Actually, There is a function that is intended for this kind of
situations:
ListQualify(listVar,"'")
Pascal
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: maandag 17 december 2001 23:23
To: CF-Talk
Subject: RE: IN condition... help?
no need to
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 17, 2001 1:22 PM
To: CF-Talk
Subject: RE: IN condition... help?
then you need to loop through each one in the IN statment and put ' ' around
each item
WHERE item IN ('#i#',)
try that.
>From: Paul Ihrig <[
ut i can't think of how to do it
now.
>From: Paul Ihrig <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: IN condition... help?
>Date: Mon, 17 Dec 2001 16:36:35 -0500
>
>right on!
>Thank you Jason!
>
>Now
right on!
Thank you Jason!
Now, is that something simple that i have should always have known?
i have read WACK 3 or so times. & paged through aWACK a few times.
Where do you learn these types of things???
i have been using CF aggressively for almost 3 years now & still there are
days, such as
then you need to loop through each one in the IN statment and put ' ' around
each item
WHERE item IN ('#i#',)
try that.
>From: Paul Ihrig <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: IN conditi
is #rs_View.Project_Type_ID2# a coma list of numbers? if so, try not adding
the ' around it in the IN statment
no, it is text
like (0264,0039 SF,0258,0257)
i have tried
IS, LIKE, IN
any other ideas.
thanks
L PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: IN condition... help?
>Date: Mon, 17 Dec 2001 15:56:29 -0500
>
>ok
>i must be missing something, so if you can see the problem i would
>appreciate it
>i am not able to view the out put
ok
i must be missing something, so if you can see the problem i would
appreciate it
i am not able to view the out put of a cfloop query, but can see the ids
output?
SELECT Profile_Code2, Profile_Name2 FROM tbl_Profile_Codes_2
WHERE Profile_Code2 IN ('#rs_View.Project_Type_ID2#')
#rs_pc2.Profil
8 matches
Mail list logo