Mahesh Mohite wrote: >I was able to achive result 2 earlier before posting. However, for the >other results I was facing problem in comparing > >RS1: >FName (Field Name) >Tom >Dick >Harry >Nancy >Bob > >RS2: >FName (Field Name) >Jack >Dick >Bob >Jill >Harry > >Both have same # of records but values are different. And what would >be the solution in case of multiple fields? > > Well, in the SQL statement, you need to ORDER BY FName ASC, so that the two recordsets will be in the same order. Then, you need to put each recordset into an arry (use getrows). Then it's just a case of comparing the first row in the first array with the first row in the second array. They're only text fields, aren't they, so just TRIM them and test to see if they are equal.
Cheers, manzo ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
