From: | Abdul Wahab Dahalan <wahab(at)mimos(dot)my> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | What this parser mean? |
Date: | 2003-03-21 02:47:14 |
Message-ID: | 3E7A7D32.4A3E8E8C@mimos.my |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | David Witham | 2003-03-21 02:52:56 | Re: What this parser mean? |
Previous Message | David Olbersen | 2003-03-20 23:19:13 | Re: Help with LIKE |