Page 9 of 36,387, showing 100 records out of 3,638,688 total, starting on record 801, ending on 900

# | Username | Text | |
---|---|---|---|

# | Nov 6th, 09:08 | markwendelson | |

# | Nov 6th, 08:58 | pidlo | ok i get this $query->newExpr('DATE_ADD(dfrom, INTERVAL - @num MONTH)') |

# | Nov 6th, 08:50 | kgb.acct.personal | |

# | Nov 6th, 08:48 | conehead | |

# | Nov 6th, 08:44 | admad | |

# | Nov 6th, 08:42 | conehead | |

# | Nov 6th, 08:41 | conehead | |

# | Nov 6th, 08:38 | admad | |

# | Nov 6th, 08:37 | conehead | |

# | Nov 6th, 08:35 | conehead | |

# | Nov 6th, 08:33 | admad | |

# | Nov 6th, 08:31 | conehead | |

# | Nov 6th, 08:28 | pidlo | something like this? $query->func()->dateAdd('dfrom', @num, 'MONTH') ??? |

# | Nov 6th, 08:28 | pidlo | howto do this 'DATE_ADD(dfrom, INTERVAL - @num MONTH)' |

# | Nov 6th, 08:28 | pidlo | hello all i have registred variable in sql '@num:=CAST(period AS UNSIGNED)', |

# | Nov 6th, 08:26 | admad | |

# | Nov 6th, 08:24 | scuadra | |

# | Nov 6th, 08:21 | conehead | |

# | Nov 6th, 08:21 | conehead | |

# | Nov 6th, 08:20 | rudy1976s | |

# | Nov 6th, 08:18 | conehead | |

# | Nov 6th, 08:16 | dereuromark | |

# | Nov 6th, 08:14 | karmicdice | |

# | Nov 6th, 08:14 | karmicdice | |

# | Nov 6th, 08:13 | conehead | |

# | Nov 6th, 08:11 | karmicdice | |

# | Nov 6th, 08:10 | conehead | |

# | Nov 6th, 08:09 | conehead | |

# | Nov 6th, 08:09 | slackebot1 | association. Just says `null`. If I set the `attachment_id` manually in the `posts` table, I can load the data with `contain` just fine. |

# | Nov 6th, 07:53 | kgb.acct.personal | |

# | Nov 6th, 07:53 | karmicdice | |

# | Nov 6th, 07:52 | karmicdice | |

# | Nov 6th, 07:52 | kgb.acct.personal | |

# | Nov 6th, 07:50 | markwendelson | |

# | Nov 6th, 07:46 | javier.villanueva | |

# | Nov 6th, 07:43 | markwendelson | |

# | Nov 6th, 07:07 | alexdd55976 | |

# | Nov 6th, 07:04 | jotpe | |

# | Nov 6th, 06:51 | conehead | |

# | Nov 6th, 06:49 | admad | |

# | Nov 6th, 06:42 | conehead | |

# | Nov 6th, 06:42 | conehead | |

# | Nov 6th, 06:19 | admad | |

# | Nov 6th, 05:58 | conehead | |

# | Nov 6th, 03:13 | liaogz82 | |

# | Nov 6th, 03:13 | liaogz82 | |

# | Nov 6th, 03:12 | liaogz82 | |

# | Nov 6th, 02:25 | daniel.upshaw | |

# | Nov 6th, 00:51 | daniel.upshaw | |

# | Nov 6th, 00:51 | daniel.upshaw | |

# | Nov 6th, 00:51 | daniel.upshaw | |

# | Nov 6th, 00:50 | daniel.upshaw | |

# | Nov 6th, 00:50 | daniel.upshaw | |

# | Nov 6th, 00:47 | dereuromark | |

# | Nov 6th, 00:47 | daniel.upshaw | |

# | Nov 6th, 00:46 | daniel.upshaw | |

# | Nov 6th, 00:46 | daniel.upshaw | |

# | Nov 6th, 00:45 | dereuromark | |

# | Nov 6th, 00:43 | daniel.upshaw | |

# | Nov 6th, 00:43 | daniel.upshaw | |

# | Nov 6th, 00:43 | dereuromark | |

# | Nov 6th, 00:39 | daniel.upshaw | |

