DYNAMIC TABLE

Results 1 to 3 of 3

Thread: DYNAMIC TABLE

  1. #1
    Join Date
    Dec 1969
    Posts
    613

    Default DYNAMIC TABLE

    I&#039M TRYING TO BUILD AN ASP PAGE THAT PASSES A RECORD FROM A TABLE TO DETAIL.ASP. THE UNIQUE FIELD IN THE DBASE IS "DOCNR".<BR>WHAT SEEMS TO BE WORKING IS WHEN I SELECT A RECORD FROM THE TABLE IN RESULTS.ASP THE LINK TRIES TO OPEN DETAIL.ASP WITH THE CORRECT "DOCNR" ATTACHED(i.e.&#060;a href=DETAIL.ASP?item=&#060;%=DLRS("DOCNR")%&#062;& #062;) THIS IS WHERE I GET HOSED HOW DO I DISPLAY DATA UNIQUE TO THAT DOCNR IN DETAIL.ASP. THX FOR ANY HELP YOU MAY BE ABLE TO GIVE ME .<BR>SCOTT

  2. #2
    Join Date
    Dec 1969
    Posts
    19

    Default RE: DYNAMIC TABLE

    Put this in your Detail.asp file<BR>&#060;%<BR>Item = Request("Item")<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>sql = "SELECT * FROM YourTable where DOCNR = " & Item <BR>rs.Open sql, Application("db_conn")<BR>%&#062;<BR><BR>Then you can display all the detailed information in a Table using &#060;%=RS("Details")%&#062; and &#060;%=RS("MoreDetails")%&#062;<BR>Where Details and MoreDetails culd be any colums in your database table

  3. #3
    Join Date
    Dec 1969
    Posts
    613

    Default RE: DYNAMIC TABLE

    thx alot I will try ASaP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •