revDatabaseColumnNamed

[Björnke von Gierke]

Hi

It seems i indeed stumbled over a sqlite bug. the same code does work  
fine on mysql, and the runrev team has been notified.

thanks
björnke


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  
>>>>> sql,
>>>>> without it being changed in between?
>>>
>> <snip>
>> examples omitted
>> </snip>
>>>
>>> any other ideas?
>>> Björnke
>>
>> Björnke,
>>
> ...
>>  put "INSERT INTO soundcheck (user,data) VALUES (:1,:2)" into tQuery
>>  revExecuteSQL gConnID, tQuery,"tUserID","*btBits"
>>  put revDataFromQuery(,,gConnID,"SELECT LAST_INSERT_ID()") into  
>> tRecordID
>>  put "SELECT data FROM soundcheck where snd_id = " & tRecordID into  
>> tQuery
>>  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
>
> Björnke
>
>
> -- 
>
> official ChatRev page:
> http://bjoernke.com/runrev/chatrev.php
>
> 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:
> http://lists.runrev.com/mailman/listinfo/use-revolution