Passing field values to access

D

DeadManWalking

HELP!

I need to pass field-values from an ASP to an access-db where they're
used as PARAMETERS in a parameter-query.

Can anyone tell me how to do this without first writing them into a
table or so...?

PLEASE HELP!
I'm really desperate...


DMW
 
T

Thomas A. Rowe

pagename.asp?Id=10000&loc=south

then on the page the run the query in HTML view

<%
Dim ID
Dim Loc
ID = Request.QueryString("Id")
Loc = Request.QueryString("loc")
%>

then your query would be

Select * from tablename where ID = '" & ID & "' and Loc = '" & Loc "' "

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
D

DeadManWalking

Thanks a lot!
I'll try this one

DMW

Thomas A. Rowe said:
pagename.asp?Id=10000&loc=south

then on the page the run the query in HTML view

<%
Dim ID
Dim Loc
ID = Request.QueryString("Id")
Loc = Request.QueryString("loc")
%>

then your query would be

Select * from tablename where ID = '" & ID & "' and Loc = '" & Loc "' "

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
Click to expand...
 
Top