pardon just a line-break, special character problem solved. Thanks for your kind response Enis
On Thursday 07 February 2008 11:23:43 Enis Karaarslan wrote:
> 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\x
>c2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\xa0\xc2\x
>a0\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 [email protected]
> > http://www.riverbankcomputing.com/mailman/listinfo/pyqt
--
--------------------------------------------
* Ar.Gör.Enis Karaarslan
* Ege Üniversitesi
* 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 [email protected] http://www.riverbankcomputing.com/mailman/listinfo/pyqt
