<cfquery name="getdomaindupes" datasource="#datasource#">
#preserveSingleQuotes(myquery)#
</CFQUERY>
-joe
----- Original Message -----
From: Dustin Snell [Unisyn Software, LLC] <[EMAIL PROTECTED]>
Date: Fri, 25 Jun 2004 07:53:16 -0700
Subject: So weird - cannot use variable for query in CFQUERY
To: CF-Talk <[EMAIL PROTECTED]>
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]
