I think it's a good idea to URLencode all text data before storing.
Not only does this solve character problems but also allows a
multiline text field to go onto a single line, so a record can go
onto one line for processing, making records easy to access.
On Sep 13, 2007, at 5:24 PM, Terry Judd wrote:
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
_______________________________________________
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
