Ok as usual straight after posting I play around some more and get it.... I had the table name typed in there in capitals (where i put blah below wasn't accurate, i should have said BLAH :D), and although I notice that when you let creole inject it in there it also uses capitals, something in my setup takes this as being case sensitive and tells me there is no BLAH table... but if you use blah... no probs.
Anyway hopefully this helps someone else out there one day.... :) On Nov 2, 10:33 pm, John Masson <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
