Posted by blueghost73@yahoo.com on 07/19/06 04:20

Kivak wrote:
> 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

I'm no expert, so I'm just guessing here, but there are two things I'd
look for. First, is your userNameTest in quotes inside those
parentheses? Second, is there a column in the table that is called
userNameTest?

--Richard

[Back to original message]