[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 8:29 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Simple Query Question
Depend on what the data type of the field you are calling from the table
]
Subject: Re: [KCFusion] Simple Query Question
Try IN ( ' #PreserveSingleQuotes(hlist)# ' )
-Ben Price
Chris Holdman writes:
I am having a problem with the
cfset hlist = replace(form.value2, , , ',' , all)
Statementfor some reason it is converting the ' to when I insert
it in my
This should do the trick
cfloop from=3D1 to=3D#listLen(form.value2)# index=3Di
field2=3D'#listGetAt(form.value2,i)#' cfif i lt listLen()OR/cfif
/cfloop
Or
cfset locList2OR =3D field2=3D' replace(form.value2,,,' OR =
field2=3D' '
cfquery name=3Dquery
You could add a boolean variable and then use it to
check to see if it's the first time through, if it is
don't use the OR, otherwise add the OR before you add
the next variable.
Might be able to use the IN clause as well instead of
hte OR.
cfset firsttime='True'
cfquery name=query
yeah, they are right, the 'IN' statement is the way to go
geez, what the heck was i thinkin? ;P
-Original Message-
From: Justin Hansen
Sent: Thursday, March 13, 2003 4:24 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Simple Query Question
oops.. correction, i dont know how all