[thelist] CF/SQL syntax error

[Robin Hastings]

>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
>

I actually had caught that just after I sent off the request for help, as well as the fact
that my column names weren't in quotes. I'm still getting the error though! Thanks for the
heads up.

Robin Hastings
Public Computer Center Coordinator
hastingsr at mrrl.org
(573) 634-6064 x242