Thread: What this parser mean?

What this parser mean?

From

Abdul Wahab Dahalan

Date:

21 March 2003, 00:47:20

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

Re: What this parser mean?

From

"David Witham"

Date:

21 March 2003, 00:52:56

Hi Abdul,

You may have lost the '' around the date specification in the to_char function when forming the string in Java. Before
submittingthe query, check the contents of the query string to make sure you still have the '' marks. 

Regards,
David Witham

-----Original Message-----
From: Abdul Wahab Dahalan [mailto:wahab@mimos.my]
Sent: Friday, 21 March 2003 13:47
To: pgsql-sql@postgresql.org
Subject: [SQL] What this parser mean?


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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: What this parser mean?

From

Guy Fraser

Date:

24 March 2003, 13:56:14

Hi

FYI

This line will not work in PostgreSQL 7.3 :

+ " limit " + recordPerpage + "," + beginRecord;

Change it to :

+ " limit " + recordPerpage + " offset " + beginRecord;

This works in pre PostgreSQL 7.3 versions as well.


Guy

Abdul Wahab Dahalan wrote:

>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>  
>