SQLSoup, whitespace

[Tim Pierson]

Happy Friday night everyone.

Maybe there's an easy way to deal with this:

How can I use the SQLSoup insert function to update columns whose names contain whitespace?

ie:  db.table.insert(XML Schema Version=None)

Are there any cool tricks I don't know?

Thanks

[Simon King]

How about:

values = {‘XML Schema Version’: None}
db.table.insert(**values)

Hope that helps,

Simon

[Tim Pierson]

Ahh! yes ! I tried that but in my fatigue I got the syntax wrong. Thanks!

Sent from my iPad

> --
> You received this message because you are subscribed to a topic in the Google Groups "sqlalchemy" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/topic/sqlalchemy/I6-C__9ZNYk/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to sqlalchemy+...@googlegroups.com.
> To post to this group, send email to sqlal...@googlegroups.com.
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.