[thelist] CF/SQL syntax error

Joshua Olson joshua at alphashop.net
Thu Jun 7 16:13:32 CDT 2001


Which db are you running?  is phonebook really a field name?

-joshua

-----Original Message-----
From: thelist-admin at lists.evolt.org
To: Thelist at Lists. Evolt. Org
Subject: [thelist] CF/SQL syntax error

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





More information about the thelist mailing list