[ACFUG Discuss] DC CF Users Group - broadcast today @ 9:00 AM EST

2007-02-13 Thread Steve Drucker
http://figleaf.mmalliance.acrobat.com/useadobeug/ http://figleaf.mmalliance.acrobat.com/useadobeug/ Audio will be provided via VOIP. 9:00 AM- 10:00 AM: ColdFusion Application and Security Presenter: Adam Lehman, Adobe

Re: [ACFUG Discuss] DC CF Users Group - broadcast today @ 9:00 AM EST

2007-02-13 Thread Dean H. Saxe
Is this going to be available online for later viewing? -dhs On February 13, 2007, Steve Drucker wrote: http://figleaf.mmalliance.acrobat.com/useadobeug/ http://figleaf.mmalliance.acrobat.com/useadobeug/ Audio will be provided via VOIP.

[ACFUG Discuss] coldfusion mx 7 hosts file

2007-02-13 Thread Steven Ross
Ok, I've been digging and I am having an issue where Coldfusion (and possibly the underlying java) is having to time out when trying to resolve a DNS entry before it looks in my hosts file. I have verified through ping that my machine is using the hosts file correctly however when it comes to CF

[ACFUG Discuss] Re: coldfusion mx 7 hosts file

2007-02-13 Thread Steven Ross
Sorry, I am not using java 1.5 the string below should read .../Versions/1.4.2/Home/... On 2/13/07, Steven Ross [EMAIL PROTECTED] wrote: Ok, I've been digging and I am having an issue where Coldfusion (and possibly the underlying java) is having to time out when trying to resolve a DNS entry

RE: [ACFUG Discuss] Installed CF 7 multi server config over Server config...Not sure what I have now???

2007-02-13 Thread Charlie Arehart
Ajas, just to clarify: if all you wanted was to test some JSP pages, you never needed to bother with the second install. The base version you installed would have worked. (JSPs can be run by CF in the Enterprise, but not the Standard, edition. That's about editions, not how it's installed. And the

[ACFUG Discuss] Calling DTS package from CFM page

2007-02-13 Thread Ajas Mohammed
Hi, I was looking around to find code for calling a DTS package from cfm page. I found this code below. I am able to connect and everything but I would like to see the status of DTS package execution not just individual steps. I got the individual steps there status codes by adding some code

Re: [ACFUG Discuss] Re: coldfusion mx 7 hosts file

2007-02-13 Thread Andrew Powell
Just to clarify: A VIP, or Virtual IP, is usually an IP address on a router or firewall that is presenting services (HTTP,FTP,etc.) for one or more other IP addresses behind a firewall. On Feb 13, 2007, at 3:08 PM, Douglas Knudsen wrote: I put the VIP right in the datasource def via

[ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS

2007-02-13 Thread Douglas Knudsen
I just updated our JDBC drivers to the latest 3.5 versions for testing out in a dev instance. We are planning to move to Oracle 10g next Q. A developer is seeing some errors with a query using GROUP BY GROUPING SETS. The error is [Macromedia][Oracle JDBC Driver][Oracle]ORA-03001: unimplemented

Re: [ACFUG Discuss] Re: coldfusion mx 7 hosts file

2007-02-13 Thread Douglas Knudsen
ah, I see now. Hence the use in LB setups. danke. DK On 2/13/07, Andrew Powell [EMAIL PROTECTED] wrote: Just to clarify: A VIP, or Virtual IP, is usually an IP address on a router or firewall that is presenting services (HTTP,FTP,etc.) for one or more other IP addresses behind a firewall.

Re: [ACFUG Discuss] Re: coldfusion mx 7 hosts file

2007-02-13 Thread Steven Ross
Hmm... since this is only failing on my local box it really isnt worth the effort... works fine in dev using the hosts file on solaris. Just breaks locally on my mac. On 2/13/07, Andrew Powell [EMAIL PROTECTED] wrote: Just to clarify: A VIP, or Virtual IP, is usually an IP address on a router

RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS

2007-02-13 Thread Fennell, Mark P.
Can you share a sample of sql statement causing the error? Thanks. mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Tuesday, February 13, 2007 3:18 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF, Oracle 9i, and

Re: [ACFUG Discuss] Calling DTS package from CFM page

2007-02-13 Thread Teddy Payne
Ajas, I would not really approach DTS tracking just from a COM package. SQL Server stores all of the information about a DTS package, the execution, steps and failures in the master DB. Create a read-only user to connect to your SQL Server's master DB and then just start exploring all of the

RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS

2007-02-13 Thread Fennell, Mark P.
Dang... now that's some serious sql spaghetti. While I don't see anything in the documentation for 9.2 regarding limits on grouping sets, it might not hurt to consider using the cube or rollup group statement keywords, creating a view to simplify the decodes and rounds and other

Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS

2007-02-13 Thread Douglas Knudsen
if only you knew the meatball. :) passed the info along. thanks. We are able to execute this in Toad, SQL+, PL/SQL Developer, and SQL Developer. SQL Developer uses JDBC, so seems its related to teh 3.5 version of the data direct drivers. DK On 2/13/07, Fennell, Mark P. [EMAIL PROTECTED]

RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS

2007-02-13 Thread Fennell, Mark P.
One last thought. If it works in toad just create or replace myViewName as select... and then select from the view in your cfquery. :) mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Tuesday, February 13, 2007 4:22 PM To:

Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS

2007-02-13 Thread Gerrey . Mary-Catherine
I know, I know, RTFM, but it has walked off. What does GROUP BY GROUPING SETS do for you? Are you sure that's a query, and not a novel in some foreign language? mcg Douglas Knudsen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/13/2007 03:28 PM Please respond to discussion@acfug.org

RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS

2007-02-13 Thread Fennell, Mark P.
From TFM... GROUPING SETS GROUPING SETS are a further extension of the GROUP BY clause that let you specify multiple groupings of data. Doing so facilitates efficient aggregation by pruning the aggregates you do not need. You specify just the desired groups, and Oracle does not need to perform

[ACFUG Discuss] CF - How to create tab delimited text file from query

2007-02-13 Thread Ajas Mohammed
Hi there, Looks like today is DB day. I want to develop a feature wherein user accessing the site should be able to create a tab delimited text file ( i have a query which will be used) and user should also be able to download this new tab delimited text file. Any suggestions are

RE: [ACFUG Discuss] CF - How to create tab delimited text file from query

2007-02-13 Thread Charlie Arehart
Ajas, does it really need to be tab-delimited? Or is comma-separated (CSV) ok? The latter is available at the cflib.org site, a great site with pre-written solutions to common problems. It has a search area, and searching for CSV found these: http://www.cflib.org/udf.cfm?ID=556 or