Coldfusion 9 and Tomcat

2009-12-22 Thread Samson Shewandagne
Does coldfusion 9 support tomcat? I can't install IIS in my pc and I want to go for tomcat for my web application server. I read some documentation and I am wondering coldfusion 9 support tomcat. Thanks, Samson ~| Want to

(ot) SQL query aliases in SQL Management Studio

2009-12-22 Thread Jason Durham
My apologies for posting an OT message to a ColdFusion list. RDMS are so closely tied to our day-to-day job in writing CF, that perhaps the list will be tolerant of such a question. I'm writing a View for our CRM package to use. The SQL works as I've written it, but Management Studio keeps

Re: Problem in launching MultiserverMonitor

2009-12-22 Thread Sigi Heckl
Of course I tried it, but as a result I get the same message again :-( Any suggestions? On Thursday 17 Dec 2009, Sigi Heckl wrote: if I try a longer password the button text changes to Set new password Did you press that button ?

Re: (ot) SQL query aliases in SQL Management Studio

2009-12-22 Thread Dave Sueltenfuss
Hi Jason, I would recommended creating the view from a query window, and not the design view that SQL Management studio uses Simply add a 'Create View dbo. AS' before the statement that works and run it in the query window Hope this helps -Dave On Tue, Dec 22, 2009 at 11:34 AM, Jason

Loading an CSV

2009-12-22 Thread Phillip Vector
I have a CSV that looks like the following... 3270,5101650,Dewey, Cheatum Howe , 0 , 0 ,0.00,0.00,9.25,-9.25 3270,5101650,Phillip Vector, 34 , 3,161.00 ,92.97,79.25,61.76,17.50 3270,5101650,James P. Kardone JR., P.C. , 0 , 0 ,0.00,0.00,9.25,-9.25 I'm stuck on how to

RE: (ot) SQL query aliases in SQL Management Studio

2009-12-22 Thread Jason Durham
Thanks Dave. Worked like a charm. I'll just have to annotate the SQL so future modifications to this View don't cause the same problem I've been fighting. -Original Message- From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com] Sent: Tuesday, December 22, 2009 10:48 AM To: cf-talk

Re: (ot) SQL query aliases in SQL Management Studio

2009-12-22 Thread Leigh
I would recommended creating the view from a query window, and not the design view that SQL Management studio uses +1 . Traditionally design views and wizards do unspeakable things to your nicely formatted sql. -Leigh

Re: Loading an CSV

2009-12-22 Thread Barney Boisvert
Use a CSV parsing library, rather than rolling your own. They take care of all that stuff for you. I've used http://ostermiller.org/utils/CSV.html in the past. If you really want to parse it yourself, you can use listToArray, and then iterate over the array and combine items that are quoted.

Re: Loading an CSV

2009-12-22 Thread Claude Schneegans
Simply define an ODBC datasource using the Microsoft txt ODBC driver. Then requst the datasaource to get all records. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion

Re: Loading an CSV

2009-12-22 Thread Phillip Vector
Defining another datasource is not allowed in this. Yes, I know it's easier to do it that way, but unfortunally it's not an option here. On Tue, Dec 22, 2009 at 9:17 AM, Claude Schneegans schneeg...@internetique.com wrote: Simply define an ODBC datasource using the Microsoft txt ODBC driver.

Re: Loading an CSV

2009-12-22 Thread Phillip Vector
On Tue, Dec 22, 2009 at 9:09 AM, Barney Boisvert bboisv...@gmail.com wrote: Use a CSV parsing library, rather than rolling your own. They take care of all that stuff for you. I've used http://ostermiller.org/utils/CSV.html in the past. I took a look at that and didn't see anything that

Re: Loading an CSV

2009-12-22 Thread Leigh
Defining another datasource is not allowed in this. What database(s) are you using? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: Loading an CSV

2009-12-22 Thread Phillip Vector
Oracle, but I do not have permission to set up another datasource. So I need to do it by coding. On Tue, Dec 22, 2009 at 9:24 AM, Leigh cfsearch...@yahoo.com wrote: Defining another datasource is not allowed in this. What database(s) are you using?

Re: Loading an CSV

2009-12-22 Thread Barney Boisvert
Quoting is part of standard CSV, Ostermiller will take care of it. But you don't need to loop over every character. Once you have your array, you start combining when you find an item that begins with a quote, and you stop combining when you find an item that ends with a quote. In my example,

Re: Loading an CSV

2009-12-22 Thread Phillip Vector
Ok.. I see what you are saying... Thanks. :) On Tue, Dec 22, 2009 at 9:26 AM, Barney Boisvert bboisv...@gmail.com wrote: Quoting is part of standard CSV, Ostermiller will take care of it. But you don't need to loop over every character.  Once you have your array, you start combining when you

