This topic is locked

Hyperlink

10/28/2006 5:07:33 AM
ASPRunnerPro General questions
B
bburden author

Hello all,
I have a field called 8DForm which is a hyperlink field, which opens up a quey that I built to pass information from the database to the query. That all work great.
But what I was wondering is, when I click my link to open the my asp page can the RecID number be shown ont the query page automatically or can it be shown in the URL?
Please help and thanks.

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3694&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />

J
Jane 10/31/2006

Brenda,
I'm not sure that I understand you correctly.

Please give me more detailed description of what you need to achieve.

B
bburden author 10/31/2006

I am not sure I know how to explain this anymore than I have. All I want to do is be able to click on a hyperlink field in the database and open up a asp page that I have stored on my server that contains information from the database.
I was wanting the recID to display on the page I open from the link in ASPRunner.
If this is not plain enough than I will just move on to something else.
Thanks

B
bburden author 10/31/2006

Thanks for you all help, but have figure out what I needed. If requested, I will post my results.

C
claybob 11/2/2006

Thanks for you all help, but have figure out what I needed. If requested, I will post my results.


I'd like to know how you figured it out. Thanks.

B
bburden author 11/2/2006



I'd like to know how you figured it out. Thanks.



Search for this information on the _list.asp page
<%

if IsBinaryField(rs.Fields("RecID")) or Format("RecID")=FORMAT_DATABASE_FILE then

Response.Write CreateImageControl(rs, "RecID", "")

else

strData = GetData(rs.Fields("RecID"), "")
if Format("RecID")<>FORMAT_HTML then

Response.Write ProcessLargeText(strData,"picfield=" & Server.URLEncode("RecID") & "&where=" & Server.URLEncode(strImageWhere),"",MODE_LIST)

else

Response.Write strData

end if
end if

%>
AND replace it with:
<%

Response.write "<a target=blank href=http://YourServerNameHere.st.com/YourFormNameHere.asp?RecID="; &

Server.URLEncode(GetData(rs.Fields("RecID"), "")) & ">" & GetData(rs.Fields("RecID"), "") & "</a>"

%>
Of course RecID is an autonumber field in Access and is my actual field name, you will have to put yourfield name here.

Now when you see this field in ASPRunner it is now a hyperlink and when you click on the link it opens the

query page that you have previous created.