Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    5

    Unanswered: 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.ac tno,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

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    You can't have parameters outside a function.
    You need to replace the $1, $2, $3, $4 with real values.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •