Yes the fact that you can store rich objects in a query you create is dumb in the extreme as it breaks so many other parts that don't know what to do when they encounter them.
One thing that I believe is not supported in OpenBD which i think is in ACF is the idea of adding a blank column so in the value array field passing a blank array QueryAddcolumn ( query, column, datatype, *arrayNew(1)*) Now this can easily be got around in a sql query by just doing something like '' as nameofcolumn but worth mentioning Shall I raise a bug ? A On 5 January 2012 11:25, Alan Williamson (aw2.0 cloud experts) < [email protected]> wrote: > 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<https://plus.google.com/115990347459711259462> > > http://groups.google.com/**group/openbd?hl=en<http://groups.google.com/group/openbd?hl=en> > > Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012 > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- 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
