Hi guys,
I`m trying to do a update using a SQL query directly.
I`m having a strange behavior here, I use a similar query in another part
of the code and it is updating normally.
When I use in the second part the update is updating the value as null.
I log the generated query and execute it directly into the DB and it works
perfectly.
The query is
* $query = $this->query("update stocks, (select supply_id, action_id, qtd,
qtd_total from actions_supplies where action_id= '".$id."') act_sup set
stocks.qtd = (stocks.qtd + act_sup.qtd_total) where stocks.supply_id =
act_sup.supply_id and flag_waiting = 'Y' and flag_original = 'N' and
area_id = (select area_id from glebes where id = '".$glebe_id."')");*
Does anyone had a similar behavior?
Any clues on how to fix this?
Thanks!
Augusto
--
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.
For more options, visit https://groups.google.com/d/optout.
