Stored Procedure

using dreamweaver mx

[Krapulator]

Im passing some form variables to a sql stored procdure, but I need to know the correct parameters to pass values to a text field (as opposed to varchar etc).

In dreamweaver you end up with:

CommandName.Parameters.Append
CommandName.CreateParameter("@sString", 200, 1,10,sString)

with 200 being the code for a varchar string and a length of 10.

How do I pass a string (of unknown size) to a text field?

Thanks for your help

[wardbekker]

Hi Krapulator,

The length you specify for the varchar should be smaller or equal to the length of the variable in you stored procedure. Varchar can handle a max of 8000 characters, so the max value you can specify is 8000. Still too small? If you use a text variable in stead of varchar, you can send a max of 2,147,483,647 charachters to you stored procedure.

Good luck!