[thelist] CF/SQL syntax error

Robin Hastings robin at rhastings.net
Thu Jun 7 16:27:08 CDT 2001

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

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

More information about the thelist mailing list