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]
