ColdFusion Tutorial

Delete data from database

This will delete data from the database.

The first query will delete all records where First Name is 'Tom'.
This is done by using the WHERE statement.

<cfquery name="del_person" datasource="persondb" username="" password="">
DELETE * FROM person 
WHERE
Person_First_Name = 'Tom'
</cfquery>

This query will delete all records in the database.

<cfquery name="del_person" datasource="persondb" username="" password="">
DELETE * FROM person 
</cfquery>

ColdFusion Tutorial test

Delete data from database

No test is available or implemented for this ColdFusion Tutorial.

No User Comments.

No User Comments, be the first one to write your comments?

Add your comments

Your Name*:
Your Email:
Site URL:
Site Name:
Comemt Title*:
Your Comment*:
Key Phrase*:
Va9
Your IP Address: 38.103.63.62
 

ScandicWeb is own by Scandic Systems LTD [UK] Company No. 5984000. All other trademarks and copyrights are the property of their respective holders.

[Home [Site Map [Privacy Statement [Site Feedback] [About ScandicWeb]


[ColdFusion [Flash [Search Engine Optimization [Graphics [Cascading Style Sheets (CSS) [JavaScript (JS) [Software]

Partner sites: ScandicSoft


Server time: 19. November 2008 Wednesday