Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I pass parameters to a view in Access 2000?

Status
Not open for further replies.

Quinton

Programmer
May 31, 2001
1
US
I have created a view table in Access 2000 with a parameter
of prmTokenand and prmExpires. the code is as such:

PARAMETERS prmToken Text ( 16 ), prmExpires DateTime;
SELECT Session_Data.Name, Session_Data.ValueString FROM Session,
Session_Data
WHERE (Session.PK_SessionID = Session_Data.FK_SessionID) AND
(Session.Expires < [prmExpires]) AND
(Session.Token = [prmToken]);

it works fine in Access 2000 giving me the input window for the prmToken
paramenter but I wish to know how to use this in an ASP file, yes its
something to do with the command object and the append.parameter property
but can you tell me how I can input a value to be used in the prmToken SQL
parameter and then get an output from the Name and ValueString fields using
ASP?

many thanks,
Q.

The Tables are set up as thus:

Table Name: Session
Table Field 1: PK_SessionId AutoNumber
Table Field 2: Token Char(16)
Table Field 3: Expires DateTime

Table Name: Session_Data
Table Field 1: PK_SessionDataID AutoNumber
Table Field 2: FK_SessionID Integer
Table Field 3: Name Char(50)
Table Field 4: ValueString Char(255)

PK_SessionID [one-to-many] FK_SessionID
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top