Re: Problem returning a cursor through ODBC to ASP layer from postgres

I have created a function in postgres called getallusers(var) that returns a cursor. This works fine at the psql level but when I try to return it through ODBC I get errors.  

 

The function is as follows:

 

CREATE OR REPLACE FUNCTION getallusers(refcursor) RETURN refcursor AS'

 

begin

open $1 for select * from users;

return $1;

end;

' language 'plpgsql';

 

 

I call it like this:

 

<%
strconn="DSN=p_test;uid=postgres;pwd="
mySQL = "begin "&vbcrlf
mySQL = mySQL & "select getallusers('rs'); "
mySQL = mySQL & "fetch all in rs; "
mySQL = mySQL & "commit; "

call query2table(mySQL,strconn)
%>

 

This does not seem to return anything.

Thanks

!-------------------------------------!
David Williams

---

Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com