Re: Form Validation
Before accusing the manual of being crap, perhaps you should take some
time to actually read it?
How to implement validation in the model:
http://book.cakephp.org/view/1143/Data-Validation
How to do validation from your controller:
http://book.cakephp.org/view/1182/Validating-Data-from-the-Controller
How to show validation message: On
http://book.cakephp.org/view/1143/Data-Validation
it says "For more information about how to handle the displaying of
validation errors, check out the section covering FormHelper." in the
second paragraph. Reading through the section on the FormHelper,
you'll quickly discover how it works.
All this stuff in one place: http://book.cakephp.org/view/1538/Data-Validation
As for your immediate issue, if you had actually read the section in
the book about validation data from the controller, you'd know exactly
what to do.
http://book.cakephp.org/view/1182/Validating-Data-from-the-Controller
I quote:
First, set the data to the model:
$this->ModelName->set( $this->data );
Then, to check if the data validates, use the validates method of the
model, which will return true if it validates and false if it doesn't:
if ($this->ModelName->validates()) {// it validated logic} else
{// didn't validate logic}
On Apr 29, 4:31 am, Sanfly wrote:
> Hi
>
> My cake version is 1.3.7
>
> I'm just learning form validation and am having a few issues.
>
> Firstly, the manual is crap in that it doesn't tell you how to
> implement the validation in your model, and it doesn't tell you how to
> show the validation error messages in your view. Took a lot of
> digging to find all that!
>
> Anyway, on the the problem at hand. I thought I had this working on
> one field, went to implement for the rest of my fields and now it is
> always validating the form even when I have deliberately used inputs
> that should fail validation. I have stripped it back down to one
> field to try and get it working again
>
> In my model: user.php
>
> // VALIDATION
> var $validate = array(
> 'first_name' => 'notEmpty'
>
> );
>
> In my controller:
>
> function add(){
>
> if($this->data){
> if ($this->User->validates($this->data)) {
> echo "does validate";
>
> }
> else { //data doesn't validate
> echo "doesnt validate";
> $this->Session->setFlash('Please correct
> errors below.');
> }
>
> }
> }
>
> Can anyone see an obvious error that I have overlooked?
>
> BTW, the 'does validate' and 'doesn't validate' are just in there for
> me to see easily where my problems are occuring. Obviously wouldnt be
> there for production
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Form Validation
Before you call $this->User->validates() you must the data to model...do
this
$this->User->set($this->data)
On Apr 29, 2011 4:31 AM, "Sanfly" wrote:
Hi
My cake version is 1.3.7
I'm just learning form validation and am having a few issues.
Firstly, the manual is crap in that it doesn't tell you how to
implement the validation in your model, and it doesn't tell you how to
show the validation error messages in your view. Took a lot of
digging to find all that!
Anyway, on the the problem at hand. I thought I had this working on
one field, went to implement for the rest of my fields and now it is
always validating the form even when I have deliberately used inputs
that should fail validation. I have stripped it back down to one
field to try and get it working again
In my model: user.php
// VALIDATION
var $validate = array(
'first_name' => 'notEmpty'
);
In my controller:
function add(){
if($this->data){
if ($this->User->validates($this->data)) {
echo "does validate";
}
else { //data doesn't validate
echo "doesnt validate";
$this->Session->setFlash('Please correct
errors below.');
}
}
}
Can anyone see an obvious error that I have overlooked?
BTW, the 'does validate' and 'doesn't validate' are just in there for
me to see easily where my problems are occuring. Obviously wouldnt be
there for production
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Form Validation
Hi
My cake version is 1.3.7
I'm just learning form validation and am having a few issues.
Firstly, the manual is crap in that it doesn't tell you how to
implement the validation in your model, and it doesn't tell you how to
show the validation error messages in your view. Took a lot of
digging to find all that!
Anyway, on the the problem at hand. I thought I had this working on
one field, went to implement for the rest of my fields and now it is
always validating the form even when I have deliberately used inputs
that should fail validation. I have stripped it back down to one
field to try and get it working again
In my model: user.php
// VALIDATION
var $validate = array(
'first_name' => 'notEmpty'
);
In my controller:
function add(){
if($this->data){
if ($this->User->validates($this->data)) {
echo "does validate";
}
else { //data doesn't validate
echo "doesnt validate";
$this->Session->setFlash('Please correct errors
below.');
}
}
}
Can anyone see an obvious error that I have overlooked?
BTW, the 'does validate' and 'doesn't validate' are just in there for
me to see easily where my problems are occuring. Obviously wouldnt be
there for production
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: an appointment system...
I integrated a calendar plugin. Worked well. Had a few issues that still exist but I'll post it up this weekend or later today. On 29 April 2011 06:04, Matt Murphy wrote: > I gotta agree. > > > On Thu, Apr 28, 2011 at 12:37 PM, Miloš Vučinić wrote: > >> Why don't you just use google calendar or some other management >> support software ? Comparing to what he has to pay you to do it, plus >> the time you will not be working on something useful it pays off. >> >> On Apr 28, 5:14 pm, Tran Cao Thai wrote: >> > i used to play around with full calendar (a plugin of jquery) when doing >> my >> > bachelor. It is good, but we still had to configure a lot (3000 lines of >> > javascript). In my opinion, building everything from scratch is a lot >> > better than trying to hack some complex systems. So if you still have >> time, >> > build your own >> > >> > >> > >> > >> > >> > >> > >> > On Thu, Apr 28, 2011 at 11:04 PM, Tan Cheng >> wrote: >> > > Hi folks, >> > >> > > My boss ask me to create an "appointment system", basically, I need a >> > > calendar that I can add events, and maybe a message system. >> > >> > > I haven't found any good plug-in for this. So anybody has any related >> > > experience doing this with php? Where should I start looking at? >> > >> > > Any input will be greatly appreciated! >> > >> > > Thank you! >> > >> > > -- >> > > Our newest site for the community: CakePHP Video Tutorials >> > >http://tv.cakephp.org >> > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help >> > > others with their CakePHP related questions. >> > >> > > To unsubscribe from this group, send email to >> > > cake-php+unsubscr...@googlegroups.com For more options, visit this >> group >> > > athttp://groups.google.com/group/cake-php >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> cake-php+unsubscr...@googlegroups.com For more options, visit this group >> at http://groups.google.com/group/cake-php >> > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Validate from within a model
You can also create the folders and make the writable before hand, that way the file will always upload. On Apr 28, 12:55 pm, cricket wrote: > On Thu, Apr 28, 2011 at 2:17 PM, func0der wrote: > > Can you explain that a bit more precise. > > http://php.net/manual/en/function.is-dir.phphttp://www.php.net/manual/en/function.is-writable.php > > I usually handle uploads on the controller/component side. Save your > model record, get the new ID, save the file, update the record. You > can leave out the initial save in some cases but you said that you're > using the id for the file name so you'd need 2 saves. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Custom Find sending back strange results
All I want to do is have one find for my comments in each associated
model. I would love to do this in the Comment model and only have to
do it once but that wasn't working out.
SHOW CONTROLLER
$this->paginate = array('comments', 'id' => $show['Show']['id'],
'model' => 'Show');
$comments = $this->paginate();
$this->set(compact('show', 'comments'));
SHOW MODEL
public $_findMethods = array('comments' => true);
public function _findComments($state, $query, $results=array()) {
if ($state == "before") {
$query = $this->__getComments($query['id'], $query['model'],
$query);
return $query;
} else {
return $results;
}
}
private function __getComments($id, $model, $query) {
$query = ClassRegistry::init('Comment')->find('all', array(
'contain' => array(
'User' => array(
'fields' => array('id', 'username',
'slug'),
'Image' => array(
'fields' => array('name')
)
)
),
'conditions' => array(
'Comment.typeID' => $id,
'Comment.model' => $model
),
'limit' => 5,
'order' => array('Comment.created' => 'desc')
));
return $query;
}
RESULTS
This is the one I want:
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`user_id`,
`Comment`.`typeID`, `Comment`.`model`, `Comment`.`comment`,
`Comment`.`created`, `Comment`.`modified`, `User`.`id`,
`User`.`username`, `User`.`slug` FROM `comments` AS `Comment` LEFT
JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE
`Comment`.`typeID` = 2 AND `Comment`.`model` = 'Show' ORDER BY
`Comment`.`created` desc LIMIT 5
This is also on the sql log and it seems to be the one the view is
using:
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`user_id`,
`Comment`.`typeID`, `Comment`.`model`, `Comment`.`comment`,
`Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment`
WHERE `Comment`.`typeID` IN (2, 3) ORDER BY `Comment`.`created` DESC
I don't even understand where it is coming from because I didn't
define it.
And I get these errors:
Notice (8): Undefined index: page [CORE/cake/libs/model/model.php,
line 2094]
Notice (8): Undefined index: order [CORE/cake/libs/model/model.php,
line 2100]
Notice (8): Undefined index: order [CORE/cake/libs/model/model.php,
line 2103]
Notice (8): Undefined index: callbacks [CORE/cake/libs/model/
model.php, line 2105]
Notice (8): Undefined index: callbacks [CORE/cake/libs/model/
model.php, line 2130]
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: an appointment system...
I gotta agree. On Thu, Apr 28, 2011 at 12:37 PM, Miloš Vučinić wrote: > Why don't you just use google calendar or some other management > support software ? Comparing to what he has to pay you to do it, plus > the time you will not be working on something useful it pays off. > > On Apr 28, 5:14 pm, Tran Cao Thai wrote: > > i used to play around with full calendar (a plugin of jquery) when doing > my > > bachelor. It is good, but we still had to configure a lot (3000 lines of > > javascript). In my opinion, building everything from scratch is a lot > > better than trying to hack some complex systems. So if you still have > time, > > build your own > > > > > > > > > > > > > > > > On Thu, Apr 28, 2011 at 11:04 PM, Tan Cheng > wrote: > > > Hi folks, > > > > > My boss ask me to create an "appointment system", basically, I need a > > > calendar that I can add events, and maybe a message system. > > > > > I haven't found any good plug-in for this. So anybody has any related > > > experience doing this with php? Where should I start looking at? > > > > > Any input will be greatly appreciated! > > > > > Thank you! > > > > > -- > > > Our newest site for the community: CakePHP Video Tutorials > > >http://tv.cakephp.org > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > cake-php+unsubscr...@googlegroups.com For more options, visit this > group > > > athttp://groups.google.com/group/cake-php > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: an appointment system...
Tan, Take a look at this note from Derick Ng that may give a jumpstart to your effort ;) http://planetcakephp.org/aggregator/items/535-cakephp-calendar-helper cheers, Sergio -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: an appointment system...
Well google does offer connectivity with it's data. You could do it and still do what you want with the data. On Apr 28, 2:01 pm, Tan Cheng wrote: > It's a good point, man. But we are trying to integrate this into > another web app we developed before and share the same users table. > Thanks for your input. > > On Apr 28, 12:37 pm, Miloš Vučinić wrote: > > > > > > > > > Why don't you just use google calendar or some other management > > support software ? Comparing to what he has to pay you to do it, plus > > the time you will not be working on something useful it pays off. > > > On Apr 28, 5:14 pm, Tran Cao Thai wrote: > > > > i used to play around with full calendar (a plugin of jquery) when doing > > > my > > > bachelor. It is good, but we still had to configure a lot (3000 lines of > > > javascript). In my opinion, building everything from scratch is a lot > > > better than trying to hack some complex systems. So if you still have > > > time, > > > build your own > > > > On Thu, Apr 28, 2011 at 11:04 PM, Tan Cheng wrote: > > > > Hi folks, > > > > > My boss ask me to create an "appointment system", basically, I need a > > > > calendar that I can add events, and maybe a message system. > > > > > I haven't found any good plug-in for this. So anybody has any related > > > > experience doing this with php? Where should I start looking at? > > > > > Any input will be greatly appreciated! > > > > > Thank you! > > > > > -- > > > > Our newest site for the community: CakePHP Video Tutorials > > > >http://tv.cakephp.org > > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp > > > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > > cake-php+unsubscr...@googlegroups.com For more options, visit this group > > > > athttp://groups.google.com/group/cake-php-Hide quoted text - > > > - Show quoted text - -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Validate from within a model
On Thu, Apr 28, 2011 at 2:17 PM, func0der wrote: > Can you explain that a bit more precise. http://php.net/manual/en/function.is-dir.php http://www.php.net/manual/en/function.is-writable.php I usually handle uploads on the controller/component side. Save your model record, get the new ID, save the file, update the record. You can leave out the initial save in some cases but you said that you're using the id for the file name so you'd need 2 saves. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Any way to pass multiple order string to Pagination
'order' => array( 'Model.field' => 'desc', 'Model.field2' => 'desc') should work, though On 28 Apr., 21:47, euromark wrote: > http://cakephp.lighthouseapp.com/projects/42648/tickets/325-adding-pa... > although it does not seem to be a duplicate of the other tickets - two > different things... > > On 28 Apr., 21:45, "Mr.Jayesh" wrote: > > > > > > > > > Hi Mates, > > > Am stuck at place where am not able to pass multiple order strings to > > pagination. I am using pagination and have done this in my controller: > > > var $paginate = array( > > 'limit' => 15, > > 'order' => array( > > 'Model.field' => 'desc', > > 'Model.field' => 'desc') > > ); > > > But the results is just working the first string and ignoring the > > second one. > > > Please, anyone guide me, I think have mistaken somewhere. Am unable to > > get solution for this. > > > Regards. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Any way to pass multiple order string to Pagination
http://cakephp.lighthouseapp.com/projects/42648/tickets/325-adding-paginator-sort-to-order-by-two-fields although it does not seem to be a duplicate of the other tickets - two different things... On 28 Apr., 21:45, "Mr.Jayesh" wrote: > Hi Mates, > > Am stuck at place where am not able to pass multiple order strings to > pagination. I am using pagination and have done this in my controller: > > var $paginate = array( > 'limit' => 15, > 'order' => array( > 'Model.field' => 'desc', > 'Model.field' => 'desc') > ); > > But the results is just working the first string and ignoring the > second one. > > Please, anyone guide me, I think have mistaken somewhere. Am unable to > get solution for this. > > Regards. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Any way to pass multiple order string to Pagination
Hi Mates, Am stuck at place where am not able to pass multiple order strings to pagination. I am using pagination and have done this in my controller: var $paginate = array( 'limit' => 15, 'order' => array( 'Model.field' => 'desc', 'Model.field' => 'desc') ); But the results is just working the first string and ignoring the second one. Please, anyone guide me, I think have mistaken somewhere. Am unable to get solution for this. Regards. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Cake 1.2 problem with XML files in plugin vendors folder
On Thu, Apr 28, 2011 at 12:30 PM, lsenft wrote: > I would like to load an XML file from a plugin vendors folder. I get > the following error: > > Error: myfile.xmlController could not be found. > > Is there a way to serve xml files from a plugin's vendors folder? What's the code that leads to the error? Some days, it's like every other person posting to this list assumes everyone else can read minds. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Query with conditions in HABTM models
On Thu, Apr 28, 2011 at 12:31 PM, david hc wrote:
> Hello,
> I have a table posts related with table categories with de habtm table
> posts_categories.
>
> posts.id
> categories.id
> posts_categories.post_id
> posts_categories.category_id
>
> I'm trying to get all the records WITHOUT category (because I have
> posts taken from RSS and not categorized yet).
>
> My model Post has the habtm array, and it works fine (I get all the
> posts with there categories when I find all).
>
> My question is how could I get all the records in posts table that are
> not included in related table. Any idea?
Something like this should work.
public function uncategorized()
{
$this->set(
'data',
$this->Post->fetchOrphans()
);
$this->set(
'categories',
$this->Post->Category->find('list')
);
}
Post:
public function fetchOrphans()
{
$ids = Set::extract(
$this->PostCategory->find('all'),
'{n}.PostCategory.post_id'
);
return $this->find(
'all',
array(
'conditions' => array(
'NOT' => array(
'Post.id' => $ids
)
)
)
);
}
Not the most elegant code as it it relies on two queries
and--worse--uses IN, which isn't handled well by MySQL at least. But
it should do the job and, given the use case, it's not like this
method is going to be called constantly. I generally don't worry too
much about performance for these sorts of little-used admin functions
(within reason, of course).
Also, Cake's automagic joining puts the joined table names in
alphabetical order, so your table should be categories_posts and the
model CategoryPost. This isn't completely necessary if you've created
a model for the join but, in order to be sure you don't run into a
gotcha down the road, it may be worth following Cake's convention.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: xml parser now what
On Thu, Apr 28, 2011 at 10:36 AM, Janu wrote: > Hi > > I am getting different xmls and after parsing I want them to be pushed > to database. Is there an easy way to accomplish that. Is there a > database to xml mapping tool available for cakephp. You can turn the XML into an array but you'll need to do some work to ensure the array structure matches your schema. See here: http://blog.crazytje.be/xml-to-array-and-array-to-xml-in-cakephp/ -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: do i need to create a controller for all pages in \views\pages\ folder
On Thu, Apr 28, 2011 at 11:49 AM, Jeremy Burns | Class Outfit wrote: > Really wrong. Please read the guide, even if the Blog tutorial isn't right > for you. Start here: http://book.cakephp.org/view/958/The-Pages-Controller. > What you are trying to do is one of the most basic things and you are way > off line. Although, granted, it's easy to see how it could be confusing. varai, if you want to include static, full HTML pages put them under app/webroot. You can even have a deep directory structure, eg app/webroot/foo.bar.html You would access this with: http://www.domain.com/foo/bar.html Take a close look at the rewrite rules in the .htaccess files. What they do is check if the requested URL is for an existing file or directory under app/webroot. If so, it serves that, other wise it passes the request to index.php, which in turn passes it to Dispatcher. It's the latter which is complaining that the request doesn't make sense. If you want your static pages to use an existing layout then you need to change the static pages into templates. In that case, you'd use the PagesController and put your various pages in the app/views/pages directory. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: how to embed swf animation in home.ctp of my cakephp project
On Thu, Apr 28, 2011 at 11:47 AM, varai wrote: > Hi > > "Not working" means no flash animation is displaying. > >> Can you access main_ani.swf directly in your web browser? > Yes, I can. Using what path? Is the flash file sitting in app/webroot? Try: /main_ani.swf (note the slash) Also, your markup gives the path for the embed tag but not the object. You need to realise that embed and object are two different things. Some browsers use one and some the other. The object tag requires param tags inside it which have the same values as the attributes of the embed tag. Notice that you have not included the path to the flash file for the object tag. >> I haven't read that tutorial, but I just skimmed it, and it doesn't say to >> call $this->renderSwf; it says to call $flash->renderSwf. > Yes, I had tried $flash->renderSwf earlier, But i got the following > error: > Notice (8): Undefined variable: flash [APP\views\pages\home.ctp, line That would suggest you haven't loaded the FlashHelper. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Problem with Variables in Elements
On Thu, Apr 28, 2011 at 2:28 PM, cricket wrote: > > Looks ok to me. Are you sure the spelling is good? Does the call to > this element occur in any other layouts? Maybe you're in a different > layout, which doesn't also have the variable assignment. Long shot, I > know. > Also, try debug($this->viewVars); -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Problem with Variables in Elements
On Thu, Apr 28, 2011 at 10:10 AM, Santiago Basulto
wrote:
> Hello People,
>
> i'm using CakePHP 1.3.5.
>
> When i pass a variable to an element, as the book says
> (http://book.cakephp.org/view/1081/Elements) i can't use it, i get
> this error message: Notice (8): Undefined variable: variable
> [APP/views/elements/header.ctp, line 2]
>
> Here's my code:
> In the layout:
> element('header',array('variable'=>'value')); ?>
> In the element (here's where te error arises):
> Notice (8): Undefined variable:
> variable [APP/views/elements/header.ctp, line 2]
>
> What's going on? I've disabled all cache but still doesn't work.
Looks ok to me. Are you sure the spelling is good? Does the call to
this element occur in any other layouts? Maybe you're in a different
layout, which doesn't also have the variable assignment. Long shot, I
know.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
xml parser now what
Hi I am getting different xmls and after parsing I want them to be pushed to database. Is there an easy way to accomplish that. Is there a database to xml mapping tool available for cakephp. thanks -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Mysql 1064 error
On Wed, Apr 27, 2011 at 3:28 PM, blue_negative wrote: > Hi, > > I am using Cake 1.3.8 and get a Mysql error code 1064. Following is > the details in debug mode > Query: check > Error: 1064: You have an error in your SQL syntax; check the manual > that corresponds to your MySQL server version for the right syntax to > use near '' at line 1 > > The associated mode has following relationships: > 4 hasMany > 1 belongsTo > 1 HBTM > > Its seems that the it is generating a sql query "Check" and hence it > is throwing the error. The interesting part is it does not generate > this "check: query for my other mode. Can't say for sure as you haven't posted either the code or the SQL, but this usually happens when you call a nonexistant method of the model, eg. $this->YourModel->check() -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Validate from within a model
Can you explain that a bit more precise.
On Apr 28, 7:59 pm, Miles J wrote:
> Why don't you just validate that the destination folder exists and is
> writable?
>
> On Apr 28, 2:57 am, func0der wrote:
>
>
>
>
>
>
>
> > Okay.
>
> > I'm doing it like this.
>
> > I'm havin a new file uploaded.
> > The file data, like mime type, name etc. will be saved in the db under
> > the file id.
> > I'm using that id as a filename for the files in my filesystem.
> > So i need to first create a db record to use the id.
>
> > Afterwards i'm trying to save the file.
> > If for example the folder for the upload is not writable or i don't
> > have the permission or any other case i can't figure out now happens,
> > then i want to cancel the upload and delete the db record so i won't
> > have 2 or more of the same file in the database.
>
> > This user is getting an error message that something fails during the
> > file upload and also i want to let the users know what they are
> > supposed to do next.
>
> > This is my intention.
>
> > And i would never validate file uploads with javascripts because of 2
> > reasons:
> > First, i don't know how
> > Second, i know enough to know that this kind of validation wouldn't be
> > save enough ^^
>
> > Nothing against you, but js alone isn't the key.
>
> > On 27 Apr., 23:54, Miles J wrote:
>
> > > You dont need to use validates(), just set an error manually.
>
> > > $this->invalidate('fields', 'Error message.');
>
> > > Also, your approach is still wrong IMO. You should be doing all error
> > > checking before any save functionality is triggered. In what scenario
> > > will the image NOT copy/transfer? I have yet to ever run into that
> > > problem.
>
> > > On Apr 27, 12:31 pm, func0der wrote:
>
> > > > okay...i think i got it.
>
> > > > It is part of the MVC pattern, isn't it?
>
> > > > The model is NOT connected to the view or the helpers. These two are
> > > > getting their data or the invalid error messages by the controller.
>
> > > > Am i right here?
>
> > > > On 27 Apr., 21:00, func0der wrote:
>
> > > > > I can re-save and delete, so why i shouldn't be able to revalidate?
>
> > > > > The error message is also in the "validationErrors" variable but while
> > > > > the output of the form there is no error message.
> > > > > But why?
>
> > > > > On 27 Apr., 20:38, Miles J wrote:
>
> > > > > > You can't validates() something after the model save has already
> > > > > > happened. Use a behavior for validation or use my plugin.
>
> > > > > >https://github.com/milesj/cake-uploader
>
> > > > > > And an example model on how to use it.
>
> > > > > >https://github.com/milesj/cake-uploader/blob/master/tests/models/uplo...
>
> > > > > > On Apr 27, 11:18 am, func0der wrote:
>
> > > > > > > Hey guys,
>
> > > > > > > i'm having a file upload here.
> > > > > > > I'm using "afterSave" to place the uploaded file in the
> > > > > > > filesystem.
>
> > > > > > > function afterSave($created){
> > > > > > > //get the entry id
> > > > > > > $this->data['DataFile']['id'] =
> > > > > > > $this->getInsertId();
> > > > > > > if(!$this->saveDataFile($this->data)){
> > > > > > >
> > > > > > > $this->delete($this->data['DataFile']['id']);
> > > > > > > $this->data['DataFile']['data_file'] =
> > > > > > > array();
> > > > > > > $this->validates();
> > > > > > > }
> > > > > > > }
>
> > > > > > > "saveDataFile" is a function which tries to places the uploaded
> > > > > > > file
> > > > > > > in the file system and returns false in case of copy fails.
>
> > > > > > > If the copy should fail i delete the record from the database and
> > > > > > > set
> > > > > > > the "data_file" index which normally cotains the uploaded file
> > > > > > > information to an empty array. This is because i want the
> > > > > > > validation
> > > > > > > to fail so the file upload field gets an error message while
> > > > > > > rendering.
>
> > > > > > > The problem now is that the upload form does NOT! contain the
> > > > > > > validation error message for that particular field.
>
> > > > > > > Do you know what i am doing wrong?
>
> > > > > > > Greetings
> > > > > > > func0der
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Validate from within a model
Why don't you just validate that the destination folder exists and is
writable?
On Apr 28, 2:57 am, func0der wrote:
> Okay.
>
> I'm doing it like this.
>
> I'm havin a new file uploaded.
> The file data, like mime type, name etc. will be saved in the db under
> the file id.
> I'm using that id as a filename for the files in my filesystem.
> So i need to first create a db record to use the id.
>
> Afterwards i'm trying to save the file.
> If for example the folder for the upload is not writable or i don't
> have the permission or any other case i can't figure out now happens,
> then i want to cancel the upload and delete the db record so i won't
> have 2 or more of the same file in the database.
>
> This user is getting an error message that something fails during the
> file upload and also i want to let the users know what they are
> supposed to do next.
>
> This is my intention.
>
> And i would never validate file uploads with javascripts because of 2
> reasons:
> First, i don't know how
> Second, i know enough to know that this kind of validation wouldn't be
> save enough ^^
>
> Nothing against you, but js alone isn't the key.
>
> On 27 Apr., 23:54, Miles J wrote:
>
>
>
>
>
>
>
> > You dont need to use validates(), just set an error manually.
>
> > $this->invalidate('fields', 'Error message.');
>
> > Also, your approach is still wrong IMO. You should be doing all error
> > checking before any save functionality is triggered. In what scenario
> > will the image NOT copy/transfer? I have yet to ever run into that
> > problem.
>
> > On Apr 27, 12:31 pm, func0der wrote:
>
> > > okay...i think i got it.
>
> > > It is part of the MVC pattern, isn't it?
>
> > > The model is NOT connected to the view or the helpers. These two are
> > > getting their data or the invalid error messages by the controller.
>
> > > Am i right here?
>
> > > On 27 Apr., 21:00, func0der wrote:
>
> > > > I can re-save and delete, so why i shouldn't be able to revalidate?
>
> > > > The error message is also in the "validationErrors" variable but while
> > > > the output of the form there is no error message.
> > > > But why?
>
> > > > On 27 Apr., 20:38, Miles J wrote:
>
> > > > > You can't validates() something after the model save has already
> > > > > happened. Use a behavior for validation or use my plugin.
>
> > > > >https://github.com/milesj/cake-uploader
>
> > > > > And an example model on how to use it.
>
> > > > >https://github.com/milesj/cake-uploader/blob/master/tests/models/uplo...
>
> > > > > On Apr 27, 11:18 am, func0der wrote:
>
> > > > > > Hey guys,
>
> > > > > > i'm having a file upload here.
> > > > > > I'm using "afterSave" to place the uploaded file in the filesystem.
>
> > > > > > function afterSave($created){
> > > > > > //get the entry id
> > > > > > $this->data['DataFile']['id'] =
> > > > > > $this->getInsertId();
> > > > > > if(!$this->saveDataFile($this->data)){
> > > > > >
> > > > > > $this->delete($this->data['DataFile']['id']);
> > > > > > $this->data['DataFile']['data_file'] =
> > > > > > array();
> > > > > > $this->validates();
> > > > > > }
> > > > > > }
>
> > > > > > "saveDataFile" is a function which tries to places the uploaded file
> > > > > > in the file system and returns false in case of copy fails.
>
> > > > > > If the copy should fail i delete the record from the database and
> > > > > > set
> > > > > > the "data_file" index which normally cotains the uploaded file
> > > > > > information to an empty array. This is because i want the validation
> > > > > > to fail so the file upload field gets an error message while
> > > > > > rendering.
>
> > > > > > The problem now is that the upload form does NOT! contain the
> > > > > > validation error message for that particular field.
>
> > > > > > Do you know what i am doing wrong?
>
> > > > > > Greetings
> > > > > > func0der
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: an appointment system...
It's a good point, man. But we are trying to integrate this into another web app we developed before and share the same users table. Thanks for your input. On Apr 28, 12:37 pm, Miloš Vučinić wrote: > Why don't you just use google calendar or some other management > support software ? Comparing to what he has to pay you to do it, plus > the time you will not be working on something useful it pays off. > > On Apr 28, 5:14 pm, Tran Cao Thai wrote: > > > > > i used to play around with full calendar (a plugin of jquery) when doing my > > bachelor. It is good, but we still had to configure a lot (3000 lines of > > javascript). In my opinion, building everything from scratch is a lot > > better than trying to hack some complex systems. So if you still have time, > > build your own > > > On Thu, Apr 28, 2011 at 11:04 PM, Tan Cheng wrote: > > > Hi folks, > > > > My boss ask me to create an "appointment system", basically, I need a > > > calendar that I can add events, and maybe a message system. > > > > I haven't found any good plug-in for this. So anybody has any related > > > experience doing this with php? Where should I start looking at? > > > > Any input will be greatly appreciated! > > > > Thank you! > > > > -- > > > Our newest site for the community: CakePHP Video Tutorials > > >http://tv.cakephp.org > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp > > > others with their CakePHP related questions. > > > > To unsubscribe from this group, send email to > > > cake-php+unsubscr...@googlegroups.com For more options, visit this group > > > athttp://groups.google.com/group/cake-php- Hide quoted text - > > - Show quoted text - -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: an appointment system...
Thank you. I will take a look into that, the full calendar looks pretty good. On Apr 28, 11:14 am, Tran Cao Thai wrote: > i used to play around with full calendar (a plugin of jquery) when doing my > bachelor. It is good, but we still had to configure a lot (3000 lines of > javascript). In my opinion, building everything from scratch is a lot > better than trying to hack some complex systems. So if you still have time, > build your own > > > > On Thu, Apr 28, 2011 at 11:04 PM, Tan Cheng wrote: > > Hi folks, > > > My boss ask me to create an "appointment system", basically, I need a > > calendar that I can add events, and maybe a message system. > > > I haven't found any good plug-in for this. So anybody has any related > > experience doing this with php? Where should I start looking at? > > > Any input will be greatly appreciated! > > > Thank you! > > > -- > > Our newest site for the community: CakePHP Video Tutorials > >http://tv.cakephp.org > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > > cake-php+unsubscr...@googlegroups.com For more options, visit this group > > athttp://groups.google.com/group/cake-php- Hide quoted text - > > - Show quoted text - -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Calling an element based on row selection
On Thu, Apr 28, 2011 at 6:06 AM, heohni
wrote:
> Hi,
>
> My idea is to have a list of database data listed in a table, one row
> per member data details.
> Each member has a link to open a popup (I am using a basic modal
> jquery script). In this popup I would like to have a comment field to
> add comments regarding the selected client.
>
> I am not sure how to do that.
> How can I call the popup with the comment field, which is outsourced
> in a element, and parse the member id to it?
>
> Guess I have a table like
> ...
> memberid 1echo $this->Html->link(__('leave a comment',
> true),?>
>
> memberid 2echo $this->Html->link(__('leave a comment',
> true),?>
>
> memberid 3echo $this->Html->link(__('leave a comment',
> true),?>
>
> My element looks like
>
> Ajax->Form('comment', 'post', array('url' =>
> array('action' => 'comment'))); ?>
>
> ...
>
>
> Ajax->Form->end(); ?>
>
>
I think the best way to handle this is to pass the ID through the
click handler that opens the pop-up, as it's the routine that connects
a Member record row with the form.
BTW, I recommend you use buttons instead of links for this as they're
better suited to the job.
http://particletree.com/features/rediscovering-the-button-element/
Essentially, what you want to do is assign a unique id attribute to
some tag (or rel if it's the right type for that) in each row that's
based on the Member.id. This could be the tr, the td, the a, input, or
button. Because IDs can't begin with a number you'll need to supply
some prefix and then parse out the id.
... ...
... ...
JS:
var member_id = $(this).attr('id').replace(/member_/, '');
The above is for when the id has been given to the button or link
itself. If you apply it instead to the table row (perhaps you have
several buttons per row which handle various tasks) you'd do something
like:
var member_id = $(this).closest('tr').attr('id').replace(/member_/, '');
Once you have the id you can then apply it to the hidden form element.
$('#memberID', $('#popup')).val(member_id);
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Security Blackholing actions I didn't specify
Ok, in the app_controller, I've included my Security component and also
added this little snippet of code for admin pages:
if(isset($this->params['admin'])) :
$this->Security->blackHoleCallback = 'forceSSL';
$this->Security->requireSecure();
endif;
That one's straight outta the book and as far as i can tell, working fine. I
just add that here on the off chance I'm missing something.
In my "carts" controller (for shopping carts) I want to be able to secure
the checkout action, only. Hence I've set up this beforeFilter:
function beforeFilter() {
parent::beforeFilter();
$this->Security->requireSecure('checkout');
$this->Security->blackHoleCallback = 'forceSSL';
}
The problem is that, when I do this, my add action (as in adding an item to
the cart) is getting redirected per the forceSSL function (which also comes
from the book, for reference).
More confusing, when I simply strip the bottom two lines of my beforeFilter
away (thus, I presume, eliminating the effects of the Security component), I
get a 404 error on the action.
Thanks for your time!
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Cake 1.2 problem with XML files in plugin vendors folder
I would like to load an XML file from a plugin vendors folder. I get the following error: Error: myfile.xmlController could not be found. Is there a way to serve xml files from a plugin's vendors folder? Thank you, Levi -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: an appointment system...
Why don't you just use google calendar or some other management support software ? Comparing to what he has to pay you to do it, plus the time you will not be working on something useful it pays off. On Apr 28, 5:14 pm, Tran Cao Thai wrote: > i used to play around with full calendar (a plugin of jquery) when doing my > bachelor. It is good, but we still had to configure a lot (3000 lines of > javascript). In my opinion, building everything from scratch is a lot > better than trying to hack some complex systems. So if you still have time, > build your own > > > > > > > > On Thu, Apr 28, 2011 at 11:04 PM, Tan Cheng wrote: > > Hi folks, > > > My boss ask me to create an "appointment system", basically, I need a > > calendar that I can add events, and maybe a message system. > > > I haven't found any good plug-in for this. So anybody has any related > > experience doing this with php? Where should I start looking at? > > > Any input will be greatly appreciated! > > > Thank you! > > > -- > > Our newest site for the community: CakePHP Video Tutorials > >http://tv.cakephp.org > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > > cake-php+unsubscr...@googlegroups.com For more options, visit this group > > athttp://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Query with conditions in HABTM models
Hello, I have a table posts related with table categories with de habtm table posts_categories. posts.id categories.id posts_categories.post_id posts_categories.category_id I'm trying to get all the records WITHOUT category (because I have posts taken from RSS and not categorized yet). My model Post has the habtm array, and it works fine (I get all the posts with there categories when I find all). My question is how could I get all the records in posts table that are not included in related table. Any idea? All my attempts (conditions, contain...) are wrong :( Thank you very much! David. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Some problem on the hasmany relationship
Hi Jeremy,
U r right!!! it works!! THANKS!
the solution: find('list',
array( 'fields'=>array('business_category_id',
'business_category_id'),);
But i m not able to save the record to this table, CategoryStock.
I did try save(), saveAll(), UpdateAll()...
if i split to : $this->Stock->CategotyStock->save($this->data), i will
get error message:
Undefined index: StockCategory. Why?
Thanks again.
Regards.
On Apr 28, 7:26 pm, jackgoh wrote:
> ahh.. okay, let me try then.
>
> Thanks.
>
> Regards
>
> On Apr 28, 7:00 pm, Jeremy Burns | Class Outfit
>
>
>
> wrote:
> > That's probably because the first value is the array key and you can't have
> > duplicate array keys (your desired result is impossible in PHP). Imagine it
> > as a select list; each option would have the same value (1), which defeats
> > the object. Cake is (in essence) simply doing a loop, adding each value it
> > finds to the resulting array and that will always replace the last value
> > found (it's always array key '1'); hence you end up with the 'last' record.
> > Would it work for you to switch the columns around? That would give you the
> > three values you need.
>
> > Jeremy Burns
> > Class Outfit
>
> > jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> > On 28 Apr 2011, at 11:13,jackgohwrote:
>
> > > When use find('list',), it is:
> > > Array
> > > (
> > > [1] => 4
> > > )
>
> > > But the result suppose is :
>
> > > Array
> > > (
> > > [1] => 7
> > > [1] => 14
> > > [1] => 4
> > > )
>
> > > It is always get the last record.
>
> > > Thanks
>
> > > On Apr 28, 3:14 pm, Jeremy Burns | Class Outfit
> > > wrote:
> > >> What are the results of find list?
>
> > >> Jeremy Burns
> > >> Class Outfit
>
> > >> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> > >> On 28 Apr 2011, at 07:19,jackgohwrote:
>
> > >>> Hi Jeremy,
>
> > >>> - There is a missing ' before category_id after
> > >>> 'associationForeignKey'
> > >>> => sorry, my typo in this content only. sorry.
>
> > >>> - Your conditions in the find->list look wrong; try 'conditions' =>
> > >>> array('stock_id' => $this->Stock->id)
> > >>> => The results are the same. both ways are working, but your
> > >>> suggestion way is better. ;)
>
> > >>> - The convention is to name your joining table CategoryStock (the two
> > >>> models are in alphabetical order). Although your arrangement ought to
> > >>> work, I generally stay with conventions unless there is a compelling
> > >>> reason not to.
> > >>> => I changed it as what you suggested. (in Stock model & StockCategory
> > >>> model)
>
> > >>> - Do you have a model for StockCategory?
> > >>> => Yes:
> > >>> class CategoryStock extends AppModel
> > >>> {
> > >>> var $name = CategoryStocks;
> > >>> }
>
> > >>> - What happens when you use find 'all' rather than 'list'?
> > >>> => i got the correct array!! But the result look like:
> > >>> Array
> > >>> (
> > >>> [0] => Array
> > >>> (
> > >>> [CategoryStock] => Array
> > >>> (
> > >>> [stock_id] => 1
> > >>> [business_category_id] => 4
> > >>> )
>
> > >>> )
>
> > >>> [1] => Array
> > >>> (
> > >>> [CategoryStock] => Array
> > >>> (
> > >>> [stock_id] => 1
> > >>> [business_category_id] => 7
> > >>> )
>
> > >>> )
> > >>> [2] => Array
> > >>> (
> > >>> [CategoryStock] => Array
> > >>> (
> > >>> [stock_id] => 1
> > >>> [business_category_id] => 14
> > >>> )
>
> > >>> )
>
> > >>> )
>
> > >>> - What happens when you die(debug($selectedRecord)) in your controller
> > >>> before passing it to your view?
> > >>> => same as above result.
>
> > >>> Out of interest, what does the resulting SQL look like?
> > >>> => (i simplified) :SELECT CategoryStock.* FROM `stock_CategoryStocks`
> > >>> AS `CategoryStock` WHERE `stock_id` = 1 , effected rows is 3 , which
> > >>> is always correct, when use the find('list'), the effected rows is
> > >>> still 3, but debug($selectedRecord) show only 1 record in the array.
> > >>> Weird.
>
> > >>> Thanks.
>
> > >>> Regards
> > >>> Jack
>
> > >>> On Apr 28, 12:03 pm, Jeremy Burns | Class Outfit
> > >>> wrote:
> > These might be typos but some of the code looks *slightly* odd.
>
> > - There is a missing ' before category_id after 'associationForeignKey'
> > - Your conditions in the find->list look wrong; try 'conditions' =>
> > array('stock_id' => $this->Stock->id)
> > - The convention is to name your joining table CategoryStock (the two
> > models are in alphabetical order). Although your arrangement ought to
> > work, I generally stay with conventions unless there is a compelling
> > reason not to.
> > - Do you have a model for StockCategory?
> > - What happens when you use find 'all' rather th
Re: do i need to create a controller for all pages in \views\pages\ folder
Really wrong. Please read the guide, even if the Blog tutorial isn't right for
you. Start here: http://book.cakephp.org/view/958/The-Pages-Controller. What
you are trying to do is one of the most basic things and you are way off line.
Jeremy Burns
Class Outfit
jeremybu...@classoutfit.com
http://www.classoutfit.com
On 28 Apr 2011, at 16:42, varai wrote:
> Yes, I had already gone through the Blog tutorial. But that doesn't
> have a static page (just to display info). What I'm trying to do is
> similar to contents of about page.
>
> I tried creating a missing_controller.ctp with no contents as below:
> class Missing_Controller extends AppController {
> }
> ?>
> and i'm not getting any errors now.
>
> thanks. :)
>
> On Apr 27, 3:24 pm, Jeremy Burns | Class Outfit
> wrote:
>> You really need to read the guide...what are you are doing is not utilising
>> Cake at all. Follow the Blog tutorial:http://book.cakephp.org/view/1528/Blog
>>
>> Jeremy Burns
>> Class Outfit
>>
>> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>>
>> On 27 Apr 2011, at 08:21, varai wrote:
>>
>>
>>
>>> Hi,
>>
>>> Is it necessary to create a controller for each page in \views\pages\
>>> folder?
>>
>>> I have this static page Preschool.html. And I'm getting the following
>>> error message:
>>> Missing Controller
>>> Error: Preschool.htmlController could not be found.
>>
>>> Error: Create the class Preschool.htmlController below in file:
>>> merry_flowers\controllers\preschool.html_controller.php
>>
>>> >> class Preschool.htmlController extends AppController {
>>
>>>var $name = 'Preschool.html';
>>> }
>>> ?>
>>> Notice: If you want to customize this error message, create
>>> merry_flowers\views\errors\missing_controller.ctp
>>
>>> Even after creating a controller with the above name and contents, i'm
>>> still getting the same Missing Controller message.
>>
>>> As the notice says, if I create missing_controller.ctp, what should
>>> the contents be?
>>
>>> Please help me. I'm cluelessI'm new to cakephp.
>>
>>> thank you.
>>
>>> --
>>> Our newest site for the community: CakePHP Video
>>> Tutorialshttp://tv.cakephp.org
>>> Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
>>> others with their CakePHP related questions.
>>
>>> To unsubscribe from this group, send email to
>>> cake-php+unsubscr...@googlegroups.com For more options, visit this group
>>> athttp://groups.google.com/group/cake-php- Hide quoted text -
>>
>> - Show quoted text -
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com For more options, visit this group at
> http://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: how to embed swf animation in home.ctp of my cakephp project
Hi
"Not working" means no flash animation is displaying.
> Can you access main_ani.swf directly in your web browser?
Yes, I can.
> I haven't read that tutorial, but I just skimmed it, and it doesn't say to
> call $this->renderSwf; it says to call $flash->renderSwf.
Yes, I had tried $flash->renderSwf earlier, But i got the following
error:
Notice (8): Undefined variable: flash [APP\views\pages\home.ctp, line
26]Code | Context-->
renderSwf('main_ani.swf',530,300,'content1');
$___viewFn = "C:\wamp\www\merry_flowers\views\pages\home.ctp"
$___dataForView = array(
"page" => "home",
"subpage" => null,
"title_for_layout" => "Home"
)
$loadHelpers= true
$cached = false
$form = FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$defaultModel = NULL
FormHelper::$_inputDefaults = array
FormHelper::$base = "/merry_flowers"
FormHelper::$webroot = "/merry_flowers/"
FormHelper::$theme = NULL
FormHelper::$here = "/merry_flowers/"
FormHelper::$params = array
FormHelper::$action = "display"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$Html = HtmlHelper object
$html = HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$_crumbs = array
HtmlHelper::$__includedScripts = array
HtmlHelper::$_scriptBlockOptions = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$base = "/merry_flowers"
HtmlHelper::$webroot = "/merry_flowers/"
HtmlHelper::$theme = NULL
HtmlHelper::$here = "/merry_flowers/"
HtmlHelper::$params = array
HtmlHelper::$action = "display"
HtmlHelper::$plugin = NULL
HtmlHelper::$data = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
$session= SessionHelper
SessionHelper::$helpers = array
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "af68519437971d9fba6217ccb9c690fc"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1304005613
SessionHelper::$sessionTime = 1304017613
SessionHelper::$cookieLifeTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$host = NULL
SessionHelper::$timeout = NULL
SessionHelper::$base = "/merry_flowers"
SessionHelper::$webroot = "/merry_flowers/"
SessionHelper::$here = "/merry_flowers/"
SessionHelper::$params = array
SessionHelper::$action = "display"
SessionHelper::$data = NULL
SessionHelper::$theme = NULL
SessionHelper::$plugin = NULL
$page = "home"
$subpage= null
$title_for_layout = "Home"include - APP\views\pages\home.ctp, line
26
View::_render() - CORE\cake\libs\view\view.php, line 731
View::render() - CORE\cake\libs\view\view.php, line 426
Controller::render() - CORE\cake\libs\controller\controller.php, line
909
PagesController::display() - APP\controllers\pages_controller.php,
line 82
Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 204
Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 171
[main] - APP\webroot\index.php, line 83
Fatal error: Call to a member function renderSwf() on a non-object in
C:\wamp\www\merry_flowers\views\pages\home.ctp on line 26
any help is appreciated! :)
On Apr 27, 8:19 pm, Ryan Schmidt wrote:
> On Apr 26, 2011, at 20:52,varaiwrote:
>
> > Does anyone know on how to embed an swf file in myfolder/views/pages/
> > home.ctp?
>
> > I tried the following embed stmt and it is not working:
> >
> > > codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/
> > swflash.cab#version=7,0,19,0" width="550" height="300"
> > title="introductory animation">
> >
> >
> > > pluginspage="http://www.macromedia.com/go/getflashplayer";
> > type="application/x-shockwave-flash">
> >
>
> Define "not working".
>
> Can you access main_ani.swf directly in your web browser?
>
> > I also tried the following after reading
> >http://bakery.cakephp.org/articles/alkemann/2008/11/25/flashhelper-a-...
> > renderSwf('main_ani.swf',530,300,'content1'); ?>
>
> > and I'm getting the error below
> > Fatal error: Call to undefined method View::renderSwf() in C:\wamp\www
> > \merry_flowers\views\pages\home.ctp on line 25
>
> > I couldn't find the renderSwf helper as stated in the link above in C:
> > \wamp\www\cakephp\cake\libs\view\helpers
>
> I haven't read that tutorial, but I just skimmed it, and it doesn't say to
> call $this->renderSwf; it says to call $flash->renderSwf.
>
> > By the way, does anyone know on where to store swf files in cakephp
> > projects?
>
> Presumably wherever you like, under the w
Re: do i need to create a controller for all pages in \views\pages\ folder
Yes, I had already gone through the Blog tutorial. But that doesn't
have a static page (just to display info). What I'm trying to do is
similar to contents of about page.
I tried creating a missing_controller.ctp with no contents as below:
and i'm not getting any errors now.
thanks. :)
On Apr 27, 3:24 pm, Jeremy Burns | Class Outfit
wrote:
> You really need to read the guide...what are you are doing is not utilising
> Cake at all. Follow the Blog tutorial:http://book.cakephp.org/view/1528/Blog
>
> Jeremy Burns
> Class Outfit
>
> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> On 27 Apr 2011, at 08:21, varai wrote:
>
>
>
> > Hi,
>
> > Is it necessary to create a controller for each page in \views\pages\
> > folder?
>
> > I have this static page Preschool.html. And I'm getting the following
> > error message:
> > Missing Controller
> > Error: Preschool.htmlController could not be found.
>
> > Error: Create the class Preschool.htmlController below in file:
> > merry_flowers\controllers\preschool.html_controller.php
>
> > > class Preschool.htmlController extends AppController {
>
> > var $name = 'Preschool.html';
> > }
> > ?>
> > Notice: If you want to customize this error message, create
> > merry_flowers\views\errors\missing_controller.ctp
>
> > Even after creating a controller with the above name and contents, i'm
> > still getting the same Missing Controller message.
>
> > As the notice says, if I create missing_controller.ctp, what should
> > the contents be?
>
> > Please help me. I'm cluelessI'm new to cakephp.
>
> > thank you.
>
> > --
> > Our newest site for the community: CakePHP Video
> > Tutorialshttp://tv.cakephp.org
> > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
> > others with their CakePHP related questions.
>
> > To unsubscribe from this group, send email to
> > cake-php+unsubscr...@googlegroups.com For more options, visit this group
> > athttp://groups.google.com/group/cake-php- Hide quoted text -
>
> - Show quoted text -
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
I need an availability calendar...
Had anyone implemented any in their websites? any suggestions? I need some users to set up their availabilities, then other users can book them if they are free.. thanks! -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: an appointment system...
i used to play around with full calendar (a plugin of jquery) when doing my bachelor. It is good, but we still had to configure a lot (3000 lines of javascript). In my opinion, building everything from scratch is a lot better than trying to hack some complex systems. So if you still have time, build your own On Thu, Apr 28, 2011 at 11:04 PM, Tan Cheng wrote: > Hi folks, > > My boss ask me to create an "appointment system", basically, I need a > calendar that I can add events, and maybe a message system. > > I haven't found any good plug-in for this. So anybody has any related > experience doing this with php? Where should I start looking at? > > Any input will be greatly appreciated! > > Thank you! > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
an appointment system...
Hi folks, My boss ask me to create an "appointment system", basically, I need a calendar that I can add events, and maybe a message system. I haven't found any good plug-in for this. So anybody has any related experience doing this with php? Where should I start looking at? Any input will be greatly appreciated! Thank you! -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Problem with Variables in Elements
Hello People,
i'm using CakePHP 1.3.5.
When i pass a variable to an element, as the book says
(http://book.cakephp.org/view/1081/Elements) i can't use it, i get
this error message: Notice (8): Undefined variable: variable
[APP/views/elements/header.ctp, line 2]
Here's my code:
In the layout:
element('header',array('variable'=>'value')); ?>
In the element (here's where te error arises):
Notice (8): Undefined variable:
variable [APP/views/elements/header.ctp, line 2]
What's going on? I've disabled all cache but still doesn't work.
--
Santiago Basulto.-
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: David Persson - Media Plugin - Handing .docx and .xlsx uploads
As to be expected, work's like a charm! Many thanks David for the fix and the plugin. d//t On Apr 27, 11:55 pm, David Persson wrote: > Hey, > > I think this commit will fix the issues with the mapping between MIME-type > and > name.https://github.com/davidpersson/mm/commit/707ab2cd6b9452403cd56fd4aac... > > The fix has also been already propagated to the media plugin. In case it > doesn't work for you please open an issue > here:https://github.com/davidpersson/media/issues > or therehttps://github.com/davidpersson/mm/issues > > - David -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Some problem on the hasmany relationship
ahh.. okay, let me try then.
Thanks.
Regards
On Apr 28, 7:00 pm, Jeremy Burns | Class Outfit
wrote:
> That's probably because the first value is the array key and you can't have
> duplicate array keys (your desired result is impossible in PHP). Imagine it
> as a select list; each option would have the same value (1), which defeats
> the object. Cake is (in essence) simply doing a loop, adding each value it
> finds to the resulting array and that will always replace the last value
> found (it's always array key '1'); hence you end up with the 'last' record.
> Would it work for you to switch the columns around? That would give you the
> three values you need.
>
> Jeremy Burns
> Class Outfit
>
> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> On 28 Apr 2011, at 11:13, jackgoh wrote:
>
>
>
> > When use find('list',), it is:
> > Array
> > (
> > [1] => 4
> > )
>
> > But the result suppose is :
>
> > Array
> > (
> > [1] => 7
> > [1] => 14
> > [1] => 4
> > )
>
> > It is always get the last record.
>
> > Thanks
>
> > On Apr 28, 3:14 pm, Jeremy Burns | Class Outfit
> > wrote:
> >> What are the results of find list?
>
> >> Jeremy Burns
> >> Class Outfit
>
> >> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> >> On 28 Apr 2011, at 07:19, jackgoh wrote:
>
> >>> Hi Jeremy,
>
> >>> - There is a missing ' before category_id after
> >>> 'associationForeignKey'
> >>> => sorry, my typo in this content only. sorry.
>
> >>> - Your conditions in the find->list look wrong; try 'conditions' =>
> >>> array('stock_id' => $this->Stock->id)
> >>> => The results are the same. both ways are working, but your
> >>> suggestion way is better. ;)
>
> >>> - The convention is to name your joining table CategoryStock (the two
> >>> models are in alphabetical order). Although your arrangement ought to
> >>> work, I generally stay with conventions unless there is a compelling
> >>> reason not to.
> >>> => I changed it as what you suggested. (in Stock model & StockCategory
> >>> model)
>
> >>> - Do you have a model for StockCategory?
> >>> => Yes:
> >>> class CategoryStock extends AppModel
> >>> {
> >>> var $name = CategoryStocks;
> >>> }
>
> >>> - What happens when you use find 'all' rather than 'list'?
> >>> => i got the correct array!! But the result look like:
> >>> Array
> >>> (
> >>> [0] => Array
> >>> (
> >>> [CategoryStock] => Array
> >>> (
> >>> [stock_id] => 1
> >>> [business_category_id] => 4
> >>> )
>
> >>> )
>
> >>> [1] => Array
> >>> (
> >>> [CategoryStock] => Array
> >>> (
> >>> [stock_id] => 1
> >>> [business_category_id] => 7
> >>> )
>
> >>> )
> >>> [2] => Array
> >>> (
> >>> [CategoryStock] => Array
> >>> (
> >>> [stock_id] => 1
> >>> [business_category_id] => 14
> >>> )
>
> >>> )
>
> >>> )
>
> >>> - What happens when you die(debug($selectedRecord)) in your controller
> >>> before passing it to your view?
> >>> => same as above result.
>
> >>> Out of interest, what does the resulting SQL look like?
> >>> => (i simplified) :SELECT CategoryStock.* FROM `stock_CategoryStocks`
> >>> AS `CategoryStock` WHERE `stock_id` = 1 , effected rows is 3 , which
> >>> is always correct, when use the find('list'), the effected rows is
> >>> still 3, but debug($selectedRecord) show only 1 record in the array.
> >>> Weird.
>
> >>> Thanks.
>
> >>> Regards
> >>> Jack
>
> >>> On Apr 28, 12:03 pm, Jeremy Burns | Class Outfit
> >>> wrote:
> These might be typos but some of the code looks *slightly* odd.
>
> - There is a missing ' before category_id after 'associationForeignKey'
> - Your conditions in the find->list look wrong; try 'conditions' =>
> array('stock_id' => $this->Stock->id)
> - The convention is to name your joining table CategoryStock (the two
> models are in alphabetical order). Although your arrangement ought to
> work, I generally stay with conventions unless there is a compelling
> reason not to.
> - Do you have a model for StockCategory?
> - What happens when you use find 'all' rather than 'list'?
> - What happens when you die(debug($selectedRecord)) in your controller
> before passing it to your view?
>
> Out of interest, what does the resulting SQL look like?
>
> Jeremy Burns
> Class Outfit
>
> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> On 27 Apr 2011, at 22:51, jackgoh wrote:
>
> > Hi cricket,
>
> > The $this->Stock->id is set correctly. And the SQL is working
> > perfectly, i can get the correct number of records (which 3 of them:
> > 4, 7, 14)
>
> > On Apr 27, 1:53 am, cricket wrote:
> >> Is $this->Stock->id set to something? What does the SQL look like? Set
> >>
Re: Some problem on the hasmany relationship
That's probably because the first value is the array key and you can't have
duplicate array keys (your desired result is impossible in PHP). Imagine it as
a select list; each option would have the same value (1), which defeats the
object. Cake is (in essence) simply doing a loop, adding each value it finds to
the resulting array and that will always replace the last value found (it's
always array key '1'); hence you end up with the 'last' record. Would it work
for you to switch the columns around? That would give you the three values you
need.
Jeremy Burns
Class Outfit
jeremybu...@classoutfit.com
http://www.classoutfit.com
On 28 Apr 2011, at 11:13, jackgoh wrote:
> When use find('list',), it is:
> Array
> (
>[1] => 4
> )
>
>
> But the result suppose is :
>
>
> Array
> (
>[1] => 7
>[1] => 14
>[1] => 4
> )
>
> It is always get the last record.
>
> Thanks
>
> On Apr 28, 3:14 pm, Jeremy Burns | Class Outfit
> wrote:
>> What are the results of find list?
>>
>> Jeremy Burns
>> Class Outfit
>>
>> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>>
>> On 28 Apr 2011, at 07:19, jackgoh wrote:
>>
>>
>>
>>> Hi Jeremy,
>>
>>> - There is a missing ' before category_id after
>>> 'associationForeignKey'
>>> => sorry, my typo in this content only. sorry.
>>
>>> - Your conditions in the find->list look wrong; try 'conditions' =>
>>> array('stock_id' => $this->Stock->id)
>>> => The results are the same. both ways are working, but your
>>> suggestion way is better. ;)
>>
>>> - The convention is to name your joining table CategoryStock (the two
>>> models are in alphabetical order). Although your arrangement ought to
>>> work, I generally stay with conventions unless there is a compelling
>>> reason not to.
>>> => I changed it as what you suggested. (in Stock model & StockCategory
>>> model)
>>
>>> - Do you have a model for StockCategory?
>>> => Yes:
>>> class CategoryStock extends AppModel
>>> {
>>>var $name = CategoryStocks;
>>> }
>>
>>> - What happens when you use find 'all' rather than 'list'?
>>> => i got the correct array!! But the result look like:
>>> Array
>>> (
>>>[0] => Array
>>>(
>>>[CategoryStock] => Array
>>>(
>>>[stock_id] => 1
>>>[business_category_id] => 4
>>>)
>>
>>>)
>>
>>>[1] => Array
>>>(
>>>[CategoryStock] => Array
>>>(
>>>[stock_id] => 1
>>>[business_category_id] => 7
>>>)
>>
>>>)
>>>[2] => Array
>>>(
>>>[CategoryStock] => Array
>>>(
>>>[stock_id] => 1
>>>[business_category_id] => 14
>>>)
>>
>>>)
>>
>>> )
>>
>>> - What happens when you die(debug($selectedRecord)) in your controller
>>> before passing it to your view?
>>> => same as above result.
>>
>>> Out of interest, what does the resulting SQL look like?
>>> => (i simplified) :SELECT CategoryStock.* FROM `stock_CategoryStocks`
>>> AS `CategoryStock` WHERE `stock_id` = 1 , effected rows is 3 , which
>>> is always correct, when use the find('list'), the effected rows is
>>> still 3, but debug($selectedRecord) show only 1 record in the array.
>>> Weird.
>>
>>> Thanks.
>>
>>> Regards
>>> Jack
>>
>>> On Apr 28, 12:03 pm, Jeremy Burns | Class Outfit
>>> wrote:
These might be typos but some of the code looks *slightly* odd.
>>
- There is a missing ' before category_id after 'associationForeignKey'
- Your conditions in the find->list look wrong; try 'conditions' =>
array('stock_id' => $this->Stock->id)
- The convention is to name your joining table CategoryStock (the two
models are in alphabetical order). Although your arrangement ought to
work, I generally stay with conventions unless there is a compelling
reason not to.
- Do you have a model for StockCategory?
- What happens when you use find 'all' rather than 'list'?
- What happens when you die(debug($selectedRecord)) in your controller
before passing it to your view?
>>
Out of interest, what does the resulting SQL look like?
>>
Jeremy Burns
Class Outfit
>>
jeremybu...@classoutfit.comhttp://www.classoutfit.com
>>
On 27 Apr 2011, at 22:51, jackgoh wrote:
>>
> Hi cricket,
>>
> The $this->Stock->id is set correctly. And the SQL is working
> perfectly, i can get the correct number of records (which 3 of them:
> 4, 7, 14)
>>
> On Apr 27, 1:53 am, cricket wrote:
>> Is $this->Stock->id set to something? What does the SQL look like? Set
>> debug to 2 to see it.
>>
>> On Mon, Apr 25, 2011 at 1:25 PM, jackgoh wrote:
>>> Hi,
>>
>>> I am facing some problem when deal with a realtionship tables, the
>>> record is not display :
>>
>>> // in Stock model:
>>>var $hasAndBelongsToMany =
Re: Some problem on the hasmany relationship
When use find('list',), it is:
Array
(
[1] => 4
)
But the result suppose is :
Array
(
[1] => 7
[1] => 14
[1] => 4
)
It is always get the last record.
Thanks
On Apr 28, 3:14 pm, Jeremy Burns | Class Outfit
wrote:
> What are the results of find list?
>
> Jeremy Burns
> Class Outfit
>
> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> On 28 Apr 2011, at 07:19, jackgoh wrote:
>
>
>
> > Hi Jeremy,
>
> > - There is a missing ' before category_id after
> > 'associationForeignKey'
> > => sorry, my typo in this content only. sorry.
>
> > - Your conditions in the find->list look wrong; try 'conditions' =>
> > array('stock_id' => $this->Stock->id)
> > => The results are the same. both ways are working, but your
> > suggestion way is better. ;)
>
> > - The convention is to name your joining table CategoryStock (the two
> > models are in alphabetical order). Although your arrangement ought to
> > work, I generally stay with conventions unless there is a compelling
> > reason not to.
> > => I changed it as what you suggested. (in Stock model & StockCategory
> > model)
>
> > - Do you have a model for StockCategory?
> > => Yes:
> > class CategoryStock extends AppModel
> > {
> > var $name = CategoryStocks;
> > }
>
> > - What happens when you use find 'all' rather than 'list'?
> > => i got the correct array!! But the result look like:
> > Array
> > (
> > [0] => Array
> > (
> > [CategoryStock] => Array
> > (
> > [stock_id] => 1
> > [business_category_id] => 4
> > )
>
> > )
>
> > [1] => Array
> > (
> > [CategoryStock] => Array
> > (
> > [stock_id] => 1
> > [business_category_id] => 7
> > )
>
> > )
> > [2] => Array
> > (
> > [CategoryStock] => Array
> > (
> > [stock_id] => 1
> > [business_category_id] => 14
> > )
>
> > )
>
> > )
>
> > - What happens when you die(debug($selectedRecord)) in your controller
> > before passing it to your view?
> > => same as above result.
>
> > Out of interest, what does the resulting SQL look like?
> > => (i simplified) :SELECT CategoryStock.* FROM `stock_CategoryStocks`
> > AS `CategoryStock` WHERE `stock_id` = 1 , effected rows is 3 , which
> > is always correct, when use the find('list'), the effected rows is
> > still 3, but debug($selectedRecord) show only 1 record in the array.
> > Weird.
>
> > Thanks.
>
> > Regards
> > Jack
>
> > On Apr 28, 12:03 pm, Jeremy Burns | Class Outfit
> > wrote:
> >> These might be typos but some of the code looks *slightly* odd.
>
> >> - There is a missing ' before category_id after 'associationForeignKey'
> >> - Your conditions in the find->list look wrong; try 'conditions' =>
> >> array('stock_id' => $this->Stock->id)
> >> - The convention is to name your joining table CategoryStock (the two
> >> models are in alphabetical order). Although your arrangement ought to
> >> work, I generally stay with conventions unless there is a compelling
> >> reason not to.
> >> - Do you have a model for StockCategory?
> >> - What happens when you use find 'all' rather than 'list'?
> >> - What happens when you die(debug($selectedRecord)) in your controller
> >> before passing it to your view?
>
> >> Out of interest, what does the resulting SQL look like?
>
> >> Jeremy Burns
> >> Class Outfit
>
> >> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>
> >> On 27 Apr 2011, at 22:51, jackgoh wrote:
>
> >>> Hi cricket,
>
> >>> The $this->Stock->id is set correctly. And the SQL is working
> >>> perfectly, i can get the correct number of records (which 3 of them:
> >>> 4, 7, 14)
>
> >>> On Apr 27, 1:53 am, cricket wrote:
> Is $this->Stock->id set to something? What does the SQL look like? Set
> debug to 2 to see it.
>
> On Mon, Apr 25, 2011 at 1:25 PM, jackgoh wrote:
> > Hi,
>
> > I am facing some problem when deal with a realtionship tables, the
> > record is not display :
>
> > // in Stock model:
> > var $hasAndBelongsToMany = array(
> > 'Category' => array(
> > 'className' => 'Category',
> > 'joinTable' => 'category',
> > 'foreignKey' => 'stock_id',
> > 'associationForeignKey' => category_id',
> > 'with' => 'StockCategory',
> > ),
> > );
>
> > // in Stock controller:
> > $selectedRecord = $this->Stock->StockCategory->find('list',
> > array( 'fields'=>array('stock_id','category_id'),
> > 'conditions'=>array('stock_id='.$this->Stock->id) ) );
> > $this->set(compact('selectedRecord'));
>
> > I try to copy the SQL by using debug() to phpmysql, and i get 3 lines
> > of records. but when i try to PRINT_
Re: Html Link in the elements
Thank you euromark!
I read it but I didn't find anythig about it.
I try with $this->Html->link(...)
but give this error:
Fatal error: Using $this when not in object context in /home/gege/www/
app/views/elements/menu.ctp on line 101
I thing because I isn't in a Class...
Thank you
On 28 Apr, 11:47, euromark wrote:
> read the manuel for 1.3
>
> $this->Html->link()
>
> On 28 Apr., 11:40, Carachi wrote:
>
>
>
>
>
>
>
> > Hello,
> > I have this problem.
> > I want create a menu for my website, so I use an element that I set in
> > my layout.ctp so:
>
> > element('menu',array(),true);?> > div>
>
> > I need use link for my menu but the helper doesn't work!
> > I try with :
> > $this->html->link(..) //but doesn't reconize $this because there
> > isn't an object
> > $html->link(..) // but is not set..
>
> > How can I use Html Helper?
>
> > Thank you
> > Bye
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Calling an element based on row selection
Hi,
My idea is to have a list of database data listed in a table, one row
per member data details.
Each member has a link to open a popup (I am using a basic modal
jquery script). In this popup I would like to have a comment field to
add comments regarding the selected client.
I am not sure how to do that.
How can I call the popup with the comment field, which is outsourced
in a element, and parse the member id to it?
Guess I have a table like
...
memberid 1echo $this->Html->link(__('leave a comment',
true),?>
memberid 2echo $this->Html->link(__('leave a comment',
true),?>
memberid 3echo $this->Html->link(__('leave a comment',
true),?>
My element looks like
Ajax->Form('comment', 'post', array('url' =>
array('action' => 'comment'))); ?>
...
Ajax->Form->end(); ?>
Please give me a hand with this, I am sure it must be possible
somehow? Or?
Thanks!!
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Validate from within a model
Okay.
I'm doing it like this.
I'm havin a new file uploaded.
The file data, like mime type, name etc. will be saved in the db under
the file id.
I'm using that id as a filename for the files in my filesystem.
So i need to first create a db record to use the id.
Afterwards i'm trying to save the file.
If for example the folder for the upload is not writable or i don't
have the permission or any other case i can't figure out now happens,
then i want to cancel the upload and delete the db record so i won't
have 2 or more of the same file in the database.
This user is getting an error message that something fails during the
file upload and also i want to let the users know what they are
supposed to do next.
This is my intention.
And i would never validate file uploads with javascripts because of 2
reasons:
First, i don't know how
Second, i know enough to know that this kind of validation wouldn't be
save enough ^^
Nothing against you, but js alone isn't the key.
On 27 Apr., 23:54, Miles J wrote:
> You dont need to use validates(), just set an error manually.
>
> $this->invalidate('fields', 'Error message.');
>
> Also, your approach is still wrong IMO. You should be doing all error
> checking before any save functionality is triggered. In what scenario
> will the image NOT copy/transfer? I have yet to ever run into that
> problem.
>
> On Apr 27, 12:31 pm, func0der wrote:
>
> > okay...i think i got it.
>
> > It is part of the MVC pattern, isn't it?
>
> > The model is NOT connected to the view or the helpers. These two are
> > getting their data or the invalid error messages by the controller.
>
> > Am i right here?
>
> > On 27 Apr., 21:00, func0der wrote:
>
> > > I can re-save and delete, so why i shouldn't be able to revalidate?
>
> > > The error message is also in the "validationErrors" variable but while
> > > the output of the form there is no error message.
> > > But why?
>
> > > On 27 Apr., 20:38, Miles J wrote:
>
> > > > You can't validates() something after the model save has already
> > > > happened. Use a behavior for validation or use my plugin.
>
> > > >https://github.com/milesj/cake-uploader
>
> > > > And an example model on how to use it.
>
> > > >https://github.com/milesj/cake-uploader/blob/master/tests/models/uplo...
>
> > > > On Apr 27, 11:18 am, func0der wrote:
>
> > > > > Hey guys,
>
> > > > > i'm having a file upload here.
> > > > > I'm using "afterSave" to place the uploaded file in the filesystem.
>
> > > > > function afterSave($created){
> > > > > //get the entry id
> > > > > $this->data['DataFile']['id'] = $this->getInsertId();
> > > > > if(!$this->saveDataFile($this->data)){
> > > > > $this->delete($this->data['DataFile']['id']);
> > > > > $this->data['DataFile']['data_file'] =
> > > > > array();
> > > > > $this->validates();
> > > > > }
> > > > > }
>
> > > > > "saveDataFile" is a function which tries to places the uploaded file
> > > > > in the file system and returns false in case of copy fails.
>
> > > > > If the copy should fail i delete the record from the database and set
> > > > > the "data_file" index which normally cotains the uploaded file
> > > > > information to an empty array. This is because i want the validation
> > > > > to fail so the file upload field gets an error message while
> > > > > rendering.
>
> > > > > The problem now is that the upload form does NOT! contain the
> > > > > validation error message for that particular field.
>
> > > > > Do you know what i am doing wrong?
>
> > > > > Greetings
> > > > > func0der
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Html Link in the elements
read the manuel for 1.3
$this->Html->link()
On 28 Apr., 11:40, Carachi wrote:
> Hello,
> I have this problem.
> I want create a menu for my website, so I use an element that I set in
> my layout.ctp so:
>
> element('menu',array(),true);?> div>
>
> I need use link for my menu but the helper doesn't work!
> I try with :
> $this->html->link(..) //but doesn't reconize $this because there
> isn't an object
> $html->link(..) // but is not set..
>
> How can I use Html Helper?
>
> Thank you
> Bye
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Html Link in the elements
Hello,
I have this problem.
I want create a menu for my website, so I use an element that I set in
my layout.ctp so:
element('menu',array(),true);?>
I need use link for my menu but the helper doesn't work!
I try with :
$this->html->link(..) //but doesn't reconize $this because there
isn't an object
$html->link(..) // but is not set..
How can I use Html Helper?
Thank you
Bye
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Validate from within a model
but thats awfully wrong and dangerous your primary validation should be in php (in the model) js validation is just a nice little addon On 28 Apr., 04:15, cake-learner wrote: > I always do validation with Jquery plugins not with cakephp function > since the form function is limited. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Assemble IN clause for paginate
your search term is an array of ids, right?
than its as easy as using
array('Asset.id' => $arrayOfIds)
because cake will automatically make an IN here
On 28 Apr., 09:25, AD7six wrote:
> On Apr 28, 8:29 am, ZAky wrote:
>
> > 1. I have a stored procedure that return an array of ids and can
> > return a comma delimited string of ids if its better
> > 2. A have a paginator that return all the data from a table.
> > 3. When the user perform a search I take the search parameters and
> > call the stored procedure.
>
> > Now I have an array or string that I want to use as a condition to the
> > paginator
>
> > $this->set('assets', $this->paginate(array('Asset.id IN' =>
> > $searchTerm)));
>
> 'Asset.id' =>
>
>
>
> > Well its not working.
>
> what query gets executed, what query are you wanting
>
>
>
> > I tried to add '('.$searchTerm.')' with no success
>
> what is that supposed to do (added it where?) what did it do.
>
> > And several more things
>
> I also sang the sacred chant, but no extra infromation or error
> messages came forth.
>
> AD
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: ajax is'n work correctly in chrome and ie
Have you inspected you page in firefox with firebug extension and in
chrome with the developer tools? In case you run into a JavaScript
problem that one browser might tolerate and another might be strict on
the same matter, you will find hints in those tools.
Besides that, don't you think you should at least describe the nature
of your problem a bit further, than just saying "works in A and does
not work in B"? What exactly is working and what not?
On 28 Apr., 05:35, taq wrote:
> VIEW form
>
>
> // let the controller action decide weather to close the modalbox
> if (isset($closeModalbox) && $closeModalbox) echo " id='closeModalbox'>";
>
> // output an ajax or a normal form
> if ($ajax->isAjax()) {
> // show ajax form
> echo $ajax->form('edit', 'post', array(
> 'model' => 'User',
> 'url' => array('controller' => 'Users', 'action' =>
> 'register'),
> 'update' => 'MB_content',
> 'complete' => 'closeModalbox()'
> ));} else {
>
> // show default form
> echo $form->create( 'User');}
>
> ?>
>
> echo $form->input('user_login', array( 'label' => 'User Name
> :' ) );
> echo $form->input('user_pass', array( 'label' =>
> 'Password :', 'type' => 'password') );
> ?>
>
> end('Submit');?>
>
>
> please guide me to make code to complatible in firefox chrome and ie
> On Apr 28, 9:14 am, "Krissy Masters"
> wrote:
>
>
>
>
>
>
>
> > With all the details you provided it should be just such a simple fix.
>
> > I also read palms and your future.
>
> > -Original Message-
> > From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
>
> > Of taq
> > Sent: Wednesday, April 27, 2011 11:25 PM
> > To: CakePHP
> > Subject: ajax is'n work correctly in chrome and ie
>
> > hi
> > I create modalbox form it work corectly in firefox
> > but work error on ie and chrome how to fix error
> > thank you
>
> > --
> > Our newest site for the community: CakePHP Video
> > Tutorialshttp://tv.cakephp.org
> > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp
> > others with their CakePHP related questions.
>
> > To unsubscribe from this group, send email to
> > cake-php+unsubscr...@googlegroups.com For more options, visit this group
> > athttp://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Assemble IN clause for paginate
On Apr 28, 8:29 am, ZAky wrote:
> 1. I have a stored procedure that return an array of ids and can
> return a comma delimited string of ids if its better
> 2. A have a paginator that return all the data from a table.
> 3. When the user perform a search I take the search parameters and
> call the stored procedure.
>
> Now I have an array or string that I want to use as a condition to the
> paginator
>
> $this->set('assets', $this->paginate(array('Asset.id IN' =>
> $searchTerm)));
'Asset.id' =>
>
> Well its not working.
what query gets executed, what query are you wanting
>
> I tried to add '('.$searchTerm.')' with no success
what is that supposed to do (added it where?) what did it do.
> And several more things
I also sang the sacred chant, but no extra infromation or error
messages came forth.
AD
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Mysql 1064 error
Hi, I am using Cake 1.3.8 and get a Mysql error code 1064. Following is the details in debug mode Query: check Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 The associated mode has following relationships: 4 hasMany 1 belongsTo 1 HBTM Its seems that the it is generating a sql query "Check" and hence it is throwing the error. The interesting part is it does not generate this "check: query for my other mode. Please let me know if I am doing something wrong. Let me know if any additional information if required. Regards James -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Mysql 1064 error
Hi, I am using Cake 1.3.8 and get a Mysql error code 1064. Following is the details in debug mode Query: check Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 The associated mode has following relationships: 4 hasMany 1 belongsTo 1 HBTM Its seems that the it is generating a sql query "Check" and hence it is throwing the error. The interesting part is it does not generate this "check: query for my other mode. Please let me know if I am doing something wrong. Let me know if any additional information if required. Regards James -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Some problem on the hasmany relationship
What are the results of find list?
Jeremy Burns
Class Outfit
jeremybu...@classoutfit.com
http://www.classoutfit.com
On 28 Apr 2011, at 07:19, jackgoh wrote:
> Hi Jeremy,
>
> - There is a missing ' before category_id after
> 'associationForeignKey'
> => sorry, my typo in this content only. sorry.
>
> - Your conditions in the find->list look wrong; try 'conditions' =>
> array('stock_id' => $this->Stock->id)
> => The results are the same. both ways are working, but your
> suggestion way is better. ;)
>
> - The convention is to name your joining table CategoryStock (the two
> models are in alphabetical order). Although your arrangement ought to
> work, I generally stay with conventions unless there is a compelling
> reason not to.
> => I changed it as what you suggested. (in Stock model & StockCategory
> model)
>
> - Do you have a model for StockCategory?
> => Yes:
> class CategoryStock extends AppModel
> {
> var $name = CategoryStocks;
> }
>
> - What happens when you use find 'all' rather than 'list'?
> => i got the correct array!! But the result look like:
> Array
> (
>[0] => Array
>(
>[CategoryStock] => Array
>(
>[stock_id] => 1
>[business_category_id] => 4
>)
>
>)
>
>[1] => Array
>(
>[CategoryStock] => Array
>(
>[stock_id] => 1
>[business_category_id] => 7
>)
>
>)
>[2] => Array
>(
>[CategoryStock] => Array
>(
>[stock_id] => 1
>[business_category_id] => 14
>)
>
>)
>
> )
>
>
> - What happens when you die(debug($selectedRecord)) in your controller
> before passing it to your view?
> => same as above result.
>
>
> Out of interest, what does the resulting SQL look like?
> => (i simplified) :SELECT CategoryStock.* FROM `stock_CategoryStocks`
> AS `CategoryStock` WHERE `stock_id` = 1 , effected rows is 3 , which
> is always correct, when use the find('list'), the effected rows is
> still 3, but debug($selectedRecord) show only 1 record in the array.
> Weird.
>
> Thanks.
>
> Regards
> Jack
>
> On Apr 28, 12:03 pm, Jeremy Burns | Class Outfit
> wrote:
>> These might be typos but some of the code looks *slightly* odd.
>>
>> - There is a missing ' before category_id after 'associationForeignKey'
>> - Your conditions in the find->list look wrong; try 'conditions' =>
>> array('stock_id' => $this->Stock->id)
>> - The convention is to name your joining table CategoryStock (the two models
>> are in alphabetical order). Although your arrangement ought to work, I
>> generally stay with conventions unless there is a compelling reason not to.
>> - Do you have a model for StockCategory?
>> - What happens when you use find 'all' rather than 'list'?
>> - What happens when you die(debug($selectedRecord)) in your controller
>> before passing it to your view?
>>
>> Out of interest, what does the resulting SQL look like?
>>
>> Jeremy Burns
>> Class Outfit
>>
>> jeremybu...@classoutfit.comhttp://www.classoutfit.com
>>
>> On 27 Apr 2011, at 22:51, jackgoh wrote:
>>
>>
>>
>>> Hi cricket,
>>
>>> The $this->Stock->id is set correctly. And the SQL is working
>>> perfectly, i can get the correct number of records (which 3 of them:
>>> 4, 7, 14)
>>
>>> On Apr 27, 1:53 am, cricket wrote:
Is $this->Stock->id set to something? What does the SQL look like? Set
debug to 2 to see it.
>>
On Mon, Apr 25, 2011 at 1:25 PM, jackgoh wrote:
> Hi,
>>
> I am facing some problem when deal with a realtionship tables, the
> record is not display :
>>
> // in Stock model:
>var $hasAndBelongsToMany = array(
>'Category' => array(
>'className' => 'Category',
>'joinTable' => 'category',
>'foreignKey' => 'stock_id',
>'associationForeignKey' => category_id',
>'with' => 'StockCategory',
>),
>);
>>
> // in Stock controller:
> $selectedRecord = $this->Stock->StockCategory->find('list',
> array( 'fields'=>array('stock_id','category_id'),
> 'conditions'=>array('stock_id='.$this->Stock->id) ) );
> $this->set(compact('selectedRecord'));
>>
> I try to copy the SQL by using debug() to phpmysql, and i get 3 lines
> of records. but when i try to PRINT_R the $selectedRecord, i can only
> get 1 record, example:
>>
> Array
> (
>[1] => 4
> )
>>
> Suppose the result have to be :
>>
> Array
> (
>[1] => 4
>[1] => 7
>[1] => 14
> )
>>
> Values : 4,7,14 are category_id, [1] is stock_id. There is a table
> call "category" to store all the category name.
>>
> Please point out whats wrong to my c
