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
PerserveSingleQuotes() perhaps? cfquery name=getdomaindupes datasource=#datasource##PreserveSingleQuotes(myquery)#/CFQUERY Doug -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 -

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

2004-06-25 Thread Joe Rinehart
I think you've having a problem with single quotes being escapedtry: 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

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