Forms & Update/Insert queries

Results 1 to 2 of 2

Thread: Forms & Update/Insert queries

  1. #1
    Join Date
    Dec 1969

    Default Forms & Update/Insert queries

    Im trying to find out how the good ASP programmers would update/insert DB data with data collected with Forms. Say you have a Form with 30+ fields (taken from one record). Your user changes some of the data in these fields then wants to update the fields in the record on the DB.<BR><BR>Would you create one *HUGE* SQL UPDATE query statement using ALL 30+ fields in your form?<BR><BR>My question is the same if you are INSERTING data for a new record.<BR><BR>Thanks, ive been really struggling with this for a while now.

  2. #2
    Join Date
    Dec 1969

    Default Insert and Update

    Inserting a new record will probably require you to create an SQL statement with all or most of the form fields. When you are updating a record, you may want to track the OLD values for the record (HIDDEN FIELDS) and determine which fields need to be updated and construct you SQL string accordingly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts