Trouble with SQL and Entry box

Cguru cguru at bigfoot.com
Fri Aug 3 21:18:15 CEST 2001


Thank you very much for your response...I add the line as you said
self.ent17.insert(END,var1[0][0])

and got the following error:
Type Error: unscriptable object...

That message was pretty cryptic.thanks

In article <b9rhmt0q058kiqs7mhonmeh35v71j4ifvu at 4ax.com>, "Tim Roberts"
<timr at probo.com> wrote:


> 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.



More information about the Python-list mailing list