Yes please chk this either it is working or not else just write this
foreach $outdaterec in $outdaterecs {
$sql="INSERT INTO ... SET .....";
$this->outdatePost->query($sql);
}
this will surely work...
On Wed, Apr 10, 2013 at 7:21 PM, Yen Hua Chuah <[email protected]> wrote:
> hi
> do u mean i will do a select to retrieve all the necessary data from post
>
> $outdaterecs=$this->Post->query("SELECT * FROM POST WHERE DATE_POSTED <=
> CURRENT_DATE()")
> foreach $outdaterec in $outdaterecs
> $this->outdatePost->create();
> $this->outdatePost['outdatepost']['id'] = $outdaterec['Post']['id'];
> $this->outdatePost->save()
> endforeach
>
> is this correct way of doing it? please advise as i am really new to
> cakephp
>
> thanks
> chris
>
>
> On Wed, Apr 10, 2013 at 9:43 PM, Soumavo Chatterjee
> <[email protected]>wrote:
>
>> 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 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.
