Re: FN-FORUM asp deleting record problem

date posted 27th January 2002 09:02

I guess it's going to be ugly code!!

I could, I suppose, just delete the record on the main table because without
that record's ID you would be unable to call the linked items. However this
strikes me as a rather messy way of managing the database.

I might be asking for guidance with the messy code in the near future - I'll
see what the database designer wants!

Thanks

Iain
;O)


----- Original Message -----
From: "Trevor Spink" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, January 27, 2002 1:39 AM
Subject: RE: FN-FORUM asp deleting record problem


> Are you running on SQL server? if so yu can try triggers or a stored
> proceedures I'd be happy to give some help on the coding. Otherwise you'll
> need to do multiple selects / deletes within ASP, which will be a real
pain
> and ugly code.
>
> If you are talking to Access you will be stuck with ugly code I am afriad.
>
> Kind Regards
>
> Trevor Spink - CTO
>
> Eonic Ltd.
> 32a Lansdowne Road, Tunbridge Wells, Kent. TN1 2NL
> t: 01892 534044 m: 07973 172892 e: [EMAIL REMOVED]
> www.eonic.co.uk
>
>
> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] Behalf Of [EMAIL REMOVED]
> Sent: 27 January 2002 00:54
> To: Freelance forum
> 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.
>
> Any Ideas?
>
> Iain
> www.fwdplus.com
>
>
> ===============================================================
> = 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]
>