Stored procedure

[Ekstrom]

Hi

I want to return a ntext datatype to ASP. How do I do that?

ASP:
.Parameters.Append .CreateParameter("@textpart", adLongVarChar, adParamOutput)

SQLServer 7.0:
CREATE PROCEDURE sp_select_info
(
@

http://www_multi_info_id

int,
@headline varchar(250) output,
@ingress varchar(1500) output,
@textpart text output
)
As
SELECT @headline=headline, @ingress=ingress, @textpart=textpart FROM

http://WWW_MULTI_INFO

WHERE

http://WWW_MULTI_INFO_ID

= @

http://www_multi_info_id

thanks in advance!
/Martin

 

[Cagliostro]

CREATE PROCEDURE sp_select_info
(
@

http://www_multi_info_id

int,
@headline varchar(250) output,
@ingress varchar(1500) output,
@textpart text output
)
returns string
as
..... John Fill

ivfmd@mail.md