Apostrophe in text variable causes SQL syntax error

Terry Judd tsj at unimelb.edu.au
Thu Sep 13 20:24:10 EDT 2007


I'm trying to poke some text into a field in a mySQL table using some simple
statements like the following...

put "INSERT INTO screens VALUES(:1,:2,:3)" into tQuery
revExecuteSQL tID, tQuery, "screenID","screenXML","screenText"

...(fields 2 and 3 are both TEXT fields) and am getting an SQL syntax error
if either of the text variables contain an apostrophe. I can escape the
character I suppose but is this behaviour normal?

Terry...




More information about the use-livecode mailing list