Retrieving data from a text datatype field through asp

<i><b>Originally posted by : Erik (erk@flashmail.com)</b></i><br /><br />I've employed the use of text fields for their large storage capacity to store large blocks of html code which i call dynamically to affect the look of a page quickly. I used the WRITETEXT sql statement to insert the block of html into the field... something like:<br /><br />set con =server.createobject("adodb.connection")<br /><br />sel="DECLARE @ptrval varbinary(16) SELECT @ptrval = TEXTPTR(livairhtml) FROM catalog READTEXT catalog.livairhtml @ptrval 0 5000"<br /><br /><br />con.open "users","sa","blahblahblah"<br />con.execute<br /><br />@ptrval is the local variable which equals the text pointer of the livairhtml field<br /><br />The problem i am having is in retrieving this data for display.<br /><br />I attempted using the reciprocal statement of the WRITETEXT statement which is the READTEXT statement but was unable to figure out how to return the results of the query so they could be displayed on the page.. Any help would be much appreciated.<br /><br />Thanks,<br />Erik Taylor<br />web goo (not a gooroo yet)

IN SQL Online Books I found

READTEXT catalog.livairhtml @ptrval 1 5000

Notice the "1" instead of "0".

Next problem, if I got that right, is that your text contains tags. Without precaution your string will be interpreted by the browser and not display at all or with an error