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 code: > > $sql = 'create temporary table t_hold select * from hold'; > $result = $model->query ( $sql ); // This returns true > > $sql = 'select * from t_hold'; > $result = $model->query ( $sql ); // This throws an error 1146 - Table > doesn't exist > > Now, the same error also happens if I take the 'temporary' out of the > create statement. > Furthermore, if I stick a 'show tables' statement before and after the > select, the 't_hold' table appears in the resulting array indicating > that it has indeed been created. > I tried puting a commit after the create as we are using innodb > tables. > > Does anyone know what's happening here / have a fix? > > Thanks in anticipation. > > Mal --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---