DRW - PLEASE HELP!!!

[skc]

Using DRW in FP2000.

I have a Session with a field from my database.

How can I use this Session...

which is: <% = Session("UID")%> //I have got this as a
field from the database earlier on in my pages.

in my SQL custom query in the DRW or in the dropdown
filter boxes against the fields in my database?

....so I want something like:

<databasefield>=Session("UID")

Please help!!!!

Thanks.

skc

 

[Kevin Spencer]

1. Was this ASP page created with the FrontPage Database Results Wizard? If
so, who customized it, and how?
2. You stated that this Session variable was created from a database query
of some kind. What exactly do you want to do with it? Do you want to put it
into another database, the same database, update the field with the value,
insert a new record, or what?
3. What (if any) are your programming skills?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[skc]

-----Original Message-----
1. Was this ASP page created with the FrontPage Database Results Wizard? If
so, who customized it, and how?

I customised it

2. You stated that this Session variable was created from a database query
of some kind. What exactly do you want to do with it? Do you want to put it
into another database, the same database, update the field with the value,
insert a new record, or what?

use the session variable as a parameter to be thrown at my
SQL.

3. What (if any) are your programming skills?

Not pro, but novice - why?

 

[grw]

If its numeric :
fp_sQry = "Select * from YourTable where Field="&Session("UID")

If its text
fp_sQry = "Select * from YourTable where Field='"&Session("UID") &"'"