On 10/04/06, Alberto Valverde <[EMAIL PROTECTED]> wrote: > > > On 10/04/2006, at 11:41, Ed Singleton wrote: > > > > > I kept getting the following error with my model: > > > > File "C:\Python24\lib\site-packages\MySQLdb\connections.py", line > > 33, in defau > > lterrorhandler > > raise errorclass, errorvalue > > _mysql_exceptions.ProgrammingError: (1064, "You have an error in > > your SQL syntax > > ; check the manual that corresponds to your MySQL server version > > for the right s > > yntax to use near 'group' at line 1") > > > > > > After reducing my code to the minimum that produced the problem, I > > discovered that creating a class in my model called "Group" was what > > produced the error. > > > > Is there any straightforward way round this or if not, is there a list > > of words I can't use as class names in my model? > > This isn't SQLObejct's fault but SQL's... "GROUP" is a reserved SQL > keyword (GROUP BY colname) hence a class called "Group" will map to a > table called "group". > > You can, however, work around it by defining a "table" attribute in > sqlmeta: > > class Group(SQLObject): > class sqlmeta: > table = "group_table" > > Hope it helps,
It does, thank you. (I should have been able to work that out for myself. I knew you could specify table names, but that hadn't clicked). Thank you Ed --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears -~----------~----~----~----~------~----~------~--~---
