Have now tried using
$this->User->cacheQueries = false;
Doesnt work :(
On May 7, 1:09 pm, Unite <[EMAIL PROTECTED]> wrote:
> Whats not cakephp except the INSERT INTO. Yes i would use save but i
> was trying everything to see if i can get it to work. And most of it
> isnt the actual code just something i made up so i can illustrate the
> problem.
>
> How do you stop cake caching the queries?
>
> On May 7, 1:05 pm, "Marcin Domanski" <[EMAIL PROTECTED]> wrote:
>
> > > foreach($file_list as $file) {
> > > //read file contents
> > > //search to see if record exists
> > > $user_id = $this->User->query("SELECT id FROM users WHERE
> > > emailaddress = '[EMAIL PROTECTED]'");
> > > //if record does not exist write record to db
> > > $this->User->query("INSERT INTO users (emailaddress) VALUES
> > > ('[EMAIL PROTECTED]')");
> > > //get last record inserted
> > > $temp = $this->User->query("SELECT last_insert_id()");
> > > }
>
> > Are you kidding ? this is not even close to cakephp i would be ashamed
> > to show such code on this group.
>
> > > On the first loop everything works 100%.
> > > On the second loop even though the email address has been inserted and
> > > is in the DB (supposedly) $user_id still returns empty as if nothing
> > > is there. I put in the sleep command to see if maybe php is running
> > > faster than the database is updating but this has no effect. What can
> > > I do to make sure that all query processes have been completed before
> > > it starts the next loop?
>
> > maybe cake is caching the queries ?
>
> > --
> > Marcin Domanskihttp://kabturek.info
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
