query problem in my fields.ini

Archived from the Xataface Users forum.

Jean — Mon Jul 06, 2009 5:00 am

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 — Mon Jul 06, 2009 10:35 am

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 — Mon Jul 06, 2009 12:02 pm

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

Jean