Trouble with SQL and Entry box

[Tim Roberts]

"Cguru" <cguru at bigfoot.com> wrote:
>This is what I have...
>       rs = pg.DB('blah')
>
>	query17 = "select companyname from clients"

It's good practice to end ALL queries with a semicolon.

>	var1 = rs.query(query17)
>        self.ent17 = Entry (master)
>	#self.ent17.configure(textvariable = query17)
>	self.ent17.insert(END,var1)
>        self.ent17.place(in_=master,x=120,y=30)
>
>It doesnt' do what I expect it to do.

The "query" method returns a tuple of tuples.  You get one tuple for each
database row returned, where each tuple contains all the columns in your
query.  In your case, if there are 5 companyes in the "clients" table,
you'll get:
  (
    ( 'IBM', ),
    ( 'Microsoft', ),
    ( 'GM', ),
    ( 'Ford', ),
    ( 'Motorola', )
  )

If you want to put the first column of the first row into your text box,
you should be able to use:

   self.ent17.insert(END,var1[0][0])

--
- Tim Roberts, timr at probo.com
  Providenza & Boekelheide, Inc.