On 6/26/07, Konstantin Alexandrov <[EMAIL PROTECTED]> wrote: > > Hello. > > I have problem with the table named 'user': > * > psycopg.ProgrammingError: ERROR: syntax error at or near "user" LINE 1: > INSERT INTO user (id, last_name, country_id, city, registrat... ^ INSERT > INTO user (id, last_name, country_id, city, registration_date, first_name, > phone, personal_info, profile_title, skype, birth_day, is_blocked, nickname, > login, yid, jid, password, middle_name, gender, region, msn, avatar, icq, > email) VALUES (1, '', NULL, '', '2007-06-26 06:34:47', '', '', '', '', '', > NULL, 'f', '', 'negus', '', '', 'swordfish', '', '', '', '', '', '', ' > [EMAIL PROTECTED]')* > > It's because this table name 'user' have to be quoted in the SQL query to > avoid conflicts. > How to do that with SQLObject?
Check SQLObject docs or google for it. There is a way, althought I don't remember off the top of my head. But why using SQLObject when there is SQLAlchemy? ;) Max. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to pylons-discuss@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
