Log message #4020775

# At Username Text
# Apr 27th 2017, 20:10 siran COLT_: sorry, i have no clue : (
# 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