Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-12 : 09:04:24
|
Steve writes "I am attemping to update a SQL2000/Win2000 "TEXT" field (otherwise known as a BLOB) which really has Ascii text in it, with ASP driven Stored Procedures. My problem is what parameter to use to the
objCommand.Parameters.Append objCommand.CreateParameter("@defaultpage", adVarChar, adParamInput, , CStr(vDefaultPage))
statement. vDefaultPage is a VBScript string (large). Obviously I need something other than adVarchar, but none of the choices in adovbs.inc seem to work.
The test SP is as follows:
CREATE PROCEDURE sp_EditCustomerText
(@customerid int,@defaultpage text)
AS
Update CustomersText
Set defaultpage = @defaultpage
Where customerid = @customerid
GO" |
|
|
|
|
|
Updating SQL Text Fields in a Stored Procedure