| # |
Apr 24th 2019, 08:37 |
asdfgh |
should i "normalize" it ? |
| # |
Apr 24th 2019, 08:37 |
asdfgh |
i can have 1-2019-01-01 or 12345678-2019-01-01 in this way the length vary |
| # |
Apr 24th 2019, 08:37 |
asdfgh |
the hash will be longer but all the hashes will have the same length |
| # |
Apr 24th 2019, 08:36 |
asdfgh |
i have to hash stupid things like ID-DATE somethin like 1235-2019-01-01 the question is, should i hash it or not? i mean does it matter to have a field with the same length in mysql ? |
| # |
Apr 24th 2019, 08:36 |
asdfgh |
hello |
| # |
Apr 24th 2019, 08:02 |
COOurb |
how can I use innerJoinWith with query? |
| # |
Apr 24th 2019, 07:54 |
COOurb |
I need to use Max() function, but it happens thatonly such objects can have it. So I think I can call function right from class |
| # |
Apr 24th 2019, 07:53 |
COOurb |
? |
| # |
Apr 24th 2019, 07:53 |
COOurb |
what type of objectand |
| # |
Apr 24th 2019, 07:53 |
COOurb |
what find() returns? |
| # |
Apr 24th 2019, 07:46 |
 remy |
Hello, Is there more information about CVE-2019-11458? We're trying to evaluate the impact on our users, but the release notes are a bit terse. > The vulnerability affects applications that open serialized content from user input. > SmtpTransport had the potential to create a harmful side-effect in its destructor should an untrusted value ever be deserialized. Anyone has an example on where/how this could be done? |
| # |
Apr 24th 2019, 07:40 |
COOurb |
because distinction doesn't recognize order |
| # |
Apr 24th 2019, 07:40 |
COOurb |
it doesn't work |
| # |
Apr 24th 2019, 07:40 |
COOurb |
nope |
| # |
Apr 24th 2019, 07:39 |
COOurb |
aha, thanx |
| # |
Apr 24th 2019, 07:21 |
conehead |
Sort by date and then apply an distinct for your value? https://book.cakephp.org/3.0/en/orm/query-builder.html#selecting-data |
| # |
Apr 24th 2019, 07:06 |
COOurb |
hwo to do it in query builder? |
| # |
Apr 24th 2019, 07:06 |
COOurb |
I need to select last (by date) entry from table for every velue of some field |
| # |
Apr 24th 2019, 07:03 |
ra7bi |
Yes i got it |
| # |
Apr 24th 2019, 07:03 |
conehead |
Oh and you wouldnt need the join table anymore |
| # |
Apr 24th 2019, 07:02 |
conehead |
Although it sounds like you could use hasMany as well. But then, the `photos` table would have to have the field `user_id`. Now as you configured it, photos may be "owned" by multiple users |
| # |
Apr 24th 2019, 07:00 |
ra7bi |
i had a problem with the type of relation , it must be `belongsToMany ` |
| # |
Apr 24th 2019, 07:00 |
conehead |
Sweet. What did the trick? I am always here and ask questions myself. Looks like I was able to help someone else for the first time ;) |
| # |
Apr 24th 2019, 06:59 |
ra7bi |
Thanks a lot |
| # |
Apr 24th 2019, 06:57 |
ra7bi |
let me confirm that |
| # |
Apr 24th 2019, 06:57 |
ra7bi |
i guess it works now |
| # |
Apr 24th 2019, 06:57 |
ra7bi |
wow |
| # |
Apr 24th 2019, 06:56 |
ra7bi |
`UsersPhotos` hasMany `Photos ` Relation between UsersPhotos and Photos table |
| # |
Apr 24th 2019, 06:56 |
conehead |
You wouldnt need a join table for hasMany |
| # |
Apr 24th 2019, 06:55 |
conehead |
Hm shouldnt it be belongsToMany? |
| # |
Apr 24th 2019, 06:55 |
ra7bi |
and the relation type = hasmany |
| # |
Apr 24th 2019, 06:55 |
ra7bi |
user_id |
| # |
Apr 24th 2019, 06:54 |
conehead |
is the name of the fields `User_id` oder `user_id`? Should be all lower cased |
| # |
Apr 24th 2019, 06:53 |
ra7bi |
@conehead i changed the name as you mentioned but , data get stored in photos and users but nothing stored in photos_users |
| # |
Apr 24th 2019, 06:52 |
COOurb |
I have inner join and max(0 function |
| # |
Apr 24th 2019, 06:52 |
COOurb |
hi, I need to get last occurrence of entry based on it's field value, like "max(date)". I have sql expression but dunno how to convert into query buildeer "call chain" |
| # |
Apr 24th 2019, 06:43 |
conehead |
@ra7bi As far as I know...tables would need to be named: `users`, `photos_users`, `photos`. See: https://book.cakephp.org/3.0/en/intro/conventions.html#database-conventions So you would probably at least have to change the join_table when defining your association. See here: https://book.cakephp.org/3.0/en/orm/associations.html#belongstomany-associations |
| # |
Apr 24th 2019, 06:17 |
ra7bi |
Please help .and thanks |
| # |
Apr 24th 2019, 06:17 |
ra7bi |
``` Users -------> UsersPhoto <-------- Photos ``` Like this |
| # |
Apr 24th 2019, 06:16 |
ra7bi |
do cake will understand this type of relation or i need to write the code myself |
| # |
Apr 24th 2019, 06:15 |
ra7bi |
Hello , i need a help , i've three tables ``` Users , UsersPhotos , Photos ``` i want to insert User data with photos and `UsersPhotos` FYI UsersPhotos have User_id , Photo_id coz it's many to many relation |