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:

Where's the POP3 example? (2005) off topic, converting mail (1998) [WebDNA] Problem running Webdna (2011) Protecting databases (1999) Clickable maps and WebCatalog? (1996) Where is f2? (1997) Surprise x and y post args (1998) Problem (1997) test (2002) Help me choose an upgrade path to 5.0 (2003) [include] affect on filepaths for links? (1997) ErrorLog with Linux? (2000) Searching (2005) Problems getting parameters passed into email. (1997) More on the email templates (1997) More on the email templates (I like it) (1997) WebSTAR 2.1 freezes my Mac (1997) PSC recommends what date format yr 2000??? (1997) Plugin or CGI or both (1997) WebCat2 several catalogs? (1997)