I have two data sources defined on my page. The first is just a list of all items. ( A, B, C, D). The second data source is created after making a selection from the first. It will capture all information about that item. Here's the code snippet:
"select * from items where item = '" . pageParameter("item","-1") . "'",
Everything is working fine on the page but now I would like to clean it up a bit. Currently on the page I have a table set up for the second data source. When the page loads, it will show what I'm using as descriptors (i.e. Item, Description, Part#) and the actual data values are not displayed. Of course they will not be displayed until you choose an item from the first data source.
My question is, can I default it to always display the first record in the table until an item is selected from the other list? I tried to do some coding but since the page refreshes after making a selection, my variable will always set itself on loading.
Not sure if this is even possible?
Hope I didn't confuse anyone with my description. Let me know if you need more information.
Thx,
Jim:bemused:
