I've got some code running which SHOULD work, but isn't, and is confusing
the hell out of me
Here's the code;
select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
and #PreserveSingleQuotes(variables.whereList)#
order by
alk <[EMAIL PROTECTED]>
Subject: Query confusion - CF not recognising query name
Date: Mon, 08 Jan 2001 18:49:07 -
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id
MHotMailBC235737002ED82197E8CF1F7A8C1FA567; Mon Jan 08 11:06:20 2001
Received: from houseoffusion.com ([2
ED]]
> Sent: Monday, January 08, 2001 13:17
> To: CF-Talk
> Subject: Re: Query confusion - CF not recognising query name
>
>
> here's a real silly question but is
>
> written exactly like
>
> this or is it written like
>
> leaving the # off
> could be
-Talk
Subject: Query confusion - CF not recognising query name
I've got some code running which SHOULD work, but isn't, and is confusing
the hell out of me
Here's the code;
select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
I just took out the and #PreserveSingleQuotes(variables.whereList)# ---
set some variables and it worked fine for me. What's in the wherelist??
It ran fine for me. cf 4.01 on Windows 2000 server.
Jeff Craig
select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#
] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 3:02 PM
> To: CF-Talk
> Subject: Re: Query confusion - CF not recognising query name
>
>
> I just took out the and
> #PreserveSingleQuotes(variables.whereList)# ---
> set some variables and it worked fine fo
s actually being executed and how many rows it
returns.
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 10:49 AM
To: CF-Talk
Subject: Query confusion - CF not recognising query name
I've got some code running which SHOULD work, b
Replies to all included;
> here's a real silly question but is
>
> written exactly like
>
> this or is it written like
>
> leaving the # off
> could be your problem.
You are kidding, right? CF hasn't required the # within CFSET since v2
> Have you run the query in a query analyzer? If so, do
Why not put debugging on for your IP only???
>I can't put debugging on as it's a production server - I don't
>have the data
>on my test machine to use, and the amount of data is huge to download
>
>As I said - it's confusing the hell out of me.
>
>Philip Arnold
Also you chould RUN SQLtrace to
Phillip,
A couple of suggestions. I use debugging on a production servers all the
time. If you have access to the CF Admin, I turn on debugging for my IP
address. Since I'm on dial-up and my ISP drops my connection all the time. I
have to change IP addresses that the debug shows on about every hal
> Why not put debugging on for your IP only???
D'OH - forgot you could do that...
> Also you chould RUN SQLtrace to see whats going on. These kind of issues
> Usually are a result of silly mistakes. I know mind are. Get someone else
> there to look at the code, might pick it up staight away.
> A couple of suggestions. I use debugging on a production servers all the
> time. If you have access to the CF Admin, I turn on debugging for my IP
> address. Since I'm on dial-up and my ISP drops my connection all
> the time. I
> have to change IP addresses that the debug shows on about every ha
12 matches
Mail list logo