Hi,
Running CFMX 6.1.
I notice that there is no option to add a datasource to connect to Oracle.
A colleague reckons we need to get Enterprise. Is this indeed the case?
Cheers,
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England
http://www.macromedia.com/software/coldfusion/productinfo/product_editions/#s2
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To
Hmm... Try dropping in the jdbc driver for the oracle database in to the
appropriate folder
(JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\lib or
equivalent), and make a datasource of type 'other' and handcraft the
connection string.
I'm not sure if the 'other' option is available on
Scott,That is totally the case.However you can hook up to Oracle using JDBC and/or ODBC drivers depending on what you need.http://www.compoundtheory.com/?action=""
I wrote that ages ago, so it may be out of date, but it should give you the gist of what you need if you want to do it.MarkOn 3/17/06,
Thanks for all replies.
We may give the below a go, or just splurge on Enterprise (like I wanted to do
in the first place... and go to version 7).
[EMAIL PROTECTED] 17/03/2006 10:48 am
Scott,
That is totally the case.
However you can hook up to Oracle using JDBC and/or ODBC drivers
Show us how you created the query q_getStates and show us the
actionPopulate code.
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the
On 17/03/06, Chris Velevitch [EMAIL PROTECTED] wrote:
Show us how you created the query q_getStates and show us theactionPopulate code.
Okay, here's both of my queries and the actionPopulate code:
cfquery datasource=#application.misc.dsn# name=q_getStates
SELECT DISTINCT state
FROM
The only thing that's different is the query comes from a database,
but the example does it in memory. Play around with the query.
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
--~--~-~--~~~---~--~~
You received