RE: New contest open
Your link comes up blank Ray Larry Juncker President & CEO ALJ Computer Services, LLC 1445 So 27th Street Fort Dodge, IA 50501 Office 515-576-0885 Fax 515-576-8510 Cell 515-571-1826 [EMAIL PROTECTED] -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 1:41 PM To: CF-Talk Subject: New contest open (If folks mind messages like this, just please let me know.) For those who do not follow my blog, I recently wrapped up a ColdFusion coding contest for beginners. Today I have announced a new contest for intermediate-level developers. Details may be found here; http://ray.camdenfamily.com/index.cfm/2005/10/30/Intermediate-ColdFusion-Con test The prize for this contest is a fully licensed copy of CFMX Standard, a 1.3k value. The contest will be open over the next two weeks. Good luck. -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda ~| 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:222699 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: cfc ?
Thanks Justin :) couple more ?'s I havent done much with cfc's beyond the typical show, insert, delete, update. ok so first ? is if the method is even correct, this is what i imagine it should be SELECT tbl_email FROM jtbl_mailingList WHERE tbl_email = - on the subscribe page i have a form which submits to itself then checks the existance of the form submission and creates object with form variables second ? is lets say it submits and the email is not found in the db how do i get the error message back to this page and how do i call it? also if the email is found how do i then invoke the unsubscribe() method from the checkSubscription() method? tia again ~Dave the disruptor~ "Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time." From: "Justin D. Scott" <[EMAIL PROTECTED]> Sent: Sunday, October 30, 2005 9:59 PM To: CF-Talk Subject: RE: cfc ? > i cant quite figure this out > what would be the best way to do this There are a couple of options off the top of my head. One would be to create a checkSubscription() method that would return a boolean value depending on whether the e-mail address was subscribed. If it is, call the unsubscribe method. If not, display your error. This is probably the better choice. You can re-use the checkSubscription() method when someone tries to join the list so it will not add a duplicate, for example. The other method would be to use your existing code, but prepend a bit value to the front of your return value. Example: After calling the method, you can check the bit value using listFirst(unSubscriber) to determine if it was successful, and perform whatever action was needed. Then you can listRest(unSubscriber) to display/extract your error message. -Justin Scott ~| 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:222698 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: How to recognize robots
> I for one applaud his efforts and would be very interested in seeing the > code if you don't mind Les One bot loaded this page 15 times before it left! That's 75,000 email addresses it harvested. So, the spammer then uses this list to send spam, and if the network admin of the system being used to send the spam is an alert individual, the returns will quickly show him something is going on and they can find the source and plug it. We'd very much like to thank the following people on our email list for subscribing! -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222697 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 to recognize robots
> I think you're having a weird idea of what the robots are doing. > I certainly do not want to annoy Google's bot or others ;-) No, the page I wrote about is specifically EXCLUDED from the googlebot or any other "friendly" bot. The only bots that ever actually hit it are spam harvestors. -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222696 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: How to recognize robots
I think his point was that good bots such as google will obey his do not crawl command. He is trying to annoy the scumbags who crawl websites to steal email address so they can spam people, these jerks ignore the robots file and love to follow do not follow links. I for one applaud his efforts and would be very interested in seeing the code if you don't mind Les On 10/30/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>I have a page I've been using on a site just to annoy harvester bots. > > I think you're having a weird idea of what the robots are doing. > I certainly do not want to annoy Google's bot or others ;-) > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~| 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:222695 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 to recognize robots
>>I have a page I've been using on a site just to annoy harvester bots. I think you're having a weird idea of what the robots are doing. I certainly do not want to annoy Google's bot or others ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222694 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: Time Block
If you do it the way you're doing it, you're comparing strings, not date objects. You should take the fields you get from the DB and use createDateTime() to create a CF datetime object, then compare that to now() instead of comparing strings. -Justin Scott > I'm trying to implement that solution, comparing today's date > with a date I > have in a database (unfortunately, the DB I inherited has the > date stored > as individual dd, mm, yy, hh, mm, and ss fields). So I create > my date with: > > '#qry.applCloseMonth#/#qry.applCloseDay#/#qry.applCloseYear# > #qry.applCloseHour#:#qry.applCloseMinute#:#qry.applCloseSecond#'> > (again, from individual fields in the DB) > > and then I create thisDate: > > #Hour(Now())#:#Minute(Now())#:#Second(Now())#'> > > and although both dates print exactly the same on the screen, the > comparison between them does not trigger an "earlier that" or > "later than" > behavior (I'm using GTE and LTE). Any suggestions on how to > make it work > (considering how the date is stored in the DB)? > > Thanks in advance, > > Roberto Perez > [EMAIL PROTECTED] ~| 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:222693 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 to recognize robots
I have a page I've been using on a site just to annoy harvester bots. This page is listed in my "robots" file as a "do not crawl" page, which the harvester bots love to visit! The page contains a javascript version of wpoison written by D.K.Merriman. To a bot, the page in question looks like a guest book with thousands of entires. It also generates random links that actually link back to the same page, so once a harvester bot hits the page, it will sit there for ever slurping up bogus email addresses. At the top of the same page, I've included the below that emails me and then I can go see where the little bastard came from: address = #cgi.remote_addr# host = #cgi.remote_host# referer = #cgi.http_referer# agent = #cgi.http_user_agent# page = #cgi.script_name# Damn good fun! -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222692 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: Time Block
At 05:17 PM 10/28/2005, Bobby Hartsfield" wrote: >Even easier, once you have the dates just check to see if now() is > >A) GTE EndDateTime OR LTE StartDateTime >B) GTE StartDateTime AND LTE EndDateTime > >A being true means grant access >B being true means deny access Hey, I'm trying to implement that solution, comparing today's date with a date I have in a database (unfortunately, the DB I inherited has the date stored as individual dd, mm, yy, hh, mm, and ss fields). So I create my date with: (again, from individual fields in the DB) and then I create thisDate: and although both dates print exactly the same on the screen, the comparison between them does not trigger an "earlier that" or "later than" behavior (I'm using GTE and LTE). Any suggestions on how to make it work (considering how the date is stored in the DB)? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~| 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:222691 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: cfc ?
> i cant quite figure this out > what would be the best way to do this There are a couple of options off the top of my head. One would be to create a checkSubscription() method that would return a boolean value depending on whether the e-mail address was subscribed. If it is, call the unsubscribe method. If not, display your error. This is probably the better choice. You can re-use the checkSubscription() method when someone tries to join the list so it will not add a duplicate, for example. The other method would be to use your existing code, but prepend a bit value to the front of your return value. Example: After calling the method, you can check the bit value using listFirst(unSubscriber) to determine if it was successful, and perform whatever action was needed. Then you can listRest(unSubscriber) to display/extract your error message. -Justin Scott ~| 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:222690 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: CFC - best practice - locks and so on
Instantiating the object into the session scope is fine. However, manipulating the session scope from inside the CFC as per: is not recommended. This breaks the encapsulation rules usually associated with CFCs. Consider doing this instead: Create a method that queries the DB and saves the query in a property in the VARIABLES scope. Then have the "getter" method return the VARIABLES scoped query. This has the benefit of keeping the query data in the component instead of having to save it separately in the session scope and makes the thing behave like an object with its own properties. It's when the object has these properties that locking can become more important. One technique that works well for instantiated objects is to use a named lock where a UUID forms the name. Create the UUID as part of the init() method and use it for every lock in the component: . wrote: > Hi all > > I'm looking for comments about cfc instantiation and the best > practices for cflock. ~| 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:222689 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: Philosophy Q: SP's or CFQUERY?
> > the CF page response time went down significantly > > because it no longer had to wait so long for the > > SQL server to process the queries. After re-reading this line I think it may have been confusing. What I meant was that the response time in ms went down, so the pages got a lot faster. > And what about the security factor? I've always been > under the assumption that if your CF only had access > to run SPs you were safer from SQL injection. I would agree with that, but you can be just as safe with inline SQL if you scrub the variables properly. I've seen people scream in horror over a query like this... WHERE id = #url.id# Until I point out... As part of the scrubbing routine. Guarantees a positive integer value, and passes in 0 if it's a string. It's not the best way, but for small sites it's quick, easy, and pretty safe. CFQUERYPARAM would help also. Unfortunately some people are still using access databases, and don't have the luxury of stored procedures. I use SQL Server myself, and sp's where needed. I'm not a zealot one way or the other on what is used. Depends on the situation. -Justin Scott ~| 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:222688 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
cfc ?
i cant quite figure this out what would be the best way to do this If i have a mailing list and the user wants to unsubscribe, I take the the email from the unsubscribe form and invoke the cfc. I can get it to unsubscribe fine but I want to add some code to check too be sure the email is in the db first and if not return an error if it is run the unsubscribe query. the main problem I am getting is the error message back, not quite sure how to display it on unsubscribe page i create the cfc object if the form was submitted in the cfc SELECT tbl_email FROM jtbl_mailingList WHERE tbl_email = UPDATE jtbl_mailingList SETtbl_subscribe = , tbl_unsubscribeDate = , WHEREtbl_email = should i make it 2 different methods? and how do i call the result? tia ~Dave the disruptor~ "Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time." ~| 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:222687 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: Philosophy Q: SP's or CFQUERY?
And what about the security factor? I've always been under the assumption that if your CF only had access to run SPs you were safer from SQL injection. I'd like to hear Neil Robertson-Ravo chime in on this come 8:00 am London time. I didn't know there were so many proponents for inline SQL. I've just always figured MSSQL was better able to run some pre-compiled execution plan in the case of an SP, over ad-hoc SQL queries. Neil? Dave Watts? Greg On 10/30/05, Justin D. Scott <[EMAIL PROTECTED]> wrote: > > > What do you mean "in memory"? > > SQL Server will hold as much of the most accessed data pages as it can in > memory once it's loaded from previous queries. This table gets hit like > crazy, so my guess is that the entire thing is loaded in memory after a > couple of hours. > > > And was your DB running on the same hardware as CF? > > The DB has to do the same work in either case (some > > randomization of a million rows), so the overhead > > of the SP/query should be completely lost in the > > mass of time it'd take to deal with the data. > > Perhaps "ramdom" wasn't the right word. The query isn't pulling "random" > rows, but subsets based on a foreign key. The foreign key that is to be > loaded is not predictable, and there are 10,000+ foreign keys that can be > pulled at any time. > > The problem with having the query come directly from ColdFusion was that > the > query was different for each foreign key, which required the SQL server to > compile a new query plan (which could be thousands of plans that would get > cycled out of memory as new ones were compiled), which took far longer > than > using one plan (from the SP) that was cached. > > Using CFQUERYPARAM on that variable may have helped, but I never tested it > that way. I just went directly from dynamic query to stored procedure and > the CF page response time went down significantly because it no longer had > to wait so long for the SQL server to process the queries. > > Even if I have some of the details wrong, that one change made things go a > WHOLE lot smoother. > > > -Justin Scott > > > ~| 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:222686 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: Philosophy Q: SP's or CFQUERY?
> What do you mean "in memory"? SQL Server will hold as much of the most accessed data pages as it can in memory once it's loaded from previous queries. This table gets hit like crazy, so my guess is that the entire thing is loaded in memory after a couple of hours. > And was your DB running on the same hardware as CF? > The DB has to do the same work in either case (some > randomization of a million rows), so the overhead > of the SP/query should be completely lost in the > mass of time it'd take to deal with the data. Perhaps "ramdom" wasn't the right word. The query isn't pulling "random" rows, but subsets based on a foreign key. The foreign key that is to be loaded is not predictable, and there are 10,000+ foreign keys that can be pulled at any time. The problem with having the query come directly from ColdFusion was that the query was different for each foreign key, which required the SQL server to compile a new query plan (which could be thousands of plans that would get cycled out of memory as new ones were compiled), which took far longer than using one plan (from the SP) that was cached. Using CFQUERYPARAM on that variable may have helped, but I never tested it that way. I just went directly from dynamic query to stored procedure and the CF page response time went down significantly because it no longer had to wait so long for the SQL server to process the queries. Even if I have some of the details wrong, that one change made things go a WHOLE lot smoother. -Justin Scott ~| 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:222685 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: Philosophy Q: SP's or CFQUERY?
What do you mean "in memory"? And was your DB running on the same hardware as CF? The DB has to do the same work in either case (some randomization of a million rows), so the overhead of the SP/query should be completely lost in the mass of time it'd take to deal with the data. cheers, barneyb On 10/30/05, Justin D. Scott <[EMAIL PROTECTED]> wrote: > > You mention SP's will give greater performance. I > > think that may be a myth these days. Google around > > and you will find all sorts of debates on it. I was > > shocked myself after spending a good bit of day > > taking some queries from a CF page and dumping them > > into a shiny new stored proc and things didn't > > improve and actually seemed to slow down some. > > In my experience, it depends on the data you're querying against and how it > is to be used. One example I had was a table with 1,000,000+ rows that had > to have random data pulled out of it about once every 3 to 5 seconds, and > more at peak hours. Even with the proper indexes and the entire table in > memory, the one query being run from ColdFusion with one variable was eating > up 75% of the processor on average, and closer to 90% during peak. > > Converting that one query to a SP and passing the variable to it knocked the > CPU usage on the CF server down to about 5% on average. It really did help > a LOT. If you're working with smaller tables that don't get a lot of > traffic, you probably won't notice much of a difference, if any. > > > -Justin Scott -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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:222684 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: Philosophy Q: SP's or CFQUERY?
> I do agree it depends on situation and I' be curious > to see how it performed in ASP or .NET or some other > language as opposed to CF. Given how much more difficult is it to pass a query from those languages compared to ColdFusion, I think I would be more inclined to call a SP anyway. -Justin Scott ~| 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:222683 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: Philosophy Q: SP's or CFQUERY?
I do agree it depends on situation and I' be curious to see how it performed in ASP or .NET or some other language as opposed to CF. -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 6:48 PM To: CF-Talk Subject: RE: Philosophy Q: SP's or CFQUERY? > You mention SP's will give greater performance. I > think that may be a myth these days. Google around > and you will find all sorts of debates on it. I was > shocked myself after spending a good bit of day > taking some queries from a CF page and dumping them > into a shiny new stored proc and things didn't > improve and actually seemed to slow down some. In my experience, it depends on the data you're querying against and how it is to be used. One example I had was a table with 1,000,000+ rows that had to have random data pulled out of it about once every 3 to 5 seconds, and more at peak hours. Even with the proper indexes and the entire table in memory, the one query being run from ColdFusion with one variable was eating up 75% of the processor on average, and closer to 90% during peak. Converting that one query to a SP and passing the variable to it knocked the CPU usage on the CF server down to about 5% on average. It really did help a LOT. If you're working with smaller tables that don't get a lot of traffic, you probably won't notice much of a difference, if any. -Justin Scott ~| 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:222682 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: Philosophy Q: SP's or CFQUERY?
> You mention SP's will give greater performance. I > think that may be a myth these days. Google around > and you will find all sorts of debates on it. I was > shocked myself after spending a good bit of day > taking some queries from a CF page and dumping them > into a shiny new stored proc and things didn't > improve and actually seemed to slow down some. In my experience, it depends on the data you're querying against and how it is to be used. One example I had was a table with 1,000,000+ rows that had to have random data pulled out of it about once every 3 to 5 seconds, and more at peak hours. Even with the proper indexes and the entire table in memory, the one query being run from ColdFusion with one variable was eating up 75% of the processor on average, and closer to 90% during peak. Converting that one query to a SP and passing the variable to it knocked the CPU usage on the CF server down to about 5% on average. It really did help a LOT. If you're working with smaller tables that don't get a lot of traffic, you probably won't notice much of a difference, if any. -Justin Scott ~| 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:222681 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: Philosophy Q: SP's or CFQUERY?
The performance benefits that SPs bring are based around their ability to act on a query result without having to send the resultset back across the network to CF. I.e. if I have to do two queries and the second depends on the results of the first, an SP will most likely be more performant, because it only requires two network trips, rather than four, and one CF recordset creation, rather than two. This effect obviously increases with the more complex the interactions are, especially if the first recordset would have been large, and isn't needed except for use in the second query. If you just have a simple query, there's not really anything that an SP can do to speed it up that isn't going to happen anyway. And then there's the overhead of calling the SP itself, which doesn't exist in a simple query. cheers, barneyb On 10/30/05, Brian Peddle <[EMAIL PROTECTED]> wrote: > You mention SP's will give greater performance. I think that may be a myth > these days. Google around and you will find all sorts of debates on it. I > was shocked myself after spending a good bit of day taking some queries from > a CF page and dumping them into a shiny new stored proc and things didn't > improve and actually seemed to slow down some. > > Here is one link http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx > but there are many. > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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:222680 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: How to recognize robots
>>The HTTP_User_Agent. Yeah, I should have gessed! ;-) I think, I'll just add the user agent in my stats and work something around it. Are you running CF 7 enterprise or pro? This particular site is still under CF 5 -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:222679 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: How to recognize robots
>>>The good ones identify themselves. > >Ok, and how do they do that? The HTTP_User_Agent. Google and Yahoo will show up with their name in the agent. Others will as well. On the other hand, when you see something that looks like IE but doesn't act like a human would, then it's time to think it may be a bot. >If a series of page requests from the same agent/ip is showing a >different cfid/cftoken per request, then either its a user that does not >support cookies (even session ones) or its a bot. > >Well, actually not really easy to implement ;-/ Are you running CF 7 enterprise or pro? If the former, I've got some code for you for logging that will deal with it nicely. If the latter, I still have some code for you but it's not as 'clean and tight'. >The reason I ask, is that I just implemented some statistics facility on >some of my customers sites. This will count all hits, including those >from robots, so I'd like to be able to discriminates visitors hits from >others. I've been meaning to write an interface to my logs to allow people to download a list of bot agents/ips. Now that the hardware for HoF is moved over I can try to get onto that. (yeh, right). :) ~| 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:222678 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 to recognize robots
>>One way is to use an image in your page that is actually a cfm file. Hmmm, this will also be blocked by some email readers, including my own, and I have some pages sent by email (News letter). -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:222677 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: Philosophy Q: SP's or CFQUERY?
Two simple rules I use are: 1. Is the query results going to be cached by CF (a list of all the mailing lists on a site)? If so, use standard. 2. Is the query results based on a large group of data with many people viewing the data (a day's messages for example) Is so, use SP. Other than that, it all depends on the data, the DB, the available RAM on the SQL server and if I really need to have a SP for the data or not. I hate to say it's a case by case basis, but it is. There are also a few books you can read that deal with the subject really well: SQL Tuning (O'Reilly) http://www.amazon.com/exec/obidos/ASIN/0596005733/houseoffusion SQL Performance Tuning (Addison-Wesley) http://www.amazon.com/exec/obidos/ASIN/0201791692/houseoffusion SQL Server Query Performance Tuning Distilled (Apress) http://www.amazon.com/exec/obidos/ASIN/1590594215 /houseoffusion Microsoft SQL Server 2000 Performance Tuning Technical Reference (Microsoft) http://www.amazon.com/exec/obidos/ASIN/0735612706 /houseoffusion I've always been a fan of the O'Reilly books but the APress ones are looking better and better. Of course, Microsoft wrote SQL 2k, so their book might be worth looking at. :) ~| 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:222676 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 to recognize robots
> The reason I ask, is that I just implemented some statistics facility > on some of my customers sites. This will count all hits, including those > from robots, so I'd like to be able to discriminates visitors hits from > others. One way is to use an image in your page that is actually a cfm file. Use the cfm file to track stats (pass in query string info to specify what page you're looking at). You can use JS to load the image, which will block bots but also drop the fraction of users with JS disabled. Not sure what happens if you embed the image directly. Presumably Google will get counted due to its image search functionality. But perhaps others won't?? ~| 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:222675 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: Philosophy Q: SP's or CFQUERY?
You mention SP's will give greater performance. I think that may be a myth these days. Google around and you will find all sorts of debates on it. I was shocked myself after spending a good bit of day taking some queries from a CF page and dumping them into a shiny new stored proc and things didn't improve and actually seemed to slow down some. Here is one link http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx but there are many. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Saturday, October 29, 2005 1:16 PM To: CF-Talk Subject: Philosophy Q: SP's or CFQUERY? I'm going back and tweaking a web app that I'm building and have learned a few stored procedure tricks (my SP skills were pretty basic before I started to play around). As a result, I'm replacing a number of CF queries (using cfqueryparam) with SQL Server stored procedures. Now, these are pretty much limited to the customer-facing (non-admin) pages, though I'm using SP's in the admin where I already have them written to return the rest sets that I need. Realizing that SP's will give greater performance, the question is this: Is it OK to write your most frequently run queries as SP's and leave the rest of the site as straight SQL queries? Or should I just make the entire site SP's? What I've been doing during development is writing straight SQL until I get what I need, then I rewrite as a SP. I've replaced a dozen or so queries that are all on the customer-facing end of things, but there are well over 100 queries still written as SQL on the admin side, and it would take a bit of effort to convert (or merge into existing SP's) those queries. Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222674 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: How to recognize robots
There are user agent lists out there http://www.psychedelix.com/agents1.html for example. You could run a report later and go against a table of useragents -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 5:15 PM To: CF-Talk Subject: Re: How to recognize robots >>The good ones identify themselves. Ok, and how do they do that? If a series of page requests from the same agent/ip is showing a different cfid/cftoken per request, then either its a user that does not support cookies (even session ones) or its a bot. Well, actually not really easy to implement ;-/ The reason I ask, is that I just implemented some statistics facility on some of my customers sites. This will count all hits, including those from robots, so I'd like to be able to discriminates visitors hits from others. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:222673 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 to recognize robots
>>The good ones identify themselves. Ok, and how do they do that? If a series of page requests from the same agent/ip is showing a different cfid/cftoken per request, then either its a user that does not support cookies (even session ones) or its a bot. Well, actually not really easy to implement ;-/ The reason I ask, is that I just implemented some statistics facility on some of my customers sites. This will count all hits, including those from robots, so I'd like to be able to discriminates visitors hits from others. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222672 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 to recognize robots
The good ones identify themselves. The bad ones can be tracked by logging every page request while setting a cfid/cftoken. If a series of page requests from the same agent/ip is showing a different cfid/cftoken per request, then either its a user that does not support cookies (even session ones) or its a bot. There are other ways as well including hidden pages that real people would never visit and the like, but the one above is the method I use and it works rather well. >Has any one a trick to detect and identify robots and search engine >visiting CF pages? ~| 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:222671 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: MySQL DSN
Can you post any errors you get from CF/MySQL -- also any errors in the CF logs? --- Josh Trefethen Exciteworks, Inc http://exciteworks.com Expert Reseller Hosting On 10/28/05, Snake <[EMAIL PROTECTED]> wrote: > > MySQL 4.1.13 > > I dunno what the grant statement was as I use HELM or MySQL Administrator > to > create the databases. > But I have the same MySQL 4.1.13 on another server which works fine with > CFMX7. > > Russ > > -Original Message- > From: Damien McKenna [mailto:[EMAIL PROTECTED] > Sent: 28 October 2005 16:14 > To: CF-Talk > Subject: RE: MySQL DSN > > > -Original Message- > > From: Snake [mailto:[EMAIL PROTECTED] > > > > Create a MySQL DSN, put the username password into the DSN and it > > works fine. Pass the username/password in the code and it doesn't > > work. > > Which version of MySQL? What was the GRANT statement used to give > permissions to the user? > > -- > Damien McKenna - Web Developer - [EMAIL PROTECTED] The > Limu > Company - http://www.thelimucompany.com/ - 407-804-1014 #include < > stdjoke.h> > > > > ~| 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:222670 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
How to recognize robots
Has any one a trick to detect and identify robots and search engine visiting CF pages? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:222669 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: Philosophy Q: SP's or CFQUERY?
I went through the route of inline SQL, then to SPs, and now I'm back to inline SQL. (When I say "inline", I mean anything other than SPs.) We use many related DBs on our SQL Server. Many queries require joins across DBs. SPs caused us all kinds of problems when we moved DBs from one server to another. I decided it was best to just leave the SQL statements in the application server and not try to create SPs. The real plan is to put most, if not all, SQL statements within CFCs thereby creating some sort of encapsulation. SPs are great in the fact that you can return multiple recordsets at once. I miss that feature, but not enough to use them again. If you desire using SPs, then I would say you are doing it the right way of creating your SQL statements then converting them to SPs once you have them tied down. M!ke -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Saturday, October 29, 2005 12:16 PM To: CF-Talk Subject: Philosophy Q: SP's or CFQUERY? I'm going back and tweaking a web app that I'm building and have learned a few stored procedure tricks (my SP skills were pretty basic before I started to play around). As a result, I'm replacing a number of CF queries (using cfqueryparam) with SQL Server stored procedures. Now, these are pretty much limited to the customer-facing (non-admin) pages, though I'm using SP's in the admin where I already have them written to return the rest sets that I need. Realizing that SP's will give greater performance, the question is this: Is it OK to write your most frequently run queries as SP's and leave the rest of the site as straight SQL queries? Or should I just make the entire site SP's? What I've been doing during development is writing straight SQL until I get what I need, then I rewrite as a SP. I've replaced a dozen or so queries that are all on the customer-facing end of things, but there are well over 100 queries still written as SQL on the admin side, and it would take a bit of effort to convert (or merge into existing SP's) those queries. Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222668 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
New contest open
(If folks mind messages like this, just please let me know.) For those who do not follow my blog, I recently wrapped up a ColdFusion coding contest for beginners. Today I have announced a new contest for intermediate-level developers. Details may be found here; http://ray.camdenfamily.com/index.cfm/2005/10/30/Intermediate-ColdFusion-Contest The prize for this contest is a fully licensed copy of CFMX Standard, a 1.3k value. The contest will be open over the next two weeks. Good luck. -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda ~| 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:222667 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: OT: CSS editor for Eclipse
I cant seem to get it to do anything for me except open a CSS file. Am I missing some thing or maybe some thing I need to configure? I'm still new to Eclipse so who know what I may be doing wrong. On 10/30/05, Barney Boisvert <[EMAIL PROTECTED]> wrote: > check csseditor.sourceforge.net > > I haven't used it in a while (prefering the one included in > MyEclipse), but it used to, and it worked well enough. > > cheers, > barneyb > > On 10/30/05, Phill B <[EMAIL PROTECTED]> wrote: > > Is there a good CSS editor for Eclipse? I downloaded one and all it > > seemed to do was set Eclipse to be the default editor of css files. > > > > -- > > Phil ~| 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:222666 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: SHOUTING
Nifty. As further suggestions: You might save metrics on this but not do anything at all at first. That way you could later go through and examine the messages occurring at certain percentages and determine a good cut-off point. You might also just find that your problem focuses on a very small number of distinct people - smack them in line and you don't have to do anything. ;^) You might then just keep an eye on the statistics and warn people as needed. You might also take the decision out of your hands by just warning people on post. Look at the message before it's submitted and present a warning ("Your message is 95% capital letters. If you're shouting, please don't shout.") You can use the metrics collected (a simple log of messages which got the warning would do) to check on how people are doing (are they honoring the warning or not?) For example sometimes we do shout. Something like "I've tried SCSI, IDE and SATA and NOTHING WORKS! Please HELP ME!" might be forgiven. ;^) Letting people know you're watching something can often curtail the behavior even if you've no actual recourse for punishing the behavior. Jim Davis ~| 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:222665 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: SHOUTING
This one returns the percentage of the string that is uppercase. The string explains my enthusiasm. ;) function ucasePercentage(str) { ucount = 0; ufinder = refind("[A-Z]", str); while (ufinder neq 0) { ucount = ucount + 1; ufinder = refind("[A-Z]", str, ufinder+1); } return round((ucount / len(str)) * 100); } #ucasePercentage(strng)#% of this string is made up of uppercase characters. So now you can come up with what percentage of the string you want to allow as uppercase and just check to see if #ucasePercentage(string)# is less than that number. I don't know what kind of posts your users are making but be aware that something like 'LOL' is 100% uppercase and probably legit. You may also consider only checking for the uppercase percentage once the string is longer than a specific number. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 12:40 PM To: CF-Talk Subject: RE: SHOUTING Here ya go... function ucasecount(str) { ucount = 0; ufinder = refind("[A-Z]", str); while (ufinder neq 0) { ucount = ucount + 1; ufinder = refind("[A-Z]", str, ufinder+1); } return ucount; } #ucasecount(strng)# The function returns a single numeric value. It's the number of uppercase characters found in the string. (In the example string... 5). You could easily add more to it such as getting the actual percent of uppercase characters that the number represents but the easiest way would be to just see if it's more than half the characters and do what you need to do. Example: The string is #len(strng)# characters long. Out of those #len(strng)# characters, #ucasecount(strng)# characters are uppercase. Are there too many uppercase characters? #tooMnayUC# ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.6/151 - Release Date: 10/28/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222664 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: SHOUTING
Here ya go... function ucasecount(str) { ucount = 0; ufinder = refind("[A-Z]", str); while (ufinder neq 0) { ucount = ucount + 1; ufinder = refind("[A-Z]", str, ufinder+1); } return ucount; } #ucasecount(strng)# The function returns a single numeric value. It's the number of uppercase characters found in the string. (In the example string... 5). You could easily add more to it such as getting the actual percent of uppercase characters that the number represents but the easiest way would be to just see if it's more than half the characters and do what you need to do. Example: The string is #len(strng)# characters long. Out of those #len(strng)# characters, #ucasecount(strng)# characters are uppercase. Are there too many uppercase characters? #tooMnayUC# ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 11:38 AM To: CF-Talk Subject: RE: SHOUTING > Maybe the Lcase function? I dont believe thats what the lcase function does ;) Just compare the strings uppercase form to its original form... Eg: find(ucase(str), str) It will return 1 if the string is all uppercase, 0 if it is not... Of course... one lowercase letter in the middle of 1 uppercase letters is not all uppercase though :) You could easily write a looping function to count the number of uppercase characters and compare that with the over all length of the string. Then you could base your decision to allow/disallow the string on the percentage of upper case characters vs lower case Steps: Loop over the string while #refind("[A-Z]", str, start)#. Each time #start# will be the results of the refind()and a counter would be incremented by 1 (the counter will hold the number of uppercase characters in the end) I've gotta run or I'd test out some actual code for you here. I'll be glad to do I later if you want something like this but have trouble writing it. Cheers ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Webmaster at FastTrack On Line [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 1:12 AM To: CF-Talk Subject: Re: SHOUTING Maybe the Lcase function? Jenny - Original Message - From: "Saturday (Stuart Kidd)" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, October 24, 2005 6:02 PM Subject: stop: SHOUTING > Hi guys, > > Just wondering if anyone knows a good way to recognise when all the > characters are capitalised? Some users love putting text in CAPS and > it just looks awful when it's displayed on screen. > > Any help I'd be grateful. > > Thanks, > > Saturday > > > ~| 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:222663 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
CFC - best practice - locks and so on
Hi all I'm looking for comments about cfc instantiation and the best practices for cflock. Please look this code used in my application. When user enters in application i call a cfc. In application.cfm: ---BEGIN application.cfm--- several cfset with session variables related to all SELECT queries in cfc -END application.cfm-- In app.cfc: ---BEGIN app.cfc--- arguments list SELECT FROM Products several CRUD operations END app.cfc- - This(using cfc in session scope) is a best practice? - Need cflock? Where? - It's possible to optimize this application? How? Any help will be very appreciated. Cheers MD ~| 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:222662 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: WAY OT: Configuring FCKEditor
Hi Jenny: Sorry for the delayed reply. Yeah, I was having a devil of a time, too. This entry on Brian Rinaldi's Blog got me started. http://tinyurl.com/cw7m8 After that it was trial & error (& error & error...). Best of Luck!!! ~| 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:222661 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: Philosophy Q: SP's or CFQUERY?
I'd use them only where there is a proven necessity. I.e. where the performance gains (demonstrated by load testing) are worth the trouble, or the security concerns are such that there's no other way. SPs move your business logic out of your application and into the database, which isn't necessarily a bad thing, but it does split the code, which can make maintenance harder. Careful design can mitigate most of that concern, of course, but it's still added complexity that shouldn't be brought on yourself for no good reason. Single queries, in particular, ought never to be converted to SPs unless it's a security concern, if you ask me. The performance isn't going to be any greater, since you still have to pass the recordset back to CF and let it create a CF query object. cheers, barneyb On 10/29/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > I'm going back and tweaking a web app that I'm building and have > learned a few stored procedure tricks (my SP skills were pretty basic > before I started to play around). As a result, I'm replacing a number > of CF queries (using cfqueryparam) with SQL Server stored procedures. > Now, these are pretty much limited to the customer-facing (non-admin) > pages, though I'm using SP's in the admin where I already have them > written to return the rest sets that I need. > > Realizing that SP's will give greater performance, the question is > this: Is it OK to write your most frequently run queries as SP's and > leave the rest of the site as straight SQL queries? Or should I just > make the entire site SP's? > > What I've been doing during development is writing straight SQL until > I get what I need, then I rewrite as a SP. I've replaced a dozen or > so queries that are all on the customer-facing end of things, but > there are well over 100 queries still written as SQL on the admin > side, and it would take a bit of effort to convert (or merge into > existing SP's) those queries. > > Pete > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: CSS editor for Eclipse
check csseditor.sourceforge.net I haven't used it in a while (prefering the one included in MyEclipse), but it used to, and it worked well enough. cheers, barneyb On 10/30/05, Phill B <[EMAIL PROTECTED]> wrote: > Is there a good CSS editor for Eclipse? I downloaded one and all it > seemed to do was set Eclipse to be the default editor of css files. > > -- > Phil -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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:222659 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: Unusual Image Rotation Request
I'm not saying build your own pixel rewriter. I'm saying that most tools only expose multiples of 90 because that's good enough 99.999% of the time. Pretty much any tool is going to be build on top of a graphics library of some sort, and I've yet to see such a library that doesn't support arbitrary rotation angles. So it'd just be a matter of making the CFC or CF/CFX tag leverage that capability. For example, Alagad Image Component uses the Java 2D libraries, which certainly support arbitrary rotation, though I don't know if AIC exposes it. If it's not there, adding it would be trivial. I suspect that many (most?) other tools work in similar fashion. cheers, barneyb On 10/30/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>adding arbitrary rotation angles would be pretty trvial > to your choice of image manipulators, as long as you can get the > source. > > I wouldn't say so: rotation by an angle being a multiple of 90º is > pretty trivial, because the transformation can be reduced to some > symetry. All pixels are preserved, and no new pixel has to be created. > Any angle rotation is quite a different and more complex algorithm, this > is why most tools provide only 90º rotations. > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222658 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: SHOUTING
> Maybe the Lcase function? I dont believe thats what the lcase function does ;) Just compare the strings uppercase form to its original form... Eg: find(ucase(str), str) It will return 1 if the string is all uppercase, 0 if it is not... Of course... one lowercase letter in the middle of 1 uppercase letters is not all uppercase though :) You could easily write a looping function to count the number of uppercase characters and compare that with the over all length of the string. Then you could base your decision to allow/disallow the string on the percentage of upper case characters vs lower case Steps: Loop over the string while #refind("[A-Z]", str, start)#. Each time #start# will be the results of the refind()and a counter would be incremented by 1 (the counter will hold the number of uppercase characters in the end) I've gotta run or I'd test out some actual code for you here. I'll be glad to do I later if you want something like this but have trouble writing it. Cheers ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Webmaster at FastTrack On Line [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 1:12 AM To: CF-Talk Subject: Re: SHOUTING Maybe the Lcase function? Jenny - Original Message - From: "Saturday (Stuart Kidd)" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, October 24, 2005 6:02 PM Subject: stop: SHOUTING > Hi guys, > > Just wondering if anyone knows a good way to recognise when all the > characters are capitalised? Some users love putting text in CAPS and > it just looks awful when it's displayed on screen. > > Any help I'd be grateful. > > Thanks, > > Saturday > > > ~| 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:222657 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: CSS editor for Eclipse
Is there a good CSS editor for Eclipse? I downloaded one and all it seemed to do was set Eclipse to be the default editor of css files. -- Phil ~| 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:222656 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: Unusual Image Rotation Request
>>adding arbitrary rotation angles would be pretty trvial to your choice of image manipulators, as long as you can get the source. I wouldn't say so: rotation by an angle being a multiple of 90º is pretty trivial, because the transformation can be reduced to some symetry. All pixels are preserved, and no new pixel has to be created. Any angle rotation is quite a different and more complex algorithm, this is why most tools provide only 90º rotations. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:222655 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: debugging complaint
actually cfdump is just a regular custom tag, altho it is encrypted. But you could effectively replace it. Russ On 10/28/05, Ryan Guill <[EMAIL PROTECTED]> wrote: > hey ray, somewhat on and off topic, > > do you know if it is possible to modify the cfdump structure? > particularly the stylesheet. I had a developer ping me the other day > about the cfdump stylesheet color specifications did not use pound > signs, something like color: 336633; > > He said it was using a browser that wasn't liking it or something. As > far as I can tell there is no way, thats an innerds of cf thing, but > just wondered if you knew if it was possible. > > On 10/28/05, Raymond Camden <[EMAIL PROTECTED]> wrote: > > Something else to consider. My starfish project handles debugging > > info, stuff like the time it took to do X. It does NOT handle erorrs. > > > > However... > > > > It IS possible to modify error behaviour. I've written to blog entries on this. > > > > This entry: > > http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modi > > fications > > > > Tells you how ot make stack traces collapse in Firefox, like they do in IE. > > > > This entry: > > http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception- > > Templates-in-CFMX-701 Will make it so if you use a struct key that > > doesn't exist, the error will tell you which keys _do_ exist in the > > struct, which is VERY helpful. Ie, instead of, you can't do foo.goo, > > you get, you can't do foo.goo, but moo and zoo are valid keys. > > > > This is ALL something you do NOT want to do on a production server, > > but it may be of use to you. > > > > > > On 10/28/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > Some good points Jim,...thanks...good points to ponder for sure.. > > > > > > Bryan Stevenson B.Comm. > > > VP & Director of E-Commerce Development Electric Edge Systems > > > Group Inc. > > > phone: 250.480.0642 > > > fax: 250.480.1264 > > > cell: 250.920.8830 > > > e-mail: [EMAIL PROTECTED] > > > web: www.electricedgesystems.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:222654 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: debugging complaint
Others have already answered, but another idea is to just write your own cfdump. It wouldn't be too hard. :) Another idea - write a custom tag that calls cfdump and all your tag does is a regex on the result of cfdump - ie - a wrapper. Just some random ideas.:) On 10/28/05, Ryan Guill <[EMAIL PROTECTED]> wrote: > hey ray, somewhat on and off topic, > > do you know if it is possible to modify the cfdump structure? > particularly the stylesheet. I had a developer ping me the other day > about the cfdump stylesheet color specifications did not use pound > signs, something like color: 336633; > > He said it was using a browser that wasn't liking it or something. As > far as I can tell there is no way, thats an innerds of cf thing, but > just wondered if you knew if it was possible. > > On 10/28/05, Raymond Camden <[EMAIL PROTECTED]> wrote: > > Something else to consider. My starfish project handles debugging > > info, stuff like the time it took to do X. It does NOT handle erorrs. > > > > However... > > > > It IS possible to modify error behaviour. I've written to blog entries on > > this. > > > > This entry: > > http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modifications > > > > Tells you how ot make stack traces collapse in Firefox, like they do in IE. > > > > This entry: > > http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception-Templates-in-CFMX-701 > > Will make it so if you use a struct key that doesn't exist, the error > > will tell you which keys _do_ exist in the struct, which is VERY > > helpful. Ie, instead of, you can't do foo.goo, you get, you can't do > > foo.goo, but moo and zoo are valid keys. > > > > This is ALL something you do NOT want to do on a production server, > > but it may be of use to you. > > > > > > On 10/28/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > Some good points Jim,...thanks...good points to ponder for sure.. > > > > > > Bryan Stevenson B.Comm. > > > VP & Director of E-Commerce Development > > > Electric Edge Systems Group Inc. > > > phone: 250.480.0642 > > > fax: 250.480.1264 > > > cell: 250.920.8830 > > > e-mail: [EMAIL PROTECTED] > > > web: www.electricedgesystems.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:222653 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: cfcdev list status
Just an FYI, I'm running a queue cleaner and it is still in progress. I've disabled the list for now. There are still messages in the outgoing queue, so more will come out, but it should be over soon. Sorry for the trouble folks. I was going to open a ticket with MailEnable, but they don't have a free support option - lovely. On 10/29/05, Raymond Camden <[EMAIL PROTECTED]> wrote: > (Forgive the OT msg) > > I am aware of the "bombing" that has been going on the CFCDev list. I > am not sure why it is happening though. It looks like the email > addresses that are no longer valid are having their failure notices > showing up on list. That should not happen, of course. I am manually > cleaning these people out when I can. I am going to open a ticket with > MailEnable since it also appears we may have hit the max number of > people for a mailing list, and obviously I want the list to grow. > > However - I need to be away for most of today. So unfortunately I > can't do anything else right now. I deeply apologize for any trouble > this causes (boy do I love being an admin of a service ;) and I hope > to have things cleared away tonight. > -- > === > Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) > > Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) > > Email: [EMAIL PROTECTED] > Blog : ray.camdenfamily.com > Yahoo IM : cfjedimaster > > "My ally is the Force, and a powerful ally it is." - Yoda > -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda ~| 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:222652 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: WAY OT: Configuring FCKEditor
Hi Jay, I'm having a real headache with this fck config, do you have any install notes I could take a look at please? I've got it all working but the graphics upload :-S Thanks, Jenny - Original Message - From: "Jay Greer" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, October 28, 2005 6:39 PM Subject: Re: WAY OT: Configuring FCKEditor > (for versiion 2.1.1) > > /FCKEditor/editor/filemanager/browser/default/connectors/cfm/config.cfm > > Lines 9 & 11 > > Good Luck! > > ~| 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:222651 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 would I send an XML file to another server/application?
Wow, thank you guys so much. I was not sure about the cfhttp thing. Much Much appreciated! - Ian On 10/27/05, Anthony Prato <[EMAIL PROTECTED]> wrote: > I had a client who could not figure out how to send and xml post like > Andy's example. On my recieving page I put this code to allow them to > post as a named form field or an xml post. > > > > > > > > > ~| 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:222650 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
Philosophy Q: SP's or CFQUERY?
I'm going back and tweaking a web app that I'm building and have learned a few stored procedure tricks (my SP skills were pretty basic before I started to play around). As a result, I'm replacing a number of CF queries (using cfqueryparam) with SQL Server stored procedures. Now, these are pretty much limited to the customer-facing (non-admin) pages, though I'm using SP's in the admin where I already have them written to return the rest sets that I need. Realizing that SP's will give greater performance, the question is this: Is it OK to write your most frequently run queries as SP's and leave the rest of the site as straight SQL queries? Or should I just make the entire site SP's? What I've been doing during development is writing straight SQL until I get what I need, then I rewrite as a SP. I've replaced a dozen or so queries that are all on the customer-facing end of things, but there are well over 100 queries still written as SQL on the admin side, and it would take a bit of effort to convert (or merge into existing SP's) those queries. Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222649 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: Problem in a Simple webservice: 1D array works 2D fails
You may want to look at using custom types. http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?href=1549.htm I was working on something similar and in research it seemed as if custom types would fix it for me. That portion of the app hasn't been created yet so I can't say yay or nay. On 10/28/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > >Thanks to everyone else for suggesting other data structures that work. I > >did some testing and there is no problem with Structs of Structs and > other > >combinations, but the designer wants as simple and portable a solution as > >possible, so it's back to see what I can do to make the 2D Array work. > > I don't know how it can get any simpler than a struct of structs. > > Will > > ~| 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:222648 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
cfcdev list status
(Forgive the OT msg) I am aware of the "bombing" that has been going on the CFCDev list. I am not sure why it is happening though. It looks like the email addresses that are no longer valid are having their failure notices showing up on list. That should not happen, of course. I am manually cleaning these people out when I can. I am going to open a ticket with MailEnable since it also appears we may have hit the max number of people for a mailing list, and obviously I want the list to grow. However - I need to be away for most of today. So unfortunately I can't do anything else right now. I deeply apologize for any trouble this causes (boy do I love being an admin of a service ;) and I hope to have things cleared away tonight. -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda ~| 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:222647 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: Big Honking Queries Make Me Want To Scream
One technique to use for complex joins is to build the joins in views. (I rarely use a join in a cfquery) By using views, the execution plan for the join is stored with the view and does not have to calculated with the dynamic SQL in a cfquery. By using views for joins, it allows focusing on the results of the joins before adding other conditions. For example: CREATE VIEW dbo.vShowDetail AS SELECT P.FNname, P.LName, C.CreditType, S.Title, S.Network, S.[Desc], SM.SubjectType, S.Logline FROM dbo.tCredits C INNER JOIN dbo.tPlayers P ON C.PlayerID = P.PlayerID INNER JOIN dbo.tShows S ON C.ShowID = S.ShowID INNER JOIN dbo.tSubjectMatter SM ON S.ShowID = SM.ShowID ORDER BY P.LName Then the cfquery is simpler SELECT TOP 100 PERCENT FNname, LName, CreditType, Title, Network, Logline FROM dbo.vShowDetail WHERE (Network = 'A') AND (Title = 'B') AND (CreditType = 'C') At 05:27 PM 10/28/2005, you wrote: >Try the ColdFusion MX Bible it has some very good chapters SQL > > >> Is there a damned good book/tutorial somewhere on writing these things? > > > >"Using Complex SQL Statements in Coldfusion for Idiots" ?? > > > >-- > >--- > >Les Mizzell > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222646 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT - Complex SQL
Jillian, If you're using DB2 UDB, you can use the date() function to pass in your date: where table_1.expiry_date = date('2005-12-31') ... Dina On 10/28/05, Dawson, Michael <[EMAIL PROTECTED]> wrote: > > Along these lines, you might want to look into DB2's data dictionary. > On our AS400, you can find the data dictionary in the qsys2 libraries. > Look for a table named "syscolumns". That table will give you the > details on any column in the database. > > I created a simple DB2 datadictionary view a few years ago and it comes > in quite handy. > > M!ke > > -Original Message- > From: Jillian Koskie [mailto:[EMAIL PROTECTED] > Sent: Friday, October 28, 2005 5:41 PM > To: CF-Talk > Subject: RE: OT - Complex SQL > > You're so right... Anybody happen to now offhand (I'm off to search > after I send this message) what the date format is for DB2? > > I'm just running this at the command line, so no need for any CF > stuffs... But unfortuantely also can't take advantage of CF stuffs. > > -Original Message- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Friday, October 28, 2005 4:16 PM > To: CF-Talk > Subject: RE: OT - Complex SQL > > You need single quotes around "each" of your values in the "IN" clause. > > > AND table_1.table_id IN ('value1','value2','value3') > > The date formats may be wrong, too. Check the actual data in the > database and/or use createODBCDateTime() and definitely use > CFQUERYPARAM. It will make your job a bit eaiser. > > Either way, I would remove the dates from your WHERE claus, fix the IN > clause, then run the query. See if you get any results with very > limited filtering, first. > > Then, go from there and add more filtering as needed. > > M!ke > > -Original Message- > From: Jillian Koskie [mailto:[EMAIL PROTECTED] > Sent: Friday, October 28, 2005 5:12 PM > To: CF-Talk > Subject: OT - Complex SQL > > Okay, I think it's because it is Friday at 4... can somebody help me > out? > > SELECT table_1.expiry_date, > table_3.expiry_date > FROM table_3 > JOIN table_2 ON table_2.table2_key = table_3.tablel2_key > JOIN table_1 ON table_1.table1_key = table_2.table1_key > WHERE table_1.expiry_date = 'Dec 31, 2005' > AND table_3.expiry_date = 'Dec 31, 2005' > AND table_1.table_id IN ('value1,value2,value3') > > This isn't returning results, and it should... where is my syntax > incorrect? > > -- > Jillian > > > > > > ~| 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:222645 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: SHOUTING
Maybe the Lcase function? Jenny - Original Message - From: "Saturday (Stuart Kidd)" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, October 24, 2005 6:02 PM Subject: stop: SHOUTING > Hi guys, > > Just wondering if anyone knows a good way to recognise when all the > characters are capitalised? Some users love putting text in CAPS and > it just looks awful when it's displayed on screen. > > Any help I'd be grateful. > > Thanks, > > Saturday > > > ~| 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:222644 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: Big Honking Queries Make Me Want To Scream
AFternoon, OK, here's what is working: 1. All form fields are from drop-down lists 2. cfif statements to account for the fact that you can decide *not* to choose anything ("xox" is the default value) Is there a better way to refine this? SELECT Shows.Title, Credits.PlayerID, Players.FName, Players.LName, Shows.Network, Credits.ShowID, Shows.Genre FROM Shows INNER JOIN Credits ON (Shows.ShowID = Credits.ShowID) INNER JOIN Players ON (Credits.PlayerID = Players.PlayerID) WHERE Credits.CreditType like '%#form.credittype#%' AND Shows.Network ='#form.network#' AND Shows.Category = '#form.category#' AND Shows.genre like '%#form.genre#%' Order by LName -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222643 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: debugging complaint
Why not just do that dynamically. -- Snake -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 28 October 2005 23:57 To: CF-Talk Subject: Re: debugging complaint i've seen where doctypes will remove all colors from a cfdump (border colors and background colors), rendering it highly ineffective. removing the doctype declaration normally fixes this for me. (of course, it goes back in prior to going to production) :) On 10/28/05, Ryan Guill <[EMAIL PROTECTED]> wrote: > hey ray, somewhat on and off topic, > > do you know if it is possible to modify the cfdump structure? > particularly the stylesheet. I had a developer ping me the other day > about the cfdump stylesheet color specifications did not use pound > signs, something like color: 336633; > > He said it was using a browser that wasn't liking it or something. As > far as I can tell there is no way, thats an innerds of cf thing, but > just wondered if you knew if it was possible. > > On 10/28/05, Raymond Camden <[EMAIL PROTECTED]> wrote: > > Something else to consider. My starfish project handles debugging > > info, stuff like the time it took to do X. It does NOT handle erorrs. > > > > However... > > > > It IS possible to modify error behaviour. I've written to blog entries on this. > > > > This entry: > > http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modi > > fications > > > > Tells you how ot make stack traces collapse in Firefox, like they do in IE. > > > > This entry: > > http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception- > > Templates-in-CFMX-701 Will make it so if you use a struct key that > > doesn't exist, the error will tell you which keys _do_ exist in the > > struct, which is VERY helpful. Ie, instead of, you can't do foo.goo, > > you get, you can't do foo.goo, but moo and zoo are valid keys. > > > > This is ALL something you do NOT want to do on a production server, > > but it may be of use to you. > > > > > > On 10/28/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > Some good points Jim,...thanks...good points to ponder for sure.. > > > > > > Bryan Stevenson B.Comm. > > > VP & Director of E-Commerce Development Electric Edge Systems > > > Group Inc. > > > phone: 250.480.0642 > > > fax: 250.480.1264 > > > cell: 250.920.8830 > > > e-mail: [EMAIL PROTECTED] > > > web: www.electricedgesystems.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:222642 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