I have the following query:
sqlLote = ("select lot.idLote from Lote lot \
inner join [dbo].[Usuario] u on lot.idUsuario = u.idUsuario \
where u.userName = '%s'") % \
(usuario)
The result of this query by sql gives
1 4 5 6 9
When I print it to the screen, the data looks like this:
cursorUsuario = connUsuario.execute(sqlLote)
print([x for x in cursorUsuario])
[(1, ), (4, ), (5, ), (6, ), (9, )]
Why is it not displayed as follows?
[1,4,5,6,9]
If you want it to be displayed that way, you should do the following: