UPDATE table and quote in a text

viktoras didziulis viktoras at ekoinf.net
Mon Feb 18 06:45:33 CST 2008


in sqlite ' should be escaped with '' (e.g. ' and ') that's it...
Viktoras

Horst wrote:
> Holá Mark,
>
> ik wil u danken. 
>
> I know, the easiest way would be to encode the data with base64encode. But
> there must also be a way to  save a text f.e. like 1234'5'6öä'ioup"# in a
> varchar or text type. With base64encode it will f.e. not be possible to use
> the "fulltext" indexing, which I will need. No, there must be another way.
> SQL is not that silly and I learned, that RR is a a powerfull tool, if you
> (or someone else) knows the "tricks". Once again the question: How to save
> any text via RR to a SQL-Table as described before.
>
> best regards
>
> Horst
>
>
>
>
> Mark Schonewille-3 wrote:
>   
>> Hallo Horst,
>>
>> You could write a function to escape all special characters, but the  
>> easiest and most reliable way is to encode the data with base64encode 
>> () before storing it.
>>
>> Best regards,
>>
>> Mark Schonewille
>>
>> --
>>
>> Economy-x-Talk Consulting and Software Engineering
>> http://economy-x-talk.com
>> http://www.salery.biz
>>
>> Convert colours between different colour spaces with Color Converter.  
>> Download at http://economy-x-talk.com/cc.html
>>
>>
>>
>> Op 17-feb-2008, om 17:09 heeft Horst het volgende geschreven:
>>
>>     
>>> Holá Mark,
>>>
>>> The main question seems to be: How to "include" a textfile for  
>>> example:
>>> ..
>>> put "1234'5'6öä'ioup"#" into mytext ## I know, this text is  
>>> senseless, but
>>> never mind, it should be able to be saved
>>> replace quote with "\" & quote in mytext ## and then, how to  
>>> replave the '
>>> ???
>>> put "UPDATE table set textfile = '" & mytext & "'... into sql_messqage
>>> revexecutesql (my_ID), sql_message
>>> put the result  ## shows an SQL-Error message and mytext will not  
>>> be saved
>>> ..
>>>
>>> best regards and, as usual, a big thank You for answering
>>>
>>> Horst
>>>
>>>       
>> _______________________________________________
>> 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
>>
>>
>>     
>
>   




More information about the use-livecode mailing list