Query a flat file
Has anyone ever queried a comma delimited flat file in CF7? I have 2 frequently updated files of around 15MB and 3MB, and don't want to import it into a database every time it changes. How efficiently can CF7 query a large file like that? Can I do calculations, filtering, etc. similar to a database query? Any other suggestions on how I might accomplish this? Thanks. Mike Klostermeyer [EMAIL PROTECTED] 402.408.3733 ext. 101 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247116 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: One-to-many application on one screen
No need for IFRAME's. Simply use javascript to trigger an onchange event in the student drop-down. The event should locate the browser to the same page, with a URL parameter consisting of at least the student ID that was chosen. Query for the data for this student, then, underneath the drop-down, simply display the data results of the selected student. Mike -Original Message- From: Andy McDuff [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 2:27 PM To: CF-Talk Subject: One-to-many application on one screen Hi there, I'm relatively new to CF (although Ben's WACK book is being throughly digested) but fine with SQL, DB design and no problems on general coding. I'm working on a small test app to display courses being attended by students. The idea is to put everything on one single HTML page. At the top of the page would appear a drop-down list of students (retrieved via cfselect tag SQL from a CFC), and on the bottom-half of the screen would appear the courses being or have been attended. There are 3 tables: student, course and student-course (many-to-many relationship broken out to two sets of 1-to-many), student-course being the link table. Nothing fancy for the moment... What's the best way to do this? Use IFRAME's? If so, what's the general approach? How do I pass the selected student (from the top frame) in order to query the courses and display them in the bottom-half of the screen (without having to use a button)? Is this done via Javascript or can this be done via CF? Any help / guidance / pseudo-code would be gratefully appreciated. Andy McDuff Madrid, Spain ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246970 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: One-to-many application on one screen
Remember, anytime you are taking input from a URL, use cfqueryparam within your queries to filter out the bad guys. Mike -Original Message- From: Andrew McDuff [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 3:28 PM To: CF-Talk Subject: Re: One-to-many application on one screen Ok dokey, will go for this and take on-board advice on simplification! Thanks to all. Andy No need for IFRAME's. Simply use javascript to trigger an onchange event in the student drop-down. The event should locate the browser to the same page, with a URL parameter consisting of at least the student ID that was chosen. Query for the data for this student, then, underneath the drop-down, simply display the data results of the selected student. Mike -Original Message- From: Andy McDuff [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 2:27 PM To: CF-Talk Subject: One-to-many application on one screen Hi there, I'm relatively new to CF (although Ben's WACK book is being throughly digested) but fine with SQL, DB design and no problems on general coding. I'm working on a small test app to display courses being attended by students. The idea is to put everything on one single HTML page. At the top of the page would appear a drop-down list of students (retrieved via cfselect tag SQL from a CFC), and on the bottom-half of the screen would appear the courses being or have been attended. There are 3 tables: student, course and student-course (many-to-many relationship broken out to two sets of 1-to-many), student-course being the link table. Nothing fancy for the moment... What's the best way to do this? Use IFRAME's? If so, what's the general approach? How do I pass the selected student (from the top frame) in order to query the courses and display them in the bottom-half of the screen (without having to use a button)? Is this done via Javascript or can this be done via CF? Any help / guidance / pseudo-code would be gratefully appreciated. Andy McDuff Madrid, Spain ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246977 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Q of Q sorting
Anyone found a way around CF7's Q of Q problem with regards to sorting int vs. char? The problem I'm having is that I am trying to sort on a numeric field, but CF is sorting as if it is a character. For example, 89 comes before 876. Any way around this? While I've had this problem with standard DB queries, this particular one is the result of a Verity search. Any way I can resort the verity collection, perhaps within the CFSEARCH tag? Mike Klostermeyer [EMAIL PROTECTED] 402.408.3733 ext. 101 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Q of Q sorting
I've found that you can use the CAST function (new in CF7), which solves my problem. Anyone ever find a complete reference to all available functions within Q of Q? Mike -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 10:14 AM To: CF-Talk Subject: RE: Q of Q sorting I haven't run into this problem, but have you tried converting the string to numeric using Val? I'm not sure if that would work in Q of Q (it's a CF function not SQL), but it's worth a try. -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 8:36 AM Anyone found a way around CF7's Q of Q problem with regards to sorting int vs. char? The problem I'm having is that I am trying to sort on a numeric field, but CF is sorting as if it is a character. For example, 89 comes before 876. Any way around this? While I've had this problem with standard DB queries, this particular one is the result of a Verity search. Any way I can resort the verity collection, perhaps within the CFSEARCH tag? This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242060 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
You are correct that they should have an ArrayFind function, but knowing this limitation you should code to the strength of the language. In CF, that means using a lot of lists and queries vs. something like C++ in which I would use arrays. Mike -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 8:10 AM To: CF-Talk Subject: RE: Find in an array... Artur... I'm looping over what could potentially be 2500 records. I'd rather avoid converting back and forth. I ended up finding a function on cflib that did the trick. I'm just irritated that there's no ArrayFind function built into CF to begin with. That seems like a complete no-brainer. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Artur Kordowski [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 6:14 AM To: CF-Talk Subject: RE: Find in an array... How about to use ArrayToList() and ListFind() Function? cfset cords = ArrayToList(villages) cfset result = ListFind(cords, 4|14) Artur -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 8:24 PM To: CF-Talk Subject: Find in an array... What the hell? I've run into this before but I just can't believe that MM didn't provide some sort of ArrayFind function!!! I've got this code: cfset villages = ArrayNew(1) cfset villages[1] = -25|25 cfset villages[2] = 4|14 cfset villages[3] = 12|20 Which works just fine. But I'm looping over a set of coordinates for a map and I want to find out if the current coordinates match coords in the array. But I have no way of doing that. Does anyone have any idea? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241909 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
and 2) more importantly, a great deal of the time an array doesn't just contain simple values, but rather contains other arrays, CFC instances, queries, etc. In a large number of cases a simple arrayFind() wouldn't work anyway, and a custom function would have to be written anyway. The same could be said for a structure, yet there is a StructFind() function. Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
You're right, thanks for the correction. StructFindValue() was what I was thinking of. ArrayFindValue() would work for me! Mike -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 8:59 AM To: CF-Talk Subject: Re: Find in an array... StructFind() searches for a key in a structure, not a value. The arrayFind() they are talking about is looking for a value. Its not the same. there is a StructFindValue() but it will only search for simple variables, not complex ones. On 6/1/06, Mike Klostermeyer [EMAIL PROTECTED] wrote: and 2) more importantly, a great deal of the time an array doesn't just contain simple values, but rather contains other arrays, CFC instances, queries, etc. In a large number of cases a simple arrayFind() wouldn't work anyway, and a custom function would have to be written anyway. The same could be said for a structure, yet there is a StructFind() function. Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: free sql tool
Third. Their tools are sweet. -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 9:56 AM To: CF-Talk Subject: RE: free sql tool I'll second that, were big fans of red gate too. Thanks Dave -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 10:54 AM To: CF-Talk Subject: RE: free sql tool Holy cow, that tool is awesome! Thanks for the heads up. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:32 AM To: CF-Talk Subject: free sql tool http://www.red-gate.com/products/SQL_Prompt/index.htm get it while its free This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any reason why a file field can be submitted back to the page it's on?
There you go again, Dave. You need to really stop throwing logic into these conversations. It gets really annoying. :) Mike -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 11:13 AM To: CF-Talk Subject: RE: Any reason why a file field can be submitted back to the page it's on? Once I see all motorists, whether driving a car, truck, or motorcycle forced to wear helmets to protect the state from the costs of uninsured motorists' injuries, then I'll believe lawmakers created a helmet law which is fair, worthy of respect, and doesn't just single out a particular group to which to apply the law because the lawmakers aren't inconvenienced by the law they created. A quick perusal of comparative head injury rates between motorcyclists and automobile drivers should help you understand why it's a bigger issue with motorcyclists. If you go over the handlebars, and you're not wearing a helmet, chances are very good that someone's going to be mopping your brains off the road. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any reason why a file field can be submitted back to the page it's on?
The reason you don't need helmets on car drivers is that the law of diminishing returns applies when you are talking about a 2nd or 3rd layer or protection (car + air bags + helmet) vs. the first layer of protection (helmet alone), as is the case of a motorcycle. It should also be noted that a seriously injured non-helmet wearing motorcyclist would not be the only victim in such an accident. Say I accidentally pull out in front of a motorcycle and hit him. The guy wearing a helmet has a concussion, broken arm, and broken leg. The guy not wearing a helmet dies. When it's all said and done, I and my insurance company (for those that actually have insurance) get sued for 50,000 in the first case, 1 million in the latter, and I rightfully lose both, I'm sure. It may sound callous, but such laws as the helmet and seat belt laws protect much more than the person under the belt or helmet (other motorists, hospitals and the state if un/under insured, insurance companies, etc.) This should be OT, so if you want, we can continue this discussion over there. Mike -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 3:53 PM To: CF-Talk Subject: Re: Any reason why a file field can be submitted back to the page it's on? But, even very minor accidents, when they involve uncovered motorcyclists lead overwhelmingly often to critical injury or death, whereas minor accidents involving non-motorcyclists, even uncovered ones, rarely lead to anything but a ruined day and a trip to the body shop. Sorry, the argument was too tempting and I had to jump at it. --Ferg Rick Faircloth wrote: But, I would dare say without actually studying the data, that there are so many more non-motorcycle drivers, that there would surely be more head injuries for those drivers than for motorcyle drivers...and surey more uninsured non-motorcycle driving motorists, leading to more cost to the state for head injuries for non-motorcycle drivers. If the data proves me wrong, so be it. But I doubt *any* data would show that to be the case, since the ratio of motorcycle drivers to all others vehicles would be miniscule... But that still doesn't answer the question as to why lawmakers wouldn't require helmets for all motorists if there only concern was to save lives and money...because if we all strapped them on all the time, we certainly would save both. Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 12:13 PM To: CF-Talk Subject: RE: Any reason why a file field can be submitted back to the page it's on? Once I see all motorists, whether driving a car, truck, or motorcycle forced to wear helmets to protect the state from the costs of uninsured motorists' injuries, then I'll believe lawmakers created a helmet law which is fair, worthy of respect, and doesn't just single out a particular group to which to apply the law because the lawmakers aren't inconvenienced by the law they created. A quick perusal of comparative head injury rates between motorcyclists and automobile drivers should help you understand why it's a bigger issue with motorcyclists. If you go over the handlebars, and you're not wearing a helmet, chances are very good that someone's going to be mopping your brains off the road. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241529 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Google Analytics?
hmm, it's almost as if you are looking over my shoulder, blogging about what I'm doing incorrectly! Thanks a lot. Mike -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 8:37 AM To: CF-Talk Subject: Re: Google Analytics? Hi Mike - check this post out: http://succor.co.uk/index.cfm/2006/2/13/Google-analytics---urchin On 22/05/06, Mike Klostermeyer [EMAIL PROTECTED] wrote: Since it appears many here use Google Analytics, I have a question. Does anyone use it over an SSL connection (during the checkout process of a cart, for example)? I can't figure out how to use it without throwing browser security warnings (domain name does not match, etc.). Any way around this? Mike -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Sunday, May 21, 2006 12:29 PM To: CF-Talk Subject: Google Analytics? What is this? I got an invitation, but I'm not sure what it is. Is it more than just google's version of web trends? Anyone using it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241206 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Google Analytics?
Since it appears many here use Google Analytics, I have a question. Does anyone use it over an SSL connection (during the checkout process of a cart, for example)? I can't figure out how to use it without throwing browser security warnings (domain name does not match, etc.). Any way around this? Mike -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Sunday, May 21, 2006 12:29 PM To: CF-Talk Subject: Google Analytics? What is this? I got an invitation, but I'm not sure what it is. Is it more than just google's version of web trends? Anyone using it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241124 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Google Analytics?
I'm still getting the security warning. Any ideas what I need to do? Mike -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 11:24 AM To: CF-Talk Subject: RE: Google Analytics? This must no longer be true; I just set up Analytics last month on our SSL site and after searching their online help for SSL and following the instructions, all is working well. Maybe it was just a temporary glitch. The SSL certificate seems to be fine now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241149 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Google Analytics?
Found the problem. I had the wrong SSL URL. Doh! Thanks for everyone's help. Mike -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 3:36 PM To: CF-Talk Subject: Re: Google Analytics? Mike, Did you check out my post? Aldon, . it can be slower but be sure to put the script at the end of you page - just before the /body tag. HTH On 22/05/06, Aldon [EMAIL PROTECTED] wrote: I have found Google Analytics to increase load time making my pages slower. Has anyone found a solution to this? Al -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 12:10 PM To: CF-Talk Subject: RE: Google Analytics? This must no longer be true; I just set up Analytics last month on our SSL site and after searching their online help for SSL and following the instructions, all is working well. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 7:37 AM To: CF-Talk Subject: RE: Google Analytics? Since it appears many here use Google Analytics, I have a question. Does anyone use it over an SSL connection (during the checkout process of a cart, for example)? I can't figure out how to use it without throwing browser security warnings (domain name does not match, etc.). Any way around this? Unfortunately, the SSL portion of Google Analytics is slightly broken. They have SSL set up so that you can fetch their files, but their certificate doesn't match the URL used to fetch the files. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241174 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Server Backup Solutions
Thanks, everyone. I'll add to the list one that I just found: http://www.backup4all.com/. Seems to cover most of my needs, all for $45. I'll check this one out as well. Mike -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:03 PM To: CF-Talk Subject: RE: Server Backup Solutions Try www.2brightsparks.comSyncBackSE $20 or so...I run backup services for some of my customers to an FTP here at my studio. Works like a charm...and it's VERY inexpensive... Rick -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:15 PM To: CF-Talk Subject: RE: Server Backup Solutions Both http://www.acronis.com and http://www.ultrabac.com offer great products. We use both. Not sure what price range you're looking for. $699 to $999 per server is a great price to pay if you ever need to put your disaster recovery plan to work. -e -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 3:58 PM To: CF-Talk Subject: RE: Server Backup Solutions Thanks. Now thinking about it, an ideal solution would be able to manage, say, a weeks worth of daily backups, on a rotating basis. Any other ideas? Mike -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 2:15 PM To: CF-Talk Subject: RE: Server Backup Solutions I use the standard NT Backup that comes with Windows. I made sure my drive mappings were setup and then scheduled Backups from that to a tape. Now ideally would be awesome to have the auto-tape changer System. I have seen it before but the project I am on, well Lets say we do with what we have or what we can scrounge for. -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 3:07 PM To: CF-Talk Subject: OT: Server Backup Solutions Curious if anyone has some suggestions for server backup software. I need to backup (probably to a separate drive cage) web servers and database servers in a Microsoft environment, and looking for any input or experiences. I don't need much, but some requirements are to be able to put backup process on a scheduler, compression, and obviously, the cheaper the better. Thanks. Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241175 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Print Friendly Version
create a PDF with CFDOCUMENT -Original Message- From: Raven Technology [mailto:[EMAIL PROTECTED] Sent: Friday, May 19, 2006 9:16 AM To: CF-Talk Subject: Print Friendly Version Can anyone assist in how to offer the user to print a friendly version of a web page? Steve LaBadie Raven Technology http://www.ravenpcs.com [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Why is there query.recordcount with non-SELECT queries?
I wouldn't say that. Sometimes it is helpful to know how many records were updated or deleted without having to do a select query beforehand. Is there a Java service factory way of getting at this information? Mike -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 10:22 AM To: CF-Talk Subject: Re: Why is there query.recordcount with non-SELECT queries? As I recall, the value gets returned, but always says 0. It's not useful for anything other than select queries. On 4/18/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: Should queries that do an update return a queryname.recordcount variable? I'm trying to determine how many records get changed during an update statement. Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238010 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: maximum number of files in directory
I've served images from a Windows 2000 Server that was fine until it reached 20,000-30,000, at which point it became unstable. Mike -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 10:19 AM To: CF-Talk Subject: RE: maximum number of files in directory Thanks all, I was pretty sure that 10-20,000 was way too much but not certain how best to organize it. I'm still thinking it through. Thanks about the point regarding category. (Category would not be a good choice, since someone may choose the wrong category first, then update the product.) Since each item will have at least two accompanying photos I'll probably do something along the line you suggest but probably bring it down to 100 or 250 instead of a thousand. Thanks Gil -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 9:58 AM To: CF-Talk Subject: Re: maximum number of files in directory or maybe categories (dresses, denim, jewelry) (the advantage of this would be fewer directories than designers) You could also use some better balanced subdivision. For instance, if you have some numerical Id nb, use the three last digits as the file name, and the rest for the directory. This way, when the directory has 1000 files, a new one is created, etc. Use something that cannot be changed in your database, so that you do not have to move the files when data is changed. Category would not be a good choice, since someone may choose the wrong category first, then update the product. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237422 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: help with list values in db
No. In your version, '5' would be incorrectly found in the list '50,150,250', whereas it would NOT be found in the SQL below. Another route to go if you are using SQL Server (possibly others as well) is to find or create a user defined function in SQL that parses lists. I've used this before it works very well, though I don't know which is most efficient. Mike -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 12:04 PM To: CF-Talk Subject: RE: help with list values in db SELECT [column list] FROM [table] WHERE catid LIKE '#ID#' OR catid LIKE '#ID#,%' OR catid LIKE '%,#ID#' OR catid LIKE '%,#ID#,%' Couldn't that WHERE clause be consolidated into one line such as: WHERE catid LIKE '%#ID#%' Or is there some performance benefit of using the four variations? Since using the LIKE clause can be a performance killer. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of Queries
By chance is one or more of the possible values of code a number? Mike -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, March 31, 2006 12:44 PM To: CF-Talk Subject: Query of Queries I don't use QofQ much and am having some troubles that maybe someone can help with. I am building a query called getShipping that populates code, description, rate. I am then running a query of queries checking on the selected rate. cfquery name=shipping dbtype=query SELECT code,description,rate FROM getShipping cfif StructKeyExists(order, shipMethod) cfif order.shipMethod Neq WHERE code = '#order.shipMethod#' /cfif /cfif /cfquery The problem is erroring out on the WHERE code = '#order.shipMethod#' ... even if it has a valid method (ie FEDEXGROUND) it is giving the following error: Query Of Queries runtime error. Unsupported type comparison. 1) does anyone see any problem with this? 2) Is there anotherway of getting a specific row/column value out of a query result set ? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236724 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update on eolas/cfform/cfchart fixes
I've seen reference to cfdocument in this thread. Is it going to be a problem as well? -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Thursday, March 30, 2006 2:38 PM To: CF-Talk Subject: RE: Update on eolas/cfform/cfchart fixes As mentioned numerous times, the problem isn't regular content, but files generated dynamically like Flex, CFForm or CFChart. !k -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: March 30, 2006 1:44 PM To: CF-Talk Subject: Re: Update on eolas/cfform/cfchart fixes At work, we have found this workaround to be highly flexible: http://blog.deconcept.com/flashobject/ Cutter Anthony Prato wrote: let me start by saying please don't post in this thread about IE/ActiveX being good or bad. Yes most of us hate it, but this change is coming in less than 2 weeks. I've been to the Active Content Center. http://www.macromedia.com/devnet/activecontent/ Unfortunately it does not provide any fixes for the flash automatically generated by Coldfusion. Nor does it provide any info on a forthcoming fix. Can someone from Adobe please respond to this! I'm amazed I have to say this, but I think Dave is wrong. :p From everything i have read the change will be included in a security update on April 11. This means people WILL install it. Most organizations have become very diligent in installing these security patches. I downloaded the IE update to test myself and all the CF generated flash loads inactive. I've already rewritten the code to display my cfdocuments using the Microsoft workaround example. (document.write() in included javascript) However, cfdocument is easy because it will leave the actual flash/pdf binary in its place. When CF processes a cfform tag it only leaves the html to load the flash in its place. Because of this I do not know how to use and of the included JavaScript workarounds for flash forms. Has anyone found a workaround? Can someone from Adobe comment? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Verity - cfsearch and cflock
I understand from the documentation that it is no longer best practice in CF7 to use cflock around cfsearch. Does this apply to CFMX a well? Mike Klostermeyer [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Verity K2 on CFMX 7?
I have CFMX7 Standard. I am trying to duplicate a site in CFMX 6 on our CF 7 server. To do so requires me to set up a K2 Verity collection, but only see the Verify Collections link in the CF Admin (no links to access the Verity K2 Server). The CFMX 7 Search Server service is running. Did anything change regarding Verity between these versions? Mike Klostermeyer [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFIF and null values
Use the isNull() function directly in the SQL. Mike -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 2:50 PM To: CF-Talk Subject: Re: CFIF and null values What is the data type of the field in the database? If it is a char, it could be an empty string of the length of the field specification, ie char(10). In which case, adding a trim to the function should work - trim(len(expr3)) eq 0 Steve Richard Colman wrote: I have a null value being returned from a query. I would like to catch it and give it a value before proceeding. So, assuming that CF returns a null value as a null string, I tried the following: cfif len(expr3) eq 0 CFSET expr3 = 0 /cfif Also cfif expr3 = CFSET expr3 = 0 /cfif However, neither of these are working. Any suggestions appreciated. Rick Colman ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236178 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFIF and null values
Sorry, you are right. Meant to mention that, but forgot. Mike -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 3:02 PM To: CF-Talk Subject: RE: CFIF and null values Use the isNull() function directly in the SQL. FYI, coalesce() is ANSI standard, isNull() is proprietary Microsoft syntax. --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236194 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: FTP server
Can anyone recommend an FTP server for Windows 2003? The easier to manage users/permissions the better (which is why we are trying to stay away from IIS). Ideally it should be able to run as a service, and also be able to listen to two ports, either within the same service or separate services. Thanks. Mike Klostermeyer [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232756 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Flash CFForm Style
I need to be able to set the background color of a Flash CFForm DateField input box. Any idea how to do this? Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flash CFForm Style
Great, thanks!
Mike
-Original Message-
From: Michael Grove [mailto:[EMAIL PROTECTED]
Sent: Friday, February 03, 2006 2:21 PM
To: CF-Talk
Subject: Re: Flash CFForm Style
I have been working on a form with custom colors.. here is the code I found
and am using. There are alot of global styles listed below. For background
color you only need one, but I figured I will give you all that I have and
let you pick out what you need.
cfform name=myform height=450 width=465 format=Flash
onload=formOnLoad()
cfformitem type=script
function formOnLoad()
{
// Do anything that you need to do in the onload Event
// call the function that is in charge of applying the
styles
applyStyles();
}
function applyStyles()
{
_global.styles.CheckBox.setStyle(fillColors,
[0xa7a7a7, 0xff]);
_global.styles.RadioButton.setStyle(fillColors,
[0x006699, 0xff]);
_global.styles.Form.setStyle(color, 0x00);
_global.styles.Button.setStyle(borderThickness, 1);
_global.styles.Panel.setStyle(backgroundColor,
0xE5F0F9);
_global.styles.Panel.setStyle(color, 0xff);
_global.styles.Panel.setStyle(headerColors,
[0x277DC6,0x50ABF7]);
_global.styles.HBox.setStyle(backgroundColor,
0x757575);
_global.styles.HBox.setStyle(marginTop, 10);
_global.styles.HBox.setStyle(marginBottom, 10);
_global.styles.HBox.setStyle(marginLeft, 10);
_global.styles.Accordion.setStyle(fillColors,
[0x547000,0x739802]);
_global.styles.Accordion.setStyle(selectedFillColors,
[0x84af00,0xa3d800]);
_global.styles.Accordion.setStyle(themeColor,
0x0066cc);
_global.styles.Accordion.setStyle(color, 0x0ff);
_global.styles.TextArea.setStyle(fontSize,14);
_global.styles.TextInput.setStyle(fontSize,9);
_global.styles.DataGrid.setStyle(rollOverColor,
0xf5ffd7);
_global.styles.DataGrid.setStyle(selectionColor,
0x84af00);
_global.styles.DataGrid.setStyle(headerColors,
[0xa6a6a6,0xe2e2e2]);
!--- _global.styles.Tab.setStyle(fillColors,
[0x277DC6,0x50ABF7]);
_global.styles.Tab.setStyle(selectedFillColors,
[0xff6600,0xffcc00]);
_global.styles.VBox.setStyle(backgroundColor,
0x507A9C);
_global.styles.ComboBox.setStyle(fillColors,
[0x006699, 0xff]);
_global.styles.ComboBox.setStyle(backgroundColor,
0x006699);
_global.styles.CalendarLayout.setStyle(rollOverColor,0x996699);
_global.styles.CalendarLayout.setStyle(selectionColor,0xcc33ff);
_global.styles.CalendarLayout.setStyle(todayColor,0xcc33ff);
_global.styles.ErrorTip.setStyle( borderColor,
0x339900);
_global.styles.ErrorTip.setStyle( color, 0x00);
_global.styles.DataGrid.setStyle(alternatingRowColors,
[0xff,0xf5ffd7]); ---
}
/cfformitem
cfformgroup type=hBox
cfformgroup type=accordion width=435 height=420 label=Containers
cfformgroup type=page label=employee accounts
!--- onchange=getUrl('WizEmployeeReview.cfm?userid=' +
grid.dataProvider[grid.selectedIndex]['userid']); ---
cfgrid name=grid height=320 width=405 query=ListUsers insert=No
delete=No sort=No autowidth=true appendkey=No highlighthref=No
enabled=Yes visible=Yes griddataalign=LEFT gridlines=no
rowheaders=No rowheaderalign=LEFT rowheaderitalic=No
rowheaderbold=No colheaders=Yes colheaderalign=LEFT
colheaderitalic=No colheaderbold=no selectmode=SINGLE
cfgridcolumn name=lname header=Name (last) headeralign=LEFT
dataalign=LEFT bold=No italic=No select=Yes display=Yes
cfgridcolumn name=fname header=Name (first) headeralign=LEFT
dataalign=LEFT bold=No italic=No select=Yes display=Yes
headerbold=No headeritalic=No
cfgridcolumn name=location_title header=Location headeralign=LEFT
dataalign=LEFT bold=No italic=No select=Yes display=Yes
headerbold=No headeritalic=No
/cfgrid
/cfformgroup
cfformgroup type=page label=account review / edit
cfformgroup type=horizontal label=Name (first/last): visible=Yes
enabled=Yes
cfinput type=Text name=fname bind={grid.selectedItem.fname}
width=100 message=First Name is required validate=noblanks
required=Yes visible=Yes enabled=Yes
cfinput type=text name=lname bind={grid.selectedItem.lname}
width=100 required=true validate=noblanks message=Last name is
required
/cfformgroup
cfinput
RE: db eamil cleaner
By selecting the ID along with the email (assuming a autonumber-type ID), you will return all records, nullifying the desired result of the distinct. Mike -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 2:23 PM To: CF-Talk Subject: RE: db eamil cleaner I don't have a script but the basic idea would look like this: Select distinct email addresses and the id with it. Then delete all records whose ID is not in that list. Then, I'd use a regex to loop over the emails, compare them to the regex and if it's not valid, delete the record. I hope that helps. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 3:18 PM To: CF-Talk Subject: Re: db eamil cleaner really only 2 fields: id (primary) and tbl_email, pretty simple ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Rick Root [EMAIL PROTECTED] Sent: Thursday, February 02, 2006 3:15 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: db eamil cleaner dave wrote: anyone have a good script to run through a mysql db and remove duplicate(but leave 1) and improper emails? That would totally depend on your database design =) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: db eamil cleaner
This will give you the emails in question, but it doesn't give you the ID's that you need in order to remove them safely. Ben's idea of joining the table to itself (earlier post): select id from emails as a, emails as b where a.id b.id and a.email = b.email is darn near brilliant in my view, as I've always struggled to wrap my hands around this problem. You could then wrap a delete statement around that above select query to knock them out in one punch. Thanks Ben! Mike -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 3:01 PM To: CF-Talk Subject: RE: db eamil cleaner Select emailAddress from emails group by emailAddress having count(emailAddress) 1 And then do whatever you need to do with these ids... -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 3:52 PM To: CF-Talk Subject: Re: db eamil cleaner select id from emails as a, emails as b where a.id b.id and a.email = b.email This should give you your list of dups. --Ben dave wrote: The problem with that is when you use distinct and then add the ID field it no longer grabs only one email because the id field is a distinct number as well so you get all the records back not just one of each. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Burns, John D [EMAIL PROTECTED] Sent: Thursday, February 02, 2006 3:25 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: db eamil cleaner I don't have a script but the basic idea would look like this: Select distinct email addresses and the id with it. Then delete all records whose ID is not in that list. Then, I'd use a regex to loop over the emails, compare them to the regex and if it's not valid, delete the record. I hope that helps. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 3:18 PM To: CF-Talk Subject: Re: db eamil cleaner really only 2 fields: id (primary) and tbl_email, pretty simple ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Rick Root Sent: Thursday, February 02, 2006 3:15 PM To: CF-Talk Subject: Re: db eamil cleaner dave wrote: anyone have a good script to run through a mysql db and remove duplicate(but leave 1) and improper emails? That would totally depend on your database design =) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231209 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Debug execution times doesn't add up
I know I've seen this thread before, but I cannot find it on the archives. In the debug, the TOTAL EXECUTION TIME doesn't equal the sum of the individual template times in CF7. Which one is correct (if any)? Mike Klostermeyer [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230585 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cffunction with infinite number of parameters
Make the input argument of type 'struct'. Within the function you can then loop over it via the StructKeyList() function. Mike -Original Message- From: Oleg Gunkin [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 2:51 PM To: CF-Talk Subject: cffunction with infinite number of parameters How do I make a function with unlimited number of parameters, and how do I access these parameters? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Space on Drive.
I have used some stored procedures in SQL Server that gives drive free space. Of course, the server that you need the information from must have SQL Server installed on it. Mike -Original Message- From: J W [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 11, 2006 8:50 AM To: CF-Talk Subject: Free Space on Drive. Pretty Sinple but I couldn't find an answer searching... SO.. Is there any Coldfusion way to grab the free space on a particular drive? I know I can grab file sizes and such with cfdirectory and cffile, but really couldn't find an answer for free space. Thanks, Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229196 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flash Forms - Why Not?
I agree with the idea that flash forms should mirror html forms. A couple examples: 1. Not being able to name fieldnames the same. In HTML, it simply returns a comma delimited list upon submit, but throws an error in flash forms. 2. The calendar popup should have a way to quickly change the year rather than scrolling through the months (I know there are hacks for this, but it should be built in), and have a way to insert NO date. Currently if you have a date already selected, there is no way to clear it out. 3. File upload capability (I know there are hacks for this as well) 4. Get rid of the 64k limit/error 5. Ability to script new objects (currently the New keyword is not allowed) 6. CFGRID does not recognize a new row when it is inserted/created programmatically 7. Again, layout and page load time is a major pain in the butt, especially when dealing with dynamic forms that currently have to be compiles EVERY time. I realize some of these may be bugs and not features, but their existence made us dump our flash form development altogether. Mike -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 21, 2005 10:48 PM To: CF-Talk Subject: Re: Flash Forms - Why Not? Thanks for asking Tim, I'd like to see flash forms add to but NOT TAKE AWAY from html forms. Therefore, everything an HTML form does, ought to happen in flash forms. For example, make them respond to the mouse wheel. Make drop down menus drop down with a press of the down arrow key. etc. So people who are used to filling in forms in html find the flash forms behave in the same way ,but also add some cool new features, such as the calendar popup, and the validation with highlighting etc. As it is now, if you use flash forms, you can use the terrific calendar popup, and the cool way the field holding the current focus is highlighted etc but you lose other stuff. Accessibility and standards compliance is a major issue and growing in importance, specially on government and QANGO sites, so it would be good to have flash forms fully compliant with the accessibility standards. Also the biggest negative to flash forms is the time to load. I had one I thought was pretty cool, with a lot of neat things on it, but the client said it didnt work. When I investigated some more, it turned out he was using a dialup connection and hadn't waited long enough for the loading graphic to appear even, let alone the whole form. I'm busy changing the form now to a XML format one, based on the example in CFFORMS.com. I really like the following aspects: [A] you're making the CFFORM concept work. In CF5 it looked terrific in the specs, but failed to deliver the goods. It now looks like we're pretty close to the goods. [B] The ease of use for coders is terrific. I have written a codegenerator that creates basic forms off a datasource table, and then I tweak from there. Far less time spent writing validation scripts etc. [C] I love the simple way you can make wizard-style forms and concertina styles. Merry Christmas!! Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227506 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Keeping a session alive
so if they are in the middle of typing War and Peace in a form field when the JS kicks off, they lose it all? Mike -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Thursday, December 01, 2005 1:22 PM To: CF-Talk Subject: Re: Keeping a session alive Ive got a js routine that does just this. Basically you set it to a minute less than your session timeout. If it expires, it reloads the page they are on. Just dont want to use it with any pages that you post to. Let me know if you want it. On 12/1/05, Bobby Hartsfield [EMAIL PROTECTED] wrote: Hello there... I've been kicking around ideas of how to keep a user's session 'alive' once they get logged in on a site. The scenario is a common one... An admin logs into the backend tools to add something. They sit on a form typing in a long, long news article or something When they are finally done an hour later, they go to submit it and their session has died and they have to log in again... then all the info they entered is gone and I get yelled at. :) I do NOT want to use cookies on these sections so I need something to keep hitting a page (really any page I guess) in the background to keep the session alive as long as their browser is open. I thought about a frame with a meta refreshed page in it but that's not very creative :) I thought about a tiny swf to do basically the same thing... that's a little better I guess. And I thought about a JS routine to occasionally fire itself based on a timer to do an httprequest to another page that will: Check the session (if it's still active, that would reset its timeout right?) If it's active, return active or whatever. If it's inactive, pass along the encrypted login info to log them back in and return active If for any reason the session is dead and cant be reset, return inactive so a hidden div or JS alert can inform them to at least copy what they have written in the field so they don't lose it because they are going to have to log in again. If the user ever got to the page, their session was active and valid so any login info could be ported from the session scope the variables scope on that page and used anytime I wanted. (like for logging them back in) I obviously like the last 'idea' better due to the elaboration :) but wanted to know what others thought about it or if you guys and gals had another solution I haven't thought of. (short of turning the session timeout up to some ridiculous amount of time) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.10/189 - Release Date: 11/30/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225849 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Authorize.net request
Hello all, I'm hoping someone out there has an example they could share for a SIM request to authorize.net that generates the required fingerprint. Mike Klostermeyer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: Rumors from Max...
what exactly are we talking about here? Mike -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 10:32 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max... macromedians are more prevalent than you might think. i have NEVER had a moment, where i couldnt get up with at least one of them. now thats cool. tony On 11/3/05, Andy McShane [EMAIL PROTECTED] wrote: From my personal experience I have to say that the help support offered by Bluedragon is second to none, the willingness and eagerness to help is a total breath of fresh air. Regardless of whether Coldfusion goes open source or not I for one prefer to know that there is someone 'from the company' available for help. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223034 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Oracle IN limit
If you have a subquery within the IN, no, there is no limit. If you specify individual items (1,2,4,2, etc.), I have reached a limit with SQL Server, but I don't recall what it was (well into the 5 figures). A subquery is the best solution. Mike -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 3:01 PM To: CF-Talk Subject: Oracle IN limit Does anyone know if there is a limit to how many items I can put in an IN clause? Bob ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Bug :- functions return additional spaces(!)
Yes, I found this as well. I did my own work-around, but it is not fit for public reading! Mike -Original Message- From: Peter Coppinger [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:22 AM To: CF-Talk Subject: ColdFusion Bug :- functions return additional spaces(!) When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT Joins
That is not true. In SQL Server: select * from a, b where a.col *= b.col is a left join Mike -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 7:56 PM To: CF-Talk Subject: Re: OT Joins The type of join is not related to where the join takes place. Except that the WHERE clause only allows for INNER JOINs, and the FROM clause can have OUTER, LEFT, RIGHT, and INNER JOINs. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT Joins
I never said that it was. You stated that it was impossible, which is incorrect. Notice the ...In SQL Server... proceeding the code. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, October 20, 2005 9:38 AM To: CF-Talk Subject: Re: OT Joins That is not true. It is not standard either. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using try/catch all over the place a good thing?
Done that as well, but evidently I was a lot more patient than you, as I generated 34,000 emails! Mike -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 10:21 AM To: CF-Talk Subject: RE: Using try/catch all over the place a good thing? I had a very funny experience with cftry/catch. I was taking responsibility for a huge and kludgey application that was the result of 2-3 different developers over time. The developer before me had put try/catches all over the place. They just caught 'any' and emailed him the error. I wasn't really paying attention to this until one day I accidentally created an infinite loop on a page. I was trying to figure out why my page was just sitting and spinning with nothing happening, then I decided it must be stuck in a loop. No big deal, I fixed it and moved on. A couple of hours later I got a call from the previous developer, who had just received 2-3 thousand emails from the app! Serves him right for setting it up that way. :-D -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 6:46 AM To: CF-Talk Subject: RE: Using try/catch all over the place a good thing? I missed commenting on the EVERYTHING since I thought he was looking for a solution to this... I can see a problem though where the cffile might work, then the query fails but you don't know it you probably want to let the user know about it Usually, yes, but again, there are plenty of occassions where you do not want to do that or do not want to interrupt the remaining experience because of a trivial error. As for the planets being aligned... I usually just tell them they have to hold their mouth right when surfing lol ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: security suggestions?
I'd figure there are more security concerns when you involve the human error factor Not only error, but theft as well. I put myself through college working retail at a nationally known retailer, and I had access to every one of our customers credit card numbers, anytime I wanted. It boggles my mind when people are scared to death to give their SSN or credit card # over the internet, but won't think anything about freely give their credit card to a broke 16 year old running the cash register. Mike -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 1:54 PM To: CF-Talk Subject: Re: security suggestions? Thanks, Jerry, Justin. I'm going to write all this down and make sure I address all these concerns. Justin, you may be right. Spending thousands of dollars to have a loan app online that may or may not be used seems like a silly waste of money to me. Sometimes new technology isn't always betteralthough, like Jerry said, it is just as much of a concern when you have a paper version. It just isn't perceived that way, which is weird, because I'd figure there are more security concerns when you involve the human error factor: Now where is that Loan App? Hmmm, must have left it in the lunchroom/restaurant/bathroom/ Jerry Johnson wrote: There is the transaction/filling out of information and how it is sent. Then there is the issue of how and what is stored. Then there is the issue of how and what is pulled back out and what is done with it. Then there is the issue of what system maintenance or backups replicate the data. Then there is the issue of what other systems share the same space How secure is the db box (and lan) that the data will be stored on? Does the CF server that gets the information have write-only access to that db, or can it also read (and potentially display?) What admin/reporting features are you going to put into place to retrieve the data? How secure are they? Can the reporting pages/reports be cached onto non-secure client boxes? Can the information be printed to a printer? Can it be copied or sent via email? How is it retained? The same questions that would need to be answered if they wanted to implement a fax-in loan application (where do they store the paper, who can access it, is it locked up, how do ou destroy it, etc). On 10/13/05, Ray Champagne [EMAIL PROTECTED] wrote: We have a potential customer that is a bank (a small local one). They want to be able to have people fill out a loan application online, but are worried about security, etc. Other than using a secure certificate and SQL Server, are there any other considerations I should give to security? Sorry this is such a broad question, but I really don't know any other things I should be worrying about. Here's a list that I've thought out, but this is all really elemntary stuff: Use cfqueryparam always Use POST vs GET Use SQL Server Use SSL Only allow retireval of data via the web site, not send any info in emails ??? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220956 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Maxewd out ntext in SQL Server. Now what?
Yikes, are they storing War and Peace? If you can/want to break it out of the DB, write it to a file then store the file location in the DB. This would require an initial pass to write out the data already in there and some CF work to pull the data in a different way (files vs. DB), but it would work. Mike -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 2:27 PM To: CF-Talk Subject: Maxewd out ntext in SQL Server. Now what? Sheesh - in a Newsletter system I've set up for a client, each separate story for the newsletter gets stored in a SQL Server ntext field. They just managed to MAX it out! A. I need Unicode. B. I need more storage than the ntext field is allowing C. Can't bust what's already there (over 100 newsletters with multiple stories each all stored in the ntext field) Suggestions? -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220597 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
A couple problems with this: 1. Typically you will want to sort on something other than the ID (date, alpha, etc.) 2. This query will return all records from the 200th record through the end of the table. If this table has a million records, you will be returning A LOT of data that you don't need. Sorry, but to my knowledge, there is nothing built into SQL Server that allows this type of filtering. Mike -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 8:50 AM To: CF-Talk Subject: RE: SQL row select? Select top 50 * from table where id not in (select top 199 id from table order by id) I think that will work. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 9:49 AM To: CF-Talk Subject: Re: SQL row select? The syntax is different for each DB, but if I remember correctly -- MS SQL uses the TOP keyword. SELECT TOP(50) * FROM TABLENAME WHERE BLAH=BLAH Burns, John D wrote: Ok, I feel like this should be something simple but my brain just isn't working this morning. Besides using CFOUTPUT with the startrow and maxrows attributes, is there a way in my SQL itself to specify that I want it to grab 50 rows starting at the 200th row. I'm trying to make a paged approach to a query that could potentially have about 20,000 records returned. I'd much rather just have MS SQL return 50 rows at a time by telling it which row to start at rather than having it return a 20,000 recordset to CF and then only output 50. I'm hoping this is something easy and my brain just hasn't woken up yet. Any thoughts would be appreciated. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219422 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
No, you are not missing something, just an early morning for me. Sorry to misinform. Mike -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 9:04 AM To: CF-Talk Subject: RE: SQL row select? 1) So sort on something else ( Select top 50 * from table Where id not in ( select top 199 id from table order by date, alpha) order by date, alpha 2) This query will return 50 records. Am I missing something? Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 10:01 AM To: CF-Talk Subject: RE: SQL row select? A couple problems with this: 1. Typically you will want to sort on something other than the ID (date, alpha, etc.) 2. This query will return all records from the 200th record through the end of the table. If this table has a million records, you will be returning A LOT of data that you don't need. Sorry, but to my knowledge, there is nothing built into SQL Server that allows this type of filtering. Mike -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 8:50 AM To: CF-Talk Subject: RE: SQL row select? Select top 50 * from table where id not in (select top 199 id from table order by id) I think that will work. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 9:49 AM To: CF-Talk Subject: Re: SQL row select? The syntax is different for each DB, but if I remember correctly -- MS SQL uses the TOP keyword. SELECT TOP(50) * FROM TABLENAME WHERE BLAH=BLAH Burns, John D wrote: Ok, I feel like this should be something simple but my brain just isn't working this morning. Besides using CFOUTPUT with the startrow and maxrows attributes, is there a way in my SQL itself to specify that I want it to grab 50 rows starting at the 200th row. I'm trying to make a paged approach to a query that could potentially have about 20,000 records returned. I'd much rather just have MS SQL return 50 rows at a time by telling it which row to start at rather than having it return a 20,000 recordset to CF and then only output 50. I'm hoping this is something easy and my brain just hasn't woken up yet. Any thoughts would be appreciated. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
MSSQL does not support LIMIT. Sure wish it did. Mike -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 10:42 AM To: CF-Talk Subject: RE: SQL row select? Did no one see this post? After reading, and re-reading the original post, it looks like this simple SQL statement is the answer (assuming that MSSQL supports the LIMIT clause: SELECT * FROM tablename LIMIT #startrow#, #totalrecords# or SELECT * FROM tablename LIMIT 200, 50 !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 8:57 AM To: CF-Talk Subject: RE: SQL row select? I don't use MS SQL but doesn't it support the LIMIT keyword in the SELECT statement? SELECT * FROM tablename LIMIT #startrow#, #totalrecords# or SELECT * FROM tablename LIMIT 200, 50 !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- Ok, I feel like this should be something simple but my brain just isn't working this morning. Besides using CFOUTPUT with the startrow and maxrows attributes, is there a way in my SQL itself to specify that I want it to grab 50 rows starting at the 200th row. I'm trying to make a paged approach to a query that could potentially have about 20,000 records returned. I'd much rather just have MS SQL return 50 rows at a time by telling it which row to start at rather than having it return a 20,000 recordset to CF and then only output 50. I'm hoping this is something easy and my brain just hasn't woken up yet. Any thoughts would be appreciated. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219452 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
The ultimate result will be 50 records, but the NOT IN clause is very inefficient, especially when dealing with what is essentially a list of record ID's from 200- 1 million. Bottom line, when using SQL Server there isn't much you can do to improve efficiency. You may want to play around with performance differences while using the SQL 'solution' vs. using CF's built in startrow/endrow attributes to the CFoutput tag. Depending upon usage variables, one may be better than the other. Mike -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 10:59 AM To: CF-Talk Subject: Re: SQL row select? Select top 50 * from table Where id not in ( select top 199 id from table order by date, alpha) order by date, alpha that works but what if you are paging through a million records as suggested before? wouldnt the inner query select the top 999,999 rows? IE Select top 50 * from table Where id not in ( select top 99 id from table order by date, alpha ) order by date, alpha I think thats what Mike K was talking about. On 9/28/05, Andy Matthews [EMAIL PROTECTED] wrote: Did no one see this post? After reading, and re-reading the original post, it looks like this simple SQL statement is the answer (assuming that MSSQL supports the LIMIT clause: SELECT * FROM tablename LIMIT #startrow#, #totalrecords# or SELECT * FROM tablename LIMIT 200, 50 !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 8:57 AM To: CF-Talk Subject: RE: SQL row select? I don't use MS SQL but doesn't it support the LIMIT keyword in the SELECT statement? SELECT * FROM tablename LIMIT #startrow#, #totalrecords# or SELECT * FROM tablename LIMIT 200, 50 !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- Ok, I feel like this should be something simple but my brain just isn't working this morning. Besides using CFOUTPUT with the startrow and maxrows attributes, is there a way in my SQL itself to specify that I want it to grab 50 rows starting at the 200th row. I'm trying to make a paged approach to a query that could potentially have about 20,000 records returned. I'd much rather just have MS SQL return 50 rows at a time by telling it which row to start at rather than having it return a 20,000 recordset to CF and then only output 50. I'm hoping this is something easy and my brain just hasn't woken up yet. Any thoughts would be appreciated. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219464 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
There were a couple typos, but it works rather nicely. Try SELECT * FROM ( SELECT TOP 20 * FROM (SELECT TOP 220 * FROM table C ORDER BY C.column ASC) B ORDER BY B.column DESC ) A ORDER BY A.column ASC Mike -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 4:09 PM To: CF-Talk Subject: RE: SQL row select? Yup, tested it, works like a charm here mate. So unless you provide any more input as to why you think it doesn't work I won't be able to help you out. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 September 2005 6:58 AM To: CF-Talk Subject: RE: SQL row select? Not only the IN method work, but yours did not, at least on MSSQL. I tried it. Now that's not necessarily the most efficient solution around, but if you have millions and millions of records to parse through with CF, then you need a DBA to ensure proper indexing and all that jazz, so you can let him write it. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 4:24 PM To: CF-Talk Subject: RE: SQL row select? I would not expect an answer like that from a proper DBA. Not sure if we are talking about MS SQL or MySQL, but the idea is to work with subqueries. SELECT * FROM ( SELECT * TOP 20 FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 FROM yourTable C ORDER BY C.yourOrderColumn ASC) B ORDER BY B.yourOrderColumn DESC ) A ORDER BY A.yourOrderColumn ASC Where 200 is for example the current row you are on and 20 is the number of records you want to retrieve. The idea is to first get TOP currentRow + numberOfRowToRetrieve Then order descending and get the top 20 Then order ascending and select all This way you only transfer from the DB over the network what you need to, and the query is not inefficient, especially if you got the right indexes. Now, its early here, so I might have made a mistake, but you get the general idea. I think the previous sample with IN does not work, especially not efficient. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 September 2005 2:25 AM To: CF-Talk Subject: RE: SQL row select? Here's a post from a DBA I'm friends with: QUOTE Just pull the entire query over to CF and use query of queries, to grab your paged row sets. I work with record sets of millions and it works very nicely. /QUOTE !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 10:59 AM To: CF-Talk Subject: Re: SQL row select? Select top 50 * from table Where id not in ( select top 199 id from table order by date, alpha) order by date, alpha that works but what if you are paging through a million records as suggested before? wouldnt the inner query select the top 999,999 rows? IE Select top 50 * from table Where id not in ( select top 99 id from table order by date, alpha ) order by date, alpha I think thats what Mike K was talking about. On 9/28/05, Andy Matthews [EMAIL PROTECTED] wrote: Did no one see this post? After reading, and re-reading the original post, it looks like this simple SQL statement is the answer (assuming that MSSQL supports the LIMIT clause: SELECT * FROM tablename LIMIT #startrow#, #totalrecords# or SELECT * FROM tablename LIMIT 200, 50 !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 8:57 AM To: CF-Talk Subject: RE: SQL row select? I don't use MS SQL but doesn't it support the LIMIT keyword in the SELECT statement? SELECT * FROM tablename LIMIT #startrow#, #totalrecords# or SELECT * FROM tablename LIMIT 200, 50 !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- Ok, I feel like this should be something simple but my brain just isn't working this morning. Besides using CFOUTPUT with the startrow and maxrows
RE: ColdFusion MX 7 : New Features Survey
Yet the one question that I wanted .NET to appear in (what languages do you want CF to interoperate with) the only choices were PHP and Python! At least they provided an 'other' text box for write in votes. Mike -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:38 PM To: CF-Talk Subject: Re: ColdFusion MX 7 : New Features Survey Anyone esle find it interesting Macromedia ia asking about the .NET stuff...heh just found it funny Adam H On 9/26/05, Calvin Ward [EMAIL PROTECTED] wrote: A more work safe analogy couldn't have been used? I mean really. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 1:57 PM To: CF-Talk Subject: Re: ColdFusion MX 7 : New Features Survey I agree its written in such a way as to provide skewed results. This is going OT (please CF_comunity paranoids abstain...;-), but I remember a survey I had to compile when I was working in the Computer Center at university. snip ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is my site working in the US?
I noticed you are calling a .cfc directly from the currency drop down. Never seen this before, curious what the general consensus was on this practice. Mike -Original Message- From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 11:55 PM To: CF-Talk Subject: Re: Is my site working in the US? In canada too!...but there's no option for the canadian $ ... Andrew. sorry to be a pain, can any USA'ers have a quick check that http://www.solocc.com is live at the moment. regards mike (i have a very paranoid client !!) ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218868 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is my site working in the US?
Although in this particular case the risk is pretty low, depending upon what the cfc actually does, there seems to be a security risk exposing your CFC's to be available to anyone that can type a URL address in a browser. If others don't agree, please explain. Thanks. Mike -Original Message- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 3:42 PM To: CF-Talk Subject: RE: Is my site working in the US? Hi mike (good name !!) I pass 2 arguments - currency_id and return URL. The cfc grabs the new currency info sets them to session variables and then uses cflocation to return to previous page. mike -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 September 2005 8:30 a.m. To: CF-Talk Subject: RE: Is my site working in the US? I noticed you are calling a .cfc directly from the currency drop down. Never seen this before, curious what the general consensus was on this practice. Mike -Original Message- From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 11:55 PM To: CF-Talk Subject: Re: Is my site working in the US? In canada too!...but there's no option for the canadian $ ... Andrew. sorry to be a pain, can any USA'ers have a quick check that http://www.solocc.com is live at the moment. regards mike (i have a very paranoid client !!) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218874 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is my site working in the US?
You can still use the CFC function, but I would 'hide' them a little more via a function call from a .cfm script. Mike -Original Message- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 3:54 PM To: CF-Talk Subject: RE: Is my site working in the US? Fair enough. I will look at using an alternative call to the cfc. (it seemed so damn easy but...) mike -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 September 2005 8:50 a.m. To: CF-Talk Subject: RE: Is my site working in the US? Although in this particular case the risk is pretty low, depending upon what the cfc actually does, there seems to be a security risk exposing your CFC's to be available to anyone that can type a URL address in a browser. If others don't agree, please explain. Thanks. Mike -Original Message- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 3:42 PM To: CF-Talk Subject: RE: Is my site working in the US? Hi mike (good name !!) I pass 2 arguments - currency_id and return URL. The cfc grabs the new currency info sets them to session variables and then uses cflocation to return to previous page. mike -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 September 2005 8:30 a.m. To: CF-Talk Subject: RE: Is my site working in the US? I noticed you are calling a .cfc directly from the currency drop down. Never seen this before, curious what the general consensus was on this practice. Mike -Original Message- From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 11:55 PM To: CF-Talk Subject: Re: Is my site working in the US? In canada too!...but there's no option for the canadian $ ... Andrew. sorry to be a pain, can any USA'ers have a quick check that http://www.solocc.com is live at the moment. regards mike (i have a very paranoid client !!) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218879 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cf_twoselectsrelated
Does anyone have a version of cf_twoselectsrelated (or something similar) that accepts a parameter to 'preselect' records in the second select depending upon what is selected in the first? Thanks. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: QoQ Trouble for Column Names with Spaces
SELECT * FROM thetable ORDER BY [my column] Mike -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 1:01 PM To: CF-Talk Subject: RE: QoQ Trouble for Column Names with Spaces Give it an alias in your original query that doesnt have spaces. cfquery datasource=... Select my column as mycolumn -Original Message- From: Brendan Baldwin [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 11:15 AM To: CF-Talk Subject: QoQ Trouble for Column Names with Spaces Hi everyone -- I'm working for a client who has given me some Oracle stored procedures which return some fields that have SPACES in the columns returned. I want to apply sorting to the results, so I was going to use a CFQUERY DBTYPE=query and just ORDER BY selectively-- The problem is that I can't seem to reference column names that have spaces in them when doing a QoQ ! Anyone know how to reference column names with spaces in a QoQ? I've tried: SELECT * FROM thetable ORDER BY 'my column' SELECT * FROM thetable ORDER BY my column SELECT * FROM thetable ORDER BY [my column] SELECT * FROM thetable ORDER BY ['my column'] Any other Ideas? --Brendan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: frickin ie!!!!!!! quick new eyes on css
OK here. Mike -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Saturday, August 20, 2005 10:44 PM To: CF-Talk Subject: RE: frickin ie!!! quick new eyes on css Seems fine in frickin ie to me :) And yes, thats an ugly green lol -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, August 20, 2005 2:32 AM To: CF-Talk Subject: frickin ie!!! quick new eyes on css in ie the links in the right side link boxes dont work, supposed to high light ugly green. yet on ie it doesnt, go figure but could me developer error this time lol anyone see anything? http://www.elkhornflyrods.com/store/index.cfm tia ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Confused about this...
Nothing like writing beautiful code that does the wrong thing (been there a time or two)! Mike -Original Message- From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 10:24 AM To: CF-Talk Subject: RE: Confused about this... Lol Thanks for your help... I got it... I just knew if I didn't ask I would be starting at it until 1pm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 11:21 AM To: CF-Talk Subject: RE: Confused about this... Duh. I see that now. Thanks Isaac. :) Oh well, it looks elegant, though doesn't it? ;-) Dave -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 12:18 PM To: CF-Talk Subject: RE: Confused about this... Umm... I think the original code got you a bit confused... he wasn't setting a variable with the name s#loopcount# -- he was just displaying that in the page for reference. Kristopher, Try this: cfscript for(LoopCount=1;LoopCount LTE cookie.COMPASS.sid.count; LoopCount = LoopCount + 1) setVariable(Evaluate(s LoopCount),Evaluate(cookie.COMPASS.sid. LoopCount)); /cfscript I didn't test it, but it should work for you. Dave -Original Message- From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 10:43 AM To: CF-Talk Subject: Confused about this... I need to output the COOKIE.COMPASS.SID.#LOOPCOUNT# But I don't know hwo to??? Can anyone throw me a pearl? cfloop Index=LoopCount from=1 to=#cookie.COMPASS.sid.count# cfoutput s#loopCount# = #cookie.COMPASS.sid.#LoopCount# /cfoutput /cfloop s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Exam
I think there are basically two questions here: 1. Does being certified mean you are good? Obviously not. 2. Does being certified mean you have a better chance of getting hired? Possibly, and it certainly never hurts. Being certified might be the one line on your resume that peaks enough interest to call you in for an interview. Many HR teams know nothing about IT specifics, but if they see that you are certified in the languages they are interested in, they could be more likely to forward your resume to the hiring manager. In a nutshell, I don't see where it is ever a BAD thing (unless it is used to shield lack of actual experience), and it COULD be a GOOD thing. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 9:32 AM To: CF-Talk Subject: RE: ColdFusion Exam Just for clarification, I didn't' say that the certification will show that the coder is a good one...I just simply said if I was looking at two coders with the same level of experience, and the same 'apparent' ability, that I would choose the one with the certification over the one without. In other words, it's a tie-breaker in my mind. That's about it. I have 7 1/2 years of experience in CF and have never been certified in it, and still am not. It only took me 10 days to get my most recent contract at a pretty high rate, so I agree with Ken in the matter that my body of work pretty much gets me the job, not a certification (which I don't have anyway). However, most CF programmers nowadays do not have 7+ years of experience to show (most seem to be 2-3 year experienced coders) so in that case, when there is a large number of coders out there with about the same experience, having the certification will certainly not HURT someone, and in fact, helps to set them apart... Having said all that, all you coders out there with less than a year or two of experience in CF, don't assume that getting the certification will get you the job...it won't...remember, it's just a piece of paper. :) In fact, the only way to know whether you have found a 'good' coder (whatever that is) is to hire them and see how they produce over at least a couple of weeks, if not a month or more. You can make some pretty good assumptions from reviewing code, interviewing, testing, checking references, etc., but you will just never know. The first coder I ever hired looked great but after 90 days, I had to let him go. He took 6 weeks to do something I could have done in a few days. Oh, one more comment...tests oftentimes test memory skills, but I have found in all my coding projects knowing where to find the information you need (i.e. references, how to search for problems/solutions on the net, etc.) is the most valuable skill that someone can have. Typing speed doesn't hurt either. ;-) WhewI'm done now. Dave Robertson-Ravo, Neil (RX) wrote: That isn't really a good MO though - there is no guarantee that the person with the qualification is a better coder - in fact I remember when we hired some developers for a project we found that the exam guys were all straight out of the book kinda guys and new little or nothing about the real world. Not to say anyone with one is bad - that is never the case but adding Certified Advanced ColdFusion Programmer after your name doesn't swing any kudos. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2005 14:56 To: CF-Talk Subject: RE: ColdFusion Exam From: Robertson-Ravo, Neil (RX) I personally don't like or rate these exams - they mean nothing in the shadow of say a good MS qualification. By all means go for it if you want to but it doesn't make you any better than a geezer off the street without one. I can guarantee you this...if I'm hiring for a CF developer, and I have two developers who are about the same in experience, and whom both have good personalities from the interview, ever single time I'd hire the one with the certification over the one without. It proves that they care about their credentials, and that they took the time, and invested the money, to 'prove' that they could at least pass the exam. No, it doesn't prove how good of a programmer they will be, but it does set someone apart, and even in some cases, allows someone to command a bit higher rate than normal. Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212538 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe:
RE: CFDOCUMENT image zooming problem not resolved with MX7 hotfix 3?
Please contact me at [EMAIL PROTECTED] I'd appreciate working with you to get this resolved. Mike -Original Message- From: Rupesh Kumar [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 11:38 AM To: CF-Talk Subject: CFDOCUMENT image zooming problem not resolved with MX7 hotfix 3? This hotfix does not have a fix for the image zoom bug but image-crop bug. Fix for image zoom and some others will be available in the updater. Mike, could you please give the details why you are not getting any PDF? You can post your mail id and I would get in touch with you. Thanks Regards, Rupesh. Coldfusion Server Team, Macromedia. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212663 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFDOCUMENT image zooming problem not resolved with MX7 hotfix 3?
I just installed hotfix 3 and now cannot create ANY PDF using CFDocument. Anyone have a similar problem with hotfix 3? Mike -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 10:04 AM To: CF-Talk Subject: CFDOCUMENT image zooming problem not resolved with MX7 hotfix 3? I have been having a showstopper-type of problem with creating PDF's using cfdocument in MX7. Images in the PDF are getting zoomed; this is a pretty well-known bug. I saw that hotfix 3 included a fix for bug 59868, cfdocument tag now scales images properly. I installed the hotfix and restarted coldfusion, and the problem persists. I even changed my template so that it was using a different image, and that second image was also zoomed. Is anyone else that is using cfdocument to generate PDF's having this problem? Thanks, Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Rolling back from updater 3 to 2
Is there anything else I need to do to roll back to updater 2 besides removing the chf703.jar file? Since updating I cannot create ANY PDF's, and removing the newest .jar didn't seem to solve the problem. Did updater 3 do anything behind the scenes that I may need to change manually? Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Not to start a flame war.....
The determining factor in RAD is going to be your proficiency with each tool, not necessarily the tool itself. I have heard from many CF/ASP.NET guys will tell you that given an equal amount of skill between the two tools, they can create the same app in the same amount of time with either tool. Sounds like you have more CF skill than anything, thereby making CF more productive for you...right now. The learning curve is undoubtedly shorter with CF, so new developers lacking both skills will be more productive sooner with CF vs. ASP.NET. Where you see your organization going platform-wise is also your other main factor. The ability to change to Linux/Unix/Windows is obviously a huge perk with CF. Mike -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 13, 2005 3:42 PM To: CF-Talk Subject: RE: Not to start a flame war. Can anybody point to any useful metrics that support the RAD aspect of ColdFusion over ASP.NET. It's one I've always felt true and I did do one comparison back in the ASP vs. CF4.5 days. It would be nice to have something more current and independent. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning .-Original Message- .From: dave [mailto:[EMAIL PROTECTED] .Sent: Wednesday, July 13, 2005 12:19 PM .To: CF-Talk .Subject: RE: Not to start a flame war. . .actually, thats not a very good one either (suprisingly) . for example on some of the examples where it addes extra lines for .cfoutput, as most of use surround the body with 1 output not once every .time its needed. . . heres my take on it all . . cfmx7 give you RAD develpment and if extra power is needed you can tap .into java or if you have a .net specific item you can run that as well .(if on a bd server), you can also run it on what you want. . . .net seems to be better for people who want to think highly of themselfs .a traditional programmers but yet aren't enough of a programmer to .learn java. . . Personally, I will take the RAD of cfm with the luxury of knowing if I .need any additional power that I have it and be able to offer my .customers good sites faster, cheaper and it gives me time to worry about .the users experience more than about whether my c++ code is worthy of .master geek status. . . It funny how I also seem to be in this debate with ppl and the funny .thing is the .net guys seem to be more worried about .net making them .more of a programmer, personally I could care less if I am a .programmer, I would rather worry about how I can make my clients .successful over my own self indulgence. . .~Dave the disruptor~ .A criminal is a person with predatory instincts who has not sufficient .capital to form a corporation. . . .From: Jacob [EMAIL PROTECTED] .Sent: Wednesday, July 13, 2005 2:57 PM .To: CF-Talk cf-talk@houseoffusion.com .Subject: RE: Not to start a flame war. . .Okay.. to be balanced. . .http://www.macromedia.com/devnet/mx/coldfusion/articles/cf_aspnet06.html . .-Original Message- .From: dave [mailto:[EMAIL PROTECTED] .Sent: Wednesday, July 13, 2005 11:47 AM .To: CF-Talk .Subject: RE: Not to start a flame war. . .LOL, thats only a WEE bit biased! . . how bout this part of it, can I run it on whatever platform, hardware, .software I or my client wants or am I stuck made to use only microsoft .crap. . .~Dave the disruptor~ .A criminal is a person with predatory instincts who has not sufficient .capital to form a corporation. . . .From: Jacob .Sent: Wednesday, July 13, 2005 2:36 PM .To: CF-Talk .Subject: RE: Not to start a flame war. . .http://www.promoteware.com/Module/Article/ArticleView.aspx?id=10 . .-Original Message- .From: Ian Skinner [mailto:[EMAIL PROTECTED] .Sent: Wednesday, July 13, 2005 11:26 AM .To: CF-Talk .Subject: Not to start a flame war. . .I would like as civilized discussion on the differences between .NET and .ColdFusion MX7 Enterprise. . .I know all the arguments of free vs. licensing, ease of language, ect and .I .am not looking to rehash those. . .I would like a break down of features one has and the other doesn't, such .as .verity in ColdFusion. . .-- .Ian Skinner .Web Programmer .BloodSource .www.BloodSource.org .Sacramento, CA . .C code. C code run. Run code run. Please! .- Cynthia Dunning . .Confidentiality Notice: This message including any .attachments is for the sole use of the intended
Purging client variables
What is the preferred method to purge old client variables, either from the Registry or database? Thanks. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211692 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Purging client variables
Sorry, I'm stupid. I didn't notice the link from within CF Admin. I KNEW I had seen it somewhere! Thanks. Mike -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 4:47 PM To: CF-Talk Subject: Re: Purging client variables The CF admin has a setting for exactly that, with a length of time you want to keep them around. Other than that, just doing a DELETE against the database will wipe them out quite effectively. cheers, barneyb On 7/12/05, Mike Klostermeyer [EMAIL PROTECTED] wrote: What is the preferred method to purge old client variables, either from the Registry or database? Thanks. Mike -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211697 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Frigging annoying Checkbox behavior
Is these checkboxes within a CFForm, or plain HTML? Mike -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 06, 2005 5:40 AM To: CF-Talk Subject: Frigging annoying Checkbox behaviour I vaguely recall reading this somewhere before; when I submit a form full of unticked checkboxes to CF (6.1 in this case), the checkboxes are defined (along with their checked values) in the form structure when I loop through it yet they aren't listed in the FORM.FieldNames variable. This happens in IE6 and FF; of course as long as one or more boxes are ticked the form behaves as is should. I have coded around it by counting the rest of the form fileds and checking the listlength of FORM.FieldNames, so I know when the checkboxes have been left unticked. Is this the expected behaviour from a browser or is something weird going on with CF? -- Geeque - accept the geek within and get your friends off your back - http://www.cafepress.com/geeque/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFDOCUMENT only works once
Scott, It's a little fuzzy now, but we had a problem with CFDocument initially after upgrading to 7. We resolved it by removing the other JVM(s) that were installed before the install of 7, then specifically installing the version CF 7 required (if it wasn't done already). Has worked flawlessly since. I would suggest looking at the JVM issue first. Mike -Original Message- From: Scott Wolf [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 8:44 AM To: CF-Talk Subject: CFDOCUMENT only works once I'm having a really bizarre problem with using CFDOCUMENT to create a PDF file. When I first re-start my ColdFusion server, I can successfully visit my page and generate my PDF, but only one time. Every time I try after that, IE just keeps waiting for a response and never seems to get one. Any suggestions? Scott Wolf | Network Administrator | GravityFree 1960 Stickney Point Road | Second Floor Sarasota | FL | 34231 | 800.207.4431 941.927.7674 | f 941.923.5429 www.GravityFree.com blocked::http://www.gravityfree.com/ 2003 TECHNOLOGY COMPANY OF THE YEAR - Sarasota County Committee for Economic Development 2001 YOUNG BUSINESS OF THE YEAR - Greater Sarasota Chamber of Commerce *Internet Email Confidentiality Footer*** Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message, and notify us immediately. If you or your employer does not consent to Internet email messages of this kind, please advise us immediately. Opinions, conclusions and other information expressed in this message are not given or endorsed by my firm or employer unless otherwise indicated by an authorized representative independent of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210967 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Live Support
PHP Live Support is fantastic for the money. Don't know if the PHP part is a non-starter for you, however. http://www.phplivesupport.com Mike -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 12:25 PM To: CF-Talk Subject: Live Support Who's using what for Live Support. Were not looking for a hosted solution. We'd like to own the software. Were considering XIGLA http://www.xigla.com/absolutels/index.htm but they don't have a multi domain license or server wide license. Any suggestions? Emmet ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209835 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sometimes form or url variables don't exist?
Check the CGI variables when the error happens by emailing yourself a CFDUMP of the various scopes. Chances are it is google or some other indexing service jumping directly to your scripts. Anyone know of a way around this, as I have had this problem in the past as well? Mike -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 3:22 PM To: CF-Talk Subject: Sometimes form or url variables don't exist? I sometimes get errors from my application where it tries to use a value that should have been on the previous form page, but for some reason doesn't exist. Has anyone else run into this? I am using an older version of Fusebox, so Form.* and URL.* variables all get converted to the Attributes scope. So whether it was passed in as a Form or URL variable shouldn't matter. I am running CFMX 6.1 on the box this just happened on, but I see it happen often on some busier sites we have running on a CF 5 box also. -Ryan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209738 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sometimes form or url variables don't exist?
If he submitted the form as expected, then (for some reason) clicked on the address bar and hit go or enter, that could produce a get vs. a post. May seem far fetched, but I know an end user or two, so nothing is out of the question! Mike -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 4:15 PM To: CF-Talk Subject: RE: Sometimes form or url variables don't exist? I know it's not a search engine because a user forwarded me a screen shot of the error. After looking closer at the log file, I see that he made a GET request to a page that should have been POSTed to. And the variables were not present in the query string. What would cause the browser to do a GET when it should do a POST? I know AOL used to (still does?) have a problem with this, but they are not coming through AOL, they are a large company and have their own dedicated access through some ISP. -Ryan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Flash CFForm 32k limit?
Anyone have any experience with the 32k limit in flash-based CFForms (and Flex)? See error below: Error generated version of _watcherSetup:738 Branch between 71782 and 104556 around line 0 exceeds 32K span. If possible, please refactor this component. Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209606 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: flash forms accordian scrollbars
If you'll send me the code in the TranslateRSSItems function, I will play with it a little. Mike -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 8:58 AM To: CF-Talk Subject: flash forms accordian scrollbars Below is a link to check out a flash form I'm experementing with and the code I'm using to create it. My question concerns the scrollbar display. Notice when you load my form that there are two scrollbars. I don't understand why and short of removing the height specification for the PAGE, I can't make the second (outside bar) go away. I've tried messing with all of the size values, but haven't found any combination that helped. Anyone have any ideas??? Thanks, Ferg See the result of this code here: http://www.fergusonhouse.com/news.cfm **Please be patient if it's slow, as this incredibly small form sometimes inexplicably takes FOREVER to load.** cffunction TranslateRSSItems (which returns a query object with 20 records)... cfform name=news action=index.cfm enctype=multipart/form-data format=Flash method=POST width=350 height=325 cfformgroup type=ACCORDION height=250 width=275 !--- all comms elements here --- cfformgroup type=PAGE label=newsfeeds height=225 !--- this tab is for the Private Message list --- cfhttp url=http://rss.news.yahoo.com/rss/mideast; method=GET resolveurl=true timeout=6000 cfif cfhttp.fileContent is not Connection Failure cfset rssFeed = TranslateRSSItems(cfhttp.FileContent) cfloop query=rssFeed !-- only output at most 5 rows --- cfif currentRow lte 5 cfoutput cfformitem type=htmlfont color=##ff#title#/fontbr#left(description, 100)#bra href=#link# target=_blankfont color=##ff size=-2::read more::/font /a/cfformitem cfformitem type=hrule/cfformitem /cfoutput cfelse cfbreak /cfif /cfloop /cfif /cfformgroup cfformgroup type=PAGE label=announcements !--- this tab is for the Chat --- /cfformgroup cfformgroup type=PAGE label=upcomingevents !--- this tab is for the Disc. Board latest entries list --- /cfformgroup /cfformgroup /cfform ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: flash forms accordion scrollbars
I know that isn't the problem, just needed a working example to play with.
The problem is with the height in the ACCORDION definition:
cfformgroup type=ACCORDION height=275 width=275
(changed height from 250 to 275) works as you would like. As you increase
the number of accordion panes, this value will have to increase as well.
Mike
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 9:17 AM
To: CF-Talk
Subject: Re: flash forms accordian scrollbars
Here's that code, but it just returns a query object. I don't think it
can be the problem.
cfscript
/**
* Translates a RSS Feed's items to a query.
*
* @param rssDoc RSS document to translate. (Required)
* @return Returns a query.
* @author William Steiner ([EMAIL PROTECTED])
* @version 1, October 30, 2003
*/
function TranslateRSSItems(rssDoc) {
// the current token we are looking at
var Token = GetToken(rssDoc,1,);
// LoopControl needs to be initialized
var LoopControl = 1;
// Initialize the Current Query Row
var RowNumber = 1;
// the number of the next token we are looking at
var NextToken = 2;
var RSS_Struct = StructNew();
// Initialize Return Query
var ResultQuery = QueryNew(Title, Link, Description);
// loop until we are out of tokens
while(Token is not /rss){
switch(Left(Token,7)){
case channel:{
// loop thru until we get to the first item
// skiping all tokens relating to document itself
while(Token is not item) {
// increment next token
NextToken = NextToken + 1;
Token = GetToken(rssDoc,NextToken,);
}
} // end channel case
case item:{
// if we are getting a item token, we want to:
// create a new blank structure
// define new structure
RSS_Struct = StructNew();
// increment next token
NextToken = NextToken + 1;
break;
} // end item case
case /item:{
// if we are getting a /item token, we want to:
// Create a new row in the query the each item
// Assuming the structure isn't empty
// copy existing structure into result array
if (not StructIsEmpty(RSS_Struct)){
// add a new row to the query
RowNumber = QueryAddRow(ResultQuery);
// populate Query
QuerySetCell(ResultQuery, Title, RSS_Struct.Title,
RowNumber);
QuerySetCell(ResultQuery, Link, RSS_Struct.Link,
RowNumber);
QuerySetCell(ResultQuery, Description,
RSS_Struct.Description, RowNumber);
}
// increment next token
NextToken = NextToken + 1;
break;
} // end /item case
case title:{
// if we are getting the title token, then we want to:
// add the next token to our structure, because that
will be our title text
// increment the 'nexttoken' variable two increments
past the end title token
// add the title to the structure
StructInsert(RSS_Struct, Title, GetToken(rssDoc,
NextToken+1, ));
// increment next token
NextToken = NextToken + 2;
break;
} // end title case
case Link:{
// if we are getting the Link token, then we want to:
// add the next token to our structure, because that
will be our link text
// increment the 'nexttoken' variable two increments
past the end link token
// add the title to the structure
StructInsert(RSS_Struct, Link, GetToken(rssDoc,
NextToken+1, ));
// increment next token
NextToken = NextToken + 2;
break;
} // end link case
case descrip:{
// if we are getting the description token, then we want to:
// add the next token to our structure, because that
will be our description text
// increment the nexttoken variable once
// add the title to the structure
StructInsert(RSS_Struct, description,
GetToken(rssDoc, NextToken+1, ));
// increment next token
NextToken = NextToken + 1;
break;
} // end description case
default: {
Token = GetToken(rssDoc,NextToken,);
NextToken = NextToken + 1;
break;
} // end default case
} // end switch
Token = GetToken(rssDoc,NextToken,);
} // end while
return (ResultQuery);
}
/cfscript
Mike
RE: flash forms accordion scrollbars
I've been there, believe me. Messing with the display of flash-based
CFForms is one of the more frustrating things I have been dealing with
lately.
Mike
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 9:48 AM
To: CF-Talk
Subject: Re: flash forms accordion scrollbars
Thanks Mike. I've changed those height values so many times, I was sure
I had changed that one too. Anyway, I guess I hadn't.
Mike Klostermeyer wrote:
I know that isn't the problem, just needed a working example to play with.
The problem is with the height in the ACCORDION definition:
cfformgroup type=ACCORDION height=275 width=275
(changed height from 250 to 275) works as you would like. As you increase
the number of accordion panes, this value will have to increase as well.
Mike
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 9:17 AM
To: CF-Talk
Subject: Re: flash forms accordian scrollbars
Here's that code, but it just returns a query object. I don't think it
can be the problem.
cfscript
/**
* Translates a RSS Feed's items to a query.
*
* @param rssDoc RSS document to translate. (Required)
* @return Returns a query.
* @author William Steiner ([EMAIL PROTECTED])
* @version 1, October 30, 2003
*/
function TranslateRSSItems(rssDoc) {
// the current token we are looking at
var Token = GetToken(rssDoc,1,);
// LoopControl needs to be initialized
var LoopControl = 1;
// Initialize the Current Query Row
var RowNumber = 1;
// the number of the next token we are looking at
var NextToken = 2;
var RSS_Struct = StructNew();
// Initialize Return Query
var ResultQuery = QueryNew(Title, Link, Description);
// loop until we are out of tokens
while(Token is not /rss){
switch(Left(Token,7)){
case channel:{
// loop thru until we get to the first item
// skiping all tokens relating to document itself
while(Token is not item) {
// increment next token
NextToken = NextToken + 1;
Token = GetToken(rssDoc,NextToken,);
}
} // end channel case
case item:{
// if we are getting a item token, we want to:
// create a new blank structure
// define new structure
RSS_Struct = StructNew();
// increment next token
NextToken = NextToken + 1;
break;
} // end item case
case /item:{
// if we are getting a /item token, we want to:
// Create a new row in the query the each item
// Assuming the structure isn't empty
// copy existing structure into result array
if (not StructIsEmpty(RSS_Struct)){
// add a new row to the query
RowNumber = QueryAddRow(ResultQuery);
// populate Query
QuerySetCell(ResultQuery, Title, RSS_Struct.Title,
RowNumber);
QuerySetCell(ResultQuery, Link, RSS_Struct.Link,
RowNumber);
QuerySetCell(ResultQuery, Description,
RSS_Struct.Description, RowNumber);
}
// increment next token
NextToken = NextToken + 1;
break;
} // end /item case
case title:{
// if we are getting the title token, then we want to:
// add the next token to our structure, because that
will be our title text
// increment the 'nexttoken' variable two increments
past the end title token
// add the title to the structure
StructInsert(RSS_Struct, Title, GetToken(rssDoc,
NextToken+1, ));
// increment next token
NextToken = NextToken + 2;
break;
} // end title case
case Link:{
// if we are getting the Link token, then we want to:
// add the next token to our structure, because that
will be our link text
// increment the 'nexttoken' variable two increments
past the end link token
// add the title to the structure
StructInsert(RSS_Struct, Link, GetToken(rssDoc,
NextToken+1, ));
// increment next token
NextToken = NextToken + 2;
break;
} // end link case
case descrip:{
// if we are getting the description token, then we want
to:
// add the next token to our structure, because that
will be our description text
// increment the nexttoken variable once
// add the title to the structure
StructInsert(RSS_Struct, description,
GetToken(rssDoc
RE: Regarding Java and .NET's incestuous ties, and Windows' future
...once Marc left last year, I think that was the sign that Microsoft is over as a software company... Yep, couldn't agree more. I'm tossing all of my MS servers/desktops and all MS software out in the trash today. That trillion dollar, market dominating, company is finished! give me a break... Mike -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 1:08 PM To: CF-Talk Subject: RE: Regarding Java and .NET's incestuous ties, and Windows' future Who is Bryan J. Smith? These two statements of his strike me as utter foolishness: ...because .NET 2.0 is based on Java 1.4 (thanx to Microsoft's recent re-license), whereas .NET 1.1 is based on Java 1.1... ...once Marc left last year, I think that was the sign that Microsoft is over as a software company... Vince -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 1:27 PM To: CF-Talk Subject: OT: Regarding Java and .NET's incestuous ties, and Windows' future While the world is starting to catch on to Longhorn not being the promised land it was promoted as over the past five years (http://www.eweek.com/article2/0,1759,1820686,00.asp http://www.eweek.com/article2/0,1759,1820686,00.asp ), the ties between .NET and Java continue (http://lists.matrixlist.com/pipermail/pc_support/2005-May/000393.html http://lists.matrixlist.com/pipermail/pc_support/2005-May/000 393.html ). -- Damien McKenna - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207897 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regarding Java and .NET's incestuous ties, and Windows' future
Who's Marc? - No idea OK, you're right. Their total assets are only 92,389,000,000, not a trillion. In my mind I was adding to that their total impact on the IT industry, in which case trillion is vastly under-estimated. My point was this: for the author to insinuate that because some 'Marc' guy (whom nobody seems to know who the hell he is) left a multi-billion dollar, market dominating, company is THE sign that the company was 'over' is just plain stupid, and I feel dumber for having read it. p.s. I'll allow your silly comparison between MS and the Romans to pass only to counter-act my silly estimate of MS's financial net worth. Mike -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 1:36 PM To: CF-Talk Subject: Re: Regarding Java and .NET's incestuous ties, and Windows' future On 5/27/05, Mike Klostermeyer [EMAIL PROTECTED] wrote: ...once Marc left last year, I think that was the sign that Microsoft is over as a software company... Who's Marc? Yep, couldn't agree more. I'm tossing all of my MS servers/desktops and all MS software out in the trash today. That trillion dollar, market dominating, company is finished! It's not trillion, it's billion, was 60 now 30, and the dollar amount has been steadily falling. give me a break... Rome fall? give me a break... Where is that comming from Vince? -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
New to CFMX - session problem
I upgraded a server from CF 4.5 to MX 6.1. Previously, when a user closed their browser (without 'logging off'), the session expired. This is no longer happening. From what I can find, MX uses session variables differently, but I can't find anything that tells me what I need to do to get sessions to expire when the browser closes. I have tried to enable/disable J2EE Session variables from within the administrator, which did not solve this problem. Anything further I need to do? Thanks for your help. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: New to CFMX - session problem - CANCEL
Sorry, using J2EE Sessions variables does fix the problem. -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 3:53 PM To: CF-Talk Subject: New to CFMX - session problem I upgraded a server from CF 4.5 to MX 6.1. Previously, when a user closed their browser (without 'logging off'), the session expired. This is no longer happening. From what I can find, MX uses session variables differently, but I can't find anything that tells me what I need to do to get sessions to expire when the browser closes. I have tried to enable/disable J2EE Session variables from within the administrator, which did not solve this problem. Anything further I need to do? Thanks for your help. Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFForm/Flash/AS
I am having trouble getting to the visibleattribute in my flash-based CFForm (CFMX 7). In the code below, when the user clicks on the Notify button, I would like the text box (currently not visible) to become visible. Thanks in advance for your assistance. Mike Klostermeyer [EMAIL PROTECTED] ++ cfform name=myform height=400 width=400 format=Flash skin=HaloBlue cfformgroup type=accordion label=Executive Summary style=marginTop: 0 height=400 visible=Yes enabled=Yes name=tabNav id=tabNav cfformgroup type=page label=1st page style=marginTop: 0 height=400 width=400 visible=Yes enabled=Yes name=tabNav2 id=tabNav2 cfformgroup type=panel label=Chairman Maintenance visible=Yes enabled=Yes cfformgroup type=horizontal visible=Yes enabled=Yes cfinput type=Button name=forcedNotify value=Notify visible=Yes enabled=Yes cfinput type=Text name=hiddenText required=No visible=no enabled=Yes /cfformgroup /cfformgroup!--- end panel --- /cfformgroup!--- end page --- cfformgroup type=page label=2nd page style=marginTop: 0 height=400 width=400 visible=Yes enabled=Yes cfformgroup type=hdividedbox visible=Yes enabled=Yes label=Status Change cfformgroup type=horizontal visible=Yes enabled=Yes cfinput type=Button name=NextStage value=Move Item to Stage X visible=Yes enabled=Yes cfinput type=Button name=PreviousStage value=Send item back to Stage X visible=Yes enabled=Yes cfinput type=Button name=Archive value=Archive visible=Yes enabled=Yes /cfformgroup /cfformgroup /cfformgroup!--- end page --- /cfformgroup!--- end accordian --- /cfform +++ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205753 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
