Dynamic Expand/Collapse detail table

[jcale4]

Hello!

There is a short tutorial on MSDN -

http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/howto/creatingtoc.asp

Is there any way to do this with a table? In other words, I have several thousand rows that i'm pulling from a database. I want to show/hide details beneath each grouping. So, a user can click "Account", then the table expands to show the details of the account.

Thanks!

 

[dtqbterror]

You can use ADO Shaped recordsets to do this. This allows you to get all of the necessary data in one trip to the database. You can then loop thru the recordset and subsets and use <div> tags to create the effect you are after.

http://www.chiefscoalition.com

 

[jcale4]

dtqbterror, (and fellow chiefs fan, (they sure laid it down yesterday didnt they?))...

I like the sound of that, unfortunetely I'm not sure what an ADO Shaped recordset is.

Thanks!

 

[dtqbterror]

http://www.serverwatch.com/tutorials/article.php/1549801

http://www.chiefscoalition.com

 

[dtqbterror]

http://freevbcode.com/ShowCode.asp?ID=1150

http://www.chiefscoalition.com

 

[dtqbterror]

My wife and I have Season Tickets so we are huge Chiefs fans and yes it was a good game last 5 minutes had me pacing the floor.

http://www.chiefscoalition.com

 

[jcale4]

This is excellent. However, ADO shaping apears to be a way to create hierarchical recordsets by joining tables on related data. I am pulling data from 1 data source which looks like this:

ACCOUNT------NAME-----------SALES---------ITEM
1324---------ACCOUNT1-------1024.00-------FIRSTITEM
1324---------ACCOUNT1-------8432.03-------SECONDITEM
8338---------ACCOUNT2-------20204.20------FIRSTITEM
2309---------ACCOUNT3-------39392.04------FIRSTITEM
2309---------ACCOUNT3-------83.34---------SECONDITEM
2309---------ACCOUNT3-------392.00--------THIRDITEM

..you get the point

So, I dont have a need to relate recordset tables by parent or children since i just select the recordset, then while looping, only show the account if it is different than the previous records account value. I'm not sure how to do this using <div>'s. Can i still use the Shape option with this sort of data source?

Thanks!

 

[dtqbterror]

Sure use a select distinct query to get a single record for each account and then use another query that selects the line item data using the accout number as your selection criteria.

http://www.chiefscoalition.com