to bet it's nothing fancy, though. It could be a stored procedure. Sorry.
----- Original Message -----
From: "Brian Yager" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 9:22 AM
Subject: Re:Problems talking with Oracle (oracle object and methods)...
> I am wanting to use the oracle object so I can use the oracle methods.
This way, I can change oracle passwords and such through my application.
>
> Brian
>
> >You don't have to "make connections" to oracle in CF, though. All you
have
> >to is use the cfquery tag. It seems like this would do what you're
wanting:
> >
> ><cfset username = "dadada">
> ><cfset password = "aaaaa">
> >
> >>> > ConnectString = "DEV"
> >>> > UID = Username & "/" & Password
> >
> >These should be set in your CF Datasource, then you just use:
> ><cfset mydsn = "thenameofthedesnsetincfadmin">
> >
> >Then:
> ><cfquery name="#username#" password="#password#" datasource="#mydsn#">
> >SELECT description
> >FROM news
> >WHERE complete = 'N'
> >AND start_date >=sysdate
> ></cfquery>
> >
> >
> >----- Original Message -----
> >From: "Brian Yager" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Thursday, February 12, 2004 7:36 AM
> >Subject: Re:Problems talking with Oracle...
> >
> >
> >> This is the piece of code that I am having a hard time writing in CF.
> >Basically, I am wanting to create the object so I can use it and it's
> >methods...There is a lot more code then what I have listed...This is just
> >the code that creates it.
> >>
> >> Thanks,
> >>
> >> Brian
> >>
> >>
> >> >It doesn't look to me like that's telling you anything about a
username.
> >It
> >> >looks like it's just opening a connection and running a pretty
standard
> >> >query. Are you sure you're looking at the right piece of code?
> >> >
> >> >-Deanna
> >> >
> >> >----- Original Message -----
> >> >From: "Brian Yager" <[EMAIL PROTECTED]>
> >> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >> >Sent: Wednesday, February 11, 2004 3:12 PM
> >> >Subject: Re:Problems talking with Oracle...
> >> >
> >> >
> >> >> Anyone?
> >> >>
> >> >>
> >> >>
> >> >> > Hello...I am needing to talk to the Oracle object to see if a
> >username
> >> >> > is valid, password is expired or in the grace period. I have some
> >ASP
> >> >> > code that I am having problems converting to CF. Here is what
they
> >> >> > had...
> >> >> >
> >> >> >
> >> >> > OBJECT RUNAT=Server
> >> >>
> >> >> > SCOPE=Application
> >> >>
> >> >> > ID=OraSession
> >> >>
> >> >> > PROGID="OracleInProcServer.XOraSession">
> >> >> > /OBJECT>
> >> >> >
> >> >> >
> >> >> > and
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > Dim OraErr
> >> >> >
> >> >> > 'On Error Resume Next
> >> >> >
> >> >> > Username = "dadada"
> >> >> > Password = "aaaaa"
> >> >> > ConnectString = "DEV"
> >> >> > UID = Username & "/" & Password
> >> >> >
> >> >> > Set OraDatabase =
OraSession.OpenDatabase(ConnectString,UID,Cint(0))
> >> >> >
> >> >> > OraDB_OK = OraDatabase.ConnectionOK
> >> >> >
> >> >> > v_count = 0
> >> >> > If OraDB_OK Then
> >> >> >
> >> >>
> >> >> > vSQL = "SELECT DESCRIPTION " & _
> >> >>
> >> >> > "FROM NEWS " & _
> >> >>
> >> >> > "WHERE COMPLETE='N' " & _
> >> >>
> >> >> > "OR START_DATE >= SYSDATE " & _
> >> >>
> >> >> > "ORDER BY START_DATE"
> >> >>
> >> >> >
> >> >>
> >> >> > Set OraDynaSet = OraDatabase.DbCreateDynaSet( vSQL, Cint(0))
> >> >>
> >> >> > Do While (OraDynaSet.EOF = False)
> >> >>
> >> >> > v_count = v_count + 1
> >> >>
> >> >> > Response.Write("<tr><td align=left bgcolor=#CDCDCD height=30><font
> >> >> > color=black>")
> >> >>
> >> >> > Response.Write (OraDynaset.Fields("DESCRIPTION") )
> >> >>
> >> >> > Response.Write ("</font></td></tr>")
> >> >>
> >> >> > OraDynaset.MoveNext
> >> >>
> >> >> > Loop
> >> >>
> >> >> > If v_count = 0 Then
> >> >>
> >> >> > Response.Write("<tr><td align=left bgcolor=#CDCDCD height=30><font
> >> >> > color=black>There is no news at this time</font></td></tr>")
> >> >>
> >> >> > End If
> >> >> > Else
> >> >>
> >> >> > Response.Write("<tr><td align=left bgcolor=#CDCDCD height=30><font
> >> >> > color=black>There was a problem getting news</font></td></tr>")
> >> >> > End If
> >> >> >
> >> >> > OraDatabase.Close
> >> >> >
> >> >> >
> >> >> > Thanks all!
> >> >> >
> >> >> >
> >> >> > Brian Yager
> >> >> > President - North Alabama
> >> >> > Cold Fusion Users Group
> >> >> > http://www.nacfug.com
> >> >> > GMD-JPO OCD IT
> >> >> > Computer Scientist - Contractor CSC
> >> >> > (256)313-9668
> >> >> > [EMAIL PROTECTED]
> >> >> mil
> >> >>
> >>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
