Query error using more than one page.

[Joe Rivera]

Having trouble seeing more than one page after a query, using either DaDaBIK 1.9 or 2.0.

Under version 1.9 I get:

Error during query execution.
select * from ship_data where DATE_FORMAT(received_date, %Y-%m-%d) = 2002-01-01
MySQL server said: You have an error in your SQL syntax near '%Y-%m-%d) = 2002-01-01' at line 1

Using 2.0, I get the "no records found". Other databases that don't require searches using the date function, do not experience these problems. Any help would be greatly appreciated. Thanks.

JOE

 

[Eugenio]

Joe Rivera wrote:
>
> Having trouble seeing more than one page after a query,
> using either DaDaBIK 1.9 or 2.0.
>
> Under version 1.9 I get:
>
> Error during query execution.
> select * from ship_data where DATE_FORMAT(received_date,
> %Y-%m-%d) = 2002-01-01
> MySQL server said: You have an error in your SQL syntax near
> '%Y-%m-%d) = 2002-01-01' at line 1
>
> Using 2.0, I get the "no records found". Other databases
> that don't require searches using the date function, do not
> experience these problems. Any help would be greatly
> appreciated. Thanks.

Do you still have the problem?

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)