> Use PreserveSingleQuotes() - it doubles the apostrophies for the SQL
I'm getting confused here. I didn't think that was what
PreserveSingleQuotes() does.
I thought this function was for *keeping* the quotes the way they were and
not escaping them.
E.g. if you have a dynamically-constructed query such as "last_name =
'O'Brien'" then PreserveSingleQuotes() will ensure that CF leaves all 3
apostrophes intact.
But this would result in an invalid SQL query. So you need to use
PreserveSingleQuotes to make sure the first and third apostrophes get
through to SQL, but you need to look after doubling the second one yourself.
Is this wrong?
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
