Sorry, Its my typing mistake :( . I put : insted , . But still my question yeat remained unanswered. :(
On Jun 8, 7:50 pm, Didip Kerabat <[email protected]> wrote: > You have Syntax Error here: > > ('sdsd':'sdsds') > > That one should be tuple right? > > - Didip - > > > > On Mon, Jun 8, 2009 at 6:14 AM, Ash <[email protected]> wrote: > > > Hello , > > > I am trying to insert in the table using two ways in the values which > > i show below > > > engine = sqlalchemy.create_engine(<to poastgres>) > > metadata = MetaData() > > > t1 = Table('master',metadata) # assume master has 2 feilds name , city > > > t1.insert({'name':'tttt','city':'bank'}) > > > engine,execute(t1) > > > This works for fine me. > > > If i make values like this > > tt = [('asasas','belhium'),('sdsd':'sdsds')] > > > t1.insert(values=tt) > > > i get error > > sqlalchemy.exceptions.ProgrammingError: (ProgrammingError) syntax > > error at or near ")" > > LINE 1: INSERT INTO abc () VALUES () > > ^ > > 'INSERT INTO abc () VALUES ()' {} > > > Can any one guide whts wrong... i jnow value is not being passed so > > anyother way. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
