Results 1 to 4 of 4

Thread: dbCountSQL

  1. 05-28-2003, 01:20 PM #1
    tkent
    tkent is offline Registered User
    Join Date
    May 2003
    Posts
    7

    dbCountSQL

    I'm having trouble with CountSQL (as displayed by dbDebug = "104") not being set correctly.

    The attached code shows the problem using Northwind.

    If the line of the sql that begins with "group by...." is dropped, then CountSQL is derived correctly.

    If "group by...." is left in, then CountSQL is not derived correctly or if dbCountSQL is supplied, dbCountSQL is ignored.
    Reply With Quote Reply With Quote
  2. 05-28-2003, 05:15 PM #2
    Frank
    Frank is offline Registered User
    Join Date
    Oct 2002
    Posts
    933
    i see no attachments. overall, dbcountsql is used when complex queries is in action. in this case, you specify the query and asp-db will use this to get the record count instead of guessing.


    fk
    Reply With Quote Reply With Quote
  3. 05-28-2003, 10:43 PM #3
    tkent
    tkent is offline Registered User
    Join Date
    May 2003
    Posts
    7
    Version: ASPDB2002-05.03-NT4-SP3-ADO21-MTS-Gold
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  4. 05-29-2003, 12:14 AM #4
    Frank
    Frank is offline Registered User
    Join Date
    Oct 2002
    Posts
    933
    1. Your dbSQL is not valid.

    2. Check out dbNameMap doc -
    http://www.aspdb.com/aspdb/doc2002/dbnamemap.shtm

    At the bottom goto the complex query example CaseStudy #23.

    there are a few complex queries example in the examples area. Contact support to locate it if you cannot dig it out.

    FK
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules