Message-ID: <29055726.post@talk.nabble.com>
Date: Fri, 2 Jul 2010 05:24:30 -0700 (PDT)
From: Srikanth Kata <srikanth@inventum.net>
To: pgsql-sql@postgresql.org
Subject: Cant execute the query
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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.