Hello, I have almost spent the whole day at the office trying to look for a solution for this error: I have a newly installed cake 1.2.x.x which I would want to connect to an MS access database (2000 file format). Thanks to the people in this group, I have found solution to this and finally connected my cake app to the MS access database. Obviously, that's not the problem. So, moving along, I have used cake console to create a model, controller and view which worked just fine. I just had to make some adjustments so that my legacy database could work with cake.
---After that I should be able to go to http://localhost/time/employees which should show an index list of employees. but I was having this error: Query: SELECT Employee.EmployeeID, Employee.Lastname, Employee.Firstname, Employee.Middlename, Employee.Birthday, Employee.CurrentAddress, Employee.ProvincialAddress, Employee.CivilStatus, Employee.Sex, Employee.Department, Employee.IsActive, Employee.StartDate, Employee.EndDate, Employee.PicturePath, Employee.StaffNumber, Employee.IsAssigned, Employee.ScheduleCode, Employee.Finger1, Employee.Finger2, Employee.CardNumber, Employee.ZKPassword FROM Employees AS Employee WHERE 1 = 1 Warning (512): SQL Error: �=�: [CORE\cake\libs\model\datasources \dbo_source.php, line 440] ---I have tried to override the scaffolding and instead create my own index action like this: function index () { $condition = array("Employee.Department = 'MITS - Web Development' "); $data = $this->Employee->findAll($condition); $this->set('employees',$data); pr($data); } ---but still the same error appears in the view. Even if the query that is displayed above it has already already adopted the condition that I have placed in the findAll() function. Please help me with this as I have only been enjoying cakephp for 4 months now. Also, this is my first time to develop php with MS ACCESS and I am not well versed with the difference of SQL to MySQL scripts. I am longing so much for someone to point mo to the right direction for this. Best regards to all! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
