[thelist] CF/SQL syntax error
Robin Hastings
hastingsr at mrrl.org
Thu Jun 7 15:48:56 CDT 2001
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
More information about the thelist
mailing list