Re: Formatting Embedded SQL

"Milo Pschigoda" <[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]> 
On 12/5/06, Rich Shepard <[email protected]> wrote:
> On Tue, 5 Dec 2006, Milo Pschigoda wrote:
>
> > self.cur.execute("CREATE TABLE name (ID integer primary key,"+
> >                                                           "col2 integer,"+
> >                                                           "col3 text)")
>
>    And the plus signs are accepted by sqlite? Kewel!
>
> > Just a thought, but I bet there's a programmatic way to do it better.
>
>    Then perhaps we'll both learn something new.

The addition actually happens in python before it gets passed to execute()
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.