cfgridcolumn name=Value numberformat=_-_,___,___.00 does not work
cfgridcolumn name=Value numberformat=_-_,___,___.00 does not work Normally in a table this works: #LSNumberFormat(SumInv,_-_,___,___.__)# it will display as : 4,100.00 which is correct. But when in a cgfrid cfgridcolumn name=Invoice_Value numberformat=_-_,___,___.00 but it displays in the grid as: -, 4,100.00 which is incorrect Please Help! Thank You ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ORM with convention over configuration?
On Tuesday 03 Apr 2007, Dinner wrote: Although I *did* hear that Doug was moth-balling Reactor to work on Transfer... April 1st was two days ago. -- Tom Chiverton Helping to evangelistically utilize extensible systems on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Subversion questions
On Tuesday 03 Apr 2007, Dinner wrote: As always, the PITA of linking or sharing components is that you gotta really test everything that uses that component whenever you make a change to it. It's harder to stage roll-outs when code is shared, and Not really - remember you can peg an svn:externals to a particular revision. -- Tom Chiverton Helping to evangelistically harness real-time solutions on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PS3 :: to run CFMX8 better then windows vista..
On Tuesday 03 Apr 2007, Dinner wrote: happy April fools all... That was *yesterday*. Not according to my clock. That was rather my point :-) kicks the dirt Who's he, and what's he done :-) ? -- Tom Chiverton Helping to efficiently coordinate efficient e-services on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: iSeries point to ColdFusion server direction...
Bob, I'm not familiar with the iSeries Apache Web server, but if you are using a standard apache web server, you would use the wsconfig program that gets installed with apache to connect to coldfusion. You can also manually copy over the mod_jrun22.so or mod_jrun2.so files and manually put in the configuration. Something like this: LoadModule jrun_module C:/JRun4/lib/wsconfig/mod_jrun22.so # JRun Settings IfModule mod_jrun22.c JRunConfig Verbose true JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore C:/JRun4/lib/wsconfig/1/jrunserver. store JRunConfig Bootstrap x.x.x.x:51002 #JRunConfig Errorurl optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 #JRunConfig ConnectTimeout 15 #JRunConfig RecvTimeout 300 #JRunConfig SendTimeout 15 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Hope this helps, Russ -Original Message- From: Bob Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 4:24 PM To: CF-Talk Subject: Re: iSeries point to ColdFusion server direction... I found an article on Adobe's site talking about Distributed configuration but it was for version 5. Anyone have anything newer that they've seen and what I would need to do to the Apache on the iSeries to point correctly to ColdFusion on W2K3? Thanks. I hope someone can point me in the right direction or fill me in... Currently where I work we donââ¬â¢t use ColdFusion but Iââ¬â¢m putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donââ¬â¢t want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iSeries point to ColdFusion server direction...
Thank you for the reply Russ. So, how in Apache to I actually point it to the ColdFusion server? Is there a line in the config where I would say that it needs to go to the W2K3 server for ColdFusion pages. Thanks again. This is new to me. Bob Bob, I'm not familiar with the iSeries Apache Web server, but if you are using a standard apache web server, you would use the wsconfig program that gets installed with apache to connect to coldfusion. You can also manually copy over the mod_jrun22.so or mod_jrun2.so files and manually put in the configuration. Something like this: LoadModule jrun_module C:/JRun4/lib/wsconfig/mod_jrun22.so # JRun Settings IfModule mod_jrun22.c JRunConfig Verbose true JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore C:/JRun4/lib/wsconfig/1/jrunserver. store JRunConfig Bootstrap x.x.x.x:51002 #JRunConfig Errorurl optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 #JRunConfig ConnectTimeout 15 #JRunConfig RecvTimeout 300 #JRunConfig SendTimeout 15 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Hope this helps, Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: iSeries point to ColdFusion server direction...
On Tuesday 03 Apr 2007, Bob Johnson wrote: So, how in Apache to I actually point it to the ColdFusion server? Is there a line in the config where I would say that it needs to go to the W2K3 server for ColdFusion pages. JRunConfig Bootstrap x.x.x.x:51002 :-) -- Tom Chiverton Helping to adaptively innovate best-of-breed systems on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
US/Canada Dropdown?
Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT ISAPI Rewrite
On 4/2/07, Russ [EMAIL PROTECTED] wrote: I simply point out that Apache might be a good solution to the problem that the person is having. Russ, I think the point is that the original question was I have just downloaded ISAPI and need help using it, not I hate the fact that IIS does not have a built-in re-write engine, what alternatives are there. This thread has been totally hijacked into being an IIS vs. Apache discussion and Pete's question was never answered. It doesn't really matter if he was using Apache or IIS with ISAPI-Rewrite to do his re-writes, the fact is that he would probably still need help, since the re-write syntax is pretty much the same. Hopefully Pete is not completely discusted that he cannot get a simple question answered. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT ISAPI Rewrite
Russ, I think the point is that the original question was I have just downloaded ISAPI and need help using it, not I hate the fact that IIS does not have a built-in re-write engine, what alternatives are there. This thread has been totally hijacked into being an IIS vs. Apache discussion and Pete's question was never answered. It doesn't really matter if he was using Apache or IIS with ISAPI-Rewrite to do his re-writes, the fact is that he would probably still need help, since the re-write syntax is pretty much the same. Hopefully Pete is not completely discusted that he cannot get a simple question answered. Dean Dean, I'm sorry if I've hijacked the discussion. I was simply answering someone that said that Apache has no advantage on the Windows box, which I feel is simply not true. I see that someone gave Pete some examples right before this whole thread hijacking started. Perhaps Pete has figured it out? I, too, would like to know whether Pete has solved his problem and what he ended up doing. Russ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL question
I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL question
I wrote a blog post concerning this a while back: http://www.stillnetstudios.com/2007/01/20/comparing-dates-without-times-in-sql-server/ Hope that helps. -Ryan Chad Gray wrote: I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
I tried that also and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:01 AM To: CF-Talk Subject: RE: SQL question How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: US/Canada Dropdown?
There aren't that many Canadian provinces - why not just add them? Straight from Wikipedia (I'm pretty sure you don't have to cross-reference this one): The current provinces are Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island, Quebec, and Saskatchewan. The three territories are Northwest Territories, Nunavut, and Yukon. Thanks! Jake Pilgrim Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
How about using... WHERE dateCreated LIKE '%4/2/2007%' -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:05 AM To: CF-Talk Subject: RE: SQL question I tried that also and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:01 AM To: CF-Talk Subject: RE: SQL question How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL question
Chad Gray wrote: I want to find all records with the day 4/2/2007? WHERE DATEDIFF(day, dateCreated,'4/3/2007')=0 ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
I tried that too and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:09 AM To: CF-Talk Subject: RE: SQL question How about using... WHERE dateCreated LIKE '%4/2/2007%' -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:05 AM To: CF-Talk Subject: RE: SQL question I tried that also and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:01 AM To: CF-Talk Subject: RE: SQL question How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: US/Canada Dropdown?
Thanks Jake! Do you know if there are abbreviations for those provinces? -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:58 AM To: CF-Talk Subject: Re: US/Canada Dropdown? There aren't that many Canadian provinces - why not just add them? Straight from Wikipedia (I'm pretty sure you don't have to cross-reference this one): The current provinces are Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island, Quebec, and Saskatchewan. The three territories are Northwest Territories, Nunavut, and Yukon. Thanks! Jake Pilgrim Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL question
Give the CONVERT function a try: WHERE CONVERT(varchar(10), dateCreated, 101) = '04/02/2007' This will change the style of the dateCreated value into mm/dd/ format, which is what the 101 means, when running the comparison. On 4/3/07, Chad Gray [EMAIL PROTECTED] wrote: I tried that also and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:01 AM To: CF-Talk Subject: RE: SQL question How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
Ooh.. I like that one -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:10 AM To: CF-Talk Subject: Re: SQL question Chad Gray wrote: I want to find all records with the day 4/2/2007? WHERE DATEDIFF(day, dateCreated,'4/3/2007')=0 ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
Select * From table Where convert(varchar, datecreated, 101)='04/02/07' Jim Gurfein managing member mediaSPA 56 locust avenue | rye | ny 10580 | usa t 914.921.3200 x 101 | m 914.588.9392 | f 914.921.9190 uk | 0207-993-2601 x101 www.mediaspa.com -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:10 AM To: CF-Talk Subject: Re: SQL question Chad Gray wrote: I want to find all records with the day 4/2/2007? WHERE DATEDIFF(day, dateCreated,'4/3/2007')=0 ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
AH! This works! Thanks! -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:10 AM To: CF-Talk Subject: Re: SQL question Chad Gray wrote: I want to find all records with the day 4/2/2007? WHERE DATEDIFF(day, dateCreated,'4/3/2007')=0 ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
Option 1. Use the CONVERT() function to get strip the time from the date. Then, you have a date string to which you can compare. Option 2. Use a combination of DAY() MONTH() YEAR() SQL functions. (This isn't the best solution, but it would work.) Ex: WHERE DAY(dateCol)=#dayVar# AND MONTH(dateCol)=#monthVar# AND YEAR(dateCol)=#yearVal# -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:12 AM To: CF-Talk Subject: RE: SQL question I tried that too and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:09 AM To: CF-Talk Subject: RE: SQL question How about using... WHERE dateCreated LIKE '%4/2/2007%' -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:05 AM To: CF-Talk Subject: RE: SQL question I tried that also and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:01 AM To: CF-Talk Subject: RE: SQL question How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT ISAPI Rewrite
I understand that you have to make excuses for your web server because it doesn't support a certain feature. I'm not sure what you mean by my web server, since I support several different web servers, and work with them regularly. Some of my clients use IIS, some use Apache, some use other web servers. I have very little control over what they use, and if my answer to their web server configuration questions was just use Apache, they would fire me. I'm not sure why you felt that you have to resort to name calling. Perhaps it is because you have conceded my argument. I humbly accept your surrender. In the face of trollish behavior, surrender is the only option. I'm not resorting to name-calling, simply observing your behavior. Nevertheless, I will try to explain why I perceive your behavior as trollish. This is CF-Talk, and managing a web server is part of the job for a lot of us. When a problem comes up that might be related to IIS, I simply point out that Apache might be a good solution to the problem that the person is having. That is not an accurate description of your actions. This thread started when a poster asked how to use ISAPI Rewrite. At that point, he already had ISAPI Rewrite, which is functionally equivalent in most respects to mod_rewrite, shares most of mod_rewrite's syntax, and is perfectly suitable for the vast majority of URL rewriting needs. He simply wanted to know how to rewrite URLs. At that point, you suggested he use Apache instead. This is not a solution to his problem, since he would still need to learn how to rewrite URLs. Your response was either mindless evangelism or a troll. I'm not sure which is worse, so I gave you the benefit of the doubt as to your being mindless. If someone was using Apache and complained that they couldn't understand the configuration files and wanted a GUI, wouldn't you suggest they move to IIS? Probably not, actually. There are, as you know, plenty of administrative utilities for Apache. In most cases, it's easier to learn how to use these utilities than to change an integral part of your existing infrastructure. And that's the crux of my point, with regard to your being a troll. If someone has hundreds of virtual servers (presumably not an uncommon situation for people on the list), with existing SSL certs, configuration options, etc, etc, it is simply not a viable option to switch web servers in many cases. Yet that is the only suggestion you ever make. Occasionally, you may be right, in the same manner that a stopped clock is right twice a day. Nevertheless, it is trollish behavior. If someone said that they were using Apache and needed to deploy a .NET app, would you not suggest they switch to IIS? Probably, because IIS is the only supported platform for running .NET applications, and new features in .NET will be available on IIS long before they're available elsewhere. I don't bash IIS on purpose; just provide arguments for Apache when someone asks for them. But, in this thread, no one asked for them! Are you hearing voices? I must say, It really is sad, that even with IIS 7, MS has not provided the rewriting functionality as part of the server. Who cares, other than you? There are plenty of ways to solve that problem. http://msdn2.microsoft.com/en-us/library/ms972974.aspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: US/Canada Dropdown? **Disregard**
Please disregard. I found them.. (must remember.. Google is my friend) -Original Message- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:13 AM To: CF-Talk Subject: RE: US/Canada Dropdown? Thanks Jake! Do you know if there are abbreviations for those provinces? -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:58 AM To: CF-Talk Subject: Re: US/Canada Dropdown? There aren't that many Canadian provinces - why not just add them? Straight from Wikipedia (I'm pretty sure you don't have to cross-reference this one): The current provinces are Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island, Quebec, and Saskatchewan. The three territories are Northwest Territories, Nunavut, and Yukon. Thanks! Jake Pilgrim Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
The trick with date and MSSQL is using and . The string '04/02/2007' is seen by MSSQL as '04/02/2007 00:00:00', so your condition will return only those records with that exact timestamp. You have to use: WHERE dateCreated = '04/02/2007' AND dateCreateted '04/03/2007' Steve Brownlee http://www.fusioncube.net/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
Ben, Ok... Nicely done. What about BETWEEN ... Any benefits there? WHERE date_created BETWEEN @date AND @date + 1 -Mark -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: US/Canada Dropdown?
Thanks Jake! Do you know if there are abbreviations for those provinces? -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:58 AM To: CF-Talk Subject: Re: US/Canada Dropdown? There aren't that many Canadian provinces - why not just add them? Straight from Wikipedia (I'm pretty sure you don't have to cross-reference this one): The current provinces are Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island, Quebec, and Saskatchewan. The three territories are Northwest Territories, Nunavut, and Yukon. Thanks! Jake Pilgrim Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: US/Canada Dropdown?
Try this: http://canadaonline.about.com/library/bl/blpabb.htm BTW, ten seconds on Google found the info. Thanks Jake! Do you know if there are abbreviations for those provinces? -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:58 AM To: CF-Talk Subject: Re: US/Canada Dropdown? There aren't that many Canadian provinces - why not just add them? Straight from Wikipedia (I'm pretty sure you don't have to cross-reference this one): The current provinces are Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island, Quebec, and Saskatchewan. The three territories are Northwest Territories, Nunavut, and Yukon. Thanks! Jake Pilgrim Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
BETWEEN is good, but it is doubly-inclusive meaning that it is like doing both = and =. In this case, it might turn up records where the created date is exactly 12:00 AM the next day. What we need is the = and the (not using the equals sign in the second comparison). .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:30 AM To: CF-Talk Subject: RE: SQL question Ben, Ok... Nicely done. What about BETWEEN ... Any benefits there? WHERE date_created BETWEEN @date AND @date + 1 -Mark ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
Ah Gotcha. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:35 AM To: CF-Talk Subject: RE: SQL question BETWEEN is good, but it is doubly-inclusive meaning that it is like doing both = and =. In this case, it might turn up records where the created date is exactly 12:00 AM the next day. What we need is the = and the (not using the equals sign in the second comparison). ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:30 AM To: CF-Talk Subject: RE: SQL question Ben, Ok... Nicely done. What about BETWEEN ... Any benefits there? WHERE date_created BETWEEN @date AND @date + 1 -Mark ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: US/Canada Dropdown?
Thanks! That is what I found via Google :-) -Original Message- From: T A Edge [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: Re: US/Canada Dropdown? Try this: http://canadaonline.about.com/library/bl/blpabb.htm BTW, ten seconds on Google found the info. Thanks Jake! Do you know if there are abbreviations for those provinces? -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:58 AM To: CF-Talk Subject: Re: US/Canada Dropdown? There aren't that many Canadian provinces - why not just add them? Straight from Wikipedia (I'm pretty sure you don't have to cross-reference this one): The current provinces are Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island, Quebec, and Saskatchewan. The three territories are Northwest Territories, Nunavut, and Yukon. Thanks! Jake Pilgrim Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL question
I just tried this and I get no records. dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1) Is this method compatible with MS SQL? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:41 AM To: CF-Talk Subject: RE: SQL question On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL question
DATEADD(YEAR, 1, @someDate) http://www.databasejournal.com/features/mssql/article.php/2216011 has a good primer on date manip for SQL server. -Joe On Apr 3, 2007, at 10:41 AM, Chad Gray wrote: On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
Behind the scenes, date/times are really numbers. They are decimal numbers that represent the number of days that have passed since a given starting date. This starting date, the zero date, is different in SQL than it is in Coldfusion, but the theory still holds. One day = 1 Two days = 2 One and a half days = 1.5 One and a quarter days = 1.25 If you play around with CreateTimeSpan() in ColdFusion, you will see this. CreateTimeSpan( 1, 0, 0, 0 ) === 1. So, by adding one to a date, you are adding a single day (since you are adding one to the underlying decimal value). Here are some related links if you are interested: http://www.bennadel.com/blog/226-ColdFusion-Date-Math-Faster-Than-Date-M ethods-And-Other-Date-Math-Ramblings.htm http://www.bennadel.com/blog/311-Ask-Ben-Looping-Through-The-Days-In-A-M onth.htm http://www.bennadel.com/blog/285-Caution-ColdFusion-Zero-Date-vs-SQL-Zer o-Date.htm Cheers! .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:41 AM To: CF-Talk Subject: RE: SQL question On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL question
Chad, Try WHERE dateCreated = @someDate AND dateCreated DATEADD(DAY, 1, @someDate) -Joe On Apr 3, 2007, at 10:45 AM, Chad Gray wrote: I just tried this and I get no records. dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1) Is this method compatible with MS SQL? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:41 AM To: CF-Talk Subject: RE: SQL question On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
Try putting single quotes around the dates (so it know you are not doing division). dateCreated = '04/02/2007' AND dateCreated ('04/02/2007' + 1) .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:46 AM To: CF-Talk Subject: RE: SQL question I just tried this and I get no records. dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1) Is this method compatible with MS SQL? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
Thanks Ben, and Joe here is what finally worked for me. dateCreated = '04/03/2007' AND dateCreated DATEADD(DAY, 1, '04/03/2007') With dateCreated = '04/03/2007' AND dateCreated ('04/03/2007' + 1) I get this error: Conversion failed when converting the varchar value '04/03/2007' to data type int. So I probably have to cast as a date in order to get this to work. -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:48 AM To: CF-Talk Subject: Re: SQL question Chad, Try WHERE dateCreated = @someDate AND dateCreated DATEADD(DAY, 1, @someDate) -Joe On Apr 3, 2007, at 10:45 AM, Chad Gray wrote: I just tried this and I get no records. dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1) Is this method compatible with MS SQL? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:41 AM To: CF-Talk Subject: RE: SQL question On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFX_XMLParser in MX 7.02
I noticed on the Activsoftware website that this Custom Tag isn't supported in MX7 and that the installation instructions don't cover multiserver environments. Has anybody installed this on MX7 and how did they get on with it? Is there actually any issues with using it or is it just a case that MX7 now has all the tools natively to do the same job so AS have dropped it? Cheers, James ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Mailer Service Bean Issues (MG and CS)
You'll have to excuse me a little on this one guys, there's a fair amount of code involved as I'm unsure as to where the error is occurring. I've spent today building a mailer service which will handle all the email processing for the application. This service consists of two elements, firstly we have the service itself, this contains functions such as setTo(), setContent(), setSubject() and post(), Anything that involves manipulating the mail itself. I also have a mail config bean, which contains all the mail server settings, usernames, passwords and things like this. The config bean is meant to be passed into the service as a constructor, so I can then access them for my cfmail tag as #VARIABLES.Instance.Config.getUsername()# or something like that. Now the problem I'm having is that when trying to use the service and access functions such as the server, I get a message saying The value of the attribute SERVER is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). Which would suggest that the config bean is not being created correctly by my Cold Spring framework and is just full of empty values, or, these values are lost by the time my mailer service tries to use them. I set the bean relationships in my ColdSpring XML file like so. !-- Mail Configuration -- bean id=MailerConfig class=Model.Mailer.MailerConfigBean constructor-arg name=OutgoingServer value***/value /constructor-arg constructor-arg name=Username value**/value /constructor-arg constructor-arg name=Password value/value /constructor-arg constructor-arg name=FromName valueThink Blue Confirmation/value /constructor-arg constructor-arg name=FromAddress value[EMAIL PROTECTED]/value /constructor-arg constructor-arg name=ReplyAddress value[EMAIL PROTECTED]/value /constructor-arg constructor-arg name=FailAddress value[EMAIL PROTECTED]/value /constructor-arg constructor-arg name=SpoolEnable valuetrue/value /constructor-arg /bean !-- Mailing Service -- bean id=MailerService class=Model.Mailer.MailerService constructor-arg name=Config ref bean=MailerConfig/ /constructor-arg /bean Then inside the mailer service I'm creating a reference to the bean in my constructor arguments like this: !--- Class Constructor Method --- cffunction name=init access=public output=false returntype=MailerService hint=I'm the class constructor method cfargument name=Config type=any required=true hint=Configuration for the mailer service / cfscript setMailerConfigBean(ARGUMENTS.Config); /cfscript cfreturn this / /cffunction !--- Set Mailer Config --- cffunction name=setMailerConfigBean access=public output=false returntype=void hint=I set the config cfargument name=MailerConfigBean required=true type=any hint=Instance of the mailer configuration bean / cfscript // Set the mail config VARIABLES.Instance.Config = ARGUMENTS.MailerConfigBean; /cfscript /cffunction Now a quick look at the post function: !--- Post Mail --- cffunction name=post access=public output=false returntype=void hint=I post the mail once its been created cfset var LOCAL = structNew() / cfmail from=#VARIABLES.Instance.Config.getFromAddress()# to=#VARIABLES.Instance.To# subject=#VARIABLES.Instance.Subject# type=html server=#VARIABLES.Instance.Config.getOutgoingServer()# username=#VARIABLES.Instance.Config.getUsername()# password=#VARIABLES.Instance.Config.getPassword()# pContent Goes Here/p /cfmail /cffunction Now, the service is auto wired into my communications controller using the following method: !--- Set Mailer Service --- cffunction name=setMailerService access=public returntype=void output=false hint=Autowire for the mailer service cfargument name=MailerService required=true type=any hint=Instance of the mailer service / cfscript // Set Mailer Service VARIABLES.MailerService = ARGUMENTS.MailerService; /cfscript /cffunction And I then create the message and post it from inside the controller with a simple script within any given function: // If passed validation then process the mail
RE: Returning a user's roles?
I'm using cflogin to authenticate users on a site. Is there a way to return the roles that a user is in (i.e. the roles that are passed in using CFLOGINUSER)? I'm using a very hackish method of looping through all of the roles for a site and using isuserinrole() to determine this, but was hoping that there was a more elegant solution. Apparently not. You'll probably need to put something in the SESSION scope to keep track of that. IsUserInRole() does accept a comma-delimited list of roles, if that helps. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Rounding to 2 decimal places.....
Someone please tell me that this is so simple that I am just missing it. I am trying to round this number - 207.44047619 to 207.44. The only way that I can think to do this would be to roll a custom function. Is there not a 1-2 liner method to do this that I am simply overlooking? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Rounding to 2 decimal places.....
Check cflib.org, I seem to remember there being something on that for this problem. Adrian -Original Message- From: Chris Ditty [mailto:[EMAIL PROTECTED] Sent: 03 April 2007 16:38 To: CF-Talk Subject: Rounding to 2 decimal places. Someone please tell me that this is so simple that I am just missing it. I am trying to round this number - 207.44047619 to 207.44. The only way that I can think to do this would be to roll a custom function. Is there not a 1-2 liner method to do this that I am simply overlooking? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:27 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Rounding to 2 decimal places.....
decimalFormat() http://livedocs.adobe.com/coldfusion/7/htmldocs/0450.htm On 4/3/07, Chris Ditty [EMAIL PROTECTED] wrote: Someone please tell me that this is so simple that I am just missing it. I am trying to round this number - 207.44047619 to 207.44. The only way that I can think to do this would be to roll a custom function. Is there not a 1-2 liner method to do this that I am simply overlooking? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Rounding to 2 decimal places.....
Thanks. That fixed it. I was looking under math functions and didn't think about looking under format. DUH. :) thanks again On 4/3/07, Charlie Griefer [EMAIL PROTECTED] wrote: decimalFormat() http://livedocs.adobe.com/coldfusion/7/htmldocs/0450.htm On 4/3/07, Chris Ditty [EMAIL PROTECTED] wrote: Someone please tell me that this is so simple that I am just missing it. I am trying to round this number - 207.44047619 to 207.44. The only way that I can think to do this would be to roll a custom function. Is there not a 1-2 liner method to do this that I am simply overlooking? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL question
Hmm, MS SQL must do the cast behind the scenes. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 11:00 AM To: CF-Talk Subject: RE: SQL question Thanks Ben, and Joe here is what finally worked for me. dateCreated = '04/03/2007' AND dateCreated DATEADD(DAY, 1, '04/03/2007') With dateCreated = '04/03/2007' AND dateCreated ('04/03/2007' + 1) I get this error: Conversion failed when converting the varchar value '04/03/2007' to data type int. So I probably have to cast as a date in order to get this to work. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(Resend) Application.cfc and cflocation
I'm resending this because I'm not sure it made it to the list. Can somebody confirm that the cflocation in Application.cfc is working fine in CFMX 7.02? In my case it still triggers an onError event, which sends an email and as a result I'm overwhelmed by useless error messages. The user doesn't see anything and the code works as expected ... Thanks Victor -- Forwarded message -- From: Victor Moore [EMAIL PROTECTED] Date: Apr 2, 2007 12:48 PM Subject: Application.cfc and cflocation To: cf-talk@houseoffusion.com Hi, I thought that the error triggered when using cflocation in Application.cfcwas fixed in version 7.01 I'm using 7,0,2,142559 and still have the problem. It was reintroduced in 7.02? do I need to apply a specific fix for it? Thank you Victor ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Rounding to 2 decimal places.....
#round(num * 100) / 100# will do just the math part. I.e. it won't add commas for thousand separators or an extra trailing zero. If you need to round the number and get a number (rather than a display string), this method is preferable. That code is obviously suitable for any number of decimal places, you need to raise 10 to the power of the number of places you want and use it where I've used 100 (which is 10 ^ 2). cheers, barneyb On 4/3/07, Chris Ditty [EMAIL PROTECTED] wrote: Thanks. That fixed it. I was looking under math functions and didn't think about looking under format. DUH. :) thanks again On 4/3/07, Charlie Griefer [EMAIL PROTECTED] wrote: decimalFormat() http://livedocs.adobe.com/coldfusion/7/htmldocs/0450.htm On 4/3/07, Chris Ditty [EMAIL PROTECTED] wrote: Someone please tell me that this is so simple that I am just missing it. I am trying to round this number - 207.44047619 to 207.44. The only way that I can think to do this would be to roll a custom function. Is there not a 1-2 liner method to do this that I am simply overlooking? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (Resend) Application.cfc and cflocation
Victor, I use cflocation in Application.cfc and it works as expected. However I'm using it within onError itself. Don't know if that makes a difference or not, but it does work at least in the onError method. Maybe you could post your code - there might be something else going astray. -- Josh - Original Message - From: Victor Moore [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, April 03, 2007 8:58 AM Subject: (Resend) Application.cfc and cflocation I'm resending this because I'm not sure it made it to the list. Can somebody confirm that the cflocation in Application.cfc is working fine in CFMX 7.02? In my case it still triggers an onError event, which sends an email and as a result I'm overwhelmed by useless error messages. The user doesn't see anything and the code works as expected ... Thanks Victor -- Forwarded message -- From: Victor Moore [EMAIL PROTECTED] Date: Apr 2, 2007 12:48 PM Subject: Application.cfc and cflocation To: cf-talk@houseoffusion.com Hi, I thought that the error triggered when using cflocation in Application.cfcwas fixed in version 7.01 I'm using 7,0,2,142559 and still have the problem. It was reintroduced in 7.02? do I need to apply a specific fix for it? Thank you Victor ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (Resend) Application.cfc and cflocation
Thank Josh, The code is in onRequestStart and it works, I mean it redirects the user, but also triggers onError event. It seems that it was a problem with using cflocation in Application.cfc and was fixed in 7.01, at least this is what I have read on Ray blog. Anyway this is the offending code: cfif cgi.server_port neq 443 cfset newURL = https://; cgi.http_host cgi.path_info cfif len (cgi.query_string) gt 0 cfset newURL = newURL ? cgi.query_string /cfif cflocation url='#newURL#' addtoken=no /cfif The line being reported onError is the line with cflocation Thanks Victor On 4/3/07, Josh Nathanson [EMAIL PROTECTED] wrote: Victor, I use cflocation in Application.cfc and it works as expected. However I'm using it within onError itself. Don't know if that makes a difference or not, but it does work at least in the onError method. Maybe you could post your code - there might be something else going astray. -- Josh -- -- Forwarded message -- From: Victor Moore [EMAIL PROTECTED] Date: Apr 2, 2007 12:48 PM Subject: Application.cfc and cflocation To: cf-talk@houseoffusion.com Hi, I thought that the error triggered when using cflocation in Application.cfcwas fixed in version 7.01 I'm using 7,0,2,142559 and still have the problem. It was reintroduced in 7.02? do I need to apply a specific fix for it? Thank you Victor ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (Resend) Application.cfc and cflocation
The line being reported onError is the line with cflocation What is the error that is being reported? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Rounding to 2 decimal places.....
You can avoid the round function by doing integer division: #num*100\100# #round(num * 100) / 100# will do just the math part. I.e. it won't add commas for thousand separators or an extra trailing zero. If you need to round the number and get a number (rather than a display string), this method is preferable. That code is obviously suitable for any number of decimal places, you need to raise 10 to the power of the number of places you want and use it where I've used 100 (which is 10 ^ 2). cheers, barneyb On 4/3/07, Chris Ditty [EMAIL PROTECTED] wrote: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (Resend) Application.cfc and cflocation
An exception occurred when invoking a event handler method from Application.cfc The method name is: onRequestStart. Event Handler Exception. coldfusion.runtime.AbortException On 4/3/07, Josh Nathanson [EMAIL PROTECTED] wrote: The line being reported onError is the line with cflocation What is the error that is being reported? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFX_XMLParser in MX 7.02
Probably, there is no real reason to have a tag like this on MX as all the XML stuff is, as you noted, out of the box. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: James Buckingham To: CF-Talk Sent: Tue Apr 03 16:13:06 2007 Subject: CFX_XMLParser in MX 7.02 I noticed on the Activsoftware website that this Custom Tag isn't supported in MX7 and that the installation instructions don't cover multiserver environments. Has anybody installed this on MX7 and how did they get on with it? Is there actually any issues with using it or is it just a case that MX7 now has all the tools natively to do the same job so AS have dropped it? Cheers, James ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Rounding to 2 decimal places.....
That will truncate, leaving you with zero decimal places, not two. This expression: #((num * 100) \ 1) / 100# will do as you want, but it has the effect of truncating at two decimal places, rather than rouding to two decimal places. E.g., 123.4567 will become 123.45, rather than the desired 123.46. Not to mention the fact that the round() call is much more readable. cheers, barneyb On 4/3/07, Peter Boughton [EMAIL PROTECTED] wrote: You can avoid the round function by doing integer division: #num*100\100# #round(num * 100) / 100# will do just the math part. I.e. it won't add commas for thousand separators or an extra trailing zero. If you need to round the number and get a number (rather than a display string), this method is preferable. That code is obviously suitable for any number of decimal places, you need to raise 10 to the power of the number of places you want and use it where I've used 100 (which is 10 ^ 2). cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Rounding to 2 decimal places.....
Wait - ignore me, I'm going crazy. That doesn't work. :$ You can avoid the round function by doing integer division: #num*100\100# ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274457 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Socket Connections
Ok I know this is possible with java so it's possible in CF but what I can't find is a good resource which talks about the how-to's and why would you of socket connections. People around here have been mentioning using a socket connection to get some data from a service (yea it's that vague) and php's fopen has been thrown out there. Any resources to help me out would be mighty appreciated. ---_ Eric R. Jones Senior Web Application Developer, AFNOC/NCD Barksdale AFB, LA DSN 781-7784 Comm (318) 456-7784 NIPRNET: [EMAIL PROTECTED] SIPRNET: [EMAIL PROTECTED] ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (Resend) Application.cfc and cflocation
H...interesting. There is something going on there in the guts of the method that doesn't like cflocation in onRequestStart. Perhaps it's because there is the potential there for an infinite loop. Maybe someone with a better understanding of what's going on under the hood can help you out. Sorry I can't be of more help. -- Josh - Original Message - From: Victor Moore [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, April 03, 2007 9:53 AM Subject: Re: (Resend) Application.cfc and cflocation An exception occurred when invoking a event handler method from Application.cfc The method name is: onRequestStart. Event Handler Exception. coldfusion.runtime.AbortException On 4/3/07, Josh Nathanson [EMAIL PROTECTED] wrote: The line being reported onError is the line with cflocation What is the error that is being reported? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Socket Connections
I did some stuff sockets to get my ColdFusion Exchange stuff working. Basically, when you need to manipulate things at the telnet level sockets are your only options. I would have preferred to use CFX_socket, which handled all of this stuff, but it stopped working for me a while back. There's not much out there, for this, I basically took Java socket tutorials, and kept trying stuff and trying stuff until I got it to work. Here's a https socket function I wrote. !--- *** --- !--- https_socket--- !--- Allows socket communication over https to occur.--- !--- *** --- cffunction access=private name=https_socket output=true returntype=string hint=Allows socket communication over https to occur. cfargument name=host type=string required=yes hint=The host to send message to. cfargument name=message type=string required=yes hint=The message to send to the host. cfargument name=port type=numeric required=no default=443 hint=The port to connect to. cfset var factory= cfset var sock= cfset var sout= cfset var out= cfset var sinput= cfset var inputStreamReader= cfset var input= cfset var results= !--- Use the sslfactory to create an object based on the Socket class --- cfset factory=CreateObject(java,javax.net.ssl.SSLSocketFactory).getDefault() cfset sock=factory.createSocket(arguments.host,arguments.port) cfset sock.startHandshake() !--- Connect to output stream --- cfset sout = sock.getOutputStream() !--- Connect to input stream --- cfset out = createObject(java, java.io.PrintWriter).init(sout) cfset sinput = sock.getInputStream() !--- I have no clue what is going here. I just know it has to be done this way. --- cfset inputStreamReader= createObject( java, java.io.InputStreamReader).init(sinput) cfset input = createObject( java, java.io.BufferedReader).init(InputStreamReader) !--- Send message to server. --- cfset out.println(#arguments.message#) cfset out.println() cfset out.flush() cfset results=input.readLine() cfset sock.close() cfreturn results /cffunction Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (Resend) Application.cfc and cflocation
An exception occurred when invoking a event handler method from Application.cfc The method name is: onRequestStart. Event Handler Exception. coldfusion.runtime.AbortException Actually, that looks like a perfectly valid exception to throw, I guess. I don't know anything about whether it was supposed to have been fixed, but why not just catch it in your onError and discard it silently? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another Subversion Question
On 4/2/07, Zaphod Beeblebrox [EMAIL PROTECTED] wrote: Hmmm...I was thinking svn:externals was more for your working copy. With SVK, I set up a mirror of Rays svn in my svn (svk calls it a depot). Then I tell it to sync to my /trunk . Then I tell it to copy from /trunk to /local. Now, whenever I want to make changes to it, I check out the local version, I can make all the changes that I want to and I can also update the trunk version from Ray's. At any point I can diff or smerge my version and Rays. Hey, that sounds pretty sweet! I'll have to check it out, I hadn't heard of it (or had thought it was something else... another SVN client, which it ain't). externals are for more than your working copy- I think of them as SVN's symlink. That's basically what externals are. As Barney B says, any changes you make, if you want to commit them, would go to the remote repository location. So SVK sounds like exactly what you'd want to use if you wanted to keep track of your changes in another repository than the one you got the code from. The way I do it, is: /blogcfc = an external from his repository /myblog = export of blogcfc which I modified Make some changes to myblog... Then I teamexport myblog into blogcfc, which copies everything (but without any version information (no .svn dirs)) into /blogcfc. Then, since I cannot commit to the blogcfc repository (wouldn't want to, either. My stuff is separate), but I *do* want others to be able to get my changes, I'll run a teamcreate patch, which will make a single diff file containing any changes to the blogcfc source. Thus, I can send that patch file to anyone who has the original source checked out, and they can apply it, and boom, they're in like flynn. Course, they neither can commit to blogcfc core code, so they'd have to do the same thing as me- once they patched their copy of the original blogcfc code, they'd have to teamexport it into another location to be managed by their own repository. Great for one-off type stuff, but probably more work than SVK? Eh. I like how SVK can use different kinds of Source Control... that's pimp. Yeah, that's a swell idea. Hmm... eh. Later, I'll check it out... ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Subversion questions
On 4/3/07, Tom C wrote: On Tuesday 03 Apr 2007, Dinner wrote: As always, the PITA of linking or sharing components is that you gotta really test everything that uses that component whenever you make a change to it. It's harder to stage roll-outs when code is shared, and Not really - remember you can peg an svn:externals to a particular revision. Indeed! I'd forgotten that part. It's what I do for MG:U w/ production stuff... Looks like we're all going! ('cept fer dirt... doesn't look like he recovered ;) *** Hmmm... glad my clock setting didn't go unnoticed. (And stop holding your breath, Dave! (you saw the RSN, right?) :-) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Rounding to 2 decimal places.....
You could do numberFormat(varName, 0.00) also Chris -Original Message- From: Chris Ditty [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 11:53 AM To: CF-Talk Subject: Re: Rounding to 2 decimal places. Thanks. That fixed it. I was looking under math functions and didn't think about looking under format. DUH. :) thanks again On 4/3/07, Charlie Griefer [EMAIL PROTECTED] wrote: decimalFormat() http://livedocs.adobe.com/coldfusion/7/htmldocs/0450.htm On 4/3/07, Chris Ditty [EMAIL PROTECTED] wrote: Someone please tell me that this is so simple that I am just missing it. I am trying to round this number - 207.44047619 to 207.44. The only way that I can think to do this would be to roll a custom function. Is there not a 1-2 liner method to do this that I am simply overlooking? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XmlTransform public dtd issue
Hello, I am new to Cold Fusion. I am using XmlTransform, to convert xml to html. My xml uses public doctype for dtd declaration. Now when i run the the application from the curre nt it looks for the dtd in coldfuison runtime/bin folder always and not in the current folder. Please suggest Regards, Ruchi - Heres a new way to find what you're looking for - Yahoo! Answers ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Rounding to 2 decimal places.....
Yeah, dunno what I was thinking there. Not sure if I actually woke up this morning; I've been doing similar things through-out today. :( That will truncate, leaving you with zero decimal places, not two. This expression: #((num * 100) \ 1) / 100# will do as you want, but it has the effect of truncating at two decimal places, rather than rouding to two decimal places. E.g., 123.4567 will become 123.45, rather than the desired 123.46. Not to mention the fact that the round() call is much more readable. cheers, barneyb On 4/3/07, Peter Boughton [EMAIL PROTECTED] wrote: -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Offline Application like Apollo
All, Our company is planning a nationwide photo contest (for kids) and we're partnering with a large get your professional photos in the mall store from chain. The store front chain has computers at each location, but they do not have internet connectivity. Has anyone every built an app that would work as a stand alone app, then when they are done, they could send us the files on disk with all the user information associated in the database? I was thinking two scenarious. Use Access and build the front end ini Access. Or have them install the developer's edition with a Access file, but I think that would be overkill. Any ideas on how this could be done? Thanks. D ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274467 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (Resend) Application.cfc and cflocation
coldfusion.runtime.AbortException suggests the execution of a CFABORT tag somewhere. I'm guessing you forgot about a CFABORT tag during development - probably on your include page. Now in our shop, we occasionally throw cfaborts for valid reasons (like a user trying to access a protected area). So in our onError function, we pitch these errors right out the window: cfif structkeyexists(arguments.exception,'rootCause') and arguments.exception.rootCause.Type EQ coldfusion.runtime.AbortException cfreturn / /cfif Hope that helps... Jake Pilgrim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Offline Application like Apollo
You couldn't use developers edition it would be a violation of the license, they would need a license for each and every machine the application is running on. Access is also a horrible method of doing something like this. I'm not sure how VBA forms handle file interactions, but what VBA experience I do have has left me scarred and crying in the corner :) You would most likely want a standalone desktop application written in C# or Java that has export capabilities, however, if it were me I would fight with them about getting internet connectivity, I mean if this is really a national chain the money shouldn't be prohibitive, and they can get all kinds of other benefits out of it. Finally, you mentioned Apollo in your subject, have you taken a look at the Apollo beta at: http://labs.adobe.com/technologies/apollo/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 2:38 PM To: CF-Talk Subject: CF Offline Application like Apollo All, Our company is planning a nationwide photo contest (for kids) and we're partnering with a large get your professional photos in the mall store from chain. The store front chain has computers at each location, but they do not have internet connectivity. Has anyone every built an app that would work as a stand alone app, then when they are done, they could send us the files on disk with all the user information associated in the database? I was thinking two scenarious. Use Access and build the front end ini Access. Or have them install the developer's edition with a Access file, but I think that would be overkill. Any ideas on how this could be done? Thanks. D ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Returning a user's roles?
Just don't forget that isUserInRole() is an AND check. If you want an OR check, you need to use a UDF. (I believe I posted one to cflib.) On 4/3/07, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED] wrote: I'm using cflogin to authenticate users on a site. Is there a way to return the roles that a user is in (i.e. the roles that are passed in using CFLOGINUSER)? I'm using a very hackish method of looping through all of the roles for a site and using isuserinrole() to determine this, but was hoping that there was a more elegant solution. Apparently not. You'll probably need to put something in the SESSION scope to keep track of that. IsUserInRole() does accept a comma-delimited list of roles, if that helps. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Offline Application like Apollo
I built a demo app in Apollo. Pretty simple really but was a feat for me since I didn't know Flex either. I blogged about it and have all the code available for download at http://jake.cfwebtools.com/index.cfm/2007/4/2/My-First-Apollo-Project Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 [EMAIL PROTECTED] wrote: All, Our company is planning a nationwide photo contest (for kids) and we're partnering with a large get your professional photos in the mall store from chain. The store front chain has computers at each location, but they do not have internet connectivity. Has anyone every built an app that would work as a stand alone app, then when they are done, they could send us the files on disk with all the user information associated in the database? I was thinking two scenarious. Use Access and build the front end ini Access. Or have them install the developer's edition with a Access file, but I think that would be overkill. Any ideas on how this could be done? Thanks. D ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (Resend) Application.cfc and cflocation
Well, according to this, it should be fixed: http://ray.camdenfamily.com/index.cfm/2005/9/28/Two-Nice-Fixes-in-ColdFusion-701 I guess it was one of those bugs that was not acknowledged, then fixed and now re-appeared. I took Dave's suggestion and it works OK for now. Thanks Victor On 4/3/07, Dave Watts [EMAIL PROTECTED] wrote: An exception occurred when invoking a event handler method from Application.cfc The method name is: onRequestStart. Event Handler Exception. coldfusion.runtime.AbortException Actually, that looks like a perfectly valid exception to throw, I guess. I don't know anything about whether it was supposed to have been fixed, but why not just catch it in your onError and discard it silently? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The document is not open.
Hi folks, I know I've seen this posted before, but it wasn't responded to (that I could find), so I'll post it again. I'm using CFX_PDF from the folks at easel2.com. The Powers-That-Be are too cheap to get CF7 right now, and they might as well wait for Scorpio if they're gonna upgrade, so I'm kinda stuck with CFX_PDF for the time being. Anyway, for some reason every once in a while one or more of our reports will generate the error: The document is not open. The error occurred in C:\Inetpub\wwwroot\CFX_PDF\pdf.cfm: line 48 Called from... etc., etc. Does anyone know why this happens? It's strange, if I run a report for 04/01 of this year the thing runs fine, but if I run the same report for 04/03, then I get this error. I'd love some help trying to track down an answer to this problem. It's got me stumped. Thanks, Chris -- http://www.cjordan.us ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Offline Application like Apollo
You could do all of the processing then save data in a CSV format or something. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 1:38 PM To: CF-Talk Subject: CF Offline Application like Apollo All, Our company is planning a nationwide photo contest (for kids) and we're partnering with a large get your professional photos in the mall store from chain. The store front chain has computers at each location, but they do not have internet connectivity. Has anyone every built an app that would work as a stand alone app, then when they are done, they could send us the files on disk with all the user information associated in the database? I was thinking two scenarious. Use Access and build the front end ini Access. Or have them install the developer's edition with a Access file, but I think that would be overkill. Any ideas on how this could be done? Thanks. D ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
chart images distorted when creating PDF
When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Help
Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: chart images distorted when creating PDF
Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Help - Answered
Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Help - Answered
No problem, if you want to know why take a look at aggregate functions, which is what count is, as well as others.. On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help - Answered
I'm going to have to look at something. I'm still not getting what I anticipated. There are over 3700 records of which 1775 of them are distinct values for RATE. However, I am only getting values of 1 for COUNT(DISTINCT rate) as rateCount. I was trying to find out how many records are there for each distinct value in the RATE field. I need to chart how many records there are for each value in RATE. Thanks for the help. Greg Morphis wrote: No problem, if you want to know why take a look at aggregate functions, which is what count is, as well as others.. On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help - Answered
can you provide a sample of your data and the way your table is designed (column name, type)? Thanks On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I'm going to have to look at something. I'm still not getting what I anticipated. There are over 3700 records of which 1775 of them are distinct values for RATE. However, I am only getting values of 1 for COUNT(DISTINCT rate) as rateCount. I was trying to find out how many records are there for each distinct value in the RATE field. I need to chart how many records there are for each value in RATE. Thanks for the help. Greg Morphis wrote: No problem, if you want to know why take a look at aggregate functions, which is what count is, as well as others.. On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help - Answered
I don't think you need DISTINCT at all if you are using GROUP BY. GROUP BY will group all the matching rate values together automatically, so the result will be all distinct values. Try something like (not tested) SELECT Count(rate) as ratecount, rate FROM myrates etc. GROUP BY rate Dump that and see if you're any closer to what you want. -- Josh - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, April 03, 2007 2:09 PM Subject: Re: SQL Help - Answered I'm going to have to look at something. I'm still not getting what I anticipated. There are over 3700 records of which 1775 of them are distinct values for RATE. However, I am only getting values of 1 for COUNT(DISTINCT rate) as rateCount. I was trying to find out how many records are there for each distinct value in the RATE field. I need to chart how many records there are for each value in RATE. Thanks for the help. Greg Morphis wrote: No problem, if you want to know why take a look at aggregate functions, which is what count is, as well as others.. On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any trouble on the updgrade? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:01 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any trouble on the updgrade? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:01 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274486 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
I don't know where to tell you to begin. I'd hate to steer you wrong. I think I would check the JVM.config file to make sure the a Java arguments are syntactically correct. They can get screwed up I'll do a little googling for you before I leave from the office. Can you tell me exacly what you upgraded. Where you just running the Update 1? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any trouble on the updgrade? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:01 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274487 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: chart images distorted when creating PDF
Ok... Here's something to check. Make sure that windows security has not enabled the windows native firewall. If it has disable it. According to this fellow: http://info4tech.wordpress.com/tag/network-administration/ A security patch that enabled the firewall caused his server to fail - probably because the internal port needed for the jrun connector was no longer enabled. Along that lines you can check security in general. Open the security control panel. Is the service set to an account or is it set to use the local system account. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any trouble on the updgrade? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:01 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: chart images distorted when creating PDF
Rafael, Why don't you post the contents of the /runtime/bin/jvm.config file. It might have a clue or 2. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any trouble on the updgrade? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:01 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Thanks for your reply. I went and downloaded the update, I installed it and now the pits! MX will not start! Now it says in the log file: Unable to initialize Event service: coldfusion.server.ServiceException I am freaking out!!! Please help. RM -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 4:54 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Are you running the latest update for CF7? There were some issues with embedding images in PDFs in early versions of 7. On 4/3/07, Rafael Marquez [EMAIL PROTECTED] wrote: When creating a pdf using cfdocument the chart images in the document randomly appear distorted and large. It is inconsistant. Sometimes one image is bad. Other times multiple images are bad. While other times it looks fine. Any help? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274489 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: chart images distorted when creating PDF
Rafael, Here's a post on how the jvm.config file can get corrupted... And how to fix it. http://www.talkingtree.com/blog/index.cfm/2006/4/7/CFAdmin-problems-when-edi ting-JVM-settings Pete is a certified java genius :) -mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274490 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
Mark: This is my jvm.config: - # # VM configuration # # Where to find JVM, if {java.home}/jre exists then that JVM is used # if not then it must be the path to the JRE itself java.home=C:/CFusionMX7/runtime/jre # # If no java.home is specified a VM is located by looking in these places in this # order: # # 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix) # 2) ../jre # 3) registry (windows only) # 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre) # # Arguments to VM java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../../classes,{application.home}/. ../lib/updates,{application.home}/../lib/,{application.home}/../gateway/lib/, {application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\\CustomTags \\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar # # commas will be converted to platform specific separator and the result will be passed # as -Djava.ext.dirs= to the VM java.ext.dirs={jre.home}/lib/ext # # where to find shared libraries java.library.path={application.home}/../lib,{application.home}/../jintegra/b in,{application.home}/../jintegra/bin/international system.path.first=false # # set the current working directory - useful for Windows to control # the default search path used when loading DLLs since it comes # before system directory, windows directory and PATH java.user.dir={application.home}/../../lib # JVM classpath java.class.path={application.home}/servers/lib,{application.home}/../lib/mac romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar,{application.home} /lib - it doesn't look wrong... -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:29 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Why don't you post the contents of the /runtime/bin/jvm.config file. It might have a clue or 2. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any trouble on the updgrade? -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:01 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Thanks for your reply. I went and downloaded the update, I
RE: chart images distorted when creating PDF
Rafael, Do you see a line at the top that says: java.home=C:/CFusionMX7/runtime/jre -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:49 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: This is my jvm.config: - # # VM configuration # # Where to find JVM, if {java.home}/jre exists then that JVM is used # if not then it must be the path to the JRE itself java.home=C:/CFusionMX7/runtime/jre # # If no java.home is specified a VM is located by looking in these places in this # order: # # 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix) # 2) ../jre # 3) registry (windows only) # 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre) # # Arguments to VM java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../../classes,{application.home}/. .../lib/updates,{application.home}/../lib/,{application.home}/../gateway/lib/ , {application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\\CustomTags \\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar # # commas will be converted to platform specific separator and the result will be passed # as -Djava.ext.dirs= to the VM java.ext.dirs={jre.home}/lib/ext # # where to find shared libraries java.library.path={application.home}/../lib,{application.home}/../jintegra/b in,{application.home}/../jintegra/bin/international system.path.first=false # # set the current working directory - useful for Windows to control # the default search path used when loading DLLs since it comes # before system directory, windows directory and PATH java.user.dir={application.home}/../../lib # JVM classpath java.class.path={application.home}/servers/lib,{application.home}/../lib/mac romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar,{application.home} /lib - it doesn't look wrong... -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:29 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Why don't you post the contents of the /runtime/bin/jvm.config file. It might have a clue or 2. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the exception occurred. Did you back up the cfusionmx7 directory befor beginning. Did you have any
Re: chart images distorted when creating PDF
Rafael, If you installed the hotfix by uploading the .jar through the CFAdmin, you can revert by deleting (or moving) the .jar file. On a windows machine this is usually located at: C:\CFusionMX7\lib\updates I had a similar problem with the charting hotfix when I installed it, but it wasn't a critical update for me so I skipped trying it again until the next cumulative hotfix. Once you delete the file, you should be able to restart and go. HTH, Jon On Apr 3, 2007, at 6:49 PM, Rafael Marquez wrote: Mark: This is my jvm.config: - # # VM configuration # # Where to find JVM, if {java.home}/jre exists then that JVM is used # if not then it must be the path to the JRE itself java.home=C:/CFusionMX7/runtime/jre # # If no java.home is specified a VM is located by looking in these places in this # order: # # 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix) # 2) ../jre # 3) registry (windows only) # 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre) # # Arguments to VM java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS - Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../../classes, {application.home}/. ../lib/updates,{application.home}/../lib/,{application.home}/../ gateway/lib/, {application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\ \CustomTags \\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar # # commas will be converted to platform specific separator and the result will be passed # as -Djava.ext.dirs= to the VM java.ext.dirs={jre.home}/lib/ext # # where to find shared libraries java.library.path={application.home}/../lib,{application.home}/../ jintegra/b in,{application.home}/../jintegra/bin/international system.path.first=false # # set the current working directory - useful for Windows to control # the default search path used when loading DLLs since it comes # before system directory, windows directory and PATH java.user.dir={application.home}/../../lib # JVM classpath java.class.path={application.home}/servers/lib, {application.home}/../lib/mac romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar, {application.home} /lib - it doesn't look wrong... -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:29 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Why don't you post the contents of the /runtime/bin/jvm.config file. It might have a clue or 2. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds)
RE: chart images distorted when creating PDF
Mark: Yes, it's right there in red R -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:49 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: This is my jvm.config: - # # VM configuration # # Where to find JVM, if {java.home}/jre exists then that JVM is used # if not then it must be the path to the JRE itself java.home=C:/CFusionMX7/runtime/jre # # If no java.home is specified a VM is located by looking in these places in this # order: # # 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix) # 2) ../jre # 3) registry (windows only) # 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre) # # Arguments to VM java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../../classes,{application.home}/. /lib/updates,{application.home}/../lib/,{application.home}/../gateway/lib / , {application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\\CustomTags \\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar # # commas will be converted to platform specific separator and the result will be passed # as -Djava.ext.dirs= to the VM java.ext.dirs={jre.home}/lib/ext # # where to find shared libraries java.library.path={application.home}/../lib,{application.home}/../jintegra/b in,{application.home}/../jintegra/bin/international system.path.first=false # # set the current working directory - useful for Windows to control # the default search path used when loading DLLs since it comes # before system directory, windows directory and PATH java.user.dir={application.home}/../../lib # JVM classpath java.class.path={application.home}/servers/lib,{application.home}/../lib/mac romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar,{application.home} /lib - it doesn't look wrong... -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:29 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Why don't you post the contents of the /runtime/bin/jvm.config file. It might have a clue or 2. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFFormGateway: init 04/03 18:07:28 user failed to load: flashgateway.controller.GatewayServlet 04/03 18:07:28 user CFInternalServlet: init Server coldfusion ready (startup time: 7 seconds) -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:08 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Is there a message in the /runtime/logs/ directoryin the *.out file It should show the startup progress and may show where the
WSE Security - anyone have any experience with it?
My client has asked for advice on what the ramifications might be for his site if he shares content with another company who uses WSE Security. The content will require secure access - there's dollars being passed back and forth - and this other company is a .net site, and they use WSE security. So .. now II have to bone up on what it means for a CF7.0.2 enterprise/Win2003 environment. Can anyone point me at any resources so I can learn about it. preferably not anything from Microsoft I have the greatest difficulty learning anything from their documentation. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: chart images distorted when creating PDF
Thanks! I can breathe again! I still have the issue with the broken chart images, though.. How did you fix that problem? RM -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 7:00 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Rafael, If you installed the hotfix by uploading the .jar through the CFAdmin, you can revert by deleting (or moving) the .jar file. On a windows machine this is usually located at: C:\CFusionMX7\lib\updates I had a similar problem with the charting hotfix when I installed it, but it wasn't a critical update for me so I skipped trying it again until the next cumulative hotfix. Once you delete the file, you should be able to restart and go. HTH, Jon On Apr 3, 2007, at 6:49 PM, Rafael Marquez wrote: Mark: This is my jvm.config: - # # VM configuration # # Where to find JVM, if {java.home}/jre exists then that JVM is used # if not then it must be the path to the JRE itself java.home=C:/CFusionMX7/runtime/jre # # If no java.home is specified a VM is located by looking in these places in this # order: # # 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix) # 2) ../jre # 3) registry (windows only) # 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre) # # Arguments to VM java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS - Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../../classes, {application.home}/. ../lib/updates,{application.home}/../lib/,{application.home}/../ gateway/lib/, {application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\ \CustomTags \\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar # # commas will be converted to platform specific separator and the result will be passed # as -Djava.ext.dirs= to the VM java.ext.dirs={jre.home}/lib/ext # # where to find shared libraries java.library.path={application.home}/../lib,{application.home}/../ jintegra/b in,{application.home}/../jintegra/bin/international system.path.first=false # # set the current working directory - useful for Windows to control # the default search path used when loading DLLs since it comes # before system directory, windows directory and PATH java.user.dir={application.home}/../../lib # JVM classpath java.class.path={application.home}/servers/lib, {application.home}/../lib/mac romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar, {application.home} /lib - it doesn't look wrong... -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:29 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Why don't you post the contents of the /runtime/bin/jvm.config file. It might have a clue or 2. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user CFMxmlServlet: init 04/03 18:07:27 INFO Macromedia Flex Build: 87315.134646 04/03 18:07:27 user CFMxmlServlet: Macromedia Flex Build: 87315.134646 04/03 18:07:28 user ColdFusionStartUpServlet: init 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 04/03 18:07:28 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2_05-b04 04/03 18:07:28 user failed to load: coldfusion.server.j2ee.CFStartUpServlet 04/03 18:07:28 user CFSwfServlet: init 04/03 18:07:28 user CFCServlet: init 04/03 18:07:28 user FlashGateway: init 04/03
RE: WSE Security - anyone have any experience with it?
My client has asked for advice on what the ramifications might be for his site if he shares content with another company who uses WSE Security. The content will require secure access - there's dollars being passed back and forth - and this other company is a .net site, and they use WSE security. So .. now II have to bone up on what it means for a CF7.0.2 enterprise/Win2003 environment. CF doesn't support WS-Security directly, so you'll have to write Java code to make this happen. Google ws security axis for more information - Apache Axis is the Java library that CF uses for web services. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274497 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mailer Service Bean Issues (MG and CS)
On 4/3/07, Robert R wrote: You'll have to excuse me a little on this one guys, there's a fair amount of code involved as I'm unsure as to where the error is occurring. Looked fine to me, with a cursory glance. Have you just plain cfdumpedcfaborted at each stage along the way, as a sorta sanity check from one bit to the next? I find that straightforward and brutal method to work well in most cases. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4