V4MD : new question SQL insert into picture

[Martin Kloss]

At 07:00 29.10.2003, you wrote:
>mySql = "UPDATE rdInventory SET fd_Image=:1 WHERE fd_Code=:2"
>myValues = "[" & member( fd_Code,2 )
>myValues2 = "," & fd_Code & "]"
>db.SqlExecute(mySql, myValues & myValues2)

Hi Ricky,

you need to use a Lingo list for binding, not a string
that looks like a list:

mySql = "UPDATE rdInventory SET fd_Image=:1 WHERE fd_Code=:2"
myValues = [member( fd_Code,2 ), fd_Code]
db.SqlExecute(mySql, myValues)

That should do the trick.
Oh wait, I think binding for conditions is not supported yet,
so the "WHERE fd_Code=:2" is not possible, or is it Ruslan?

Martin.


Martin Kloss

Need music? http://www.selling-sound.com

Like the author? Buy the book at:
http://www.amazon.de/exec/obidos/ASIN/3898422194/lingmmugd

Get your daily dose of Lingo at the LingoPark:
http://www.lingopark.de