This is a multi-part message in MIME format.
------=_NextPart_000_0002_01C4AAE2.9C863B30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I am attempting to use a stored procedure to pull a report from the
database. My questions is if its even possible to pull the data using a
function and then treat the returned data as a normal recordset with the web
pages.
The actual function looks like
CREATE OR REPLACE FUNCTION submissionreport(integer, date, text) RETURNS
RECORD AS'
DECLARE
somekey ALIAS for $1;
somedate ALIAS for $2;
somesortorder ALIAS for $3;
submission RECORD;
BEGIN
SELECT INTO submission (... stuff goes here)
ORDER BY sort;
RETURN submission;
END;
' LANGUAGE plpgsql;
The error being returned is in the web pages"
SQLState: 08S01 Native Error Code: 1 Error while executing the query;
ERROR: cannot display a value of type record"
Kent Anderson
EZYield.com
407-629-0900
www.ezyield.com
========================================
This electronic message transmission contains information from the Company
that may be proprietary, confidential and/or privileged. The information is
intended only for the use of the individual(s) or entity named above. If
you are not the intended recipient, be aware that any disclosure, copying or
distribution or use of the contents of this information is prohibited. If
you have received this electronic transmission in error, please notify the
sender immediately by replying to the address listed in the "From:" field.
------=_NextPart_000_0002_01C4AAE2.9C863B30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D359544117-05102004>I am atte=
mpting to
use a stored procedure to pull a report from the database. My questions is =
if
its even possible to pull the data using a function and then trea=
t the
returned data as a normal recordset with the web pages.</SPAN></FONT><=
/DIV>
<DIV><FONT face=3DArial size=3D2><SPAN
class=3D359544117-05102004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D359544117-05102004>The actua=
l function
looks like</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN
class=3D359544117-05102004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D359544117-05102004>CREATE OR=
REPLACE
FUNCTION submissionreport(integer, date, text) RETURNS RECORD
AS'<BR> <BR> DECLARE<BR> somekey ALIAS for $1;<BR> some=
date
ALIAS for $2;<BR> somesortorder ALIAS for $3;<BR> submission
RECORD;<BR> BEGIN<BR></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D359544117-05102004>SELECT IN=
TO
submission (... stuff goes here)<BR>ORDER BY sort;</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D359544117-05102004> &nb=
sp;
RETURN submission;<BR>END;<BR>' LANGUAGE plpgsql;</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT><SPAN class=3D359544117-05102004><FONT size=3D2><FONT face=3DAri=
al>The
error being returned is in the web pages"</FONT>
<TABLE class=3DDisplay cellSpacing=3D0 width=3D"100%" align=3Dcenter border=
=3D1>
<TBODY>
<P><FONT face=3DArial></FONT>
<P><FONT face=3DArial>SQLState: 08S01 Native Error Code: 1 Error while ex=
ecuting
the query; ERROR: cannot display a value of type record<SPAN
class=3D359544117-05102004>"</SPAN></FONT></P></TBODY></TABLE></FONT></SP=
AN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Kent Anderson</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>EZYield.com</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>407-629-0900</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><A
href=3D"http://www.ezyield.com/">www.ezyield.com</A></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>This electronic message transmission conta=
ins
information from the Company that may be proprietary, confidential and/or=
privileged. The information is intended only for the use of the individual(=
s) or
entity named above. If you are not the intended recipient, be aware t=
hat
any disclosure, copying or distribution or use of the contents of this
information is prohibited. If you have received this electronic
transmission in error, please notify the sender immediately by replying to =
the
address listed in the "From:" field.</FONT></DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0002_01C4AAE2.9C863B30--
