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 -~----------~----~----~----~------~----~------~--~---