parameter syntax for a type TEXT column
Posted on 2013-01-08
I'm currently using parameterized queries in my code and am looking for assistance on how to create one a type TEXT column in a sql server database. Right now I have:
.Parameters.Append .CreateParameter( "newsletter", adLongVarChar, adParamInput, , newsletter )
adLongVarChar is defined in my adovbs.inc file, and I'm certain this parameter is giving me problems as my query works if I don't include it.
Any assistance is greatly appreciated!