Help with ODBC to Access query [Solved]

From: Date: Tue, 06 Mar 2001 17:36:57 +0000
Subject: Help with ODBC to Access query [Solved]
References: 1 2  Groups: php.windows 
Request: Send a blank email to php-windows+get-5853@lists.php.net to get a copy of this message
I'd like to thank everyone for their responses... After trying many variations, I finally figured it out. By changing the single quotes back to double quotes (normally some of the parameters to the where clause are variables), I changed the double quotes around the first DatePart argument to single quotes, and it worked. $query1 = "SELECT COUNT(RunNumber) AS RunCount, DatePart('m', CallDate) AS MonNum
               FROM CallData
               WHERE  (CallDate Between #1/1/$year# AND #12/31/$year#)
                  AND Driver = $driver
               GROUP BY DatePart('m', CallDate)";
Thanks again, SWS
I'm trying to get the following query to work:
    $query1 = 'SELECT COUNT(RunNumber) AS RunCount,
                      DatePart("m", CallDate) AS MonNum
                FROM CallData
                WHERE (CallDate Between #1/1/00# AND #12/31/00#)
                  AND Driver = 1731
                GROUP BY DatePart("m", CallDate)';
It returns the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in d:\internet\apache\htdocs\db\test.php on line 48


« previous php.windows (#5853) next »