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... _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
