| Regex and Sql Queries containing + [message #6726] |
Mon, 17 July 2017 19:43  |
Laevus
Messages: 5
Registered: October 2016
|
Junior Member |
|
|
Dear Tony,
I have calendar data that must be loaded into a scheduler for display.
I must get the calendar data from the current day and one year into the future.
The following query works with MySql 5.6:
select * from calendar where dt between curdate() and curdate() + interval 365 day;
When I run the same query through Radicore 2.04.1, I get the following error:
sys0060
sys0061
2017-07-18 01:10:46
sys0063 Cannot extract token from: '+ interval 365 day' (# 256)
sys0065 7678 C:\xampp\htdocs\****\includes_erp\include.library.inc
sys0066 /****/calendar.php
sys0187 C:\xampp\htdocs\****
sys0183 ::1
sys0184 localhost
sys0185 localhost
sys0068 ::1
If I remove the + from the query, I can move forward (with a correctly reported ill-formed sql query error).
It seems that there is a bug in the regex portion of the code.
Or I have missed something silly.
Thank you for your time.
`Laevus
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
