[jifty-devel] Perhaps another bug :)

[Joshua J. Kugler]

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.
> <SNIP>
> 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.

j----- k-----

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