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