Post reply

WEB PAGE and RECORDSET Problem

  • July 21, 2005 at 4:34 am

    #88299

    Hi all, I have a strange problem which i will explain below.

    I have a web page which pulls back data from a table using a Stored Procedure.

    The Stored procedure works as expected when opened up in the database, but when i call the Stored Procedure from the web page three particular columns are missing (all appear to be text columns).

    I have also created a dummy text column, thinking it was that data type at fault, this column works in the web page.

    Is there anything I could do or try to correct this problem?

    Cheers all.

  • July 21, 2005 at 12:19 pm

    #576191

    That seems to be one of the ADO "gotcha"s. Make sure that in the select statement in the stored procedure the TEXT columns are the LAST columns 

    Like:

    select col1,col2,........, coltext1,coltext2,coltext3

    from ...

     


    * Noel

  • July 22, 2005 at 4:17 am

    #576350

    Hi, thats very interesting, I would never have thought of that.

    Thanks very much for you time and effort.

  • July 22, 2005 at 6:23 am

    #576379

    make sure ur data types in your web page match the ones in your database.

    I would be able to help you further if tell me what application ur using to develop your web page

  • July 22, 2005 at 6:27 am

    #576383

    No probs, putting the text columns last in the Stored procedure seemed to work fine.

    Cheers

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

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