OpenBD, Stuctures, Queries, and Structures within Queries
9 views
Skip to first unread message
Fiddlesticks
Jan 3, 2012, 5:31:16 PM1/3/12
to BlogCFC
version 5.9.8.012
blog.cfc line 1517- 1533
Hi. Just upgrading to the latest version of blogcfc, and thought I'd
share a few gotchas. I'm using openBlueDragon as my CF engine.
Issue 1. is more a problem openBlueDragon has with arguments:
<cfset queryAddColumn(getEm,"categories",arrayNew(1))> will fail
because it does not define a type at position 3.
Having said that, lines 1529 - 1533 appear to be generating a
structure and placing it within the newly added column. Genius idea,
but never seen it done before. Is this supported in CF proper, or a
"hidden" feature? Either way my installation doesn't seem to like
it. As a workaround I have reverted to the commented out idea of
setting two columns and inserting the data separately.
blog.cfc line 1517- 1533
Hi. Just upgrading to the latest version of blogcfc, and thought I'd
share a few gotchas. I'm using openBlueDragon as my CF engine.
Issue 1. is more a problem openBlueDragon has with arguments:
<cfset queryAddColumn(getEm,"categories",arrayNew(1))> will fail
because it does not define a type at position 3.
Having said that, lines 1529 - 1533 appear to be generating a
structure and placing it within the newly added column. Genius idea,
but never seen it done before. Is this supported in CF proper, or a
"hidden" feature? Either way my installation doesn't seem to like
it. As a workaround I have reverted to the commented out idea of
setting two columns and inserting the data separately.
Raymond Camden
Jan 3, 2012, 5:37:20 PM1/3/12
to blo...@googlegroups.com
BlogCFC does not support openBD. Basically if it fails there, it fails there.
Well, that's my opinion anyway, Stroz and the New Leadership (grin)
can say if the support plans have changed.
Fiddlesticks
Jan 3, 2012, 5:56:43 PM1/3/12
to BlogCFC
Fair enough. :)
Stephen Moretti
Jan 4, 2012, 6:47:23 AM1/4/12
to blo...@googlegroups.com
I don't see on the OpenBD documentation anything about whether the datatype is required or not (its not required in ACF9). It might be worth raising it on the OpenBD mailing list as an incompatibility or a point for clarification.
Stephen
--
Stephen Moretti
Blog : http://nil.checksite.co.uk/
Twitter : http://twitter.com/mr_nil
Stephen Moretti
Blog : http://nil.checksite.co.uk/
Twitter : http://twitter.com/mr_nil
More Twitter : http://twitter.com/CFOverflow
Fiddlesticks
Jan 4, 2012, 9:53:32 AM1/4/12
to BlogCFC
Yup. It's already been raised already on the openBD list.
Interestingly, the CF documentation omits to mention the supported
column type of "Object", which was the one I needed.
After guessing at "Structure" the CF8 error message tells me what the
supported column types are (including "Object").
Will have to wait until I get home and then see if OpenBD will play
nice with "Object" as a column type.
On Jan 4, 11:47 am, Stephen Moretti <stephen.more...@gmail.com> wrote:
Interestingly, the CF documentation omits to mention the supported
column type of "Object", which was the one I needed.
After guessing at "Structure" the CF8 error message tells me what the
supported column types are (including "Object").
Will have to wait until I get home and then see if OpenBD will play
nice with "Object" as a column type.
On Jan 4, 11:47 am, Stephen Moretti <stephen.more...@gmail.com> wrote:
Raymond Camden
Jan 4, 2012, 10:00:27 AM1/4/12
to blo...@googlegroups.com
On Wed, Jan 4, 2012 at 8:53 AM, Fiddlesticks <mst...@fsmail.net> wrote:
> Will have to wait until I get home and then see if OpenBD will play
> nice with "Object" as a column type.
Or use a proper CF engine.
(Ahem.)
Fiddlesticks
Jan 4, 2012, 1:37:29 PM1/4/12
to BlogCFC
No go. Ah well, back to my workaround.
On Jan 4, 3:00 pm, Raymond Camden <raymondcam...@gmail.com> wrote:
On Jan 4, 3:00 pm, Raymond Camden <raymondcam...@gmail.com> wrote:
Reply all
Reply to author
Forward
0 new messages