hi
Won't the query function return an array? wont this return an error?
please advise
thanks
chris
On Wednesday, April 10, 2013 10:07:53 PM UTC+8, dada123 wrote:
>
> 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]<javascript:>
> > 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]<javascript:>
>> > wrote:
>>
>>> why not withing a loop u can use it ....
>>>
>>>
>>> On Wed, Apr 10, 2013 at 7:08 PM, Yen Hua Chuah
>>> <[email protected]<javascript:>
>>> > 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]<javascript:>
>>>> > 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]<javascript:>
>>>>> > 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] <javascript:>.
>>>>>>
>>>>>> To post to this group, send email to
>>>>>> [email protected]<javascript:>
>>>>>> .
>>>>>> 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] <javascript:>.
>>>>>
>>>>> To post to this group, send email to [email protected]<javascript:>
>>>>> .
>>>>> 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] <javascript:>.
>>>> To post to this group, send email to [email protected]<javascript:>
>>>> .
>>>> 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] <javascript:>.
>>> To post to this group, send email to [email protected]<javascript:>
>>> .
>>> 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] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> 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.
