All the 'PreserveSingleQuotes(SQL)' function will do it pass your string to the
database server unadulterated. If you dont use it then CF will automatically
double up on all the single quotes in your string. For example
<CFSET name = "O'Brien">
<CFQUERY>
INSERT
INTO names (thename)
VALUES ('#name#')
</CFQUERY>
This gets sent to the DB server looking like this:
INSERT
INTO names (thename)
VALUES ('O''Brien')
Automagically! Its one of the things CF does for us behind the scenes.
If you want to write the string directly you would need to double the qutoes
yourself:
<CFQUERY>
INSERT
INTO names (thename)
VALUES ('O''Brien')
</CFQUERY>
Or the SQL Server will not parse your query.
Where you would use PreserveSingleQuotes would be when you are building the
entire query text yourself outside the CFQUERY tag, e.g.:
<CFSET myQuery = "INSERT INTO names (thename) VALUES ('O''Brien')">
<CFQUERY>
#PreserveSingleQuotes(myQuery)#
</CFQUERY>
If you didnt do that, then CF would still double all your quotes, creating a
badly formatted string of SQL and possibly destroying the universe.
Make sense?
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
