DataTypeEnum Value for a SQL TEXT

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.

All Forums

Old Forums

CLOSED - General SQL Server

DataTypeEnum Value for a SQL TEXT

Author

Topic

johns
Starting Member

24 Posts

Posted - 2003-08-09 : 14:09:58

What is the correct vbscript "DataTypeEnum Value" for a SQL TEXT field?

This seems to work, but I am guessing I am not doing it correctly...

cmdDC.Parameters.Append cmdDC.CreateParameter("@CONTENT", adBSTR, adParamInput, len(strContent))
cmdDC.Parameters("@CONTENT") = CStr(strContent)

In my SQL PROC I reference the field as: "@CONTENT TEXT,"

Thanks,

John S.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-08-09 : 14:23:19

Use the following:

adLongVarBinary    205 - for image columns
adLongVarChar      201 - for text columns
adLongVarWChar     203 - for ntext columns

johns
Starting Member

24 Posts

Posted - 2003-08-09 : 14:31:08

Thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources