Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 24th, 2004, 12:07 PM
Registered User
 
Join Date: Oct 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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)
%>






Similar Threads
Thread Thread Starter Forum Replies Last Post
delete using checkboxes in gridview aspvbnet ASP.NET 2.0 Basics 1 November 22nd, 2006 08:28 PM
Delete records in MySQL using checkboxes in forms taslim Beginning PHP 2 August 10th, 2006 05:01 AM
Cannot get multiple delete using checkboxes workin gmizzell Classic ASP Databases 0 July 13th, 2003 04:22 PM
checkboxes to export records dazednconfused PHP How-To 1 June 28th, 2003 01:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.