UPDATE table and quote in a text

[Horst]

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
> 
> 

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