Passing a variable in link, new or existing record

[z06-dave 0]

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

[davej 251]

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

[z06-dave 0]

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.