[thelist] CF/SQL syntax error

[Chris Johnston]

Without looking at the table I would have to guess that the problem
comes from the fact that you can't update a field that you are using to
search on.

You are updating phonebook.id and also using it as the key for the query
(WHERE phonebook.id=#form.id#). This shouldn't be done.

/chris


> -----Original Message-----
>
> <cfquery name="updatepb" datasource="phonebook">
> UPDATE phonebook
> SET
> phonebook = '#form.phonebook#', areacode = '#form.areacode#', 
> date = '#form.date#', id = #form.id# WHERE 
> phonebook.id=#form.id# </cfquery>