What this parser mean?
От | Abdul Wahab Dahalan |
---|---|
Тема | What this parser mean? |
Дата | |
Msg-id | 3E7A7D32.4A3E8E8C@mimos.my обсуждение исходный текст |
Список | pgsql-sql |
I wrote a java program to query a data from 4 tables and the string query is like: querydata ="select bizfavorite.bizid,bizprofile.bizname,bizprofile.bizphone,bizprofile.bizfax,bizfavorite.searchtype," + "bizfavorite.keyword,to_char(bizfavorite.listdate,'DD-MM-YYYY') as listdate,bizfavorite.offerid,offer.otype,offer.bizid as obizid,"+ "to_char(offer.oposted_date,'DD-MM-YYYY') as oposted_date,to_char(offer.oexpiry_date,'DD-MM-YYYY') as oexpiry_date,"+ "userprofile.username,userprofile.ufullname,userprofile.uemail"+" from bizfavorite join bizprofile using(bizid) join userprofile using(bizid) left join offer using(offerid)"+ " where bizfavorite.username= ? and urole='1' order by listdate desc" + " limit " + recordPerpage + "," + beginRecord; When I run this query, I got this message : Message: ERROR: parser: parse error at or near "-" but when I ran this query from psql command prompt its ok.I got what I want. b2bscm=> select bizprofile.bizname,bizprofile.bizphone,bizprofile.bizfax,bizfavorite.searchtype,bizfavorite.keyword,to_char(bizfavorite.listdate,'DD-MM-YYYY') as listdate,bizfavorite.offerid,offer.otype,offer.bizid as obizid,to_char(offer.oposted_date,'DD-MM-YYYY') as date,to_char(offer.oexpiry_date,'DD-MM-YYYY') as oexpiry_date,userprofile.username,userprofile.ufullname,userprofile.uemail from bizfavorite join bizprofile using(bizid) join userprofile using(bizid) left join offer using(offerid) where bizfavorite.username= 'faiz' and urole='1' order by listdate desc limit 8,0; Any help, very much appreciated..Thanks
В списке pgsql-sql по дате отправления: