| # |
Sep 22nd 2011, 16:57 |
scoutmstershke |
http://mark-story.com/posts/view/using-bindmodel-to-get-to-deep-relations |
| # |
Sep 22nd 2011, 16:56 |
TheWarden |
the primary key in the dongle_keys_hardwares is id though. |
| # |
Sep 22nd 2011, 16:56 |
robcowie |
I get that part, and it works with application to multiple applicants, but I can't get it to work with multiple residences linked to the applicants. I can't find any docs to point me in the right direction |
| # |
Sep 22nd 2011, 16:55 |
TheWarden |
okay.. I thought of something else maybe this is the issue here... the dongle_keys table has an id column that then links to the dongles_key_hardwares table that is linked in that table to the column dongle_keys_id. Is there anything more I need to do for that to work with present configuration? |
| # |
Sep 22nd 2011, 16:55 |
scoutmstershke |
and once it calls it, it automaticly un binds |
| # |
Sep 22nd 2011, 16:55 |
scoutmstershke |
hard to find one sec I 'll show you an example |
| # |
Sep 22nd 2011, 16:54 |
scoutmstershke |
yeah build your form in the view then pass the $this->data to $this->model->SaveAll($data); |
| # |
Sep 22nd 2011, 16:54 |
TheWarden |
scoutmstershke: sounds like a better route but no I haven't done that. This should work though but as for the bind model, where do I read on this? I must have missed it or don't recall. |
| # |
Sep 22nd 2011, 16:53 |
scoutmstershke |
so instead of having that association always parseing mysql databse it only pull when needed |
| # |
Sep 22nd 2011, 16:53 |
robcowie |
I can't work syntax for the form helper to make saveAll work, any pointers? |
| # |
Sep 22nd 2011, 16:53 |
robcowie |
I asked earlier, but got called away: I have a few models - application has many applicants, applicant has many residences, residence has one address, and want a form for a new application that has 2 applicants, with 3 residences and address for each. Can I do that with saveAll, or do I need to step through the $this->data array in the controller and save like that? |
| # |
Sep 22nd 2011, 16:53 |
spongebob |
Hi, a quick question re updateAll(). The docs show examples ofâ?¦ array('Baker.created <=' => $this_year) and array('Ticket.customer_id' => 453) for the conditions arrays. Does this mean that the equals is taken for granted on the second one and it doesn't need to beâ?¦ array('Ticket.customer_id =' => 453) |
| # |
Sep 22nd 2011, 16:53 |
scoutmstershke |
rob just ask your questions |
| # |
Sep 22nd 2011, 16:52 |
scoutmstershke |
done vis the controller |
| # |
Sep 22nd 2011, 16:52 |
scoutmstershke |
it a function that allows you to make associations on the fly I use them were I only need it once |
| # |
Sep 22nd 2011, 16:52 |
TheWarden |
scoutmstershke: bind model ? |
| # |
Sep 22nd 2011, 16:51 |
TheWarden |
scoutmstershke: yes the user has access to the table in question. |
| # |
Sep 22nd 2011, 16:51 |
robcowie |
Can any one help me with using for the form helper with multiple linked models and saveAll |
| # |
Sep 22nd 2011, 16:50 |
TheWarden |
scoutmstershke: ahh good point I never double checked that... let me go see.. oh man I will kick myself it that is all it is. |
| # |
Sep 22nd 2011, 16:50 |
scoutmstershke |
and have you tried bind model to see if that would work? |
| # |
Sep 22nd 2011, 16:49 |
TheWarden |
let me be more clear, the present tables I will be working with within this context all resides on the in the same database. |
| # |
Sep 22nd 2011, 16:49 |
scoutmstershke |
have you tried just doing a query to make sure it has access to the db? |
| # |
Sep 22nd 2011, 16:48 |
robcowie |
hello again |
| # |
Sep 22nd 2011, 16:48 |
TheWarden |
For now yes as I move forward there will be cases that it will be in different database. |
| # |
Sep 22nd 2011, 16:48 |
scoutmstershke |
same* |
| # |
Sep 22nd 2011, 16:48 |
scoutmstershke |
? |
| # |
Sep 22nd 2011, 16:48 |
scoutmstershke |
are the tables in the sma db |
| # |
Sep 22nd 2011, 16:47 |
TheWarden |
well presently it is only one database... also keep in mind what you are looking at is a plugin and the database.php is from the app. Therefore this is why I require multiple. |
| # |
Sep 22nd 2011, 16:47 |
ScottO_ |
and you only need an association in one db |
| # |
Sep 22nd 2011, 16:47 |
TheWarden |
scoutmstershke: no I haven't actually. |
| # |
Sep 22nd 2011, 16:47 |
ScottO_ |
but that example is across multiple datbases |
| # |
Sep 22nd 2011, 16:46 |
ScottO_ |
TheWarden: you may need the 'with' key in the association |
| # |
Sep 22nd 2011, 16:46 |
ScottO_ |
lol |
| # |
Sep 22nd 2011, 16:46 |
scoutmstershke |
nvm im wrong anyway |
| # |
Sep 22nd 2011, 16:45 |
ScottO_ |
scoutmstershke: he shouldnt need usesTable |
| # |
Sep 22nd 2011, 16:45 |
scoutmstershke |
have you noticed youe $useTable is spelled wrong? |
| # |
Sep 22nd 2011, 16:45 |
TheWarden |
scoutmstershke: the table is dongle_keys_hardwares there is not prefix of web_. It's not loading the model from what I can tell at all and I don't see any query going to MySQL when I do a <?php echo $this->element('sql_dump'); ?> for that other table. |
| # |
Sep 22nd 2011, 16:45 |
ScottO_ |
TheWarden: http://www.foldifoldi.com/?p=436 |
| # |
Sep 22nd 2011, 16:44 |
ScottO_ |
its not like you are trying to do an association across multi[ple databases |
| # |
Sep 22nd 2011, 16:44 |
ScottO_ |
its an association on one db |
| # |
Sep 22nd 2011, 16:43 |
scoutmstershke |
wtf never seen that error before |