I have got these 2 Recordsets after querying them separately from the ASP code. Now using this ASP code I have to compare them and display either of the following results
Result: FName field in RS1 with 4 Records is matching with FName field in RS2 with 4 Records. Result: FName field in RS1 with 4 Records is not matching as there are 5 Records found in FName field in RS2. Result: FName field in RS1 with 4 Records is not matching with FName field in RS2 with 4 Records as one of the records is not matching. I hope I am making myself clear. Thanks, Mahesh --- In [EMAIL PROTECTED], "Shawn K. Hall" <[EMAIL PROTECTED]> wrote: > Hi Mahesh, > > > Is there a easy way to compare records of these 2 > > Recordsets? ...if theres a field called FName in RS1 > > that has 4 records and a field called FName in RS2 > > that also has 4 records then I want to compare them > > and see if the records are matching or not (regardless > > of the order in which they are returned). > > Are you wanting to only return records that are the same on both > recordsets, or are you wanting to return a complete listing (side by > side fields) where certain fields are equavalent, or are you wanting > to return only records that don't have an equivalent record in the > other table? > > All of these would have different implementation requirements. > > It really depends on exactly what you want. For the greatest > control, you'd probably want to return both complete recordsets as > arrays and compare the values programmatically or via XSL. The SQL > to compare them directly from the database would be dependent on > what db platform you use. > > Regards, > > Shawn K. Hall > http://ReliableAnswers.com/ > > '// ======================================================== > "There's a certain enjoyment to be gained from > humiliating your friends." > -- Guy Ritchie ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
