asp pages for db

[hotski]

I have a database with 4 tables One for agent info and 3 for property info.
I have linked the agent table to the property tables.
I need to setup a link for the agents. If I have an agent and they click on see my property, Do I have to have a page for each agent or can it be done with one page?

 

[Sergeant]

You can append the Agent's ID to the link URL, like:
http://MySite/Properties/MyProperties.asp?agentID=2

Then in the MyProperties.asp page, you use Request.QueryString("agentID") in conjunction with the SQL string.

"SELECT * FROM PROPERTIES WHERE agentID = " & Request.QueryString("agentID")

Is this what you were asking?

 

[hotski]

problem

OK I think I have you setup.. So If I create a page with all the elements in it I want to show..Then when the link is click on for that agent It will show all the elements for that agent.. and Only one page will need to be created..??

P.