DATABASE QUESTION

[aviles22]

I HAVE A DATABASE ON MY SERVER CONTAINING INFORMATION FROM MY SUBMISSION PAGE. WHEN A VISITOR SUMITS HIS/HER CONTACT INFORMATION I HAVE NO PROBLEMS ADDING IT TO THE DATABASE.

MY PROBLEM EXISTS WHEN I TRY TO VIEW THE INFORMATION. I CAN HAVE ALL THE DATA LISTED WITH NO PROBLEM. BUT THIS WILL BE USELESS LATER ON DOWN THE LINE WHEN MY RECORDS INCREASE.
HOW CAN I GO FROM RECORD TO ANOTHER. I AM USING TEXT BOX CONTROLS BOUND TO AN ADODC DATA CONTROL. WHEN I MOVE FROM ONE RECORD TO ANOTHER THE TEXT BOXES DO NOT UPDATE.

DO I HAVE TO RELOAD THE PAGE OR WHAT ELSE!

 

[Caradog]

There are a few ways you can do this and this is one of the ways I do it.

I have 2 pages,

Page 1 displays the info

Page 2 increases a counter that moves the recordset pointer forward or backwards in the DB.

To display a new record on page 1, you can either have a link (be it a button or text link) to page 2. Page two increases the recordset pointer by using recordset.MoveNext. I then store this pointer in a session var using Session("Pointer&quot = recordset.bookmark. Page 2 then uses a response.redirect to push the web browser back to page 1.

Page one then simply opens up the database then immediately after you reset the db bookmark to, RecordSet.Bookmark = Session("Pointer&quot.

This is a dirty way of doing it but it gives you the idea.

There are better ways but it too early in the morning for my mind to work properly yet