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, ",")
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)
strQuery = strQuery & "id = " & arrSelection(i)
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Mode = adModeReadWrite
Conn.ConnectionString = "Provider=MSDAORA.1;Data Source=ORALUIS;User ID=tesis;Password=luis"