This topic is locked

Asprunner 4.1

11/23/2006 3:40:25 PM
ASPRunnerPro General questions
L
luic author

How can I create a hyperlink in the edit page to link to a list page of another table with the same key value in the edit page ?
Thanks.

J
Jane 11/24/2006

Chris,
you can do it using event.

Here is a sample cod for the EditOnLoad event.

Sub EditOnLoad()

str = "select * from "&strTableName&" where "&where

Set rsTemp = server.CreateObject("ADODB.Recordset")

rsTemp.open str, dbConnection
Response.Write "<a href=""TableName_view.php?editid1="&rsTemp("FieldName")&""">view</a>"
End Sub



where Fieldname is your actual field name where key value is stored.

C
clig 11/26/2006

How can I create a hyperlink in the edit page to link to a list page of another table with the same key value in the edit page ?

Thanks.


You could also set the field to "Hyperlink" then set URL Prefix to whatever the string is that you tested to search for the particular criteria...
eg)

DIALUP1_list.asp?TargetPageNumber=1&action=Search&lang=&orderby=&dir=&PageSize=20&masterkey=&SearchField=Project&SearchOption=Contains&SearchFor=