z06-dave Posted April 23, 2015 Share Posted April 23, 2015 (edited) First off, first post, I'm no .asp guru, but I get the job done... When passing a variable to a new page something like this: www.database.com/test.asp?mrnsearch=203434 Is there a way in .asp to create that record number in the db if it does not exist? I know I can easily open the record, but can I create a new one its it's not there? For instance I want to open mrn 203434 is if exists, if not create it and open it. Thanks Edited April 23, 2015 by z06-dave Link to comment Share on other sites More sharing options...
davej Posted April 23, 2015 Share Posted April 23, 2015 Don't you read the record like this? http://www.w3schools.com/asp/ado_query.asp So you would insert a new record like this... http://www.w3schools.com/asp/ado_add.asp And update an existing record like this... http://www.w3schools.com/asp/ado_update.asp Link to comment Share on other sites More sharing options...
z06-dave Posted April 24, 2015 Author Share Posted April 24, 2015 Yes, and that should do it. That part of the project is a few months away and I wanted to make sure I could use a .asp page before I did all of my front end configuration. I'm not ready to learn asp.net, or should I say I don't have the time right now. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now