Mahesh Mohite wrote: >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 > >1) Result: FName field in RS1 with 4 Records is matching with FName >field in RS2 with 4 Records. > >2) Result: FName field in RS1 with 4 Records is not matching as there >are 5 Records found in FName field in RS2. > >3) 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. > > The order to process them in is 2, 3, 1 (I added numbers to the results above). As Shawn said, put both recordsets into separate arrays. Get the upper Boundary for each (UBound), compare them. If they are different, then you have result 2. If the data passes that test, you're just going to have to compare each pair of rows to see if they are the same (so make sure that you use the ORDER BY clause of the SQL statement to ensure that if you do have two matching recordsets, the data is in the same order for both of them). If this test is falied, you have result 3, otherwise you have result 1.
I hope that this is clear. manzo ------------------------ 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/
