Using a cookie in a FP Access data query

R

RonTev

I want to retrieve data from an access database where a
cookie value is used in a custom query. In the following
attempt I get a "data mismatch" error. DN is a numeric
field in the database; CDNum is a cookie with a numeric
value (or, it is supposed to be ...when setting a cookie,
is there a way to be sure it is numeric??)

SELECT * FROM assigned WHERE (DN = 'request.cookies("CDNum")')

Alternatively, are there a couple of lines of ASP which
would declare a variable, containing the cookie value,
which would then be visible to the Database results wizard
- the same way it sees variables from the POST method
usually used??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top