I have searched high and low for this answer but turned up nothing concrete.
I am using MS SQL Server and ASP.
I have a database with a table which includes a field with a TEXT datatype.
I have created a simple stored procedure to select all the fields in the table into a recordset.
I have been able to output these on a web page using ASP, EXCEPT the TEXT field named "Content".
Can anyone tell me how I output the field to the web page?
The stored procedure:
CREATE PROCEDURE gettherecords @KeyPhrase varchar(100) AS BEGIN SELECT * From TheTable WHERE KeyPhrase = @KeyPhrase END
Set rsResults = Server.CreateObject("ADODB.recordset") rsResults.open "Exec gettherecords '" & varKeyPhrase & "'", connect response.write rsResults("Content")
As I say, the other fields output fine...
Thanks for your help, chaps.