Delete Syntax error...grrrr....

<i><b>Originally posted by : Keith Malatesta (Malatesta@mediaone.net)</b></i><br />I keep getting a syntax error with this delete code:<br /><br /><br /><%<br /><br /> dim conn<br /> dim strQuery<br /> dim rsEvents<br /> dim sqlCmd<br /> <br />set myConnection = server.CreateObject("ADODB.connection")<br /> myConnection.open "DSN=Shoedb;UID=sa;PWD=;DATABASE=storefront"<br /> <br /> set sqlCmd = server.CreateObject("ADODB.Command")<br /> sqlCmd.activeConnection = myConnection<br /> sqlCmd.commandType = 1<br /> sqlCmd.commandText = _<br /> "DELETE * FROM ProductDetail WHERE ProductID = '"& request.form("Product_ID")'"<br /> <br /> set rsEvents = sqlCmd.execute<br /><br /> <br />%><br /><br />You have just deleted, <%=Request.Form("Product_ID")%> <%=Request.Form("Description")%>!<br /><p><a href="http://64.27.72.226/product.asp">Return to Products</a></p><br /><br />Anyone?<br />

<i><b>Originally posted by : Adam Stevenson (alstevenson@nadev.com)</b></i><br /><br /><br />Could you please post your error messages. I think the error could be in your Delete statement.<br /><br />Sincerely,<br /><br />Adam Stevenson<br />------------<br />Keith Malatesta at 9/27/2000 4:52:29 PM<br /><br />I keep getting a syntax error with this delete code:<br /><br /><br /><%<br /><br /> dim conn<br /> dim strQuery<br /> dim rsEvents<br /> dim sqlCmd<br /> <br />set myConnection = server.CreateObject("ADODB.connection")<br /> myConnection.open "DSN=Shoedb;UID=sa;PWD=;DATABASE=storefront"<br /> <br /> set sqlCmd = server.CreateObject("ADODB.Command")<br /> sqlCmd.activeConnection = myConnection<br /> sqlCmd.commandType = 1<br /> sqlCmd.commandText = _<br /> "DELETE * FROM ProductDetail WHERE ProductID = '"& request.form("Product_ID")'"<br /> <br /> set rsEvents = sqlCmd.execute<br /><br /> <br />%><br /><br />You have just deleted, <%=Request.Form("Product_ID")%>*<%=Request.Form("Description")%>!<br /><p><a href="http://64.27.72.226/product.asp">Return to Products</a></p><br /><br />Anyone?<br />