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: cfquery: search numeric IN/Contains/Like i cant get the IN/CONTAINS to work on searching a numeric field. i can can get the result if the passed value is the exact Number. but if i want the subset of a number or any results with 1300 then i cant get it to work. i have googled it, every way i can think <cfquery name="ClientList_Query" dbtype="query"> SELECT * FROM ClientList_Query1 WHERE 0 = 0 <!--- Search by ClientID ---> <cfif FORM.search IS NOT ""> AND ClientID IN (#FORM.search#) </cfif> ORDER BY #DefOrder# #URL.OrderByType# </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
