pymssql

[sum abiut]

ok did some changes:

conn=pymssql.connect(server,username,password,database)
 cus=conn.cursor(
cus.execute("SELECT budget_code,budget_description,rate_type FROM glbud")
for row in cus:
    print(row)


the above code display the selected column


but when i iterate and try to print the fields, its not displaying anything
and its not giving any error.

conn=pymssql.connect(server,username,password,database)
 cus=conn.cursor(
cus.execute("SELECT budget_code,budget_description,rate_type FROM glbud")
for row in cus:
    print(row.budget_code,row.budget_description,row.rate_type)


the above code it doesn't print out anything and it doesn't give me any
error.

any assistance will be very much appreciated.




On Fri, Sep 9, 2016 at 1:38 PM, Lawrence D’Oliveiro <lawrencedo99 at gmail.com>
wrote:

> On Friday, September 9, 2016 at 12:48:50 PM UTC+12, sum abiut wrote:
> >     cus.execute("SELECT * FROM glbud ")
>
> Never use “select *”, except for testing.
>
> >     for row in cus:
> >            print(row)
> > this works perfect, but when i try to iterate through and only print out
> > specific fields i got the error NameError: name 'budget_code' is not
> defined
>
> Possibly because you are getting back a tuple? Are you expecting some
> other object type?
> --
> https://mail.python.org/mailman/listinfo/python-list
>