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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-20 : 09:28:01
|
Paul writes "i've spent a day and a half now on just trying to successfully validate users from an asp page. and after pounding my head on the desk, consulting with others, and another round of pounding, i still get this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'test'.
/layout.asp, line 18
it points to this line of code:
mySQL = "SELECT * FROM [OBES_MIGRATE].[dbo].[tbl_USER] where USER_ID = " & chr(34) & myuser & chr(34)
Set objRS = objConn.Execute(mySQL) (<-- line 18)
myuser comes in from a form. it seems as if the recordset wants to assign myuser (which in this case, was 'test') as a column name of the return set and not a field name, as it actually is.
it's already a reported error for sql server at ms but i couldn't find anything relating to asp and being able to correct it.
PLEASE HELP!!!!!!!!!
thanks,
paul" |
|
|
|
|
|
Error...[SQL Server]Invalid column name