Re: SQL Query Question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38623
interpreted = N
texte = On 9/17/01 12:26 PM, John Hill wrote:> SELECT DISTINCT ItemType FROM > Yes, I have that working already. The problem lies in that I want to have more than one column distinct (as in my webcat example). I can do this no problem using multiple queries and using DISTINCT on each one, but I would like to do it in one query since there are 6 columns that need this treatment. Any ideas?Thanks Charles > John. > >> I need to perform a query on an SQL datasource and summarize the results of >> a couple of the columns in the table. To do this in WebCat is no problem, >> but I can't figure out the equivalent syntax in SQL. Any help would be >> appreciated. >> >> [search db=some.db&neItemIDdata=BLANK&ItemTypesumm=T&ItemCatsumm=T] >> >>

>> >> [/search] >> >> >> >> >> ------------------------------------------------------------- >> 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/ > > > --------------------------------- > John A. Hill > Oak Hill Software > Website Development/Consulting > john@oakhillsoftware.com > > ------------------------------------------------------------- > 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 email: ckline@rightcode.net President phone: 856.608.7908 RightCode, Inc. 900 Briggs Road, Suite 303 Mt. Laurel, NJ 08054 http://www.rightcode.net -= fuel for websites =- ------------------------------------------------------------- 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:

    
  1. Re: SQL Query Question (Andrew Simpson 2001)
  2. Re: SQL Query Question (Britt T. 2001)
  3. Re: [OT] was Re: SQL Query Question (Charles Kline 2001)
  4. Re: [OT] was Re: SQL Query Question (John Peacock 2001)
  5. Re: SQL Query Question (Charles Kline 2001)
  6. [OT] was Re: SQL Query Question (John Peacock 2001)
  7. Re: SQL Query Question (John Hill 2001)
  8. SQL Query Question (Charles Kline 2001)
On 9/17/01 12:26 PM, John Hill wrote:> SELECT DISTINCT ItemType FROM > Yes, I have that working already. The problem lies in that I want to have more than one column distinct (as in my webcat example). I can do this no problem using multiple queries and using DISTINCT on each one, but I would like to do it in one query since there are 6 columns that need this treatment. Any ideas?Thanks Charles > John. > >> I need to perform a query on an SQL datasource and summarize the results of >> a couple of the columns in the table. To do this in WebCat is no problem, >> but I can't figure out the equivalent syntax in SQL. Any help would be >> appreciated. >> >> [search db=some.db&neItemIDdata=BLANK&ItemTypesumm=T&ItemCatsumm=T] >> >>

>> >> [/search] >> >> >> >> >> ------------------------------------------------------------- >> 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/ > > > --------------------------------- > John A. Hill > Oak Hill Software > Website Development/Consulting > john@oakhillsoftware.com > > ------------------------------------------------------------- > 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 email: ckline@rightcode.net President phone: 856.608.7908 RightCode, Inc. 900 Briggs Road, Suite 303 Mt. Laurel, NJ 08054 http://www.rightcode.net -= fuel for websites =- ------------------------------------------------------------- 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:

X etc.... (1999) [MoveFile] (2000) re:check boxes (1997) WebCatalog Upgrade Pricing? (1997) SPAWN does not inherit functions (2003) [LOOKUP] (1997) Text data with spaces in them... (1997) How to put the Trademark Symbol (%99) in Sendmail? (2003) RE: Emailer Set Up (1997) Credit card types (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Middle problem (2004) Server slowing down. (1997) Multiple Newcarts (1996) Setting Cart value (2000) Fwd: [ANNOUNCE] BIAP W*API Patch plug-in (1998) More on the email templates (1997) Credit Card Checking?? (1998) Encyption mail was Suggestions for Topics ... (1998) [WebDNA] Nested Searches (2013)