Ask a Question related to Coldfusion - Getting Started, Design and Development.
-
FusionRed #1
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
-
How to delete the first entry of a table
I know that I can read the first row of a table with $db_query = "SELECT * FROM mytable ORDER BY key_mycode ASC LIMIT 0, 1"; But how can I delete... -
delete automatic in table after 2 months
I need to delete automatic in DB after 2 months. db tbl in_sert column recordID employeeID datum (date) mfm mem tfm tem ofm oem recordID =... -
DELETE table and reset AutoNumber
I'm using MS-Access and was wondering if there's a way to DELETE a table and reset the primary key which is an AutoNumber field. If I do "DELETE... -
Delete key doesn't delete when datagrid is bound to a disconnected table
(Re: WinForm Datagrid) I manually built a table instead of filling it from a datasource. I bound my datagrid to the table. The datagrid works great.... -
Delete from one table with matching records in another table
I'm an Access programmer making the migration to SQL Server, and I want to delete all the records from one table with matching records in another... -
eastinq #2 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
-
warddc #3 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
-
FusionRed #4 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
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
