|
|
 |
RE: FN-FORUM asp deleting record problem
date posted 27th January 2002 11:50
Nice and neat solution, assumes however that you have available all the
foreign keys.
If you need to run a select to get the FK, things can get a little more
ugly. But the use of transactions is essential whether in ASP or Stored
Procedure.
-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Robert Blackmore
Sent: 27 January 2002 11:15
To: [EMAIL REMOVED]
Subject: RE: FN-FORUM asp deleting record problem
Hi Ian,
You can use a transaction and execute 3 delete statements from within
the ASP code.
e.g.
Lcon.BeginTrans
Lcon.Execute "DELETE * FROM Sub1 WHERE ID = " & LlngID
Lcon.Execute "DELETE * FROM Sub2 WHERE ID = " & LlngID
Lcon.Execute "DELETE * FROM Main WHERE ID = " & LlngID
Lcon.CommitTrans
The transaction will ensure that the data is either deleted from all 3
tables or no tables.
Regards,
Rob
> ----- Original Message -----
> From: [EMAIL REMOVED]
> To: "Freelance forum" [EMAIL REMOVED]
> Sent: Sunday, January 27, 2002 12:53 AM
> Subject: FN-FORUM asp deleting record problem
>
>
> > I am trying to delete a record from a database table. The record is
linked
> > to via a unique ID to two further tables. (Have been brought in to
work
> with
> > an existing database)
> >
> > Is it possible to delete the record from all three tables at the
same
> time?
> > I have found information on the macromedia site about adding to
multiple
> > tables from the same page but there seems to be no mention of
deleting
> from
> > more than one table.
>
>
>
> ===============================================================
> = SAVE TIME *AND* MAKE MONEY! with Neutralize (**): =
> = Generate bespoke quotes for Online Marketing Services. =
> = Resellers info at http://www.neutralize.com & 01209 210 910 =
> ===============================================================
>
> **************************************************************
> *** Sponsor the forum for as little as £1 at: ***
> *** ***
> *** http://www.freelancers.net/cgi/sponsor.cgi?action=show ***
> **************************************************************
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
===============================================================
= SAVE TIME *AND* MAKE MONEY! with Neutralize (**): =
= Generate bespoke quotes for Online Marketing Services. =
= Resellers info at http://www.neutralize.com & 01209 210 910 =
===============================================================
**************************************************************
*** Sponsor the forum for as little as £1 at: ***
*** ***
*** http://www.freelancers.net/cgi/sponsor.cgi?action=show ***
**************************************************************
Freelancers and Freelance Jobs:
http://www.freelancers.net
Forum FAQs:
http://freelancers.netrickery.com
To unsubscribe please email:
[EMAIL REMOVED]
If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
===============================================================
= SAVE TIME *AND* MAKE MONEY! with Neutralize (**): =
= Generate bespoke quotes for Online Marketing Services. =
= Resellers info at http://www.neutralize.com & 01209 210 910 =
===============================================================
**************************************************************
*** Sponsor the forum for as little as £1 at: ***
*** ***
*** http://www.freelancers.net/cgi/sponsor.cgi?action=show ***
**************************************************************
Freelancers and Freelance Jobs:
http://www.freelancers.net
Forum FAQs:
http://freelancers.netrickery.com
To unsubscribe please email:
[EMAIL REMOVED]
If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
|
|
|
