Problems talking with Oracle...
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 = "a"
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("")
Response.Write (OraDynaset.Fields("DESCRIPTION") )
Response.Write ("")
OraDynaset.MoveNext
Loop
If v_count = 0 Then
Response.Write("There is no news at this time")
End If
Else
Response.Write("There was a problem getting news")
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]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
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 = "a"
> 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("
> color=black>")
> Response.Write (OraDynaset.Fields("DESCRIPTION") )
> Response.Write ("")
> OraDynaset.MoveNext
> Loop
> If v_count = 0 Then
> Response.Write("
> color=black>There is no news at this time")
> End If
> Else
> Response.Write("
> color=black>There was a problem getting news")
> 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]
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 = "a"
>> > 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("
>> > color=black>")
>>
>> > Response.Write (OraDynaset.Fields("DESCRIPTION") )
>>
>> > Response.Write ("")
>>
>> > OraDynaset.MoveNext
>>
>> > Loop
>>
>> > If v_count = 0 Then
>>
>> > Response.Write("
>> > color=black>There is no news at this time")
>>
>> > End If
>> > Else
>>
>> > Response.Write("
>> > color=black>There was a problem getting news")
>> > 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]
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:
>
>
>
>
>>> > ConnectString = "DEV"
>>> > UID = Username & "/" & Password
>
>These should be set in your CF Datasource, then you just use:
>
>
>Then:
>
>SELECT description
>FROM news
>WHERE complete = 'N'
>ANDstart_date >=sysdate
>
>
>
>- 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 = "a"
>> >> > 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("
>> >> > color=black>")
>> >>
>> >> > Response.Write (OraDynaset.Fields("DESCRIPTION") )
>> >>
>> >> > Response.Write ("")
>> >>
>> >> > OraDynaset.MoveNext
>> >>
>> >> > Loop
>> >>
>> >> > If v_count = 0 Then
>> >>
>> >> > Response.Write("
>> >> > color=black>There is no news at this time")
>> >>
>> >> > End If
>> >> > Else
>> >>
>> >> > Response.Write("
>> >> > color=black>There was a problem getting news")
>> >> > 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]
Using Stored Procedures in CF
Hi all...In my 7 years of using CF, I have never used a stored procedure. Can anyone help me understand how I need to code it? For example purposes, lets just say I have 2 values that I need to pass to it. How would this be coded? Thanks much, Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Using Stored Procedures in CF
What publisher is that from? I'll go out and get it today! Thanks, Brian >I cover stored procedures at length in The ColdFusion MX Bible, both for >Microsoft SQL Server and Oracle 9i. Another good source is Books On Line >that comes with Microsoft SQL Server, but they don't cover the ColdFusion >side of things. > >Respectfully, > >Adam Phillip Churvis >Member of Team Macromedia > >Advanced Intensive ColdFusion MX Training: >* ColdFusion MX Master Class >* Advanced Development with CFMX and SQL Server 2000 >http://www.ColdFusionTraining.com > >Download CommerceBlocks V2.1 and LoRCAT from >http://www.ProductivityEnhancement.com > >The ColdFusion MX Bible is in bookstores now! >- Original Message - >From: "Brian Yager" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, March 05, 2004 9:12 AM >Subject: Using Stored Procedures in CF > > >> Hi all...In my 7 years of using CF, I have never used a stored procedure. >Can anyone help me understand how I need to code it? For example purposes, >lets just say I have 2 values that I need to pass to it. How would this be >coded? >> >> >> Thanks much, >> >> Brian >> >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Encrypting CF code/files
I have been tasked with learning all I can on this. I have searched the knowledge base but didn't find what I thought was encrypting the code. Can anyone send me a link to where this is explained or tell me how you go about doing this? Thanks, Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Encrypting CF code/files
Thanks much. This is exactly what I needed. This is for a classified site that will be on a classified network...We just want it for an extra layer of security. Brian > What you're after is cfcrypt.exe > > here's a link that explains how to use it: > > http://www.macromedia. com/v1/documents/cf4/Adva> nced_ColdFusion_Development/11_Building_ColdFusion_Extensions/adv11_09. > htm > > And here's one that explains that encrypted templates can easily be > decrypted: > > http://www.macromedia.com/devnet/security/security_zone/asb99-08.html > > Cheers > Bert > > > > > > > > -Original Message- > > From: Brian Yager [mailto:[EMAIL PROTECTED] > > Sent: 22 March 2004 14:48 > > To: CF-Talk > > Subject: Encrypting CF code/files > > > > > > I have been tasked with learning all I can on this. I have > > searched the knowledge base but didn't find what I thought > > was encrypting the code. Can anyone send me a link to where > > this is explained or tell me how you go about doing this? > > > > Thanks, > > > > Brian > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Having a problem using cfstoredproc
Hi all...This is my first time using a stored procedure. I am getting this error [Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored procedure call. Check your bindings against the stored procedure's parameters. Here is my code And here is the SQL package with the stored procedure (it is the in_grace one) /* Formatted on 2004/05/06 14:59 (Formatter Plus v4.8.0) */ CREATE OR REPLACE PACKAGE class_user_maint IS PROCEDURE change_password ( i_user IN VARCHAR2, i_password IN VARCHAR2, o_msgOUT VARCHAR2 ); PROCEDURE in_grace ( i_user IN VARCHAR2, o_grace OUT VARCHAR2, o_days OUT NUMBER ); FUNCTION session_exists (i_user IN VARCHAR2) RETURN VARCHAR2; END class_user_maint; / Can someone please help me figure out what I need to do to get this to work? Thank you very much. Brian Yager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sending a disconnect to Oracle through CF code...
Has anyone done this before? I have a task that I must check to see if the user already has an Oracle session active when they log on. If they do, do not allow the logon. If they don't, let them continue. The Oracle session lasts for 15 minutes of inactivity. When the user logs out of the application, I need to log them out of Oracle as well. Thanks in advance Brian Yager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending a disconnect to Oracle through CF code...
> Brian Yager wrote: > > > I have a task that I must check to see if the user already has an > Oracle session active when they log on. If they do, do not allow the > logon. > > Logon trigger in Oracle? To log them in, I just use their username and password in a query. > > > The Oracle session lasts for 15 minutes of inactivity. When the > user logs out of the application, I need to log them out of Oracle as > well. > > Don't know. > > Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Web service for MLS (Multiple Listing Service...houses)
Does anyone know of a webservice for MLS? I am wanting my client be able to list all of her houses based off of what is in the MLS database. Has anyone done anything like this? Thanks, Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Trying to uplaod a file using CFFILE, I am getting an error...
I am getting an error that the form field does not contain a file.
Here is the code from the first page
<br>
function parseFile1Name(theFile)<br>
{<br>
var start = -1;<br>
while (theFile.value.indexOf("\\", start + 1) != -1)<br>
{<br>
start = theFile.value.indexOf("\\", start + 1);<br>
}<br>
document.form.up_thefile.value = theFile.value.substring(start+1, theFile.value.length);<br>
}<br>
<br>
And here is the code from the second page
select value from class_parameter where parameter = 'FILESERVER'
form.thefile is #form.myfile# and #form.up_thefile#
I am getting a value for both form.myfile and form.up_thefile. But I am getting
"The form field C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp60591.tmp did not conatin a file"
I am using CFMX6.1 on a Windows 2000 Server with Oracle 9i. Has anyone seen this before?
Thank for the help.
Brian Yager
President - North Alabama
Cold Fusion Users Group
http://www.nacfug.com
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Trying to uplaod a file using CFFILE, I am getting an error...
I believe this was it...Thanks much for the help! Brian >Make sure your filefield attribute is correct in the cffile action. I >think it needs just the field name 'myfile' not '#form.myfile#' > >-- >Expert Hosting for Less! >http://exciteworks.com > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Trying to uplaod a file using CFFILE, I am getting an error...
The JS is not altering the file upload...it is just grabing the name of the file and placing it in a hidden form field. Brian >You cannot use JS to alter a file upload field value. This is a security >feature. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ListGetAt vs. ListToArray
Why not just loop on the list? Brian >I have an application where I have to read a large file, record by record. >After each record is read, I do some processing of the data and then save it >to a database table. The question is, after I've read the record (which is >a comma separated string) is it more efficient to use ListGetAt to access >individual data elements or just do one ListToArray and then operate on the >array? Or, is there a better way? > >Walt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Looking for a UPS rate checker custom tag
I don't mind buying one if it's good. If you have one or know of one please let me know ([EMAIL PROTECTED]) I want one that will basicaly tell the user the shipping rate based on address and weight. Thanks, 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] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
