Hi all, I'm in the process of converting a site that formerly ran on a Win2K/MS SQL Server to a Linux/Postgres platform.
The database migration went fine and I'm working my way through the little CF errors that are popping up and have come across this one. The error text is : Error Executing Database Query. No class found for unknown. It gives me the SQL that generated this error, which is: SELECT projects_id AS clickID, projects_name AS maintitle, '' AS subTitle, -1 AS status FROM projects LEFT OUTER JOIN projectPeople ON (projects.projects_id = projectPeople.pp_project) LEFT OUTER JOIN people ON (projectPeople.pp_people = people.people_id) LEFT OUTER JOIN activity ON (projects.projects_id = activity.act_project) WHERE projects_date_update IS NOT NULL GROUP BY projects_id, projects_name ORDER BY projects_name, projects_id funny thing is, when I paste that query text into pgadmin to test it, it runs fine and returns the correct results. Has anyone come across the "No class found for unknown." error and knows a solution for it? thanks, bye! ----------------------- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