Re: Loading an CSV

2009-12-22 Thread Leigh
Oracle Okay. I was thinking there might be options with an MS datasource. But as that is out of the question, I would go with Barney's suggestion. (Looks interesting. I will have to try it myself). ~| Want to reach

Re: (ot) SQL query aliases in SQL Management Studio

2009-12-22 Thread Jason Fisher
It looks like the reason for the original rewrite was due to subquerying the same table twice. Nothing wrong with that, but the wizard decides to ensure that every reference is unique, thus the aliasing of the second reference. You could get around that by adding your own table aliases in

cffileupload onUploadComplete not working

2009-12-22 Thread Tim Do
I'm trying to do a multiple file upload using cffileupload. The upload is working fine but I'd like to relocate the user after all files have been uploaded. I added: onComplete=uploadCompleteHandler('#batchUploadName#') But the user is being redirected on the page load and not after the user

RE: Coldfusion 9 and Tomcat

2009-12-22 Thread Scott Stewart
As far as I know it doesn't officially but why not just use Apache if you can't install IIS? -Original Message- From: Samson Shewandagne [mailto:sbeke...@yahoo.com] Sent: Tuesday, December 22, 2009 9:37 AM To: cf-talk Subject: Coldfusion 9 and Tomcat Does coldfusion 9 support tomcat?

Re: Coldfusion 9 and Tomcat

2009-12-22 Thread Matt Quackenbush
Is it officially supported? I don't know; haven't researched that. I am not one of them, but I do know for a fact that people are running CF9 on Tomcat. ~| Want to reach the ColdFusion community with something they want? Let

Re: cffileupload onUploadComplete not working

2009-12-22 Thread Raymond Camden
You don't pass functionname(), but just the name. Change your oncomplete to oncomplete=uploadCompleteHandler Now this means you can't pass in the CF variable. Just use within your js. It will be static on the client side though. On Tue, Dec 22, 2009 at 12:52 PM, Tim Do t...@wng.com wrote:

Re: Searching a Date Range

2009-12-22 Thread Qing Xia
Another approach is to use the dateDiff() SQL function. That way, you can determine the level of precision at which you are comparing. For example, run the following scripts against any SQL database. You will see that the result is quite different. If you only want to know two date values are

Re: Coldfusion 9 and Tomcat

2009-12-22 Thread Judah McAuley
Also if it is a matter of needing a webserver for development purposes, CF9 has a built in web server. It is not recommended for production use but should work fine for basic development. Judah On Tue, Dec 22, 2009 at 6:36 AM, Samson Shewandagne sbeke...@yahoo.com wrote: Does coldfusion 9

Re: Searching a Date Range

2009-12-22 Thread Leigh
SET @dateVal_2 = '2009-12-22 23:59:59.000' You will see that the result is quite different.  If you only want to know two date values are on the same day regardless of time, then using dateDiff() may be safer. If the comparison is structured correctly, the results are the same (or

Re: Loading an CSV

2009-12-22 Thread Kevin Pepperman
I had a similar situation recently in an export from an old legacy application. (90% of my job) It may not apply to your situation, but it sure saves me a ton of time, so it is slightly relevant here. (Windows info only here) The data contained every single char (comma, semicolon, TAB, QUOTES[

RE: Coldfusion 9 and Tomcat

2009-12-22 Thread Sebastiaan GMC van Dijk
CF runs on any J2EE server with any webserver ;-) Sebastiaan Naafs - van Dijk http://onlinebase.nl/ _ Windows Live™ Mail. Flere kontoer på ett sted. http://download.live.com/wlmai

Re: Searching a Date Range

2009-12-22 Thread Qing Xia
True, if at least one side of the date comparison is a constant then it is better to structure the comparison in such a way that functions can be avoided. On Tue, Dec 22, 2009 at 3:56 PM, Leigh cfsearch...@yahoo.com wrote: SET @dateVal_2 = '2009-12-22 23:59:59.000' You will see that the

Re: Coldfusion 9 and Tomcat

2009-12-22 Thread Sean Corfield
On Tue, Dec 22, 2009 at 6:36 AM, Samson Shewandagne sbeke...@yahoo.comwrote: Does coldfusion 9 support tomcat? I can't install IIS in my pc and I want to go for tomcat for my web application server. I read some documentation and I am wondering coldfusion 9 support tomcat. The ORM embedded