Oct-30-2018, 12:06 AM
New to Python.
Looping row by row through query (cursor1) with fetchone() and getting values using "row", like row.idno.
Inside the main loop, made another connection and query (cursor2) to look up a value in another table that also has field idno.
How do I get values in cursor2, like having row1 for cursor1 and row2 for cursor2, like row1.idno and row2.idno ?
Looping row by row through query (cursor1) with fetchone() and getting values using "row", like row.idno.
Inside the main loop, made another connection and query (cursor2) to look up a value in another table that also has field idno.
How do I get values in cursor2, like having row1 for cursor1 and row2 for cursor2, like row1.idno and row2.idno ?