Referencing Form Fields in a SQL Statement

[ChrisBelzona]

Can anyone help, here's the situation.
I have User/Password login fields on my main menu.

I need to reference them in a sql statement in other frames.

I have previously used the post method and referenced them by the following '& Request.Form("T1&quot &' etc.. however I now need to refernce them without the post method.

Any Suggestions


Chris

 

[khorjak]

Hi Chris,

Is there a particular reason why you're not wanting to use the post method?

If you have login textboxes in one frame, and intend to verify it in another, you can still use POST. Just set target="frameB".

HTH

Choo Khor
choo.khor@intelebill.com

 

[ChrisBelzona]

Hi Choo

Thanks for taking time to look at my question.

To answer your question and give you a little more back ground - I use the User/Password fields on two forms that link to an access table to retrieve hyperlinks that are allocated to each user. One of these forms uses the post method the other does not, when the user opens the asp page it lists their allocated hyperlinks.

If you have any more suggestions I would be grateful

Chris

 

[nj5j]

Setup a session variable and reference it:

Session("Session_whatever&quot = "whatever"

To fetch in the other frame:

dim x_parm
x_parm = Session("Session_whatever&quot

that's all