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]
