question about dril downs in asp

Dev Shed Forums Sponsor:

Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!

September 29th, 2003, 08:51 AM

DaGr8Anil

Junior Member

Join Date: Sep 2003

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

question about dril downs in asp

Hi. I am creating a asp script that pulls records of an oracle database and displaying it as a table on an asp page. however what I want to do is display the records as links. for example.

record 1

(if record one is clicked)

record 1
information of another record from database 1
information another record from database 2
etc.

(and if record 1 is clicked again)

record 1

i really jus started learning asp and if anyone knows how to do that without any issues with client and server sides. i be very grateful. thank you

Attached Files

dwpl_crit_agg.asp (10.1 KB, 182 views)

September 29th, 2003, 11:36 AM

don_sparko

Digitally Challenged

Join Date: May 2003

Posts: 280

Time spent in forums: 54 m 14 sec
Reputation Power: 6

you could build your sql statement to reflect a link such as

Code:

select '<a href=""displayrecord.asp?id='+record_id+'"">Record '+record_id+'</a>' as recordopener from table_name

then you just create an asp page called displayrecord.asp and have it query your db based on the request.querystring("id")

__________________
My brain cells are like a storm trooper's armor: useless

September 29th, 2003, 08:55 PM

pda8333

Contributing User

Join Date: Sep 2003

Posts: 216

Time spent in forums: 8 h 6 m 31 sec
Reputation Power: 5

Hi DaGr8Anil,

upon clicking on 'record 1', you want to show another info below it, and upon clicking back 'record 1', that info will disappear? to my understanding, is this correct? if yes, then try this code.

This code only shows you how to display & hide your records upon clicking.

Hope this helps you.

Code:

<body>
:
:
<script language=javascript>  
    
    function ExpandCollapse(my) {
       var my_id = my;
       var summary = my + "show";
  
  	innerTextvar = my_id.innerText;
       if (document.all[summary].style.display != "block") {
           document.all[summary].style.display = "block";
       }
       else {
            document.all[summary].style.display = "none";
       }
    }
 </script>

<a onclick='javascript:ExpandCollapse("rec1")' id="rec1" TITLE="Show Summary" style="cursor:hand">
<font color='#000000'><B>Record 1</B></font><br>
        
<div class="clsSummary" id="rec1show" style="display:none;">
 <table>
   <tr>
     <td>info of another record from database 1</td>
  </tr>
  <tr>
     <td>info of another record from database 2</td>
   </tr>
 </table>
</div>
:
:
</body>

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > question about dril downs in asp

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump