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-10-12 : 10:41:20
|
| veerag writes "set dbbasket = server.createobject("adodb.connection")set rsbasket = server.createobject("adodb.recordset")dbbasket.open "provider=SQLOLEDB.1;uid=sa;pwd=sa;server=sagar;database=shop1"sql = "execute sp_checkbasketitemquantity" & idproduct & ", " & session("idbasket")set rsbasket = dbbasket.Execute(sql) Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near ','. /ANAND/additem1.asp, line 38 my question is why it is showing syntax error and what is the use of & operator and single and double quotes.whether the execution is right or wrong.this is the most important question?how to see the value of session("id1") ?please reply to my questions." |
|
|
|
|
|
incorrect syntax error