| # |
Apr 27th 2017, 20:10 |
COLT_ |
yea, well Im using MS SQL and its forcing me to use ODBC, cant use the Native one |
| # |
Apr 27th 2017, 20:09 |
siran |
not using sqlserver, though |
| # |
Apr 27th 2017, 20:09 |
siran |
COLT_: im on windows, and I don't know |
| # |
Apr 27th 2017, 20:09 |
COLT_ |
this happens on CakePHP |
| # |
Apr 27th 2017, 20:08 |
COLT_ |
My problem is, why does php_pdo_sqlsrv.dll keeps asking me for ODBC driver 13 |
| # |
Apr 27th 2017, 20:08 |
COLT_ |
thanks btx |
| # |
Apr 27th 2017, 20:02 |
burzum2 |
btx - you can't check it this way, it's not really a field and a collection of ids or records, basically an array. Just create custom rule and check that it is an array and that it is not empty |
| # |
Apr 27th 2017, 19:50 |
 btx |
@COLT_ if it’s an option I’d highly recommend something like vagrant or Docker instead of running on Windows. or a $5 droplet from Digital Ocean. Not what you asked for, just opinion. Also might help to post what your actual issue is |
| # |
Apr 27th 2017, 19:47 |
COLT_ |
Im having problems with cakephp running on a windows server |
| # |
Apr 27th 2017, 19:46 |
btx |
having a brain fart. how would I add validation to make sure (eg on `create` that a Product has been assigned a Category (hasMany)? I tried `$validator->requirePresence('categories')` but it’s just ignored |
| # |
Apr 27th 2017, 19:46 |
COLT_ |
any of you guys use PHP on a windows machine? |
| # |
Apr 27th 2017, 19:46 |
COLT_ |
hello guys |
| # |
Apr 27th 2017, 19:43 |
btx |
@siran, it’s only protected so `$query->_parts` should be accessible |
| # |
Apr 27th 2017, 19:35 |
siran |
i want to access _parts |
| # |
Apr 27th 2017, 19:35 |
siran |
is there a getter? |
| # |
Apr 27th 2017, 19:35 |
siran |
hey, how to access a protected property of Query object? |
| # |
Apr 27th 2017, 19:24 |
aaronds |
exit |
| # |
Apr 27th 2017, 19:24 |
btx |
ew |
| # |
Apr 27th 2017, 19:24 |
COLT_ |
does any of you guys use PHP on a windows machine? |
| # |
Apr 27th 2017, 19:23 |
siran |
aaronds: ok i already got it, thanks! |
| # |
Apr 27th 2017, 19:23 |
aaronds |
@siran, of course, you're not extending Query, you'll be extending Table, which I just overlooked... |
| # |
Apr 27th 2017, 19:23 |
holisticnetworking |
I should say @btx |
| # |
Apr 27th 2017, 19:23 |
aaronds |
within your beforeFind, @siran, have a look at the implementation of \Cake\Database\Query, you'll see the protected $_parts variables holds a lot of info. |
| # |
Apr 27th 2017, 19:22 |
holisticnetworking |
Well. Being a search, that's a long story. However the Paginator is creating the pagination links. |
| # |
Apr 27th 2017, 19:22 |
siran |
aaronds: thanks. in what context is $this ? |
| # |
Apr 27th 2017, 19:22 |
btx |
@holisticnetworking what does the code generating those URLs look like? |
| # |
Apr 27th 2017, 19:20 |
holisticnetworking |
It is specifically the `limit` variable that is missing. |
| # |
Apr 27th 2017, 19:20 |
aaronds |
@siran, have a look at $this->_parts['where'] |
| # |
Apr 27th 2017, 19:19 |
slackebot1 |
facet=andst%5B0%5D=5and sort=Clients.emailand direction=asc |
| # |
Apr 27th 2017, 19:19 |
slackebot1 |
fmt=invoicesand facet=andst%5B0%5D=5and sort=Invoices.idand direction=descand limit=50and saved_query=14 // Paginator URLs on the same page: <https://limsdev4.biotech.cornell.edu/c/invoices?selected_columns=Invoices.id%2CClients.last_name%2CClients.state%2CClients.country%2CClients.email%2CBPayment.country%2CBPayment.state%2CInvoices.external%2CJournal.id2%2CInvoices.grand_total%2CInvoices.amount_paid%2CInvoices.paid& fmt=invoices and_method=POSTand saved_query=14and |
| # |
Apr 27th 2017, 19:19 |
holisticnetworking |
Any idea why Paginator would suddenly drop some preset GET variables? Compare the two URLs, broken down for clarity: // Original https://limsdev4.biotech.cornell.edu/c/invoices?_method=POSTandsaved_query=andselected_columns=Invoices.id%2CClients.last_name%2CClients.state%2CClients.country%2CClients.email%2CBPayment.country%2CBPayment.state%2CInvoices.external%2CJournal.id2%2CInvoices.grand_total%2CInvoices.amount_paid%2CInvoices.paid |
| # |
Apr 27th 2017, 19:19 |
COLT_ |
why does php_pdo_sqlsrv.dll keeps asking me for ODBC driver 13 on Cake? |
| # |
Apr 27th 2017, 19:18 |
COLT_ |
someone pleasee help me get out of a doubt |
| # |
Apr 27th 2017, 19:17 |
siran |
in beforeFind I need to tweak the query and remove one of the where() conditions, is this possible? |
| # |
Apr 27th 2017, 19:15 |
siran |
given a $query object, how can I extract the where conditions that have been applied to it, is this possible? |
| # |
Apr 27th 2017, 19:15 |
siran |
hi all! |
| # |
Apr 27th 2017, 19:13 |
aaronds |
nice, like that. I'll have a play around with it tomorrow. Thanks for your help @btx. |
| # |
Apr 27th 2017, 19:13 |
btx |
@aaronds |
| # |
Apr 27th 2017, 19:11 |
btx |
aaronds - you could also actually override `Router` to provide the modified `::url` function - and in `url()` do your check and fall back to `parent::url()` if no tricky stuff needs doing |
| # |
Apr 27th 2017, 19:03 |
aaronds |
ugly, but it'll do for what I need it for |
| # |
Apr 27th 2017, 19:02 |
aaronds |
I suppose something to the effect of `if (in_array('UrlBuilder', class_uses(new App\Controller\Admin\DashboardsController())) { /* do stuff */ }` would be required, with the option to fall back to guessing via the native Router::url(); |