Session Link Issue

[anon007]

Here is my delima, I have a page lets say page one and on page one I have a list of accounts with an update accounts link on it going to the update_account.asp page where an sql statment runs to open the record with the right information. How can I create a session needed, or how do I code it to that the link provides the info for the update page so the right record is opened?

Any direction would be great

 

[Sheco]

How about putting the record's unique ID on the QueryString for each link?

So that the browser receives something like this:[tt]
<a href="update_account.asp?ID=1">Account One</a>
<br>
<a href="update_account.asp?ID=2">Account Two</a>
<br?
<a href="update_account.asp?ID=3">Account Three</a>
[/tt]

 

[anon007]

thant sounds good let me try it. Thanks

 

[anon007]

OK I have the string in place now when it opens the asp page how do I get the statement recnize the ID.

This is on the update page to open the record.

sql = "SELECT * FROM [Accounts] WHERE [Accounts].[AccountID]=" &Trim("ID")

 

[gmmastros]

sql = "SELECT * FROM [Accounts] WHERE [Accounts].[AccountID]=" & [!]Response.QueryString[/!]("ID")


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[anon007]

I almost got it but now I gewt this error

Object doesn't support this property or method: 'Response.QueryString'

 

[Sheco]

QueryString is a property of the Request object... try:

[red]Request[/red].QueryString("ID")

 

[anon007]

lol perfect ok so I am still learning asp. Thanks