Björnke von Gierke
bvg at mac.com
Fri Jun 5 13:22:04 CDT 2009
It seems i indeed stumbled over a sqlite bug. the same code does work
fine on mysql, and the runrev team has been notified.
On 5 Jun 2009, at 17:11, Björnke von Gierke wrote:
> On 5 Jun 2009, at 16:53, Devin Asay wrote:
>> On Jun 4, 2009, at 3:38 PM, Björnke von Gierke wrote:
>>>>> Can anyone tell me how to store and retrieve binary data using
>>>>> without it being changed in between?
>> examples omitted
>>> any other ideas?
>> put "INSERT INTO soundcheck (user,data) VALUES (:1,:2)" into tQuery
>> revExecuteSQL gConnID, tQuery,"tUserID","*btBits"
>> put revDataFromQuery(,,gConnID,"SELECT LAST_INSERT_ID()") into
>> put "SELECT data FROM soundcheck where snd_id = " & tRecordID into
>> put revQueryDatabaseBLOB(gConnID,tQuery) into tCurs
>> put empty into tRecData # declare variable to receive data
>> put revDatabaseColumnNamed(tCurs,"data","tRecData")
> Thanks Devin
> This looks exactly the same as one of the versions i tried.
> Differences are:
> you use remote mysql, i use sqlite
> you use slightly different queries
> you use revquerydatabaseBlob (but that's just an alias for the
> normal one)
> yours works, mine does'nt
> so... is this maybe a bug in the sqlite driver? I'll try my code on
> mysql this weekend...
> thanks for the info
> official ChatRev page:
> Chat with other RunRev developers:
> go stack URL "http://bjoernke.com/stacks/chatrev/chatrev1.3b3.rev"
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode