July 21, 2005 at 4:34 am
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
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
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
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
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