← Back to team overview

sikuli-driver team mailing list archive

[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.