Re: blocking spambots
On Tuesday 20 Nov 2007, Todd wrote: Somewhere in the world, someone has a random email address that someone thinks is fake and is wondering why the hell he's getting more spam. ;) One hopes a .local TLD was used, or a domain with an MX that points at a spam reporting service... -- Tom Chiverton Helping to assertively streamline holistic design-patterns on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JRun Updater 7 500 Java bean field access exception
I receive this error in the CF Admin Verity Collections section: 500 Java bean field access exception My CF version is 7.0.2 (multiserver) on JRun Updater 7 (JVM 1.6.0_2). My OS version is Win2003 (32bit). I found a solution for this problem in Steven Erats blog (not tested yet): http://www.talkingtree.com/blog/index.cfm/2006/12/13/CFMX7-Verity-Java6 But: The Jrun Updater 7 Release Notes mentions that JVM 1.6 is supported. So is this a bug in the updater or do I miss something obvious? -- Harry Klein | Konzeption und Entwicklung CONTENS Software GmbH Oettingenstr. 25 | 80538 München Fon: +49 (0)89 5199 69-0 | Fax: +49 (0)89 5199 69-78 mailto:[EMAIL PROTECTED] | http://www.contens.de Sitz der Gesellschaft: München Geschäftsführer: Jens Hoppe Amtsgericht München, HRB 128 273 ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun Updater 7 500 Java bean field access exception
CF 7.0.2 isn't supported on Java 6, is it? On Nov 21, 2007 6:55 PM, Harry Klein [EMAIL PROTECTED] wrote: I receive this error in the CF Admin Verity Collections section: 500 Java bean field access exception My CF version is 7.0.2 (multiserver) on JRun Updater 7 (JVM 1.6.0_2). My OS version is Win2003 (32bit). I found a solution for this problem in Steven Erats blog (not tested yet): http://www.talkingtree.com/blog/index.cfm/2006/12/13/CFMX7-Verity-Java6 But: The Jrun Updater 7 Release Notes mentions that JVM 1.6 is supported. So is this a bug in the updater or do I miss something obvious? -- Harry Klein | Konzeption und Entwicklung CONTENS Software GmbH Oettingenstr. 25 | 80538 München Fon: +49 (0)89 5199 69-0 | Fax: +49 (0)89 5199 69-78 mailto:[EMAIL PROTECTED] | http://www.contens.de Sitz der Gesellschaft: München Geschäftsführer: Jens Hoppe Amtsgericht München, HRB 128 273 ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun Updater 7 500 Java bean field access exception
Harry Klein wrote: I receive this error in the CF Admin Verity Collections section: 500 Java bean field access exception My CF version is 7.0.2 (multiserver) on JRun Updater 7 (JVM 1.6.0_2). But: The Jrun Updater 7 Release Notes mentions that JVM 1.6 is supported. It is supported by JRun, not by any CF version prior to 8. Jochem ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problems with submit
Hi Folks, Using CF8: I have a results entry form and if the user hits submit more than once the result is submitted more than once, how would I stop the user being able to submit more than once.. Yes I know a real newbie question :) Thanks for any feedback you can give. You can do this with Javascript or if you're using CF7 or later you can do this with cfinput. Here's a short discussion of 2 approaches: http://www.coldfusioncookbook.com/entry/25/How-do-you-stop-users-from-clicking-the-submit-button-more-than-once? Here's what I usually do: INPUT TYPE=Button VALUE=Submit onClick=if(this.value == 'Submit') this.form.submit(); this.value = 'Please Wait.';this.disabled=true; hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLDAP and Sun One Directory Service
I'm not familiar with Sun One (I'm better at Active Directory), but this may help. Your actual object looks like cn=mrbig,ou=executive,dc=msi-inc,dc=com. OU is not an attribute of a user object, so that is why you can't use that attribute in the filter. However, the OU is part of the user's distinguishedName. You should be able to set your filter to include a partial distinguishedName. FILTER=((distinguishedName=*ou=executive,dc=msi-inc,dc=com)(uid=#form. username#)) M!ke Dawson University of Evansville -Original Message- From: Steve Metzger [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 20, 2007 6:54 PM To: CF-Talk Subject: CFLDAP and Sun One Directory Service We built a hierarchy in Sun one with various layers of OUs and groups with users under them. We thought it would be good practice to have each user possess a single user entry in the hierarchy. We use CFLDAP to authenticate, but we would like to limit the FILTER= parameter to a subset of OUs and groups that lie across various OUs. Example. Under Sales we have GroupA and GroupB OUs Under Marketing we have GroupC and GroupD Under Executive we have user mrbig and mrsmall If i want to add more intelligence to my authentication and my website is only for GroupA and GroupC and those under Executive I would expect a filter statement like this: ((objectclass=person)(|(ou=GroupA)(ou=GroupC)(ou=Executive))(uid=#form. username#)) But we cannot include ou in objectclass=person for some reason... Any clues? thanks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
AW: JRun Updater 7 500 Java bean field access exception
Thanks for the clarification. I followed Steven Erats recommendation - and Verity works now with JVM 1.6. Harry -Ursprüngliche Nachricht- Von: Jochem van Dieten [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 21. November 2007 13:12 An: CF-Talk Betreff: Re: JRun Updater 7 500 Java bean field access exception Harry Klein wrote: I receive this error in the CF Admin Verity Collections section: 500 Java bean field access exception My CF version is 7.0.2 (multiserver) on JRun Updater 7 (JVM 1.6.0_2). But: The Jrun Updater 7 Release Notes mentions that JVM 1.6 is supported. It is supported by JRun, not by any CF version prior to 8. Jochem ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: blocking spambots
On Wednesday 21 Nov 2007, Les Mizzell wrote: One hopes a .local TLD was used, or a domain with an MX that points at a spam reporting service... There ya go - sends them right to reporting if they try to use the email addresses! Not my idea, unfortunely : http://www.projecthoneypot.org/faq.php#d -- Tom Chiverton Helping to centrally optimize cutting-edge information on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF 8 install and the hot fix.
We are installing our first, brand new CF8 server in an hour or two. Would any of you recommend that we go ahead and apply the Cumulative Hot Fix 2 at this time, or wait and see if we experience any issues as recommended on Adobe's Hot Fix page [http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402792sliceId=1]? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: blocking spambots
One hopes a .local TLD was used, or a domain with an MX that points at a spam reporting service... There ya go - sends them right to reporting if they try to use the email addresses! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfeed and CDATA problems.
I am creating an XML feed within the following manner: My question is, the ![CDATA[ is being ignored (sorta). It is converting the characters as ascii. How can I get around this? cfset feedA1 = StructNew() cfset feedA1.version = rss_2.0 cfset feedA1.title = SITE NAME : Local News cfset feedA1.link = http://www.sitenamegoeshere.com; cfset feedA1.pubDate = ParseDateTime(now()) cfset feedA1.description=Local Headlines cfset feedA1.item = ArrayNew(1) cfset a = 1 cfoutput query=getA1Content cfset feedA1.item[a] = StructNew() cfset feedA1.item[a].title = replace(getA1Content.headline[a], , lt;, ALL) cfset feedA1.item[a].description = StructNew() cfset feedA1.item[a].description.value = getA1Content.content[a] cfset feedA1.item[a].description.value = replace(feedA1.item[a].description.value, '', ', ALL) cfset feedA1.item[a].pubDate = dateformat(getA1Content.runDate[a], ddd, dd mmm ) ' ' timeformat(getA1Content.theTimeStamp[a], hh:mm) ' EST' cfset feedA1.item[a].author = writer cfset feedA1.item[a].comments = ![CDATA[ a href='http://www.sitenamegoeshere.com/ redir.cfm?adid=250' target='_blank'img src='http://www.sitenamegoeshere.com/ /banners/bannerAd.gif'/a]] cfset feedA1.item[a].link = http://www.sitenamegoeshere.com/ news/display.htm?theid= getA1Content.id cfset a = a + 1 /cfoutput cffeed action=create name=#feedA1# outputfile=#filePath#rss\a1_complete2.xml overwrite=true xmlVar=A1_xmlout ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293651 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Server 2005 Workgroup vs Standard License?
Hey folks, Hopefully this is not off topic. We have a lot of CF sites running our software that use SQL 2000. We are going to be moving to SQL 2005 and are doing research on the licensing options. It seems that there is a Standard license and a Workgroup license of SQL 2005. For the purposes of hosting dynamic websites, we're not sure what the key differences or trade-offs are for our purposes (other than price). The only one that seems like it might be relevant is a max limit of 2 GB of RAM for the Workgroup license. Other than that, we're not sure what the key factors are. Any advice on this choice (other than price)? For example, are there any reasons to definitely get or not get one or the other of these licenses for the purpose of hosting a bunch of dynamic CF-based sites on a shared server? (note, the web server running CF is separate from the db server). Thanks in advance for your advice! Nick Gleason . .. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293652 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfswitch in cf8
I don't know if this has been thrown out there or not, so here it is. Some of you will remember a conversation that referred to this webapper blog (http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowCommentsArti cleID=20060727042244) about cfswitch on string values being horrendously slow under load in earlier versions of CF. (CF 7 for sure) Well, I was messing around with it in CF7 yesterday, looping a million times with cfif's and cfswitch's (the switches were 90 times slower for string values and twice as slow for numbers). A SeeFusion stack trace did indeed show constant attempts to convert the strings to doubles, and then the resultant exceptions that were thrown and caught internally. I ran the same test code on our new CF8 server and was very happy to see the switch was only about twice as slow for string values (and the same for number values). And for 1 million loops it was literally the difference between 200 and 400 milliseconds. So those of you with your sites comfortably on CF8 with _heavy_ loads on your cfswitch's, you can rest easy. And for the rest of you, unless you are doing thousands of cfswitches you are probably safe too. ~Brad ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfswitch in cf8
On Nov 21, 2007 10:10 AM, Brad Wood [EMAIL PROTECTED] wrote: A SeeFusion stack trace did indeed show constant attempts to convert the strings to doubles, and then the resultant exceptions that were thrown and caught internally. Note that if you run the CF8 debugger with break on exceptions enabled, you'll see it tries to convert strings to numbers in cfif as well in a lot of situations. This is kind of inherent in dynamic languages - and why some people use compare() or compareNoCase() for strings (but I think that's horribly ugly an unreadable). I ran the same test code on our new CF8 server and was very happy to see the switch was only about twice as slow for string values (and the same for number values). And for 1 million loops it was literally the difference between 200 and 400 milliseconds. Which is why this sort of optimization concern is so pointless! :) Readability and maintainability are very important. Saving a millisecond here and there in a web-based application is pretty worthless since network latency and other issues tend to completely swamp any miniscule code savings you might make using cfif instead of cfswitch. And as we've seen repeatedly, what's faster in one release of one CFML engine is slower in another release or another engine... For example, Railo is faster at locating unscoped variables but slower as locating scoped variables - which is the opposite to ColdFusion! Do what is most readable / maintainable for you and stop worrying about micro-performance stuff! -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: VPS or Dedicated CF Hosts
Thanks for bringing this post to my attention. With regards to generator backup, we do realize that this is one of the chinks in our armor, and as you said, we are very much working toward implementing a solution for this. Generators are amazingly expensive and it will be difficult to implement, but we are working toward that. All of our servers, switches, and routers are on a distributed UPS system, which handles 99.9% of power problems that occur in our area, but even so, getting a generator system online is our current priority in improving our infrastructure. Does AHP have a generator system in place? I could not find anything about their infrastructure on their site. Regarding out of date software, I'm happy to report that this is something we've remedied. Any new VPS Account will now use CentOS 4 instead of CentOS 3 as it was previously. If you need something even more modern then what's included with CentOS 4, we'll be happy to work with you to get that installed. In some cases, we'll even perform the upgrade for you for free when we set up your VPS Account. Just ask us about it. We want you to succeed and if using bleeding edge software will help you do that, we're all for it. We continually strive to offer better services and improve our infrastructure, so it pays to check back from time to time to see how we've improved. ;) Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member Adobe Solution Partner Mary Jo Sminkey wrote: Same here. I use viviotech vps and they are great at responding to support tickets and keep on top of other support related issues that come up in their forums. I used them for a short time myself but dropped them due to the lack of proper infrastructure/generator backup. I understand they are working on getting that in place, but in the meantime, a long power outage means your site will be down. I also found their Linux VPS servers full of out-of-date software which meant a lot of extra work trying to get the latest stuff installed. I've had very good luck in the past with HMS for dedicated servers and I'd guess their VPS plans are equally good and often recommend them. Personally though, I'm on a tighter budget though than their prices allow so use AHP Hosting and have been fairly happy with them (him) so far. Being a one-person shop myself I am more accepting of not having 24/7 support, and have found the response fast and generally knowledgeable. He also gave me a discount code for my customers to use to get an even better price when they signup, a nice little incentive for those on the fence about moving to a VPS plan. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: string concatenation / appending in CF8
On Nov 20, 2007 5:39 PM, Ryan Stille [EMAIL PROTECTED] wrote: Hmm that one didn't work for me when I tried it Dale's code worked fine for me... Dale Fraser wrote: cfset string = The Quick / cfset string = Brown Fox / cfoutput#string#/cfoutput ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfswitch in cf8
Which is why this sort of optimization concern is so pointless! :) Not so fast there cowboy. :) The 200 mili and 400 mili numbers were 1 million loops of a 4-faceted cfif and cfswitch structure respectively comparing string values on CF8. That same test on CF7.0.2 yields 1 second for the cfif and 115 seconds (nearly two minutes!) for cfswitch. Good luck trying to blame two minutes of page load time on network delays. :) Do many people use 1 million cfif's or cfswitch's on a page? Probably not. Truth is though; there is at least one documented case where a large number of cfswitch's on CF7 was literally bringing down someone's server until they converted them to cfif's. The problem may not affect everyone, but it's worth noting as opposed to writing it off IMO. Also, I'm glad you mentioned the CF8 debugger lets you break on exceptions. I'll have to play with that! ~Brad ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Verity Ranking
I am implementing a custom verity collection on my site. I am trying to find out how to inform the verity engine to rank some fields as more important than others. The items i'm indexing have a title, author, date, abstract, and keywords. At this point, I cant figure out how to get verity to rank a hit in the title above a hit in the abstract. If someone is searching for javascript compression and there is an article called javascript compression and there is a separate article that has both of those words as keywords, they will have an equal rank even though the identically named article is obviously a better match. Any help would be appreciated. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Issues with CFLDAP
I have the following query for an LDAP server: !--- Grab the authenticated username and remove the domain / --- cfset userName = #GetAuthUser()# cfset adminPass = #application.thepassword# cfldap action=query name=getUser attributes=cn,sn,dn,title,mail,telephonenumber,alias start=dc=acct,dc=upmchs,dc=net filter=((objectclass=user)(alias=#userName#)) server=acct.upmchs.net sort=cn ASC username=1upmc-acct\#userName# password=#adminPass# cfdump var=#getUser# label=#userName# But, when I go to output the query, I end up with nothing, I even tried to use a cfdump var=getUser, but it just came up empty. Does anyone know why? I'm guessing it has to do with it trying to find #userName# in active directory. Is there any way this can also be implemented in finding which groups are associated with #userName#? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Server 2005 Workgroup vs Standard License?
Hopefully this is not off topic. We have a lot of CF sites running our software that use SQL 2000. We are going to be moving to SQL 2005 and are doing research on the licensing options. It seems that there is a Standard license and a Workgroup license of SQL 2005. For the purposes of hosting dynamic websites, we're not sure what the key differences or trade-offs are for our purposes (other than price). The only one that seems like it might be relevant is a max limit of 2 GB of RAM for the Workgroup license. Other than that, we're not sure what the key factors are. Any advice on this choice (other than price)? For example, are there any reasons to definitely get or not get one or the other of these licenses for the purpose of hosting a bunch of dynamic CF-based sites on a shared server? (note, the web server running CF is separate from the db server). The Workgroup edition doesn't support any of the native SQL Server 2005 redundancy functionality (mirroring, etc). Other than that, and the RAM limitation, you should be fine with Workgroup. The feature comparison matrix pretty much lays it all out: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfswitch in cf8
Not so fast there cowboy. :) The 200 mili and 400 mili numbers were 1 million loops of a 4-faceted cfif and cfswitch structure respectively comparing string values on CF8. That same test on CF7.0.2 yields 1 second for the cfif and 115 seconds (nearly two minutes!) for cfswitch. Good luck trying to blame two minutes of page load time on network delays. :) Do many people use 1 million cfif's or cfswitch's on a page? Probably not. Truth is though; there is at least one documented case where a large number of cfswitch's on CF7 was literally bringing down someone's server until they converted them to cfif's. The problem may not affect everyone, but it's worth noting as opposed to writing it off IMO. I have to say, I fully agree with Sean here, and disagree with you. If ANYONE uses one million of ANYTHING in a single program, that person has bigger problems than optimization choices. CF is simply not the appropriate platform for a million operations of anything in a single program. That's not what it's for. If you have those kind of requirements, use something else - Java comes to mind - and invoke it from CF. A completely unrealistic test tells you how to optimize for completely unrealistic environments. What's more, the optimization won't apply universally to similar unrealistic environments in the future, because the internals of CF (and other CFML interpreters/compilers) change frequently enough to make your optimization choice fail in other versions. premature optimization is the root of all evil: http://en.wikipedia.org/wiki/Optimization_(computer_science)#Quotes Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Verity Ranking
Hello James, Verity follows the same rules as the major search engines. So, you are correct in saying the javascript compression following each other, or mentioned anywhere on the same page will have the same rank. To combat this, the only thing you can do is get users to use quotation marks around the phrase so verity will pick up the exact phrase. You can get more information on verity here: http://www.searchtools.com/tools/verity.html http://livedocs.adobe.com/coldfusion/6.1/htmldocs/indexseb.htm Kind regards, Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: James Wolfe [mailto:[EMAIL PROTECTED] Sent: November-21-07 4:25 PM To: CF-Talk Subject: Verity Ranking I am implementing a custom verity collection on my site. I am trying to find out how to inform the verity engine to rank some fields as more important than others. The items i'm indexing have a title, author, date, abstract, and keywords. At this point, I cant figure out how to get verity to rank a hit in the title above a hit in the abstract. If someone is searching for javascript compression and there is an article called javascript compression and there is a separate article that has both of those words as keywords, they will have an equal rank even though the identically named article is obviously a better match. Any help would be appreciated. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Issues with CFLDAP
I've not heard of the alias attribute. If you are using Active Directory, try using the sAMAccountName attribute rather than the alias attribute. You can also use the full email address for the userPrincipalName attribute, in most cases. I assume you are not getting any actual errors, so, the first thing I would do is narrow down the cause of the problem. Remove the filter and replace all variables with hard-coded values. Run the query and see if you get any records. If you get no records, and there is no filter, then the problem most likely lies with the user account's permissions. (However, I would assume that an account permission problem would throw an error.) All in all, I think if you change alias to sAMAccountName, your filter should work. The next part of your question, regarding the group membership, is pretty easy to answer. If you add the memberOf attribute, to your query, you will get a list of group distinguishedNames of which the user is a member. You will need to also use the separator attribute of the CFLDAP tag to correctly return the group DNs. Finally, if you are filtering down to a single account, you don't need to specify an objectClass. The query will return the record that matches the username, and it can only be one type. Below are the added/modified attributes of the CFLDAP tag according to my suggestions. cfldap ... separator=#chr(9)# attributes=cn,sn,dn,title,memberOf filter=sAMAccountName=#username# ... M!ke _ From: Dan Lopez [mailto:[EMAIL PROTECTED] Sent: Wed 11/21/2007 2:46 PM To: CF-Talk Subject: Issues with CFLDAP I have the following query for an LDAP server: !--- Grab the authenticated username and remove the domain / --- cfset userName = #GetAuthUser()# cfset adminPass = #application.thepassword# cfldap action=query name=getUser attributes=cn,sn,dn,title,mail,telephonenumber,alias start=dc=acct,dc=upmchs,dc=net filter=((objectclass=user)(alias=#userName#)) server=acct.upmchs.net sort=cn ASC username=1upmc-acct\#userName# password=#adminPass# cfdump var=#getUser# label=#userName# But, when I go to output the query, I end up with nothing, I even tried to use a cfdump var=getUser, but it just came up empty. Does anyone know why? I'm guessing it has to do with it trying to find #userName# in active directory. Is there any way this can also be implemented in finding which groups are associated with #userName#? ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfswitch in cf8
What would be your threshold number of cfswitch's that you would use before deciding to switch to Java (or something else)? Obviously you appear to have a limit in mind. I'll run the test that number of times. I'm not advocating anyone code something 1 million times but most performance problems show themselves under load. My point has simply been this: Calling information about code which has been shown to have a very significant performance decrease under load in real world situations as an insignificant find is irresponsible in my opinion. My test may have been a bit of a hyperbole but I think it successfully demonstrated the point. The effect was linear in my findings, meaning it would be less of a problem with less load, but it was still around 90 to 100 times slower regardless. Nowhere have I claimed my test to be perfect, but I don't think you can dismiss the fact that users of CF7 whom rely on many cfswitch tags evaluating strings on a high trafficked will experience slower code than if they used a cfif construct. Of course, I wouldn't recommend re-writing any code unless you actually experience a problem; but my original post was really an information post noting how the CF8 internals differed from CF7, not an everybody-go-rewrite-your-cf7-apps post. I feel that any information about a language and what it is faster or slower at is noteworthy information. I also feel any part of a language which is shown to be around 100 times slower than alternative code is very significant. Sure, make readable and clean code within reason-- but are you and Sean suggesting that being informed of a language's weak and strong points is pointless? All I want is for people to recognize useful information about the language they code in. And as we all know-- knowing is half the battle. http://en.wikipedia.org/wiki/G.I._Joe ~Brad -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 21, 2007 3:12 PM To: CF-Talk Subject: RE: cfswitch in cf8 Not so fast there cowboy. :) The 200 mili and 400 mili numbers were 1 million loops of a 4-faceted cfif and cfswitch structure respectively comparing string values on CF8. That same test on CF7.0.2 yields 1 second for the cfif and 115 seconds (nearly two minutes!) for cfswitch. Good luck trying to blame two minutes of page load time on network delays. :) Do many people use 1 million cfif's or cfswitch's on a page? Probably not. Truth is though; there is at least one documented case where a large number of cfswitch's on CF7 was literally bringing down someone's server until they converted them to cfif's. The problem may not affect everyone, but it's worth noting as opposed to writing it off IMO. I have to say, I fully agree with Sean here, and disagree with you. If ANYONE uses one million of ANYTHING in a single program, that person has bigger problems than optimization choices. CF is simply not the appropriate platform for a million operations of anything in a single program. That's not what it's for. If you have those kind of requirements, use something else - Java comes to mind - and invoke it from CF. A completely unrealistic test tells you how to optimize for completely unrealistic environments. What's more, the optimization won't apply universally to similar unrealistic environments in the future, because the internals of CF (and other CFML interpreters/compilers) change frequently enough to make your optimization choice fail in other versions. premature optimization is the root of all evil: http://en.wikipedia.org/wiki/Optimization_(computer_science)#Quotes Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfswitch in cf8
What would be your threshold number of cfswitch's that you would use before deciding to switch to Java (or something else)? Obviously you appear to have a limit in mind. I'll run the test that number of times. Running iterative tests tells you nothing about application performance. I can't tell you how many times I've seen an example of an iterative test used to justify a coding decision, only to find out that the decision provided no benefit (or actually degraded performance) under actual load. I can, however, tell you that it's very entertaining to get paid to tell someone that. I'm not advocating anyone code something 1 million times but most performance problems show themselves under load. Yes, and the way to identify those problems is through load testing, not through building scripts that do things you don't actually do in your codebase. Tests which involves iteration instead of concurrent requests don't tell you useful information about how applications actually work, because they exaggerate often-unimportant implementation details and fail to capture the details about your actual application. I feel that any information about a language and what it is faster or slower at is noteworthy information. I also feel any part of a language which is shown to be around 100 times slower than alternative code is very significant. However, this isn't information about a language. CFML is a language. The same CFML commands work one way in CF 7 and another way in CF 8, as you've discovered. What if they work yet another way in CF 9? What if I'm porting my application from CF 5? Unless you never plan to change versions or platforms, this tells you nothing useful about the language itself. If I told you I was writing an application in CFML using CFSWITCH with string constants, and didn't provide any further details, what would you advise me to do in this particular case? How about if I said I was using CF 7, but would soon upgrade to CF 8? Or BlueDragon? Oh, and if you're going to quote someone, I'll take Knuth over GI Joe when it comes to performance optimization. When it comes to compilers, Knuth kicks GI Joe's ass. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfswitch in cf8
Running iterative tests tells you nothing about application performance. That may be a good point, but what does it have to do with the original topic? Sean originally stated that performance gains measured in milliseconds were meaningless. I pointed out that the way CF7 was coded allowed for performance degradations which were larger than mere milliseconds. Besides my iterative test, you keep ignoring the reports of real live applications who suffered from the performance of cfswitch tags and strings. Yes, and the way to identify those problems is through load testing, not through building scripts that do things you don't actually do in your codebase. And what makes you an expert in my code base? Have you seen it? Fact of the matter is, I was just working this week in some code which performed some conditional processing of large result sets looping once per column and row. Based on the data available it has the potential to run thousands of times. What if they work yet another way in CF 9? You can beat the what-if horse all you want, but this thread has clearly been about differences between CF7 and CF8. To tell me people haven't coded in such a way that optimized for their version of the compiler would be a lie. I'm sorry, but I won't be able to post any more until Monday. I'm off to celebrate Thankgiving. Happy Holiday everyone! (And I am interesting what other people's opinion on this is.) ~Brad ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293666 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Zip Code Locator
Hello all and Happy Holidays! One of my customers wants me to create a dating site for him. I know that one of the features that he will want is to locate people within X miles of their zip code. Does anyone know of any code that you have used or recommend for this that I can plug into the site to accomplish this? API's or whatever is fine. Thanks, Bruce ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Zip Code Locator
Hello all and Happy Holidays! One of my customers wants me to create a dating site for him. I know that one of the features that he will want is to locate people within X miles of their zip code. Does anyone know of any code that you have used or recommend for this that I can plug into the site to accomplish this? API's or whatever is fine. dr. dave, the man the women crave, will likely chime in on this since he's got some experience in this area. Will ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfswitch in cf8
That may be a good point, but what does it have to do with the original topic? Sean originally stated that performance gains measured in milliseconds were meaningless. I pointed out that the way CF7 was coded allowed for performance degradations which were larger than mere milliseconds. if you're doing large enough numbers of iterations. In any case, I don't really care about the original topic. I was responding to your response to Sean, which I thought was off-base. I've worked with many, many CF applications, and the vast majority of their problems are one of two things: 1. Poorly-designed database interaction, and 2. doing unnecessary work at runtime. The number of times that a specific way of doing things in CF has made a significant difference is very close to zero. I'm not going to say that these problems never arise, but they're clearly the exceptions rather than the rule. And yet, I see so many CF programmers focused on which is faster questions about CF tags, etc, that they lose sight of the big picture - the two points mentioned above. So, you'll have to forgive me, but I tend to respond to those sorts of questions a certain way. In the same vein, I see iterative tests used ALL THE TIME by CF programmers, and frankly I think they're horrible. They're misleading, and again they distract from the real performance issues you're likely to encounter. Besides my iterative test, you keep ignoring the reports of real live applications who suffered from the performance of cfswitch tags and strings. If you have a real live application which suffers from some specific performance problem, you should address that performance problem. My point is simply that trying to solve the performance problem by premature optimization is usually a mistake. Having worked now with hundreds of applications that have had performance problems, I feel comfortable saying that any feature of the language, misused, can lead to performance problems. But that by itself isn't especially useful in telling someone how to build an application. And, of course, the specific numbers you quoted to Sean were from your iterative test. I think it's perfectly OK to critique the process by which you gained those numbers, if you're going to use them as justification for doing something one way or another. And what makes you an expert in my code base? Have you seen it? Fact of the matter is, I was just working this week in some code which performed some conditional processing of large result sets looping once per column and row. Based on the data available it has the potential to run thousands of times. Your test ran a million iterations, according to you. You said that this doesn't represent what people actually do. I don't need to be an expert in your code base, I just have to have fundamental reading skills. And, frankly, based on what little I now know about your code base, I would recommend that you investigate doing that conditional processing in a stored procedure if you can, because that kind of operation is usually better done in an SP than in CF. So, where you might see switching from one decision structure to another as an optimization, I would instead see moving the decision structure out of CF altogether as the optimization. You can beat the what-if horse all you want, but this thread has clearly been about differences between CF7 and CF8. To tell me people haven't coded in such a way that optimized for their version of the compiler would be a lie. People do all sorts of dumb things. That's hardly a justification for those things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Zip Code Locator
funny.. girls call me me dr, i even was gunna buy www.drdave.com but it was taken.. dammit. first thing to decide is how accurate you want it. If you just go by zipcode you could be 2 - 200 miles off the actual distance. If you want it accurate you need to use actual addresses. there are easy goodle and yahoo tools now available to pass an address and then get back their geocoding info. Email me off-list if u need some code dr. dave, the man the women crave, will likely chime in on this since he's got some experience in this area. Will ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Zip Code Locator
We use this: http://www.zipcodedownload.com/Products/Product/Z5Premium/Standard/Overview/ Using the latitude and longitude you can calculate distances between zip codes. Russ -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 21, 2007 7:33 PM To: CF-Talk Subject: Zip Code Locator Hello all and Happy Holidays! One of my customers wants me to create a dating site for him. I know that one of the features that he will want is to locate people within X miles of their zip code. Does anyone know of any code that you have used or recommend for this that I can plug into the site to accomplish this? API's or whatever is fine. Thanks, Bruce ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Zip Code Locator
you don't need that and its not accurate, just do a geocode on address and then the formula. The reason why using a zipcodes lat and lon don't work is because lets say person a is in zipcode 1 and zipcode 1 is 40 square miles and they live on the outer western edge and person 2 is in zipcode 2 which is 20 square miles and which is directly next to zipcode one and they live near eastern side. If you run the codes based on the zipcode lat and lon they will be approx 30 miles apart but if you run it on actual lat and lon they might only be a mile apart. Why is this? The zipcode lat and lon are based on the center of the the zipcode not the actual locations. We use this: http://www.zipcodedownload.com/Products/Product/Z5Premium/Standard/Overview/ Using the latitude and longitude you can calculate distances between zip codes. Russ ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Zip Code Locator
Yeah, that explains on one dating site I was looking at, I did a 50 mile radius search and I was getting people from Stockton, which is WAY more than 50 miles from where I live. I will do the geocode deal. I use Google for our school district site for school boundaries. Pretty slick API that they have. Thanks, Bruce -Original Message- From: Dave l [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 21, 2007 7:11 PM To: CF-Talk Subject: Re: Zip Code Locator you don't need that and its not accurate, just do a geocode on address and then the formula. The reason why using a zipcodes lat and lon don't work is because lets say person a is in zipcode 1 and zipcode 1 is 40 square miles and they live on the outer western edge and person 2 is in zipcode 2 which is 20 square miles and which is directly next to zipcode one and they live near eastern side. If you run the codes based on the zipcode lat and lon they will be approx 30 miles apart but if you run it on actual lat and lon they might only be a mile apart. Why is this? The zipcode lat and lon are based on the center of the the zipcode not the actual locations. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Zip Code Locator
sure :) it's funny though most sites do it the other way. For example use the Subway sandwich site, I live in area code 80528 which is a fort collins area code but I actually live in Windsor which is a different city, so when I search for a local store the closest one really is like 14 miles away and the one 2 blocks away doesn't even show up. There is give an take to this as well, like on the Ross sites I use the actual lat lon of the store but the general zipcode for the user which might make it closer but they didn't want the user to have to put in their actual address as most people wouldn't understand why it is better and might perceive it as collecting their data. Yeah, that explains on one dating site I was looking at, I did a 50 mile radius search and I was getting people from Stockton, which is WAY more than 50 miles from where I live. I will do the geocode deal. I use Google for our school district site for school boundaries. Pretty slick API that they have. Thanks, Bruce ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293674 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Race Condition and Locking?
For the first time, I had a fluke race condition happen in my store app. Two people placed separate orders at the exact same time. Somehow, the order totals got crossed up which caused one of the orders to use the other order's total when transmitting the sale thru authorize.net I didnt think I HAD to use a lock, but I'm guessing maybe I do because of this. And to be honest, I never really use locks much because I didn't think I needed them in the later versions of CF. Here's the code that transmits to auth.net. I'm guessing I'd wrap it in a cflock? !--- Initialize authorize.cfc --- cfset SESSION.authorizenet = createObject(component,cfcs.AuthorizeNet).init(AuthNetLogin, AuthNetPassword) cfinvoke component=#SESSION.authorizenet# method=transmitpayment returnvariable=response cfinvokeargument name=AuthNetURL value=#AuthNetURL# cfinvokeargument name=storeinfo value=#storeinfo# cfinvokeargument name=shopperbillshipinfo value=#VARIABLES.shopperbillshipinfo# cfinvokeargument name=shoppercreditinfo value=#VARIABLES.shoppercreditinfo# cfinvokeargument name=carttotals value=#VARIABLES.carttotals# cfinvokeargument name=finalcarttotal value=#VARIABLES.finalCartTotal# cfinvokeargument name=IPaddress value=#CGI.remote_addr# cfinvokeargument name=shopperbillstatename value=#shopperbillstatename# cfinvokeargument name=shoppershipstatename value=#shoppershipstatename# /cfinvoke Thanks, Will ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Race Condition and Locking?
Are you sure this is were it happened at? Wouldn't you give them a order # or something earlier? For the first time, I had a fluke race condition happen in my store app. Two people placed separate orders at the exact same time. Somehow, the order totals got crossed up which caused one of the orders to use the other order's total when transmitting the sale thru authorize.net I didnt think I HAD to use a lock, but I'm guessing maybe I do because of this. And to be honest, I never really use locks much because I didn't think I needed them in the later versions of CF. Here's the code that transmits to auth.net. I'm guessing I'd wrap it in a cflock? !--- Initialize authorize.cfc --- cfset SESSION.authorizenet = createObject(component,cfcs. AuthorizeNet).init(AuthNetLogin, AuthNetPassword) cfinvoke component=#SESSION.authorizenet# method=transmitpayment returnvariable=response cfinvokeargument name=AuthNetURL value=#AuthNetURL# cfinvokeargument name=storeinfo value=#storeinfo# cfinvokeargument name=shopperbillshipinfo value=#VARIABLES. shopperbillshipinfo# cfinvokeargument name=shoppercreditinfo value=#VARIABLES. shoppercreditinfo# cfinvokeargument name=carttotals value=#VARIABLES.carttotals# cfinvokeargument name=finalcarttotal value=#VARIABLES. finalCartTotal# cfinvokeargument name=IPaddress value=#CGI.remote_addr# cfinvokeargument name=shopperbillstatename value=#shopperbillstatename# cfinvokeargument name=shoppershipstatename value=#shoppershipstatename# /cfinvoke Thanks, Will ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Race Condition and Locking?
Are you sure this is were it happened at? Wouldn't you give them a order # or something earlier? Nope, not sure. I'm just goin off the fact that everything about the orders was correct. Each had all its own info, order #, etc. Everything EXCEPT the total that was logged to the db and processed thru auth.net. I may be wrong. It's hard to pinpoint exactly where things went wrong. Will ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Race Condition and Locking?
I am assuming that you are using access, hopefully not!! HAHA damn caplocks If you are using mysql or sql server then you could put the authorize.net request in a cftransaction block. Could this be a good use for cfthread? Are you sure this is were it happened at? Wouldn't you give them a order # or something earlier? Nope, not sure. I'm just goin off the fact that everything about the orders was correct. Each had all its own info, order #, etc. Everything EXCEPT the total that was logged to the db and processed thru auth.net. I may be wrong. It's hard to pinpoint exactly where things went wrong. Will ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED: Race Condition and Locking?
After consultation with the disruptor, I came to the conclusion that using a timestamp wasn't a good idea for a customer ID. :) It finally bit me in the butt after 860 orders. Now I use a timestamp + IP add. Thanks, Will ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOLVED: Race Condition and Locking?
And if two people on a NAT router order at the same time? :-P On Nov 22, 2007 2:57 PM, Will Tomlinson [EMAIL PROTECTED] wrote: After consultation with the disruptor, I came to the conclusion that using a timestamp wasn't a good idea for a customer ID. :) It finally bit me in the butt after 860 orders. Now I use a timestamp + IP add. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOLVED: Race Condition and Locking?
naw that would never happen.. Funny thing is that is what he said to me when he first used just the timestamp, lol And if two people on a NAT router order at the same time? :-P ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOLVED: Race Condition and Locking?
Will, It's still going to bite you in the butt. You still have a race condition, and lots of people share IPs. From what you've said, I'd say take a good hard look inside the AuthorizeNet component. Or lock the bejeesus out of it - but if you just do that it's going to be hard to know whether you've killed the problem or not, until it happens again. Jaime Metcher -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 November 2007 3:57 PM To: CF-Talk Subject: SOLVED: Race Condition and Locking? After consultation with the disruptor, I came to the conclusion that using a timestamp wasn't a good idea for a customer ID. :) It finally bit me in the butt after 860 orders. Now I use a timestamp + IP add. Thanks, Will ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4