filling page with records based upon ID

Results 1 to 2 of 2

Thread: filling page with records based upon ID

  1. #1
    reardon Guest

    Default filling page with records based upon ID

    sorry about my vagueness but Im new to asp!<BR>Im developing a little site where you can do a search. The results show some basic records witha hyperlink to full record.<BR>However, I cannot work out how to output the record from the link eg description.asp?ID=1 will output only &#039;1&#039; - the other information I can&#039;t get to show. I haven&#039;t been able to find any code snippets on any of the site&#039;s that do this and am completely stuck as to how to do this basic and fundamental page. Can someone point me in the right direction or pass on some sample code please?<BR>

  2. #2 Guest

    Default RE: filling page with records based upon ID

    on the asp page you do something like this:<BR>&#060;%<BR>SQLCMD="Select * from Yourtable where ID = " & CInt(Request.QueryString("ID")) & ";"<BR><BR>set rs=objConn.Execute(SQLCMD)<BR>for each fld in Rs.Fields<BR>&nbsp;&nbsp;&nbsp;&nbsp;Response.Writ e Fld.Name & ": " & fld.value<BR>Next<BR>%&#062;<BR><BR>objConn is a connection you would have openned tothe database.

Posting Permissions

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