version is 1.1.19.6305,
in cake/libs/model/dbo/dbo_mysql.php 133 line,echo exec sql statement,
find """$sql = "select curType,curId from orders_sequence where
curDate='$today' and type='$type'";
$row_2 = $this->findBySql($sql); "" no run.
it 's sql cache?? run same sql statement,return same value?
On Jan 15, 8:52 pm, "Olexandr Melnyk" <[EMAIL PROTECTED]> wrote:
> Is curId a either a primary or a unique key?
>
> On 1/15/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > '$type = "ORD"
> > $today = date("Ym");
> > $sql = "select curType,curId from orders_sequence where
> > curDate='$today' and type='$type'";
> > $row_1 = $this->findBySql($sql);
>
> > $sql = "update orders_sequence set curId = curId + 1 where
> > curDate='$today' and type='$type'";
> > $this->execute($sql);
>
> > $sql = "select curType,curId from orders_sequence where
> > curDate='$today' and type='$type'";
> > $row_2 = $this->findBySql($sql);
>
> > $row1 == $row2 ? why ?? please help me,thanks
>
> --
> Sincerely yours,
> Olexandr Melnykhttp://omelnyk.net/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
