lol .. I never thought of update as a reserved word, since I've never used
date or update as a field name .. especially the way you spelled it (UpDate
.. which I intuitively thought of as Upload Date, considering what you were
after ..). Bloody SQL hehe. At least CF has the common sense to prefix
everything with CF ;)
I had the same problem one time with 'Login' as a field name. It turns out
that, in Sybase, 'Login' is a reserved word.
Live and learn, heh.
On a related note .. does anyone have a list of *all* reserved words on all
database platforms? I imagine this would be rather helpful for many of us
who will be exposed to multiple database platforms throughout our careers.
If you know of such a list, or a partial list, please let me know and I will
add it to my list of 'best practices' for my own CF methodology and also
compile the list and add it to my CF technical database, and make it
available to any other CF sites that want it :)
Todd Ashworth
----- Original Message -----
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 6:35 PM
Subject: Re: INSERT into error....
> AH... ok.. this works now.. i placed UpDate as the new Column name and of
> course that did not work either
>
> I looked at the list of reserved names and guess what? :)
>
> update is reserved also.. i changed it to OPDate and it worked fine.
>
> What a PITA!!!!
>
> Thanks everyone for the help. I printed out the list of reserved names in
> 20point type and hung it on my wall. :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
