Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Location
    Malaysia
    Posts
    25

    Lightbulb Unanswered: insert and delete

    I'm trying to do 2 transaction in the same page. I'm using 2 form. Form1 is for insert record in table and form2 is to delete the data that retrieve in the page. I'm using dreamweaver to code it. The insert statement done but the delete statement from form2 not work but when I run the page there is no error.

    I attach my coding for your info. If somebody can help me solve this problem, it's a happy day for me...
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    How are you submitting your second form because from the looks of the file attached it can't be submitted..... if it can't be submitted then the values will never be available for requesting...

  3. #3
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Try the attached
    Attached Files Attached Files

  4. #4
    Join Date
    Apr 2004
    Location
    Malaysia
    Posts
    25

    more detail

    Quote Originally Posted by rokslide
    Try the attached
    Thank q for your reply. It is not what I mean. What I want is the 2 transaction done at the same time. When the user click the Sokong button both insert and delete statement take place.
    The senario is retrieve data form table A after user click Sokong button the data will be insert in table B and the retrieving data will be delete in table A.

    Can it be done....

  5. #5
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618

    Some more like this

    Check the attached, should be basically what you want
    Attached Files Attached Files

Posting Permissions

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