Using a cookie in a custom query in FrontPage Access

[rontev]

I'd like a page to open and immediately display database results where the
Custom query includes a field derived from a stored cookie. What ASP code
will it take to make this item visible to the front page query wizard??

 

[clintonG]

It will take code to read the cookie, get the value from the
key used to contain specific data, assign that data to a variable,
pass that variable to a SQL statement used as the query value
which is passed to an instance of a Server object used to
generate a record set.

Don't forget to write some error handling code.

 

[rontev]

Thanks, yes, I agree on the steps required. I know how to retrieve the
cookie value. I don't know how to assign the variable in a form acceptable
to the FrontPage wizard. (It won't let me edit the resulting SQL directly)
I suspected that Front Page passes variables from one page to the next with
arrays stored as session variables - but I don't know how to get around that
with direct asp code. I only need one variable. Hardly worth an array. Any
Hints??

Ron

 

[clintonG]

I've been taught to break a problem down into its smallest
part and then work backwards. You may be able to determine
how FrontPage is passing the data to another page and
then deduce how to access the data you need but you'll have to
build results pages that provide you with the clues from which
you can deduce and test your assumptions.

<%= Clinton Gallagher