> > [/search]> select ItemType, ItemCatfrom somedatabasegroup by ItemType, ItemCatI suggesting buying a book on SQL, rather than asking such OTquestions on this list.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list > > [/search]> select ItemType, ItemCatfrom somedatabasegroup by ItemType, ItemCatI suggesting buying a book on SQL, rather than asking such OTquestions on this list.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list DOWNLOAD WEBDNA NOW! 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...
Charles Kline wrote:> > 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]> >
Top Articles:
Talk List
Related Readings:
WC Database Format (1997)
browser info.txt and SSL (1997)
Most Efficiant Way to do restricted Areas (1997)
Separate SSL Server (1997)
OFF-TOPIC: Lending investors ... (2002)
WebCat2b15MacPlugin - showing [math] (1997)
Exclude by date - multiple (1997)
math/text variable limits per page (2001)
Snake Bites (1997)
Forumulas.db & Variables (2002)
Online reference (1997)
View order not right (1997)
my price won't move (1997)
Trouble with formula.db (1997)
WebDNA Codes in Secure Mode (1997)
Its slow... (2004)
WebDNA vs PHP (2003)
[ShowNext] (1997)
[Shell script] question. (2004)
Paypal merchant code tricks or pitfalls (2003)