[thelist] CF/SQL syntax error
scott.brady at homeqonline.com
scott.brady at homeqonline.com
Thu Jun 7 16:19:07 CDT 2001
Actually, I do that all the time (whether it's proper or not, it does work . ..
at least, it doesn't generate a syntax error) using SQL Server.
My best guess is that they are using a column name of "date". Try changing the
column name to something like "theDate".
Or, if the "date" field is set to a type of "date_time" and you're trying to set
it to a string (such as '6/7/2001') could be generating the error (including the
single quotes).
Hope one of those helps.
Scott
> 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.
> > -----Original Message-----
> >
> > <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>
More information about the thelist
mailing list