Re: passing binary data to MySQL BLOB field

'Cause you replied to the original question about using blobs! I see the dictionary entry now, missed that. Pete lcSQL Software On Thu, Mar 7, 2013 at 10:13 AM, Björnke von Gierke wrote: > Why me, and not one of the hundreds of other list-readers :P > > I've never done

Re: passing binary data to MySQL BLOB field

Why me, and not one of the hundreds of other list-readers :P I've never done arrays with binary, but the dictionary entry for revExecuteSQL says: "To pass binary data in an array element, prepend "*b" to the element's key." I Assume that means: put "I am binary!" into myArray["*bSomeKey"] reve

Re: passing binary data to MySQL BLOB field

Bjornke, How do you specify binary data if you use the an array instead of a list of variable names? Pete lcSQL Software On Tue, Mar 5, 2013 at 5:01 AM, Björnke von Gierke wrote: > Not sure why it won't work for you, but it seems that your first try had > some typo or oth

Re: passing binary data to MySQL BLOB field

Not sure why it won't work for you, but it seems that your first try had some typo or otherwise wrong code. Your copy/paste has code missing so it's hard to say what the problem is. The second error looks like you forgot some closing brackets or quotation marks, again it's hard to tell due to la

passing binary data to MySQL BLOB field

Can anyone advise what the correct syntax should be to construct a MySQL "INSERT" query that passes variables from LiveCode when one of said variables is a binary object? I am trying to construct the statement and then use it with RevExecuteSQL. I'm particularly trying to understand the LC Dicti