CodingForums.com - View Single Post - Select all rows of data and compare values

Old Pedant · 10-24-2012, 07:49 PM

??? You don't show any *LOOP* on the recordset, so of course you will only see one record.

You are using NightmarishStalker code (AKA the misnamed DreamWeaver) but apparently you have modified it. As bad as DrunkWalker code normally is, it would do the loop for you.

But you also say "The above code is repeated using different variables through out the page" and that tells me that your code is horribly inefficient.

Maybe if you showed some sample data from the DB table and some sample output you are trying to achieve we could toss out the DoofusWhacker code and give you something usable.

10-24-2012, 07:49 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,224 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	??? You don't show any LOOP on the recordset, so of course you will only see one record. You are using NightmarishStalker code (AKA the misnamed DreamWeaver) but apparently you have modified it. As bad as DrunkWalker code normally is, it would do the loop for you. But you also say "The above code is repeated using different variables through out the page" and that tells me that your code is horribly inefficient. Maybe if you showed some sample data from the DB table and some sample output you are trying to achieve we could toss out the DoofusWhacker code and give you something usable. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.