MYSTERY ZILLION တွင် English သို့မဟုတ် Unicode ဖြင့်သာ အသုံးပြုခွင့်ရှိသည်။ ဇော်ဂျီ ၊ ဧရာ စသည်တို့ကို အသုံးပြုခွင့် မရှိ။ Unicode fonts များမှာ Mon3,Yunghkio, Myanamr3 စသည်များ အသုံးပြုနိုင်သည်။ Unicode Guide ကို ဒီမှာ Download ချပါ။ Zawgyi to Unicode Converter
Don't share ebook or software if nobody request. You can find free book websites on here. We are welcome for discussion or asking question instead.

No such column person.p_id: SQLException in java

edited November 2011 in Help Desk
I made a query on sqlite db from a java program. I got this above exception. I'm sure there exists the person table and p_id field.

My query is...

select * from (person inner join company on person.p_id=company.p_id) inner join contact on person.p_id=contact.p_id where person.p_id=?

When I put this query on navicatLite by placing person.p_id=' 1 ' instead of person.p_id=? , it was ok. It showed me correct values.

But from java program, I got above exception.
Thanks for your help.

sqlite version 3.7.8
sqlitejdbc-v056
Tagged:
Sign In or Register to comment.