I think I saw a trac ticket before I started on a bit of a merry
blitz, for someone asking for something for those DB specific
queries so we can use the power of reactor (meta data) in
there.
E.G.: Instead of
SELECT fu.fuField, baa.baaField FROM fu t1 LEFT JOIN baa t1 ON t1.link =
t2.link
I'm doing:
SELECT [foo:fooField], [bar:barField] FROM [foo:] t1 LEFT...
Which you can probably guess, is parsed so that I can use reactor
object names vs. the actual table names.
I achieve this via a function which takes the object names (to get the
metadata) and
searches/replaces, something like:
runQuery("foo, bar","SELECT [foo:fooField], [bar:barField] FROM [foo:]...");
I can post it, much as I hate to share stuff that others might actually try
to use,
but I was wondering if someone was tackling that ticket or if there is a way
to
do that now?
I'd hate to post it because I only use it in a specific couple of places,
and it
probably isn't very optimal (as I'm only sorta familiar with the guts of
Reactor,
thus the code is pretty brutish.) and it's not an edit I made to reactor,
but
a component in/of one of my models actually doing the deeds.
Bah, I'll post it, maybe blog it, as I've been meaning to, but I can just
see
some poor schmoe building an empire on a bunch of sand, if you under-
stand... eh.
* * *
If this post made sense, you must be pretty good at puzzles. :-P
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
