I have Microsoft SQL Server on a remote server linked using SQL Linked Server to Quickbooks' database. On another server I have my symfony installation (Unix). Everything is all fine and good, I can do raw queries and retrieve data from Quickbooks through MSSQL. However, when I try to use Propel things get a little fubar. The way that SQL Linked Server references the Quickbooks database is like this:
"SELECT name FROM QODBC...Customer" It prefixes the table (Customer) with "QODBC...", which is the problem. When Symfony goes to optimize the queries it does this: "SELECT QODBC...Customer.name FROM QODBC...Customer" Which of course doesn't work, because you can't have all those extra "." in a multipart identifier. If I could only get it like: "SELECT Customer.name FROM QODBC...Customer" Everything would be great, because that query actually works. Has anyone come across this before? I've searched through SQL Linked Server but can't find any other way of modifying that little delimited "...". Is there a way through Propel I can change the "FROM" clause of criteria? Or is there a way I can change what table name it chooses for the optimizations? Thanks in advance, any help appreciated. I have a few ideas of fixing it but it would require editing some core Propel classes and I'd rather avoid it if possible. Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
