Updating SQL Text fields using ADO in ASP

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "tuuky" <tuuky@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 16 Jun 2005 18:09:01 -0700

I am trying to use a parameter list to insert and update a Text field
(datatype text) in a SQL table through a stored procedure.

The asp form contains a text box that posts back to the page.

..Parameter.Append .CreateParameter("@news_text", [text type here], newsText)

First, I can't seem to find the constant value for such data type.
I tried using a adLongVarChar, but I received a conversion error.

Any help would be appreciated.

Rod
.

Follow-Ups:
- Re: Updating SQL Text fields using ADO in ASP
  - From: Andrew D. Newbould

Prev by Date: VB 6.0: not able to initialize a textbox
Next by Date: newbie problem with compiling example for VC++ 2005
Previous by thread: VB 6.0: not able to initialize a textbox
Next by thread: Re: Updating SQL Text fields using ADO in ASP
Index(es):
- Date
- Thread

Relevant Pages

Re: JDBD: time format
... What might be happening is that if the Stored Procedure is returning ... your time as an SQL Date or SQL Time datatype, ... will always return a String using a: ...
(comp.sys.ibm.as400.misc)
Re: converting/casting before submitting
... an object and tell the client lib the actual datatype of your data. ... pass sql datatype to the sqlserver. ... | before passing it as a parameter to a SQL stored procedure. ...
(microsoft.public.dotnet.framework.aspnet)
using table datatype..
... Can any of you help me with examples in using the table datatype in SQL ... Server 2000. ... I am trying to take the output of a stored procedure, ...
(microsoft.public.sqlserver.programming)
Re: Updating SQL Text fields using ADO in ASP
... (datatype text) ... in a SQL table through a stored procedure. ... I can't seem to find the constant value for such data type. ... ASP variables are typeless and therefore you are actually passing a Variant yet telling ADO (and therefore SQL) its a String. ...
(microsoft.public.vstudio.development)
Re: Views vs Stored Procedures, whats the difference?
... I hope you are not suggesting you embed SQL queries into the application? ... A stored procedure logic will be exactly as fast as the algorithm you ... I understant that SQL Server supports hints. ... implementations (nestedloop, merge, hash, ..) on decent sized tables, then ...
(comp.databases.ms-sqlserver)