The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Re: UKHA Classified update - SQL Help!


  • To: ukha_d@xxxxxxx
  • Subject: Re: Re: UKHA Classified update - SQL Help!
  • From: steve.cooper@xxxxxxx
  • Date: Wed, 27 Mar 2002 10:14:53 +0000
  • Delivered-to: mailing list ukha_d@xxxxxxx
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@xxxxxxx


>>across all lower level ProductTypes

Just to clarify before I have a look at this for you.

By the above do you mean a ProductTypeID that doesn't appear in the
ParentProductTypeID of any other Product Type.  I would have thought in
your application you need a cascading count.

i.e.

Computer
- Hardware
A box
Another box
- Software
A lotus product
A microsoft product
A product that works

So when you put in Software you get an answer of 3 but when you put in
Computer you get an answer of 5, 2 Harware + 3 Software.

Is this correct?

S.



___________________________________________________________________________

The information contained in this message is confidential and may be
legally privileged. If you are not the intended recipient, please do not
read, copy or otherwise use it and do not disclose it to anyone else.
Please notify the sender of the delivery error and then delete the
message from your system.

Any views or opinions expressed in this email are those of the author only.

Thank you for your assistance.

___________________________________________________________________________



Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.