The best, fastest thing to try would be to remove the cfquery tag and
replace it with a cfoutput tag. That way, you can see exactly what is
happening, and what all the variables are evaluating to.
But maybe you've already done that...
Are you using PreserveSingleQuotes()?
Nat Papovich
ICQ 32676414
"If it was hard to write,"
says the Real Programmer,
"it should be hard to understand."
-----Original Message-----
From: Chad Elley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 9:19 PM
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
