I can't get to the query .. it's in the custom tag, which is encrypted, so
WHERE is not an option. What the query returns is a recordset which I can
reference like .. #recordset_name.field_name# just like any other query.
What I want to do is futher refine the recordset and remove all of the rows
that don't have anything to do with what I want to show.
Example: I have a tag that pulls some news headlines in certain categories
and then creates links to the full article. Say I chose the 'Entertainment'
category. The tag returns all entertainment related news, including movies,
music, etc. Well, say I only want to show things related to music and not
the movies. How do I only display those headlines containing info about the
music? I suppose I could do a <cfif> every time I get ready to display a
row and check to see if it contains the words I am looking for, but then I
would have to loop through a bunch of rows I don't care about and apply
<cfswitch> statement. I figure there is a more efficient way. I would
really like to avoid a big <cfswitch> statement in the middle of a loop,
just to filter out a few rows.
Todd
----- Original Message -----
From: David Shadovitz <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 04, 2000 4:35 PM
Subject: Re: Querying a recordset ...
> Todd,
>
> It's not clear whether you want to filter out rows or columns, nor
> whether you can modify the custom tag.
>
> If you want to filter out rows, add to your SQL statement's "where"
> clause.
>
> If you want to filter out columns:
> If the keywords correspond to column names, only output those columns
> whose name contains a keyword.
> If the keywords correspond to data, you'd evaluate each column and check
> whether it contains a keyword.
>
> Please provide more information!
>
> -David
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
