|
To insert the form data from the example above with a CFQUERY use this syntax:
<CFQUERY NAME="AddEmployee"
DATASOURCE="Employee DB">
INSERT INTO Employees (FirstName, LastName, Phone)
VALUES ('#Form.FirstName#', '#Form.LastName#',
'#Form.Phone#')
</CFQUERY>
|
|