Once you run your query, then just do a <cfset myInt = listFind(yourQuery.column, value, "delimeter")>
Doug B. ----- Original Message ----- From: "Les Irvin" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Saturday, January 27, 2007 11:22 AM Subject: Re: Querying a delimited text field > I'm trying to find it using sql within a <cfquery> tag, that's why I'm > stumped. > > On 1/27/07, Jim Wright <[EMAIL PROTECTED]> wrote: > > > > Les Irvin wrote: > > > Novice question here. > > > > > > I need to write a query to find a single integer in a field of delimited > > > integers, say "23,25,27,29". How is this done in Cold > > Fusion? FindOneOf? > > > FindNoCase? Can anyone advise? > > > > > > > In CF, you would probably use ListFind...but are you trying to find this > > on the CF side, or in your database query? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
