I don't think you have any choice. _Something_ has to loop through all the rows
of the query and make a decision on what to include/exclude. If you find (or
write) another custom tag to do this, it may actually end up being less
effecient (even if cleaner looking in your CF templates). You've got the
original query, a loop through every record to do the filtering, then another
loop through the records to display what's left. Currently you have just the
original query and your display loop which does the filtering.
Jim
-----Original Message-----
From: Todd Ashworth <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, June 04, 2000 3:58 PM
Subject: Re: Querying a recordset ...
>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.
