Hi,
Is it possible to line up the results of seperate recordsets (in the form of 2 tables side by side) in asp without having to use SHAPE?
I'm basically selecting all dealer numbers into rst1
then i'm selecting all their related stats into rst2(which is an extremely complicated query with various correlated sub queries so need to be implemented as 2 recordsets seperately).
I've gotten as far as displaying all the data by using 2 seperate do while loops, but cannot format the data in asp/html properly - so that it all looks like its in one instead of 2 tables.
NOTE:The data in each will always correlate, so their row counts will always be the same.
Any help is so appreciated,
Mark
Is it possible to line up the results of seperate recordsets (in the form of 2 tables side by side) in asp without having to use SHAPE?
I'm basically selecting all dealer numbers into rst1
then i'm selecting all their related stats into rst2(which is an extremely complicated query with various correlated sub queries so need to be implemented as 2 recordsets seperately).
I've gotten as far as displaying all the data by using 2 seperate do while loops, but cannot format the data in asp/html properly - so that it all looks like its in one instead of 2 tables.
NOTE:The data in each will always correlate, so their row counts will always be the same.
Any help is so appreciated,
Mark