Posted by Kivak on 07/19/06 03:44

Hi,

I am having a SQL Server 2005 problem with my Insert statement. I am
sending a command via my website to my database. It comes up with an
error I'll put below. The code is here:

"INSERT INTO tblUsers (userName) VALUES ( userNameTest)"

This is the error I get:

The name "userNameTest" is not permitted in this context. Valid
expressions are constants, constant expressions, and (in some contexts)
variables. Column names are not permitted.

Now, userName is a varchar field in the database. What is wrong?

Kivak

[Back to original message]