RE: IN condition... help?

2001-12-18 Thread Pascal Peters
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

RE: IN condition... help?

2001-12-17 Thread Bryan Love
[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 <[

RE: IN condition... help?

2001-12-17 Thread Jason Green
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

RE: IN condition... help?

2001-12-17 Thread Paul Ihrig
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

RE: IN condition... help?

2001-12-17 Thread Jason Green
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

RE: IN condition... help?

2001-12-17 Thread Paul Ihrig
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

Re: IN condition... help?

2001-12-17 Thread Jason Green
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

IN condition... help?

2001-12-17 Thread Paul Ihrig
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