[Tutor PyCZ] Problem s formatovanim

[slacker]

users = cursor.execute("SELECT user FROM table  WHERE user = '%s'" % test)

preju hezky den.


smoke wrote:
> Zdravim,
> 
> narazil sem na jeden problem, ktery se mi bohuzel nedari vyresit.
> Neznate prosim nekdo reseni?
> 
> O co jde:
> 
> Pomoci modulu MySQLdb provadim select z db. Problem nastane tehdy, kdy
> pomoci formatovani do selectu dosadim promenou:
> 
> import MySQLdb
> 
> conn = MySQLdb.connect (host = "host",
>                            user = "user",
>                            passwd = "******",
>                            db = "db")
> 
> cursor = conn.cursor()
> test = "user1"
> users = cursor.execute("SELECT user FROM table  WHERE user = '%s'")    %
> test
> ....
> 
> a zde to bohuzel vyhodi tuto chybu:
> TypeError: unsupported operand type(s) for %: 'long' and 'str'
> 
> Vypada to jako drobnost ;o), ale nedari se mi na ni prijit - diky za
> kazdou radu nebo nasmerovani.