May 8, 2002 at 2:10 pm
Hello,
I am attempting to show data that I insert into a TEMP table, to be shown thru an ASP page. I am not sure hot to make the call to a TEMP table from within the ASP code. Can anyone assist with this?
Thanks in Advance
Andrew
How long a minute is....
Depends on what side of the bathroom door you are on.
May 8, 2002 at 2:50 pm
When you say TEMP table how are you generating it. If thru a stored proc make sure you have SET NOCOUNT ON at the begining after the as and do a SELECT xxxx FROM TEMPTABLE then do a drop table to free the resources ASAP. This will return the set to ASP. If you are creating thru some other process thne unless the ASP call is the same connection under the same spid you will not be able to see a #TEMP table but a ##TEMP tables should be visible as long as some connection that referenced does not drop before the ASP page connection.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply