Quetion how to write a SQL Query for an Access database in .ASP
Posted on 2007-10-04
I am in no way shape or form a web guy, so I have almost no clue how to do this. I wrote the page that does the form/db portion using Frontpage, if that's any indication of my skill level :)
I have a web page, that asks a user a question, and then logs the answer, along with the user ID in an access database. (Using NT Authentication)
I do not want users to be able to keep coming to the page and adding more records in with answers. I only want each user to have one record in the database.
What I want to be able to do, is set up a SQL query at the top of the page, that looks into the database after the user authenticates, then if it finds a record with that user's ID it redirects them to a different page that would say something like "You already have a record in the database, go away". If no record is found then it displays the page, and allows them to complete the form.