revDatabaseColumnNamed

[Mark Stuart]

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?
thanks
Björnke
<<<

Hi Björnke,

Check out the Rev Dictionary for revDatafromQuery:
====
local tImageData
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.

local tImageDataArray
put "*b" & the text of image "MyImage" into tImageDataArray[1]
get revDataFromQuery(, , myId, "SELECT size FROM images WHERE imagedata = :1", "tImageDataArray")
====

HTH u,
Mark Stuart
Email has been scanned for viruses by Altman Technologies' email management service - www.altman.co.uk/emailsystems