Radicore Forum: Bug Reports » Regex and Sql Queries containing +

Home » RADICORE development » Bug Reports » Regex and Sql Queries containing + (Regex and Sql Queries containing +)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator