Re: [SQLObject] IntCol not working - desparately need help

[Mike M. <mm...@wo...>]

On Friday 14 November 2003 11:31 am, Ian Bicking wrote:

Thank you both for prompt and accurate replies.  Approximately 1-3/4 seconds 
after waking up this morning, it occured to me that "index" is indeed a 
reserved word in SQL, which goes to confirm one more time that continuing to 
beat one's head against the wall late at night is futile and painful.  
Unfortunately, that doesn't stop me from doing it, though.

Also, thanks for not rubbing my nose in it.

Mike
> On Nov 14, 2003, at 2:10 AM, Randall Randall wrote:
> > The word "index" is reserved in MySQL.
> >
> > You should use
> > myIndex = IntCol()
> > if you have to have a separate index.
>
> Good catch.  You can also do
>      index = IntCol(colName="person_index")
>
> --
> Ian Bicking | ia...@co... | http://blog.ianbicking.org

-- 
the Moum's (Mike, Dede, Suzanne, Jeff, Kristen)
Tipp City, Ohio, USA
Visit the Baha'i World web site at www.bahai.org
Visit the U.S. Baha'i web site at www.us.bahai.org