FrontPage 2003 session variables and Access data base

[Rick Rantilla]

I've figured out how to use the session variables to carry data from ASP page
to ASP page. Now I want to use those same session variables in querys to an
Access database. I've tried the Insert Parameter in the Data Base Results
Wizard and now have tried SQL, for example, where loginemail is one of my
session variables:

SELECT * FROM BookSwaps WHERE (mail = '::loginemail::')

It won't take session(loginemail) or session("loginemail")

What is the exact syntax to pass a session variable to an Access query?

 

[Jim Buyens]

If you want to use thje DRW, you'll have to pass the loginemail value as a
query string value or as a form field. For example:

<a href="[email protected]">Display</a>

If you want to use Session variables, you'll need to write your own ASP/ADO
code rather than using the DRW.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------