RE: Sending File Data Over Webservice
Morning Mark, That's an excellent and thorough answer, thanks. It's nice to see someone who has tried this kind of approach themselves and got a little experience with it. I like this idea of issuing a token for the files, that's quite neat. Another great little idea is delivering the files using cfcontent which means they don't have to be web accessible, this is a very nice security factor, I like it a great deal. What are the overheads like on using cfcontent to deliver a file opposed to simply having it available in a web accessible directory? Cheers Mark, Robert -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: 27 February 2008 21:19 To: CF-Talk Subject: RE: Sending File Data Over Webservice Robert, We have a web service used for the state of California that wraps image files up as base64 - exactly as you suggest below. The image files are obviously much smaller than media files (mostly less than half a meg), but I can tell you that you are on the right track thinking that it is a resource intensive way to go. If we were doing larger files we would probably use something much dumber than a web service (also as you suggest) - a URL to retrieve the file via HTTP. Of course you can pass a token or something that is good for only 1 retrieval and then serve the file from a location outside the web root (for security). You could also zip it. But after zipping and using cfcontent and checking credentials you now have a second request that could be resource intensive as well. The bottom line is that there is no great low resource way to securely send files around in an SOA type architecture. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Robert Rawlins [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 27, 2008 2:48 PM To: CF-Talk Subject: Sending File Data Over Webservice Hello Guys, I'm after a little advice on refactoring a web service which I have running on one of my applications. The webservice isnt a standard ColdFusion webservice running over SOAP, this is a custom REST service which simply recieves POST data into the FORM scope and then spits back an XML document for the client to read. Now, I basicly offer a bunch of multimedia content over this webservice, anything from text, through to images, sound and video. With the current setup, when a request is made to the service for a particular piece or set of multimedia, the media is zipped on the server into an archive file, the binary data of which is then read into a base64 encoded string and this is then passed back to the client wrapped in some XML over the web service. The challenge I meet with this is not knowing how to weigh up the cost of bandwidth and security against the load hit this causes on the server. See, at the moment, with zipping the content I'm saving a substantial amount of bandwidth, also with zipping the files and sending them as a string I have the ability to be able to produce a HASH key checksum for the file, then when the file arrives the other end, the client can rebuild the file and checksum to make sure all is alive and well after the transmition. Now, the real downside to this option is that it must be hungry on the system, all the checksumming and zipping must be making some form of performance hit, right? especialy on what will likely become a very busy little web service in the comming months. My other planned method of attack is to not pass the files through the webservice at all, but simply pass a web accessible path for them, the client application could then simply loop through the returned XML and make http requests to download the media, this would obviously up the bandwidth but does offer less load involved with compressing the media. I'm sorry the question isnt a little more specific about what I'm asking, I'm just thinking out loud really, hoping somone will chime in and offer thier thoughts. How would you tackle this challenge? what would your priority be? bandwidth or reducing the load on the server? is it plausable to offer a checksum solution even if we're not sending the binary data over the service directly so we can still offer that level of security without the overhead of the zipping? I'm looking for the best ballance. I'd be interested to get your thoughts. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sending File Data Over Webservice
What are the overheads like on using cfcontent to deliver a file opposed to simply having it available in a web accessible directory? Significant, in my past experience. The CFCONTENT request monopolizes a CF thread for the duration of the download. As an alternative, you might consider creating temporary URLs; you can easily do this on Unix using symlinks. You can create symlinks to directories in Windows, and that might be sufficient also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sending File Data Over Webservice
Thanks Dave, Unix? What's that? Heh, I'm only pulling your leg, I know what Unix is. I thought that cfcontent would be an intensive little monkey, it doesn't surprise me to hear you've found that in the past, it's nice to have that confirmation. I think my real goal with this is to keep it as unintensive as possible, I mean, keeping the files hidden from web access isn't the absolute end of the world, if people view and download them it has no real consequence, other than eating all my bandwidth, however, all the files are stored with a UUID as the name so it's not as if people will stumble across them by accident. One thing I'm considering as an option at the moment is maintaining the theory of passing the binary data back over a webservice, however, cutting out the compression, at least this makes the load on the server a little less and it's just the bandwidth which is going to take a bit of a hit, maybe 10-20% or something like that, quite manageable though. What do you think, does that sound a solution? Or would you still look around at the idea of making files temporarily accessible? Robert -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 28 February 2008 09:07 To: CF-Talk Subject: RE: Sending File Data Over Webservice What are the overheads like on using cfcontent to deliver a file opposed to simply having it available in a web accessible directory? Significant, in my past experience. The CFCONTENT request monopolizes a CF thread for the duration of the download. As an alternative, you might consider creating temporary URLs; you can easily do this on Unix using symlinks. You can create symlinks to directories in Windows, and that might be sufficient also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help with Rewrite Rule! (circuit.fuseaction)
Hi guys, I have one more questions on this topic. I've added a handful of rules and they work however all of the images on the site are broken. I have a virtual directory in IIS for my site called images and all the img tags on my pages start with for ex: images/foldername/imagename.gif. I don't want to change all the img tags in my site to http://domainname/images/etcetc..; Is there a better solution.. Your help on this matter are much appreciated. Regards, cfcoder Oops... Didn't see Barney's reply... weird that when you click on the Archive link it only bring up a single message, not the whole thread. Russ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
JRun Clustering problem - Instance keeps shutting down
Hi there, We've been having a lot of problems recently with one of our Cluster instances whereby it keeps either shutting itself down or starts to reject threads. There isn't a set pattern to when this happens but it is only happening on one instance (we have four in total separated 50/50 on two servers). When JRun starts rejecting requests we're seeing this kind of thing in the logs: 27/02 10:44:01 metrics Web threads (busy/total): 0/10 Sessions: 4520 Total Memory=65472 Free=8732 27/02 10:45:01 metrics Web threads (busy/total): 0/11 Sessions: 4515 Total Memory=56320 Free=8533 27/02 10:46:01 metrics Web threads (busy/total): 1/10 Sessions: 4512 Total Memory=57600 Free=7505 27/02 10:47:01 metrics Web threads (busy/total): 0/10 Sessions: 4518 Total Memory=57920 Free=6622 27/02 10:48:01 metrics Web threads (busy/total): 1/10 Sessions: 4503 Total Memory=57216 Free=9725 27/02 10:49:01 metrics Web threads (busy/total): 0/10 Sessions: 4501 Total Memory=54976 Free=7224 27/02 10:50:01 metrics Web threads (busy/total): 0/9 Sessions: 4431 Total Memory=61376 Free=12289 27/02 10:50:41 info Clusterable service JRunProxyClusterHelper successfully removed a peer when that peer left the cluster 27/02 10:51:01 metrics Web threads (busy/total): 0/9 Sessions: 4413 Total Memory=56832 Free=11473 27/02 10:52:01 metrics Web threads (busy/total): 0/9 Sessions: 4377 Total Memory=56064 Free=11637 27/02 10:53:01 metrics Web threads (busy/total): 0/9 Sessions: 4341 Total Memory=53504 Free=11657 27/02 10:54:02 metrics Web threads (busy/total): 0/9 Sessions: 4300 Total Memory=53568 Free=11636 27/02 10:55:02 metrics Web threads (busy/total): 0/9 Sessions: 4263 Total Memory=53568 Free=11543 27/02 10:56:02 metrics Web threads (busy/total): 0/1 Sessions: 4213 Total Memory=53504 Free=11598 27/02 10:57:02 metrics Web threads (busy/total): 0/1 Sessions: 4173 Total Memory=52544 Free=11585 27/02 10:58:02 metrics Web threads (busy/total): 0/1 Sessions: 4132 Total Memory=52608 Free=11501 27/02 10:59:02 metrics Web threads (busy/total): 0/1 Sessions: 4089 Total Memory=52608 Free=11370 27/02 11:00:02 metrics Web threads (busy/total): 0/1 Sessions: 4051 Total Memory=52608 Free=11454 27/02 11:01:02 metrics Web threads (busy/total): 0/1 Sessions: 4014 Total Memory=52096 Free=11537 27/02 11:02:02 metrics Web threads (busy/total): 0/1 Sessions: 3967 Total Memory=52096 Free=11190 .so note that JRun rejects the instance from the cluster but the logs carry on. Also note that the Web Threads just carry on as 0/1 until the instance is started up again. The frequency of this has started to increase and we're now getting this at least once a day. The server is a virtual machine, Win Server 2003, CF7.0 with multiserver JRun. We have it setup on Round Robin with sticky sessions. Just to give you a breakdown on what we've tried already The problem started on the 29th of Jan this year and looking at our logs nothing has changed on or around this time apart from an upgrade to our backup software on the other working server. So I wouldn't expect this to effect the one that is now faulty. We started to add Hotfixes to the server on the 5th of Feb but this hasn't resolved the problem. These included JRun Updater 7 and CF HotFix 3 which had stability fixes for clustering. This was applied to both servers. Checking logs in IIS I'm not seeing anything abnormal. We've compared the setup of the failing instance to the other server instance and apart from a few unique configuration settings both are identifical in JRun. We are considering the option of rebuilding the instance using the working one but to be honest that drawing at straws. Has anybody else had a similar kind of problem or can think of any other ideas as to what might be causing this. Your help would be appreciated and if there is anymore information you need please let me know. Cheers, James ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JRun Clustering problem - Instance keeps shutting down
Hi there, We've been having a lot of problems recently with one of our Cluster instances whereby it keeps either shutting itself down or starts to reject threads. There isn't a set pattern to when this happens but it is only happening on one instance (we have four in total separated 50/50 on two servers). When JRun starts rejecting requests we're seeing this kind of thing in the logs: 27/02 10:44:01 metrics Web threads (busy/total): 0/10 Sessions: 4520 Total Memory=65472 Free=8732 27/02 10:45:01 metrics Web threads (busy/total): 0/11 Sessions: 4515 Total Memory=56320 Free=8533 27/02 10:46:01 metrics Web threads (busy/total): 1/10 Sessions: 4512 Total Memory=57600 Free=7505 27/02 10:47:01 metrics Web threads (busy/total): 0/10 Sessions: 4518 Total Memory=57920 Free=6622 27/02 10:48:01 metrics Web threads (busy/total): 1/10 Sessions: 4503 Total Memory=57216 Free=9725 27/02 10:49:01 metrics Web threads (busy/total): 0/10 Sessions: 4501 Total Memory=54976 Free=7224 27/02 10:50:01 metrics Web threads (busy/total): 0/9 Sessions: 4431 Total Memory=61376 Free=12289 27/02 10:50:41 info Clusterable service JRunProxyClusterHelper successfully removed a peer when that peer left the cluster 27/02 10:51:01 metrics Web threads (busy/total): 0/9 Sessions: 4413 Total Memory=56832 Free=11473 27/02 10:52:01 metrics Web threads (busy/total): 0/9 Sessions: 4377 Total Memory=56064 Free=11637 27/02 10:53:01 metrics Web threads (busy/total): 0/9 Sessions: 4341 Total Memory=53504 Free=11657 27/02 10:54:02 metrics Web threads (busy/total): 0/9 Sessions: 4300 Total Memory=53568 Free=11636 27/02 10:55:02 metrics Web threads (busy/total): 0/9 Sessions: 4263 Total Memory=53568 Free=11543 27/02 10:56:02 metrics Web threads (busy/total): 0/1 Sessions: 4213 Total Memory=53504 Free=11598 27/02 10:57:02 metrics Web threads (busy/total): 0/1 Sessions: 4173 Total Memory=52544 Free=11585 27/02 10:58:02 metrics Web threads (busy/total): 0/1 Sessions: 4132 Total Memory=52608 Free=11501 27/02 10:59:02 metrics Web threads (busy/total): 0/1 Sessions: 4089 Total Memory=52608 Free=11370 27/02 11:00:02 metrics Web threads (busy/total): 0/1 Sessions: 4051 Total Memory=52608 Free=11454 27/02 11:01:02 metrics Web threads (busy/total): 0/1 Sessions: 4014 Total Memory=52096 Free=11537 27/02 11:02:02 metrics Web threads (busy/total): 0/1 Sessions: 3967 Total Memory=52096 Free=11190 .so note that JRun rejects the instance from the cluster but the logs carry on. Also note that the Web Threads just carry on as 0/1 until the instance is started up again. The frequency of this has started to increase and we're now getting this at least once a day. The server is a virtual machine, Win Server 2003, CF7.0 with multiserver JRun. We have it setup on Round Robin with sticky sessions. Just to give you a breakdown on what we've tried already The problem started on the 29th of Jan this year and looking at our logs nothing has changed on or around this time apart from an upgrade to our backup software on the other working server. So I wouldn't expect this to effect the one that is now faulty. We started to add Hotfixes to the server on the 5th of Feb but this hasn't resolved the problem. These included JRun Updater 7 and CF HotFix 3 which had stability fixes for clustering. This was applied to both servers. Checking logs in IIS I'm not seeing anything abnormal. We've compared the setup of the failing instance to the other server instance and apart from a few unique configuration settings both are identifical in JRun. We are considering the option of rebuilding the instance using the working one but to be honest that drawing at straws. Has anybody else had a similar kind of problem or can think of any other ideas as to what might be causing this. Your help would be appreciated and if there is anymore information you need please let me know. Cheers, James ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion 8 ODBC Server ErrorCode=2300 connection unexpectedly closed by peer
The description for Event ID ( 0 ) in Source ( ColdFusion 8 ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion 8 ODBC [EMAIL PROTECTED],ErrorCode=2300,ErrorMessage=Network problem, connection unexpectedly closed by peer. Please advice how we can get rid of these events. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
emails stop being sent by CF
For no apparent reason, emails stop being sent by CF. This has happened on more than one server. This same issue was mentioned here as well: http://groups.google.com/group/macromedia.coldfusion.server_administration/browse_thread/thread/33edf401eb8a6f11/a4eb4efb1190589e Please advice. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Prevent users from voting twice.
Hey guys, I've been spending practically every free moment of my time the past few months working on a project--and I've gotten some valuable help from the community here. Anyway, here I am again to ask for help :) I'm not going to go and explain the project right now, but the part for which I require assistance is the voting system. Basically, the user clicks on the voting icon (sends them to the processor page), and by means of URL querystring, the number of points is added to the database. Now, it would be overly simple for the user to click on the three-points icon 200 times, and totally mess up my results. Therefore, I obviously want to make some type of system that can stop the user from voting more than once. It doesn't have to be superbly secure--but as secure as possible. I was thinking by means of IP address and/or cookies. What is your thought on this? Please tell me as well how I would code whatever option you give me, as I was trying to do the IP adress option, but I kept getting stuck. My thought was that the user's IP would be logged into the database, and whenever they vote again, a query would get all the IP addresses logged for that video. Then, it would check if the client's IP is in the results of that query. But...I don't know how to check one IP against all the IPs that have voted. I'm sure it's a basic syntax, but it just isn't coming to me. Anyway, please give me your advice and code if possible for how to prevent a user from voting twice. Thanks, George L. P.S. This is kind of time sensitive. Any help you can give would be great. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sending File Data Over Webservice
Daves right... Although cfcontent won't be as bad as opening the file as binary, encoding as base64 and then creating a vary large XML packet. I have never used the symlink idea - although I've heard him mention it before. I'd be interested in a code snippet on how to do this on the fly in Linux. Would you have to pass arguments to a shell script Dave? -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 3:07 AM To: CF-Talk Subject: RE: Sending File Data Over Webservice What are the overheads like on using cfcontent to deliver a file opposed to simply having it available in a web accessible directory? Significant, in my past experience. The CFCONTENT request monopolizes a CF thread for the duration of the download. As an alternative, you might consider creating temporary URLs; you can easily do this on Unix using symlinks. You can create symlinks to directories in Windows, and that might be sufficient also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: emails stop being sent by CF
Hi Piet The spool may have stopped processing - I wrote a UDF for such a problem give this a whurl. http://www.cflib.org/udf.cfm?id=1511 HTH Jose Diaz On Thu, Feb 28, 2008 at 10:46 AM, Piet Bruins [EMAIL PROTECTED] wrote: For no apparent reason, emails stop being sent by CF. This has happened on more than one server. This same issue was mentioned here as well: http://groups.google.com/group/macromedia.coldfusion.server_administration/browse_thread/thread/33edf401eb8a6f11/a4eb4efb1190589e Please advice. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Prevent users from voting twice.
The simplest way to do this is through a cookie. You can't lock down an IP as this is something that may not be unique to them. (e.g. AOL) If they block cookies don't let them vote. If they vote, clear cookies, vote again, so be it. If you want to prevent that, ask them to login/register (with email confirm) but expect a far lower voting numbers (but better quality). You just cannot rely on an IP though. You can have the situation that the IP number changes between voting page display and actual vote being submitted. Adam George Linderman wrote: Hey guys, I've been spending practically every free moment of my time the past few months working on a project--and I've gotten some valuable help from the community here. Anyway, here I am again to ask for help :) I'm not going to go and explain the project right now, but the part for which I require assistance is the voting system. Basically, the user clicks on the voting icon (sends them to the processor page), and by means of URL querystring, the number of points is added to the database. Now, it would be overly simple for the user to click on the three-points icon 200 times, and totally mess up my results. Therefore, I obviously want to make some type of system that can stop the user from voting more than once. It doesn't have to be superbly secure--but as secure as possible. I was thinking by means of IP address and/or cookies. What is your thought on this? Please tell me as well how I would code whatever option you give me, as I was trying to do the IP adress option, but I kept getting stuck. My thought was that the user's IP would be logged into the database, and whenever they vote again, a query would get all the IP addresses logged for that video. Then, it would check if the client's IP is in the results of that query. But...I don't know how to check one IP against all the IPs that have voted. I'm sure it's a basic syntax, but it just isn't coming to me. Anyway, please give me your advice and code if possible for how to prevent a user from voting twice. Thanks, George L. P.S. This is kind of time sensitive. Any help you can give would be great. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Prevent users from voting twice.
Okay, got it. Thank you. Yeah, I was wondering if IPs were not going to work...but didn't know that they were *that* unreliable. How exactly would I implement the cookie option? I don't have any experience with cookies, aside from knowing that they are little files on the user's computer. Would I want to make a new cookie for each vote? Or would that clutter up the user's system in a bad way? In other words, can you point me in the right direction code-wise regarding these cookies? Also, for theoretical purposes, is there any other way at all to uniquely identify the user? I mean, do we as coders have access to logging the user's MAC address on the NIC, or something like that? Or to make it more secure I'd just have to make it with a log in and such. The simplest way to do this is through a cookie. You can't lock down an IP as this is something that may not be unique to them. (e.g. AOL) If they block cookies don't let them vote. If they vote, clear cookies, vote again, so be it. If you want to prevent that, ask them to login/register (with email confirm) but expect a far lower voting numbers (but better quality). You just cannot rely on an IP though. You can have the situation that the IP number changes between voting page display and actual vote being submitted. Adam George Linderman wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun Clustering problem - Instance keeps shutting down
I don't know if it is of any help, but when one of our instances stops receiving any requests, it takes a IIS restart to pick it up again. Bouncing the instance has no effect On Thu, Feb 28, 2008 at 7:02 PM, James Buckingham [EMAIL PROTECTED] wrote: Hi there, We've been having a lot of problems recently with one of our Cluster instances whereby it keeps either shutting itself down or starts to reject threads. There isn't a set pattern to when this happens but it is only happening on one instance (we have four in total separated 50/50 on two servers). When JRun starts rejecting requests we're seeing this kind of thing in the logs: 27/02 10:44:01 metrics Web threads (busy/total): 0/10 Sessions: 4520 Total Memory=65472 Free=8732 27/02 10:45:01 metrics Web threads (busy/total): 0/11 Sessions: 4515 Total Memory=56320 Free=8533 27/02 10:46:01 metrics Web threads (busy/total): 1/10 Sessions: 4512 Total Memory=57600 Free=7505 27/02 10:47:01 metrics Web threads (busy/total): 0/10 Sessions: 4518 Total Memory=57920 Free=6622 27/02 10:48:01 metrics Web threads (busy/total): 1/10 Sessions: 4503 Total Memory=57216 Free=9725 27/02 10:49:01 metrics Web threads (busy/total): 0/10 Sessions: 4501 Total Memory=54976 Free=7224 27/02 10:50:01 metrics Web threads (busy/total): 0/9 Sessions: 4431 Total Memory=61376 Free=12289 27/02 10:50:41 info Clusterable service JRunProxyClusterHelper successfully removed a peer when that peer left the cluster 27/02 10:51:01 metrics Web threads (busy/total): 0/9 Sessions: 4413 Total Memory=56832 Free=11473 27/02 10:52:01 metrics Web threads (busy/total): 0/9 Sessions: 4377 Total Memory=56064 Free=11637 27/02 10:53:01 metrics Web threads (busy/total): 0/9 Sessions: 4341 Total Memory=53504 Free=11657 27/02 10:54:02 metrics Web threads (busy/total): 0/9 Sessions: 4300 Total Memory=53568 Free=11636 27/02 10:55:02 metrics Web threads (busy/total): 0/9 Sessions: 4263 Total Memory=53568 Free=11543 27/02 10:56:02 metrics Web threads (busy/total): 0/1 Sessions: 4213 Total Memory=53504 Free=11598 27/02 10:57:02 metrics Web threads (busy/total): 0/1 Sessions: 4173 Total Memory=52544 Free=11585 27/02 10:58:02 metrics Web threads (busy/total): 0/1 Sessions: 4132 Total Memory=52608 Free=11501 27/02 10:59:02 metrics Web threads (busy/total): 0/1 Sessions: 4089 Total Memory=52608 Free=11370 27/02 11:00:02 metrics Web threads (busy/total): 0/1 Sessions: 4051 Total Memory=52608 Free=11454 27/02 11:01:02 metrics Web threads (busy/total): 0/1 Sessions: 4014 Total Memory=52096 Free=11537 27/02 11:02:02 metrics Web threads (busy/total): 0/1 Sessions: 3967 Total Memory=52096 Free=11190 .so note that JRun rejects the instance from the cluster but the logs carry on. Also note that the Web Threads just carry on as 0/1 until the instance is started up again. The frequency of this has started to increase and we're now getting this at least once a day. The server is a virtual machine, Win Server 2003, CF7.0 with multiserver JRun. We have it setup on Round Robin with sticky sessions. Just to give you a breakdown on what we've tried already The problem started on the 29th of Jan this year and looking at our logs nothing has changed on or around this time apart from an upgrade to our backup software on the other working server. So I wouldn't expect this to effect the one that is now faulty. We started to add Hotfixes to the server on the 5th of Feb but this hasn't resolved the problem. These included JRun Updater 7 and CF HotFix 3 which had stability fixes for clustering. This was applied to both servers. Checking logs in IIS I'm not seeing anything abnormal. We've compared the setup of the failing instance to the other server instance and apart from a few unique configuration settings both are identifical in JRun. We are considering the option of rebuilding the instance using the working one but to be honest that drawing at straws. Has anybody else had a similar kind of problem or can think of any other ideas as to what might be causing this. Your help would be appreciated and if there is anymore information you need please let me know. Cheers, James ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun Clustering problem - Instance keeps quot;shutting downquot;
Thanks AJ. Is that the give it a kick approach :-) We actually had a phase before all this started where IIS stopped processing requests and then very kindly jammed up both server instances, stopping the site completely. It wasn't until we restarted it or the server that it would release the other instance. We've not had an IIS-related problem now since the 24th of January so I don't think this is related to that. That and the fact that JRun is actually telling us that it's dropping the instance while IIS shows normal activity. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun Clustering problem - Instance keeps quot;shutting downquot;
Thanks AJ. Is that the give it a kick approach :-) We actually had a phase before all this started where IIS stopped processing requests and then very kindly jammed up both server instances, stopping the site completely. It wasn't until we restarted it or the server that it would release the other instance. We've not had an IIS-related problem now since the 24th of January so I don't think this is related to that. That and the fact that JRun is actually telling us that it's dropping the instance while IIS shows normal activity. Cheers, James I don't know if it is of any help, but when one of our instances stops receiving any requests, it takes a IIS restart to pick it up again. Bouncing the instance has no effect On Thu, Feb 28, 2008 at 7:02 PM, James Buckingham [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Prevent users from voting twice.
The problem with using IPs or cookies to assure only one vote is that you're not assuring only one person vote, by one machine vote. When a machine is in a shared environment (school labs, libraries, one machine for a family), that machine will only get one vote. If that's fits your audience then that's okay. I've often wondered if then I should replace any vote with a new vote. In other words, make the most recent vote the one that is kept, rather than the first vote. Otherwise, you could have them enter an email address, which is closer to unique though still shared at times. Or log in using a unique id. -- Daniel Kessler University of Maryland College Park School of Public Health 3302E HHP Building College Park, MD 20742-2611 Phone: 301-405-2545 http://sph.umd.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Signature Capture
Just a note for future searchers- I am still looking into the PDF solution, but I found something that might do the trick. I am using the applet mentioned and linked below to collect a signature. It will basically hand out a series of coordinates representing the signature. These coordinates can be saved in the database and easily reconstituted using CF 8's image manipulation functions (ImageDrawLines(myImage,x,y)) to recreate the coordinates as an image which can be rolled into a PDF, printed, whatever... This seems to work pretty well. E -Original Message- From: E C list [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 27, 2008 1:13 PM To: CF-Talk Subject: RE: Signature Capture Thanks Gerald, Chris and Dave. I am not sure what route I am going to go with this, but both ideas are helpful. I downloaded that java applet and it works great...pretty cool and simple...it works well in firefox, I am not sure why, but it wouldn't load in Internet Explorer, probably some security thing. E -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Monday, February 25, 2008 2:14 PM To: CF-Talk Subject: Re: Signature Capture Here it is http://www.planet-source-code.com/URLSEO/vb/scripts/ShowCode!asp/txtCodeId!1 10/lngWid!9/anyname.htm On Mon, Feb 25, 2008 at 1:25 PM, Chris Jordan [EMAIL PROTECTED] wrote: I'm about to do a project where we'll be capturing signatures, and one member of the team says that he found a java applet that will capture signatures. We'll be running it on a PDA. I know nothing else about it (not even what it's called), I just know that my guy says he's found one. The point of this being that you may just want to look for something like what I'm describing here as another alternative. Good luck! Chris Dave Watts wrote: Has anyone come up with any good solutions that would let you embed a signature capture field in a form? This is for ColdFusion 8. The widget would appear at the bottom of a form contract and the hope would be that after the form was submitted it could be saved to a file on the server or made a part of a pdf. There is also talk of using something like this to draw basic diagrams to attach to a contact's record. You would need to use a PDF form to capture the signature. The PDF form containing the signature field can be appended to another PDF form containing the other form fields, if you want to do that, using CFPDFFORM. To work effectively with signatures, your PDF would have to post itself, not just the form data it contains, to your CF server. Then, in the action page, you'd be able to reference the PDF scope. This exact thing is covered in this class: http://training.figleaf.com/Courses/movingtocoldfusion8.cfm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Prevent users from voting twice.
Well ask yourself at what level would you like to be uniquely identified when visiting any website? I certainly don't want them to know my MAC address. Have a look at the cfcookie tag. Also be aware that cfcookie cannot be used with cflocation. The concept with cookies is : 1) Landing page checks that there is no votemade cookie set. Sets a cansetcookies cookie and redirects to voting page. 2) Voting page checks for the cansetcookies (redirects to the we use cookies page and that votemade is not set. 3) Vote is made and on the thank you page the votemade cookie is set. George Linderman wrote: Okay, got it. Thank you. Yeah, I was wondering if IPs were not going to work...but didn't know that they were *that* unreliable. How exactly would I implement the cookie option? I don't have any experience with cookies, aside from knowing that they are little files on the user's computer. Would I want to make a new cookie for each vote? Or would that clutter up the user's system in a bad way? In other words, can you point me in the right direction code-wise regarding these cookies? Also, for theoretical purposes, is there any other way at all to uniquely identify the user? I mean, do we as coders have access to logging the user's MAC address on the NIC, or something like that? Or to make it more secure I'd just have to make it with a log in and such. The simplest way to do this is through a cookie. You can't lock down an IP as this is something that may not be unique to them. (e.g. AOL) If they block cookies don't let them vote. If they vote, clear cookies, vote again, so be it. If you want to prevent that, ask them to login/register (with email confirm) but expect a far lower voting numbers (but better quality). You just cannot rely on an IP though. You can have the situation that the IP number changes between voting page display and actual vote being submitted. Adam George Linderman wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Interesting idea for next CF - thoughts...
Watch out for that though. I remember someone on this list who used to use the extends= attribute in their cfcomponent tags. That worked great until CF8 when Adobe actually implemented that attribute and all their code broke. :) ~Brad -Original Message- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 27, 2008 10:28 PM To: CF-Talk Subject: Re: Interesting idea for next CF - thoughts... When CF6 was introduced they allowed you to add whatever arbitrary attributes you want to cfcomponent, cffunction, cfargument and cfproperty tags so you could use that metadata via getMetaData() ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JRun Clustering problem - Instance keeps shutting down
That is probably because the JRun connector loaded in IIS is what divvies up the requests. ~Brad -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 6:38 AM To: CF-Talk Subject: Re: JRun Clustering problem - Instance keeps shutting down I don't know if it is of any help, but when one of our instances stops receiving any requests, it takes a IIS restart to pick it up again. Bouncing the instance has no effect ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JRun Clustering problem - Instance keeps quot;shutting downquot;
Is it possible there is a connectivity issue which is causing the JRun connectors (which are loaded on the IIS box and control load balancing) to think that instance is down? I don't know off the top of my head if there is a log file on the IIS box. ~Brad -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 7:17 AM To: CF-Talk Subject: Re: JRun Clustering problem - Instance keeps quot;shutting downquot; Thanks AJ. Is that the give it a kick approach :-) We actually had a phase before all this started where IIS stopped processing requests and then very kindly jammed up both server instances, stopping the site completely. It wasn't until we restarted it or the server that it would release the other instance. We've not had an IIS-related problem now since the 24th of January so I don't think this is related to that. That and the fact that JRun is actually telling us that it's dropping the instance while IIS shows normal activity. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Interesting idea for next CF - thoughts...
Watch out for that though. I remember someone on this list who used to use the extends= attribute in their cfcomponent tags. That worked great until CF8 when Adobe actually implemented that attribute and all their code broke. :) You mean with an empty value? -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Interesting idea for next CF - thoughts...
They didn't use an empty value. They put in cfc names and/or notes as to what other component that component extended. Of course, the values they had been putting in there were not valid for CF8. The empty quotes were the lines your imagination was supposed to go between. ~Brad -Original Message- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 8:24 AM To: CF-Talk Subject: Re: Interesting idea for next CF - thoughts... Watch out for that though. I remember someone on this list who used to use the extends= attribute in their cfcomponent tags. That worked great until CF8 when Adobe actually implemented that attribute and all their code broke. :) You mean with an empty value? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How do I change my localhost setting in CF 8?
Got it working, Dave... thanks! Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 27, 2008 11:54 PM To: CF-Talk Subject: RE: How do I change my localhost setting in CF 8? I tried changing the web-inf/jrun-web.xml file to add a virtual directory mapping. I decided to try that first rather than move the entire wwwroot. I created the following entry: virtual-mapping resource-path/webroot/*/resource-path system-pathE:/Inetpub/webroot/system-path /virtual-mapping But I get a browser message that the page can't be displayed when I try both http://webroot/his-anointing/index.cfm or http://webroot:8500/his-anointing/index.cfm If I move the his-anointing directory under the wwwroot directory in the ColdFusion 8 directory then I can bring up the page. Does this mean I'm going to have to change the resource path for localhost and relocate the CFIDE files, etc, now in the ColdFusion 8 directory, to be able to resolve: http://localhost:8500/his-anointing/index.cfm? If your web root directory is e:\inetpub\wwwroot, you don't want to create a virtual directory mapping pointing to that, because those refer to subdirectories of the web root, not the root itself. In your URLs above, webroot is not a hostname, so that won't resolve. The virtual mapping you created would map this URL: http://localhost:8500/webroot/ to the directory: e:\inetpub\wwwroot I don't think that's what you want. As for relocating the CFIDE files, etc, you could simply create virtual directories pointing to those, if you didn't want to move them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 ODBC Server ErrorCode=2300 connection unexpectedly closed by peer
Piet Bruins wrote: The description for Event ID ( 0 ) in Source ( ColdFusion 8 ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion 8 ODBC [EMAIL PROTECTED],ErrorCode=2300,ErrorMessage=Network problem, connection unexpectedly closed by peer. Don't use ODBC. quote JDBC-ODBC bridge ... Adobe does not recommend this driver type unless your application requires DBMS-specific features. /quote http://livedocs.adobe.com/coldfusion/8/htmldocs/datasources_ADV_MJS_02.html#1261469 Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JRun Clustering problem - Instance keeps quot;shutting downquot;
I just poked around my server a bit... Exactly what log file did you past from in the OP. If you have a dedicated IIS box and depending on your OS, I'm not sure if the directories will be the same, but do you have anything useful in these logs: C:\JRun4\lib\wsconfig\wsconfig.log C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard00.log In the last log, the 1 directory corresponds to the clusters set up in C:\JRun4\lib\wsconfig\wsconfig.properties. I obviously have IIS6, and the number on the end of the file name is auto-incrementing. ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 8:21 AM To: CF-Talk Subject: RE: JRun Clustering problem - Instance keeps quot;shutting downquot; Is it possible there is a connectivity issue which is causing the JRun connectors (which are loaded on the IIS box and control load balancing) to think that instance is down? I don't know off the top of my head if there is a log file on the IIS box. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Interesting idea for next CF - thoughts...
You mean 'extends=' didn't actually extend a CFC? Wow, then my code was working through magic and incantation all that time! Hot Damn, call the Enquirer! ;) Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Brad Wood wrote: They didn't use an empty value. They put in cfc names and/or notes as to what other component that component extended. Of course, the values they had been putting in there were not valid for CF8. The empty quotes were the lines your imagination was supposed to go between. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF scheduled jobs just stop running...
CF scheduled jobs that have run fine for days will sometimes just stop being run. There are no errors that we can find when this happens and the only indication of the issue (other than the jobs just not running) is that the scheduler.log file no longer shows [job name] Executing... lines for the job. Please advice. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: emails stop being sent by CF
For no apparent reason, emails stop being sent by CF. I'm having this problem about once a year. The problem is cause by an invalid file in the spool. I mean a file that contains no information that could make a valid message. This causes the spooler to loop indefinitely on the problem. The solution is to delete the first file in the spooler, then the rest should be sent. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Prevent users from voting twice.
George Linderman wrote: Okay, got it. Thank you. Yeah, I was wondering if IPs were not going to work...but didn't know that they were *that* unreliable. Well, think about this: Everyone in my office is behind the same router. So there are 7 people in this office who would show up as a single IP. Add to that that if I go home or use a proxy (like a free internet proxy, or the TOR system) I could vote many times. You can never completely eliminate the possibility of someone voting early and voting often, but using a registration system or cookies can make it more reliable. --Ben Doom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun Clustering problem - Instance keeps amp;quot;shutting downamp;quot;
The log file was from the failing instance. It was residing in the C:\JRuns\Logs\ folder. IIS is sitting on both boxes so I'm not sure if that classes as a dedicated IIS box. We have round robin on the DNS as well so requests are being passed to both boxes. I actually didn't know about those logs. You learn something new every day :-) Just looking at the same time as those previous logs these start 2 milliseconds after the failure notice. Nothing was happening in these logs for a few hours before this... C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 2008-02-27 10:50:43 jrISAPI[2192:6480] Sticky session breakage, a host for serving session 503042d9e2ad1a7e34287c18369f231a287aTR; __utma=228107678.392619640.1204109239.1204109239.1204109239.1; __utmb=228107678; __utmc=228107678; __utmz=228107678.1204109239.1.1.utmccn=(referral)|utmcsr=us.f352.mail.yahoo.com|utmcct=/ym/ShowLetter|utmcmd=referral not available. Failing over to another server, but above session is broken. 2008-02-27 10:50:45 jrISAPI[4052:6480] Sticky session breakage, a host for serving session 50302bd60c2496e669ee2155771f16362587TR not available. Failing over to another server, but above session is broken. 2008-02-27 10:50:52 jrISAPI[9760:6480] Sticky session breakage, a host for serving session 5030b494a4dd95871bb572701d10113ba365TR; __utma=228107678.629465025.1204106629.1204106629.1204106629.1; __utmb=228107678; __utmc=228107678; __utmz=228107678.1204106629.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none) not available. Failing over to another server, but above session is broken. C:\JRun4\lib\wsconfig\wsconfig.log - I'm not seeing anything on the 27th at that time. Does that help at all? Cheers for all your help, James I just poked around my server a bit... Exactly what log file did you past from in the OP. If you have a dedicated IIS box and depending on your OS, I'm not sure if the directories will be the same, but do you have anything useful in these logs: C:\JRun4\lib\wsconfig\wsconfig.log C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard00.log In the last log, the 1 directory corresponds to the clusters set up in C:\JRun4\lib\wsconfig\wsconfig.properties. I obviously have IIS6, and the number on the end of the file name is auto-incrementing. ~Brad downquot; Is it possible there is a connectivity issue which is causing the JRun connectors (which are loaded on the IIS box and control load balancing) to think that instance is down? I don't know off the top of my head if there is a log file on the IIS box. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT - SQL Union Problem
I'm not an SQL guru, so take this with a grain of salt: You could do a join on table1.firstname=table2.firstname and table1.firstname = table2.lastname to get all the results that match. You could union this to two unioned selects where there's an entry in table1 but not table2 and vice versa. You'll have to select empty strings for the columns that are only present in one or the other table. This should give you a result set where you either have the addresses from one, or the other, or both. You can make display (or further processing) decisions based on that. --Ben Doom Mark Henderson wrote: OK, so that was working, and those are the only two fields I want to union on, which is fine. But now I also want to add the address fields to the query result, without doing a union on those additional fields. Some addresses aren't entered quite right, and this will then create duplicates even though the query doesn't see them as such - does that make sense? So, for instance, when I do: SELECT FirstName1 AS FirstName, Surname1 AS LastName FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName FROM tblCentennialMembers; I get the result set I want. But if I do SELECT FirstName1 AS FirstName, Surname1 AS LastName. Add1, Add2, City, Country FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName, Address1, Address2, City, Country FROM tblCentennialMembers; It returns almost everything including the duplicates since add1 doesn't always match address1, even though the first and last names match. So, how to get the extra fields into the original result set while only doing a union on first and last names? Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun Clustering problem - Instance keeps amp;amp;quot;shutting downamp;amp;quot;
And why do I keep getting my replies in separate entries :-( Sorry people!! The log file was from the failing instance. It was residing in the C:\JRuns\Logs\ folder. IIS is sitting on both boxes so I'm not sure if that classes as a dedicated IIS box. We have round robin on the DNS as well so requests are being passed to both boxes. I actually didn't know about those logs. You learn something new every day :-) Just looking at the same time as those previous logs these start 2 milliseconds after the failure notice. Nothing was happening in these logs for a few hours before this... C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 2008-02-27 10:50:43 jrISAPI[2192:6480] Sticky session breakage, a host for serving session 503042d9e2ad1a7e34287c18369f231a287aTR; __utma=228107678.392619640.1204109239.1204109239.1204109239.1; __utmb=228107678; __utmc=228107678; __utmz=228107678.1204109239.1.1. utmccn=(referral)|utmcsr=us.f352.mail.yahoo. com|utmcct=/ym/ShowLetter|utmcmd=referral not available. Failing over to another server, but above session is broken. 2008-02-27 10:50:45 jrISAPI[4052:6480] Sticky session breakage, a host for serving session 50302bd60c2496e669ee2155771f16362587TR not available. Failing over to another server, but above session is broken. 2008-02-27 10:50:52 jrISAPI[9760:6480] Sticky session breakage, a host for serving session 5030b494a4dd95871bb572701d10113ba365TR; __utma=228107678.629465025.1204106629.1204106629.1204106629.1; __utmb=228107678; __utmc=228107678; __utmz=228107678.1204106629.1.1. utmccn=(direct)|utmcsr=(direct)|utmcmd=(none) not available. Failing over to another server, but above session is broken. C:\JRun4\lib\wsconfig\wsconfig.log - I'm not seeing anything on the 27th at that time. Does that help at all? Cheers for all your help, James I just poked around my server a bit... Exactly what log file did you past from in the OP. If you have a dedicated IIS box and depending on your OS, I'm not sure if the directories will be the same, but do you have anything useful in these logs: C:\JRun4\lib\wsconfig\wsconfig.log C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard00.log In the last log, the 1 directory corresponds to the clusters set up in C:\JRun4\lib\wsconfig\wsconfig.properties. I obviously have IIS6, and the number on the end of the file name is auto-incrementing. ~Brad downquot; Is it possible there is a connectivity issue which is causing the JRun connectors (which are loaded on the IIS box and control load balancing) to think that instance is down? I don't know off the top of my head if there is a log file on the IIS box. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cffile and security
Good Morning, I have been working with cffile for the first time and in the process, read several places that you should upload files to a temp location outside your webroot for security reasons. My original problem was with trying to eliminate spaces from file names...so now this is the process I'm using...upload to a temp file, remove spaces and replace with _ then move the file (code below) My question is, why do I have to go to a temp file first and is this secure in it's final version/location? Also, how do I deal with naming conflicts...does move allow for the same options as upload...rename, overwrite ect.? It doesn't seem to allow for a result struc. !---Query for job folder name--- cfquery name=jobfolder datasource=#Application.dbDSN# select jobfoldername from jobs where jobId = #session.jobId# /cfquery cfoutput cffile action = upload fileField = FileToUpload destination = c:/temp accept = image/pjpeg, image/jpg, application/pdf nameConflict = MakeUnique result=result cfdump var=#result# cfset NoSpaceServerFileName = reReplace(Result.ServerFileName, \s+,_, all) cffile action=rename source=c:\temp\#Result.serverFileName#.pdf destination=C:\temp\#NoSpaceServerFileName#.pdf cffile action=move source=C:\temp\#NoSpaceServerFileName#.pdf destination=C:\cfusionmx7\wwwroot\pyramidhomeworks\JobAdmin\JobFiles\#jobFo lder.jobFolderName#\#NoSpaceServerFileName#.pdf result=moveresult br /cfdump var=#jobFolder# /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Interesting idea for next CF - thoughts...
Lol. You got me. I meant implements=, not extends=. That was the one CF8 introduced. :) ~Brad -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 8:48 AM To: CF-Talk Subject: Re: Interesting idea for next CF - thoughts... You mean 'extends=' didn't actually extend a CFC? Wow, then my code was working through magic and incantation all that time! Hot Damn, call the Enquirer! ;) Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: unofficial ahphosting thread
My heads up was a buddy of mine telling me my sites were down Eric /*-Original Message- /*From: Azadi Saryev [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, February 27, 2008 8:34 PM /*To: CF-Talk /*Subject: Re: unoffical ahphosting thread /* /*hmm... i never got any heads-up at all... /* /*Azadi Saryev /*Sabai-dee.com /*http://www.sabai-dee.com/ /* /*Rick Faircloth wrote: /* Yes, I got the notice, too. /* /* /* -Original Message- /* From: Terry Schmitt [mailto:[EMAIL PROTECTED] /* Sent: Wednesday, February 27, 2008 2:38 PM /* To: CF-Talk /* Subject: Re: unoffical ahphosting thread /* /* Greg did send out an upgrade email. /* /* 3) to notify all clients of planned upgrades in advance, especially /* upgrades to something like virtualization software, like most hosting /* providers do /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JRun Clustering problem - Instance keeps amp;quot;shutting downamp;quot;
Interesting. I've got to give credit to someone at Macromedia for using the work breakage. :) Well, it seems clear that IIS and the JRun connector are losing contact with the instance and subsequently removing it from the cluster. What we don't know is why. Did I understand that you have at least one other CF instance on the same physical box which does not experience this problem? That would rule out OS and general connectivity problems. I think you said it was on a VM. Is that instance along on the VM, or are there more than one instance on that VM. I don't know where to tell you to go from here. Maybe someone else will chime in with an idea. Just ignore my comment about the dedicated IIS box. For some reason I had gotten it in my head that you had a separate physical server for IIS. I guess I've got the load-balancing diagram stuck in my head that was posted yesterday on the list. :) ~Brad -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 9:30 AM To: CF-Talk Subject: Re: JRun Clustering problem - Instance keeps amp;quot;shutting downamp;quot; The log file was from the failing instance. It was residing in the C:\JRuns\Logs\ folder. IIS is sitting on both boxes so I'm not sure if that classes as a dedicated IIS box. We have round robin on the DNS as well so requests are being passed to both boxes. I actually didn't know about those logs. You learn something new every day :-) Just looking at the same time as those previous logs these start 2 milliseconds after the failure notice. Nothing was happening in these logs for a few hours before this... C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 2008-02-27 10:50:43 jrISAPI[2192:6480] Sticky session breakage, a host for ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: unofficial ahphosting thread
I got a heads-up email on feb 15th with a subject of AHPHosting Maintentance event - VPS Upgrade Notice. On Thu, Feb 28, 2008 at 8:01 AM, Eric Roberts [EMAIL PROTECTED] wrote: My heads up was a buddy of mine telling me my sites were down Eric /*-Original Message- /*From: Azadi Saryev [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, February 27, 2008 8:34 PM /*To: CF-Talk /*Subject: Re: unoffical ahphosting thread /* /*hmm... i never got any heads-up at all... /* /*Azadi Saryev /*Sabai-dee.com /*http://www.sabai-dee.com/ /* /*Rick Faircloth wrote: /* Yes, I got the notice, too. /* /* /* -Original Message- /* From: Terry Schmitt [mailto:[EMAIL PROTECTED] /* Sent: Wednesday, February 27, 2008 2:38 PM /* To: CF-Talk /* Subject: Re: unoffical ahphosting thread /* /* Greg did send out an upgrade email. /* /* 3) to notify all clients of planned upgrades in advance, especially /* upgrades to something like virtualization software, like most hosting /* providers do /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT - SQL Union Problem
This should do it. There's a union and a left outer join. I hope this works in Access, I've never used it... /* First Get Centennial Members */ SELECT FirstName , LastName , Address1 , Address2 , City , Country FROM tblCentennialMembers /* Now Get Members who are in the Foundation but aren't Centennial Members */ UNION SELECT m.FirstName1 AS FirstName , m.SurName1 AS LastName , m.Add1 AS Address1 , m.Add2 AS Address2 , m.City , m.Country FROM tblMain m LEFT OUTER JOIN tblCentennialMembers cm ON m.FirstName1 = cm.FirstName AND m.SurName1 = cm.LastName WHERE m.Foundation = Yes AND cm.FirstName IS NULL /* Removes Centennial Members Records from result */ On Wed, Feb 27, 2008 at 9:11 PM, Mark Henderson [EMAIL PROTECTED] wrote: OK, so that was working, and those are the only two fields I want to union on, which is fine. But now I also want to add the address fields to the query result, without doing a union on those additional fields. Some addresses aren't entered quite right, and this will then create duplicates even though the query doesn't see them as such - does that make sense? So, for instance, when I do: SELECT FirstName1 AS FirstName, Surname1 AS LastName FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName FROM tblCentennialMembers; I get the result set I want. But if I do SELECT FirstName1 AS FirstName, Surname1 AS LastName. Add1, Add2, City, Country FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName, Address1, Address2, City, Country FROM tblCentennialMembers; It returns almost everything including the duplicates since add1 doesn't always match address1, even though the first and last names match. So, how to get the extra fields into the original result set while only doing a union on first and last names? Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sending File Data Over Webservice
I have never used the symlink idea - although I've heard him mention it before. I'd be interested in a code snippet on how to do this on the fly in Linux. Would you have to pass arguments to a shell script Dave? Yes, or in Windows, to a batch file that runs the Sysinternals tool junction.exe. I suppose you could just invoke junction.exe directly with CFEXECUTE, but I haven't tried that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT - URL Rewriting, how many rules?
Sorry, very quick OT. I have 20 odd rules in my .htaccess file and it may grow to 40 or 60. Is this too many? Can anyone claim to have more and do you notice any performance hit? Any links to info on this subject? Thanks. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - URL Rewriting, how many rules?
I have 20 odd rules in my .htaccess file and it may grow to 40 or 60. Is this too many? Can anyone claim to have more and do you notice any performance hit? Any links to info on this subject? The most I've seen in a production application was about 300, and it didn't cause any noticeable problem. However, we didn't load test to ensure that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun Clustering problem - Instance shutting down
Right here's hoping that this doesn't start another thread as this is getting embrassing!!! That second set are logs are obviously related to the drop of the instance and JRun starting to hand the sessions across to the other server. Not very helpful but still more information I can work on. Yes you're right we do have another instance on that server and yeah it is strange that out of four instances only one is failing. Or what I should say is that the vast majority of fails are coming from there, we do get a few others here and there but nothing worth highlighting as an issue and related to this. We're going to move the code from the other instance over to this one in the hope that this might fix it. The idea being that we might have a mismatch somewhere that is causing a problem so this would eliminate it this. Stab in the dark really though :-(. Don't know about the shared VM side of things, I'll need to ask the System's guys about that one but again that kind of opens up the field to anything while we've definately got a lead with the JRun logs at the moment. Thanks for your efforts though Brad, it's appreciated. Cheers, James Interesting. I've got to give credit to someone at Macromedia for using the work breakage. :) Well, it seems clear that IIS and the JRun connector are losing contact with the instance and subsequently removing it from the cluster. What we don't know is why. Did I understand that you have at least one other CF instance on the same physical box which does not experience this problem? That would rule out OS and general connectivity problems. I think you said it was on a VM. Is that instance along on the VM, or are there more than one instance on that VM. I don't know where to tell you to go from here. Maybe someone else will chime in with an idea. Just ignore my comment about the dedicated IIS box. For some reason I had gotten it in my head that you had a separate physical server for IIS. I guess I've got the load-balancing diagram stuck in my head that was posted yesterday on the list. :) ~Brad downamp;quot; The log file was from the failing instance. It was residing in the C:\JRuns\Logs\ folder. IIS is sitting on both boxes so I'm not sure if that classes as a dedicated IIS box. We have round robin on the DNS as well so requests are being passed to both boxes. I actually didn't know about those logs. You learn something new every day :-) Just looking at the same time as those previous logs these start 2 milliseconds after the failure notice. Nothing was happening in these logs for a few hours before this... C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 2008-02-27 10:50:43 jrISAPI[2192:6480] Sticky session breakage, a host for ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - URL Rewriting, how many rules?
mod_rewrite is a drop in a bucket compared to the ocean of a JEE stack, let alone one with CF on it. Using .htaccess is going to be more of a performance penalty, because of all the extra per-request file IO. Unless you have a compelling reason (like shared hosting), you should put all your config in the main config files. If you want to version your rewriting config with your app (usually what you want), then use an Include directive instead of .htaccess. I've used hundrends (maybe thousands?) of rewrite rules with no issue and used rewrite maps with thousands of entries, both with no discernible performance penalty. Rewriting queries still provided the best bang for your buck speeding things up. cheers, barneyb On Thu, Feb 28, 2008 at 8:29 AM, Adrian Lynch [EMAIL PROTECTED] wrote: Sorry, very quick OT. I have 20 odd rules in my .htaccess file and it may grow to 40 or 60. Is this too many? Can anyone claim to have more and do you notice any performance hit? Any links to info on this subject? Thanks. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - URL Rewriting, how many rules?
mod_rewrite is a drop in a bucket compared to the ocean of a JEE stack, let alone one with CF on it. Using .htaccess is going to be more of a performance penalty, because of all the extra per-request file IO. Unless you have a compelling reason (like shared hosting), you should put all your config in the main config files. If you want to version your rewriting config with your app (usually what you want), then use an Include directive instead of .htaccess. I've used hundrends (maybe thousands?) of rewrite rules with no issue and used rewrite maps with thousands of entries, both with no discernible performance penalty. Rewriting queries still provided the best bang for your buck speeding things up. cheers, barneyb On Thu, Feb 28, 2008 at 8:29 AM, Adrian Lynch [EMAIL PROTECTED] wrote: Sorry, very quick OT. I have 20 odd rules in my .htaccess file and it may grow to 40 or 60. Is this too many? Can anyone claim to have more and do you notice any performance hit? Any links to info on this subject? Thanks. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Does Java version matter with cf8 (standard) performance?
Per Mark Mandel's following piece, http://www.compoundtheory.com/?action=displayPostID=270 Your thoughts/experience? Thks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sending File Data Over Webservice
I wonder if this can also be done using underlying JAVA classes and things like that? Might be worth looking around for some libraries. Rob -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 28 February 2008 16:36 To: CF-Talk Subject: RE: Sending File Data Over Webservice I have never used the symlink idea - although I've heard him mention it before. I'd be interested in a code snippet on how to do this on the fly in Linux. Would you have to pass arguments to a shell script Dave? Yes, or in Windows, to a batch file that runs the Sysinternals tool junction.exe. I suppose you could just invoke junction.exe directly with CFEXECUTE, but I haven't tried that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with Rewrite Rule! (circuit.fuseaction)
Here's an example, I have a rule that translates http://mysite/index.cfm?offers.booksbookid=1 to http://mysite/offers/books/somebook however none of the images on this page get displayed. I looked at an image property and the src which had the following src: http://mysite/offers/books/images/bookimage/somebook.gif I want it to be http://mysite/images/bookimage/somebook.gif where images is a virtual directory. Can anybody please suggest how this can be done? Regards, cfcoder ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sending File Data Over Webservice
Dave, What's your take on heavy use of cfexecute and the shell - at least in Windows we have found it to be a little dicey. Sometimes command shells are left in the process space without terminating. -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 10:36 AM To: CF-Talk Subject: RE: Sending File Data Over Webservice I have never used the symlink idea - although I've heard him mention it before. I'd be interested in a code snippet on how to do this on the fly in Linux. Would you have to pass arguments to a shell script Dave? Yes, or in Windows, to a batch file that runs the Sysinternals tool junction.exe. I suppose you could just invoke junction.exe directly with CFEXECUTE, but I haven't tried that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: unoffical ahphosting thread
I am not going to blame Greg for SWSoft's F-up Is AHP just one guy? What were you guys expecting? Greg chose to use SWSoft software. They may be at fault but he is responsible. Also if he makes an upgrade and doesn't have enough help if things go wrong, that is also his fault. SWSoft isn't to blame for over a week of downtime. That was Greg. Subject: re: unoffical ahphosting thread From: [EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Wed, 27 Feb 2008 11:14:04 -0600 I a have been with them for a while and don't plan on leaving anytime soon. While this is a major ouch...I too have enjoyed the one on one relationship with greg and the speed at which he normally gets things done. My sites are all still down as of last night. He is normally very quick to address problems when they occur. Much like I don't blame MS for hardware manufacturer's failings, I am not going to blame Greg for SWSoft's F-up ;-). THough I do agree with some of theother comments...it would be nice to have emails sent out periodically even if just to say it's still broke, but I am working on it. Doing that would provide a good diversion from trying to fix the code...sometimes that helps get it done faster. Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
schedule tasks gone missing?
Hi All, I've just been shocked by looking in my schedule tasks (after a cf upgrade) to find no schedule tasks showing. Now the tasks are running but i just can't see them to administer them? Does anyone know how i can access these or make them show again? A quick web search didn't return anything helpful. Thanks in advance. -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk f..works:http://cfframeworks.com short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Interesting idea for next CF - thoughts...
Jim Davis said: I know it won't validate, but can't you do that now? I would expect CF to ignore any unknown attributes. Way back when, CF5 and prior, it would throw errors on attributes it didn't recognize. When CF6 was introduced they allowed you to add whatever arbitrary attributes you want to cfcomponent, cffunction, cfargument and cfproperty tags so you could use that metadata via getMetaData() -- with other tags I'm not sure, haven't tried it. But it's likely that the server might already ignore unrecognized attributes on tags by default. So yeah, you could possibly get away with it, although I tend to agree with Dave Watts' comments regarding its usefulness. As do I, personally. But I'm also of two minds on the issue: While I wouldn't use such a feature (for all the reasons already stated) some people clearly might. In the end consistency and workability is more important to me. If this guy finds this useful and, most importantly, is consistent with his usage then great. Anything that lets us remember what the hell we were thinking a year later can't be all bad. ;^) Of course there are other considerations. I think the most important one is are you inflicting this system on others? If so, and they DON'T understand then your consistency means nothing - you must be consistent within your workgroup for anything like this to truly work. I've actually gone further and created my own comment tag and parsing engine for CFC development... probably worse that this to many people but it works wonders for me and allows me to self-document my code pretty darn well. In any case any documentation, whether it's via strict comments, code markup, naming conventions, etc is definately more good than bad. But it only works really when everybody involved works together. Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does Java version matter with cf8 (standard) performance?
Don, On Thu, Feb 28, 2008 at 11:36 AM, Don L [EMAIL PROTECTED] wrote: Per Mark Mandel's following piece, http://www.compoundtheory.com/?action=displayPostID=270 Your thoughts/experience? Unfortunately, the answer is the usual: it depends. Certainly, it depends on your application(s). And to some extent, it may depend on who you talk to. The issues Mark refers to are easily seen if you're using a lot of framework stuff, and in particular, with Transfer. There's a lot of class loading going on, and that can kill the performance. I ran into the issue in deploying a client site, and we went through two hosting services before Mark and Sean Corfleld blogged about this problem, and we realized it wasn't the host's fault. There was a fair amount of discussion about the problem on the Transfer list. On the other hand, many people (including, of course, Adobe), say that it's the combination of CF8 and Java 1.6 that provides the huge performance gains shown in Adobe's benchmarking for CF8. So evidently, in most CF non-framework-driven applications, the issue is overcome by other performance gains. When I ran into the problem, I discussed it with a contact I have at CrystalTech, and they actually discussed the issue with Adobe. As Mark suggests, both Adobe and Sun are aware of the problem. Sun just hasn't fixed the bug yet. But CrystalTech (and other hosting services I've talked to) are not willing to downgrade the Java version because it will hurt performance for many/most of their customers. In my case, I moved to a VPS where I was free to change the Java version, and it made a gigantic difference. Of course, the VPS made a difference in a lot of other ways. So how much of a problem the Java bug is -- or whether it's a problem for you at all -- depends very much on your situation. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does Java version matter with cf8 (standard) performance?
Thank you for your thoughtful follow-up, Tom. Don Don, Unfortunately, the answer is the usual: it depends. Certainly, it depends on your application(s). And to some extent, it may depend on who you talk to. So how much of a problem the Java bug is -- or whether it's a problem for you at all -- depends very much on your situation. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with CFLDAP and AD
Thanks to you both for setting me on the right path. I figured out what I needed to do, and I'm now able to authorize users depending on their OUs. I really appreciate the help! Bonnie ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with CFLDAP and AD
Thanks to you both for setting me on the right path. I figured out what I needed to do, and I'm now able to authorize users depending on their OUs. I really appreciate the help! Bonnie Hi: I'm having trouble getting CFLDAP to work with my Active Directory. Here's what I have so far: Server name: server.xxx.yyy.edu Active directory structure: xxx OU1 (organizational unit, not security group) User1 OU2 User2 I want to set up the CFLDAP tag so that it only authenticates users in OU1 NOT anyone outside of OU1 (so User1 would authenticate, but User 2 would not). Here's my code: cfldap action=query name=qryUser start=ou=OU1,dc=xxx,dc=yyy,dc=edu scope=subtree attributes=* filter=ou=OU1 server=server.xxx.yyy.edu port=389 username=xxx\#Trim(user1)# password=user1password The authentication works, but it will authenticate users in OU2 as well as OU1. Please help! Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLDAP Security groups
Hi - Trying to query a security group in Active Directoy to determine if a person belongs to it. I am getting no results when I run the below code - but I know they are a memember of the Students group. Any ideas appreciated. Dan B cfldap action=QUERY name=auth2 attributes=samaccountname start=CN=Students,OU=_Groups,OU=_Users,DC=xx,DC=xx filter=samaccountname=dbeauchemin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLDAP Security groups
Rather than querying the Students group, query the user account. The attribute you want is memberOf. It will give you a list of groups to which the user belongs. Then, search that list for Students. m!ke -Original Message- From: Dan beauchemin [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 12:34 PM To: CF-Talk Subject: CFLDAP Security groups Hi - Trying to query a security group in Active Directoy to determine if a person belongs to it. I am getting no results when I run the below code - but I know they are a memember of the Students group. Any ideas appreciated. Dan B cfldap action=QUERY name=auth2 attributes=samaccountname start=CN=Students,OU=_Groups,OU=_Users,DC=xx,DC=xx filter=samaccountname=dbeauchemin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLDAP Security groups
Dan beauchemin wrote: cfldap action=QUERY name=auth2 attributes=samaccountname start=CN=Students,OU=_Groups,OU=_Users,DC=xx,DC=xx filter=samaccountname=dbeauchemin You are only returning the 'samAccountName' attribute which is just the account name of the Group itself. You either need to query the qroup record (as you are) and examine its 'member' attribute to see if contains the desired user or query the user record and examine its 'memberOf' attribute to see if it contains the desired group. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Interesting idea for next CF - thoughts...
I've actually gone further and created my own comment tag and parsing engine for CFC development... probably worse that this to many people but it works wonders for me and allows me to self-document my code pretty darn well. Not all that far-out for those of us who've worked with Fusedocs for example. There's a similar XML dialect called SPEC that I created used for documenting functions and such in the onTap framework, though the dialect itself was designed with the intention of being independent of the language or framework, so you could use SPEC to document Java (or create SPEC docs from JavaDocs) if you wanted. I use it in the framework as a skeleton for displaying language reference in HTML format. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Interesting idea for next CF - thoughts...
Lol. You got me. I meant implements=, not extends=. That was the one CF8 introduced. :) Oh interfaces... that makes more sense. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
comparing data in a loop
hi, i know there must be a simple answer to this but i am braindead right now and cannot think of it. this is more of a logic question, and i am lacking it right now :) i would appreciate your help please i have data in a query, e.g. col1 col2 col3 --- 1 2 3 1 2 4 1 3 1 etc i need to be able to check that no 2 rows have the same data the problem is, is that i dont know how many columns there will be and i dont know what the unique columns will be. but i have the query and i have an array of unique columns for example i have 'col1' and 'col2' in an array called uniqueColumns() so i need to somehow search through the query to ensure that no 2 rows contain the same data - but only in the unique columns. so on the above example if i did have col1 and col2 in the uniqueColumns array then when searching through the query i need it to tell me that row 1 and 2 have matching unique columns as they both contain: col1 = 1 col2 = 2 i would be very grateful of your help thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT - SQL Union Problem
Did that work for you Mark? On Thu, Feb 28, 2008 at 11:26 AM, Sonny Savage [EMAIL PROTECTED] wrote: This should do it. There's a union and a left outer join. I hope this works in Access, I've never used it... /* First Get Centennial Members */ SELECT FirstName , LastName , Address1 , Address2 , City , Country FROM tblCentennialMembers /* Now Get Members who are in the Foundation but aren't Centennial Members */ UNION SELECT m.FirstName1 AS FirstName , m.SurName1 AS LastName , m.Add1 AS Address1 , m.Add2 AS Address2 , m.City , m.Country FROM tblMain m LEFT OUTER JOIN tblCentennialMembers cm ON m.FirstName1 = cm.FirstName AND m.SurName1 = cm.LastName WHERE m.Foundation = Yes AND cm.FirstName IS NULL /* Removes Centennial Members Records from result */ On Wed, Feb 27, 2008 at 9:11 PM, Mark Henderson [EMAIL PROTECTED] wrote: OK, so that was working, and those are the only two fields I want to union on, which is fine. But now I also want to add the address fields to the query result, without doing a union on those additional fields. Some addresses aren't entered quite right, and this will then create duplicates even though the query doesn't see them as such - does that make sense? So, for instance, when I do: SELECT FirstName1 AS FirstName, Surname1 AS LastName FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName FROM tblCentennialMembers; I get the result set I want. But if I do SELECT FirstName1 AS FirstName, Surname1 AS LastName. Add1, Add2, City, Country FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName, Address1, Address2, City, Country FROM tblCentennialMembers; It returns almost everything including the duplicates since add1 doesn't always match address1, even though the first and last names match. So, how to get the extra fields into the original result set while only doing a union on first and last names? Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: comparing data in a loop
It might be useful to know that you can reference query objects like a struct of arrays: QueryName['ColumnName'][1] So cfset ColNameA = col1 cfset ColNameB = col2 cfloop query=QueryName cfif QueryName[ColNameA][QueryName.CurrentRow] EQ QueryName[ColNameA][ QueryName.CurrentRow] !--- Perform actions for non-unique actions --- /cfif /cfloop This might be something that would be accomplished better in the SQL statement though. A more specific description of the issue would be helpful. On Thu, Feb 28, 2008 at 3:16 PM, Richard White [EMAIL PROTECTED] wrote: hi, i know there must be a simple answer to this but i am braindead right now and cannot think of it. this is more of a logic question, and i am lacking it right now :) i would appreciate your help please i have data in a query, e.g. col1 col2 col3 --- 1 2 3 1 2 4 1 3 1 etc i need to be able to check that no 2 rows have the same data the problem is, is that i dont know how many columns there will be and i dont know what the unique columns will be. but i have the query and i have an array of unique columns for example i have 'col1' and 'col2' in an array called uniqueColumns() so i need to somehow search through the query to ensure that no 2 rows contain the same data - but only in the unique columns. so on the above example if i did have col1 and col2 in the uniqueColumns array then when searching through the query i need it to tell me that row 1 and 2 have matching unique columns as they both contain: col1 = 1 col2 = 2 i would be very grateful of your help thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: comparing data in a loop
Copy and paste error: cfif QueryName[ColNameA][QueryName.CurrentRow] EQ QueryName[ColNameB][ QueryName.CurrentRow] On Thu, Feb 28, 2008 at 3:37 PM, Sonny Savage [EMAIL PROTECTED] wrote: It might be useful to know that you can reference query objects like a struct of arrays: QueryName['ColumnName'][1] So cfset ColNameA = col1 cfset ColNameB = col2 cfloop query=QueryName cfif QueryName[ColNameA][QueryName.CurrentRow] EQ QueryName[ColNameA][QueryName.CurrentRow] !--- Perform actions for non-unique actions --- /cfif /cfloop This might be something that would be accomplished better in the SQL statement though. A more specific description of the issue would be helpful. On Thu, Feb 28, 2008 at 3:16 PM, Richard White [EMAIL PROTECTED] wrote: hi, i know there must be a simple answer to this but i am braindead right now and cannot think of it. this is more of a logic question, and i am lacking it right now :) i would appreciate your help please i have data in a query, e.g. col1 col2 col3 --- 1 2 3 1 2 4 1 3 1 etc i need to be able to check that no 2 rows have the same data the problem is, is that i dont know how many columns there will be and i dont know what the unique columns will be. but i have the query and i have an array of unique columns for example i have 'col1' and 'col2' in an array called uniqueColumns() so i need to somehow search through the query to ensure that no 2 rows contain the same data - but only in the unique columns. so on the above example if i did have col1 and col2 in the uniqueColumns array then when searching through the query i need it to tell me that row 1 and 2 have matching unique columns as they both contain: col1 = 1 col2 = 2 i would be very grateful of your help thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: comparing data in a loop
Combine the columns using an alias and query for DISTINCT? -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 3:16 PM To: CF-Talk Subject: comparing data in a loop hi, i know there must be a simple answer to this but i am braindead right now and cannot think of it. this is more of a logic question, and i am lacking it right now :) i would appreciate your help please i have data in a query, e.g. col1 col2 col3 --- 1 2 3 1 2 4 1 3 1 etc i need to be able to check that no 2 rows have the same data the problem is, is that i dont know how many columns there will be and i dont know what the unique columns will be. but i have the query and i have an array of unique columns for example i have 'col1' and 'col2' in an array called uniqueColumns() so i need to somehow search through the query to ensure that no 2 rows contain the same data - but only in the unique columns. so on the above example if i did have col1 and col2 in the uniqueColumns array then when searching through the query i need it to tell me that row 1 and 2 have matching unique columns as they both contain: col1 = 1 col2 = 2 i would be very grateful of your help thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: comparing data in a loop
On Thu, Feb 28, 2008 at 12:16 PM, Richard White [EMAIL PROTECTED] wrote: hi, i know there must be a simple answer to this but i am braindead right now and cannot think of it. this is more of a logic question, and i am lacking it right now :) i would appreciate your help please i have data in a query, e.g. col1 col2 col3 --- 1 2 3 1 2 4 1 3 1 etc i need to be able to check that no 2 rows have the same data the problem is, is that i dont know how many columns there will be and i dont know what the unique columns will be. but i have the query and i have an array of unique columns for example i have 'col1' and 'col2' in an array called uniqueColumns() so i need to somehow search through the query to ensure that no 2 rows contain the same data - but only in the unique columns. so on the above example if i did have col1 and col2 in the uniqueColumns array then when searching through the query i need it to tell me that row 1 and 2 have matching unique columns as they both contain: col1 = 1 col2 = 2 create a valueList for each column in the array. use a compare() or compareNoCase() on the resulting lists. -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
An effort to make cold fusion 8 standard edition more efficient
Sam Farmer got me started with YSlow (performance tool), thanks, Sam. With this tool, one can tell, some of the major memory hoggers include: ext-core.js (77k) grid.js (53k) -- when one looks at all the amenties, needed or not, one would know this thing is going to cost ya, now, if I may, it would be so desirable to have, say, two options, a) light version; b) heavy one (load whatever you want)... one wonders what designers are doing with their job (not targeting against Adobe team...)... fukEditor_gecko.js (152.7k) Here's some more detail App memory load (without FckEditor): 927k (with FckEditor):1338k The difference is pretty substantial. Now, the alernative for text editor could be, YUIEditor or tinyMCE, both works fine for simple, straight page/form, however, neither would work within complex CFWINDOW. And on js, Gzip components is recommended, does the current cf8 standard support that? For instance, ext-core.js is called by cf server instance, not manually called by a developer. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: comparing data in a loop
hi, thanks for all your replies and thanks charlie this is a very elegant solution :) i didn't even know about this function, thanks again richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficient
So, use the CF8 components for rapid prototyping. Refactor with straight Ext for final app, optimizing what you need when you need it, and packed in any fashion you find appropriate. You said that App memory load with FckEditor was 1338k? I'm guessing you mean your client side memory load on your browser? And that you mean 'load', not the amount of data transferred across the wire? OK, so what's the problem? Have you seen how much memory Word or Excel or something takes? Right this moment, on my desktop, Outlook is using 68000k, Eclipse:237700, and Thunderbird: 156000. 400k is negligible. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Don L wrote: Sam Farmer got me started with YSlow (performance tool), thanks, Sam. With this tool, one can tell, some of the major memory hoggers include: ext-core.js (77k) grid.js (53k) -- when one looks at all the amenties, needed or not, one would know this thing is going to cost ya, now, if I may, it would be so desirable to have, say, two options, a) light version; b) heavy one (load whatever you want)... one wonders what designers are doing with their job (not targeting against Adobe team...)... fukEditor_gecko.js (152.7k) Here's some more detail App memory load (without FckEditor): 927k (with FckEditor):1338k The difference is pretty substantial. Now, the alernative for text editor could be, YUIEditor or tinyMCE, both works fine for simple, straight page/form, however, neither would work within complex CFWINDOW. And on js, Gzip components is recommended, does the current cf8 standard support that? For instance, ext-core.js is called by cf server instance, not manually called by a developer. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: comparing data in a loop
thanks this is a good idea ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How accurate is IP address / Geocode lookup?
I have a client that is looking to ascertain the state ( or country if not US based ) of the current visitor to their web site. One possibility has been to use their IP address and a geocode lookup, which I have never done before. So, how accurate is doing a geocode lookup based upon IP? Does it really give the user's location or more often the ISP's location? Any feedback would be appreciated. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficient
if I may, it would be so desirable to have, say, two options, a) light version; b) heavy one (load whatever you want)... I believe that you can load only the js pieces you need. By default, they all come in. But I believe you can import them separately. Check the docs. I'm pretty sure you can lighten up the scripts. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help with Rewrite Rule! (circuit.fuseaction)
On Fri, Feb 29, 2008 at 1:46 AM, cf coder [EMAIL PROTECTED] wrote: however none of the images on this page get displayed. I looked at an image property and the src which had the following src: http://mysite/offers/books/images/bookimage/somebook.gif I want it to be http://mysite/images/bookimage/somebook.gif Try base href=http://mysite/; / (in the head of your document). That will cause all css, js, image and links on the page to use http://mysite/ as the base of relative requests. -- Kay Smoljak business: www.cleverstarfish.com standards: kay.zombiecoder.com coldfusion: kay.smoljak.com personal: goatlady.wordpress.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: comparing data in a loop
you guys have really helped me out, thanks!!! i didnt even realise that i could do a query on a query. this will help tidy my code and business logic up no end. i am trying to do a combination of some of your suggestions as follows: --- this is the unique column array --- cfset uniqueColumnString = arraytolist(uniqueIdentifierArray,,) --- massImport is the name of the query --- cfset sqlQuery = select distinct uniqueColumnString from massImport --- then simply run the query --- cfquery name=getUniqueColumns dbtype=query cfoutput#sqlQuery#/cfoutput /cfquery i have tried various tests with the query on query and overall it is working fine except when i put the distinct part on the query it produces an error saying: java.lang.Long cannot be cast to java.lang.String however if i run a similar piece of code in mysql, it works fine. can anyone see what i have done wrong thanks again for your help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How accurate is IP address / Geocode lookup?
I don't know what your idea of accurate is and I've never tested a large enough sample size to be sure, but I say it's not accurate. I say this because when I checked my IP address, it said I was in NJ. Grabbed another IP and it showed PA. I'm in MD. I checked a friends IP and it nailed him to his town. On Thu, Feb 28, 2008 at 5:28 PM, Jeff Chastain [EMAIL PROTECTED] wrote: I have a client that is looking to ascertain the state ( or country if not US based ) of the current visitor to their web site. One possibility has been to use their IP address and a geocode lookup, which I have never done before. So, how accurate is doing a geocode lookup based upon IP? Does it really give the user's location or more often the ISP's location? Any feedback would be appreciated. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How accurate is IP address / Geocode lookup?
From what I understand, it's usually the ISP. However, it is often the last hop before the actual client, so it would only be inaccurate if, say, the person was in TN and the ISP was in KY. That said, at my last job, we were in KY, and we showed up as in (I think) PA, since that was where the router for static IPs was. Alltel was our ISP, IIRC. So it's a good approximation, but I would not rely on it for calculating sales tax. :-) --Doom Jeff Chastain wrote: I have a client that is looking to ascertain the state ( or country if not US based ) of the current visitor to their web site. One possibility has been to use their IP address and a geocode lookup, which I have never done before. So, how accurate is doing a geocode lookup based upon IP? Does it really give the user's location or more often the ISP's location? Any feedback would be appreciated. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How accurate is IP address / Geocode lookup?
Accurate as in at the state level within the US and from what you have said plus a few tests I have run, this does not seem to be the case. Thanks was what I needed. Thanks. -Original Message- From: Dae [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 4:41 PM To: CF-Talk Subject: Re: How accurate is IP address / Geocode lookup? I don't know what your idea of accurate is and I've never tested a large enough sample size to be sure, but I say it's not accurate. I say this because when I checked my IP address, it said I was in NJ. Grabbed another IP and it showed PA. I'm in MD. I checked a friends IP and it nailed him to his town. On Thu, Feb 28, 2008 at 5:28 PM, Jeff Chastain [EMAIL PROTECTED] wrote: I have a client that is looking to ascertain the state ( or country if not US based ) of the current visitor to their web site. One possibility has been to use their IP address and a geocode lookup, which I have never done before. So, how accurate is doing a geocode lookup based upon IP? Does it really give the user's location or more often the ISP's location? Any feedback would be appreciated. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficient
Yes, I meant, client/browser side memory. Ok, so, show me some trick on trimming down ext-core.js (repackaging vs ?) , and how not to load fukEditor-gecko.js. Wny? I want it to speed up. Thanks. So, use the CF8 components for rapid prototyping. Refactor with straight Ext for final app, optimizing what you need when you need it, and packed in any fashion you find appropriate. You said that App memory load with FckEditor was 1338k? I'm guessing you mean your client side memory load on your browser? And that you mean 'load', not the amount of data transferred across the wire? OK, so what's the problem? Have you seen how much memory Word or Excel or something takes? Right this moment, on my desktop, Outlook is using 68000k, Eclipse:237700, and Thunderbird: 156000. 400k is negligible. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficient
I have been evaluating inline JS editors for years and I can say that I have not very been happy with any of them so far. Even with the best of them a user can mangle a well formed page in no time flat. And not to mention that JS can be extreemly picky and temperamental. We are dealing with a googie spell issue right now that is getting on our nerves. I am not all that suprised that you are having problems with placing an editor in a complex cfwindow design. The JS files that comes out of the box with CF 8 are large, as some of the JS libraries to begin with. The Ext-all library is 450+ k even with all the white space trimmed out. It is just the nature of the beast. IMO your best bet would be to forgo CF's built-in AJAX components and roll your own using the available libraries like EXT, Jquery, YUI or what ever best suits your needs. If you are worried about load time you can turn on compression on the server or roll your own (I have read about people doing it with cf a while back). Ok, so, show me some trick on trimming down ext-core.js (repackaging vs ?) , Got to the site and down load it. You can build your own ext library using only what you need. On Thu, Feb 28, 2008 at 4:50 PM, Don L [EMAIL PROTECTED] wrote: Sam Farmer got me started with YSlow (performance tool), thanks, Sam. With this tool, one can tell, some of the major memory hoggers include: ext-core.js (77k) grid.js (53k) -- when one looks at all the amenties, needed or not, one would know this thing is going to cost ya, now, if I may, it would be so desirable to have, say, two options, a) light version; b) heavy one (load whatever you want)... one wonders what designers are doing with their job (not targeting against Adobe team...)... fukEditor_gecko.js (152.7k) Here's some more detail App memory load (without FckEditor): 927k (with FckEditor):1338k The difference is pretty substantial. Now, the alernative for text editor could be, YUIEditor or tinyMCE, both works fine for simple, straight page/form, however, neither would work within complex CFWINDOW. And on js, Gzip components is recommended, does the current cf8 standard support that? For instance, ext-core.js is called by cf server instance, not manually called by a developer. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Prevent users from voting twice.
Why not use some sort of captcha they have to enter in addition to selecting the item they wish to vote for. It is hard to automate reading captcha. That combined with a cookie will reduce the amount of duplicates. This email may contain material confidential to Pearson. If you were not an intended recipient, please notify the sender and delete all copies. We may monitor email to and from our network. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficient
Tom, thanks for the pointer... after scanning the relevant doc a bit more... Particuarly the following on the CFAJAXIMPORT tag, You can have only ONE scriptsrc attribute on a page, in a cfajaximport tag or a cfform tag. You can use a scriptsrc attribute in a cfajaximport tag to apply its value to all forms on a page. In the case of, cfgrid, cftextarea, they are parts of CFFORM family, so, I need to figure out, the dependences (all the related js scripts for each including FukEditor...), then, package them into one... has anyone done that, any one interested in working with me on that (cut down time...) Appreciated. Don Check the docs. I'm pretty sure you can lighten up the scripts. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficient
Thank you for sharing your insights, Gerald, option one of redoing the design for optimal performance gain on the part of the inadequacy of some of the core js compoments within the cf8 context would be very time-consuming... option two of nudging/pleading with Adobe to add more best resources like Ben Forta in the design, overseeing and improvements of their flagship product like Cold Fusion 8 over their third world developers would help... option three... Don I have been evaluating inline JS editors for years and I can say that I have not very been happy with any of them so far. Even with the best of them a user can mangle a well formed page in no time flat. And not to mention that JS can be extreemly picky and temperamental. We are dealing with a googie spell issue right now that is getting on our nerves. I am not all that suprised that you are having problems with placing an editor in a complex cfwindow design. The JS files that comes out of the box with CF 8 are large, as some of the JS libraries to begin with. The Ext-all library is 450+ k even with all the white space trimmed out. It is just the nature of the beast. IMO your best bet would be to forgo CF's built-in AJAX components and roll your own using the available libraries like EXT, Jquery, YUI or what ever best suits your needs. If you are worried about load time you can turn on compression on the server or roll your own (I have read about people doing it with cf a while back). , Got to the site and down load it. You can build your own ext library using only what you need. On Thu, Feb 28, 2008 at 4:50 PM, D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficient
If you are looking fir some pre-rolled alternatives to CF's AJAX offerings you can take a look here. http://ajaxrain.com/ This WYSIWYG was on the front page: http://projects.bundleweb.com.ar/jWYSIWYG/ I just ran into this today BTW so I cannot comment on their offerings On Thu, Feb 28, 2008 at 5:48 PM, Don L [EMAIL PROTECTED] wrote: Tom, thanks for the pointer... after scanning the relevant doc a bit more... Particuarly the following on the CFAJAXIMPORT tag, You can have only ONE scriptsrc attribute on a page, in a cfajaximport tag or a cfform tag. You can use a scriptsrc attribute in a cfajaximport tag to apply its value to all forms on a page. In the case of, cfgrid, cftextarea, they are parts of CFFORM family, so, I need to figure out, the dependences (all the related js scripts for each including FukEditor...), then, package them into one... has anyone done that, any one interested in working with me on that (cut down time...) Appreciated. Don Check the docs. I'm pretty sure you can lighten up the scripts. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SOT - SQL Union Problem
Sonny, Sorry for the delay, as your original message got eaten by NoSpamToday on our Exchange server (go figure) and my time zone tends to have me in bed when the *rest of the world* is hard at work. Awesome, thanks (yes I think it worked)! I do have one question however - when I do the original union on just first and last names I get a record count of 1192, but when using your union and left outer join I have 1202. Just an interesting side note but it does appear to be doing what I want, so I wont delve into the intricacies too much. Once again, the assistance is much appreciated. Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT - SQL Union Problem
And thanks to Ben as well (and anyone else I missed), who also went into NoSpamToday (usually a product I have no hassles with). Mark -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: 29 February 2008 04:42 To: CF-Talk Subject: Re: SOT - SQL Union Problem I'm not an SQL guru, so take this with a grain of salt: You could do a join on table1.firstname=table2.firstname and table1.firstname = table2.lastname to get all the results that match. You could union this to two unioned selects where there's an entry in table1 but not table2 and vice versa. You'll have to select empty strings for the columns that are only present in one or the other table. This should give you a result set where you either have the addresses from one, or the other, or both. You can make display (or further processing) decisions based on that. --Ben Doom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How accurate is IP address / Geocode lookup?
I've used this product, integrates with CF, too: http://www.cyscape.com/products/chawk/ --- Ben -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 5:42 PM To: CF-Talk Subject: Re: How accurate is IP address / Geocode lookup? From what I understand, it's usually the ISP. However, it is often the last hop before the actual client, so it would only be inaccurate if, say, the person was in TN and the ISP was in KY. That said, at my last job, we were in KY, and we showed up as in (I think) PA, since that was where the router for static IPs was. Alltel was our ISP, IIRC. So it's a good approximation, but I would not rely on it for calculating sales tax. :-) --Doom Jeff Chastain wrote: I have a client that is looking to ascertain the state ( or country if not US based ) of the current visitor to their web site. One possibility has been to use their IP address and a geocode lookup, which I have never done before. So, how accurate is doing a geocode lookup based upon IP? Does it really give the user's location or more often the ISP's location? Any feedback would be appreciated. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How accurate is IP address / Geocode lookup?
Jeff Chastain wrote: I have a client that is looking to ascertain the state ( or country if not US based ) of the current visitor to their web site. One possibility has been to use their IP address and a geocode lookup, which I have never done the location you often get is where the IP block owner is located. for country level, IP lookups are 90% accurate (our geoLocator CFC stops at country/locale info). accuracy drops off the smaller the administrative unit you want to find, where the client is physically located (somebody along a state/province border could go either way) the ISP involved (AOL is a famous extreme case where every user's state, etc. is AOL satellite-based ISPs will also screw you up even at the country level). that said, if you're not using the location to deliver packages or drop bombs it's probably good enough, especially if you use a manual fallback mechanism. there's supposedly more accurate means of measuring where a given IP is physically located: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=831F21D5-20ED-7DEE-2AFB50CC1481BAC1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Interesting idea for next CF - thoughts...
-Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 9:13 AM To: CF-Talk Subject: RE: Interesting idea for next CF - thoughts... Watch out for that though. I remember someone on this list who used to use the extends= attribute in their cfcomponent tags. That worked great until CF8 when Adobe actually implemented that attribute and all their code broke. :) Yeah... you really can't use any common words. Since my imprint in the DepressedPress I prefix everything with DP_... something like that should keep it off any reserved word lists. ;^) Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: An effort to make cold fusion 8 standard edition more efficie nt
And on js, Gzip components is recommended, does the current cf8 standard support that? For instance, ext-core.js is called by cf server instance, not manually called by a developer. Yes, if your web server is configured to gzip static files, these files will be gzipped. All CF does is write the SCRIPT tags that reference the .js files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: comparing data in a loop
i have seen the documentation on the query on a query and it says that distinct can be used and i have it exactly as in the example so i really dont know why that error is showing! anyone seen this error before? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLDAP problem
I'm having a difficult time with a client's LDAP server. I'm using the routine 2-query CFLDAP auth scheme that first confirms the username on the nameserver using admin creds, then matches the username and password using the user's creds. The code works fine on multiple other instances. But I can't query one client's LDAP server beyond matching the username via the filter. When I add the password, even without any other attributes as filter=(unicode_Pwd=#FORM.userlogin#), the query won't execute. I can't query at all via basic security / port 636, and using the unsecured default port acts as above. I am also unable to match on attributes their admin swears are correct. I can pull some (e.g. cn, firstName, givenName) but not others (e.g. samaccountName). And I'm at the limits of my CFLDAP experience and knowledge. The client seems not to have anyone with expert knowledge of their LDAP server. Any ideas would be greatly appreciated. Thanks! David -- Want an e-mail address like mine? Get a free e-mail account today at www.mail.com! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: An effort to make cold fusion 8 standard edition more efficie nt
Thanks for the idea, Dave, unfortunately my version of the web server does not seem to support compression, oddly it has a dll for compression... I'll probably need to do more research... Don Yes, if your web server is configured to gzip static files, these files will be gzipped. All CF does is write the SCRIPT tags that reference the .js files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: An effort to make cold fusion 8 standard edition more efficie nt
Yeah, that kind of compression is almost always a web server function. On 2/28/08, Don L [EMAIL PROTECTED] wrote: Thanks for the idea, Dave, unfortunately my version of the web server does not seem to support compression, oddly it has a dll for compression... I'll probably need to do more research... Don Yes, if your web server is configured to gzip static files, these files will be gzipped. All CF does is write the SCRIPT tags that reference the .js files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: An effort to make cold fusion 8 standard edition more efficie nt
IIS supports compression, but it's a PITA to configure. Of course MS doesn't provide any sort of GUI for this and you have to edit their xml file... Apache also supports compression and is much easier to configure. FusionReactor supports compression as well for CF content. Russ -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 9:11 PM To: CF-Talk Subject: Re: An effort to make cold fusion 8 standard edition more efficie nt Thanks for the idea, Dave, unfortunately my version of the web server does not seem to support compression, oddly it has a dll for compression... I'll probably need to do more research... Don Yes, if your web server is configured to gzip static files, these files will be gzipped. All CF does is write the SCRIPT tags that reference the .js files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: An effort to make cold fusion 8 standard edition more efficie nt
IIS supports compression, but it's a PITA to configure. Of course MS doesn't provide any sort of GUI for this and you have to edit their xml file... Actually you don't, if you want to use IIS compression, there is a plugin called HttpZip by Port80. It's a GUI plugin to manage the IIS settings for this. http://www.port80software.com/products/httpzip/ They also have several other tools for IIS configurations. John Mason [EMAIL PROTECTED] 770.337.8363 www.FusionLink.com - ColdFusion and Flex hosting Now offering ColdFusion 8 Enterprise hosting FREE Subversion hosting -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, February 29, 2008 12:26 AM To: CF-Talk Subject: RE: An effort to make cold fusion 8 standard edition more efficie nt IIS supports compression, but it's a PITA to configure. Of course MS doesn't provide any sort of GUI for this and you have to edit their xml file... Apache also supports compression and is much easier to configure. FusionReactor supports compression as well for CF content. Russ -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 9:11 PM To: CF-Talk Subject: Re: An effort to make cold fusion 8 standard edition more efficie nt Thanks for the idea, Dave, unfortunately my version of the web server does not seem to support compression, oddly it has a dll for compression... I'll probably need to do more research... Don Yes, if your web server is configured to gzip static files, these files will be gzipped. All CF does is write the SCRIPT tags that reference the .js files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
No focus on page, when page loads
Hi, i'm using an xslt file that loads my page - which does not use a body. The problem i have is that everytime i open the page the focus is on the submit button. I don't really want that - where i just want no focus when the page opens up. I geuss a javascript is needed but i also dont have a body tag! Any ideas! Please assist! Regards ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Experienced CF Dev seeking telecommute work between June and August
Hi All, Here's my situation. I am a ColdFusion developer with 10 years of CF experience going from CF8 all the way back to CF3. I am also (primarily, since this year) a high school computer science and web design teacher and I am looking for something to keep myself busy during the summer months; I will be available from approximately June 10th until August 15th, 2008. I'm located in the western Philadelphia, PA suburbs, so unless you're local to me, I'd be looking for this to be a telecommuting gig. If you're within a couple of hours of my location, I'd be available for periodic on-site meetings (travel expenses paid, of course). In addition to broad experience in CF, where I specialize in intranets, extranets, and content management systems, I also have a lot of experience with learning management systems, performance tuning, user interface and user factors, page layout, HTML CSS, JavaScript, AJAX, and DHTML, MySQL and MS SQL Server. So, if you think you have a project that needs doing over the summer (I can get ramped up before the end of the school year), or if you need a pinch-hitter to cover for the usual summer vacation times, please shoot me an email. I'll be happy to send you my CV with references as well as a list of URL's of sites that I have worked on. Even if you aren't sure what your needs are, save this email and keep me in mind if something comes up. Thanks, Pete Ruckelshaus ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3663 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
