Session variable as DB Results Criteria

[lahstech]

I want to use session("lastname") from a logon page as the criteria for records to be shown through a DB Results table. In other words, I want to display in a table only the records that belong to session("lastname"). How do I set the criteria for the query to be limited to the session("lastname") that is NOT from a hidden value passed from a form?

 

[FesterSXS]

It sounds like this is what you are after...

strSQL = "SELECT field1, field2 FROM myTable WHERE lastname='" & Session("lastname") & "';"

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[lahstech]

Since I'm using Frontpage 2003 - changing any code is automatically changed back by Frontpage in the sql statement.