# |
Nov 14th 2017, 17:46 |
flavius |
which other domain |
# |
Nov 14th 2017, 17:45 |
saeideng |
but I have another domain |
# |
Nov 14th 2017, 17:44 |
saeideng |
http://localhost/ works |
# |
Nov 14th 2017, 17:44 |
saeideng |
The DNS server returned: Name Error: The domain name does not exist. This means that the cache was not able to resolve the hostname presented in the URL. Check if the address is correct. |
# |
Nov 14th 2017, 17:43 |
saeideng |
Unable to determine IP address from host name... |
# |
Nov 14th 2017, 17:43 |
saeideng |
The following error was encountered while trying to retrieve the URL |
# |
Nov 14th 2017, 17:43 |
saeideng |
The requested URL could not be retrieved |
# |
Nov 14th 2017, 17:43 |
saeideng |
my local domain not works |
# |
Nov 14th 2017, 17:43 |
inoas |
but would be good if there was a standard @ cakephp/app |
# |
Nov 14th 2017, 17:43 |
inoas |
so create src/web-assets or something |
# |
Nov 14th 2017, 17:40 |
etipaced |
Where is the best place to store SCSS files in a Cake 3 project? I don’t know that I want to keep these inside webroot since that’s publicly accessible. |
# |
Nov 14th 2017, 17:39 |
inoas |
there must be a better way than this https://gist.github.com/inoas/7d5be16ddf8be8737b7142a9ec535f66 |
# |
Nov 14th 2017, 17:36 |
inoas |
found it in some older code of mine now ... too |
# |
Nov 14th 2017, 17:36 |
inoas |
return $exp->or_([ there is that thing I was looking for |
# |
Nov 14th 2017, 17:30 |
flavius |
more here -> https://book.cakephp.org/3.0/en/orm/query-builder.html#advanced-conditions |
# |
Nov 14th 2017, 17:30 |
inoas |
hehe, that is very low levely ;-) again I think where and andWhere() do the same thing here |
# |
Nov 14th 2017, 17:29 |
flavius |
@inoas example of query expressions if it helps you -- https://pastebin.com/vMj8cj7d |
# |
Nov 14th 2017, 17:09 |
inoas |
got an example for that, none in the book :E |
# |
Nov 14th 2017, 17:08 |
inoas |
right I am looking for the query expression way |
# |
Nov 14th 2017, 17:08 |
diego182 |
thats what i've been doing lately, i do this way or with query expression |
# |
Nov 14th 2017, 17:07 |
inoas |
just use where(['or' => $yourConditions]) for the most part |
# |
Nov 14th 2017, 17:07 |
inoas |
so it is dangerous to use IMHO |
# |
Nov 14th 2017, 17:06 |
inoas |
diego182 well orWhere can have its uses but as far as I know it basically sets the query object into a state to append addition statements as OR instead of AND |
# |
Nov 14th 2017, 17:06 |
inoas |
was it _or()? |
# |
Nov 14th 2017, 17:06 |
diego182 |
i saw something about it, i guess were at github, that orWhere is comming back, aboud andWhere, i didnt now about that, thanks! |
# |
Nov 14th 2017, 17:06 |
inoas |
which will fail as the keys are not unique |
# |
Nov 14th 2017, 17:06 |
inoas |
now next problem I want to iterate this multiple times $orConditions['Devices.identifier LIKE'] = $value; |
# |
Nov 14th 2017, 17:02 |
inoas |
well not sure if it will stay deprecated, btu you should not - as you were suggesting to use andWhere I just wanted to warn you about orWhere |
# |
Nov 14th 2017, 17:02 |
inoas |
ah wrong channel |
# |
Nov 14th 2017, 17:02 |
inoas |
doing this WHERE a.id IN ( <select article id values related to tag 'parrot'> ) AND a.id IN ( <select article id values related to tag 'bungie'> ) (found here https://stackoverflow.com/questions/24519215/mysql-match-all-tags-rather-than-any/24519276#24519276 ) |
# |
Nov 14th 2017, 17:01 |
diego182 |
not anymore, as its been deprecated |
# |
Nov 14th 2017, 17:00 |
inoas |
btw, are you using orWhere? |
# |
Nov 14th 2017, 17:00 |
inoas |
diego182 |
# |
Nov 14th 2017, 16:56 |
inoas |
it rocks for mixing and matching AND and OR |
# |
Nov 14th 2017, 16:56 |
inoas |
I wish I could easily create an ebay-like search syntax |
# |
Nov 14th 2017, 16:54 |
inoas |
this is how it works https://gist.github.com/inoas/368c0931066033493255f01fb8835a39 |
# |
Nov 14th 2017, 16:50 |
diego182 |
humm |
# |
Nov 14th 2017, 16:49 |
inoas |
the matchings collapse into one innerJoin and an AND statement to concat the conditions |
# |
Nov 14th 2017, 16:49 |
diego182 |
i'm not shure if that would work, but what if you call two matching on query builder? |
# |
Nov 14th 2017, 16:47 |
inoas |
if I create a subquery each time heh |
# |
Nov 14th 2017, 16:46 |
inoas |
sounds it is easily doable |