Not specified

<i><b>Originally posted by : Felicia (ong_felicia@hotmail.com)</b></i><br />Can an expert help me on this...<br /><br />I don't quite understand about the below error...<br /><br />Select * from [_UserInfo] where Loginname like 'Felicia'Select * from [_CompanyInfo] where PriSalesRep like 'Kelvin Yue'SecSalesRep like 'Dave Heng' <br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br />[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'SecSalesRep'. <br />/sis/CfmSalesRep.asp, line 19 <br /><br />below is my code:<br /><br /><% <br /> set RST = Server.CreateObject("ADODB.Recordset")<br /> loginname = Request.QueryString("loginname")<br /> sql ="Select * from [_UserInfo] where Loginname like '" & loginname & "'"<br /> response.write sql<br /> RST.Open sql,Session("FlipConnection"),ADOPENSTATIC,ADLOCKPESSIMISTIC,ADCMDTEXT<br /> RST("Rights")=100<br /> RST("Confirmed")=1<br /> RST.Update<br /> <br /> set RST1 = Server.CreateObject("ADODB.Recordset")<br /> PriSalesRep = Request.QueryString("PriSalesRep")<br /> SecSalesRep = Request.QueryString("SecSalesRep")<br /> sql1 ="Select * from [_CompanyInfo] where PriSalesRep like '" & PriSalesRep & "'" & "SecSalesRep like '" & SecSalesRep & "'"<br /> response.write sql1<br /> RST1.Open sql1,Session("FlipConnection"),ADOPENSTATIC,ADLOCKPESSIMISTIC,ADCMDTEXT<br /> RST1("Confirmed")=1<br /> RST1("PriSalesRep")=PriSalesRep<br /> RST1("SecSalesRep")=SecSalesRep<br /> RST1.Update<br /><br /><br /><br /> RST.Close<br /> Set RST = Nothing<br /> RST1.close<br /> set RST1 = nothing<br /> <br /><br />%><br /><br />many thanks..<br />

<i><b>Originally posted by : David B (david_baylor@yahoo.com)</b></i><br />Proper syntax for the second call is<br /><br /><br />select * from table where field1 like 'xxx' and field2 like 'yyy'<br /><br />You forgot the word "and"<br /><br /><br />------------<br />Felicia at 3/26/2000 7:57:55 PM<br /><br />Can an expert help me on this...<br /><br />I don't quite understand about the below error...<br /><br />Select * from [_UserInfo] where Loginname like 'Felicia'Select * from [_CompanyInfo] where PriSalesRep like 'Kelvin Yue'SecSalesRep like 'Dave Heng' <br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br />[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'SecSalesRep'. <br />/sis/CfmSalesRep.asp, line 19 <br /><br />below is my code:<br /><br /><% <br /> set RST = Server.CreateObject("ADODB.Recordset")<br /> loginname = Request.QueryString("loginname")<br /> sql ="Select * from [_UserInfo] where Loginname like '" & loginname & "'"<br /> response.write sql<br /> RST.Open sql,Session("FlipConnection"),ADOPENSTATIC,ADLOCKPESSIMISTIC,ADCMDTEXT<br /> RST("Rights")=100<br /> RST("Confirmed")=1<br /> RST.Update<br /> <br /> set RST1 = Server.CreateObject("ADODB.Recordset")<br /> PriSalesRep = Request.QueryString("PriSalesRep")<br /> SecSalesRep = Request.QueryString("SecSalesRep")<br /> response.write sql1<br /> RST1.Open sql1,Session("FlipConnection"),ADOPENSTATIC,ADLOCKPESSIMISTIC,ADCMDTEXT<br /> RST1("Confirmed")=1<br /> RST1("PriSalesRep")=PriSalesRep<br /> RST1("SecSalesRep")=SecSalesRep<br /> RST1.Update<br /><br /><br /><br /> RST.Close<br /> Set RST = Nothing<br /> RST1.close<br /> set RST1 = nothing<br /> <br /><br />%><br /><br />many thanks..<br />