query problem in my fields.ini

[Jean]

Hi Steve,
I have a problem with this query :

Code: Select all

select * from annuaire_enligne WHERE nom NOT REGEXP '([0-9]{4})' ORDER BY nom

with this message
Cannot use a scalar value as an array in /var/www/html/xataface-1.1.5r2/Dataface/Table.php on line 1971

I remember I had this problem some time ago :
http://xataface.com/forum/viewtopic.php?t=4057#20391

Do you know how I can fix it ?

Thank you

Jean

[shannah]

Looks like the SQL parser is probably having trouble with the query. Looks find to me. You can try downloading the latest SQL parser from SVN http://weblite.ca/svn/dataface/core/trunk/lib/SQL and replacing your existing parser with it (located in lib/SQL) and see if that makes a difference.

-Steve

[Jean]

Thank you Steve, I'll experiment it to-morrow.
Jean