PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
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, jul., 08 2004 9:34 PM - 1 resposta
#1
Publicado em julho, 08 2004 - 9:34 PM
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...
#2
Publicado em julho, 09 2004 - 10:55 AM
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...
→ Voltar para WINDEV 2024