Re: [OT] was Re: SQL Query Question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38626
interpreted = N
texte = On 9/17/01 12:46 PM, John Peacock wrote:> John Peacock wrote: > > Actually, I take that back. If you want to get the distinct values in > each field, you will need to do what John Hill said and > > SELECT DISTINCT fieldname from db > > for each field in questions. My way will give you all unique > _combinations_ of the fields in question, not a single list of each > columns unique values. > > If you normalize your database, you would have ItemType and ItemCat > tables with a single record for each value. Then your main database > would key into those tables for the values of each record. See any > decent book on relational databases for details. > Ah... A brilliant idea. Thanks and sorry for the OT post.- ck ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
On 9/17/01 12:46 PM, John Peacock wrote:> John Peacock wrote: > > Actually, I take that back. If you want to get the distinct values in > each field, you will need to do what John Hill said and > > SELECT DISTINCT fieldname from db > > for each field in questions. My way will give you all unique > _combinations_ of the fields in question, not a single list of each > columns unique values. > > If you normalize your database, you would have ItemType and ItemCat > tables with a single record for each value. Then your main database > would key into those tables for the values of each record. See any > decent book on relational databases for details. > Ah... A brilliant idea. Thanks and sorry for the OT post.- ck ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Charles Kline

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

RE: Emailer Set Up (1997) Add a field to the error log? (1997) Not really WebCat (1997) HideIf ip= OR ip= (1998) Separate SSL Server (1997) WebCat2b15MacPlugin - showing [math] (1997) Uh...can someone help me out with the b10? (1997) ShowNext (1997) Running WebCat from a CD-ROM (1997) Support ?? (1997) Need relative path explanation (1997) Using Plug-In while running 1.6.1 (1997) WCS Newbie question (1997) remotely add + sign (1997) WebCatalog Eating 200% of the CPU (2002) SiteBuilder? - SlideShow (2004) reservation program (2000) [OT] Airport Network (2003) Date search - yes or no (1997) [WebDNA] Friday's.. WIP thread (2009)