So weird - cannot use variable for query in CFQUERY

2004-06-25 Thread Dustin Snell [Unisyn Software, LLC]
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

RE: So weird - cannot use variable for query in CFQUERY

2004-06-25 Thread Tony Weeg
maybe its not parsing the #listGetAt# like it should? 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

RE: So weird - cannot use variable for query in CFQUERY

2004-06-25 Thread Douglas.Knudsen
- 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

Re: So weird - cannot use variable for query in CFQUERY

2004-06-25 Thread Joe Rinehart
-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

RE: So weird - cannot use variable for query in CFQUERY

2004-06-25 Thread Dustin Snell [Unisyn Software, LLC]
You were correct. Could you please explain to me how/why this happens? -Dustin _ From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 8:00 AM To: CF-Talk Subject: Re: So weird - cannot use variable for query in CFQUERY I think you've having a problem with single

Re: So weird - cannot use variable for query in CFQUERY

2004-06-25 Thread Joe Rinehart
to do so. -joe - Original Message - From: Dustin Snell [Unisyn Software, LLC] [EMAIL PROTECTED] Date: Fri, 25 Jun 2004 08:21:29 -0700 Subject: RE: So weird - cannot use variable for query in CFQUERY To: CF-Talk [EMAIL PROTECTED] You were correct. Could you please explain to me how/why