>Hello,
>
>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
>
>Line 48 is : $result = odbc_exec($connect, $query1);
>
>The connection is established okay, as other queries work:
>
>
> $query2 = "SELECT RunNumber, CallDate AS TDate, CallUnit,
>CallDutyCrew AS Crew, PtNum, NatureFull, Driver, Attendant1,
>Attendant2
> FROM CallData
> WHERE (CallDate Between #1/1/00# AND #12/31/00#)
> AND Attendant1 = $id
> ORDER BY RunNumber";
>
>I've tried escaping the m's in the DatePart (I initially used
>double-quotes " " around the query string), tried changing the
>COUNT(RunNumber) to COUNT(*), etc without success. The query runs
>fine as written if entered directly into Access.
>
>Any ideas?
>
>SWS
Sir, I've been struggling with similar ODBC problems all afternoon.
Try saving your query as a query in Access, and then passing "SELECT
* FROM query_name". Sometimes this works, and sometimes it doesn't.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
