[SQL] - COUNT, SUM retrieval

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33292
interpreted = N
texte = WebCat 4.0 Windows 2000I am unable to find any information on how to retrieve non-field information (COUNT, SUM, etc) from a SQL query in WebCat using the [SQL] context. According to the docs, any legal SQL statement can be used. Therefore, I would assume that this would work:[sql dsn=internal&statement=SELECT COUNT(*) FROM employees WHERE LastName = 'Jones'][/sql]As is, this WebDNA code returns nothing, but the same SQL statement in an .asp page works correctly, so I know that this particular SQL command is compatible with the database (Access 97). If I use[sql dsn=internal&statement=SELECT COUNT(*) FROM employees WHERE LastName = 'Jones'][numfound] [/sql]WebCat returns 1, although there are 11 records matching this query.How can I use SQL commands like COUNT in the WebCat [sql] context?Thanks in advance, Matt ------------------------------------------------------------- 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] - COUNT, SUM retrieval (Matt 2000)
  2. Re: [SQL] - COUNT, SUM retrieval (Anup Setty 2000)
  3. [SQL] - COUNT, SUM retrieval (Matt 2000)
WebCat 4.0 Windows 2000I am unable to find any information on how to retrieve non-field information (COUNT, SUM, etc) from a SQL query in WebCat using the [SQL] context. According to the docs, any legal SQL statement can be used. Therefore, I would assume that this would work:[sql dsn=internal&statement=SELECT COUNT(*) FROM employees WHERE LastName = 'Jones'][/sql]As is, this WebDNA code returns nothing, but the same SQL statement in an .asp page works correctly, so I know that this particular SQL command is compatible with the database (Access 97). If I use[sql dsn=internal&statement=SELECT COUNT(*) FROM employees WHERE LastName = 'Jones'][numfound] [/sql]WebCat returns 1, although there are 11 records matching this query.How can I use SQL commands like COUNT in the WebCat [SQL] context?Thanks in advance, Matt ------------------------------------------------------------- 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/ Matt

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:

authenticate broken when url not fully specified? (2000) problem serving foreign languages text (1997) [taxRate] [TaxTotal] ? (1997) WebCatalog can't find database (1997) WebCat2 several catalogs? (1997) Sendmail Question (2001) [WebDNA] [random] limit 1-10 (2010) String manipulation in Webcatalog (2001) Only charge card when product shipped ? (1997) WebCat2 - [include] tags (1997) Adding Message to Order (1997) WebDNA Solutions ... sorry! (1997) Bug Report, maybe (1997) Databases (2000) question: webmerchant connection (1997) Need help with search title (1998) WebCatalog 4.0 ? (2000) [Announce] WebCatalog 2.1 Released (1998) SMSI: databases corrupted on crash and permission issueson OSX (2002) More on the email templates (1997)