[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