X-Original-To: pgsql-sql@postgresql.org
Received: from filter.mimos.my (filter.mimos.my [192.228.137.70])
	by postgresql.org (Postfix) with ESMTP id 34F19475AFF
	for <pgsql-sql@postgresql.org>; Thu, 20 Mar 2003 21:47:17 -0500 (EST)
Received: from ew.mimos.my (localhost.localdomain [127.0.0.1])
	by filter.mimos.my (8.11.6/8.11.6) with ESMTP id h2L2UcV08012
	for <pgsql-sql@postgresql.org>; Fri, 21 Mar 2003 10:30:38 +0800
Received: (from root@localhost)
	by ew.mimos.my (8.12.3/8.12.3) id h2L2lFti088087
	for pgsql-sql@postgresql.org; Fri, 21 Mar 2003 10:47:15 +0800 (MYT)
	(envelope-from wahab@mimos.my)
Received: from mimos.my (sol-wel197.nat.mimos.my [10.1.23.197])
	by ew.mimos.my (8.12.3/8.11.6) with ESMTP id h2L2lEeg088029
	for <pgsql-sql@postgresql.org>; Fri, 21 Mar 2003 10:47:15 +0800 (MYT)
	(envelope-from wahab@mimos.my)
Message-ID: <3E7A7D32.4A3E8E8C@mimos.my>
Date: Fri, 21 Mar 2003 10:47:14 +0800
From: Abdul Wahab Dahalan <wahab@mimos.my>
Reply-To: wahab@mimos.my
Organization: Mimos Berhad
X-Mailer: Mozilla 4.77 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: What this parser mean?
X-scanner: scanned by Inflex 1.0.10 - (http://pldaniels.com/inflex/)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200303/481
X-Sequence-Number: 12520

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