scoobydope
ISP
ADODB.Command error '800a0bb9' <br><br>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <br><br>/sqlchk.asp, line 19 <br><br><br><br>That is the error I get when i try to run my page that is trying to delete all of my info from my database. I am pretty much just copying the text straight from the "Beginning ASP Databases" book but I think I may have an error in my sqlDelete string: <br>Could somebody take a peek at this code and perhaps suggest where I should concentrate?<br><br><br><%@ Language=VBScript %><br><HTML><br><HEAD><br><META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"><br></HEAD><br><BODY><br><%<br>Dim objConn<br><br>Dim objCmd<br>Set objConn = Server.CreateObject("ADODB.Connection"<br> objConn.Open "suites", "usrname", "password"<br><br>strDelete = "DELETE IP_addr,lastName,firstName,phone,suite,pchook_ans FROM PChookup WHERE IP_addr = 24.113.113.141 "<br><br>Set objCmd = Server.CreateObject ("ADODB.command"<br>Set ObjCmd.ActiveConnection = objConn<br>objCmd.CommandText = strDelete<br>objCmd.CommandType = adCmdText<br><br>objCmd.Execute<br>Set objCmd = Nothing<br>objConn.Close <br>set objConn = Nothing<br><br><br><br><br><br>%><br><P> </P><br><br></BODY><br></HTML><br>