On 31/01/02 19:51, Norman Palardy said:
> To be honest I don't think he meant that he executed that code.
> It was a table he created as an example for the following select
>>> create table Im_A_Dork
>>> (
>>> id integer,
>>> who varchar,
>>> why varchar,
>>> butmom varchar,
>>> primary key (id)
>>> )
>>>
>>> curs = db.SQLSelect("select * from Im_A_Dork")
>>> for
>>> who = curs.field("who")
Now this is getting really confusing! The original post was from someone
saying they got errors when using "select * from Im_A_Dork". I suggested
that an error may then arise if you say "curs.idxField(14)" when you REALLY
want "curs.idxField(15)", and it may be better to spell out all the fields
in the select statement to be sure of getting what you want: "select
who,why,butmom..... from Im_A_Dork". Then Mr WW said you don't need to spell
them out, you can use the example above.
F.A.B.
Ian
------------------------------
Ian G. Morris - Tonewright
ian at igmusic dot co dot nz
"Second-best $200 I ever spent."
|