How to write detailed information page?

[longmatch]

Dear all:
Right now I have a summary page using query with catory and procedure number in each category. Do you think it is possible for me to use a link in each category, in order for me to see the detail procedures in each category when I click the category links (using another query)?

Thanks

Haijun

 

[TonyU]

[tt]
Most definitely!

I'm going to assume that the recordset name on your sumamry page is named rsSummary

Click on the field where you want the link to be and add this link to it
Details.asp?ID=<%=rsSummary(&quot;ID&quot%>

Then on your Details page simply select * where id = the querystring(&quot;id&quot you're passing on the url

Make sense?

[tt]&quot;A Successful man is one who can build
a firm foundation with the bricks
that others throw at him&quot;
[/tt]

​

 

[longmatch]

I got your idea. It is true that rsSummary is my recordset name. this recordset is from query using a username. That means rsSummary is user specific. I need to write a details.asp page to get the detail procedure information. The ID=<%=rsSummary(&quot;ID&quot should be category name. But my query should also include the username. How can I pass the username into the details.asp page? If you can not see what I means. You can see the diagram.

My database - query based upon a username for category name and procedures numbers in this category - see detailed procedures in each category when clicking the category name.

I am hoping I state my question right.

Thanks and have a good weekend.

Haijun

 

[TonyU]

[tt][COLOR=#3366]
Simply replace <%=rsSummary(&quot;id&quot%> with
<%=rsSummary(&quot;username&quot%>
then
on your details page, your sql should read something like
select * from table where username = request.querystring(&quot;username&quot...

[tt]&quot;A Successful man is one who can build
a firm foundation with the bricks
that others throw at him&quot;
[/tt]

​

 

[TonyU]

[tt] just pass to the url whatever field you need to pass.

[tt]&quot;A Successful man is one who can build
a firm foundation with the bricks
that others throw at him&quot;
[/tt]

​