RE: cfquery: search numeric IN/Contains/Like

2006-08-21 Thread Snake
What is the value of #FORM.search# It must be at least 1 number, or a comma dleimited list of numbers. Contains requires full-text search and is for text fields. Snake -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: 21 August 2006 21:34 To: CF-Talk Subject:

RE: cfquery: search numeric IN/Contains/Like

2006-08-21 Thread Ben Nadel
Paul, I am not sure if you want to get the subset to match in the DB or in the CF variable??? You could always loop over the WHERE items. SELECT * FROM [table] WHERE 1 = 0 cfloop index=i list=#FORM.search# OR CAST( ClientID AS VARCHAR(12)) LIKE

Re: cfquery: search numeric IN/Contains/Like

2006-08-21 Thread Paul Ihrig
the search field could be a first name, id date, whatever. i am doing the 0=0 to return all records if nothing is passed. then will check to see if it numeric, if it is they will be looking up an ID. if there is a similar id, return that set.. say our ids have 123456789 charecters. i just want to

Re: cfquery: search numeric IN/Contains/Like

2006-08-21 Thread Paul Ihrig
thanks Ben will try those examples in the mornning. On 8/21/06, Ben Nadel [EMAIL PROTECTED] wrote: Paul, I am not sure if you want to get the subset to match in the DB or in the CF variable??? You could always loop over the WHERE items. SELECT * FROM [table] WHERE