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