Unanswered: What is the ADO constant for text datatype?
I have a table (MSSQL 2000 server) with a column called "Content" whose datatype is text. Now I'm trying to insert data into the table using a stored procedure. What is the ADO constant that I should use to insert value into that column? My pieces of code are
Dim Conn, cmd
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = Application("ConnStr")
Conn.CursorLocation = adUseClientBatch
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = Conn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "MyStoredProcedure"