Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle ASP
|
Oracle ASP Using ASP with Oracle databases. For Oracle discussions not specific to ASP, please see the Oracle forum. For more ASP discussions, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle ASP 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 26th, 2004, 02:00 PM
Registered User
 
Join Date: Oct 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Deleting several records on ASP using checkboxes

Hi,

I'm using Oracle9i and ASP to delete multiple records choosing each one of them with checkboxes, but when I do it, I can only delete one record because if I choose more than one it doesn't do anything.
Is there anyone who can give me a hand?.
Thanks!!!!.

 
Old April 25th, 2005, 08:47 PM
Registered User
 
Join Date: Apr 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In ASP classical (not ASP.NET), you can you use mutil checkboxs with the same name. You use Request.Forms("CheckBoxName") to get value of checkboxs
For example: You have 4 checkboxs and get values, 'A','B','C','D'
Request.Forms("CheckBoxName") will return : A,B,C,D
Then, forming SQL :
strSQL = "Delete tablename where ID in (" & Request.Forms("CheckBoxName") & ")"
Good luck !!!








Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Duplicate Records BrianWren Pro VB Databases 1 February 22nd, 2008 01:30 PM
Delete records in MySQL using checkboxes in forms taslim Beginning PHP 2 August 10th, 2006 05:01 AM
error in deleting,updating and records in asp method Classic ASP Databases 1 May 6th, 2005 10:35 AM
The use of checkboxes to delete records inoracle9i luisbueno Classic ASP Databases 0 December 24th, 2004 12:07 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.