I'm having an issue with the data types in ASP. I have several columns which are either a data type of ntext or nvarchar in SQL 2008. When creating a form using DreamWeaver - ASP, I am having to create a variable on each column that is of a data type ntext or nvarchar. I read in a different forum that VARCHAR would need to be used but that did not work.
Why does ntext or nvarchar not work without a variable in ASP? Anyone know of a better way to handle this?
Any assistance or info would be greatly appreciated!