mstuart at adaptcrm.com
Thu Jun 4 14:41:24 CDT 2009
Written by Björnke von Gierke on Thu Jun 4, 2009 - 09:32 AM CDT
Can anyone tell me how to store and retrieve binary data using sql,
without it being changed in between?
Check out the Rev Dictionary for revDatafromQuery:
put the text of image "MyImage" into tImageData
get revDataFromQuery(, , myID, "SELECT size FROM images WHERE imagedata = :1", "*btImageData")
You can also use the name of a numerically indexed array, instead of a list of variable names. In this case, the elements of the array are substituted for the corresponding placeholders. To pass binary data in an array element, prepend "*b" to the element's value.
put "*b" & the text of image "MyImage" into tImageDataArray
get revDataFromQuery(, , myId, "SELECT size FROM images WHERE imagedata = :1", "tImageDataArray")
Email has been scanned for viruses by Altman Technologies' email management service - www.altman.co.uk/emailsystems
More information about the use-livecode