Check the online manual as Nitai suggested. However, i know this is a
funny function from memory due to the way ACF implemented it.
OpenBD supports named-parameters for core functions; not just UDF/CFC
functions. From what i understand ACF still does not support this, and
is yet another example of inconsistency that frustrates the CFML developer.
Because of the ACF parameter order of QueryAddColumn() parameters, it
causes some grief. It's a horribly designed function API.
Our advice, is to use named parameters and remove the guess work that
comes with calling the function.
As for query objects not supporting non-simple types -- that is
correct. I would argue your point about it being a "useful feature" as
it promotes poor data structure, and causes no end of grief when it
comes to QueryOfQueries. The Query object is designed to mimic a SQL
query (aka rows+columns). If you want to storing rich objects like
that, then you should stick to arrays/structures or structures/structures.
Hope that helps
a
Fiddlesticks wrote:
Couple of things with QueryAddColumn:
The first (raised previously) is that you need to define a column
type, whereas in CF it's not required.
The second is that is does not appear to support the "Object" type,
meaning you can't insert a structure into a query object, which is a
very useful feature of Coldfusion.
(The "object" type is not mentioned in the CF docs, but is listed as a
supported type in the error message in CF8 when you get the type
wrong.)
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
