SQL-Query help

Results 1 to 4 of 4

Thread: SQL-Query help

  1. #1
    Ghose Guest

    Default SQL-Query help

    I can&#039;t seem to solve this....<BR><BR>SELECT COUNT(DISTINCT remote_ADDR) FROM tblName WHERE cond = 2001-01-15<BR><BR>this is what the server return....<BR><BR>Syntax error (missing operator) in query expression &#039;COUNT(DISTINCT remote_ADDR)&#039;. <BR><BR>hope someone can help me...

  2. #2
    New ASP Guest

    Default RE: SQL-Query help

    IF your "cond = 2001-01-15" is right, this will work.<BR><BR>SELECT COUNT(remote_ADDR) FROM tblName WHERE cond = 2001-01-15<BR>GROUP BY remote_ADDR<BR><BR><BR><BR>

  3. #3
    It works.... Guest

    Default RE: SQL-Query help

    Thank you very much..

  4. #4
    New ASP Guest

    Default Any time <eof>


Posting Permissions

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