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/ p...@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
