RE: other companies and developers to watch out for
Yea! Whew. I was getting worried there for a second. That being said, I think working titles for my script might be something like: The Poster Boy; Relentlessly Pursued; or A Fly in Your Ointment. Peace. -Original Message- From: Adam Cohen [mailto:a...@colony1.net] Sent: Friday, February 04, 2011 2:21 PM To: cf-jobs-talk Subject: Re: other companies and developers to watch out for This is untrue and ridiculous. Here is a copy of my off list response. Michael if you are serious please get help as it starting to seem like we should report this to authorities for your own protection. Call me if you are unclear re my position. Michael, I have no interest in further discussion with you. I hope your retraction is sufficient to eliminate any harm to me or my company that your libelous posts may have created. I have no desire to cause you harm - and never attempted to. I doubt you will hear from me further in any capacity, legal or otherwise. If an issue arises in the future whereby this comes into question by someone, I expect you will take prompt action to assist remedying it in the future as well. In the meantime as a fellow person I wish you well and hope you can get your life together. Watching this unfold has been a bit troubling and depressing. I have no interest in pursuing you and am not taking any action at this time. Adam On 2/4/2011 12:38 PM, Michael Firth wrote: Elliot and Adam, I am emailing the both of you once again in an attempt to find out if my retraction satisfies you or does more need to be done to avoid the joint petition. If you have not seen the retraction, it is at the bottom of the thread in question on houseoffusion. I will also devise something if you need it to for your website. I can only assume that continued non-response means yes that you are still planning to pursue legal action. As such, please have your lawyer call me at 770-432-7753 and i will give him a list of my assets, which you are free to pick and choose from. Not sure what your looking to get, but if it helps settle things please. If we are to go to court please note I will be defending myself and throw myself on the mercy of the court. Is it begging? Yes, because I cannot and will not put my family through this. Also, as a military veteran of 8 years I believe if you made your bed lie in it. I don't know what else to say that I have Sent from a mobile device. Please excuse any typos. On Feb 4, 2011, at 2:04 PM, Michael Firth mftr...@att.net wrote: Today, I was given the response, that the parties still plan to pursue legal action and to ensure that I am paying for the rest of my life regardless of how many apologies I try to make things right. I have since sent two letters begging for mercy. I guess now there really is no other option but to totally remove myself from this earth. Peace. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4455 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: Custom Tags, cf_location
Wow. This thread is FANTASTIC. Michael, you can't be so sensitive. In programming, there are a LOT of egos we all have to deal with. None of the comments were that condescending, and if they really have 18's for stats, well it might be a good idea to just listen to what they have to say. I commend you for having an opinion, but your professionalism and openness for criticism is lacking. Also, many colleges are accepting Wikipedia as a legitimate resource as long as you're staying away from subjective matter. I think Dave is probably just having fun with the fact that this thread is better than a sitcom. -Brandon On Tue, Jan 25, 2011 at 8:38 PM, Michael Firth mfsqlser...@gmail.comwrote: Interesting. In my spare time I am going back to college and almost to a tee all of my professors warn about wikipedia and how much misinformation is on there. What is really something is that at my previous school the professors were the same way about wikipedia. Guess you have to take it with a grain of salt. On Jan 25, 2011, at 9:35 PM, Dave Watts wrote: Wikipedia is not exactly a great source for verifying something lol. Just saying. It's satisfactory for undisputed facts, and it's easier to remember off the cuff than other sites that list logical fallacies, which is what begging the question is. I use it quite often to provide simple explanations of (again, undisputed) facts that I already happen to have picked up somewhere else - in this case, university philosophy and logic courses. I'm a college dropout, but I remember what I learned. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: why is cf_builder so expensive?
I use it at home and at work. For me it is a nice-to-have but probably not worth $300. I know a few developers who tried it and went back to CFEclipse. The only reason I like it is for some of the RDS and ORM functionality. I wouldn't miss it if it was gone. On Tue, Jan 25, 2011 at 8:48 PM, Michael Firth mfsqlser...@gmail.comwrote: M. So how exactly does one afford the best tools when they don't have the dollars? Easy to say when you got a job. You say people at Adobe have to eat, but most people at Adobe also make 60-8 easily. And if your a developer the educational use is of no real benefit because if I remember that was only for college students. I am surprised that nobody has really tried to say why cf builder is so good likes it features. in other words, nobody has really provided a good reason as to why should I invest in it. On Jan 25, 2011, at 9:44 PM, Dave Watts wrote: Contrary to popular belief not everybody makes the big bucks. In that case, it's even more important to have the best tools you can afford. What would be nice to see some sort of discount for developers or trim it down like they do for the server so that use developers can at least practice using it. It would be nice if unicorns shit rainbows too. But people at Adobe have to eat just like everyone else. And I don't think they could easily differentiate between practice and real coding. That said, Adobe has offered bundling - buy CF server, get two or three seats of CF Builder. Adobe's also offered Flash Builder for free to unemployed developers, and ColdFusion Builder free for educational use: http://freeriatools.adobe.com/ If you have a valid student ID, you're good to go. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) job-placement agent
+1 For TEKSystems On Fri, Jan 14, 2011 at 10:16 AM, Jason Fisher ja...@wanax.com wrote: Got great help a number of years ago from TEKSystems and I've had good experiences with Kforce as well. From: John M Bliss bliss.j...@gmail.com Sent: Friday, January 14, 2011 10:25 AM To: cf-talk cf-talk@houseoffusion.com Subject: (ot) job-placement agent Have you every used a job-placement agent? (Not sure if that's exactly what they're called.) Someone who helps with your CV, markets you, sets up interviews, and then gets paid by employer that eventually hires you. If so, can you recommend one and/or a company that does this sort of thing? URL? Thanks! P.S. Boss, if you're reading this, I'm not looking...it's for a friend. :-) -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
Why don't you just throw your directory structure into the database and select it from a dropdown? Maybe do some ajax to simulate the parent/child relationship when a directory is selected. On Oct 4, 2010 6:08 PM, Gonzo Rock gonzor...@gmail.com wrote: Using input type=file works great to let a user point to a file... but how do you let the user browse and point to a Directory? I am trying to figure out how to let a user browse to a particular directory location on their network and then capture that location for future use. In this instance the application will always look in this location for files that it needs to process for the user. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone else have the latest CFBuilder crashing constantly?
I am also having the same problem on Win7 64-bit. It eventually caused me to go back to CFEcilpse. On Thu, Apr 15, 2010 at 9:41 AM, Jason Durham jdur...@cti-stl.com wrote: I'm having the same problem on Win7 64-bit. Build date of CFB shows Feb 27, 2010. -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Friday, March 12, 2010 2:59 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? Cutting and pasting chews through memory very quickly, it was raised as a bug and Adobe just closed it straight away. Now that either means it is fixed or they are not going to fix it so let's see. But as I described to Adobe, I went from 77mb of heap space and after copying and pasting about 5 to 10 times from another file my heap space had grown out to 250mb before ColdFusion Builder then crashed. There are a lot of memory leaks with ColdFusion Builder, that just ends up chewing through memory way to fast. -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, 12 March 2010 2:51 AM To: cf-talk Subject: RE: Anyone else have the latest CFBuilder crashing constantly? For me, CFB beta 3 has been unstable to a point where I went back to text editors to get work done. There is a problem when I cut and paste a lot. Every paste would set off something in CFB which seemed to need to time out before it came back to life. Also, there were problems when I would type a double quote and CFB would go numb on me for a while. I definitely had to watch the screen as I typed since I had no idea when it would go mental on me. I ended up turning off all the helpers in the system which turns it into a fancy text editor and allows me to get work done. I sure hope they fix all these problems before it goes into production. I assumed that there would be another beta, but that may not happen. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfoutput query within cfoutput query
I have a situation where i need to display info from two queries on the same row of a table. Here is the background, each person in a database table has a name and ID which is then linked to another table that lists pets. Each person can have as many as 4 pets. Now i need to display the ID, name, and each pet on the same row of table, preferably with the pets all listed in the same cell. I'm not that experienced with ColdFusion so my first attempt looked like this: cfquery datasource=#dsn# name=person SELECT * FROM tblPerson /cfquery table cfoutput query=person tr td#ID#/td td#name#/td cfquery datasource=#dsn# name=pets SELECT * FROM tblPets WHERE ownerID = #person.ID# /cfquery cfoutput query=pets td#pet#br/td /cfoutput /tr /cfoutput /table If you've read this far, i'm sure you know this won't work but i hope can see what i'm trying to do. Please help if have any solutions ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Merlin Manager 1.0.1 is now public
It worked for me a few days ago. On Thu, Feb 25, 2010 at 3:19 AM, Andrew Scott andr...@andyscott.id.auwrote: So public that the website doesn't work. -Original Message- From: cft...@fusionlink.com [mailto:cft...@fusionlink.com] Sent: Tuesday, 23 February 2010 4:08 AM To: cf-talk Subject: Merlin Manager 1.0.1 is now public The Merlin Manager project I demo at CFUnited is now on its first public release as version 1.0.1. It is completely free to use and the CFCs are now open source under the GPL version 3 license. The AIR client is not open source yet. That may happen in the future. For service and support there is an optional annual $85.00 service fee. If you haven't heard of Merlin yet. There is a online demo at http://www.merlinmanager.com. It is a management and monitoring system for ColdFusion servers. Unlike Adobe's CF 9 Manager, Merlin works on ColdFusion 7, 8 and 9. It also has monitoring for versions 8 9. With Merlin you can save server configuration snapshots and restore them across multiple servers. It also includes a handy update and patch management system to keep your systems up-to-date. You can download Merlin at: http://www.merlinmanager.com John ma...@fusionlink.com twitter: john_mason_ blog: codfusion.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331128 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IDE for coldfusion 9
I tried CFBuilder for several months and finally got fed up with glitchy code-folding. Plus, I don't want to get too used to a tool that's going to end up costing an arm and a leg. Eclipse + plugins seems to handle everything I need, without beta-testing bugs. -Brandon On Wed, Feb 10, 2010 at 10:51 AM, Adrocknaphobia adrocknapho...@gmail.comwrote: cfplug Why not give Adobe ColdFusion Builder a spin? It has built-in support for CF 7 - 9. As well as inline support for HTML, CSS, JS and SQL. http://labs.adobe.com/technologies/coldfusionbuilder/ /cfplug -Adam On Tue, Feb 9, 2010 at 9:35 PM, fun and learning funandlrnn...@gmail.com wrote: Yes the latest version of CFE has a CF 9 dictionary. i.e. It supports CF9 syntax. G! On Tue, Feb 9, 2010 at 2:13 PM, fun and learning funandlrnn...@gmail.com wrote: Hi, Can anyone tell me if there is a new CFEclipse plugin for Coldfusion 9? Hi All, Thanks a lot for the information. I did install the latest cfeclipse plugin, and tried a simple cfoutput example, and its working... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IDE for coldfusion 9
Adam, Thanks for the feedback. My comment was based mostly on heresy and existing Adobe product costs. I have not seen any official pricing yet. Many of the numbers circulating around were near the $300 mark. I understand that it's not meant to be a revenue builder, but I assume that Adobe will want to at least recuperate a fair amount of its development costs. Maybe with the growing .NET community, in addition to the (arguably similar and still free) Eclipse IDE, Adobe will eat much of the cost in order to sustain their market share. -Brandon On Wed, Feb 10, 2010 at 11:25 AM, Adrocknaphobia adrocknapho...@gmail.comwrote: Brandon, What would you consider an arm and a leg? We originally started work on ColdFusion Builder as a feature of ColdFusion 9. In fact it was a the highest requested feature for CF9 despite the existence of CFEclipse, Dreamweaver and HomeSite. But as our vision for a comprehensive ColdFusion IDE grew, it made more sense to turn it into it's own product. What I mean to say is that we built this for the community, not to supplement ColdFusion revenue. Adobe isn't looking for a pay day on CB so you shouldn't expect to have to part with your appendages. :-) -Adam On Wed, Feb 10, 2010 at 12:02 PM, Brandon brandonregis...@gmail.com wrote: I tried CFBuilder for several months and finally got fed up with glitchy code-folding. Plus, I don't want to get too used to a tool that's going to end up costing an arm and a leg. Eclipse + plugins seems to handle everything I need, without beta-testing bugs. -Brandon On Wed, Feb 10, 2010 at 10:51 AM, Adrocknaphobia adrocknapho...@gmail.comwrote: cfplug Why not give Adobe ColdFusion Builder a spin? It has built-in support for CF 7 - 9. As well as inline support for HTML, CSS, JS and SQL. http://labs.adobe.com/technologies/coldfusionbuilder/ /cfplug -Adam ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IDE for coldfusion 9
Rick, I would have to agree with that train of thought. Hopefully, it ends up being the case. -Brandon On Wed, Feb 10, 2010 at 11:59 AM, Rick Faircloth r...@whitestonemedia.comwrote: Given the fact that most software is free that is described as built for the community, I would say that to honor that label, Adobe would have to offer it for $50 or less, if not free. -Original Message- From: Adrocknaphobia [mailto:adrocknapho...@gmail.com] Sent: Wednesday, February 10, 2010 12:25 PM To: cf-talk Subject: Re: IDE for coldfusion 9 Brandon, What would you consider an arm and a leg? We originally started work on ColdFusion Builder as a feature of ColdFusion 9. In fact it was a the highest requested feature for CF9 despite the existence of CFEclipse, Dreamweaver and HomeSite. But as our vision for a comprehensive ColdFusion IDE grew, it made more sense to turn it into it's own product. What I mean to say is that we built this for the community, not to supplement ColdFusion revenue. Adobe isn't looking for a pay day on CB so you shouldn't expect to have to part with your appendages. :-) -Adam On Wed, Feb 10, 2010 at 12:02 PM, Brandon brandonregis...@gmail.com wrote: I tried CFBuilder for several months and finally got fed up with glitchy code-folding. Plus, I don't want to get too used to a tool that's going to end up costing an arm and a leg. Eclipse + plugins seems to handle everything I need, without beta-testing bugs. -Brandon On Wed, Feb 10, 2010 at 10:51 AM, Adrocknaphobia adrocknapho...@gmail.comwrote: cfplug Why not give Adobe ColdFusion Builder a spin? It has built-in support for CF 7 - 9. As well as inline support for HTML, CSS, JS and SQL. http://labs.adobe.com/technologies/coldfusionbuilder/ /cfplug -Adam ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Random question
Les, As a quick solution, you could take a look at this http://www.cflib.org/udf/generatePassword and then modify it to your needs. -Brandon On Wed, Feb 10, 2010 at 12:50 PM, Les Irvin les.cft...@gmail.com wrote: How would I come up with a 4-character random string consisting of any letter or number? 1k3d, e4rf, 69e4, dfje, 3967, etc... Thanks in advance for your help, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Low-tech asychronous call to ColdFusion
On 7/20/06, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: FYI, just doing some testing on these tags (cfthread and cfjoin) and I hope to have them posted on my blog today or tomorow. They'l require CF7, but Standard Edition is fine (Enterprise not required). Awesome Damon-- this is something I've needed/wanted for quite some time. The applications I work with depend on multiple calls to slow, 3rd party resources. Being able to thread these calls and have their results returned (without depending on shared scopes) is going to make my life a whole lot better as a developer. Looking forward to it! - Brandon -- http://devnulled.com ~| 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:247257 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Statistical computations in CF?
On 6/28/06, powell @ nauticom. net powell @ nauticom. net [EMAIL PROTECTED] wrote: I'm working on an app that pulls together a client's data for a given period of time, and produces a forecast for what future data might look like. Reed, I work a lot (on and off) with predictive algorithms, scoring and ranking of data, etc. In my experience there really isn't a cookbook for this sort of thing-- you basically need to get to know the data you're working with very intimately, determine what data changes should cause changes in your predictions, etc, and come-up with valid algorithms on your own (while hopefully utilizing some sort of statistics and math background). I don't know that you'll really find any common library to do what you're looking for, though I'm sure you'll find a lot of 3rd party tools to be beneficial depending on the complexity of what you're working on. I didn't really answer your question, but hopefully this is at least a little helpful? Thanks, - Brandon -- http://devnulled.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245048 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: database linking table naming conventions?
I preface all table names with 3 character group reference. SECURITY SEC_Roles PK=Role_Key SEC_Users PK=User_Key SEC_User_Roles PK=User_Role_Key FK=Role_Key FK=User_Key BILLING BIL_Invoices PK=Invoice_Key BIL_Payments PK=Payment_Key BIL_Invoice_Payments FK=Invoice_Key FK=Payment_Key Etc... -B -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, April 14, 2006 10:02 AM To: CF-Talk Subject: RE: database linking table naming conventions? I'm confused. You're worried about the name of the table and the order of the table names in your DB? This is a problem I've never heard of. DBAs just name things what they want, and I've never heard of table names causing problems except for cases like reserved words and special characters in the name. Or am I misunderstanding your question? -Original Message- From: John McKown [mailto:[EMAIL PROTECTED] Sent: Friday, April 14, 2006 7:05 AM Imagine these two database tables: Users and Groups You want a Foreign Key table to link them together (or what I call a linking table) that might be named UserGroups. But UserGroups as a table name itself does not stand out in the table list because it does not use a prefixed naming convention (something I like about Fusebox on the web side). Examples table names might be: LT_Users_Groups or FK_Users_Groups. Is there an understood standard there? Also, the order of the table names might need to be taken into account based on where the foreign keys are. [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:237784 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 have also seen that if clusters on the hard drive go bad that affect the folder. All images in that folder are now inaccessible. -B -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 5:42 AM To: CF-Talk Subject: maximum number of files in directory I'm creating a database for a store. It will probably have several thousand items (but will probably never come close to 10,000). The pictures of the items will be stored in a file directory (not as a blob in a database). What is the maximum amount of files that can be stored in a directory and still have an efficient response time. Each item will have at least two graphics if not three or four #itemID#-th #itemID# It is quite possible that there could be 15-20,000 images in this directory. Is that too many? The alternative is to store the graphics according to designer /graphics/items/#designerName# / #itemID#.jpg or maybe categories (dresses, denim, jewelry) (the advantage of this would be fewer directories than designers) /graphics/items/#categories# / #itemID#.jpg It would be so much simpler to have all the graphics in one directory. Will I be causing problems later on by doing that? Gilbert Midonnet 718.928.4524 www.glmdesigns.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237418 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: css file based in screen resolution
Here is an article that gives some good tips. http://www.digital-web.com/articles/preparing_for_widescreen/ -B -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 8:56 AM To: CF-Talk Subject: css file based in screen resolution Hi all I'm looking for tips about how to use css files based in screen resolution. By now I'm include in application.cfm a template(screenresolution.cfm) with Ajax. In Ajax I'll store in session var that screen resolution. But when load any template occurs an error: variable session.screenresolution is undefined. Loading screenresolution.cfm with javascript alert shows me OK. What's wrong? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237019 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: How do I get rid of single quote duplication in sql?
Use the function PreserveSingleQuotes() cfset sqlPart = 'name: ' + name cfset sqlPart = #PreserveSingleQuotes(sqlPart)# -Brandon -Original Message- From: Oleg Gunkin [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 07, 2006 11:26 AM To: CF-Talk Subject: How do I get rid of single quote duplication in sql? I have the following problem with sql generation: Example cfset sqlPart = 'name: ' + name cfquery select #sqlPart# as name from user /cfquery The outcome of this code is select ''name: '' + name as name from user How do I get rid of single quote duplication? -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234499 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: Finding empty locations
In the database create a table for Isle, Bay, Shelf, and Product. Isle_ID Isle_Status Bay_ID Isle_ID Bay_Status Shelf_ID Bay_ID Shelf_Status Product_ID Shelf_ID Populate those tables with rows for every possible Isle,Bay, and shelf in the warehouse. Then you can do a single query: SELECT Isle_ID, Bay_ID,Product_ID FROM Isle I,Bay B,Shelf S WHERE 0=0 AND I.Isle_ID=B.Isle_ID AND S.Bay_ID=B.Bay_ID AND Shelf_ID NOT IN ( SELECT Distinct Shelf_ID FROM Product ) -Brandon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 8:04 AM To: CF-Talk Subject: Finding empty locations Our warehouse has stock arranged in a way that makes it very easy to find. If I ask someone to get the title from 03.28.07 they just have to go to isle 3 then walk down it to bay 28 and get the product from shelf 7. Simple. I now need to write a query that can tell me where in the warehouse there is an empty location and this is more complex than it should be. The only way I can think is to have three nested loops (one for each of isle, bay and shelf) to generate a location and then query the database to see if there is any stock in it. The problem is that this could easily lead to thousands of queries being run and that is going to cause performance problems. IE: cfloop from=1 to=#isles# index=x cfloop from=1 to=#bays# index=y cfloop from=1 to=#shelves# index=z cfset location = #x#.#y#.#z# cfquery SELECT * FROM Stock WHERE location = #location# /cfquery /cfloop /cfloop /cfloop Can anyone think of a better way? -- Jay ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231929 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
CFScript Quick Reference Guide?
Some time ago I had a PDF which was a quick reference to CFScript. It was basically a quick and dirty two page overview which showed the various control structures available in CFScript. I've not needed it in quite a long time and don't seem to have it around any longer. That said, I was curious to see if anyone knows what document I'm talking about and happens to have a copy or knows where I can get it again? A Java programmer I work with is working on integrating something in Java to CF and keeps asking me control structure questions about CFScript. I've googled for the last 15 minutes without any luck finding it unfortunately. Any help would be appreciated. Thanks, - Brandon -- http://devnulled.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230238 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: CFScript Quick Reference Guide?
On 1/23/06, Charlie Griefer [EMAIL PROTECTED] wrote: any specific questions that we can take a shot at tho? I know CFScript just fine so I don't have any questions about it, I was just looking for an old Quick Start guide that I used to have-- but thanks. :) I finally found it.. I've posted it here in case someone else would like it: http://www.content-type.com/-1407484951/cfscript.pdf.htm Unfortunately my VOIP router at home locks-up every so often and today is one of those days, so I'm unable to upload it to my server at home at the moment.. sorry. Thanks, - Brandon -- http://devnulled.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230254 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: Anyone use AbleCommerce, CFMX version?
On 1/16/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: I notice that Tumi.com (they're an up and coming luxury luggage maker) is using some kind of Fusebox app, anyone know exactly what store they're using, or is it built internally? Hhm, that's certainly not a typical Fusebox application, and not any software that I've run across. Looks home-grown to me. You could always email them and see if they'd tell you for sure. Judging by both the industry and what the URL's look like, most likely that site is done at ebags.com. Actually I would say with a high degree of certainty that it's an ebags site after doing a dig of both URL's: ;; ANSWER SECTION: www.tumi.com. 3600IN A 66.179.113.186 ;; ANSWER SECTION: www.ebags.com. 3600IN A 66.179.113.187 FWIW, - Brandon -- http://devnulled.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229752 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
JRun Clustering Behavior?
I've been setting-up/testing a simple JRun cluster with instances of ColdFusion MX 7.0 and one thing which does not seem to be documented well about JRun is what events signal adding/dropping instances from a cluster, what errors it can or can't recover from by switching to another instance in the cluster, etc. If someone could pass on a link about this that I haven't been able to find, that would be great. Otherwise I have a laundry list of questions below... Here is the setup I'm using (all are Windows 2003 servers): 1 Web server connected to 1 JRun Cluster JRun Cluster contains 2 servers Each JRun Server contains 2 instances of a given application, so there are basically 4 instances in the cluster total. No load balancing between the web server and the JRun servers or any of that sort of stuff yet, it's just a basic cluster I'm setting-up for a product beta. Here are my specific questions (that is, if there isn't anywhere I can read about this stuff)... 1. Other than stopping an instance, what events/exceptions would trigger a JRun application instance to be dropped from the cluster? 2. What events does using the JRun drivers pointing to a cluster (as in not using a load balancer) help catch gracefully? So far it looks like only when an instance has stopped. For instance I've got several cannot connect to JRun errors when I've intentionally made a server busy. I haven't tried shutting down a server completely then trying it out yet-- does it catch that? 3. How does an instance which has been restarted or otherwise dropped from the cluster make it's way back into the cluster? I've tried a lot of scenarios with this in particular, and can't figure it out. It just seems to eventually reappear, but it takes a very long time for that to happen. Mostly I'm just trying to get a good feel for how well or not this scenario works so that I can troubleshoot potential problems with it in the future. I'd greatly appreciate any advice or any useful links you could send my way. I've read tons and tons of stuff about clustering in JRun, but nothing specifically about how JRun clustering behaves/reacts in different scenarios. Thanks, - Brandon -- -- http://devnulled.com ~| 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:202438 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: JRun Clustering Behavior?
Thanks for the reply Simon. It was behaving illogically when running through various tests which is why it wasn't making much sense to me. For example, if I stopped one particular instance, it would not end-up back in the cluster for quite a long time, but would eventually at random find it's way back in, however the other instances would behave as you said below. I ended-up reinstalling the web server connectors and now it seems to be behaving as one would expect it to. Thanks, - Brandon On Apr 12, 2005 12:19 PM, Simon Horwith [EMAIL PROTECTED] wrote: JRun has a cluster manager service. When a server is offline or stops responding to requests, it's dropped from the cluster. If you attempt to access something in the session scope and the server is unable to access the session, it fails over to the other cluster member... but only if you have fail over turned on (which you should). For the most part, nothing much short of a crash, stop, or restart will remove an instance from the cluster as far as I know. This is one of the reasons you balance the instances. When it is restarted or started for the first time, the cluster manager adds it to the cluster for you. ~Simon -- -- http://devnulled.com ~| 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:202493 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: CF/programming experience from the list?
On Thu, 03 Mar 2005 16:14:02 -0400, Will The Game [EMAIL PROTECTED] wrote: I just wanted to try and gauge where I'm at right now in terms of programming Sorry for the late bump, but I just came across this thread. I was reading and writing at age three and had my first exposure to computers at that age when I was in preschool (a Ti 99). My parents bought me one of those (my dad had been using Digital computers since the late 70's at that time).. then an Apple IIe when I was in First Grade. Finally in 3rd Grade I started teaching myself AppleBasic.. moved to a hand-me-down IBM 286 AT in 5th Grade and continued doing BASIC as well as batch files. Around age 10 or 11 I wrote a completely menu driven system to uncompress applications at runtime and then recompressed changed application data when an application ended on my 286 because my 20 MB hard drive was too small. I kept messing around in BASIC, batching, and Logo until early High School when I started to play around in Turbo C++ and a language similar to C++ called Synapps. I mostly wrote, uhh, well, innocent viruses that propagated through my High School's network but would clean themselves up and disappear after a couple of days. Mostly they just did really innocent things like disable the mouse input for about 30 seconds every 45 minutes and give error messages like Computer is halting to let mouse cool, please standby. I think I had more fun writing the code to install and propagate the virus then clean itself-up and disappear than anything else (it was very stealthy and cool for the time period, IMHO); I've never really been malicious, but I did find people's reactions rather humorous. :) I also setup a BBS for the High School and eventually helped setup a proxy with 2 modems which served as an access point to the net for the school. I grew-up in a VERY rural area, so all things considered it was pretty advanced at the time. Once the web came around and I found messing around in Mosaic much more impressive that Gopher and BBS's, I got really interested in HTML, graphics, etc. which was my entry into the web and playing with HTML in late 94 or so. I'd also done a lot of sketching and so forth growing-up, so getting my hands on a copy of Photoshop really fascinated me. In 1997 I started getting fascinated with Unix, Linux and FreeBSD after graduating High School and spending too much time messing around on IRC. I started college, but left after a semester because the whole internet thing was too lucrative, and I didn't feel like I was learning much. I didn't really get back into programming again until I started playing around with ColdFusion in 1998 or so when I was a Graphic Designer at a small web company. By 2000 I was working as a full-time CF Developer. From 2000 until now I've played around in Java, Python, and PHP for the most part, not to mention ColdFusion. I also started going to college on and off again.. lately I've been going very regularly and have learned C, Assembly, UML, I start a Java class tomorrow, and C++ in a couple of months, etc. I should graduate before too long with a CS Degree and am about 90% sure I'll be doing grad school as well provided my GPA stays up and I can get accepted. Post grad school I see myself working towards a Software Architect type role or perhaps some sort of RD, but that's still quite a ways off. I somewhat regret messing around so long and taking so long to do my undergrad, but at the same time I really appreciate what I'm learning and have a much better understanding of what it takes to be a good software developer, as well as have a good bearing on what I want to do with my career. In the beginning of the web career I really struggled in deciding which way to go because I could make a living doing graphic design, or sys admin, or programming, but realized I enjoy writing software the most of the three. I mean I find myself reading books like The Art of Unix Programming and Code Complete for fun.. yikes! And honestly it was the joy of programming in CFMX that really sealed the deal for me on wanting to really focus on being a software developer. So that's the long answer... the short being I've been programming for around 18 years, and doing ColdFusion for almost 7 years. - Brandon -- -- http://devnulled.com ~| 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:197643 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: Limitations of CFMX 7.0 Developer Version Gateways?
Double-check the JVM version that CF is using (SYSTEM INFORMATION in the top nav of the CF Admin). A colleague same this behavior on a system that had the 1.4.0 JVM. Thanks Sean. I'd actually tried another JVM as well just in case-- the default one which came with JRun (I did the multiserver install), as well as 1.4.2_06, but forgot to mention that. This morning I reinstalled CFMX 7 as the time limited Enterprise version rather than the Developer version and it seemed to clear up the problem. Previously it appeared that the Damon Cooper's gateway example would just sort of hang after 10 calls to the gateway, and now it runs all 100. So now I'm curious as to what way the gateways are limited in the Developer's version so I'll know to look out for that gotcha in the future. As an initial guess, it looks like you're limited to 10 gateway calls per server request? Thanks, - Brandon -- -- http://devnulled.com ~| 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:194095 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
Limitations of CFMX 7.0 Developer Version Gateways?
I'm currently working with the CFML asynch gateway in CFMX 7.0 using the Developer edition and I seem to be having various problems with events not running. Essentially I'll fire off about 5 events, and only 2 of them ever complete even though they are queued successfully. Nothing shows-up in any of the JRun or CF logs, so it doesn't quite make sense. I also tried Damon Cooper's demo file app and it doesn't work correctly either-- it seems to die after about 10 threads or so. I've played around with the various settings available via the CF Admin as well as the jrun.xml file just in case, and nothing seems to change anything. I was wondering if someone from MM could comment on the limitations of the event gateway in the Developer version of CFMX 7.0 as I couldn't find any documentation for it? I suppose I'll probably try installing the Enterprise trial tomorrow to test out this particular functionality, but it would be good to know what the limitations are in the Developer's edition. Thanks, - Brandon -- -- http://devnulled.com ~| 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:194009 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 Server Deadlock timed out queries while Enterprise Manager is Open
Your problem is not a CFMX problem, it's an Enterprise Manager problem. Our DBA's at work got us out of the habit of using that and now we only use the Query Analyzer to look at and change data. IIRC, Enterprise Manager locks the rows which are open in the display pane (so that you can edit them). - Brandon On Thu, 16 Dec 2004 12:59:56 -0800, Brook Davies [EMAIL PROTECTED] wrote: We recently added a second server to our CFMX application and are running now in this 2 server clustered environment. In the past we have always been able to open SQl Server enterprise manager and view/edit data at the database level. However, when we do this now, it looks like the CFMX database requests on BOTH servers start to get queued. When we close the table in the enterprise manager, the queued requests complete. In the CFADMIN we do NOT have a limit on the number of simultaneous DB connections. Is this a setting within SQl Server somewhere? Brook ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188189 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: Apache and CF
On Wed, 30 Jun 2004 13:03:15 -0400, Dave Watts [EMAIL PROTECTED] wrote: While you can't read the IIS metabase directly very easily, IIS isn't prone to having people screw up the httpd.conf file with typos, either. In addition, it's very easy to see what's going on in the IIS management console. This is a pretty easy problem to work around (though these are the paths for FreeBSD): $cp httpd.conf httpd.conf.bak $ee httpd.conf (edit file here with your editor of choice) $/usr/local/sbin/apachectl configtest (if it fails, you can revert to the backup, or compare them... also configtest will give you verbose output as to where/why it failed) $/usr/local/sbin/apachectl restart There are a few different web/GUI based ways out there of mucking around in httpd.conf as well if it's too scary for someone. - Brandon -- -- http://devnulled.com http://spooled.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone @ CF-FUN '04
Dick, You might want to check out REALbasic, it seems to have most all of what you are looking for: http://www.realsoftware.com/ I've never used it myself, but one of my friends at IBM uses it to write cross platform utilities. Hopefully that's of some help. - Brandon -- -- http://devnulled.com http://spooled.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Measure Application Bandwidth
On Fri, 25 Jun 2004 10:47:49 -0500, Chris McGrath [EMAIL PROTECTED] wrote: Hi all, I am in search of a tool that will allow me to measure how much bandwidth an application uses per user(average). The tools that comes to mind to keep track of this sort of stuff are either web stats, or something which actually tracks the bandwidth used on your network and you can do the calculations yourself. Here are a couple of free packages which might get you started down that path (both of which I've used and like) AWStats: http://awstats.sourceforge.net/ MRTG: http://people.ee.ethz.ch/~oetiker/webtools/mrtg/ Not sure if either of those are quite what you're looking for, but it's a start I suppose... - Brandon -- -- http://devnulled.com http://spooled.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Measure Application Bandwidth
Chris, Ahh, so you want something on the client side.Check out NetStat Live by AnalogX: http://www.analogx.com/contents/download/network/nsl.htm - Brandon On Fri, 25 Jun 2004 11:23:08 -0500, Chris McGrath [EMAIL PROTECTED] wrote: It's an http based coldfusion application. Basically what I am looking for is something I can put on a users machine and track how much bandwidth they use while they use the application. This is a multi-part message in MIME format. Chris McGrath wrote: I am in search of a tool that will allow me to measure how much bandwidth an application uses per user(average). What sort of application? If you mean a HTTP based application just get it from your webserver logfiles. If you mean something else, please elaborate. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Apache, CF5 and CFMX Question
I am trying to set up a local dev server that is running Virtual Hosts. I would like some of the virtual hosts to run on CF 5 and another to run on CFMX, has anyone achieved this? Mark, I've never tried that myself, but it seems like a pretty novel idea. I'm curious, if you reverse the order of the VirtualHosts in the httpd.conf file, does anything change?(I.E., CFMX works but CF5 doesn't?) - Brandon -- http://devnulled.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Securing CF Apps against SQL Injection Cross Site Scripting
I'm jumping a little late into this discussion, but I see a couple of things which haven't been discussed. I think you need to do protection against XSS and SQL Injection in multiple layers. 1.) Web Server / Application Server Layer 2.) Pre-Application Execution 3.) Post User Input / Pre Query 1: On IIS you can use the Microsoft tool URLScan for this, or the Aqtronix Web Knight.I believe this capability is built into IIS 6 on Win2K3, but I haven't used it yet to know for sure. For Apache, you should check into mod_security.I was pretty happy when this was released, and use it on my site. 2: I essentially wrote a custom app which checks various scopes for various RegEx's related to XSS and SQL Injection which are ran from Application.cfm, as well as the detection of buffer overflow attempts, etc.If something is violated, we get an e-mail with the details about it, and the user is redirected gracefully. 3: Make sure you scrub all user input, including checking the Len(Trim)) of each parameter to make sure it's not too long.Never trust anything which is coming in via form, url, cookie, or client variables (such as CGI.HTTP_USER_AGENT.And as others have mentioned, proper granular security on databases. This is a bit on the anal side, but the software I work with requires it. Note that pretty much all of these solutions assume you have a decent grasp of writing RegEx's, as well as know how the various exploits can be performed. Thanks, - Brandon http://devnulled.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How many class files do YOU have?
If you have that many CFM's then the reason you are getting OutOfMemory errors is due to the fact that you are running out of space in the permanent generation of the Java Heap. I won't get into specifics with JVM tuning. I have some info on my blog http://bpurcell.org but to fix this bump up the -XX:MaxPermSize value in your jvm.config to 192 or 256 it should get rid of the problem. Also load testing has found that you can uncheck the value save class files in the admin and still get the same performance without storing the class files to disk. They will be compiled on first hit and loaded into memory. With the slick new compiler in 6.1 it is very efficient, in fact more efficient than having to sort through 6000 class files to load the appropriate file. Hope that helps Brandon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF cluster setup... is there a howto somewhere?
There is an updated version of the article Jeremy suggested at (using CFMX 6.1 enterprise with the J2EE install) http://www.bpurcell.org/viewContent.cfm?ContentID=121 This article covers how Hardware can be used as well http://www.macromedia.com/devnet/mx/coldfusion/j2ee/articles/balancing_j2ee.html I also have another article on multiple instances if you want to use that model as well. http://www.macromedia.com/devnet/mx/coldfusion/articles/multi_instances.html Frank D and I are working on another article using Microsoft NLB. I can say after using it though it does not gain you alot beyond clustering the front end. Brandon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RIA options, Flex Flash and others.
Dick, The Flash examples you mention run fine on my machine and I do not notice any significant sluggishness. On slower machines I do see some issues but I think the comparisons you are drawing are not exactly fair. The XUL examples I have seen are not exactly visually stunning. Also, currently XUL is very limited on what browsers it can be ran on. I reviewed several of the examples at http://www.xulplanet.com/tutorials/xulqa/ and they are all pretty simple UI's. Although they are more responsive they do not look anything like the examples that Flex provides. If you look at how the flash player has changed over the last few versions you will see that performance has improved and the actionscript language has continued to evolve as well. Performance enhancements are high on the priority list for the Flash player and performance issues are not being ignored. Brandon There have been several threads lately, about RIAs and PIAs -- discussing Flex, Flash, XUL, Neuromancer (_javascript_ Remoting), desktop applications and XUL. I for one was/am critical of the Flash RIA as not being good enough -- resulting in a heavy or sticky feel to the UI. I realize the advantages of Flash, especially its consistency and ubiquity -- I only wish it were more usable and more programmable. Flex (at some cost) appears to address the programmability issue. Also, there are hints that the next CFMX will include some Flash programming capabilities. That's all well and good, if Flash can deliver acceptable performance -- if it can't then I will look elsewhere for RIA solutions. I like MACR, Their products are good to excellent, their people are great -- I have had no negative experiences with either. That said, Flash still disappoints me -- I would like to see it succeed.I would like to be able to use it. But there is something very wrong. Several days ago I mentioned that the Flex code explorer contained one of the slowest menu trees I'd ever seen. This is one of the apps that MACR uses to showcase the FlexFlash RIA. It just isn't fast enough to be usable, especially when you consider the amount of client resources it consumes to attain poor UI performance.My particular criticism is with the expanding and collapsing of the folders -- where only client-side RIA processing is performed, Two days ago I learned about XUL. XUL looks like a possible RIA solution that too, has been discussed in other threads. To prove to myself that the Flash Tree example was, indeed a poor performer, I decided to write a comparable tree menu in XUL.All I really did was create (part of) the tree. Selecting an item/document/leaf nodedoesn't do anything.I nested the folders 3 levels deep and duplicated the Component Library outer node enough times to get a tree larger than the code explorer. This is enough to compare expand/collapse with the Flash tree. Here it is.You need a current Mozilla or FireFox browser tto render XUL. http://67.124.145.42/XUL/XULSampleTreeMenu.xul Put this up, side-by-side with the Flex Code Explorer at: http://macromedia.com/software/flex/?promoid=home_prod_flex_111703# Expand enoughfolders on each to get the window scrolling.Then expand/collapse the top node. Why is Flash so slow? Thoughts! Dick P.S.Display source and you will see the entire XUL program. P.P.S.The XUL page may be slow to download -- The site is on my development machine which is quite busy -- JRUN/CFMX/MySQL, VirtualPC/WIN XP, 2 streamers, lots of browser windows a few desktop apps [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:JRun with ColdFusion
ColdFusion MX 6.1 shipped after the JRun 4 Updater 2 release so it is a later build. The build number for JRun that ships with CFMX 6.1 is 63824 The build number for JRun Updater 2 is 61650 You can always find the build # by going to JRun4/bin and typing jrun -info [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:cgi.path_info doesn't work in MX ?
It should be there, I have been using cgi.path_info in a lot of my CF applications.What webserver are you using? Brandon Hi, I've just found out that cgi.path_info return empty string in MX, whereas it works in CF5. I've the application just migrated to MX and I don't want to change all the scripts which use cgi.path_info to cgi. script_name, although I know cgi.script_name give the same function. I've too many scripts to work on. Is anyone out there has the same problem and know how to solve it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:How do you clear cache in CFMX?
Jon, I understand your frustation. Currenlty the only way to refresh is as Dave explains. It is difficult to hit ever page with it off though and restarting isn't a good option either.Look for this feature in the next release.It will probably be just a switch in the CF Admin to flush the current template cache and it will get rebuilt as pages are invoked. Brandon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFCACHE parts of pages without cfhttp
Be careful when using the filesystem make sure you do not store hundreds of files in a single directory.I found that the listing and searching through files can kill performance.I recommend creating subdirectories and breaking up the cached files. brandon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Resolved: Re:CFMX and Fedora
Of course, this tells me nothing. I tried recompiling the connector several times, once when I initially encountered the problem, once early this morning, and also about an hour ago. After the third recompile, ColdFusion started working. The only thing I have noticed that seems odd about the system right now is that sendmail takes almost 10 minutes to start since installing ColdFusion. M Something to check for the Sendmail problem... make sure you can actually do nslookups from the DNS servers which you have in /etc/resolv.conf I'm used to FreeBSD now so I'm not sure if that is the correct path. If you can't find that file, use the command 'locate resolv.conf' as root to find it. - Brandon http://booms.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFMX Instances on JRUN
Joe, There are two ways you can accomplish this. You can copy the cfusion-ear directory to another instance of JRun or you can rerun the installer and buildwar file. For the first approach just copy /server/cfusion/cfusion-ear. You can also create a new instace of JRun. Then rerun the installer and create a war file.Then follow the steps in my article http://www.macromedia.com/devnet/mx/coldfusion/j2ee/articles/endtoend.htmlIgnore steps 8 and 9 if you do not want to cluster.I will look into writing a step by step doc on this and posting it is as a technote. Brandon Purcell http://www.bpurcell.org Dave, No, i only have one Instance of CFMX. I am looking for the proper docs to deploy a second instance of CFMX and change setting etc. Thanks, Joe Eugene -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Saturday, September 27, 2003 4:24 PM To: CF-Talk Subject: Re: CFMX Instances on JRUN I wasnt able to find any clear documentation of the correct setup for Multiple Instances of CFMX on JRun. I installed CFMX Enterprise with Full JRun Version running. Can someone point me any docs on how to add the Second Instance of CFMX pointing to the same Web Root. It would be nice to debug which instance processed the request as well. Do you have 2 instances installed already, and you're just looking for info on how to share the doc root? Or are you asking how to install a second instance *and* set up the shared doc root. For sharing the doc root, the most concise instruction set is this: http://www.bpurcell.org/index.cfm?mode=entryentry=937 I've done this a lot, so if this doesn't fully answer your question, let me know and I'm glad to help you out. It can be confusing. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFMX Instances on JRUN
Joe, Do you get an error when you try to access the admin? When you go into the JMC under J2EE apps do you see CF deployed on the new JRun instance.Check the JRun4/logs to see if you see any issues with the CF deploy. You may want to try the second approach if you still have problems with the first since it would give you a fresh start with the cfusion.war. Brandon Purcell http://www.bpurcell.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Load Testing Tools
Here are a few that may be helpful http://www.bpurcell.org/macromedia/loadtesting.cfm If you want something simple and inexpensive. Try Microsoft Web Application Stress tool. OpenSTA is a little more robust but a little more difficult to work with. - Brandon Purcell http://www.bpurcell.org ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Strangeness in DWMX with circuits.xml.cfm files
Massimo, Here is the test case. I had a couple of other co-workers try it-- one with DWMX Fusedocs installed, and one without, and they weren't able to repeat the problem unfortunately. 1.) Create a new file.. I /think/ you should be able to name it anything, but I happen to be using a FB4 file named circuits.xml.cfm. I've saved this file on its own, as well as into VSS, and the same problem happens each time. 2.) Copy and paste the below content into it: circuit access=internal /circuit 3.) Save the file 4.) Close the file 5.) Reopen in DWMX or anything else (preferred) and see if the file now looks like this: access=internal / One other thing I have noticed-- it seems to save fusebox.xml.cfm files correctly which have a structure like this (related to the word circuits): ?xml version=1.0 encoding=UTF-8? fusebox circuits circuit / /circuits /fusebox Hopefully that's of some help. Thanks, - Brandon --- http://booms.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strangeness in DWMX with circuits.xml.cfm files
(x-posted to the fusebox.org forums) I'm currently working on a project in Fusebox 4 using Dreamweaver MX 6.1, and it seems to be stripping the word circuits out of any circuits.xml.cfm file. I haven't really altered the config of DWMX very much, other than adding Fusedocs to it (which I suspect could be part of the problem?) For instance, a file which looks like this: circuit access=internal /circuit Will end-up looking like this when I reopen it: access=internal / Has anyone else came across this problem or have any ideas on how to fix that behavior? Meanwhile, I guess I'll just use CF Studio. Thanks, - Brandon --- http://booms.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Running on FreeBSD 5.1-RELEASE
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 For the 2-5 people in the ColdFusion community that might actually be interested... :) I finally got a chance to play with installing CFMX on FreeBSD again, and have it up and running! I'm pretty excited-- this is something I've wanted to have working for a long time-- my favorite web dev language running on my favorite OS. I wish I had a beefier box to try it out on-- I don't think the Celeron 466 with 256 MB of RAM its on will really be a good testament to its performance, but it's what I have. I'm running a few sample Fusebox 3 apps that don't really do any queries or anything special, and they are taking around 2.3 seconds per page to run (and yes, I realize they have to compile on the first load). Anyone ran CFMX on a Windows box with similar hardware? I'm curious about the difference in performance since FreeBSD is a pretty Java unfriendly platform, but it's getting better. Anyhow, I still have a lot of stuff to finish configuring before I can give much of a review on it. I'll document the process and post it somewhere once I'm farther along than just having the CF Administrator and some demo code working... its actually pretty easy, just needed 4-5 extra hours to play and some hardware to get to try it out again. I must mention-- thanks to Macromedia for documenting the OSX install which helped me with this one. You can find a couple of screen shots here (though you'll probably kill my server.. its getting ready to be replaced shortly): http://booms.net/gallery/CFMXonFreeBSD - - Brandon - -- http://booms.net -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+++gKItvhVYbHj70RAi/MAKCQQkaRarVTeb3gK5T4STd+NKx9EACgjoDA X6ienbLpdIs0uJzwQGBXaxA= =/K2C -END PGP SIGNATURE- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: encrypting password
One note on security using hash, this still leaves the passwords in the database open to dictionary attacks. Its really only slightly better than storing the passwords unencrypted. That is to say, if the attacker somehow gains access to the database, they just need to use a dictionary file, and try a hash of those words one at a time until a match is found. A generally accepted strategy is to use a salt word as well to create the password. The salt is a string which you know and keep secure, which the attacker hopefully does not. Then they need 2 pieces of information to attack the database. The comparison is essentially the same: cfset salt = mysuperS3cRetStr$ng cfif Hash(form.passwordsalt) is not checkperson.passwordHash cflocation url = unauthenticated.cfm cfelse ... /cfif when you insert the hashed password, just append the salt to the end. cfset hashedPwForDBInsertion = Hash(form.passwordsalt) One more note, using hash() makes lost password retrieval more difficult in that the hash() function is a one way hash. There is no way to unhash. So essentially, if someone loses their password, you need a mechanism for them to reset the password to a new password, rather than just pulling the old one from the db and sending it to them. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 11:51 AM To: CF-Talk Subject: RE: encrypting password I'd suggest using CFs hash() function. It's a one way encryption/obfuscation method. Doug ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
HELP -- CFMX Very High Queued Requests/Hanging
Jeremy, Drop me an email at [EMAIL PROTECTED] What is the URL of the forums posting? Have you taken a thread dump when the server hangs? Are there any errors in /runtime/logs? Thanks Brandon Purcell Sr Product Support Engineer Macromedia [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX (Session State Replication)
Joe, With CFMX Standalone both Enterprise and Professional session replication is not possible. This is an issue with the underlying objects that represent the data in CFMX. In order for session replication to work the objects need to be serializable. In the first release of CFMX for J2EE this was still a problem. In the last release (CFMX for J2EE Phase II) changes were made to make all session data serializable. They also had to make changes to the CFMX classloader so this required a bit of work. If the underlying application server supports session replication then CFMX for J2EE Phase II will replicate session data as well. I am in the middle of completing an article for the DevCenter that illustrates how to configure this on JRun. Look for it in the middle of the month of Feb. For a lead in you can read my article about multiple instances http://www.macromedia.com/desdev/mx/coldfusion/j2ee/articles/multiple.html Let me know if you have any questions Brandon Purcell [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX on FreeBSD
Has anyone been able to get CFMX and FreeBSD working together? I got it working on CFMX RC1 last Spring or so with FreeBSD 4.5. Keep in mind that working means in standalone mode only and that Verity will probably never work. I didn't try to setup an ODBC connection. If so, have you experienced problems with this setup? Solutions? After I finally got it setup, I realized the same flaw as when I got JRun 2 running on FreeBSD. Its kind of pointless to do because there are no connectors to get it to work with Apache. It's a fun project I guess, but without being able to do much with the standalone webserver such as multihoming, its not of any use to me. Here are some very rough notes of my install if you're curious: http://booms.net/article.php?story=20030104145852802 They are by no means thorough since I decided it was sort of a waste of time to go back and document it properly, but perhaps it will be of some help. It was really pretty easy. - Brandon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Where to put CFMX? - remoting and IIS
Candace, It should not matter where you install CFMX, flash remoting requests are handled by the ISAPI filter then passed on to CFMX. So the configuration you need to check is in IIS. Make sure that the ISAPI filter is installed at the global level and the /JRunScripts virtual directory is added at each site. Then try the URL http://siteurl/flashservices/gateway You can set verbose=true in the jrun.ini file to see what is happening Brandon Purcell [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Error Template
Just thought I'd pass along an interesting difference I found in CFMX today with error templates since I finally have it in a production setting. Its probably already been covered somewhere, but it can't hurt to share. If multihoming on a server, you will want to create a virtual directory in the CF Administrator to somewhere that your error templates are located. Otherwise they will not work as you would expect them to. If your error template depends on anything from a cfapplication tag or something else such as that in Application.cfm/OnRequestEnd.cfm AND the error handler is not in the same directory as those files, you'll need to cfinclude them manually. They are not ran during the error handler request if they reside in a different directory (such as if they further up the directory tree.. normally they would be ran). Be sure to wrap the include(s) in cftrycfcatch tags (obviously). Secondly, if a page cannot be compiled because of something like a syntax error, it will not use the error template and will dump a regular error message to anyone who hits that page. So if you're depending on some sort of mechanism in your error template to log/report errors, please make sure to check the application log for errors in pages that can't be compiled (of course you should already be checking it anyhow...). Hopefully someone will find this useful. - Brandon -- http://booms.net http://spooled.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF Instant Messaging
An option besides those old tags is PresenceWorks ( http://www.presenceworks.com ). I've worked enough with it enough to get something basic working in CF 5, then another project came along and I haven't gotten back to it yet. Perhaps I'll be able to write it as a CFC by the time it's a priority again and open source it at CFLib or something along those lines. I don't remember what the service cost of PresenceWorks is offhand, but its very reasonable. The support is very good as well-- when I had some questions I ended-up talking to the person who wrote their Java API. I think combining PresenceWorks with the open source work which has already been done to figure out the AIM/ICQ (they both use the same login servers now.. rumor is they are working to merge protocols, finally!), MSN, and Yahoo protocols, I suppose you could eventually roll something together. However it seems like a pretty big PITA and potentially maintenance heavy item if its not core to you or your clients business. - Brandon -- http://booms.net http://spooled.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Typos in Method selection Exception Error
I wasn't sure where to submit this, but I know there are Macromedia types on the list and its past my bedtime. There are typos in this error message in CFMX (updated with the Updater v1): Error Occurred While Processing Request Method selection Exception. An exception occurred during method selection process for Method CreateContext The cause of this exception was that either there are no methods with the the specified method name and argument types, or the method CreateContext is overloaded with arguments types that Coldfusion can't decipher reliablly. Use javacast function to reduce ambiguity. reliablly should be reliably There are repeated the's in the text either there are no methods with the the specified method name and argument types Thanks, - Brandon -- http://www.booms.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: RE :set email timezone?
mind to tell me how to check the zone please? thanks I don't know if there is a command line way (doubtful...), but double click on the clock in the System Tray, and click on the time zone tab. As far as synching time, there is no reason to install unnecessary software. Just setup a script that runs this command once a week from the command line: net time /setsntp:ntpservergoeshere.com (If you have a server farm, set up an internal server with NTP and let everything update off of it instead of a public NTP server) BTW-- if you run the above command and suddenly the time is definitely off compared to what the local time is, then the time zone is set wrong on that machine. - Brandon -- http://spooled.net http;//booms.net FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
granted that that is true. however doesn't CF or any other programming language do the same thing. and if the way your getting at the data is by using form and url parameter, then it's very easy for me to do from the website and not even bother to try hack the database. using client variables and session variables make this a little harder but not impossible. I was just thinking about this issue today myself since I'm currently working on something that involves the privacy issues of a lot of users. My initial thought was to do something such as just using Encrypt() and Decrypt() to put all variables encoded into one long form/url string. Though on a page with a lot of links, that would be way too CPU intensive, and its just a hack job around a good security plan (though I can see its usefulness as just one small part of a plan-- I tend to encrypt any somewhat sensitive or easily altered data in Client/Cookie/Session scopes for instance). The solution would be to make a role based security scheme to take care of that problem. In theory, it shouldn't matter if someone is manually entering in ID's of things via Form/URL strings which they want to see so long as you are checking their permission level to that specific record. Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. As others have said, you could probably just use GUID's if you are that worried. The additional layer of security would negate the minute added CPU time needed to generate GUID's if the application needed the additional security. Again, if you are controlling / checking access to records (essentially treating all data from forms and URL's as if it were a virus), it shouldn't be a problem to begin with. One of the other things I could think of being bad about using plain incrementing integers is that unless you start at a random point of assigning ID's, people could perhaps get a general idea of how many records for that type of data exist in the database. Random ID's (a la Access) are very problematic if you ever need to 'upsize' data to a different database server or environment (i.e. I could see how they could be a pain for clustering and/or replication). Or maybe just the recent experience of upsizing a replicated Access DB pool w/ random ID's to SQL Server has left a bad taste in my mouth. :) - Brandon -- http://spooled.net http://booms.net FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FreeBSD and Java = CFMX???
From: Alex [EMAIL PROTECTED] You have to be realistic and have a little business savvy. Concur. I've seen maybe 3-4 people mention they were interested in seeing it on FreeBSD? So I'm curious, has anyone been able to get the Linux version of CFMX running on FreeBSD 4.5? Believe it or not, I once had JRun running on a FreeBSD 3.4 box a couple of years back just to see if I could get it up and running. It was slow and it crashed a little too often, but it worked at least. I do remember seeing something about CFMX on FreeBSD in the beta forums, but I don't remember coming across anyone claiming to have of gotten it working. Anyhow, one of the projects I'm planning on pursuing over the weekend is trying to get CFMX working on 4.5 with Linux emulation. If it runs reasonably, I could certainly justify purchasing a copy of it to use on my personal server so long as the final version still work on it. I'm in the process of throwing some hardware together to try it out since I don't have anything newer than a firewall/NAT box running 4.3 around, and I really don't want to do a buildworld on my personal server to upgrade it since its pretty customized at this point. I don't think I could swallow having to move back to Linux or Win2K on my personal server, unfortunately. I hope I can get it to work. Otherwise I'm stuck with PHP for now. - Brandon -- http://spooled.net http://booms.net FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access
mySQL, hands down. With the right GUI front end you also have an easy and very powerful environment to work in. The free/donationware mySQLFront (http://www.mysqlfront.de) is my favorite. Thanks for the tip-- this is definitely the best Windoze MySQL front-end I've used. I've been using MyCC for close to a year, and its super quirky. I've been using it with in combination with phpMyAdmin to get past its shortcomings. I just used the Export Tables tool in MySQL-Front to move data from one database to another, and it worked flawlessly. If you didn't know it already, phpMyAdmin is an awesome web-based front-end for MySQL. I love the command line, but its just not a sufficient tool for managing a database. (I use MySQL on Linux and FreeBSD) As far as MySQL vs. Access, it will certainly take more time to configure and learn MySQL, but you'll be glad you did in the long run. Downloading the above GUI will make it very simple to work with once you get it setup. IMHO, if you need a book, the best MySQL book is MySQL by Paul DuBois. Personally, I think anyone having problems with Access that can't afford MS SQL Server should really consider moving to MySQL. - Brandon -- http://spooled.net http://booms.net FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: apache 2 - windows
I vaguely remember this being discussed a while back and can't find the thread in the archives but... Has anyone built a coldfusion module to load with the new apache windows version ? What version of ColdFusion are you looking to get the shared object for? I'm not sure what the differences are in the Preview Release and Release Candidate versions of CFMX, but CFMX RC 1 does have an SO for Apache 2.x on windoze. - Brandon -- http://spooled.net http://booms.net FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next and previous records
Does anyone have a good query cache idea that would work with the example included? Thanks, Brandon - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 20, 2001 9:19 AM Subject: Re: Next and previous records Just a couple of notes: 1. Why not use a cached query so it doesn't reexecute on each page 2. Be careful using a url parameter (url.id) in a query without first validating it. You are leaving yourself open to hackers (http://www.vawter.com/urlhack.cfm) - Original Message - From: Michael Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 20, 2001 7:59 AM Subject: RE: Next and previous records Thanks This is what I wound up going with. Seems to be working fine so far. ...thanks, Joseph. CFQUERY NAME=GetRecords DATASOURCE=xionmediacom SELECT portfolio.*, media.*, clients.Client, portfolio.Description AS PortDesc FROM portfolio, media, clients WHERE portfolio.TypeID = #URL.ID# And portfolio.ID = media.PortfolioID AND portfolio.ClientID = clients.ID AND portfolio.ActiveStatus = 1 AND media.ActiveStatus = 1 ORDER BY clients.Client /CFQUERY !---Assign default value for start--- cfparam name=start default=1 !---Assign default value for display--- cfset display = 1 !---Calculate the next value--- cfset nextX = #start# + #display# !---Calculate the previous value--- cfset PrevX = #start# - #display# cfif PrevX LTE 0 cfset PrevX = 1 /cfif html head cfoutputtitle#title#/title/cfoutput /head body !---Output results--- h2Results Page/h2 cfoutput query=GetRecords startrow=#start# maxrows=#display# #PortDesc#br /cfoutput !---Previous (X) (only show this link if there are previous results)--- cfif #start# is not 1 cfoutput a href=thispage.cfm?start=#PrevX#display=#display#ID=#URL.ID# previous /a /cfoutput /cfif nbsp; !---Next (X) (only show this link if there are more results available)--- cfif nextX LTE GetRecords.RecordCount cfoutput a href=thispage.cfm?start=#nextX#display=#display#ID=#URL.ID# next /a /cfoutput /cfif /body /html -Original Message- This one also takes keyword as a paramater... It may be closer to what you need. (even supports multiple columns) http://cfhub.com/discussion/viewmessages.cfm?Forum=11Topic=422 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: legal question?????
Of course you are liable...really might want to speak with legal counsel about this. - Original Message - From: Amanda Stern [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 2:25 PM Subject: legal question? Hello, Not sure if anyone can answer this question/concern for me but will ask anyways.I have been creating some reports for HR that will be used internally to keep track of our employees work(ie number of items completed, average numbers etc). One of the averages I am being asked to report will be a very skewed number and I am concerned because these averages are used to grade employees. People have been let go over these numbers. Bottom line is, I do not want to have any numbers on my report that I already know are skewed. I expressed my concern to my employer and they agreed that the numbers will be off but they want it anyways and they say they will take that into consideration. Am I in anyway liable or am I being paranoid??? :) Thanks, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another little bit off topic subject..
Does anyone have a good and simple code set to parse out e-mail addresses from an CFHTTP request result. I have been grappling with a few things but can't seem to come up with a rounded solution that will find every occurance of an e-mail address in a HTTP output and create a list of those addresses that I can use to output later. Any suggestions or solutions would be appreciated Thanks, Brandon Wood ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Another little bit off topic subject..
Perfect...you rock. - Original Message - From: Bernd VanSkiver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 06, 2001 2:29 PM Subject: Re: Another little bit off topic subject.. CF_GetEmail http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34736D-2830-11D4-AA 9700508B94F380method=Full Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 06, 2001 11:36 AM Subject: RE: Another little bit off topic subject.. Does anyone have a good and simple code set to parse out e-mail addresses from an CFHTTP request result. I have been grappling with a few things but can't seem to come up with a rounded solution that will find every occurance of an e-mail address in a HTTP output and create a list of those addresses that I can use to output later. Any suggestions or solutions would be appreciated I think there's a tag in the Developer's Exchange, but I don't know it's exact name Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Parsing E-mail Addresses...
MessageDoes anyone have a good and simple code set to parse out e-mail addresses from an CFHTTP request result. I have been grappling with a few things but can't seem to come up with a rounded solutions that will find every occurance of an e-mail address in a HTTP output and create a list of those addresses that I can use to output later. Any suggestions or solutions would be appreciated Thanks, Brandon Wood ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Geek Cruises
You have got to be kiddingThere is no way I would spend eight friggin days with a bunch of you guys. I love you and all but jeez... - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 10:05 AM Subject: WOT: Geek Cruises Okay, I know this is off-topic, but I just found this link and thought it was interesting/funny enough to share. Geek Cruises: http://www.userfriendly.org/bazaar/GEN-geekcruises.html Enjoy! Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Geek Cruises
A.darn it. Wasn't trying to stir up the chilisjust a few geeks. - Original Message - From: John Paitel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 10:51 AM Subject: Re: Geek Cruises For shame, Brandon... your little friggin managed to get 2 chilis on the old Eudora Rate your email... LOL John At 10:06 AM 7/26/01 -0500, you wrote: You have got to be kiddingThere is no way I would spend eight friggin days with a bunch of you guys. I love you and all but jeez... - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 10:05 AM Subject: WOT: Geek Cruises Okay, I know this is off-topic, but I just found this link and thought it was interesting/funny enough to share. Geek Cruises: http://www.userfriendly.org/bazaar/GEN-geekcruises.html Enjoy! Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Database-driven Help System...
Does anyone have a suggestion for a good database-driven help system I can implement in an admin area of a site? I want to be able add a system that is similar to a windows help system but that gets its information from a database. Thanks, Brandon Wood ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: An official Apology
I don't know if it is just me, but did that whole apology sound exactly like the one in A Fish Called Wanda? Absolutely hilarious. Chill Outwe do not bite---at least now me. - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 8:21 AM Subject: An official Apology My poilitical ideals are very simplistic and nieve, I would like to say sorry to all people who have and will read my thread. I am sorry. A lot of our business is done in the United States and I would not like to Jeopardise that by a silly email. I am so nieve that my name and email address was available for all to see. Please forgive me everyone as my actions have been totally thoughtless. I truly wish I did not post this email. I am not politically minded and deserve all insults thrown at me, I am totally disgusted with my comments. Thank You John McCosker ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to get a list of all tables in a given datasource - and how to combine queries
Cool...how can I get a copy? Cheers, Brandon - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 9:01 AM Subject: Re: How to get a list of all tables in a given datasource - and how to combine queries Getting all the tables for a SQL database is simple. Just query the system table 'sysobjects' with this query: Select name,xtype from sysobjects where xtype = 'u' and name not like 'dt%' Order By Name For your second question it will take some logic to do what you want. Go look at this app that I am writting. It is a web based sql manager. www.factorxsoftware.com/sqlmanager HTH Clint -- Original Message -- From: JoshMEagle [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 08 Jun 2001 08:34:07 -0400 Have two questions First, given the name of a datasource, how do I go about finding what tables are contained in the datasource via CF (not just opening SQL Server) Second, I have a query of all the datasources on my server using cfregistry that is returned as a query ... how can I combine this information with the query to display the tables into one query? Is this even possible? THANKS! Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Complimentary skill
There is a guy names Stan out there who knows all ther is 2 kno about Cold Fuzion. He can tell u all you need to no. Cheers, BW - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 12:26 AM Subject: Re: Complimentary skill Jason, First off, I suggest you check out the CF-COMMUNITY list. (You can find more info at www.houseoffusion.com ) That lists tends to deal with more non-ColdFusion-technical specific issues. If you want to be a technical guy, I would suggest learning good database design first (I.E. normal forms, primary keys, foreign keys, intersection tables, insertion and deletion anomalies, etc...) Then learn SQL. Then learn good database implementation techniques (I.E. triggers, stored procedures, etc..). You will probably not be able to pick up one of those things without also picking some information on another. If you're anything like me, no matter how much you read up on / research / study good database design it will not make much sense until you try to apply it to a real-world situation. If you want to be on the graphic end of things, I'm not going to be much help. At 04:40 PM 06/08/2001 -0700, you wrote: I'm fairly new to the Cold Fusion world and am wondering what skill do you find compliments CF the most? I have been in IT for a little over 2 years now. I started as a Project Manager for a small company, caved into my jealousy for those who can develop and began learning web dev. When I was learning HTML I found that javascript and photoshop were 2 things that complimented HTML very well to give you a full set of tools. I started doing web-dev for my career at a company that was Unix based. I found that I didn't know my way around Unix so I began learning Unix, Apache, Netscape Server, and Korn Shell scripting. I used my web-dev and korn shell scripting to build a nice internally used cgi page that moved me into the Cold Fusion world. Now I'm wondering what next? I enjoy learning something at work and something different at home. What would you suggest for someone who wants to build a very broad and firm foundation for web dev? SQL? Flash? Perl? JSP? CF Server? Thanks for your input. Jason Stevens Codesic Consulting Kirkland, WA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MAIL error question...
Has anyone seen this error when sending cfmail out? From the ERRORS.log: Error,TID=182,06/07/01,11:21:16,Error occurred while attempting to send mail message. - [PT_ERROR] General error (550 not local host gardere.com, not a gateway) - Sender = '[EMAIL PROTECTED]', Recipients = '[EMAIL PROTECTED]' - Undelivered message archived to 'C:\CFUSION\MAIL\UNDELIVR\CFM631.TMP' I have been sending mail out through my normal mail gateway forever, and now all of the mail I send out gives me this error. If anyone has seen it, please elaborate, as I can't understand what CF is telling me. Thanks a ton, Brandon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL date.
You will have to convert the ODBC DateTime to another format in the template using the DateFormat function of CF. CFOUTPUT #DateFormat(#date#, mm/dd/)# /CFOUTPUT That should work... - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 4:42 PM Subject: SQL date. I would like SQL server to return the date in the format of mm/dd/ without the time. Is this possible? Actually I know it possible the problem is how :) Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS CF...
Jim, Right now, I have only 2 IP Addresses available to use. 1 for the machine, and 1 for the site. Right now, I am using the machine's IP and the site's for the regular http site. I haven't dedicated one of those for the SSL key, which I could. Right now, when I click advanced, I only see port 80 attached to the site's IP. What dould you recommend? I do have two IPs available to use. So are you saying that I create a single site in the MMC and then create 2 virtual directories each having a different IP or are you saying to create 2 sites with each pointing to the same home directory but with different ports and different IPs bound to the same? You are really helping me out here...I haven't message with virtual hosting and leave most of the hosting side of things to those who know better...but in this case, I am the only one holding the bag. If you can be specific in what should go in the site parameters, the IP config for both the ports and sites, advanced properties and possible host header places, I think I might just be on my way...for the record, I guess I do have two IPs I can use, I can point the Key to either of them in the Key Manager and have nothing more to losehehe Thanks a ton, Brandon - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:24 AM Subject: Re: SSL, IIS CF... That sounds like the way I usually set it up. Under the virtual site's properties you have TCP port 80 and SSL port 443 specified. If you click 'Advanced' you should see both ports bound to their respective IP address or host header. Are you using host headers (IPless domains) on your web server? If you're using host headers, remember that for SSL you need to have an IP address to which you bind the certificate. So, you could use host headers for the non-SSL (port 80) site, but you need an IP for SSL. Since you need a (dedicated) IP address for SSL on this site anyway, I'd just set up the http/port80 side using standard IP-based domain resolution as well and not use host headers at all for this particular virtual site. Have you completed installation of the certificate in Key Manager and pointed it to the correct IP address? Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 28, 2001 11:03 PM Subject: Re: SSL, IIS CF... Jim, I issued the cert under the standard www.mysite.com. I haven't set up two virtual sites using different ports. Is that the key? And if so, how can you set them up to both use the same dir? I have tried to just use a single site with both ports open and that doesn't seem to work. Every time I try to connect to the https URL, I get a page not found error--for the same template I can call with no problem using the standard http request. Thanks for your help, by the way. I think you are on thr right track to getting me edumacated...or as Stan says, You must no ssl sites good. Cheers and clarification, Brandon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS CF...
Yes, it is definitely the code calling Web Trends Live that is messing up the SSL page. I am trying to trap for the existence of https: in a page request but cannot seem to find any CGI or request variable that will return whether or not a page request is requesting http or https. Has anyone run across this? All I want to do is to not call the Web Trends Live code if the site requests an https page. That should solve my problem. Any help would be appreciated. Cheers, Brandon - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: Brandon Wood [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:51 AM Subject: Re: SSL, IIS CF... Do you have stuff like img src=http://www.someothersite.com; on the page? That'll definitely cause stuff like this. I'm not familiar with the Web Trends Live code that you're talking about. Is this a java class or somesuch? Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: Jim McAtee [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:42 AM Subject: Re: SSL, IIS CF... Jim, Darn it, I bet the secure and nonsecure message is coming up due to the existence of Web Trends Live code I have on all of my pages. Hmm...any suggestions? Cheers, BW - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: Brandon Wood [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:57 AM Subject: Re: SSL, IIS CF... Brandon, Are you using IIS4 (NT4) or IIS5 (Windows 2000)? Just to let you know... my only experience is with IIS4. The following describes what I see in one of my sites with a certificate installed. Select the virtual site and go to Properties (right click, then Properties, or click the finger/hand icon above. On the 'Web Site' tab, it shows the IP address, which I'd setup with the second of your two IP addresses. There's a box labeled 'TCP Port' which should have '80' in it. The 'SSL Port' box should have 443 in it. Clicking on the 'Advanced' button should show two areas, the above showing the port 80 configuration, the bottom one showing the port 443 config. If the 'SSL Port' box on the 'Web Site' tab is greyed out, I belive it's because there's no certificate is installed on the machine (not certain about this, however). Therefore, it may be necessary to correctly install the cert before doing the above. Not sure where you are with the certificate, so excuse me if you already know this: Under key manager your certificate must be installed and bound to the IP address that you're going to use for SSL. Double check this. Installing the certificate is a two part deal. First you generate a certificate request, which you send off to Thawte, Verisign, etc. They issue you a certificate which you then install in key manager. You go back to the request in key manager and install it there. Only after you've installed the certificate (just a block of encrypted text) will the certificate be active. Beyond the above, there shouldn't be anything you need to do with virtual directories or special directory permissions, etc. In fact, you probably don't want to mess with them unless for some other purpose. The entire site should be enabled for SSL. Which brings up some other issues. Once you get this far, I'll tell you about those. Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:24 AM Subject: Re: SSL, IIS CF... Jim, Right now, I have only 2 IP Addresses available to use. 1 for the machine, and 1 for the site. Right now, I am using the machine's IP and the site's for the regular http site. I haven't dedicated one of those for the SSL key, which I could. Right now, when I click advanced, I only see port 80 attached to the site's IP. What dould you recommend? I do have two IPs available to use. So are you saying that I create a single site in the MMC and then create 2 virtual directories each having a different IP or are you saying to create 2 sites with each pointing to the same home directory but with different ports and different IPs bound to the same? You are really helping me out here...I haven't message with virtual hosting and leave most of the hosting side of things to those who know better...but in this case, I am the only one holding the bag. If you can be specific in what should go in the site parameters, the IP config for both the ports and sites, advanced properties and possible host header places, I think I might just be on my way...for the record, I guess I do have two IPs I can use, I can point the Key to either of them in the Key Manager and have nothing more to losehehe Thanks a ton, Brandon
Re: SSL, IIS CF...
Jim, Yes, I got it to work... Here is the code I used to keep the Web Trends code from showing. I sure hope this helps people out who might be going through these problems themselves. cfparam name=CGI.HTTPS default=off cfif #CGI.HTTPS# IS off cfinclude template=stats/Web_Trends_Live_Stats.cfm /cfif Thanks a ton, Brandon P.S. BTW, what were some of the caveats you were going to mention once the SSL worked? I am curious to find out if they are ones I have already come across. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: Brandon Wood [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:22 PM Subject: Re: SSL, IIS CF... If you can turn CF debugging on you should see a cgi variable called HTTPS, with a value of on. Do something like: cfparam name=CGI.HTTPS default=off ... cfif not CGI.HTTPS ... put your outside site references, Web Trends stuff, etc. here. /cfif Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: Jim McAtee [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:23 PM Subject: Re: SSL, IIS CF... Yes, it is definitely the code calling Web Trends Live that is messing up the SSL page. I am trying to trap for the existence of https: in a page request but cannot seem to find any CGI or request variable that will return whether or not a page request is requesting http or https. Has anyone run across this? All I want to do is to not call the Web Trends Live code if the site requests an https page. That should solve my problem. Any help would be appreciated. Cheers, Brandon - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: Brandon Wood [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:51 AM Subject: Re: SSL, IIS CF... Do you have stuff like img src=http://www.someothersite.com; on the page? That'll definitely cause stuff like this. I'm not familiar with the Web Trends Live code that you're talking about. Is this a java class or somesuch? Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: Jim McAtee [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:42 AM Subject: Re: SSL, IIS CF... Jim, Darn it, I bet the secure and nonsecure message is coming up due to the existence of Web Trends Live code I have on all of my pages. Hmm...any suggestions? Cheers, BW - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: Brandon Wood [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:57 AM Subject: Re: SSL, IIS CF... Brandon, Are you using IIS4 (NT4) or IIS5 (Windows 2000)? Just to let you know... my only experience is with IIS4. The following describes what I see in one of my sites with a certificate installed. Select the virtual site and go to Properties (right click, then Properties, or click the finger/hand icon above. On the 'Web Site' tab, it shows the IP address, which I'd setup with the second of your two IP addresses. There's a box labeled 'TCP Port' which should have '80' in it. The 'SSL Port' box should have 443 in it. Clicking on the 'Advanced' button should show two areas, the above showing the port 80 configuration, the bottom one showing the port 443 config. If the 'SSL Port' box on the 'Web Site' tab is greyed out, I belive it's because there's no certificate is installed on the machine (not certain about this, however). Therefore, it may be necessary to correctly install the cert before doing the above. Not sure where you are with the certificate, so excuse me if you already know this: Under key manager your certificate must be installed and bound to the IP address that you're going to use for SSL. Double check this. Installing the certificate is a two part deal. First you generate a certificate request, which you send off to Thawte, Verisign, etc. They issue you a certificate which you then install in key manager. You go back to the request in key manager and install it there. Only after you've installed the certificate (just a block of encrypted text) will the certificate be active. Beyond the above, there shouldn't be anything you need to do with virtual directories or special directory permissions, etc. In fact, you probably don't want to mess with them unless for some other purpose. The entire site should be enabled for SSL. Which brings up some other issues. Once you get this far, I'll tell you about those. Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:24 AM Subject: Re: SSL, IIS CF... Jim
Silly Validation Question...
Hey, Does anyone have a good script or method of making a select box contain a value other than ? I am working on a state drop-down in which the first selection is Pick State with a value of . What I want to happen is for a javascript screen to pop up (or something like that--you know the usual CFFORM javascript validation) if a user tries to submit the form without choosing a state that has a value. I have seenm this used many times and even with CFSELECT form fields, but I am having the worst time trying to implement this. I want to populate the CFSELECT with a query from a State_Table but do not want to store a state with a value of as not to populate a state field with NULL answer. Is there an OnError or someother Javanscript function that could make sure that a value other than was chosen and that the error message could be configurable. I know that this is so CF 101, but I have never had to do this and am pulling my hair out in anger. Thanks a ton, BW ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS CF...
You are so cool...I found the code generator and made a version for SSL. And now I use the following code to check which one to show: cfparam name=CGI.HTTPS default=off cfif #CGI.HTTPS# IS off cfinclude template=stats/Web_Trends_Live_Stats.cfm cfelse cfinclude template=stats/Web_Trends_Live_Stats_SSL.cfm /cfif Thanks for the advice...That really helped! Cheers, Brandon - Original Message - From: Bill Holloway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 3:53 PM Subject: RE: SSL, IIS CF... Two solutions: If you don't care about tracking the secure pages, you can take advantage of the cgi.server_port_secure variable and include or exclude the web trends code accordingly. Also, I know you can generate a https:// version of the web trends tag from the webtrendslive.com site under the customize your code section. HTH Bill -Original Message- From: Brandon Wood [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 11:23 AM To: CF-Talk Subject: Re: SSL, IIS CF... Yes, it is definitely the code calling Web Trends Live that is messing up the SSL page. I am trying to trap for the existence of https: in a page request but cannot seem to find any CGI or request variable that will return whether or not a page request is requesting http or https. Has anyone run across this? All I want to do is to not call the Web Trends Live code if the site requests an https page. That should solve my problem. Any help would be appreciated. Cheers, Brandon - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: Brandon Wood [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:51 AM Subject: Re: SSL, IIS CF... Do you have stuff like img src=http://www.someothersite.com; on the page? That'll definitely cause stuff like this. I'm not familiar with the Web Trends Live code that you're talking about. Is this a java class or somesuch? Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: Jim McAtee [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:42 AM Subject: Re: SSL, IIS CF... Jim, Darn it, I bet the secure and nonsecure message is coming up due to the existence of Web Trends Live code I have on all of my pages. Hmm...any suggestions? Cheers, BW - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: Brandon Wood [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:57 AM Subject: Re: SSL, IIS CF... Brandon, Are you using IIS4 (NT4) or IIS5 (Windows 2000)? Just to let you know... my only experience is with IIS4. The following describes what I see in one of my sites with a certificate installed. Select the virtual site and go to Properties (right click, then Properties, or click the finger/hand icon above. On the 'Web Site' tab, it shows the IP address, which I'd setup with the second of your two IP addresses. There's a box labeled 'TCP Port' which should have '80' in it. The 'SSL Port' box should have 443 in it. Clicking on the 'Advanced' button should show two areas, the above showing the port 80 configuration, the bottom one showing the port 443 config. If the 'SSL Port' box on the 'Web Site' tab is greyed out, I belive it's because there's no certificate is installed on the machine (not certain about this, however). Therefore, it may be necessary to correctly install the cert before doing the above. Not sure where you are with the certificate, so excuse me if you already know this: Under key manager your certificate must be installed and bound to the IP address that you're going to use for SSL. Double check this. Installing the certificate is a two part deal. First you generate a certificate request, which you send off to Thawte, Verisign, etc. They issue you a certificate which you then install in key manager. You go back to the request in key manager and install it there. Only after you've installed the certificate (just a block of encrypted text) will the certificate be active. Beyond the above, there shouldn't be anything you need to do with virtual directories or special directory permissions, etc. In fact, you probably don't want to mess with them unless for some other purpose. The entire site should be enabled for SSL. Which brings up some other issues. Once you get this far, I'll tell you about those. Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:24 AM Subject: Re: SSL, IIS CF... Jim, Right now, I have only 2 IP Addresses available to use. 1 for the machine, and 1 for the site. Right now, I am using the machine's IP and the site's
Re: Silly Validation Question...
Hmm... Tried just about every suggestion, and nothing seems to be popping up as a warning...the form just submits anyway. I have written a dynamic form loops through a table and gets all of the questions that appear for the form, then loops through various question types to see what type of question it is. Then when a question of type state is called, a dynamic drop down is generated with a unique question id and a list of states to choose from. The code I am using follows--which doesn't seem to work: CFFORM ACTION=pv_post.cfm method=post NAME=addcase CFIF #sec_info.field_type_id# IS 7 cfquery name=get_states datasource=#datasource# dbtype=ODBC SELECT * FROM State_Table ORDER BY State_ID /cfquery cfoutput script language=JavaScript if (document.addcase.qu_#sec_info.cqid#.value == void){ alert(Pick a state!); } /script /cfoutput cfoutput select name=qu_#sec_info.cqid# /cfoutput OPTION VALUE=voidSELECT STATE CFOUTPUT query=get_states OPTION VALUE=#state##state# /cfoutput /select /cfif cfoutputINPUT TYPE=hidden NAME=question_list VALUE=#question_list#/cfoutput INPUT type=submit name=insert value=Continue raquo; nbsp; /CFFORM I can't seem to get the message to pop up, and it is driving me crazy. Am I putting the javascript in the wrong place. It seems as though, since the form is displayed on the fly that I need to keep the javascript near the loop item, so that the dynamic form field name sits together with the dynamic field. I just can't get the javascript to notice if I have or haven't chosen the void value. The form just submits regardless. Thanks again for all of the suggestions, so far. Cheers, Brandon - Original Message - From: David Baskin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 6:17 PM Subject: RE: Silly Validation Question... Brandon, put your pick a state select option before your cfoutput on the state query. then, on submit of the form, do a check to see if the user has not selected a state. i use a value of void in my boxes and then just do a simple javascript check to see if the value of the select box is void. if so, throw an error. HTH. d example: cf: select name=state size=1 option value=void Select a State cfoutput query=states option value=state_cd #state_cd# /cfoutput javascript: if (document.yourformname.state.value == void){ alert(Pick a state!); } -Original Message- From: Brandon Wood [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 2:13 PM To: CF-Talk Subject: Silly Validation Question... Hey, Does anyone have a good script or method of making a select box contain a value other than ? I am working on a state drop-down in which the first selection is Pick State with a value of . What I want to happen is for a javascript screen to pop up (or something like that--you know the usual CFFORM javascript validation) if a user tries to submit the form without choosing a state that has a value. I have seenm this used many times and even with CFSELECT form fields, but I am having the worst time trying to implement this. I want to populate the CFSELECT with a query from a State_Table but do not want to store a state with a value of as not to populate a state field with NULL answer. Is there an OnError or someother Javanscript function that could make sure that a value other than was chosen and that the error message could be configurable. I know that this is so CF 101, but I have never had to do this and am pulling my hair out in anger. Thanks a ton, BW ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Silly Validation Question...
Think I figured it out the first part using the cf_field_validation tag. Pretty neat! The only problem is that I want to call two javascript functions from the same onsubmit call--due to the fact that I have two separate loops running in order to serve up two parts of the dynamic form. What's the proper format to use when calling multiple javascript functions from the same form? This doesn't seem to work: CFFORM ACTION=pv_post.cfm?sa=2stid=4scid=8p=post_insertpt=post_insertcid=#cid # method=post NAME=addcase onsubmit=return state();return state_2(); INPUT type=submit name=insert value=Continue raquo; onclick=return state();return state_2(); It does work however with the first set of state javascript checksbut the state_2 checks do not get executed. This is so dumb, but what can I call to get both state and state_2 javascript functions to get executed once the user clicks the submit button? Thanks a ton, BW - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 7:15 PM Subject: RE: Silly Validation Question... Brandon, The solution to the problem is to NOT use CFFORM for validation. Use roll-your-own JavaScripts instead. You'll have far greater flexibility. Here's an example of how I was able to make sure a state was selected in a form: -snip--- script language=JavaScript!-- function validate(form) { if (form.state_code.selectedIndex == 0) { alert('Please select a state.'); return false; } return true; } //--/script cfparam name=state_code default= cfif state_code neq cfoutput #state_code# /cfoutput /cfif CFQUERY NAME=get_states DATASOURCE=zapconnect_com_sql SELECT STATE_CODE, STATE_NAME FROM STATES ORDER BY STATE_NAME /CFQUERY cfoutput form action=#script_name# onSubmit=return validate(this) select name=state_code option value=Select a State: /cfoutput cfoutput query=get_states option value=#state_code##state_name# /cfoutput /select input type=submit value=Submit /form snip- Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net -Original Message- From: Brandon Wood [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 2:13 PM To: CF-Talk Subject: Silly Validation Question... Hey, Does anyone have a good script or method of making a select box contain a value other than ? I am working on a state drop-down in which the first selection is Pick State with a value of . What I want to happen is for a javascript screen to pop up (or something like that--you know the usual CFFORM javascript validation) if a user tries to submit the form without choosing a state that has a value. I have seenm this used many times and even with CFSELECT form fields, but I am having the worst time trying to implement this. I want to populate the CFSELECT with a query from a State_Table but do not want to store a state with a value of as not to populate a state field with NULL answer. Is there an OnError or someother Javanscript function that could make sure that a value other than was chosen and that the error message could be configurable. I know that this is so CF 101, but I have never had to do this and am pulling my hair out in anger. Thanks a ton, BW ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SSL, IIS CF...
Hey all... I am going to be a complete heel and ask a few questions about SSL to those who seem to work with it quite a bit in real world scenarios. I haven't had to implement an SSL-protected site or templates in some time and seem to be stumbling when trying to implement a strategy to begin. My situation is this: I have written an entire site, including non-secure forms that collect and store user data and the like using CF and SQL Server. I am in the process of securing the pages using SSL but have been having problems getting started. Is there any way I can use a directory to house both secure and non-secure forms and call them merely using https instead of http? I am having the worst time in trying to get even a page to show up using IIS's directory security using an SSL key pointed to an IP using the secured directory. There always seems to either be a page not found error or a SSL protected page error. Any help at all in getting any or all of these issues ironed out would be extremely useful, as I did not think it would take much time at all to roll out a secured version of the templates I had already writtenwhich may be an extremely huge misguided thought. Also, does anyone know of a GOOD repository of SSL, IIS, CF and setting these up in general? I have scoured the Microsoft site to no avail, and there is not much better info available from Allaire, it seems. Thanks a ton for the vine...and any help you may send my way. Cheers, Brandon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS CF...
Jim, I issued the cert under the standard www.mysite.com. I haven't set up two virtual sites using different ports. Is that the key? And if so, how can you set them up to both use the same dir? I have tried to just use a single site with both ports open and that doesn't seem to work. Every time I try to connect to the https URL, I get a page not found error--for the same template I can call with no problem using the standard http request. Thanks for your help, by the way. I think you are on thr right track to getting me edumacated...or as Stan says, You must no ssl sites good. Cheers and clarification, Brandon - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 28, 2001 11:29 PM Subject: Re: SSL, IIS CF... Brandon, Say your non-secure site is at www.mysite.com. Is your certificate issued for www.mysite.com or some other host name like secure.mysite.com? In IIS, have you set up two distinct virtual sites, or do you merely have both port 80 and port 443 enabled for a single virtual site? I've found the easiest way to work with SSL is to simply have the cert issued for the standard domain name www.mysite.com. Then content can be served using either http or https. Jim - Original Message - From: Brandon Wood [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 28, 2001 9:49 PM Subject: SSL, IIS CF... Hey all... I am going to be a complete heel and ask a few questions about SSL to those who seem to work with it quite a bit in real world scenarios. I haven't had to implement an SSL-protected site or templates in some time and seem to be stumbling when trying to implement a strategy to begin. My situation is this: I have written an entire site, including non-secure forms that collect and store user data and the like using CF and SQL Server. I am in the process of securing the pages using SSL but have been having problems getting started. Is there any way I can use a directory to house both secure and non-secure forms and call them merely using https instead of http? I am having the worst time in trying to get even a page to show up using IIS's directory security using an SSL key pointed to an IP using the secured directory. There always seems to either be a page not found error or a SSL protected page error. Any help at all in getting any or all of these issues ironed out would be extremely useful, as I did not think it would take much time at all to roll out a secured version of the templates I had already writtenwhich may be an extremely huge misguided thought. Also, does anyone know of a GOOD repository of SSL, IIS, CF and setting these up in general? I have scoured the Microsoft site to no avail, and there is not much better info available from Allaire, it seems. Thanks a ton for the vine...and any help you may send my way. Cheers, Brandon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
previous/next in sql
alright, i'm trying to create a "previous/next" statement so that my query only grabs 6 records at a time. but first off, i have an order by statement that reads: order by datediff(dd,expirationDate,getdate())/abs(datediff(dd,expirationDate,getdate())),businessName so i can't just grab where the id field is greater than the last one outputted. then i tried creating it in a cursor in sql, but its a dynamic query, and i couldn't have a sql "if" statement within the "where" clause, to check if a value was 0 or not something like: where 0=0 if (@stateId0) and stateId=@stateId i might be missing something, or maybe someone has a better idea, but what i'd really like to do (if it can be done) is grab 6 records, and within sql, be able to specify the row number of the outputted queryso then i can put where (row number) 6 for the next set of records. Brandon Paolin Programmer AVERICOM Communications 856-874-1133 ext. 321 1931 Olney Avenue * Suite 600 Cherry Hill, NJ 08003 http://www.avericom.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: previous/next in sql
i can't use a cursor cause its a dynamic query, and i couldn't have a sql "if" statement within the "where" clause, to check if a value was 0 or not something like: where 0=0 if (@stateId0) and stateId=@stateId - Original Message - From: "Russ Conway" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 04, 2001 3:38 PM Subject: RE: previous/next in sql alright, i'm trying to create a "previous/next" statement so that my query only grabs 6 records at a time. How about using a cursor and submitting the ID of the last record processed as a parameter to the stored procedure? Then just loop through the results until you hit the ID passed to the procedure and return the next 6 rows. Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (646) 638-3444 http://www.hallofsports.com .. . . where the legends live on ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US Zip Codes
Here you go. These are at least 1.5 years old. They seem to be reasonably accurate. Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com/ [EMAIL PROTECTED] -Original Message- From: Kent A. Orso [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 8:42 AM To: CF-Talk Subject: Re: Database of US Zip Codes Check out CF_STATE on the Allaire Tag Gallery - Original Message - From: "JoshMEagle" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 12, 2001 8:52 AM Subject: RE: Database of US Zip Codes Anyone know of a pre-existing database of US zips/cities? Proabably a shot in the dark, but a shot I'm willing to take. JoshM -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 8:26 PM To: CF-Talk Subject: RE: Database of US Zip Codes Put it in a request-scoped cached query instead and you won't have any locking worries. best, paul At 08:26 AM 3/9/01 +1100, you wrote: 2. Is it good practice to have it as a query in an application.cfm (server or application scope) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Here you have, ;o)
Hi: Check This! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: custom CFERROR pages, what's your solution?
for all your database querys, you can use try/catching - Original Message - From: "Greg Wolfinger" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 26, 2001 11:58 PM Subject: Re: custom CFERROR pages, what's your solution? what i do is create sites with no errors...then i never have to user cferror. Until hackers do a DNS attack on your db and your db server overloads and choaks. - Original Message - From: "Brandon Paolin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 26, 2001 4:30 PM Subject: Re: custom CFERROR pages, what's your solution? what i do is create sites with no errors...then i never have to user cferror. :) - Original Message - From: "Mike Amburn" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 26, 2001 1:22 PM Subject: custom CFERROR pages, what's your solution? using CFERROR, you can create a custom error page. however, you can't perform any CF logic within that page. if you had to include some logic, the only method i can think of is to capture the error data in form inputs and use javascript to submit the form to another page that included the CF. has anyone else thought of a (better) method where you can use CFERROR but also present a page that uses CF logic? -mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: custom CFERROR pages, what's your solution?
what i do is create sites with no errors...then i never have to user cferror. :) - Original Message - From: "Mike Amburn" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 26, 2001 1:22 PM Subject: custom CFERROR pages, what's your solution? using CFERROR, you can create a custom error page. however, you can't perform any CF logic within that page. if you had to include some logic, the only method i can think of is to capture the error data in form inputs and use javascript to submit the form to another page that included the CF. has anyone else thought of a (better) method where you can use CFERROR but also present a page that uses CF logic? -mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFerror and its
you can't execute cf code on error pages. what i do is put all the cfcode in hidden form variables, and onload submit the form to another page that executes the cold fusion and emails me the error code. - Original Message - From: "Andres" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 9:56 AM Subject: CFerror and its Hello all, i have an application.cfm that calls a cf error tag like this: cfapplication name="myapp" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout="#CreateTimeSpan(0, 0, mins_until_timeout, 0)#" cferror type="VALIDATION" template="site_errors.cfm" mailto="[EMAIL PROTECTED]" cfinclude template="variables.cfm" The problem is that when a validation error occurs, the error page appears fine, but the CF inside the error template is not executed... it shown as if it was a regular html page with all the cf showing. can someone tell me why this is happening and how i can correct the problem?? thanks andres ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What Does OT Stand For?
yeah, for example, this message subject should be: OT: What Does OT Stand For? - Original Message - From: "Russel Madere" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 12:08 PM Subject: RE: What Does OT Stand For? In the context of a mailing list or news group, it means Off Topic. Likewise, WOT means Way Off Topic, SOT means Slightly Off Topic, etc. By off topic, the post means he or she does not think it fully matches the purpose of the list (as defined by the charter or FAQ or whatever the creater published). Sometimes an off topic thread can migrate on topic pretty quickly, or like what has often happened, it gets even further off topic until the list gets mad and flames the posters. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 09:32 To: CF-Talk Subject: What Does OT Stand For? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: TimeFormat Function
#lcase(TimeFormat(now(),'tt'))# - Original Message - From: "Phoeun Pha" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 2:08 PM Subject: TimeFormat Function you know the tt mask in the timeformat function? well it always comes out Uppercase. is there a mask that makes it come out lowercase? I was thinking of using string functions to parse out the AM or PM and make them lowercase, but there must be a simpler way! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Regular Expression in CF
Can anyone out there tell me how I can use a regular expression to grab an entire script block? Here is what I am using now: script.*.*|\s/script This works for the following: script language="javascript" src="http://images.foxnews.com/root_js.js"/script However, it won't work if there is anything inside the script blocks. Any help would be greatly appreciated. Thanks, Brandon ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how do I show a range of numbers?
How about this: cfif #variable# GTE 1 OR #variable# LTE 9 Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com/ mailto:[EMAIL PROTECTED] -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 28, 2000 3:02 PM To: CF-Talk Subject: how do I show a range of numbers? For example I have a CFIF statement that looks like this: CFIF #VARIABLE# IS 1 OR #VARIABLE# IS 2 OR #VARIABLE# IS 3 ETC... could I do something like: CFIF #VARIABLE# IS 1-9 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Regular Expression in CF
Can anyone out there tell me how I can use a regular expression to grab an entire script block? Here is what I am using now: script.*.*|\s/script This works for the following: script language="javascript" src="http://images.foxnews.com/root_js.js"/script However, it won't work if there is anything inside the script blocks. Any help would be greatly appreciated. Thanks, Brandon ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: GetTicketCount() - where and when
This is probably what getTicketCount is:The number of milliseconds since January 1, 1970, or somewhere around there. All you have to do is set a variable to its value where you want to start timing. Set another variable to the value again when you want to stop timing. The total number of milliseconds it took is the 2nd time minus the old time. HTH, Brandon Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com 512.236.1517 -Original Message- From: pan [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 2:07 PM To: CF-Talk Subject: Re: GetTicketCount() - where and when From: "Eric Fickes" [EMAIL PROTECTED] Subject: GetTicketCount() - where and when Definition: Returns a millisecond clock counter that can be used for timing sections of CFML code or any other aspects of page processing. 1.This counter is how long it took the CF server to parse the CF code. EG, execution time? 2.Is this for the entire page, or just for code contained in between CFOUTPUT and /CFOUTPUT? Ticks are based on a server counter that runs the lifetime of the current boot. GetTickCount() returns the value of that counter when the func is called - so it's usefulness is in terms of the diff between GetTickCount() calls. It is not precise and is not a diff that equates exactly to x milliseconds of cpu time - however it is close enough. Doesn't take into account "server/network burps" or other things that might pause or delay server ops at the system/network level. Use the diff under the assumption that the machine and network are operating smoothly, is acting on your template with the highest priority and that there are no "burps". It's relaible enough. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java and CF
Java.sun.com Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com 512.236.1517 -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 2:22 PM To: CF-Talk Subject: RE: Java and CF ok, for us dough heads (I'm probably the only one) - where would you, or anyone else, recommend cf developers to start preparing for the new version if they have only ever programmed in CF? je -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 11:18 AM To: CF-Talk Subject: RE: Java and CF The performance comparison Allaire demonstrated at the Conference is not exhaustive, of course, but, for THAT app, Allaire's new Java-based approach out-performed its existing C++-based approach. best, paul At 10:39 AM 12/1/00 -0500, you wrote: There is no WAY a Java server can out perform a *well* *written* C++ server. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Java and CF
Can CF use Java the way it can with Jrun with other application servers? Brandon Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com 512.236.1517 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 9:44 AM To: CF-Talk Cc: '[EMAIL PROTECTED]' Subject: RE: Firewall Question personally, i don't agree with network admins claiming opening security ports is a risk. ports 80 and 25 are almost always open and they offer plenty of risk. the question really is, is the admin knowledgeable enough to control traffic security. companies like checkpoint (they might have been acquired - not sure) make/made great products for securing internet/network traffic. With all due respect, I suspect you're not a network admin! Any time you open a port, it's a risk - it's another thing that has to be watched. There are typically limited resources for what a network administrator can deal with, and no matter what products you buy to help monitor security issues, they still require human guidance and intervention. I've seen enough misconfigured firewalls to know that you can't simply buy hardware and software to solve security issues. The question here is, do the risks outweigh the rewards? From the network admin's point of view, probably not - until someone convinces him otherwise. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get the last 12 months transactions?
Take the current date. Subtract 12 months from it Select all records that are greater than the result Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com 512.236.1517 -Original Message- From: fr me [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 9:59 AM To: CF-Talk Subject: Get the last 12 months transactions? Does anyone know how to test that a date is in the last 12 months? _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
Here are a couple of things. When you get too few parameters, you have messed up your SQL statement: here is where you messed up: Checkedoutby needs single quotes around it like checked out. I don't know if this is mandatory or not, but you might want to switch JobInfoUpload.FileID and #URLFileID# around. Field names come first. HTH Brandon Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com 512.236.1517 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 10:52 AM To: CF-Talk Subject: UPDATE on a MS Access Database Im trying a UPDATE on a Access database, and im getting an error cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC" UPDATE JobInfoUpload SET CheckedOut='Yes', cfoutputCheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID/cfoutput /cfquery Everything is spelled correct, but i get an error below. I have a feeling it has something to do with my Yes/No Column in the database. ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where '48' = JobInfoUpload.FileID" Data Source = "CJM.mdb" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (25:1) to (25:60) in the template file D:\Web\Capitol1interface\chad\checkout.cfm. Date/Time: 11/30/00 11:51:07 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98) Query String: JobId=11LoginID=1FileID=48 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists