Apostrophe in text variable causes SQL syntax error

[Josh Mellicker]

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