Hi all, I am considering cake as a front-end to a large db2 database and i have this weird problem, which does not apply to mssql and mysql databases. Whenever i try to a view an entry from a table by clicking on the respective link on the index page, i get an SQL Error: 42818. The cause is that when cake attempts to retrieve the record it escapes the id value of the entry in the query with single quotes (as if the field was a string), e.g.
SELECT FROM tests AS Test WHERE Test.id = '1' FETCH FIRST 1 ROWS ONLY This happens with both scaffolding enabled and disabled - it doesn't matter if i explicitly declare the table schema! I am using cake 1.2.1.8004, DB2 9.1 and the PECL ibm_db2 (1.6.5 which is a bit old) binary driver that comes with the latest PECL binary archive for windows. Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
