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.
Exact, the CFX API has all the necessary functionalities to do this, and this is
the way ODBCInfo works.
I developed ODBCInfo even before CF 5, JDBC was not around, and know I don't
fell like rewriting the whole thing to use JDBC.
>>I've looked at the info about ODBC on MS Website and I
don't envy you. :) Well I do, but I don't. :)
;-)... And in the MS docs, you have a description of how it should work, not always
identical to how it really works... ;-/
>>Ohh... so you're going to use the db specific features in sql server
and oracle to get that data... nice.
Well, for the ODBC SQL Server and Oracle drivers, the SQLPrimaryKeys and SQLForeignKeys functions are supported. It is only for Access that they are not, I don't know why.
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
