Inserting Data from Form into MS Access Database with Coldfusion

[websiteideas]

Can anyone please tell me what looks wrong with this code? It's only inserting the username and password, but not the other fields.

newuser.cfm:

<form action="insert_user.cfm" method="post">

Login: <input name="UserLogin" type="text"><br>
Password: <input name="UserPassword" type="text"><br>
Email: <input name="EmailName" type="text"><br>
Address: <input name="Address" type="text"><br>
City: <input name="City" type="text"><br>
State: <input name="StateOrProvince" type="text"><br>
Zip Code: <input name="PostalCode" type="text"><br>
Country: <input name="CountryRegion" type="text"><br>
Company: <input name="CompanyName" type="text"><br>
Work Phone: <input name="WorkPhone" type="text"><br>
Work Extension: <input name="WorkExtension" type="text"><br>
Home Phone: <input name="HomePhone" type="text"><br>
Mobile Phone: <input name="MobilePhone" type="text"><br>

<input type="submit">

</form>




insert_user.cfm:

<CFQUERY DATASOURCE="realestate" NAME="insert">

INSERT INTO Contacts(UserLogin, UserPassword, Address, City, StateOrProvince, PostalCode, CompanyName, WorkPhone, WorkExtension, HomePhone, MobilePhone )

VALUES('#form.UserLogin#', '#form.UserPassword#', '#form.Address#', '#form.City#', '#form.StateOrProvince#', '#form.PostalCode#', '#form.CompanyName#', '#form.WorkPhone#', '#form.WorkExtension#', '#form.HomePhone#', '#form.MobilePhone#', '#form.EmailName#')

</CFQUERY>

[gigamike]

hi websiteideas,

:( youre field is not parallel in the insert statement:

11 fields inside
INSERT INTO Contacts(UserLogin, UserPassword, Address, City, StateOrProvince, PostalCode, CompanyName, WorkPhone, WorkExtension, HomePhone, MobilePhone ) --> forgot email field here

and
12 fields inside
VALUES('#form.UserLogin#', '#form.UserPassword#', '#form.Address#', '#form.City#', '#form.StateOrProvince#', '#form.PostalCode#', '#form.CompanyName#', '#form.WorkPhone#', '#form.WorkExtension#', '#form.HomePhone#', '#form.MobilePhone#', '#form.EmailName#')

let me know if it works.

thanks,

gigamike



Can anyone please tell me what looks wrong with this code? It's only inserting the username and password, but not the other fields.

newuser.cfm:

<form action="insert_user.cfm" method="post">

Login: <input name="UserLogin" type="text"><br>
Password: <input name="UserPassword" type="text"><br>
Email: <input name="EmailName" type="text"><br>
Address: <input name="Address" type="text"><br>
City: <input name="City" type="text"><br>
State: <input name="StateOrProvince" type="text"><br>
Zip Code: <input name="PostalCode" type="text"><br>
Country: <input name="CountryRegion" type="text"><br>
Company: <input name="CompanyName" type="text"><br>
Work Phone: <input name="WorkPhone" type="text"><br>
Work Extension: <input name="WorkExtension" type="text"><br>
Home Phone: <input name="HomePhone" type="text"><br>
Mobile Phone: <input name="MobilePhone" type="text"><br>

<input type="submit">

</form>




insert_user.cfm:

<CFQUERY DATASOURCE="realestate" NAME="insert">

INSERT INTO Contacts(UserLogin, UserPassword, Address, City, StateOrProvince, PostalCode, CompanyName, WorkPhone, WorkExtension, HomePhone, MobilePhone )

VALUES('#form.UserLogin#', '#form.UserPassword#', '#form.Address#', '#form.City#', '#form.StateOrProvince#', '#form.PostalCode#', '#form.CompanyName#', '#form.WorkPhone#', '#form.WorkExtension#', '#form.HomePhone#', '#form.MobilePhone#', '#form.EmailName#')

</CFQUERY>