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]
