Post reply

#temp table problem

  • September 1, 2005 at 1:40 am

    #91011

    i have one sp which iam calling from an asp page, previously the sp had a "catlst" table

    now i have replace that catlst table with

    #catlst table, to avoid lockings and other multiuser issues

    but when i fire that stored procedure in query analayzer, it shows the resultset

    but when iam using that sp from an asp page, no resultset are getting displayed

    recordset ado is not understanding the resultst from a temp table

    hint content in sp

    ---

    select * from #catlst

    ---

    what to do ?

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • September 1, 2005 at 3:01 am

    #586753

    Can you explain the error that you are getting from the asp page.

  • September 1, 2005 at 3:28 am

    #586756

    no error message, but the recordset is not getting populated with the records

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • September 2, 2005 at 6:28 am

    #587153

    make sure SET NOCOUNT ON is at the top of your stored procedure; if it's not there, your ADO recordset may be getting the results of

     "(45 rows affected)" or something similar from within your proc before your final

    select * from #catlst

    other than than, post the actual code of the SP and we might be able to see where you are having the issue.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 2, 2005 at 6:47 am

    #587160

    thanks for answering, but the reason was

    i had drroped the table after use

    select * from #catlist

    drop #catlst

    that was very stupid

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • September 2, 2005 at 7:05 am

    #587165

    Dropped it after the insert or after the select??

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply