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 havemore than one column distinct (as in my webcat example). I can do this noproblem using multiple queries and using DISTINCT on each one, but I wouldlike to do it in one query since there are 6 columns that need thistreatment. Any ideas?ThanksCharles> 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.netPresident phone: 856.608.7908RightCode, Inc.900 Briggs Road, Suite 303Mt. Laurel, NJ 08054http://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:
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 havemore than one column distinct (as in my webcat example). I can do this noproblem using multiple queries and using DISTINCT on each one, but I wouldlike to do it in one query since there are 6 columns that need thistreatment. Any ideas?ThanksCharles> 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.netPresident phone: 856.608.7908RightCode, Inc.900 Briggs Road, Suite 303Mt. Laurel, NJ 08054http://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
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...