# | Nov 6th, 00:39 | daniel.upshaw | |

# | Nov 6th, 00:38 | daniel.upshaw | |

# | Nov 6th, 00:38 | daniel.upshaw | |

# | Nov 6th, 00:38 | slackebot1 | migrations dump - migrations mark_migrated - migrations migrate - migrations orm-cache-build - migrations orm-cache-clear - migrations rollback - migrations seed - migrations status``` |

# | Nov 6th, 00:38 | daniel.upshaw | |

# | Nov 6th, 00:36 | dereuromark | |

# | Nov 6th, 00:34 | daniel.upshaw | |

# | Nov 6th, 00:34 | daniel.upshaw | |

# | Nov 6th, 00:04 | daniel.upshaw | |

# | Nov 6th, 00:04 | daniel.upshaw | |

# | Nov 6th, 00:03 | daniel.upshaw | |

# | Nov 6th, 00:03 | daniel.upshaw | |

# | Nov 6th, 00:02 | daniel.upshaw | |

# | Nov 6th, 00:02 | daniel.upshaw | |

# | Nov 5th, 23:53 | daniel.upshaw | |

# | Nov 5th, 23:53 | dereuromark | |

# | Nov 5th, 23:53 | dereuromark | |

# | Nov 5th, 23:53 | daniel.upshaw | |

# | Nov 5th, 23:51 | dereuromark | |

# | Nov 5th, 23:51 | dereuromark | |

# | Nov 5th, 23:50 | daniel.upshaw | |

# | Nov 5th, 23:50 | daniel.upshaw | |

# | Nov 5th, 23:50 | daniel.upshaw | |

# | Nov 5th, 23:50 | dereuromark | |

# | Nov 5th, 23:49 | daniel.upshaw | |

# | Nov 5th, 23:45 | dereuromark | |

# | Nov 5th, 23:42 | daniel.upshaw | |

# | Nov 5th, 23:19 | slackebot1 | ->like( $conc2, "%$search%" ) ->like( $conc3, "%$search%" ) ->like( $conc4, "%$search%" ); } ); } ``` But all I get is a ``` Column not found: 1054 Unknown column 'Table2.first_name' in 'where clause' ``` due to the fact, that the Query doesn't join. This functions resides in my index() function of my Table1Controller and the initialization of the $query |

# | Nov 5th, 23:19 | slackebot1 | variable does have the contain ``` $query = $this->Table->find( 'all' ) ->contain( ['Table2'] ); ``` The contain also works if i remove my function from above (to show related information in my index page) but i dont know how i can perform a custom where in which both my tables are being searched with concatinated fields |

# | Nov 5th, 23:19 | slackebot1 | 'Table2.last_name' => 'literal' ] ); $conc4 = $q->func() ->concat( [ 'Table2.last_name' => 'literal', ' ', 'Table2.first_name' => 'literal' ] ); return $exp->or( [ 'Table1.company LIKE' |

# | Nov 5th, 23:19 | slackebot1 | */ // Concatenated EasybillCustomers Name $conc1 = $q->func() ->concat( [ 'Table1.first_name' => 'literal', ' ', 'Table1.last_name' => 'literal' ] ); $conc2 = $q->func() ->concat( [ |

# | Nov 5th, 23:19 | slackebot1 | 'Table1.last_name' => 'literal', ' ', 'Table1.first_name' => 'literal' ] ); // Concatenated EasybillCustomersContacts Name $conc3 = $q->func() ->concat( [ 'Table2.first_name' => 'literal', ' ', |

# | Nov 5th, 23:19 | kevin.pfeifer | |

# | Nov 5th, 23:19 | slackebot1 | => "%$search%", 'Table1.first_name LIKE' => "%$search%", 'Table1.last_name LIKE' => "%$search%", 'Table1.city LIKE' => "%$search%", 'Table2.first_name LIKE' => "%$search%", 'Table2.last_name LIKE' => "%$search%" ] ) ->like( $conc1, "%$search%" ) |

# | Nov 5th, 21:56 | phantomwatson | |

# | Nov 5th, 21:50 | phantomwatson | |

# | Nov 5th, 21:49 | phantomwatson | |

# | Nov 5th, 21:47 | phantomwatson |