Re: [SQLObject] syntax error exception on sqlite database?

[Oleg B. <ph...@ph...>]

On Mon, Aug 02, 2010 at 10:24:18PM -0700, Dominic LoBue wrote:
> I am not quite sure what the problem is, but I have so far ruled out
> both the database and my code.

   I am not so sure...

> When I use the same code on the same
> database data in a mysql database, everything works fine.

   It could be that the SQL syntax you use is valid in MySQL but invalid in
SQLite.

>  1/QueryR  :  SELECT FactionName, Description, solarSystemID,
> corporationID, militiaCorporationID, raceIDs, sizeFactor,
> stationCount, stationSystemCount, PRIMARY FROM chrFactions WHERE
> ((chrFactions.factionID) = (500001))

> sqlobject.dberrors.OperationalError: near "PRIMARY": syntax error

   What does it mean - SELECT *** PRIMARY FROM? It seems you've got a
column named PRIMARY...

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.