PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WD7.5] Inserting an image into a MySQL blob field
[WD7.5] Inserting an image into a MySQL blob field
Iniciado por David, 08,jul. 2004 21:34 - 1 respuesta
Publicado el 08,julio 2004 - 21:34
Hello!!
I'm trying to send an image to a blob field in MySQL, but for some reason i can't. here's some code:
reg = 2 // register number
gIMG= c:\"images\someimage.jpg" // image path
q = "UPDATE func SET foto = {WDBinaryMemo('"+gIMG+"')} WHERE fid = "+reg // the query
qRes = SQLExec(q, "QR1")
Instead of dumping the file to the database it only stores its path, why? Am i doing something wrong? Is missing something?
I really appreciate some help
thanks...
Publicado el 09,julio 2004 - 10:55
Hi,
if you use the navite access to mysql, you must use the memo funftions, like hlinkmemo. This works fine.
Greetings
Thilo
Hello!!
I'm trying to send an image to a blob field in MySQL, but for some reason i can't. here's some code:
reg = 2 // register number
gIMG= c:\"images\someimage.jpg" // image path
q = "UPDATE func SET foto = {WDBinaryMemo('"+gIMG+"')} WHERE fid = "+reg // the query
qRes = SQLExec(q, "QR1")
Instead of dumping the file to the database it only stores its path, why? Am i doing something wrong? Is missing something?
I really appreciate some help
thanks...