|
| |
|
|
chadb
Posts: 469
From: Kansas
Status: online
 |
Hyperlink Query Value - 5/5/2008 14:24:46
I have a page that displays drw results. I have a hyperlink on one of the results that I want to hyperlink to another page that qill query on the value of the hyperlink. I have the hyperlink setup like:
<a href="jobdetail.asp?ID=<%=FP_FieldLink(fp_rs,"job")%>">
The fp_rs,"job" is the value that I want to pass on. So on the jobdetail page, I have this query that works:
fp_sQry="SELECT * FROM Item WHERE (Job = 'J065076')"
at this time the Job = 'J065076' is a static value. I want to change the 'J065076' to the hyperlink value. How can I do that?
Thanks
Chad
|
|
|
|
rdouglass
Posts: 9137
From: Biddeford, ME USA
Status: offline
|
RE: Hyperlink Query Value - 5/5/2008 15:01:03
quote:
fp_sQry="SELECT * FROM Item WHERE (Job = 'J065076')"
I thin this will work:
fp_sQry="SELECT * FROM Item WHERE (Job = '::ID::')"
Hope it helps.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
chadb
Posts: 469
From: Kansas
Status: online
|
RE: Hyperlink Query Value - 5/5/2008 15:03:55
Well, my ID field is the Primary Key, Autonumber. The job field, could span 5 - 10 ID's? That make sense?
| |
|
|
|
chadb
Posts: 469
From: Kansas
Status: online
|
RE: Hyperlink Query Value - 5/5/2008 15:15:18
Nevermind, got it. Thanks, that is what I needed.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
