Validating user from database/wizard

[Emmett Power]

Hi,

I have a simple user registration/login database on my FP2002 web. I
have the usual registration page which works fine and populates the
database. This supplies data to cookies which, again, works fine.

The problem comes with validating the data on the login page from the
database.

I have tried various non-database wizard solutions using connection
objects but keep coming up against problems recognising the DSN. I
have tried various workarounds to this with no luck.

I am wondering if it is possible to use the database wizard to set up
the connection, check the login data against the database and then
using Response.Redirect according to the data entered.

Is this possible? If so can anybody point me to code samples to look
at.

Thanks for any help.

Regards

Emmett Power

 

[Stephen Travis]

Sure. Just add the response.redirect inside the DRW and it will only ge executed it the query returns a record. You should also add
a response.buffer true to the top of the page to supress the page until it completes.

 

[Emmett Power]

Stephen,

Thanks for the help.

Regards


Emmett

Sure. Just add the response.redirect inside the DRW and it will only ge executed it the query returns a record. You should also add
a response.buffer true to the top of the page to supress the page until it completes.