<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:267840
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
