Find a specific record and display it on a page (ASP, JSP)
You can add a server behavior that finds a
specific record in a recordset so that you can display the record
data on the page. The server behavior is only available when using
the ASP or JSP server models.
Create a page that has the following prerequisites:
A record ID contained in a URL parameter passed
by another page to the current page. You can create URL parameters
on the other page with HTML hyperlinks or with an HTML form. For
more information, see Collecting data submitted by users.
Recordset columns bound to the page. The specific record
must be displayed on the page. For more information, see Make text dynamic.
Add the server behavior to find the record specified
by the URL parameter by clicking the Plus (+) button on the Server
Behaviors panel (Window > Server Behaviors) and selecting Recordset
Paging > Move to Specific Record.
In the Move To Record In pop‑up menu, select the recordset
you defined for the page.
In the Where Column pop‑up menu, select the column that
contains the value passed by the other page.
For example, if the other page passes a record ID number,
select the column containing record ID numbers.
In the Matches URL Parameter box, enter the name of the
URL parameter passed by the other page.
For example, if the URL the other page used to open the
detail page is id=43, enterid in
the Matches URL Parameter box.
Click OK.
The next time the page is requested by a browser, the server
behavior will read the record ID in the URL parameter passed by
the other page and move to the specified record in the recordset.