Update and Insert

Results 1 to 2 of 2

Thread: Update and Insert

  1. #1
    Join Date
    Dec 1969

    Default Update and Insert

    How do I figure out if a record was updated or not in the page. I have to insert 3 records in a table based on form field school1, school2, school3. I want insert only one record if only school1 is populated. User can later came in and modify school one and add school2. So school1 has to be updated and school2 will have to be inserted. <BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Update and Insert

    Why not always do a delete/insert?<BR><BR>Another option:<BR><BR>Store the school&#039;s ID in a hidden field - if it&#039;s populated, do an UPDATE. If it&#039;s not, do an INSERT.

Posting Permissions

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