UPDATE SQL-DB maker Errors

Horst baleareninsel at gmx.net
Sun Feb 4 11:42:31 EST 2007


Holá Erverybody,

I´m Using RR 2.7.4 and MySQL 4.1

I try to update an existing record with
put "UPDATE post SET Mail_body =" & Mail_text & "' where lfdnr = " &
Mail_Number into SQL_Befehl
revexecute DB_ID SQL_Befehl


Sometimes it works, sometimes not. So I found out, if the Mail_Text includes
one " or ' the datas will not be Updated.  OK, But, and that´s the question,
How to solve the problem without changing the data to base64, because that
seems to be a global problem an it makes no sense to convert all fields in
my DB. 

I'm glad, if you have a helpfull hand

thanks

Horst
-- 
View this message in context: http://www.nabble.com/UPDATE-SQL-DB-maker-Errors-tf3170373.html#a8794446
Sent from the Revolution - User mailing list archive at Nabble.com.




More information about the use-livecode mailing list