Karen
|
| Posted: 06/11/2003, 9:04 AM |
|
I am trying to add a criteria into the query builer, where a date field is greater than current date. I have tried adding the parameter as time() of type expression but the results are not correct.
I'm using CCS2, PHP/MySQL. Any advice is much appreciated!
|
|
|
 |
RonB
|
| Posted: 06/11/2003, 12:59 PM |
|
where datefield>now()
Ron
|
|
|
|
Karen
|
| Posted: 06/11/2003, 5:51 PM |
|
I've tried now() also. If I put the criteria as a parameter of type expression, I get fatal error: call to undefined function now(). If I put the criteria as an expression, I don't get the desired results.
Any ideas? TIA!
|
|
|
|
Karen
|
| Posted: 06/11/2003, 5:56 PM |
|
I wanted to add that if I review records in the query builder, the records were displayed but not in live page. Wonder what could be causing this? Now I'm really confused!
|
|
|
|
Karen
|
| Posted: 06/11/2003, 6:01 PM |
|
Got it! It works with time() and another criteria (is null) which did not need a parameter had the parameter type set as parameter, changed that to expression and it works. Sorry for the trouble. Thanks very much!
|
|
|
|
|
