"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Also make sure that you are inserting the correct values into the correct format fields,as in, the value in city should be inserted intoa text field, and since the error is occuring on line 9, there maybe a field there that is being inserted into maybe a number field, also check you relationships in your database!

If inserting to SQL SERVER make sure your field types are "varchar" if inserting into MS ACCESS make sure they are "text".
Using cfqueryparam is actually more efficient, and more secure.

Never trust data coming from the browser! URLs can be modified, and form data can be forged. Use <CFPARAM> to test for variable existence and to enforce data type restrictions. In addition, use <CFQUERYPARAM> to enforce type restrictions while improving system performance and scalability.