Delete record in a table

E

Esperanza

Hello ASP Expert,
I just would like to delete a record in a table.
Any Idea ??
Thanks in advance !!
Esperanza


I got the error message :
The application is using arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another.
Or the error message:
The operation requested by the application is not supported by the provider

'------------------------CODE-----------------------------------------------
------------
<body>
<!-- #INCLUDE FILE = "FonctionsConn.asp" -->

<%


dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")


dim intIndex

objConn.Open chaineConnRapports

objRS.Open "SELECT * FROM Document WHERE ID_DOC LIKE 'PaCh'", objConn,
adOpenDynamic, adLockOptimistic, adCmdTable
'objRS.Open "SELECT * FROM Document WHERE ID_DOC LIKE 'PaCh'", objConn

While not ObjRS.eof
response.write "Document :" & objRS("ID_DOC")
objRS.delete
objRS.MoveNext
Wend

objRS.Close
objConn.Close
Set objRS = Nothing
set objConn = Nothing

%>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't find largest database record 7
Problem with data type mismatch - error 80040e07 1
Data type mismatch in criteria expression. 3
Connecting guestbook to MySQL 0
Microsoft JET Database Engine error '80040e07' 4
where to buy asp page 0
Need code assistance to update pivot table from an ADO recordset 4
User defined datatype? 2

Top