Обсуждение: Cant execute the query
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.
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