$this->Foo->cacheQueries = false;
On Aug 24, 7:53 am, Ziad <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I have a sequence (in postgres) that I am using to get invoice
> numbers. This sequence is not 'attached' to any of the models, I am
> just using it to generate numbers. However, when I call a nextval on
> the sequence in a loop, I keep getting the same number from the
> sequence:
>
> foreach(...) {
>
> $invNumberRes = null;
> $invNumber = null;
> $invNumberRes = $this->Fee->execute("SELECT
> nextval('invoice_number')");
> $invNumber = $invNumberRes[0][0]['nextval'];
>
> }
>
> I am getting the same value each time I am going around the loop. But
> each time I run the script the number is being incremented by 1. Even
> stranger, when I run a:
> SELECT currval('invoice_number');
>
> on the database directly its not changing after the script!
>
> Any help with this would be greatly appreciated.
>
> Cake version: 1.1.13.4450
> PHP version: 5.2
> PostgreSQL version: 8.2.4
>
> Thanks in advance.
>
> Ziad
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
