HOW TO RETRIEVE VALUE FROM TEMP TABLE ON THE INTERFACE
"Vasudeva, Rahul" <[email protected]> Tue, 10 Jan 2006 10:30:54 +0530
| Newsgroups | gmane.comp.db.postgresql.cygwin |
|---|---|
| Message-ID | <782A2941488DA54D8916B99CCA46D21B0294EEAE@BOMEX001.corp.capgemini.com> |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C615A2.2A8DDE64
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
=0D
I am executing a stored procedure from an ASP page without any input
parameters, in that stored procedure two sql queries are executed and
the result is stored in a temporary table, now I want to retrieve the
recordset of that temp table on the interface=2E=0D
=0D
There is an error every time on the Interface "Invalid Object" ,
although I am dropping the temp table explicitly =2E
=0D
Thanks & Regards
Rahul Vasudeva=2E
=0D
This message contains information that may be privileged or confidential=
and is the property of the Capgemini Group=2E It is intended only for the=
person to whom it is addressed=2E If you are not the intended recipient, =
you are not authorized to read, print, retain, copy, disseminate, =
distribute, or use this message or any part thereof=2E If you receive this=
message in error, please notify the sender immediately and delete all =
copies of this message=2E
------_=_NextPart_001_01C615A2.2A8DDE64
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns=3D"http://www=2Ew3=
=2Eorg/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p=2EMsoNormal, li=2EMsoNormal, div=2EMsoNormal
{margin:0in;
margin-bottom:=2E0001pt;
font-size:12=2E0pt;
font-family:"Times New Roman";}
a:link, span=2EMsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span=2EMsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span=2EEmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8=2E5in 11=2E0in;
margin:1=2E0in 1=2E25in 1=2E0in 1=2E25in;}
div=2ESection1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=
=3D'font-size:10=2E0pt;
font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=
=3D'font-size:10=2E0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=
=3D'font-size:10=2E0pt;
font-family:Arial'> I am executing a stored procedure=
from an
ASP page without any input parameters, in that stored procedure two sql=
queries
are executed and the result is stored in a temporary table, now I want to
retrieve the recordset of that temp table on the interface=2E=
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=
=3D'font-size:10=2E0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=
=3D'font-size:10=2E0pt;
font-family:Arial'>There is an error every time on the Interface=
“Invalid
Object” , although I am dropping the temp table explicitly =2E=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=
=3D'font-size:10=2E0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=
=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3D2 color=3Dnavy face=3DArial><span style=3D'font-size:10=
=2E0pt;font-family:Arial;
color:navy'>Thanks & Regards</span></font><font size=3D1 color=
=3Dnavy><span
style=3D'font-size:7=2E5pt;color:navy'><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=
=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12=2E0pt'>Rahul=
Vasudeva=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=
=3D'font-size:
12=2E0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
<table><tr><td bgcolor=3D#ffffff><font color=3D#000000>This message=
contains information that may be privileged or confidential and is the=
property of the Capgemini Group=2E It is intended only for the person to=
whom it is addressed=2E If you are not the intended recipient, you are=
not authorized to read, print, retain, copy, disseminate, distribute, or=
use this message or any part thereof=2E If you receive this message in=
error, please notify the sender immediately and delete all copies of this=
message=2E<br>
<br>
</font></td></tr></table>
------_=_NextPart_001_01C615A2.2A8DDE64--