pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCant execute the query
2+ messages / 2 participants
[nested] [flat]
* Cant execute the query
@ 2010-07-02 12:24 Srikanth Kata <srikanth@inventum.net>
0 siblings, 1 reply; 2+ messages in thread
From: Srikanth Kata @ 2010-07-02 12:24 UTC (permalink / raw)
To: pgsql-sql
When i am executing this query, i am facing the
select
s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as
svcdescr from vwsubsmin s
inner join packages p on s.svcno=p.pkgno
inner join account a on a.actno=s.actno
inner join ssgdom d on a.domno=d.domno
inner join (select subsno from getexpiringsubs($1,cast($2 as
integer),cast($3 as double precision),$4) as (subsno int,expirydt timestamp
without time zone,balcpt double precision)) as e on s.subsno=e.subsno
where s.status <=15 and d.domno=$5
order by d.domname,s.expirydt,a.actname
Error is :
ERROR: there is no parameter $1
LINE 5: inner join (select subsno from getexpiringsubs($1,cast($2 as...
^
********** Error **********
ERROR: there is no parameter $1
SQL state: 42P02
Character: 295
Please suggest on this
--
View this message in context: http://old.nabble.com/Cant-execute-the-query-tp29055726p29055726.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Cant execute the query
@ 2010-07-08 22:08 Thomas Kellerer <spam_eater@gmx.net>
parent: Srikanth Kata <srikanth@inventum.net>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas Kellerer @ 2010-07-08 22:08 UTC (permalink / raw)
To: pgsql-sql
Srikanth Kata wrote on 02.07.2010 14:24:
>
> When i am executing this query, i am facing the
> select
> s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as
> svcdescr from vwsubsmin s
> inner join packages p on s.svcno=p.pkgno
> inner join account a on a.actno=s.actno
> inner join ssgdom d on a.domno=d.domno
> inner join (select subsno from getexpiringsubs($1,cast($2 as
> integer),cast($3 as double precision),$4) as (subsno int,expirydt timestamp
> without time zone,balcpt double precision)) as e on s.subsno=e.subsno
> where s.status<=15 and d.domno=$5
> order by d.domname,s.expirydt,a.actname
>
>
>
> Error is :
>
> ERROR: there is no parameter $1
> LINE 5: inner join (select subsno from getexpiringsubs($1,cast($2 as...
> ^
>
> ********** Error **********
>
> ERROR: there is no parameter $1
> SQL state: 42P02
> Character: 295
>
>
>
> Please suggest on this
What about the answers you got here?
http://www.dbforums.com/postgresql/1658082-cant-execute-query.html
http://old.nabble.com/Unable-to-run-this-query-td29073430.html#a29073430
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-07-08 22:08 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-02 12:24 Cant execute the query Srikanth Kata <srikanth@inventum.net>
2010-07-08 22:08 ` Thomas Kellerer <spam_eater@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox