Thanks for everyones assistance. Dan, however, provided the solution I was looking for. Please see below.
Arun. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: April 18, 2002 3:44 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] How do I filter matching records? Would this query give you the results you need? <cfquery name="checkCategory" datasource="DB" MAXROWS="#MaxRows#"> SELECT table1.*, table2.* FROM table1, table2 WHERE table1.category LIKE '%#category#%' AND table2.category LIKE '%#category#%' AND table2.Reviews <> #checkReviewCount# and table2.Reviews <> table2.CheckReviewCount -- <=== my addition </cfquery> If not, how about this sort of thing from the original query? <cfoutput query = checkCategory> <cfif reviews neq reviewcount> output stuff </cfif> </cfquery> ********************** The values for #category#, #ReviewCount# and #reviews# are being passed from a previous page. <cfoutput> <CFSET MAXROWS = #reviews#> <CFSET checkReviewCount = #ReviewCount#> </cfoutput> <cfquery name="checkCategory" datasource="DB" MAXROWS="#MaxRows#"> SELECT table1.*, table2.* FROM table1, table2 WHERE table1.category LIKE '%#category#%' AND table2.category LIKE '%#category#%' AND table2.Reviews <> #checkReviewCount# </cfquery> >From the above Query, I'm trying to Output only the records that have the same category from two tables. Of these records, from TABLE2 I want only the ones where the "Reviews" DO NOT EQUAL the "checkReviewCount". For example: If MaxRows = 3 TABLE2:COLUMN1 CheckID (autonumber) 1 2 3 TABLE2:COLUMN2 Reviews (int) 4 2 7 TABLE2:COLUMN3 checkReviewCount (int) 4 0 0 TABLE2:COLUMN4 category (text) dogs dogs dogs Only 2 records should be returned, since the number 4 occurs in both the "Reviews" and "checkReviewCount" Columns. Do I have to loop the query to get a value for each occurance of #checkReviewCount#. If so, how do I accomplish this? Thank You. Arun - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Arun Persaud" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
