Doug, I don't think that will work unless listFind is an access function, and I do not believe it is.
Dave -----Original Message----- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 12:31 PM To: CF-Talk Subject: Re: Querying a delimited text field <CFQUERY NAME="names" DATASOURCE="#DB_redwood#"> SELECT distinct lname, fname, artist_id FROM photos, photographers WHERE listfind(themes.id, photos.theme_id) <> 0 and photographers.id = photos.artist_id order by lname </CFQUERY> Doug B. ----- Original Message ----- From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Saturday, January 27, 2007 11:26 AM Subject: Re: Querying a delimited text field > 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:267842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
