Professional Web Applications Themes

Delete form - Post data to a table and delete uponsubmit. - Coldfusion - Getting Started

I have a delete form that I'd like to post the data to a table (delete_pcn) and delete upon submit, so that all deletions may be kept track of in this delete_pcn table. Currently I've got the form returning the data for review prior to deletion, then the data is just deleted out of existence. Does anyone have any idea how I might go about doing this???? Red;->...

  1. #1

    Default Delete form - Post data to a table and delete uponsubmit.

    I have a delete form that I'd like to post the data to a table (delete_pcn) and
    delete upon submit, so that all deletions may be kept track of in this
    delete_pcn table. Currently I've got the form returning the data for review
    prior to deletion, then the data is just deleted out of existence.

    Does anyone have any idea how I might go about doing this????

    Red;->

    FusionRed Guest

  2. #2

    Default Re: Delete form - Post data to a table and delete uponsubmit.

    I would start a <cftransaction>, perform an insert into delete_pcn, then a delete from other table, then end </cftransaction>. This makes sure the record is saved before it is deleted.

    eastinq Guest

  3. #3

    Default Re: Delete form - Post data to a table and delete uponsubmit.

    you could skip the whole transferring records from one table to another and just create a status column in the table and set the value to '0' or 'inactive' or 'deleted' or whatever.

    d.
    warddc Guest

  4. #4

    Default Re: Delete form - Post data to a table and delete uponsubmit.

    HI there and many, many thanks to both easting and warddc. Both are great suggestions.

    Red;->
    FusionRed Guest

Similar Threads

  1. How to delete the first entry of a table
    By Stefan Mueller in forum MySQL
    Replies: 4
    Last Post: December 2nd, 08:56 AM
  2. delete automatic in table after 2 months
    By pilem17 in forum Coldfusion Database Access
    Replies: 3
    Last Post: October 25th, 09:32 AM
  3. DELETE table and reset AutoNumber
    By McKirahan in forum ASP Database
    Replies: 2
    Last Post: August 2nd, 09:09 PM
  4. Delete key doesn't delete when datagrid is bound to a disconnected table
    By Fred Zolar in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: April 1st, 07:47 AM
  5. Delete from one table with matching records in another table
    By Dale Fye in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 1st, 01:28 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139