[thelist] CF/SQL syntax error

[Robin Hastings]

Hi folks!

  I'm trying to get a databased phone book directory online and I'm running into a syntax
problem that is frustrating me. I'm sure that I'm just overlooking something stupid, but
I'd appreciate another set of eyes to look over my query to see where I've gone wrong!

The query is:
<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>

and I'm getting a "Syntax Error In Update Statement" error when testing the page. Thanks
in advance for taking a look at this!!

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