Coldfusion Update Problems

hey, i am having problems with this update page. It keeps giving me a database error. I have tried all sorts of things and i still can't get it to work

Instructions:
login as...
username = test
password = test

then click on Update Contact Details

then change a field or whatever and click submit

there is the error.....i just don't know how to make it work

website located at:
http://studentwork.qantm.com.au/pking/website/members.cfm

ANY HELP WOULD BE GREAT

cheers

Something's wrong with your SQL. Try copying the SQL from the error and running it yourself within your database to narrow down the problem. My first try would be to put single quotes around the contact id...like this:

UPDATE tblContact SET Username='test', Password='test', FirstName='Rhonda', LastName='Barlo', StreetAddress='P.O.Box 1692', PostAddress='', City='Springwood', State='QLD', Country='Australia', PostCode=4127, PhoneNumber='(07)3427 7021', MobileNumber='', FaxNumber='', EmailAddress='rhonda@ptwm.org.au' WHERE ContactID='2'

In case your ID field is a string instead of a number (which is what it should be).

hey i tried what u said.

i began from the bottom and instead of having
Where ContactID=#form.ContactID# (i put ContactID = 2)

which then came to another error but this time it was with the 2nd last form field (EmailAddress='#Form.EmailAddress#')
and when i replaced that with a e-mail address it then went to the 3rd last error

etc etc etc

do you know what's happening here?

any help be sweet

cheers

The problems seem to be in the data types of the fields in the database and the corresponding way you're passing them in the query. I would forget about CF for now and just get the query working in your database's SQL editor. Once it works there you should be able to see how to do it from your CF code.