> Any SQL Server 7 gurus out there that know how to allow
> apostrophe's in SQL
> statements? For example, last_name = 'O'Brien' chokes the query.
last_name = 'O''Brien'
By the way, CF does this automatically in cfquery:
<cfset lname = "O'Brien">
<cfquery>
....
last_name = '#lname#'
...
</cfquery>
- Sean
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sean Daniels
Manager, Engineering
Marketplace Technologies
[EMAIL PROTECTED]
tel: 207.439.6030
cel: 978.764.0799
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.dealstream.com
http://www.mergernetwork.com
http://www.dealforce.com
------------------------------------------------------------------------------
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.
