temporary tables in cake.

2009-05-28 Thread MalContented
Hi, I am trying to use temporary tables for some data manipulation but they don't seem to work... Consider this simplified code: $sql = 'create temporary table t_hold select * from hold'; $result = $model-query ( $sql ); // This returns true $sql = 'select * from t_hold'; $result =

Re: temporary tables in cake.

2009-05-28 Thread Malcolm McLean
Oops, sorry. Forget this - I had a stupid typo in my code (it must be too late, I'm going home). Mal On 28 May, 18:29, MalContented goo...@mmcsoftware.co.uk wrote: Hi, I am trying to use temporary tables for some data manipulation but they don't seem to work... Consider this simplified