You have Syntax Error here:
('sdsd':'sdsds')
That one should be tuple right?
- Didip -
On Mon, Jun 8, 2009 at 6:14 AM, Ash <ashishsinghbha...@gmail.com> 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 sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
