>>>which means I
> can't use it in a UDF with CF5 because you can't put a
> <cfx> tag (or
> any tag) in cfscript.
> Well, the idea of ODBCInfo is to return queries, and you
> cannot use queries in cfscript either, so...
No you can't, although you can instantiate a JDBC class and execute
its methods to return a ResultSet object which can then be converted
into a query (manually -- I haven't found a reliable way to
instantiate a ColdFusion query object using a resultset). None of
which requires the use of either <cfquery> or <cffunction>, so that
all works in pure cfscript-declared UDF's. I rather assumed that
something similar would be true of returning data from ODBC code
written in C++, that you could return a C++ ResultSet object and then
convert that into a query without going through the cfquery or
cffunction tags to get it.
>>>I'm sure you're not interested in donating the code,
>>>since it's an
> income source for you.
> Well, its not really that the income is making me rich,
> but considering the amount of work involved,
> the current price is not scandalous ;-)
Not at all. :) I've looked at the info about ODBC on MS Website and I
don't envy you. :) Well I do, but I don't. :)
> Everyone who ever played with the ODBC API knows what I
> mean ;-)
I'm sure they do.
>>>So access doesn't support ODBC's standard with regard to
>>>primary and foreign key information?
> Nope, although Access does support primary and foreign
> keys, but the ODBC API does not.
Ohh... so you're going to use the db specific features in sql server
and oracle to get that data... nice. I suppose ultimately if I had a
client with a budget and I _had_ to make the onTap framework work with
Access databases, I could license a copy of the cfx tag and then
execute that within a <cffunction> to make it transparent, but that's
all rather speculative. As it is very few of the database features
work with Access, and I keep too busy with other things to worry too
much about it.
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
