delete statement help

[orangeblue]

can someone tell me why i am getting this error

Microsoft VBScript runtime error '800a01a8'
Object required: ''
/admin2/include/portfoliolist_delete.asp, line 36

here is the delete code
set deletePortfolio=server.createobject("adodb.recordset")
sql="DELETE FROM dbstock_portfolio where portfolio_id='"&request.Form("portfolio_id")&"' "
set deletePortfolio=objConnection.Execute (sql, , adCmdText)

thanks

 

[FesterSXS]

you dont need this line set deletePortfolio=server.createobject("adodb.recordset") as no recordset is necessary to delete a record.

Also - have you set up the connection objConnection??

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com

 

[orangeblue]

thanks

this is what I have now

set objConnection=server.CreateObject("ADODB.Connection")
sql="DELETE FROM dbstock_portfolio where portfolio_id='"&request.Form("portfolio_id")&"' "
objConnection.Execute (sql, adCmdText)

but getting this error now
Microsoft VBScript compilation error '800a0414'

Cannot use parentheses when calling a Sub

/admin2/include/portfoliolist_delete.asp, line 37

objConnection.Execute (sql, adCmdText)
--------------------------------------^

 

[FesterSXS]

just try objConnection.Execute (sql)

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com

 

[orangeblue]

doh!

thanks its working now
again thanks for your help