thanks for the reply, But It still doesn't work. it gives error such:
Traceback (most recent call last):
File "main.py", line 107, in on_listWidget_itemClicked
""" %chosen)
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use
near
'\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2'
at line 4")
I use MySQLdb, I take input from listWidget when clicked and convert to string
and store it in "chosen"
chosen= str(item.text());
print chosen # prints on command line for
debugging
and the error is on the last line
db.query("""
SELECT OS, IP_Adress
FROM ServerDB
WHERE IP_Adress = '%s'
""" % chosen)
thanks,
On Thursday 07 February 2008 11:03:55 Phil Thompson wrote:
> On Thursday 07 February 2008, Enis Karaarslan wrote:
> > Hello all,
> >
> > I am a newbie in PyQt, just a simple question.
> > I want to use a variable in my sql tatement.
> >
> > If I use string, following statment runs smoothly
> >
> > db.query("""SELECT OS, IP_Adress
> > FROM ServerDB
> > WHERE IP_Adresi='10.22.5.1'""")
> > s = db.store_result()
> >
> >
> > But I want to use the variable "chosen" and get the IP_Adresses equal to
> > that variable such as:
> >
> > db.query("""
> > SELECT OS, IP_Adress
> > FROM ServerDB
> > WHERE IP_Adress = chosen
> > """)
> >
> > But it doesn't work ...
> >
> > thanks for the help
>
> Dynamically create the string you want...
>
> db.query("""
> SELECT OS, IP_Adress
> FROM ServerDB
> WHERE IP_Adress = '%s'
> """ % chosen)
>
> Phil
> _______________________________________________
> PyQt mailing list PyQt@riverbankcomputing.com
> http://www.riverbankcomputing.com/mailman/listinfo/pyqt
--
--------------------------------------------
* Ar.Gör.Enis Karaarslan
* Ege University
* Kampüs Network Yönetim Grubu
* ULAK-CSIRT - http://csirt.ulakbim.gov.tr
--------------------------------------------
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ PyQt mailing list PyQt@riverbankcomputing.com http://www.riverbankcomputing.com/mailman/listinfo/pyqt
