double slash or not; that's the question..

[wezetel]

In J3/F3 I have a date field and use the php allow field. There I prepare a database query with following line:
->where('status' .' = \'frei\'');
I had to escape the apostrophes with backslashes.

In J4/F4beta4 I had to double the slashes to get it working.

According the announcement ( ....so you should make sure all of these are reverted to single slashes.), I removed the duplicate slashes. But this doesn't work. I had to keep the double slashes.

 

[troester]

In general: Did you try with ->where("status = 'frei' "); or 'status = "frei" ' or with $myDb->quote like http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#select

For the backslashes we'll have to look.

 

[wezetel]

Seems I made the query to complicated :-(
Using different (single/double) apostrophes works like a charme and therefore no need to use slashes at all.
Thanks a lot!

 

[troester]

Need for double backslashes in date/jdate 'getAllowedPHPDates' is fixed (-> next version), thanks for reporting.