Python 2.4.3 with Vertica Database on Linux. We are migrating from an Informix database to Vertica. We have C code and a lot of SQL Stored procedures in our Informix db that are not viable in Vertica. We are trying to convert them to Python. My first questions is: I am using pyodbc to connect to the Vertica database. When I do a select on count and print the result it displays as (for example) 4L (which is the row count plus the data type). If I try to use the variable in a conditional it does not work. I have no idea how to have data value simply be 4 ! cursor.execute("SELECT COUNT(*) from cv_gls_wkly_misc") result = cursor.fetchone() number_of_rows = result[0] print `number_of_rows The data display is the (select count(*)) and a selected row. 4L [(5185L, 93L, Decimal("42.50"), Decimal("50.36"), Decimal("3406.35"), Decimal("0"), Decimal("78.00"), Decimal("0"), Decimal("66.00"), Decimal("0"), Decimal("12.73"), Decimal("0"), Decimal("0"), Decimal("311.00"))] Regards, CVez
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor