tw
-----Original Message-----
From: Dustin Snell [Unisyn Software, LLC] [mailto:[EMAIL PROTECTED]
Sent: Friday, June 25, 2004 10:53 AM
To: CF-Talk
Subject: So weird - cannot use variable for query in CFQUERY
Using CF MX 6.1 with MSSQL 2000 on Windows 2003 Server
Regardless of the query used the following code gives me an
"Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax "
error:
<cfset myquery="select Count(*) as thecount from cdomains where
thedomain='#ListGetAt(getcustomer.email,2,"@")#';">
<cfoutput>#myquery#</cfoutput>
<cfquery name="getdomaindupes"
datasource="#datasource#">#myquery#</CFQUERY>
However it works if I don't use a variable and instead literally put the
same query inside the query block:
<cfquery name="getdomaindupes" datasource="#datasource#">
select Count(*) as thecount from cdomains where
thedomain='#ListGetAt(getcustomer.email,2,"@")#';</CFQUERY>
I have been working on this for hours and can't figure it out. I know I have
stored my queries in variables before but it won't work in this case.
Anyone ever seen this?
-Dustin Snell
Unisyn Software, LLC
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
