I am having difficulty with the results of a sql task not being the same as the results from the sql query in the db environment and I am wondering if anybody else has seen this behavior.
I have a sql task executing the following query: SELECT c.property_value, center.name, s.property_value FROM center INNER JOIN center_property c ON center.centerKey = c.centerKey AND c.property_type = '_CODE' LEFT OUTER JOIN center_property s ON center.centerKey = s.centerKey AND s.property_type = '_STATUS' WHERE center.parentCenterFK = 147 AND center.active = 1 ORDER BY center.name ASC The 'center' table is joined to the 'center_property' table twice using the property_type _CODE and _STATUS in order to get the values for the _CODE and _STATUS. This query gives me the expected results from within the mysql commandline tool and gui manager. >From ant though, I get the code property value and the status property value, but the center.name column is always blank. I have thought about the column 'name' being a reserved word but quoting the column name or making it an alias works with the command line query, but gives the same results via ant. I have tried moving the sql to an external resource file as well as directly in the build file and the output is no different. I am stumped as to why the query would work, return the right number of rows, but not show any result for the second column. All columns are string types. (property_value is VARCHAR(255) and center.name is VARCHAR(100)) Does anybody have any ideas on where to look for the missing names? Thank you. Larry Mills-Gahl --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@ant.apache.org For additional commands, e-mail: user-h...@ant.apache.org
