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 > 1 = 0 > > <cfloop index="i" list="#FORM.search#"> > OR > CAST( ClientID AS VARCHAR(12)) LIKE '%i%' > </cfloop> > > > The above will match PART of the search form in the FULL id in the > database. > I guess you might be able to go the other way as well: > > > SELECT > * > FROM > [table] > WHERE > 1 = 0 > > <cfloop index="i" list="#FORM.search#"> > OR > 'i' LIKE '%' + CAST( ClientID AS VARCHAR(12)) + '%' > </cfloop> > > > This will match part of the database ID in the search form... > > > I have NOT tested this... But maybe It can give you some ideas. > > > ....................... > Ben Nadel > www.bennadel.com > > > -----Original Message----- > From: Paul Ihrig [mailto:[EMAIL PROTECTED] > Sent: Monday, August 21, 2006 4:34 PM > 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:250520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4