Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified
Actually,
[Bindable]
private var people_info:ArrayCollection;
shoudl be outside of function myfunction
Jay Jayaraman
Central Billing Services
Financial Management and Planning
(404) 498-8453 (W)
(404) 273-7131 (C)
From: viswanathan.jayara...@atl.frb.org
To: discussion@acfug.org
Date: 09/09/2010 01:58 PM
Subject:Re: [ACFUG Discuss] newbie question: storing an array
variable into a variable whose data type is not specified
Sent by:ad...@acfug.org
This is how you will do it
.
In the actionscript, you will do
[Bindable]
private var people_info:ArrayCollection;
people_info = eventObj.result.people_info as ArrayCollection;
as the result from your cfc contains three elements
people_Info
statMsg
status
Jay Jayaraman
Central Billing Services
Financial Management and Planning
(404) 498-8453 (W)
(404) 273-7131 (C)
From:Chris H
To:discussion@acfug.org
Date:09/09/2010 01:09 PM
Subject:Re: [ACFUG Discuss] newbie question: storing an array
variable into a variable whose data type is not specified
Sent by:ad...@acfug.org
Thanks Steve, Jay, Clark and Axunderwood for the prompt responses and
useful suggestions.
1. I have changed the return type of function to "struct" and other
changes in the function as below according to the suggestions
ArrayAppend(peoplearray, #printPeople.empID#);
ArrayAppend(peoplearray, #printPeople.departmentname#);
ArrayAppend(peoplearray, #printPeople.departmentID#);
ArrayAppend(peoplearray, #printPeople.empTitle#);
.
Rest of part is same as I posted earlier
2. How would I reference the return values in the caller function which is
a Flex component?
private function myfunction(eventObj:ResultEvent):void{
var people_obj:Object = new Object();
people_obj.dept_name = eventObj.result.dept_name;
people_obj.dept_num = eventObj.result.dept_num;
// would the below code work?
people_obj.peoplearray = eventObj.result.peoplearray
}
// How can I access the department name, department ID and employee ID,
title of the third person whose name is John from the above people_obj //
object?
// Or, do I need an arraycollection variable
[Bindable]
private var people_info:ArrayCollection;
people_info = eventObj.result.peoplearray
Then, I could load the arraycollection variable people_info into a
DataGrid element where the elements would be displayed in order?
Can someone please advise?
Thanks
From: Steve Ross
To: discussion@acfug.org
Sent: Thu, September 9, 2010 9:55:29 AM
Subject: Re: [ACFUG Discuss] newbie question: storing an array variable
into a variable whose data type is not specified
yep, what you are actually doing is creating a named struct (hash) when
you do this:
changing the return type will give you exactly what you want (unless you
want an array), and if you do then you can create an array of structs...
On Thu, Sep 9, 2010 at 9:51 AM, Chris H wrote:
Hi All,
I am a newbie to Coldfusion. My development background is mainly in C/C++
so please excuse me if my below question is naive.
I have a function as below
SELECT *
FROM people
WHERE peopleName = "John"
ArrayAppend(peoplearray, #printPeople.empID#);
ArrayAppend(peoplearray, #printPeople.departmentname#);
ArrayAppend(peoplearray, #printPeople.departmentID#);
ArrayAppend(peoplearray, #printPeople.empTitle#);
The part http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-
--
Steve Ross
web application & interface developer
http://blog.stevensross.com
[mobile] (912) 344-8113
[ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www
Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified
This is how you will do it
.
In the actionscript, you will do
[Bindable]
private var people_info:ArrayCollection;
people_info = eventObj.result.people_info as ArrayCollection;
as the result from your cfc contains three elements
people_Info
statMsg
status
Jay Jayaraman
Central Billing Services
Financial Management and Planning
(404) 498-8453 (W)
(404) 273-7131 (C)
From: Chris H
To: discussion@acfug.org
Date: 09/09/2010 01:09 PM
Subject:Re: [ACFUG Discuss] newbie question: storing an array
variable into a variable whose data type is not specified
Sent by:ad...@acfug.org
Thanks Steve, Jay, Clark and Axunderwood for the prompt responses and
useful suggestions.
1. I have changed the return type of function to "struct" and other
changes in the function as below according to the suggestions
ArrayAppend(peoplearray, #printPeople.empID#);
ArrayAppend(peoplearray, #printPeople.departmentname#);
ArrayAppend(peoplearray, #printPeople.departmentID#);
ArrayAppend(peoplearray, #printPeople.empTitle#);
.
Rest of part is same as I posted earlier
2. How would I reference the return values in the caller function which is
a Flex component?
private function myfunction(eventObj:ResultEvent):void{
var people_obj:Object = new Object();
people_obj.dept_name = eventObj.result.dept_name;
people_obj.dept_num = eventObj.result.dept_num;
// would the below code work?
people_obj.peoplearray = eventObj.result.peoplearray
}
// How can I access the department name, department ID and employee ID,
title of the third person whose name is John from the above people_obj //
object?
// Or, do I need an arraycollection variable
[Bindable]
private var people_info:ArrayCollection;
people_info = eventObj.result.peoplearray
Then, I could load the arraycollection variable people_info into a
DataGrid element where the elements would be displayed in order?
Can someone please advise?
Thanks
From: Steve Ross
To: discussion@acfug.org
Sent: Thu, September 9, 2010 9:55:29 AM
Subject: Re: [ACFUG Discuss] newbie question: storing an array variable
into a variable whose data type is not specified
yep, what you are actually doing is creating a named struct (hash) when
you do this:
changing the return type will give you exactly what you want (unless you
want an array), and if you do then you can create an array of structs...
On Thu, Sep 9, 2010 at 9:51 AM, Chris H wrote:
Hi All,
I am a newbie to Coldfusion. My development background is mainly in C/C++
so please excuse me if my below question is naive.
I have a function as below
SELECT *
FROM people
WHERE peopleName = "John"
ArrayAppend(peoplearray, #printPeople.empID#);
ArrayAppend(peoplearray, #printPeople.departmentname#);
ArrayAppend(peoplearray, #printPeople.departmentID#);
ArrayAppend(peoplearray, #printPeople.empTitle#);
The part http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-
--
Steve Ross
web application & interface developer
http://blog.stevensross.com
[mobile] (912) 344-8113
[ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified
I think you have to first declare before attempting to do this Jay Jayaraman Central Billing Services Financial Management and Planning (404) 498-8453 (W) (404) 273-7131 (C) From: Chris H To: discussion@acfug.org Date: 09/09/2010 09:51 AM Subject:[ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified Sent by:ad...@acfug.org Hi All, I am a newbie to Coldfusion. My development background is mainly in C/C++ so please excuse me if my below question is naive. I have a function as below SELECT * FROM people WHERE peopleName = "John" ArrayAppend(peoplearray, #printPeople.empID#); ArrayAppend(peoplearray, #printPeople.departmentname#); ArrayAppend(peoplearray, #printPeople.departmentID#); ArrayAppend(peoplearray, #printPeople.empTitle#); The part http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] cflocation with variables encrypted, is it safe approach?
Return Receipt Your Re: [ACFUG Discuss] cflocation with variables encrypted, is document: it safe approach? was[EMAIL PROTECTED] received by: at:07/29/2008 06:01:22 PM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] cflocation with variables encrypted, is it safe approach?
Return Receipt Your Re: [ACFUG Discuss] cflocation with variables encrypted, is document: it safe approach? was[EMAIL PROTECTED] received by: at:07/29/2008 06:01:18 PM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] OT: Contract
Return Receipt Your Re: [ACFUG Discuss] OT: Contract document: was[EMAIL PROTECTED] received by: at:07/15/2008 01:59:16 PM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Assistance parsing XML file?
Return Receipt Your Re: [ACFUG Discuss] Assistance parsing XML file? document: was[EMAIL PROTECTED] received by: at:07/15/2008 11:57:13 AM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Assistance parsing XML file?
Return Receipt Your Re: [ACFUG Discuss] Assistance parsing XML file? document: was[EMAIL PROTECTED] received by: at:07/15/2008 10:09:21 AM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] showing image from network share..how to?
Return Receipt Your Re: [ACFUG Discuss] showing image from network share..how document: to? was[EMAIL PROTECTED] received by: at:05/12/2008 12:28:01 PM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] showing image from network share..how to?
Return Receipt Your Re: [ACFUG Discuss] showing image from network share..how document: to? was[EMAIL PROTECTED] received by: at:05/12/2008 11:15:38 AM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] showing image from network share..how to?
Return Receipt Your Re: [ACFUG Discuss] showing image from network share..how document: to? was[EMAIL PROTECTED] received by: at:05/12/2008 11:14:43 AM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Best way to download a PDF file
Return Receipt Your Re: [ACFUG Discuss] Best way to download a PDF file document: was[EMAIL PROTECTED] received by: at:05/01/2008 11:50:57 AM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Creating a web service
maybe, I am way off, but function returntype is string, while it seems to
return boolean
Jay Jayaraman
Central Billing Services
Financial Management and Planning
(404) 498-8453 (W)
(404) 273-7131 (C)
"Kevin Hellriegel" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/21/2008 04:59 PM
Please respond to
discussion@acfug.org
To
discussion@acfug.org
cc
Subject
[ACFUG Discuss] Creating a web service
I'm having a slight problem with a web service I'm trying to create. I
have a cfc that looks similar to this:
[Lots of code to validate the PickupDoc]
I created a simple cfm page that tries to use the cfc as a webservice:
http://dev/import.cfc?wsdl";>
The web service *should* return false, but instead I get the error
message:
Web service operation "Import" with parameters {PickupDoc={Hello my baby,
hello my honey},SenderID={Test}} could not be found.
I can see the wsdl when I copy the url and put it into my browser. If I
change the cfinvoke to use it as a component instead of a webservice it
works fine. I must be missing something. Any ideas? This is in CFMX 7.0.2.
Thanks,
Kevin
-
Annual Sponsor - Figleaf Software
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
Re: [ACFUG Discuss] can external java app use datasources defined in Coldfusion?
Thanks Doug and Charlie. I will try to define and use the JNDI datasources. One question. If I define a JNDI datasource with the user name and password while defining, then do I need to reenter user name and password again in CFAdmin when I define the datasource as J2EE datasource type? Jay Jayaraman Central Billing Services Financial Management and Planning (404) 498-8453 (W) (404) 273-7131 (C) "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/02/2008 01:15 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] can external java app use datasources defined in Coldfusion? I've used the approach Charlie outlined before. In both the JMC and CFAdmin tools the dsn password is encrypted in the xml file. DK On 4/2/08, Dean H. Saxe <[EMAIL PROTECTED]> wrote: > But of course any of those configs is vulnerable to the password being > stolen. Its an interesting problem for production boxes and one I > hope to see a whitepaper from Foundstone on soon... ;-) > > There are some products out there that allow credentials to be > "checked out" when needed (think like source control), but I have not > yet looked into them. > > -dhs > > > Dean H. Saxe, CISSP, CEH > [EMAIL PROTECTED] > "What is objectionable, what is dangerous about extremists is not that > they are extreme, but that they are intolerant." > -- Robert F. Kennedy, 1964 > > > On Apr 2, 2008, at 9:41 AM, [EMAIL PROTECTED] wrote: > > > > > Hello, > > > > We have some java application using its own datasource to > > connect to the database. This requires either hardcoding username > > and password or put it in a config file. Is there a way for this > > jav app to use datasources defined in Coldfusion so that java app > > can share the same db connection pool? > > > > > > Jay Jayaraman > > Central Billing Services > > Financial Management and Planning > > (404) 498-8453 (W) > > (404) 273-7131 (C) > > - > > Annual Sponsor - Figleaf Software > > > > To unsubscribe from this list, manage your profile @ > > http://www.acfug.org?fa=login.edituserform > > > > For more info, see http://www.acfug.org/mailinglists > > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > > List hosted by FusionLink > > - > > -- Sent from Gmail for mobile | mobile.google.com Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] can external java app use datasources defined in Coldfusion?
Hello, We have some java application using its own datasource to connect to the database. This requires either hardcoding username and password or put it in a config file. Is there a way for this jav app to use datasources defined in Coldfusion so that java app can share the same db connection pool? Jay Jayaraman Central Billing Services Financial Management and Planning (404) 498-8453 (W) (404) 273-7131 (C) - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] SQL JOIN problem
Try this. SELECT vja.jobID, j. jobName, vja.vendorID FROM job_tbl j LEFT JOIN vja_tbl vja ON j.jobID = vja.jobID WHERE vja.vendorID = '1' or vja.VendorID is null Jay x8453 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/26/2007 03:38 PM Please respond to discussion@acfug.org To cc Subject [ACFUG Discuss] SQL JOIN problem Hello ALL, My problem is not strictly speaking a ColdFusion issue, however I am using it in a CF application AND I know there?re a few SQL geniuses out there. I?m hoping one of those geniuses can help me. I have two tables: job_tbl and vja_tbl job_tbl contains: jobID, jobName vja_tbl contains: jobID, vendorID vja_tbl is used to Assign Vendors to Jobs. I need a result set that contains: - all the jobs (all the records of the job_tbl) (all the records of the first table) - with only the vendorID of a specific/selected Vendor (only the redords of vja_tbl WHERE vja.vendorID = ?1?, for example) (only the records of the 2nd table WHERE?) I believe what I need is a LEFT OUTER JOIN, at least my description ?appears? to meet the definition of an OUTER JOIN. Example data: job_tbl jobID jobName 1 Andre 2 Beer 3 Beresovsky 4 Brooks 5 Fontana and so on? vja_tbl jobID vendorID 11 1 15 2 37 3 1 4 16 5 7 and so on? I will pass a variable, form.vendorID, to the query for a selected Vendor. I need a result set that gives me ALL the jobs (5 in this example) with the vendorID for only the jobs that this Vendor is assigned to. Desired result set for: vendorID = 1 jobID jobIName vendorID 1 Andre1 2 Beer 3 Beresovsky 1 4 Brooks 5 Fontana Example LEFT JOIN of (one of my attempts) SELECT vja.jobID, j. jobName, vja.vendorID FROM job_tbl j LEFT JOIN vja_tbl vja ON j.jobID = vja.jobID WHERE vja.vendorID = '1' However this only produces 2 records: jobID jobIName vendorID 6 Andre1 7 Beresovsky 1 I have GOOGLED myself crazy looking for insight/education into how to do this, but (from my flawed point of view) every example I?ve found ?appears? to suggest a workable solution and yet I can?t get the full result set I need. It is import to the next step in the application that I have a full result set of ALL jobID?s with only a vendorID value equal to the selected vendor. All other records must contain . The full-result set is presented to the user as a ?checkbox form? with checked jobNames for only those jobs to which the vendor is assigned to. The user can then check or un-check the jobNames and this ?updated? set is re-INSERTed to the the vja_tbl. I hope my explanation and examples clearly express what I need to do?I?m STUCK though on how to get there from here. Thanks for your consideration, Dan Kaufman [EMAIL PROTECTED] "What is the distance between the eyes and the soul?" Fortune Cookie - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Getting Flex2Gateway to work with https
For me, it did not. I had to restart teh server. Jay x8453 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2007 11:57 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https Well, for me it works without restarting the server. Try it and see. :) shawn gorrell <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 11:40 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https But of course. - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: discussion@acfug.org Sent: Wednesday, August 15, 2007 11:34:49 AM Subject: Re: [ACFUG Discuss] Getting Flex2Gateway to work with https One more question. Whenever I change the services-config.xml, Do I need to stop and start ColdfFusion service? Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 10:48 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https ah, ok. This whole thing is a real undocumented shambles IMHO. Folks on flexcoders, some Adobe one seven, say you can have multiple channel defs in here and that your Flex app will try each one until it finds one that works. This never worked for me. To try this, looks like you need to add to the channels list perhaps. What I did in the end was to set the my-cfamf channel to use https, thus only one channel. I could do this at the time as ALL things on the server required https. HTH! DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED] > wrote: I get a blank page when I type http:///flex2gateway/ I get the following error when I type https:///flex2gateway/ 500 No configured channel has an endpoint path '/flex2gateway/'. flex.messaging.MessageException: No configured channel has an endpoint path '/flex2gateway/'. at flex.messaging.MessageBroker.getEndpoint(MessageBroker.java:318) at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:329) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:259) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Jay x8453 "Charlie Arehart" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 10:32 AM Please respond to discussion@acfug.org To cc Subject RE: [ACFUG Discuss] Getting Flex2Gateway to work with https Jay, did you write what you meant? because it sounds like you got what you expected. :-) You said, "I should...get a blank page...I am not getting that...it gives me a blank page." Or am I reading this wrong? :-) /charlie From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 15, 2007 9:55 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Getting Flex2Gateway to work with https without going to Flex App, I should be able to type https:///flex2gateway/ and get a blank page. Is that correct? I am not getting that. http:///flex2gateway/ gives me a blank page. Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 09:38 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https You have to compile the Flex app against this services-config file. I'd leave the endpoint URIs using the variables instead of hard-coded URLs too. This way you can have two services-config files on your local machine, one for http one for https. Simply point FB to the one you need and compile. DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: Hello, I have a problem getting the https:///flex2gateway/ to work. This is what I did: 1. Added a channel definition for https in services-config file. * false remote
Re: [ACFUG Discuss] Getting Flex2Gateway to work with https
Your suggestion did it after I added the channels and recycled the ColdFusion Service Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 10:48 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https ah, ok. This whole thing is a real undocumented shambles IMHO. Folks on flexcoders, some Adobe one seven, say you can have multiple channel defs in here and that your Flex app will try each one until it finds one that works. This never worked for me. To try this, looks like you need to add to the channels list perhaps. What I did in the end was to set the my-cfamf channel to use https, thus only one channel. I could do this at the time as ALL things on the server required https. HTH! DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED] > wrote: I get a blank page when I type http:///flex2gateway/ I get the following error when I type https:///flex2gateway/ 500 No configured channel has an endpoint path '/flex2gateway/'. flex.messaging.MessageException: No configured channel has an endpoint path '/flex2gateway/'. at flex.messaging.MessageBroker.getEndpoint(MessageBroker.java:318) at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:329) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:259) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Jay x8453 "Charlie Arehart" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 10:32 AM Please respond to discussion@acfug.org To cc Subject RE: [ACFUG Discuss] Getting Flex2Gateway to work with https Jay, did you write what you meant? because it sounds like you got what you expected. :-) You said, "I should...get a blank page...I am not getting that...it gives me a blank page." Or am I reading this wrong? :-) /charlie From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 15, 2007 9:55 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Getting Flex2Gateway to work with https without going to Flex App, I should be able to type https:///flex2gateway/ and get a blank page. Is that correct? I am not getting that. http:///flex2gateway/ gives me a blank page. Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 09:38 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https You have to compile the Flex app against this services-config file. I'd leave the endpoint URIs using the variables instead of hard-coded URLs too. This way you can have two services-config files on your local machine, one for http one for https. Simply point FB to the one you need and compile. DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: Hello, I have a problem getting the https:///flex2gateway/ to work. This is what I did: 1. Added a channel definition for https in services-config file. * false remote false false false http://f122w17/flex2gateway/ " class="flex.messaging.endpoints.AMFEndpoint "/> false false https://f122w17/flex2gateway/ " class="flex.messaging.endpoints.SecureAMFEndpoint"/> false false [Flex] false false false false
Re: [ACFUG Discuss] Getting Flex2Gateway to work with https
One more question. Whenever I change the services-config.xml, Do I need to stop and start ColdfFusion service? Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 10:48 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https ah, ok. This whole thing is a real undocumented shambles IMHO. Folks on flexcoders, some Adobe one seven, say you can have multiple channel defs in here and that your Flex app will try each one until it finds one that works. This never worked for me. To try this, looks like you need to add to the channels list perhaps. What I did in the end was to set the my-cfamf channel to use https, thus only one channel. I could do this at the time as ALL things on the server required https. HTH! DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED] > wrote: I get a blank page when I type http:///flex2gateway/ I get the following error when I type https:///flex2gateway/ 500 No configured channel has an endpoint path '/flex2gateway/'. flex.messaging.MessageException: No configured channel has an endpoint path '/flex2gateway/'. at flex.messaging.MessageBroker.getEndpoint(MessageBroker.java:318) at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:329) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:259) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Jay x8453 "Charlie Arehart" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 10:32 AM Please respond to discussion@acfug.org To cc Subject RE: [ACFUG Discuss] Getting Flex2Gateway to work with https Jay, did you write what you meant? because it sounds like you got what you expected. :-) You said, "I should...get a blank page...I am not getting that...it gives me a blank page." Or am I reading this wrong? :-) /charlie From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 15, 2007 9:55 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Getting Flex2Gateway to work with https without going to Flex App, I should be able to type https:///flex2gateway/ and get a blank page. Is that correct? I am not getting that. http:///flex2gateway/ gives me a blank page. Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 09:38 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https You have to compile the Flex app against this services-config file. I'd leave the endpoint URIs using the variables instead of hard-coded URLs too. This way you can have two services-config files on your local machine, one for http one for https. Simply point FB to the one you need and compile. DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: Hello, I have a problem getting the https:///flex2gateway/ to work. This is what I did: 1. Added a channel definition for https in services-config file. * false remote false false false http://f122w17/flex2gateway/ " class="flex.messaging.endpoints.AMFEndpoint "/> false false https://f122w17/flex2gateway/ " class="flex.messaging.endpoints.SecureAMFEndpoint"/> false false [Flex] false false false
RE: [ACFUG Discuss] Getting Flex2Gateway to work with https
I get a blank page when I type http:///flex2gateway/ I get the following error when I type https:///flex2gateway/ 500 No configured channel has an endpoint path '/flex2gateway/'. flex.messaging.MessageException: No configured channel has an endpoint path '/flex2gateway/'. at flex.messaging.MessageBroker.getEndpoint(MessageBroker.java:318) at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:329) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:259) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Jay x8453 "Charlie Arehart" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 10:32 AM Please respond to discussion@acfug.org To cc Subject RE: [ACFUG Discuss] Getting Flex2Gateway to work with https Jay, did you write what you meant? because it sounds like you got what you expected. :-) You said, "I should...get a blank page...I am not getting that...it gives me a blank page." Or am I reading this wrong? :-) /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 15, 2007 9:55 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Getting Flex2Gateway to work with https without going to Flex App, I should be able to type https:///flex2gateway/ and get a blank page. Is that correct? I am not getting that. http:///flex2gateway/ gives me a blank page. Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 09:38 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https You have to compile the Flex app against this services-config file. I'd leave the endpoint URIs using the variables instead of hard-coded URLs too. This way you can have two services-config files on your local machine, one for http one for https. Simply point FB to the one you need and compile. DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: Hello, I have a problem getting the https:///flex2gateway/ to work. This is what I did: 1. Added a channel definition for https in services-config file. * false remote false false false http://f122w17/flex2gateway/"; class="flex.messaging.endpoints.AMFEndpoint "/> false false https://f122w17/flex2gateway/"; class="flex.messaging.endpoints.SecureAMFEndpoint"/> false false [Flex] false false false false Endpoint.* Service.* Configuration Message.* 2. Recycled the ColdFusion Service I know I am missing some step. I would appreciate if somebody can help me identify what I am missing. Thanks Jay x8453 - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - Annual Sponsor - Figleaf Software To
Re: [ACFUG Discuss] Getting Flex2Gateway to work with https
without going to Flex App, I should be able to type https:///flex2gateway/ and get a blank page. Is that correct? I am not getting that. http:///flex2gateway/ gives me a blank page. Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2007 09:38 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Getting Flex2Gateway to work with https You have to compile the Flex app against this services-config file. I'd leave the endpoint URIs using the variables instead of hard-coded URLs too. This way you can have two services-config files on your local machine, one for http one for https. Simply point FB to the one you need and compile. DK On 8/15/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: Hello, I have a problem getting the https:///flex2gateway/ to work. This is what I did: 1. Added a channel definition for https in services-config file. * false remote false false false http://f122w17/flex2gateway/"; class="flex.messaging.endpoints.AMFEndpoint "/> false false https://f122w17/flex2gateway/"; class="flex.messaging.endpoints.SecureAMFEndpoint"/> false false [Flex] false false false false Endpoint.* Service.* Configuration Message.* 2. Recycled the ColdFusion Service I know I am missing some step. I would appreciate if somebody can help me identify what I am missing. Thanks Jay x8453 - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Getting Flex2Gateway to work with https
Hello, I have a problem getting the https:///flex2gateway/ to work. This is what I did: 1. Added a channel definition for https in services-config file. * false remote false false false http://f122w17/flex2gateway/"; class="flex.messaging.endpoints.AMFEndpoint"/> false false https://f122w17/flex2gateway/"; class="flex.messaging.endpoints.SecureAMFEndpoint"/> false false [Flex] false false false false Endpoint.* Service.* Configuration Message.* 2. Recycled the ColdFusion Service I know I am missing some step. I would appreciate if somebody can help me identify what I am missing. Thanks Jay x8453 - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Atlanta Flash/Flex UG - New Features in Flex 3 and AIR
Return Receipt Your Re: [ACFUG Discuss] Atlanta Flash/Flex UG - New Features in document: Flex 3 and AIR was[EMAIL PROTECTED] received by: at:07/23/2007 07:33:30 AM - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] moving tables across data sources
If you are using SQL Server, you can use DTS Jay x8453 "Tepfer, Seth" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/13/2007 09:44 AM Please respond to discussion@acfug.org To cc Subject [ACFUG Discuss] moving tables across data sources What is the quick and easy way to copy a table from one data source to another? The table structure exists, it?s just empty. I was thinking of doing some SQL like: INSERT INTO carrierLanesCopy SELECT carrierLanes.* FROM carrierLanes; But then I realized there is no reference to DS in the query itself. Stupid. I don?t want to have to loop over each line of the table, reading and writing. There has to be a better way, right? seth - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Installing CF MX 6.1 on W2K3
Return Receipt Your Re: [ACFUG Discuss] Installing CF MX 6.1 on W2K3 document: was[EMAIL PROTECTED] received by: at:06/26/2007 07:44:05 AM - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] EOLAS fix for ColdFusion Flash Forms
If you are using Sent by: [EMAIL PROTECTED] 06/18/2007 12:28 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] EOLAS fix for ColdFusion Flash Forms Ok, so I did this update to my development environment and it did indeed fix the issue with Flash forms. I then approached my boss with the idea of updating the production server and he was apprehensive and asked that I research if this fix created any new issues and if so what they were. So, I ask this forum if there are any known issues created by the 7.0.2 update? Thanks, Jeff On 6/16/07, Charlie Arehart <[EMAIL PROTECTED]> wrote: Jeff, are you running 7.02? According to the release notes, that should have been fixed (and indeed by cumulative hotfixes for 7.01 if you're still on that release). From http://www.adobe.com/support/documentation/en/coldfusion/mx702/cf702_releasenotes.html : "ColdFusion MX 7.01 Cumulative Hot Fix 1, 2 and 3, including a Microsoft Internet Explorer EOLAS fix for UI components and Flash Forms. For more information, see Issues Fixed in this Release. - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] CF and Oracle
Thank you for your response. That is a good idea. Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/10/2007 03:20 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] CF and Oracle ugh, cfstoredproc is for callling SPs, not functions. I'never tried calling functions with it at least. To call the function, simply use cfquery with SQL like select testfunction() from dual; cfprocresult is for result sets being returned, use cfprocparam to retrieve values returned from a proc. Odd thing is I didn't get the error you got at all, I'm using 9i here. DK On 5/10/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: DK, I am trying to call a Oracle Stored Function that returns NUMBER or VARCHAR. I get an error "Object has been closed" (error Code HY000). If Oracle Stored Function returns a ref cursor, it works fine. Here is the ColdFusion Code that calls stored function returning NUMBER: This fails with the above error Stored Function TESTFUNCTION CREATE OR REPLACE FUNCTION TESTFUNCTION return NUMBER as begin RETURN 100; end; Here is the ColdFusion Code that calls Stored Function returning ref cursor: This works. Stored Function TESTFUNCTION2 CREATE OR REPLACE FUNCTION TESTFUNCTION2 return types.ref_cursor as arg_cursor types.ref_cursor; begin OPEN arg_cursor FOR SELECT 100 FROM DUAL; return arg_cursor; end; Thanks Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/09/2007 02:57 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] CF and Oracle yes. DK On 5/9/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: Hello, Has anybody been actively working on Flex, CF and Oracle? I have a few questions. Thanks Jay x8453 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] CF and Oracle
DK, I am trying to call a Oracle Stored Function that returns NUMBER or VARCHAR. I get an error "Object has been closed" (error Code HY000). If Oracle Stored Function returns a ref cursor, it works fine. Here is the ColdFusion Code that calls stored function returning NUMBER: This fails with the above error Stored Function TESTFUNCTION CREATE OR REPLACE FUNCTION TESTFUNCTION return NUMBER as begin RETURN 100; end; Here is the ColdFusion Code that calls Stored Function returning ref cursor: This works. Stored Function TESTFUNCTION2 CREATE OR REPLACE FUNCTION TESTFUNCTION2 return types.ref_cursor as arg_cursor types.ref_cursor; begin OPEN arg_cursor FOR SELECT 100 FROM DUAL; return arg_cursor; end; Thanks Jay x8453 "Douglas Knudsen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/09/2007 02:57 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] CF and Oracle yes. DK On 5/9/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: Hello, Has anybody been actively working on Flex, CF and Oracle? I have a few questions. Thanks Jay x8453 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] CF and Oracle
Hello, Has anybody been actively working on Flex, CF and Oracle? I have a few questions. Thanks Jay x8453 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
