| YesSoftware Forums -> CodeCharge Studio -> ASP |
|
The name '#07' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. (Microsoft OLE DB Provider for SQL Server)"
|
  |
Joe
|
| Posted: 07/23/2004, 9:59 AM |
|
I am getting the following error?? anybody have any clues. I am using MS SQL, CCS, ASP
"The name '#07' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. (Microsoft OLE DB Provider for SQL Server)"
|
|
|
|
Pinochet
Posts: 13
|
| Posted: 07/23/2004, 3:25 PM |
|
If you haven't already discovered the cause of your error....
I've received that error while working in MSSQL Query Analyzer designing queries. I believe it is caused by incorrect Transact-SQL syntax in a SQL statement. Specifically I remeber getting the error while designing a 'while' loop and using 'begin' and 'end' statements....Sorry to be so vague.
If you are using a custom SQL please post it here and I/someone can help debug.
_________________
don't worry it doesn't mean anything anyway |
 |
|
kubrt
|
| Posted: 08/03/2004, 6:06 AM |
|
You have probably mistaken quotes and double qoutes.
SQL server takes "column value" as column name.
|
|
|
|
aditya
|
| Posted: 08/17/2004, 12:28 AM |
|
I am having the error as
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'aditya' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
/Assignment/real_project/aditya_next.asp, line 57
Can anybody help me immediately?
|
|
|
|
Praveenkumar Sivakumar
|
| Posted: 08/24/2004, 12:07 AM |
|
"Only constants, expressions, or variables allowed here. Column names are not permitted"
The Error shown above is due to incorrect syntax used in the query. Please ensure that the Wildcard's are specified correctly.
Here i write an example of using a insert query in MS-SQL . Kindly try your query in the same way and it will work.
Query: insert into emp_details (emp_name,emp_id,emp_email,emp_dept,emp_pwd) Values ('" + ename + "', '" + eid + "','" + eemail + "','" + edept + "','" + pwd + "');
|
|
|
|
|
 |
|
|
|
