error in sql

<i><b>Originally posted by : stephen (profliz@hotmail.com)</b></i><br />my coding:<br /><br />SQL1 = "SELECT m_id, m_email, m_subject, m_numReplies, m_entrydate FROM messages "<br />SQL2 = SQL1 & "WHERE m_reply=-1 ORDER BY m_id DESC;"<br />set rs = Server.CreateObject("ADODB.Recordset")<br />connectme="DSN=feedbackDSN"<br />rs.Open SQL2,connectme ---> line 30<br /><br />error mesg give :<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e10' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <br /><br />/vote/messagelist.asp, line 30 <br /><br />anyone have any idea what is wrong? plz help<br />

<i><b>Originally posted by : darren (darreng@grosvenorent.com)</b></i><br /><br />the error will report as line 30 but is actually the sql statement. do a response.write(sql2) just before line 30 and see hwat you have. this error means you are not matching what sql expects. may need '' around the -1<br /><br />------------<br />stephen at 12/14/2000 9:38:18 PM<br /><br />my coding:<br /><br />SQL1 = "SELECT m_id, m_email, m_subject, m_numReplies, m_entrydate FROM messages "<br />SQL2 = SQL1 & "WHERE m_reply=-1 ORDER BY m_id DESC;"<br />set rs = Server.CreateObject("ADODB.Recordset")<br />connectme="DSN=feedbackDSN"<br />rs.Open SQL2,connectme ---> line 30<br /><br />error mesg give :<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e10' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <br /><br />/vote/messagelist.asp, line 30 <br /><br />anyone have any idea what is wrong? plz help<br />