UPDATE table and quote in a text

Mark Schonewille m.schonewille at economy-x-talk.com
Sun Feb 17 07:45:28 EST 2008


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




More information about the use-livecode mailing list