cfquery timeout doesn't work out on jdbc driver
Hi All, I have a situation here where cfquery doesn't seem to be performing well on jdbc driver, when I read in forums it was clearly mentioned that cfquery timeout doesn't support some drivers, Is there any another alternate to this. My requirement is no matter what happens, if query is not responding in given amount of time then it should timeout.Can anyone suggest a good advice. Thanks, Vamsi ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Rather big log
You may also need to delete the client key. It could be that the Registry is full and new entries are not able to be written. If you switch to something else (DB or cookie), the CF routine that handles purging will still attempt to clear out these variables. If you do decide to clear navigate to HCLM/software/macromedia/ColdFusion/currentversion/ and right click on clients and choose delete. I recommend that you do not try to expand the clients key. If you do you might as well go for a cup of coffee :) Of course it could be that someone has altered permissions for writing to the registry (that's a common method of preventing client vars that I've heard recommended) - in which case simply switching to something else will do the trick. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Wednesday, October 07, 2009 11:49 PM To: cf-talk Subject: RE: Rather big log I'm guessing the way to solve that would be to stop using the registry to store client variables. I recommend a database-- but if you must, cookies would still be a better option than registry. If you're also having the same problem with your logs not rolling over, check out this link from the original post on CF-Talk. http://www.succor.co.uk/index.cfm/2006/5/2/Massive-CFJrun-log-files http://www.adobe.com/go/24039877 ~Brad Original Message Subject: Re: Rather big log From: Jeff Gould jgo...@princetonol.com Date: Wed, October 07, 2009 10:51 pm To: cf-talk cf-talk@houseoffusion.com Ooooh dear. I just checked in C:\CFusionMX7\runtime\logs\ and the coldfusion-out.log is a whopping 500MB. It is packed to the rafters with nearly 2 million lines like these: 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\ Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\urltoken: Gareth, I am having the same problem. Do you remember what you did to resolve this? Thanks. Jeff ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 5 scheduler going wild
Hi, I've been using the same coldFusion 5 server for about 9 years with no problem. Suddenly the scheduler started acting crazy: all task are reexecuted every 2 min. starting at 00:00. It happened twice in a couple of weeks. Any one ever seen such an issue? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion 9 and XAMPP
Every once in a while the connector will flake out and mess up the Apache config file (I think). I am not sure what happens, I have never looked. Generally I just run the server connector again and what ever problem that was happning fixes itself. I have been using XAMPP for years (countless installs) and have never ran into fubar situation. I just installed CF 9 with XAMPP. What I do when doing a fresh install of CF with XAMPP: 1) Unzip XAMPP and run the setup_xampp.bat 2) back up the httpd.conf in xampp\apache\conf\ 3) install CF and run the connector during install If something screws up I restore the httpd.conf and run the server connector again This generally works every time. Like Brad menationed, if you still run into problems I would take a look at the log files in xampp\apache\logs\ btw: CF should make a back up of httpd.conf but I make back ups just in case. HTH G On Wed, Oct 7, 2009 at 9:16 PM, Mike Little m...@nzsolutions.co.nz wrote: hmmm... used httpd.exe - apache will now not start. i can't see how the cf9 install would cause this? mike have removed the server connector and apached now works. not sure where to go from here - should i try another binary path istead of bin\httpd.exe ?? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Javascript error in Firefox
Hi,
I am having a javascript, that works in IE and not in firefox. I always get the
error as below.
Error: changeTextSize is not defined
Source File: javascript:changeTextSize(-1);
Line: 1
Error: changeTextSize is not defined
Source File: javascript:changeTextSize(1);
Line: 1
This is the piece of code
script type=text/javascript
src=http://localhost/scripts/js/js_textresize.js;/script
lispanChange font size a href=javascript:changeTextSize(-1);span
title=Reduce Text Size class=font_size_minusnbsp;/span/a a
href=javascript:changeTextSize(1);span title=Enlarge Text Size
class=font_size_plusnbsp;/span/a/span/li
The changeTextSize function is within the js_textresize.js file.
function changeTextSize(offset) {
currentSize = currentSize + offset;
if (currentSize = sizes.length) {
currentSize = sizes.length - 1;
}
if (currentSize 0) { // don't underflow the sizes array
currentSize = 0;
}
if (document.styleSheets[0].cssRules) { // Mozilla
if (document.styleSheets[0].cssRules[0]) {
setStyleMozilla(divStr);
}
}
else if (document.styleSheets[0].rules) { // IE
setStyleIE(divStr);
}
else { // do nothing for unrecognized browsers
}
document.cookie = 'textSize='+ currentSize + '; path=/; domain=' +
sessionCookieDomain;
}
Can anyone please help on this?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327032
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: remote windows file manager
On Monday 05 Oct 2009, Rick Root wrote: CFFM allows you to upload a zip file then unzip it on the server.. but to upload a a whole directory without zip/unzip? I've never seen anything that does that, at least not web-based. No, you'd have to be able to enumerate the users file system, which browsers are not going to let you do. AIR would let you do it, but as you say, it's not web based. -- Helping to continually bully low-risk initiatives as part of the IT team of the year, '09 and '08 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. 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 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery timeout doesn't work out on jdbc driver
How about installing SeeFusion and enabling one of its rules to kill threads that run for a certain about of time? If there is a running query it will kill it. It may be a hammer where you wanted a scalpel, but it would work. Since requests who area waiting for external I/O can't monitor themselves, often the only way to ensure such a timeout is with a second monitor thread. ~Brad Original Message Subject: cfquery timeout doesn't work out on jdbc driver From: Vamsi Pappu vissu.va...@gmail.com Date: Thu, October 08, 2009 7:47 am To: cf-talk cf-talk@houseoffusion.com My requirement is no matter what happens, if query is not responding in given amount of time then it should timeout.Can anyone suggest a good advice. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: remote windows file manager
The only times I've seen this done before involved an Active X control that the user was required to install with the usual browser security warnings and such. That may work, but you are adding complexity and removing portability. ~Brad Original Message Subject: Re: remote windows file manager From: Tom Chiverton tom.chiver...@halliwells.com Date: Thu, October 08, 2009 10:38 am To: cf-talk cf-talk@houseoffusion.com On Monday 05 Oct 2009, Rick Root wrote: CFFM allows you to upload a zip file then unzip it on the server.. but to upload a a whole directory without zip/unzip? I've never seen anything that does that, at least not web-based. No, you'd have to be able to enumerate the users file system, which browsers are not going to let you do. AIR would let you do it, but as you say, it's not web based. -- ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327035 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery timeout doesn't work out on jdbc driver
Run it in a thread with CFthread and put a timeout on the cfjoin. Adam On Thu, Oct 8, 2009 at 8:47 AM, Vamsi Pappu vissu.va...@gmail.com wrote: Hi All, I have a situation here where cfquery doesn't seem to be performing well on jdbc driver, when I read in forums it was clearly mentioned that cfquery timeout doesn't support some drivers, Is there any another alternate to this. My requirement is no matter what happens, if query is not responding in given amount of time then it should timeout.Can anyone suggest a good advice. Thanks, Vamsi ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327036 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 load times on VPS
Much appreciated. I'll bring a few of these issues up with KA but at this
point the answers they provide will be purely informational. I was
simultaneously testing my site with a HostMySite VPS and the performance was
better for my application. I have kept that server and it's fantastic so
far. Thanks again.
Chip
On Wed, Oct 7, 2009 at 5:43 PM, Mark Kruger mkru...@cfwebtools.com wrote:
Chip,
As Jordan pointed out much of the stuff to check will be up to your NOC
support guys. Here's things that come to the top of my head.
Sometimes hosts use virtual network to isolate your system from other
systems in the same data center or on the same rack. In that case the
connection is going through VPN protocols which can incur overhead. In
addition, DNS comes into play if you are using a FQDN (your machine has to
look it up). Note: If you use an IP address your stack will actually look
up
the Reverse address :)
You could be running into inside/outside firewall behavior where your
traffic is hitting the firewall which routes it back to the other box -
making the inside interface of the firewall a possible bottleneck. You
could also be running afoul of NIC capacity on the VPS - which shares it's
overall capacity with N number of VPS on the same box. Of course if the 2
servers are in different locations you might be onto something with the hop
count or total number of interfaces that examine the packets en route. And
further up the stack (as Jared mentioned) are drivers, driver settings,
connection pooling etc.
That's all I can think of.
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Chip Beck [mailto:chipb...@gmail.com]
Sent: Wednesday, October 07, 2009 4:22 PM
To: cf-talk
Subject: Re: CF load times on VPS
Thanks to everyone for the responses. I wanted to respond in case any other
novices to dedicated machines run into the same issue. After debugging, I
realized the performance issue was in the database query time. As MySQL was
being run on a separate box, for whatever reason the connection between my
VPS and the database-hosting box was not as fast as the connection between
my shared host and the MySQL database it was querying. Was this because of
physical distance between boxes? Maybe they were housed in different
locations? What are the major factors that contribute to the speed at which
CF talks to MySQL or any database for that matter?
On Wed, Sep 16, 2009 at 12:29 PM, Jordan Michaels
jor...@viviotech.netwrote:
+1
The debugging information is what you need to get your hands on here.
I'm not familiar with how KA's setup is, but if you have access to the
CF Admin you can just turn it on from there, hit your page, and
debugging info will show up at the bottom. That should provide some
real insight as to what's causing the hang-up.
Sending this question to KAVPS Support may also be a good idea. They
would be most familiar with their VPS's and maybe they've run into
this problem before.
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Open BlueDragon Steering Committee
Adobe Solution Provider
b...@bradwood.com wrote:
Can you turn on debugging, or better yet, install SeeFusion on both
servers? Then it's a simple matter of looking to see what is taking
so long. Stack traces are your friend here.
I *doubt* it is directly related to the fact that the file is big
(unless you're talking megabytes-big) other than the fact that you
have more room to cram poorly performing queries in a larger file.
:)
~Brad
Original Message
Subject: CF load times on VPS
From: Chip Beck chipb...@gmail.com
Date: Wed, September 16, 2009 9:41 am
To: cf-talk cf-talk@houseoffusion.com
Forgive me in advance for this seemingly vague question, but I'm
mostly just asking for suggestions on a general method of
troubleshooting this...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327037
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 9 + EC2
So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327038 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 9 + EC2
My understanding, from the MAX info, is that the EC2 implementation is still in private beta. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327039 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 9 + EC2
hmmm. that sucks. they should've been ready with the AMI before the product launch. On Thu, Oct 8, 2009 at 9:38 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: My understanding, from the MAX info, is that the EC2 implementation is still in private beta. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327040 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 9 + EC2
With the core product being ready, I'm kind of glad they took the marketing opportunity they had with MAX to push a new release to the masses. There next big marketing opp would not have had such a diverse audience, and it would probably have been a year from now. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 10/8/2009 12:20 PM, Agha Mehdi wrote: hmmm. that sucks. they should've been ready with the AMI before the product launch. On Thu, Oct 8, 2009 at 9:38 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: My understanding, from the MAX info, is that the EC2 implementation is still in private beta. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Free Database Enginer for ColdFusion
H2 comes with an GUI deal, like most these kinds of DBs do. Even a servlet based deal! Wow! I'm pretty sure someone even said what to do to fire up the H2 console deal, previously in this thread. The docs for h2 are fine, just fine-- you might want to take a look at 'em. Here's a feeling lucky type of link: http://www.h2database.com/html/tutorial.html The docs are clear and clean, and worked, even-- I set up h2 in like 10 minutes the other day. 5 min of it was reading. But I love reading. -- We are one, after all, you and I, together we suffer, together exist and forever will recreate each other. Teilhard de Chardin On Wed, Oct 7, 2009 at 4:38 PM, Bryan Stevenson wrote: I may have spoken too soon Arslan I managed to get to the connection details in DBVisulaizer and now I see there is no database type of H2 (HSQLDB is there). I double checked Aqua Data Studio and again...no database type of H2. Both apps have generic database types, so perhaps that may work. Of course I would assume that the Railo folks could point you in the right direction. I sure hope H@ can be administered via some sort of GUII for one can't stand doing all my DB admin with SQL alonetakes FOREVER ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Free Database Enginer for ColdFusion
Yeah I actually state contrary to that earlier i nthe thread. I'd not used the web GUI that H2 offered. All you need to do is double click the H2 jar if you have that enabled on the system or execute h2.jar from the command line. Adam On Thu, Oct 8, 2009 at 1:40 PM, denstar valliants...@gmail.com wrote: H2 comes with an GUI deal, like most these kinds of DBs do. Even a servlet based deal! Wow! I'm pretty sure someone even said what to do to fire up the H2 console deal, previously in this thread. The docs for h2 are fine, just fine-- you might want to take a look at 'em. Here's a feeling lucky type of link: http://www.h2database.com/html/tutorial.html The docs are clear and clean, and worked, even-- I set up h2 in like 10 minutes the other day. 5 min of it was reading. But I love reading. -- We are one, after all, you and I, together we suffer, together exist and forever will recreate each other. Teilhard de Chardin On Wed, Oct 7, 2009 at 4:38 PM, Bryan Stevenson wrote: I may have spoken too soon Arslan I managed to get to the connection details in DBVisulaizer and now I see there is no database type of H2 (HSQLDB is there). I double checked Aqua Data Studio and again...no database type of H2. Both apps have generic database types, so perhaps that may work. Of course I would assume that the Railo folks could point you in the right direction. I sure hope H@ can be administered via some sort of GUII for one can't stand doing all my DB admin with SQL alonetakes FOREVER ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Free Database Enginer for ColdFusion
But I love reading. You can read? Must be nice. Just kidding. I can read, but only if people type slowly... G! On Thu, Oct 8, 2009 at 1:40 PM, denstar valliants...@gmail.com wrote: H2 comes with an GUI deal, like most these kinds of DBs do. Even a servlet based deal! Wow! I'm pretty sure someone even said what to do to fire up the H2 console deal, previously in this thread. The docs for h2 are fine, just fine-- you might want to take a look at 'em. Here's a feeling lucky type of link: http://www.h2database.com/html/tutorial.html The docs are clear and clean, and worked, even-- I set up h2 in like 10 minutes the other day. 5 min of it was reading. But I love reading. -- We are one, after all, you and I, together we suffer, together exist and forever will recreate each other. Teilhard de Chardin On Wed, Oct 7, 2009 at 4:38 PM, Bryan Stevenson wrote: I may have spoken too soon Arslan I managed to get to the connection details in DBVisulaizer and now I see there is no database type of H2 (HSQLDB is there). I double checked Aqua Data Studio and again...no database type of H2. Both apps have generic database types, so perhaps that may work. Of course I would assume that the Railo folks could point you in the right direction. I sure hope H@ can be administered via some sort of GUII for one can't stand doing all my DB admin with SQL alonetakes FOREVER ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Upgrading from CF MX6.1 to 8 - Verity question....
Hi all, We have an app that has been in 6.1 for years and we are finally working on upgrading it to CF 8. My questions is simple, although I'm afraid the answer will not be: Why does it take 5 times as long to create a collection in CF 8 as it does to create a collection CF MX 6.1 ? We have a module that creates about 24 collections. Each collection takes about 2 seconds to create in MX 6.1. In CF 8, they take around 10-12 seconds to create. This is Windows platform. I even checked to see if CF 8 collections have more files, and while, an empty collection in MX 6.1 has 27 files and 20 folders, an empty collection in CF 8 has 30 files, but only 9 folders. 47 hits to the OS in MX 6.1 and only 39 in CF 8 and it still takes 5 times as long. We have other modules that actually do indexing in these collections and those have also been running about 5 times as long. Has anyone run into this and, if so, can it be explained? Is there possibly something wrong? Thanks! Dave Phillips ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Free Database Enginer for ColdFusion
well guys :) I have successfully created H2 database and its working fi9 with my CF server Alhamdulillah... besides I downloaded ExecuteQuery which is direct run java based software to connect to most of the famous databases and perform basic tasks like table creation :) so I guess H2 has won over Derby ;) lolz... Regards, Arsalan -- From: Gerald Guido gerald.gu...@gmail.com Sent: Friday, October 09, 2009 12:16 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Free Database Enginer for ColdFusion But I love reading. You can read? Must be nice. Just kidding. I can read, but only if people type slowly... G! On Thu, Oct 8, 2009 at 1:40 PM, denstar valliants...@gmail.com wrote: H2 comes with an GUI deal, like most these kinds of DBs do. Even a servlet based deal! Wow! I'm pretty sure someone even said what to do to fire up the H2 console deal, previously in this thread. The docs for h2 are fine, just fine-- you might want to take a look at 'em. Here's a feeling lucky type of link: http://www.h2database.com/html/tutorial.html The docs are clear and clean, and worked, even-- I set up h2 in like 10 minutes the other day. 5 min of it was reading. But I love reading. -- We are one, after all, you and I, together we suffer, together exist and forever will recreate each other. Teilhard de Chardin On Wed, Oct 7, 2009 at 4:38 PM, Bryan Stevenson wrote: I may have spoken too soon Arslan I managed to get to the connection details in DBVisulaizer and now I see there is no database type of H2 (HSQLDB is there). I double checked Aqua Data Studio and again...no database type of H2. Both apps have generic database types, so perhaps that may work. Of course I would assume that the Railo folks could point you in the right direction. I sure hope H@ can be administered via some sort of GUII for one can't stand doing all my DB admin with SQL alonetakes FOREVER ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion 9 and XAMPP
hey guys, thanks for the good advice. due to time limitations yesterday i am running cf on its own server at moment. will try later today to reinstall with xampp. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
calculate 5 pm last thursday
Users can vote in a contest each week from 5 pm Thursday until 5 pm next Thursday, when the next week begins. How do I find 5 pm Thursday just past? Here is what I have but it is not working: #dateformat(DateAdd(h,17,(now() -DayOfWeek( now() ) -3)),'-MM-DD HH:MM:SS')# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: calculate 5 pm last thursday
On Thu, Oct 8, 2009 at 4:01 PM, Matthew Smith chedders...@gmail.com wrote:
Users can vote in a contest each week from 5 pm Thursday until 5 pm next
Thursday, when the next week begins. How do I find 5 pm Thursday just past?
These are fun challenges.
I'd wager money there's a better way to do this. They key to my
solution is the iif() statement. Most of the rest is just code to
show it works.
Paste binned: http://cfm.pastebin.com/m175b5a7d
pre
Stuff I wrote down to figure out some math...
6 friday -1
7 saturday -2
1 sunday -3
2 monday -4
3 tuesday -5
4 wednesday -6
5 thursday -7
/pre
cfloop from=0 to=7 step=1 index=i
!--- use this to test the time before or after 5pm ---
cfset hourOffset = 1
!--- date to test ---
cfset testDate = DateAdd('h',hourOffset, Now()+i)
cfoutput
testDate = #DateFormat(testDate,, d, )# @
#timeFormat(testDate, 'h:mm tt')#br/
cfset theDiff = iif(DayOfWeek(testDate) gt 5 or (DayOfWeek(testDate)
eq 5 and hour(testDate) gte
17),0-(DayOfWeek(testDate)-5),0-DayOfWeek(testDate)-2)
cfset newDate = dateAdd('d',theDiff, testDate)
cfset lastThursday = createDateTime(Year(newDate), month(newDate),
day(NewDate), 17, 0, 0)
Last Thursday at 5pm = #dateFormat(lastThursday,', d, ')#
@ #timeFormat(lastThursday, 'h:mm tt')#
Br/br/
/cfoutput
/cfloop
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327049
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: calculate 5 pm last thursday
And here's the output from my computer with the offset set to +1 (to show after 5pm today) Stuff I wrote down to figure out some math... 6 friday -1 7 saturday -2 1 sunday -3 2 monday -4 3 tuesday -5 4 wednesday -6 5 thursday -7 testDate = Thursday, October 8, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 8, 2009 @ 5:00 PM testDate = Friday, October 9, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 8, 2009 @ 5:00 PM testDate = Saturday, October 10, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 8, 2009 @ 5:00 PM testDate = Sunday, October 11, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 8, 2009 @ 5:00 PM testDate = Monday, October 12, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 8, 2009 @ 5:00 PM testDate = Tuesday, October 13, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 8, 2009 @ 5:00 PM testDate = Wednesday, October 14, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 8, 2009 @ 5:00 PM testDate = Thursday, October 15, 2009 @ 5:56 PM Last Thursday at 5pm = Thursday, October 15, 2009 @ 5:00 PM ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: remote windows file manager
A signed java applet might work too, along those same lines.. On Thu, Oct 8, 2009 at 11:47 AM, b...@bradwood.com wrote: The only times I've seen this done before involved an Active X control that the user was required to install with the usual browser security warnings and such. That may work, but you are adding complexity and removing portability ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery timeout doesn't work out on jdbc driver
Or figure out why its running slowly, and make it run faster. =) Rick On Thu, Oct 8, 2009 at 12:01 PM, Adam Haskell a.hask...@gmail.com wrote: Run it in a thread with CFthread and put a timeout on the cfjoin. Adam On Thu, Oct 8, 2009 at 8:47 AM, Vamsi Pappu vissu.va...@gmail.com wrote: Hi All, I have a situation here where cfquery doesn't seem to be performing well on jdbc driver, when I read in forums it was clearly mentioned that cfquery timeout doesn't support some drivers, Is there any another alternate to this. My requirement is no matter what happens, if query is not responding in given amount of time then it should timeout.Can anyone suggest a good advice. Thanks, Vamsi ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Minimum flash player for CF flash controls.
Can somebody point me to some actual documentation that details what version of Flash is required by a user for them to access Flash based, forms and charts created by ColdFusion 8 code? TIA Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Minimum flash player for CF flash controls.
I don't know about documentation, but the CFFORM controls are generated by Flex 1.5, and would therefore require FP9, I think. Nothing in CF requires FP10. Dave Watts, CTO, Fig Leaf Software On 2009-10-08, Ian Skinner h...@ilsweb.com wrote: Can somebody point me to some actual documentation that details what version of Flash is required by a user for them to access Flash based, forms and charts created by ColdFusion 8 code? TIA Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Minimum flash player for CF flash controls.
Dave Watts wrote: I don't know about documentation, but the CFFORM controls are generated by Flex 1.5, and would therefore require FP9, I think. Nothing in CF requires FP10. Dave Watts, CTO, Fig Leaf Software That jives with other hints I have been able to find. But I'm looking for something more definitive and defensible to use in a document. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Minimum flash player for CF flash controls.
I thought that Flex 1.5 only required Flash Player 8 In fact, based on this article, I'd say its actually Flash Player 7: http://kb2.adobe.com/cps/285/3d2855d6.html Rick On Thu, Oct 8, 2009 at 6:00 PM, Ian Skinner h...@ilsweb.com wrote: Dave Watts wrote: I don't know about documentation, but the CFFORM controls are generated by Flex 1.5, and would therefore require FP9, I think. Nothing in CF requires FP10. Dave Watts, CTO, Fig Leaf Software That jives with other hints I have been able to find. But I'm looking for something more definitive and defensible to use in a document. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Hosting.com Offers Free ColdFusion Beta
Press Release: http://www.hosting.com/aboutus/press/2009/october/coldfusion9.shtml Program Details: http://www.hosting.com/cf9/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Minimum flash player for CF flash controls.
It is indeed Flash Player 9. Apparently FP10 already has a penetration rate of 94% according to Adobe. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion sessions and facebook connect
Jeff, I did a few facebook applications a couple years ago, but facebook connect does not ring a bell. But the issue with the sessions does. The postback from facebook resulted in a different CFID CFTOKEN each time, so I ended up rolling my own. What specifically are you trying to do? -- Dan O'Keefe On Wed, Oct 7, 2009 at 7:51 PM, Jeff U j...@uspokerdirectory.com wrote: Also, another thread from 4 months ago: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:59559 so hopefully Casey or Shane can chime in if they are still out there. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327059 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 9 + EC2
Sure, it would have been much smarter to make the vast majority of the user base wait until the AMI deployment was fully tested, rather than let the them use the new version now. By the way, it might be obvious, but you can actually deploy a CF instance onto EC2 right now. You don't have to wait for some official Adobe AMI to do this. On Thu, Oct 8, 2009 at 1:20 PM, Agha Mehdi aghaime...@gmail.com wrote: hmmm. that sucks. they should've been ready with the AMI before the product launch. On Thu, Oct 8, 2009 at 9:38 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: My understanding, from the MAX info, is that the EC2 implementation is still in private beta. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327060 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 9 + EC2
Don't have a clue how they should've been ready with the AMI before the product got interpreted as should've delayed CF 9 launch and waited for the AMI. May be, it's because English is my 2nd language :) Apologies for that. Not in any hurry to run anything in the cloud so, I will wait for the official Adobe AMI. That will mean less work on my part. Cheers Agha On Oct 8, 2009, at 7:56 PM, Brian Kotek brian...@gmail.com wrote: Sure, it would have been much smarter to make the vast majority of the user base wait until the AMI deployment was fully tested, rather than let the them use the new version now. By the way, it might be obvious, but you can actually deploy a CF instance onto EC2 right now. You don't have to wait for some official Adobe AMI to do this. On Thu, Oct 8, 2009 at 1:20 PM, Agha Mehdi aghaime...@gmail.com wrote: hmmm. that sucks. they should've been ready with the AMI before the product launch. On Thu, Oct 8, 2009 at 9:38 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: My understanding, from the MAX info, is that the EC2 implementation is still in private beta. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
