CF and MS Access support
I'm helping someone with a project and she elected to use GoDaddy as her host. They now tell her they have upgraded to the latest version of CF and it no longer supports MS Access databases. Have I missed something? This is news to me. Larry V. Stephens Indiana University Office of Risk Management steph...@indiana.edu 812-855-9758 ~| 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:328503 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 and MS Access support
On Thu, Nov 19, 2009 at 8:17 AM, Stephens, Larry V steph...@indiana.eduwrote: I'm helping someone with a project and she elected to use GoDaddy as her host. They now tell her they have upgraded to the latest version of CF and it no longer supports MS Access databases. Have I missed something? This is news to me. 1. Coldfusion is an additional fee per month over basic hosting so she may not have selected that initially when setting up her account. 2. I only have access to MySQL on my account, so that may be true. ~| 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:328504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Jpg as a Watermark
Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im using at the moment: cfpdf action = addwatermark source = #TEST# image = #request.mainfilePath#Test2# foreground = No overwrite = yes pages = #totalpages# opacity = 10 Position = 10, -50 showonprint = YES destination = #TEST3# ~| 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:328505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Report Builder
I'm starting to play around with Report Builder. can the .cfr files see application variables, such as data sources or do I have to hard code the data source name into each report -- Scott Stewart IT Consultant/ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (919) 874-6229 ~| 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:328506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Jpg as a Watermark
I am presuming that a watermark doesn't have to use many colors. So, you might want to try gif instead of jpg. Damo Drumm wrote: Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im using at the moment: cfpdf action = addwatermark source = #TEST# image = #request.mainfilePath#Test2# foreground = No overwrite = yes pages = #totalpages# opacity = 10 Position = 10, -50 showonprint = YES destination = #TEST3# ~| 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:328507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Jpg as a Watermark
Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im using at the moment: cfpdf action = addwatermark source = #TEST# image = #request.mainfilePath#Test2# foreground = No overwrite = yes pages = #totalpages# opacity = 10 Position = 10, -50 showonprint = YES destination = #TEST3# We had the same need, when you use the watermark feature it is on TOP of the image and sometimes you can not read the content below. What we did was to create an image and then use it as a background image in HTML as the watermark. This placed the image behind the content and if you need, you can even customize the image by using the CFIMAGE tag. Matt Friedman life is too short to drink cheap beer ~| 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:328508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph
An update on this, for my own reference as well as for people googling. I have, following various people's advice, changed the memory profile of our application quite dramatically and I will summarize what I changed and the tools I used to find the problems. I shall properly blog this later, no time now. Firstly, after installing and using JConsole, I figured it was high time I learned about JVM and its memory spaces. I found the following articles very useful: http://www.slideshare.net/gengmao/inside-the-jvm-memory-management-and-troubleshooting http://www.javaworld.com/javaworld/jw-01-2002/jw-0111-hotspotgc.html I had also followed Paul's advice and increased New Gen space in the heap, which did have an immediate effect, just not as large as I had hoped - more on that in a bit. Next I found error logs in the same directory as the jvm.config file (mine was {colfusion}/runtime/bin), the part dump of which is seen below. It turned out this was a reasonably common error, and not just to do with CF: http://www.talkingtree.com/blog/index.cfm/2006/4/28/Understanding-HotSpot-in-Plain-English This article recommended using the -Xint JVM option to turn off Hotspot optimization. I did this and the effect was pretty disastrous on performance (the effect can vary a lot depending on the nature of your application, apparently). I searched some more and found an article suggesting that to avoid the error, free 'Survivor' space needed increasing - this seemed in line with the state of memory at the time of my crash so I went ahead and started tweaking, bringing me back to Paul's earlier advice but finally seeing me use more dramatic settings: -Xmn384m -XX:SurvivorRatio=1 -XX:TargetSurvivorRatio=25 This says, use 384Mb for new gen, of which 2/3rds will be for Survivor space; also, the GC will aim to keep survivor space at least 75% empty (no more than 25% full). I ended with these figures after a whole heap of teaking that had previously brought my memory spikes down. This had the benefit of clearly showing little jumps in Old Gen memory every 10 seconds or so. I tracked these jumps down using JConsole to spot the time of the jump and SeeFusion to see what templates were requested at those times. My tracking led me to the same page that appeared in my error log, a verity search. I googled and found: Operations on collections (e.g., CFSearch and CFIndex) can cause growth over time. http://kb2.adobe.com/cps/175/tn_17517.html No workarounds, that's just the way it is. I noted the size of memory being eaten by these searches (up to and around 15MB) and ended with the JVM settings quoted above, the idea being that there should be enough new gen memory available to cope with these verity searches (so that object don't just get dumped into Old gen all the time). Finally, and most dramatically, I found some code that allowed a blank search against verity. When I ran it, I found it ate 100-150Mb or RAM each time. Using subversion, I found out when this became possible and why. It turns out this code was committed and deployed the same day we started seeing the crash reports on our servers and that it was an unneccessary change, fixing the symptom of a bug but not the cause. I reverted the change. So now I have a very different JVM memory configuration on one of our live servers and have committed a code change that will alleviate some horrid memory abuse to all three. I have JConsole monitoring all three servers and can see the modified server memory useage starkly contrasted against the other two. I shall keep them running for a while and see how things go... Anyways, enough already. Dominic 2009/11/18 Dominic Watson watson.domi...@googlemail.com Right, so changing Eden memory size had a slight effect on the memory useage pattern (spikes only going up to around 80% instead of 95%), but did not stop the crashing. Getting to grips with JConsole has been really useful / educating. I have been monitoring all three of our live servers overnight and one of the servers bombed this morning; I was then able to see what was going on in memory when the bomb occurred: * Old Gen - normal, using far less than peak * Perm gen - normal, sub 90MB * Eden - normal, far less than the 192MB allocated * Survivor - had been flat at max (20MB) for around 20 seconds. Normal shape of this graph for the server is very spikey, peaking very briefly and very often I then discovered the hs_err log for the crash (yes, I'm a server debugging noob) and it told me the following: # # An unexpected error has been detected by Java Runtime Environment: # # java.lang.OutOfMemoryError: requested 1160376 bytes for Chunk::new. Out of swap space? # # Internal Error (allocation.cpp:218), pid=11476, tid=12428 # Error: Chunk::new # # Java VM: Java HotSpot(TM) Server VM (11.3-b02 mixed mode windows-x86) # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # The
RE: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph
Dom, That is a GREAT play by play... Thanks! Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Thursday, November 19, 2009 9:09 AM To: cf-talk Subject: Re: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph An update on this, for my own reference as well as for people googling. I have, following various people's advice, changed the memory profile of our application quite dramatically and I will summarize what I changed and the tools I used to find the problems. I shall properly blog this later, no time now. Firstly, after installing and using JConsole, I figured it was high time I learned about JVM and its memory spaces. I found the following articles very useful: http://www.slideshare.net/gengmao/inside-the-jvm-memory-management-and-troub leshooting http://www.javaworld.com/javaworld/jw-01-2002/jw-0111-hotspotgc.html I had also followed Paul's advice and increased New Gen space in the heap, which did have an immediate effect, just not as large as I had hoped - more on that in a bit. Next I found error logs in the same directory as the jvm.config file (mine was {colfusion}/runtime/bin), the part dump of which is seen below. It turned out this was a reasonably common error, and not just to do with CF: http://www.talkingtree.com/blog/index.cfm/2006/4/28/Understanding-HotSpot-in -Plain-English This article recommended using the -Xint JVM option to turn off Hotspot optimization. I did this and the effect was pretty disastrous on performance (the effect can vary a lot depending on the nature of your application, apparently). I searched some more and found an article suggesting that to avoid the error, free 'Survivor' space needed increasing - this seemed in line with the state of memory at the time of my crash so I went ahead and started tweaking, bringing me back to Paul's earlier advice but finally seeing me use more dramatic settings: -Xmn384m -XX:SurvivorRatio=1 -XX:TargetSurvivorRatio=25 This says, use 384Mb for new gen, of which 2/3rds will be for Survivor space; also, the GC will aim to keep survivor space at least 75% empty (no more than 25% full). I ended with these figures after a whole heap of teaking that had previously brought my memory spikes down. This had the benefit of clearly showing little jumps in Old Gen memory every 10 seconds or so. I tracked these jumps down using JConsole to spot the time of the jump and SeeFusion to see what templates were requested at those times. My tracking led me to the same page that appeared in my error log, a verity search. I googled and found: Operations on collections (e.g., CFSearch and CFIndex) can cause growth over time. http://kb2.adobe.com/cps/175/tn_17517.html No workarounds, that's just the way it is. I noted the size of memory being eaten by these searches (up to and around 15MB) and ended with the JVM settings quoted above, the idea being that there should be enough new gen memory available to cope with these verity searches (so that object don't just get dumped into Old gen all the time). Finally, and most dramatically, I found some code that allowed a blank search against verity. When I ran it, I found it ate 100-150Mb or RAM each time. Using subversion, I found out when this became possible and why. It turns out this code was committed and deployed the same day we started seeing the crash reports on our servers and that it was an unneccessary change, fixing the symptom of a bug but not the cause. I reverted the change. So now I have a very different JVM memory configuration on one of our live servers and have committed a code change that will alleviate some horrid memory abuse to all three. I have JConsole monitoring all three servers and can see the modified server memory useage starkly contrasted against the other two. I shall keep them running for a while and see how things go... Anyways, enough already. Dominic 2009/11/18 Dominic Watson watson.domi...@googlemail.com Right, so changing Eden memory size had a slight effect on the memory useage pattern (spikes only going up to around 80% instead of 95%), but did not stop the crashing. Getting to grips with JConsole has been really useful / educating. I have been monitoring all three of our live servers overnight and one of the servers bombed this morning; I was then able to see what was going on in memory when the bomb occurred: * Old Gen - normal, using far less than peak * Perm gen - normal, sub 90MB * Eden - normal, far less than the 192MB allocated * Survivor - had been flat at max (20MB) for around 20 seconds. Normal shape of this graph for the server is very spikey, peaking very briefly and very often I then discovered the hs_err log for the crash (yes, I'm a server debugging noob) and it told me the following: # # An unexpected error has been detected by Java
Re: Jpg as a Watermark
Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im using at the moment: cfpdf action = addwatermark source = #TEST# image = #request.mainfilePath#Test2# foreground = No overwrite = yes pages = #totalpages# opacity = 10 Position = 10, -50 showonprint = YES destination = #TEST3# We had the same need, when you use the watermark feature it is on TOP of the image and sometimes you can not read the content below. What we did was to create an image and then use it as a background image in HTML as the watermark. This placed the image behind the content and if you need, you can even customize the image by using the CFIMAGE tag. Matt Friedman life is too short to drink cheap beer Heres another one i've tried which might work if it would do it automatically At the minute ive a PDF at 48kb before I add the Watermark. after ive the watermark added it jumps to 60MB but when I go to File save as Version 5 on Abobe it cuts the Size back to 99KB Im wondering can this be done automatically so i dont have to open the file and save it down each to to reduce the size of it. The version of Adobe Im using is 6 ~| 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:328511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph
Thanks for the good follow up info. I'll be interested in your learning curve for figuring out JConsole. ~Brad Original Message Subject: Re: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph From: Dominic Watson watson.domi...@googlemail.com Date: Thu, November 19, 2009 9:08 am To: cf-talk cf-talk@houseoffusion.com An update on this, for my own reference as well as for people googling. I have, following various people's advice, changed the memory profile of our application quite dramatically and I will summarize what I changed and the tools I used to find the problems. I shall properly blog this later, no time now. ~| 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:328512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8, Vista, SQL 2005
Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. Any help appreciated. 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:328513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Internet Explorer and @ signs in link text
We're working with the eBay search APIs to do product searches and we're running into a problem. A lot of the item names have @ signs in the name (a lot of L@@K! or @ L@@K @. We use the item name as the link to the product, but in IE, the @ sign [under certain conditions, described below] causes the URL to be messed up. Instead of displaying the item name, it displays the actual URL. The link still works, but it's not exactly user-friendly. The cases that seem to cause it (that we know of): 1) two @ signs together ( @@ ) 2) a single @ sign surrounded by spaces When you get those results back on eBay's site, it doesn't cause a problem, so they must have found some way around it. But everything we've tried hasn't worked. We've tried displaying the HTML entities (#64), using HTMLEditFormat(), URLEncodedFormat(), and XMLFormat(). We've been able to get around the @@ problem by replacing them with the letter O [since it's most likely that @@ are meant to be O's and not a's]. But, with the single version, we can't necessarily assume that. And, we can't necessarily do replaces for every combination, because we don't know them all. So, does anyone know 1) why IE does this and 2) a good fix for it? I've tried to Google it, but it's hard because the search basically ignores @ symbols). And, I've tried to look in the eBay developer forums. Thanks! -- - Scott Brady http://www.scottbrady.net/ ~| 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:328514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad Original Message Subject: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 10:27 am To: cf-talk cf-talk@houseoffusion.com Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. ~| 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:328515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Internet Explorer and @ signs in link text
haha, I've had my fair share of troubles trying search Google for information on punctuation. In fact you're probably pretty safe that anyone else having this problem will never ever find this thread. :) ~Brad I've tried to Google it, but it's hard because the search basically ignores @ symbols). ~| 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:328516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. ~| 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:328517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Internet Explorer and @ signs in link text
The URL encoding for the @ symbol is %40. If you replace @ with %40 in url strings that should work. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4622 (20091119) __ The message was checked by ESET Smart Security. http://www.eset.com ~| 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:328518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Run a trace on the DB while you run the query in CF and see if the statement is ever making it to the database. It may be a data source driver issue. ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 11:15 am To: cf-talk cf-talk@houseoffusion.com No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad ~| 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:328519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHTTP Connection Failure
I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP Connection Failure
I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8, Vista, SQL 2005
SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is different and there is a TCP setting you have to change. You may want to look at your firewall also. Chad -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 11:27 AM To: cf-talk Subject: CF8, Vista, SQL 2005 Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. Any help appreciated. 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:328522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.comwrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP Connection Failure
Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:41 PM To: cf-talk Subject: Re: CFHTTP Connection Failure where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.comwrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Chad I think the datasource connection is ok as I can select single individual columns in a query. Thanks SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is different and there is a TCP setting you have to change. You may want to look at your firewall also. Chad -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 11:27 AM To: cf-talk Subject: CF8, Vista, SQL 2005 Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. Any help appreciated. 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:328525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, Vista, SQL 2005
I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. Thanks Run a trace on the DB while you run the query in CF and see if the statement is ever making it to the database. It may be a data source driver issue. ~Brad No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad ~| 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:328526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query? ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 2:22 pm To: cf-talk cf-talk@houseoffusion.com I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. ~| 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:328527 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 and MS Access support
I'm helping someone with a project and she elected to use GoDaddy as her host. They now tell her they have upgraded to the latest version of CF and it no longer supports MS Access databases. Have I missed something? This is news to me. It's possible that they're using 64-bit CF, which doesn't support Access. 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! ~| 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:328528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further - The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query? ~Brad I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. ~| 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:328529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
What's quite a few? I have a couple of SQL tables with more than 100 columns, one with over 200 columns, and have no problems at all... and that's SQL 2005, Vista, CF8. You may have a problem with available memory or disk space. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 4:30 PM To: cf-talk Subject: Re: CF8, Vista, SQL 2005 Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further - The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query? ~Brad I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. ~| 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:328530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Thanks What's quite a few? I have a couple of SQL tables with more than 100 columns, one with over 200 columns, and have no problems at all... and that's SQL 2005, Vista, CF8. You may have a problem with available memory or disk space. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further - The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? ~| 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:328531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
I run CF8, SQL 2005 on my Vista laptop for demos (and development at home) and have no issues... and some of the record are significant. I doubt this is an issue, but if you SQL DB is more than 1.2 Terabytes then you're hitting the SQL Server performance limit. You probably don't even have that much disk space. Look at the processes you have running and shut down some non-essentials. Memory is the most likely culprit... or maybe your program has a never-ending loop... that will do it too. Good Luck... Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __ The message was checked by ESET Smart Security. http://www.eset.com ~| 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:328532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Just a guess, but maybe do some maintenance on the database. Try a shrink. Rebuild the indexs. Is the database from SQL 2005 or an earlier version? Sound like it is more on the CF end than the database through. Check the DSN setting in CFadministrator also. Remove it and add it back using the default settings. -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 4:43 PM To: cf-talk Subject: Re: CF8, Vista, SQL 2005 Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. 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:328533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Database size is around 800mb. Im using a test cfm page with one query so I dont think its a loop. Thanks I run CF8, SQL 2005 on my Vista laptop for demos (and development at home) and have no issues... and some of the record are significant. I doubt this is an issue, but if you SQL DB is more than 1.2 Terabytes then you're hitting the SQL Server performance limit. You probably don't even have that much disk space. Look at the processes you have running and shut down some non-essentials. Memory is the most likely culprit... or maybe your program has a never-ending loop... that will do it too. Good Luck... Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __ The message was checked by ESET Smart Security. http://www.eset.com ~| 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:328534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Forgive me if you've already answered this in the thread, but have you tried explicitly selecting all 40 of the columns? 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! ~| 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:328535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Also try restarting the CF ODBC services. There are two of them in the services control panel. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, November 19, 2009 5:04 PM To: cf-talk Subject: RE: CF8, Vista, SQL 2005 Just a guess, but maybe do some maintenance on the database. Try a shrink. Rebuild the indexs. Is the database from SQL 2005 or an earlier version? Sound like it is more on the CF end than the database through. Check the DSN setting in CFadministrator also. Remove it and add it back using the default settings. -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 4:43 PM To: cf-talk Subject: Re: CF8, Vista, SQL 2005 Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. 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:328536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Selecting the 40 colums results in the same, but selecting a few coulumns is ok. Ive tried restarting services. Thanks Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Forgive me if you've already answered this in the thread, but have you tried explicitly selecting all 40 of the columns? 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! ~| 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:328537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, Vista, SQL 2005
Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC drivers. Are you able to select an entire row from a native SQL Server client? 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! ~| 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:328538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
jQuery Sortable list not working in CFWINDOW
Hello! I have a page where a user can select other users to assign to a project. The user drags and drops a user from a list on the left side into another list on the right side. This is all handled using an unordered list and jQuery's sortable() function. This works great by itself, but I am wanting to put this into a cfwindow. I have attached the code below. If I wrap this code into a cfwindow tag, it works. However, when I drop the code in a file somewhere and set the source attribute in the cfwindow tag to point to that file, it doesn't work. It also doesn't work if I use the ColdFusion.Window.create() function. Any thoughts? script type=text/javascript src=scripts/jQuery.js/script script type=text/javascript src=scripts/jQuery_MenuDragDrop.js/script script type=text/javascript $(document).ready(function() { // users available and assigned lists: $(ul#sListAvailable, ul#sListAssigned).sortable({ connectWith: ul.userList, placeHolder: ul.userList, update: function() { ... } }); }); /script labelAssign Users:/label bAvailable Users:/bbr ul class=userList id=sListAvailable cfoutput query=qryAccounts li class=userList id=#iLoginID##sNameFirst# #sNameLast#/li /cfoutput /ul bAssigned Users:/bbr ul class=userList id=sListAssigned/ul ~| 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:328539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC drivers. Are you able to select an entire row from a native SQL Server client? 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! ~| 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:328540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Then it's almost certainly a JDBC issue. You could try to find information about it in the DataDirect documentation (CF uses DataDirect Connect for JDBC) or you could try a different JDBC driver for SQL Server. 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! ~| 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:328541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
How can I setup a different JDBC driver Thanks Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Then it's almost certainly a JDBC issue. You could try to find information about it in the DataDirect documentation (CF uses DataDirect Connect for JDBC) or you could try a different JDBC driver for SQL Server. 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! ~| 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:328542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Amazon S3 - HTTPS and Live Stats
I'm looking into moving over to Amazon S3 for hosting static content on a site that is currently hosted internally. We see wildly varying amounts of bandwidth from day to day, so S3 seems to be a natural solution to cut bandwidth costs. I will need to be able to access the files over HTTPS AND keep some semblance of the current Live Stats reporting we use. Google is a little slim on some aspects of those two items. I thought I'd hit the list here and see if anyone had any advice. This is the only links I turned up on HTTPS: http://clouddevelopertips.blogspot.com/2009/08/amazon-s3-gotcha-using-virtual-host.html It seems to think you can't use HTTPS with a CNAME pointer which would be a downer, but not a deal breaker. (I've got tons of legacy code and E-mails that I would like to keep pointing at the old URL while it seamlessly repoints to an S3 bucket) On the Live Stats reports, I've found that logging can be enabled for a bucket... http://docs.amazonwebservices.com/AmazonS3/latest/index.html?LoggingHowTo.html ...but I can't seem to find any useful info on if those logs are anything like IIS logs and can be consumed by reporting tools like Live Stats. (And apparently Live Stats was bought by MS and dropped like 3 years ago, so I guess this would be a good time to find a new analytics app too :) On a related note, I was quite excited to see that ColdBox just came out with an S3 explorer app! Now if only Adobe CF had baked-in S3 support like Railo :) ~Brad ~| 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:328543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Place its JAR in your class path, restart CF and add the data source by constructing the JDBC URL and specifying the driver class name. I've always used the data direct drivers for SQL Server, but this might get you started: http://msdn.microsoft.com/en-us/data/aa937724.aspx ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 4:49 pm To: cf-talk cf-talk@houseoffusion.com How can I setup a different JDBC driver ~| 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:328544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
How can I setup a different JDBC driver Here are some examples: http://www.bpurcell.org/blog/index.cfm?ENTRY=981mode=entry http://blog.demirkapi.net/post.cfm/installing-jtds-sql-server-jdbc-driver-for-coldfusion Here's the Adobe documentation for CF 7 - it works basically the same way in other versions also, though: http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0056.htm 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! ~| 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:328545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP Connection Failure
the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long conference call with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. On Thu, Nov 19, 2009 at 11:53 AM, Mark Kruger mkru...@cfwebtools.comwrote: Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:41 PM To: cf-talk Subject: Re: CFHTTP Connection Failure where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.com wrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Amazon S3 - HTTPS and Live Stats
I'm looking into moving over to Amazon S3 for hosting static content on a site that is currently hosted internally. We see wildly varying amounts of bandwidth from day to day, so S3 seems to be a natural solution to cut bandwidth costs. I will need to be able to access the files over HTTPS AND keep some semblance of the current Live Stats reporting we use. Are you planning to use Amazon Cloudfront in front of your S3 content? http://aws.amazon.com/cloudfront/ Google is a little slim on some aspects of those two items. I thought I'd hit the list here and see if anyone had any advice. This is the only links I turned up on HTTPS: http://clouddevelopertips.blogspot.com/2009/08/amazon-s3-gotcha-using-virtual-host.html It seems to think you can't use HTTPS with a CNAME pointer which would be a downer, but not a deal breaker. (I've got tons of legacy code and E-mails that I would like to keep pointing at the old URL while it seamlessly repoints to an S3 bucket) This is generally true, since the name in the cert needs to match the name used by the browser to make the HTTPS request. I'm not sure if Cloudfront solves this problem. 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 informat ~| 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:328547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long conference call with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. Are you sure the intermediate certs are also there? I ran into just this problem with a client yesterday - they'd installed the site cert, but not the intermediate certs, and couldn't connect. 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! ~| 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:328548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
It might be worth looking at the connection settings in SQL studio. SQL studio by default will truncate long fields, which may be hiding row size limitations. If you bump up the field length limit in SQL studio and it still works, that would point even more strongly to JDBC. Jaime On Fri, Nov 20, 2009 at 8:37 AM, A D alandeans2...@yahoo.co.uk wrote: Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC drivers. Are you able to select an entire row from a native SQL Server client? 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! ~| 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:328549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Store Flash File in database then load into Flash?
I have a client that required the flash file to be stored in an Oracle database. And now I am required to load Flash using an xml file that should be pulling its data from the database. I cannot store files on the server - so I'm trying to figure out if what I'm attempting is even possible. So far I've been able to create the xml. But note that the url is actually a physical file on the system. I can't do this. I have to retrieve the binary flash data from Oracle and do this same sort of thing. Help anyone? Ideas? Thanks! ___ cfinvoke component=#session.cfc#.msr_multisigs method=getIndexFlash returnvariable=qGetIndexFlash/cfinvoke cfoutput cfxml variable=xmlObject casesensitive=yes cfprocessingdirective suppresswhitespace=yes movies cfloop query=qGetIndexFlash movie url=#XMLFormat(qGetIndexFlash.promoFlashFile)# name=#XMLFormat(qGetIndexFlash.promoXMLName)# frameCount=#XMLFormat(qGetIndexFlash.promoXMLFrameCnt)# flashVars=#XMLFormat(qGetIndexFlash.promoXMLParams)# color1=#XMLFormat(right(qGetIndexFlash.promoTopColor,6))# color2=#XMLFormat(right(qGetIndexFlash.promoMidColor,6))# color3=#XMLFormat(right(qGetIndexFlash.promoBottomColor,6))# / /cfloop /movies /cfprocessingdirective /cfxml /cfoutput cfset xmlString = toString(xmlObject) cfsetting enablecfoutputonly=yes showdebugoutput=no cfcontent type=text/xml cfoutput#xmlString#/cfoutput ~| 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:328550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
Hmmm. not sure what the intermediate cert is. Shouldn't it also affect the one server that can connect? All four of them have the exact same config and cacerts file On Thu, Nov 19, 2009 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long conference call with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. Are you sure the intermediate certs are also there? I ran into just this problem with a client yesterday - they'd installed the site cert, but not the intermediate certs, and couldn't connect. 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! ~| 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:328551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Store Flash File in database then load into Flash?
I have a client that required the flash file to be stored in an Oracle database. And now I am required to load Flash using an xml file that should be pulling its data from the database. I cannot store files on the server - so I'm trying to figure out if what I'm attempting is even possible. So far I've been able to create the xml. But note that the url is actually a physical file on the system. I can't do this. I have to retrieve the binary flash data from Oracle and do this same sort of thing. Help anyone? Ideas? You could certainly store the Flash file itself in a BLOB field, then pull it out with CF, write it temporarily to the filesystem, then serve it up. If you can't even write it temporarily to the filesystem for some reason, you could conceivably use CFIMAGE with the WRITETOBROWSER attribute, then wrap that in a CFSAVECONTENT tag and rewrite the contents to use the generated URL with OBJECT/EMBED tags instead of IMG. 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 infor ~| 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:328552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP Connection Failure
Hmmm. not sure what the intermediate cert is. Shouldn't it also affect the one server that can connect? All four of them have the exact same config and cacerts file All the servers would presumably require the intermediate certs. Are you absolutely sure they all have the exact same list of certificates in their keystores? 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! ~| 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:328553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP Connection Failure
I used Keytool to inspect the cacerts from two servers and randomly checked lines and they all match. I can go back and check it again but why would 3 out of 4 work before 4:00 PM yesterday and keep failing since? On Thu, Nov 19, 2009 at 3:27 PM, Dave Watts dwa...@figleaf.com wrote: Hmmm. not sure what the intermediate cert is. Shouldn't it also affect the one server that can connect? All four of them have the exact same config and cacerts file All the servers would presumably require the intermediate certs. Are you absolutely sure they all have the exact same list of certificates in their keystores? 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! ~| 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:328554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Store Flash File in database then load into Flash?
I'll give that a try. I'm not supposed to write anything to the server. Sure makes the easy stuff tricky. Thanks, Dave! ~| 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:328555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Sortable list not working in CFWINDOW
Try this: function sortLists(el){ var mylist = $(el); var listitems = mylist.children('li').get(); listitems.sort(function(a, b){ var compA = $(a).text().toUpperCase(); var compB = $(b).text().toUpperCase(); return (compA compB) ? -1 : (compA compB) ? 1 : 0; }); $.each(listitems, function(idx, itm) {mylist.append(itm); }); } Just pass it a UL id and do it either after the drop or on page load. ~| 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:328556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Sortable list not working in CFWINDOW
Here is an example. It does not feature drag/drop but it works like a charm. http://tonybentley.com/projects/sortedlist.cfm?download=true ~| 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:328557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Store Flash File in database then load into Flash?
Just pull the content, and use cfcontent + cfheader. If the data is base64()ed, toBinary() it first, but other than that, it's pretty straight forward. Basically a example of serving images from a DB will get you there. I've even got an example lying around here somewhere, if needed. It's way easier than it seems it should be, really. -- Better a diamond with a flaw than a pebble without. Confucius On Thu, Nov 19, 2009 at 4:26 PM, Dave Watts wrote: I have a client that required the flash file to be stored in an Oracle database. And now I am required to load Flash using an xml file that should be pulling its data from the database. I cannot store files on the server - so I'm trying to figure out if what I'm attempting is even possible. So far I've been able to create the xml. But note that the url is actually a physical file on the system. I can't do this. I have to retrieve the binary flash data from Oracle and do this same sort of thing. Help anyone? Ideas? You could certainly store the Flash file itself in a BLOB field, then pull it out with CF, write it temporarily to the filesystem, then serve it up. If you can't even write it temporarily to the filesystem for some reason, you could conceivably use CFIMAGE with the WRITETOBROWSER attribute, then wrap that in a CFSAVECONTENT tag and rewrite the contents to use the generated URL with OBJECT/EMBED tags instead ~| 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:328558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
I used Keytool to inspect the cacerts from two servers and randomly checked lines and they all match. I can go back and check it again but why would 3 out of 4 work before 4:00 PM yesterday and keep failing since? I don't know. What happens if you attempt to browse those HTTPS URLs from the server console (if you can possibly do that?) 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! ~| 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:328559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
Works fine accessing the service from the browser on all 4 servers. I even have small .net app on the servers, which connects just fine to this webservice. On Thu, Nov 19, 2009 at 4:19 PM, Dave Watts dwa...@figleaf.com wrote: I used Keytool to inspect the cacerts from two servers and randomly checked lines and they all match. I can go back and check it again but why would 3 out of 4 work before 4:00 PM yesterday and keep failing since? I don't know. What happens if you attempt to browse those HTTPS URLs from the server console (if you can possibly do that?) 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! ~| 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:328560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFHTTP Connection Failure
H. So the call to HTTP works, but HTTPS does not URLs are exactly the same I assume you have pinged around and made sure that the 4 servers resolve the domain exactly the same right? And you have tried a CF Restart? Sometimes the DNS cache for the JVM will have the wrong address in it if you have been making networking changes etc. Remember also that each server needs to be examined from the console (from RDP or whatever). You have to be able to troubleshoot by making outgoing requests from the individual servers. Still, I'm with dave. If it works via HTTP but not HTTPS it has to be the certs somehow. This post is about SSL 3.0 http://www.coldfusionmuse.com/index.cfm/2009/2/24/CF-SSL30-Authorize-net But it also includes some info on how to test CF and the JVM and log the results. It is probably worth it to try and trap the handshake conversation and see what's up. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 5:06 PM To: cf-talk Subject: Re: CFHTTP Connection Failure the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long conference call with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. On Thu, Nov 19, 2009 at 11:53 AM, Mark Kruger mkru...@cfwebtools.comwrote: Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:41 PM To: cf-talk Subject: Re: CFHTTP Connection Failure where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.com wrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Sortable list not working in CFWINDOW
try this: 1) create a js function in your main page (the one that opens a cfwindow): script type=text/javascript createSortables = function() { // users available and assigned lists: $(ul#sListAvailable, ul#sListAssigned).sortabl e({ connectWith: ul.userList, placeHolder: ul.userList, update: function() { ... } }); } /script 2) remove your current $(document).ready(...) block (completely if it is in the page loaded in cfwindow, or just the part of it that creates the sortable lists if it is in the main page and also has other functions used by your main page) 3) in the page that loads inside cfwindow add this line as last line before the closing /body tag: cfset ajaxonload('createSortables') Azadi Saryev On 20/11/2009 06:34, Joshua Rowe wrote: Hello! I have a page where a user can select other users to assign to a project. The user drags and drops a user from a list on the left side into another list on the right side. This is all handled using an unordered list and jQuery's sortable() function. This works great by itself, but I am wanting to put this into a cfwindow. I have attached the code below. If I wrap this code into a cfwindow tag, it works. However, when I drop the code in a file somewhere and set the source attribute in the cfwindow tag to point to that file, it doesn't work. It also doesn't work if I use the ColdFusion.Window.create() function. Any thoughts? script type=text/javascript src=scripts/jQuery.js/script script type=text/javascript src=scripts/jQuery_MenuDragDrop.js/script script type=text/javascript $(document).ready(function() { // users available and assigned lists: $(ul#sListAvailable, ul#sListAssigned).sortable({ connectWith: ul.userList, placeHolder: ul.userList, update: function() { ... } }); }); /script labelAssign Users:/label bAvailable Users:/bbr ul class=userList id=sListAvailable cfoutput query=qryAccounts li class=userList id=#iLoginID##sNameFirst# #sNameLast#/li /cfoutput /ul bAssigned Users:/bbr ul class=userList id=sListAssigned/ul ~| 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:328562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Converting an AJAX response to coldfusion object
Hi all, I am probably not using the correct 'language' here -- forgive me new to the AJAX world. I have a lovely cfgrid populated by binding it to a CFC. Everything works great. I have some 'filters' that let the users filter the data in the grid. Now the client has asked to have a 'download grid data to excel.' I've done this many times in the past - just not with AJAX data. Now I am stuck. The data is in a javascript object, which I'd like to convert to a coldfusion object. I've tried statements like cfset cfData=DeserializeJSON(theData) and I've set 'theData' via javascript like var theData= ColdFusion.Grid.getGridObject('resource_list'); But I keep getting errors on variable theData not found. a) if I don't specify returnFormat in my CFC, what format does cfgrid data come back as? (JSON, WDDX?). b) how can I convert the javascript object into a coldfusion object? c) or should I be doing something totally different :-) I am missing something -- help/suggestions much appreciated! Cheers, Matts ~| 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:328563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting an AJAX response to coldfusion object
Any remote call to a CFC will return WDDX (unless otherwise specified). You could serialize the JS object into JSON, then pass it to ColdFusion as a struct. -Original Message- From: Developer MediaDoc [mailto:skings...@media-doc.com] Sent: Thursday, November 19, 2009 9:32 PM To: cf-talk Subject: Converting an AJAX response to coldfusion object Hi all, I am probably not using the correct 'language' here -- forgive me new to the AJAX world. I have a lovely cfgrid populated by binding it to a CFC. Everything works great. I have some 'filters' that let the users filter the data in the grid. Now the client has asked to have a 'download grid data to excel.' I've done this many times in the past - just not with AJAX data. Now I am stuck. The data is in a javascript object, which I'd like to convert to a coldfusion object. I've tried statements like cfset cfData=DeserializeJSON(theData) and I've set 'theData' via javascript like var theData= ColdFusion.Grid.getGridObject('resource_list'); But I keep getting errors on variable theData not found. a) if I don't specify returnFormat in my CFC, what format does cfgrid data come back as? (JSON, WDDX?). b) how can I convert the javascript object into a coldfusion object? c) or should I be doing something totally different :-) I am missing something -- help/suggestions much appreciated! Cheers, Matts ~| 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:328564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Internet Explorer and @ signs in link text
The problem isn't that it's breaking the URL. It's that the @ sign in the _text_ of the link (i.e., the text displayed on screen that the user clicks on) is causing the mess-up in the link (so that the URL is displayed as the link instead).. So, if we URL encode the @ symbol with %40, the user will actually see L%40%40K! instead of L@@K. On Thu, Nov 19, 2009 at 10:26 AM, Robert Harrison rob...@austin-williams.com wrote: The URL encoding for the @ symbol is %40. If you replace @ with %40 in url strings that should work. -- - Scott Brady http://www.scottbrady.net ~| 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:328565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Amazon S3 - HTTPS and Live Stats
Are you planning to use Amazon Cloudfront in front of your S3 content? At this point in time, no. Our business is confined to the US and CAN so I'm not too worried about people on the other side of the world. I'm making bet that the latency will be acceptable for this continent. Of course, please tell if you have found otherwise, or have a really good reason for me to begin considering cloud front again. Also, it doubled the price from what I could tell. (Not that it was that expensive to begin with). However I was vaguely annoyed at the lack of specifics regarding what bandwidth I have to pay for so I could have been calculating incorrectly. For instance, someone hits a 5 GB file through cloud front, so I have to pay for S3 bandwidth as well as cloud front bandwidth right? (That's where the twice as expensive part comes in) If I have 5 end points in the US, and someone downloads the file from each one, would I pay for 10 times the bandwidth of the file (instead of 5 times) to allow for it to be copied to each end point? Now my understanding is that is is cached now at the points. So if someone hits it again from the same end point, do I pay for both bandwidths again, or just the end point bandwidth. How long is it cached for? How do I refresh the cache? I quickly ended up with more questions than answers on the cloud front and it didn't seem worth the money so I sort of just left it. It seems to think you can't use HTTPS with a CNAME pointer which would be a downer, but not a deal breaker. (I've got tons of legacy code and E-mails that I would like to keep pointing at the old URL while it seamlessly repoints to an S3 bucket) This is generally true, since the name in the cert needs to match the name used by the browser to make the HTTPS request. I'm not sure if Cloudfront solves this problem. Hmm, it would be interesting if Cloud Front solved that, but I don't know why Cloud Front wouldn't suffer from the same problems that the S3 domains do. I'm curious why they won't simply let you set up a domain or subdomain and resolve it to an IP address on their end that was mapped to your bucket. Then if you own a wild card cert (which we do) they let you install that cert on their servers so it truly is your domain and your cert. Of course, all that may very well be easier said than done. Especially since that would take a lot of IP addresses, and it would tie you to a specific server on their end. ~Brad ~| 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:328566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Internet Explorer and @ signs in link text
Can you paste in the HTML if a sample link in its broken form for us to see? I mean the actual anchor tag in its completeness. ~Brad Original Message Subject: Re: Internet Explorer and @ signs in link text From: Scott Brady dsbr...@gmail.com Date: Thu, November 19, 2009 9:55 pm To: cf-talk cf-talk@houseoffusion.com The problem isn't that it's breaking the URL. It's that the @ sign in the _text_ of the link (i.e., the text displayed on screen that the user clicks on) is causing the mess-up in the link (so that the URL is displayed as the link instead).. So, if we URL encode the @ symbol with %40, the user will actually see L%40%40K! instead of L@@K. ~| 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:328567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting an AJAX response to coldfusion object
a) if I don't specify returnFormat in my CFC, what format does cfgrid data come back as? (JSON, WDDX?). A naked call to a CFC usually returns WDDX. However, if you are binding to it with a cfgrid, returnformat=json is probably being added to the URL. b) how can I convert the javascript object into a coldfusion object? You don't. At least, not on the client side you don't. c) or should I be doing something totally different :-) Yes, I think you are barking up wrong creek with your paddle. If you want you export the data to Excel I think you should make regular call back to the server (not ajax) and that call should return an Excel file for the browser to handle however it saw fit. The Excel can be generated by simply outputting HTML tables and using cfcontent to tell the browser what it is, or you can get a native Excel file with Ben Nadel's POI utility or CFSpreadsheet if you are on CF9. The trick is that you probably want your current CFC you are using for your ajax call to be reusable so you don't have your query in two places. You can do this by having the actual call in a service that both your Ajax CFC and your export to Excel page call so both views are using the same service. Depending on what your Ajax CFC returns, you might be able to simply invoke and get its results back as a native CF result set in your Excel export page. The nice thing about CF is the eleventy billion ways you can get different data back from the same CFC. ~Brad ~| 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:328568 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 and MS Access support
GoDaddy doesn't support Access databases on on Windows IIS 7 accounts running ColdFusion. They support neither Access nor Coldfusion on their Grid Web Hosting accounts. If she will log into her GoDaddy account, go to the help center and search on Coldfusion, there are several articles that address this, and each has a link that will let her check her account to see if Access and/or Coldfusion are supported. On Thu, Nov 19, 2009 at 5:17 AM, Stephens, Larry V steph...@indiana.edu wrote: I'm helping someone with a project and she elected to use GoDaddy as her host. They now tell her they have upgraded to the latest version of CF and it no longer supports MS Access databases. Have I missed something? This is news to me. ~| 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:328569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Converting an AJAX response to coldfusion object
see if this helps: http://www.coldfusionjedi.com/index.cfm/2007/9/4/Exporting-from-CFGRID Azadi Saryev On 20/11/2009 11:32, Developer MediaDoc wrote: Hi all, I am probably not using the correct 'language' here -- forgive me new to the AJAX world. I have a lovely cfgrid populated by binding it to a CFC. Everything works great. I have some 'filters' that let the users filter the data in the grid. Now the client has asked to have a 'download grid data to excel.' I've done this many times in the past - just not with AJAX data. Now I am stuck. The data is in a javascript object, which I'd like to convert to a coldfusion object. I've tried statements like cfset cfData=DeserializeJSON(theData) and I've set 'theData' via javascript like var theData= ColdFusion.Grid.getGridObject('resource_list'); But I keep getting errors on variable theData not found. a) if I don't specify returnFormat in my CFC, what format does cfgrid data come back as? (JSON, WDDX?). b) how can I convert the javascript object into a coldfusion object? c) or should I be doing something totally different :-) I am missing something -- help/suggestions much appreciated! Cheers, Matts ~| 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:328570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Amazon S3 - HTTPS and Live Stats
At this point in time, no. Our business is confined to the US and CAN so I'm not too worried about people on the other side of the world. I'm making bet that the latency will be acceptable for this continent. Of course, please tell if you have found otherwise, or have a really good reason for me to begin considering cloud front again. Also, it doubled the price from what I could tell. (Not that it was that expensive to begin with). However I was vaguely annoyed at the lack of specifics regarding what bandwidth I have to pay for so I could have been calculating incorrectly. For instance, someone hits a 5 GB file through cloud front, so I have to pay for S3 bandwidth as well as cloud front bandwidth right? (That's where the twice as expensive part comes in) If I have 5 end points in the US, and someone downloads the file from each one, would I pay for 10 times the bandwidth of the file (instead of 5 times) to allow for it to be copied to each end point? Now my understanding is that is is cached now at the points. So if someone hits it again from the same end point, do I pay for both bandwidths again, or just the end point bandwidth. How long is it cached for? How do I refresh the cache? I quickly ended up with more questions than answers on the cloud front and it didn't seem worth the money so I sort of just left it. My understanding is that you would not have to pay for end-user access to S3 content if you're using Cloudfront. You'd pay for end-user access to that content via Cloudfront, and you'd have to pay the normal S3 upload and storage fees for your own access to your bucket. That said, I would not bet the farm on my understanding here, as I haven't really looked that closely at Cloudfront yet. Hmm, it would be interesting if Cloud Front solved that, but I don't know why Cloud Front wouldn't suffer from the same problems that the S3 domains do. I'm curious why they won't simply let you set up a domain or subdomain and resolve it to an IP address on their end that was mapped to your bucket. Then if you own a wild card cert (which we do) they let you install that cert on their servers so it truly is your domain and your cert. Of course, all that may very well be easier said than done. Especially since that would take a lot of IP addresses, and it would tie you to a specific server on their end. Well, I don't know if it solves that problem or not, but because this service is aimed specifically at HTTP usage for end-users of a web site, I wouldn't be too surprised if they had. S3 really is just general-purpose storage, and just because you get to it via HTTP doesn't mean they've spent a lot of time figuring out how to make it work well for HTTP end-user access. 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 m ~| 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:328571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Amazon S3 - HTTPS and Live Stats
My understanding is that you would not have to pay for end-user access to S3 content if you're using Cloudfront. You'd pay for end-user access to that content via Cloudfront, and you'd have to pay the normal S3 upload and storage fees for your own access to your bucket. That said, I would not bet the farm on my understanding here, as I haven't really looked that closely at Cloudfront yet. Well, it's a good thing you kept the farm out of the chip pile. :) I went back and re-read all the CloudFront stuff. Here are the highlights: Amazon CloudFront uses Amazon S3 as the origin server to store the original, definitive versions of your files. Normal fees will apply for Amazon S3 usage, including âorigin fetchesâ â data transferred from Amazon S3 to edge locations. and... Copying objects to edge locations When Amazon CloudFront receives a request for an object it doesnât already have at an edge location, it makes a standard GET request back to Amazon S3. You incur the normal Amazon S3 charges for GET requests and for data transfer out; the charges appear in the Amazon S3 portion of your AWS statement. On the topic of caching: ...when space is needed at an edge location, the service will remove less popular objects in order to make room for more popular ones. This means that objects that arenât accessed frequently are less likely to remain in CloudFrontâs edge locationsâ caches. Thus, for less popular objects, delivery out of Amazon S3 (rather than from CloudFront) is the better choice. Amazon S3 will provide strong distribution performance for these objects, and serving them directly from Amazon S3 saves you the cost of continually copying less popular objects from Amazon S3 to the edge locations in CloudFront. So it looks like CloudFront works best for objects that are accessed a lot. (duh) However, an object that was accessed infrequently might incur you additional charges because it is continually being copied back to the edge location. Not to mention that would defeat the purpose of the edge location since the transfer would have to come from the S3 servers. What the docs DON'T tell me is what other objects mine have to compete with to stay cached at an edge location. If I was sharing an edge location with a LOT of frequently accessed files from other customers, my object would probably experience more evictions than at a sleepier location. Well, I don't know if it solves that problem or not, but because this service is aimed specifically at HTTP usage for end-users of a web site, I wouldn't be too surprised if they had. Ok, ready for something funny? I dredged Google some more and reality turns out to be the opposite of that. In fact, CloudFront has NO SSL support. None. They encourage you to use S3 for all your HTTPS traffic. Heh --so much for their service aimed specifically at HTTP usage. :) http://developer.amazonwebservices.com/connect/thread.jspa?threadID=26488start=15tstart=0 What's worse is one site claimed that CloudFront allows you to use up to 10 CNAMEs per distribution where S3 only allows one per bucket. (I needed at least 2) Well I guess I'm darned if I use S3 and darned it I used CloudFront. lol http://www.bucketexplorer.com/documentation/cloudfront--amazon-s3-vs-amazon-cloudfront.html I like the Amazon Web Services, but they have had a continual string of pretty big gotcha's-- like lack of server affinity support (sticky sessions) in their EC2 cloud. At least it's very cheap to sign up for and experiment with since there are no upfront contracts! ~Brad ~| 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:328572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4