Hi
Please consider a simple LEFT JOIN MySQL query:
<cfquery datasource="test" name="qry>
SELECT ID, name, table2.id, table2.extradata
FROM table1
LEFT JOIN table2 ON table1.id = table2.id
</cfquery>
On BlueDragon 7 the results on a CFDUMP are:
| 1 | john | 1 | married |
| 2 | paul | [null] | [null] |
On OpenBD 1.3 the results are:
| 1 | john | 1 |
married |
| 2 | paul | object of [undefined class] | object of [undefined
class] |
So, if I want to use the second row of this query I get several errors
because the field is "undefined" instead of "null"...
I tryed to change several parameters on the Connection String of the
Datasource, and I also change the version of the mysql-connector.jar,
but the error persists.
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
online manual: http://www.openbluedragon.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
