Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-02 : 09:26:19
|
Doug writes "First of all, I have already submitted two (what I consider to be) difficult SQL questions and both times I recieved a timely answer that really saved my butt! I have told all my pragramming comrades about your site and I want to extend my appreciation for all your help.
I hope you can help me with this question... it's probably a well documented process, but I don't know where to begin.
1) I am working with a fourth normal form database on a SQL 7 server.
2) I am creating an interface to administer and enter data into the database using ASP, ADO and VBScript.
3) I need to be able to retrieve data from several different but related tables, display it to the user in an HTML form (using several different element types inluding text, radio buttons, select boxes, etc.) allow the user to change existing data and add data that did not exist before. Finally, submit the changes and/or additions to the database.
My understanding is that I cannot use UPDATE on a field that doesn't already exist or INSERT on a field that already exists. So, how do I update the database if I don't know if the data already existed and is being updated OR if the data never existed and is now being added? For example, one of the HTML forms gathers general customer information including up to 3 different phone numbers. Not all customers will want to include 3 numbers, but may want to add up to 3 numbers in the future.
I hope this is enough info to paint my picture. Thanks again for all your hard work and help! You have become an integral part of my technical medical kit for SQL!
Regards,
Doug" |
|
|
|
|
|
|
|
Mixing Insert and Update