I'm working on an application that connects to a company's internal customer database which is powered by Pervasive SQL 9.5. I can connect to this database with ODBC, but the PSQL syntax has a few differences from regular SQL. To fix this, I extended the DboOdbc class like so:
http://pastebin.com/f7863aa63 When I visit my scaffolding, however, I get the following: http://pastebin.com/f401544f3 The queries are as follows: SELECT COUNT(*) AS psql_count FROM CUSTOMER AS Customer WHERE 1 = 1 SELECT TOP 20 Customer.CUSTOMERNBR, Customer.LOCATIONKEY, {...} FROM CUSTOMER AS Customer WHERE 1 = 1 No records are returned, but no syntax errors are thrown. 'psql_count' comes back as "47" which is the correct number of records. Any ideas why this is happening? --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---