First question:<BR>What size do I set the adLongVarChar parameter to? (MAX_LONG doesn't exist in VB)<BR><BR>Second question:<BR>When I enter this stored procedure:<BR>CREATE PROC sp_GetChapter (<BR> @title varchar(50) OUTPUT,<BR> @contents text OUTPUT<BR>)<BR>AS<BR>SELECT @title = title, @content = content FROM page<BR><BR>SQL 7.0 says "The assignment operation operation cannot take a text data type as an argument". How do I return the text-field?
Hmm, I just did a little test and SQL doesn't complain about it, strange. Well you could always return it as a recordset:<BR><BR>CREATE PROC sp_GetChapter (<BR>AS<BR>SELECT title, content FROM page<BR><BR>In VB you can reference this values through the recordset object. rs!title and rs!content (or rs(0) and rs(1))<BR><BR><BR><BR>
Strange that you don't get the same error. This ASP-script and stored procedure will be getting hammered quite often so I'd prefer not having to create a recordset server object every time it's called...
when I test a little bit further I also get that error. I wouldn't know a solution, but creating the rs object. <BR><BR>I dont think it will be a really big performance hit. How often if "Quit Often" ? I the page gets 1000 unique visitors a day, I think you don't need to worry, when you get 100.000 visitors a day you probably can afford a really big server.....<BR><BR>Hmmm, how much data is in the text field?? You could split it into multiple nvarchar(8000) parameters.... But I think the concatenation you would have to do in the vbs script is going to be a bigger performance hit.