[jifty-devel] Perhaps another bug :)
Joshua J. Kugler
jkugler at bigfoot.com
Mon Mar 20 03:07:32 EST 2006
On Saturday 18 March 2006 22:19, bart bunting said something like:
> Hi yet again,
> It appears that it is not possible to have a column called order.
> When I try This is what I get.
> The second output is from when I rename it to priority.
> Perhaps it's clashing with a reserved word in sql when the statement
> is generated?
"Order" is indeed a reserved word in SQL. In MySQL you can "escape it,"
so to speak, by putting back ticks around it thus: `order` but it's
still a bad idea to use it as a column name.
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth, that Jesus Christ is LORD -- Count on it!
More information about the jifty-devel