Chad-
Make sure you are using the PreserveSingleQuotes function around any string
value. ColdFusion will convert your single quotes to double quotes unless
you specify otherwise, and this can throw SQL Server off.
Norman Elton
Information Technology
College of William & Mary
-----Original Message-----
From: Chad Elley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 12:19 AM
To: CF-Talk
Subject: Running a Dynamically Created Query
I have set up a series of Cold Fusion templates that build a dynamic SQL
statement. I have run into a "stump in the road" as a result. The SQL
statement consists almost entirely of variables equaling an integer, but
when I have a variable equal to a string, I get errors. For example, when I
attempt to drop a value enclosed in single quotes (i.e. city = 'Atlanta'), I
get errors.
Here is the problem though... We can copy the code into SQL server 2K and
it runs perfectly, but when it executes it through Cold Fusion passing it
into SQL server, it bombs out.
Any suggestions?
Thanks,
Chad Elley
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
