UPDATE table and quote in a text

Horst baleareninsel at gmx.net
Sun Feb 17 10:09:14 CST 2008


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
 

Mark Schonewille-3 wrote:
> 
> Dear Horst,
> 
> Single quotes should be escaped the way you do and this should work  
> fine. I have seen reports of commands starting with revdb being  
> unable to escape single quotes, but this can be solved by using  
> revExecuteSQL -- I don't know whether there really is a bug with  
> escaping characters, I didn't encounter this problem myself. Make  
> sure that you only replace single quotes that are part of the data  
> and not the two single quotes that surround the string.
> 
> 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 13:24 heeft Horst het volgende geschreven:
> 
>>
>> Hi there,
>>
>> A  question to all SQL-Masters:
>> To update a record in a SQL-Table and to store text which includes  
>> the "
>> sign in an SQL-Syntax I learnd, that it is necessary to use
>>
>> replace quote with "\" & quote in zText
>> Well, that works fine, but what about The ' sign?
>>
>> replace "'" with "\'" in zText
>> seems NOT to work.
>>
>> Thanks a lot to all of you and best regards
>>
>> Horst
>> -- 
>> View this message in context: http://www.nabble.com/UPDATE-table- 
>> and-quote-in-a-text-tp15529083p15529083.html
>> Sent from the Revolution - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> 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
> 
> _______________________________________________
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15530593.html
Sent from the Revolution - User mailing list archive at Nabble.com.




More information about the use-livecode mailing list