| # |
Oct 1st 2016, 12:11 |
 maikh |
it was a naming problem. :slightly_smiling_face: |
| # |
Oct 1st 2016, 12:11 |
maikh |
oh... now it works. |
| # |
Oct 1st 2016, 12:09 |
maikh |
hm, i dont understand. i have some more n:m associations that works. but only this one not... |
| # |
Oct 1st 2016, 12:02 |
hmic |
i'd suggest naming the jointable manually in those relations |
| # |
Oct 1st 2016, 11:58 |
maikh |
hm, i think there is something more wrong. |
| # |
Oct 1st 2016, 11:55 |
maikh |
http://pastebin.com/VNnBXsAF |
| # |
Oct 1st 2016, 11:54 |
hmic |
what did solve it? |
| # |
Oct 1st 2016, 11:54 |
maikh |
yes, sorry. this is solved. :slightly_smiling_face: |
| # |
Oct 1st 2016, 11:50 |
hmic |
you asked about a table not beeing found |
| # |
Oct 1st 2016, 11:50 |
hmic |
this is not the problem you asked for in the beginning |
| # |
Oct 1st 2016, 11:49 |
maikh |
yes, they are. and in ```$this->request->data['floors'], ['floorsmovein'] there are the selected ids. but nothing goes into my databasetables. ```$this->Forms->patchEntity($form, $this->request->data, [ 'associated' => [ 'Rooms','Floors','Floorsmovein','Specialremovals', 'Dismantles', 'Assembles' ] ]);``` |
| # |
Oct 1st 2016, 11:46 |
hmic |
you tell me! |
| # |
Oct 1st 2016, 11:45 |
maikh |
@hmic hm... floors_forms and floorsmovein_forms are my joinTables arent they? |
| # |
Oct 1st 2016, 11:44 |
hmic |
!tell maikh about gist |
| # |
Oct 1st 2016, 11:43 |
hmic |
show the schema, show the code, explain from there |
| # |
Oct 1st 2016, 11:43 |
hmic |
still your text example does not reveal your current database setup or actual problem. |
| # |
Oct 1st 2016, 11:43 |
hmic |
you need a jointable for belongsToMany to work. even if its a self-relation (afaiu) |
| # |
Oct 1st 2016, 11:39 |
slackebot |
i think, but nothing is saved in floorsmovein_forms. |
| # |
Oct 1st 2016, 11:39 |
maikh |
@hmic i have a form with many many inputs. on the one hand i have a multi select where the user checks the floors which he is living on moving out. On the other hand the user has to select floors in which he is moving in. these two should be belongsToMany assocs with floors. In the floors table there are floors which can be selected by users. so in my form i have one field named ```floors._ids``` and the other one ```floorsmovein._ids``` The as |
| # |
Oct 1st 2016, 11:36 |
hmic |
maikh: belongsToMany uses a jointable, ever. i dont understand what you want to archive, but if you are sure you dont need one, you might want to use hasMany instead? |
| # |
Oct 1st 2016, 11:18 |
maikh |
but allways get an cake error ```SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dmsdigital.floorsmovein' doesn't exist``` |
| # |
Oct 1st 2016, 11:18 |
maikh |
i tried it with this: ```$this->belongsToMany('Floors', [ 'className' => 'Floors', 'foreign_key' => 'floor_id', 'propertyName' => 'Floors' ]); $this->belongsToMany('Floorsmovein', [ 'className' => 'Floors', 'foreign_key' => 'floorsmovein_id', 'propertyName' => 'Floorsmovein' ]);``` |
| # |
Oct 1st 2016, 11:14 |
maikh |
hey there. i have a model named ```floors``` in this table there are records for floors. Then i have a n:m association to which saves the floors in forms_floors now, i need a new model which should save the floors in forms_floorsmovein how do i realize this with only one table for the floors? |
| # |
Oct 1st 2016, 09:09 |
birdy247 |
the through option :) |
| # |
Oct 1st 2016, 08:57 |
birdy247 |
how can I enforce school_type_id is not empty? |
| # |
Oct 1st 2016, 08:57 |
birdy247 |
I dont have a Table for the joinTable |
| # |
Oct 1st 2016, 08:57 |
birdy247 |
echo $this->Form->input('schools.0._joinData.school_type_id', ['empty' => '--Select--']); |
| # |
Oct 1st 2016, 08:57 |
birdy247 |
I have a field like this |
| # |
Oct 1st 2016, 08:57 |
birdy247 |
morning |
| # |
Oct 1st 2016, 01:09 |
ra7bi |
thanks i will try it now |
| # |
Oct 1st 2016, 01:06 |
thinkingmedia |
you can do it as a SQL expression or you can do it as binded value |
| # |
Oct 1st 2016, 01:06 |
thinkingmedia |
actually, that's the same as just subtracting from the current time. |
| # |
Oct 1st 2016, 01:05 |
thinkingmedia |
``` where($query->newExpr("DATE_ADD(created, INTERVAL 2 HOUR) > NOW()")) ``` |
| # |
Oct 1st 2016, 01:04 |
ra7bi |
what do you mean ? it's a query for fetching all participants |
| # |
Oct 1st 2016, 01:04 |
thinkingmedia |
is this for mysql? |
| # |
Oct 1st 2016, 01:03 |
ra7bi |
i want where created+2hours > current time |
| # |
Oct 1st 2016, 01:03 |
ra7bi |
this is my Query |
| # |
Oct 1st 2016, 01:03 |
ra7bi |
``` $query = $this->Participants->find() ->where(['created >'=>Time::now()->addHours(2)]); ``` |
| # |
Oct 1st 2016, 01:02 |
thinkingmedia |
``` $this->find()->where(['created'=>$query-> |
| # |
Oct 1st 2016, 01:01 |
thinkingmedia |
``` |
| # |
Oct 1st 2016, 01:01 |
thinkingmedia |
f**k |