The use of checkboxes to delete records inoracle9i
Can someone help me with this error?
I'm trying to delete multiple records with this code in ASP connecting to an oracle database, but I'm receiving an error that says: Invalid table name
This is the code:
Dim strSelection, arrSelection
strSelection = Request.Form("toDelete")
arrSelection = Split(strSelection, ",")
Dim i
Dim strQuery
strQuery = "Delete * from sce_pre_seleccion_t where id_universidad = '01' and "
For i = 0 To UBound(arrSelection)
If i > 0 Then
strQuery = strQuery & " OR id = " & arrSelection(i)
Else
strQuery = strQuery & "id = " & arrSelection(i)
End if
Next
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Mode = adModeReadWrite
Conn.ConnectionString = "Provider=MSDAORA.1;Data Source=ORALUIS;User ID=tesis;Password=luis"
Conn.Open
Conn.Execute(strQuery)
Response.Write(strQuery)
%>
|