Hey All, A bit of a problem that I think will be hard to troubleshoot as it must be an environment issue, but I'm hoping perhaps someone has come across it before...
In a project I'm doing (1.1) I have plenty of the usual Criteria statements which use Propel to access the DB which are fine, but for a couple more complex queries I've just used SQL to Creole and bypassed Propel (example below), but all of these simply throw an error saying "Could not execute query [Native Error: Table 'XXX.XXX' doesn't exist" I've tried just very simple queries like select * from blah, with the same result... Has anyone had this issue before or have any ideas? The maddening thing is it works on another environment I have, but it's setup totally different so it's hard to compare the two... Thanks for any advice! JM Code sample: $connection = Propel::getConnection(); $query = 'SELECT blah FROM blah WHERE blah'; $query = sprintf($query, $mechanic, $num_slots); $statement = $connection->prepareStatement($query); $resultset = $statement->executeQuery(); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
