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
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