How to delete the Multiple Records Using Checkbox

tks_muthu · February 9th, 2005, 03:39 AM

Hi all!

i am using the checkbox for the purpose of delete the checked items.
when i click more than one checkbox

the request.form value is displayed below
GWT-2/8/2005-00003*IC-098,GWT-2/8/2005-00004*IC-876, GWT-2/8/2005-00004*IC-098, GWT-2/8/2005-00005*IC-876

then how can i split the value like

BookId=GWT-2/8/2005-00003
FlightNo=IC-098

for all values

plz help. i will expecting ur reply

Muthu

Shibu · February 9th, 2005, 03:50 AM

You don't have to split the things to delete it from the database.
Just use the following code structure

Code:

if trim(request.form("chk")) <> "" then
qry_delete = "DELETE FROM tbl_NAME WHERE ConditionField IN (" & request.form("chk") & ")"
conn.execute delete 
end if

Shibu Narayanan
Software Associates

tks_muthu · February 9th, 2005, 03:55 AM

Quote:

quote:Originally posted by Shibu
You don't have to split the things to delete it from the database.
Just use the following code structure

Code:

if trim(request.form("chk")) <> "" then
qry_delete = "DELETE FROM tbl_NAME WHERE ConditionField IN (" & request.form("chk") & ")"
conn.execute delete 
end if

Shibu Narayanan
Software Associates

Hi Shibu!
actually i would like to delete the record using various field
like BookingId and FlightNo from two different tables.

so plz ask how to split these

Muthu

Vadivel · February 9th, 2005, 10:05 AM

strData = Request.form("SomeName")
ArrayName = split(strData, ",")

the second parameter of the split function is for specifing the delimiter.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

tks_muthu · February 10th, 2005, 03:19 AM

Thank You Very Much!

Muthu