"niko" <[EMAIL PROTECTED]> wrote:
> while using gadfly, got an error that i don't understand.
> Code is as follow :
> cursor = connection.cursor()
> cursor.execute('select id_m from mots where nom_m = "%s"' % nom_m)
> id_m = cursor.fetchall()
>
> Error message :
> File "C:\Python24\Lib\site-packages\gadfly\kjParser.py", line 567, in
> getmember
> (Token,skip) = self.LexDict.Token(self.String, self.Position)
> File "C:\Python24\Lib\site-packages\gadfly\kjParser.py", line 433, in
> Token
> raise LexTokenError, "Lexical token not found "+info
> gadfly.kjParser.LexTokenError: Lexical token not found near ::
> ' where nom_m = '*'"Ancient s Pled'
>
> Stored value seems to interfere with somethong ? Am i wrong ? Did i
> missed something ? Thanks in advance for any help.
the "%" operator does the substitution *before* the execute method is
called.
maybe you meant
> cursor.execute('select id_m from mots where nom_m = %s', nom_m)
?
</F>
--
http://mail.python.org/mailman/listinfo/python-list
