sikuli-driver team mailing list archive
-
sikuli-driver team
-
Mailing list archive
-
Message #25365
[Question #247191]: type a select results from oracle database
New question #247191 on Sikuli:
https://answers.launchpad.net/sikuli/+question/247191
Hello, so here is my problem i want to type a select result from my database in my application but i got a weird error and my print the result of the query i don't get it right . here is my script and the error :
MY script :
db=zxJDBC.connect("jdbc:oracle:thin:@10.1.0.99:1521:ORCL","AGRO01", "AGRO01","oracle.jdbc.driver.OracleDriver", CHARSET='iso_1')
c = db.cursor()
c.execute("select code from fournisseur where code<'451256'")
row=c.fetchone()
print(row)
click("1397814484205.png")//my image contains a an input text where i want to type the result that i get in row
type('row',KeyModifier.WIN)
and here is what i got :
[(u'451256',)]// this is the result of the query but i just want the number 451256 i don't know why it gives me the result like this
[log] CLICK on L(223,213)@S(0)[0,0 1920x1080]
[error] script [ test ] stopped with error in line 12
[error] TypeError ( type(): 1st arg can't be coerced to String )
is there anything that can be done , please help me thank you
--
You received this question notification because you are a member of
Sikuli Drivers, which is an answer contact for Sikuli.