SessionVariables - INSERT INTO Command

How can I use Session Variables to populate a field using the Insert Into
command?

troyo@troyo.net

Joe
Sun Jul 06 16:15:56 CDT 2003


"troyo" <troyo@troyo.net> wrote in message
news:s6%Na.19444$ma.416@twister.nyroc.rr.com...
> How can I use Session Variables to populate a field using the Insert Into
> command?
>
> troyo@troyo.net
>
>

If by 'use a session variable to populate a field' you mean use the
session variable feature to populate a database table column you can't, it's
two different animals all togeather.

If what you really mean is how do you put the contents in a session variable
into a database table column as a new row using insert into, the code is

recordsetname.open "insert into table-name (column-name) values (' " &
session("sessionvariablename") & " ')", connectionname

of course, this won't work without using the replace function to change
single quotes to two single quotes in the sessionvariablename value if it
might contain them.