Hyperlink Query Value (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

chadb -> 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 -> 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.



chadb -> 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 -> RE: Hyperlink Query Value (5/5/2008 15:15:18)

Nevermind, got it. Thanks, that is what I needed.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.347656E-02