Insert data into database

This shows how to insert data into the database.

 

<!--- Set the variable First Name. --->
<cfset First_Name = "Tom">
<!--- Set the variable Last Name. --->
<cfset Last_Name = "Jackson">
<!--- Run the insert query. --->
<cfquery name="add_person" datasource="persondb" username="" password=""> 
INSERT INTO person 
(Person_First_Name,
Person_Last_Name)
VALUES 
('#First_Name#',
'#Last_Name#')
</cfquery>

Advertisement

No User Comments.

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

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