Mike P wrote:
That is a nice piece of code,
I cracked the idea of the shift; problem, my final problem is still
how to convert
my @row = $sth->fetchrow_array;
$$StartDate = $row[0];
$$EndDate = $row[1];
$sth->finish()
into python code as i'm not sure what $$ means
according to a quick google, fetchrow_array is equivalent to Python's
fetchone (read one row from the database into a sequence object), so the
above is simply:
row = cursor.fetchone()
start_date = row[0]
end_date = row[1]
in Python. if you know for sure that the SQL statement only fetches two
columns, you can simply do
start_date, end_date = cursor.fetchone()
</F>
--
http://mail.python.org/mailman/listinfo/python-list
