why not withing a loop u can use it ....
On Wed, Apr 10, 2013 at 7:08 PM, Yen Hua Chuah <[email protected]> wrote: > hi > but the sql used will be inserting more than 10 records. > how can that function do? > > please advise as i am very new to cakephp > > thanks > chris > > On Wed, Apr 10, 2013 at 8:17 PM, Soumavo Chatterjee > <[email protected]>wrote: > >> $this->data['Modelname']['fieldname']=value; >> >> Check this it will work >> >> >> On Wed, Apr 10, 2013 at 5:39 PM, Yen Hua Chuah <[email protected]>wrote: >> >>> hi >>> I would want to do a mass insert records into a table using sql >>> >>> e.g. insert into outdatedpost select * from post where date_posted < >>> current_date() >>> >>> is there a way to do this in cakephp? >>> >>> this function will be run every morning say 12.30 midnight >>> >>> Hence i have to create a shell object for the outdatedpost. >>> >>> Then in the shell object, i will call the Outdatedpost controller to >>> perform this sql >>> >>> $this->outdatedposts->query("insert into outdatedpost select * from post >>> where date_posted < current_date()") >>> >>> however, it seems that cakephp will give me an error on the query() >>> function >>> >>> please help!!! >>> >>> thanks >>> chris >>> >>> -- >>> Like Us on FaceBook https://www.facebook.com/CakePHP >>> Find us on Twitter http://twitter.com/CakePHP >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "CakePHP" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/cake-php?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> >> >> -- >> *Regards >> >> -- >> Soumavo Chattaraj >> >> >> * >> >> -- >> Like Us on FaceBook https://www.facebook.com/CakePHP >> Find us on Twitter http://twitter.com/CakePHP >> >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "CakePHP" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/cake-php/d8SUYXDzXPk/unsubscribe?hl=en. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/cake-php?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- *Regards -- Soumavo Chattaraj Sr. Application Programmer | Web Spiders Mobile No: +91 9933561534 / +91 9330662099 / EmailID: [email protected]/[email protected] Web Spiders India Pvt. Ltd. Matrix Tower, 8th and 9th Floor, Plot No DN-24, Sector - V, Salt Lake City, Kolkata-700091, India. Phone: +91.33.4011.0900 / 53 | Fax: +91.33.4011.0939 URL: www.webspiders.com | Twitter: twitter.com/Web_Spiders | Facebook: facebook.com/webspidersgroup | LinkedIn: linkedin.com/company/web-spiders | The Leading Rich Mobile & Web Engineering Company*** -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
