RE: Preventing Link-Builders
Kris Jones wrote on 2010-02-12: We've got a very busy legacy home-grown forum that since late August 2009 or so has been getting hit heavily by the Link-Building industry. Posting requires membership, which requires a captcha to be entered, and a confirmation email link to be clicked. Everyday, I search and invalidate hundreds of link-building memberships (the ones I can find). Interestingly, none of the links ever get posted -- we're using akismet, which does a pretty good job of stopping these. Kris - try http://www.stopforumspam.com/apis and look up the e-mail + ip in that database. And report any spammers that are not in that database already, to contribute to the anti-spam community! Cheers, Hugo -- Hugo Ahlenius - Hugo AhleniusE-Mail: hugo.ahlenius(at)nordpil.com Phone:+46 75 7575284 Nordpil Fax: +46 8 6747020 http://nordpil.com Mobile: +46 733 467111 Skype: callto:hugo.ahlenius vCard:http://nordpil.com/hugoahlenius.vcf - ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java assistance
You need Java EE to compile these. This is not included in the standard JDK. Download Java EE and you should be ok to compile the code. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 15 February 2010 09:45, Eric Roberts w...@witchnet.org wrote: We are trying to implement a signature pad. The code that I found that seems to work well with CF in both browsers comes with example code that I am using as the basis for the actual code. There are some calls that are giving the following errors: Description Resource Path Location Type HttpServlet cannot be resolved to a typeTestServlet.java /servlet/srcline 26 Java Problem HttpServletRequest cannot be resolved to a typeTestServlet.java /servlet/srcline 34 Java Problem HttpServletResponse cannot be resolved to a type TestServlet.java /servlet/srcline 34 Java Problem These calls are unmodified from the original code that did work fine, but won't compile. I do not have the source on the .class files so I can't look and make sure that syntax or class are correct.is there anyway to expose at least the function names to make sure that isn't the problem? There are no javadocs. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
coldfusion for medical research
Hi, our company builds software with coldfusion for charitable institutions/universities who store information for medical research purposes. i understand there is a free license for educational purposes but is there a free or discounted license for this scenario? thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: coldfusion for medical research
You'd be best talking to your local Adobe rep about this. Something on this page will probably give details for that: http://www.adobe.com/support/contact/ If Adobe can't provide you with a price you're happy with, you might want to consider Railo (http://www.gerailo.com) and OpenBD (http://www.openbluedragon.org) as possible alternatives. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Broken images in CFADMIN
I had this issue while installing CF9 64-bit on Win 7 64-bit. For me the solution was to uninstall CF9 then uninstall IIS, then reinstall IIS and CF9. Although I am guessing there is an easier solution out there. On Sat, Feb 13, 2010 at 6:49 PM, ColdFusion Developer cfdev2...@gmail.comwrote: I know thatere was a webpage contributed to this issue but not able to find it this round. I know of the one from adobe but that is not the issue. I have Windows 7 Home Premium installed with CF 9 Dev edition running under IIS. When I load up CF Administror the images are broken (Missing). I thought this has something to do with one of the IIS options but can't remember which. Anyone else experience this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Possible switch to CFEclipse
Hey Gerald, I definitely agree with Kevin, If you're looking for a great CFML engine to run on your server and don't have the $$ for Adobe's ColdFusion, look into Railo. I develop on both and have found Railo to be very comparable to Adobe's Coldfusion. http://www.getrailo.org/index.cfm/download/#primary Paul Alkema http://www.AlkemaDesigns.com -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Sunday, February 14, 2010 11:23 PM To: cf-talk Subject: Re: Possible switch to CFEclipse While I have your attention. Could you, meaning Adobe, for the love of God and all that supports the CF community at large, put out a version of CF Server that a hosting company can use that offers some sort of user/domain based security with out us having to shell out $7500? Or in other terms: An affordable way to for us (the community) to provide Adobe ColdFusion hosting? Thanx G! On Thu, Feb 11, 2010 at 7:03 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Aptana, jQuery, ExtJS and AIR are all baked into ColdFusion Builder... with just one install. -Adam On Thu, Feb 11, 2010 at 3:16 PM, Andy Matthews li...@commadelimited.com wrote: Aptana also has a plugin which allows you to code for Adobe AIR. http://andymatthews.net/category/AIR/ andy -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Thursday, February 11, 2010 12:39 PM To: cf-talk Subject: Re: Possible switch to CFEclipse I am currently using Homesite+ for my IDE a I made that leap a couple of years ago. This is my rig that I have been tweeking for the last couple of years and the what and why of what I use for CF/Web work. One thing to remember with Eclipse. More Plugins = More ram. I also make it a habit to jack up the RAM allotted to Eclipse from 256 megs to 512 in the eclipse.ini file. This will speed things up considerably. I start off with the PHP Eclipse distro because, well, I work with PHP a lot. But even if I didn't, it has a lot of the basic tools I use for web dev. Like support for XAMPP, Mysql etc Then I add the Aptana plugin and add it's plugins for Ajax, SVN, AIR support and what ever tickles my fancy at that moment. Some people are very vocal against Aptana (I mean some people just flat out despise it) . It has a nasty habit of firing up it's start up page every time you load it. You can turn this off by going to: Window Preferences Aapata Start up page and disable the start up page If you ask me, Aptana is fantastic for working with (X)HTML, CSS, JS, Ajax, and in particular it's jQuery/JS support. It provides auto suggest, auto complete and inline help CSS, html, JS including all of the major AJAX/JS libraries as well as (inspection) for your own custom JS Libraries (and help as long as you document them). I really like it's CSS editor a lot. Then I add the Adobe CF 8.1 plugins and plop the CF 8.1 docs in the Plugins folder for good measure. Then Finally I install CFEclipse. I also Use XMLBuddy a lot because, well, I like it. Good luck. G! On Wed, Feb 10, 2010 at 9:23 PM, Terry Troxel te...@it-werks.com wrote: I do not want to start a flame here, just get some information to help me make a decision. I am using CF8 and not yet ready for CF9. I am currently using Homesite+ for my IDE and would like to know what the requirements are for installing Eclipse and CFEclipse on my 32 bit dual core laptop w/3 gigs of ram. I do not know anyone who is currently using it which is why I am asking here. I do not do any Java programming at all and am planning on using it to replace Homesite if that is possible and maybe get some advise from all of you. If you recommend Eclipse, which package and other plugins do I need as well? Terry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The JVM library could not be found. SOLVED
and you wouldn't want all of them to set global environment variables. Well, actually I don't care, all I want is that a piece of soft I do not want installs itself correctly if it is needed by some other soft I want. The problem was also (as very often) that the error message was inappropriate: The SVM file WAS FOUND, it is the rest of the Java library needed by the SVM which was not. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: java assistance
James I tried that and I am just fighting against my inexperience with Java outside of CF and in doing it with Eclipse. I have touched pure Java in about 11 or 12 years and we didn't have eclipse back then. A friend of mine suggested that I just call the servlet within a cf page as Java in CF...but that didn't work either...or I am doing something wrong. This is getting a bit frustrating. This shouldn't be this difficult. Eric PS...you seem to know ajax pretty well...we are using Help Bubble and want to put a google map to show the location. We have the GPS coordinates in the DB, so I am just passing that to the page that generates the map. If I call that page, the map comes up fine, but when I call it in the help bubble, I get all the textual output, but no map. Here's the code that calls the bubble...maps_test2.cfm is the page that contains the code that calls the map: lia href=## id=map2 onclick=return false;850 Stephenson Highway, Troy MI/a/li script new HelpBalloon( { title: 'Job Location Map', dataURL: 'maps_test2.cfm?latlng=42.5429670, -83.1201470', icon: $('map2') }); /script The page has a link with the coordinates that brings up a page with google maps so they can enter their address to get directions...that comes up fine. Just no map. Both the map and the link are surrounded in divs. Any ideas? Thanks! -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Monday, February 15, 2010 4:49 AM To: cf-talk Subject: Re: java assistance You need Java EE to compile these. This is not included in the standard JDK. Download Java EE and you should be ok to compile the code. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 15 February 2010 09:45, Eric Roberts w...@witchnet.org wrote: We are trying to implement a signature pad. The code that I found that seems to work well with CF in both browsers comes with example code that I am using as the basis for the actual code. There are some calls that are giving the following errors: Description Resource Path Location Type HttpServlet cannot be resolved to a typeTestServlet.java /servlet/srcline 26 Java Problem HttpServletRequest cannot be resolved to a type TestServlet.java /servlet/srcline 34 Java Problem HttpServletResponse cannot be resolved to a type TestServlet.java /servlet/srcline 34 Java Problem These calls are unmodified from the original code that did work fine, but won't compile. I do not have the source on the .class files so I can't look and make sure that syntax or class are correct.is there anyway to expose at least the function names to make sure that isn't the problem? There are no javadocs. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfwindow looks different in cf9
I did some css overwrites to force my app to remain similar. The ext- css file in CF has darn near every HTML tag listed in there and zeroed out. Sent from my iPhone On Feb 13, 2010, at 4:12 PM, John Pullam jpul...@mcleansystems.com wrote: That makes a lot of sense and is consistent with what my test case has shown. Could you please explain what you mean by some css overwrites? Ideally I'd like to find a way to restate that the cfwindow code (on the page I invoke in the window) should use my main CSS style sheet in its entirety (the same sheet I use for the main web page). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible switch to CFEclipse
We are working to find an alternative way to license ColdFusion to hosting companies that is more cost effective for the smaller shops. However, it's a common misconception that the price of ColdFusion is proportionate to the cost of hosting. Hosting companies don't pay anywhere near list price. For one specific host we discounted the cost of ColdFusion 8 by over $1M in good faith, and asked the hosting company not to charge more for CF than they do for ASP/PHP. In the end, the hosting company decided not to alter it's prices because the CF community is willing to pay the premium. Can't say I really blame them, after all ColdFusion is a premium server/language compared to the the competition. This is my personal opinion, so please take it with a grain of salt, but I don't believe the shared hosting model will be around much longer. The costs of virtual private machines has been steadily dropping and cloud vendors like Amazon and Microsoft are driving costs down. Today Amazon offers a Linux AMI for as little as $40/month. Rather than spend engineering resources on a proprietary user/domain model that hosting companies would likely ignore, I'd rather remain focused on innovating ColdFusion development and try to bring a lost-cost version of CF to market that makes virtual machine hosting cheaper than shared hosting. Do you really want to spend another decade sharing a directory? If you are willing to take the risk to move to one of the clone engines, you should check out OpenBD on the Google App Engine. Free is hard to beat. ;-) -Adam On Mon, Feb 15, 2010 at 9:00 AM, Paul Alkema paulalkemadesi...@gmail.comwrote: Hey Gerald, I definitely agree with Kevin, If you're looking for a great CFML engine to run on your server and don't have the $$ for Adobe's ColdFusion, look into Railo. I develop on both and have found Railo to be very comparable to Adobe's Coldfusion. http://www.getrailo.org/index.cfm/download/#primary Paul Alkema http://www.AlkemaDesigns.com -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Sunday, February 14, 2010 11:23 PM To: cf-talk Subject: Re: Possible switch to CFEclipse While I have your attention. Could you, meaning Adobe, for the love of God and all that supports the CF community at large, put out a version of CF Server that a hosting company can use that offers some sort of user/domain based security with out us having to shell out $7500? Or in other terms: An affordable way to for us (the community) to provide Adobe ColdFusion hosting? Thanx G! On Thu, Feb 11, 2010 at 7:03 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Aptana, jQuery, ExtJS and AIR are all baked into ColdFusion Builder... with just one install. -Adam On Thu, Feb 11, 2010 at 3:16 PM, Andy Matthews li...@commadelimited.com wrote: Aptana also has a plugin which allows you to code for Adobe AIR. http://andymatthews.net/category/AIR/ andy -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Thursday, February 11, 2010 12:39 PM To: cf-talk Subject: Re: Possible switch to CFEclipse I am currently using Homesite+ for my IDE a I made that leap a couple of years ago. This is my rig that I have been tweeking for the last couple of years and the what and why of what I use for CF/Web work. One thing to remember with Eclipse. More Plugins = More ram. I also make it a habit to jack up the RAM allotted to Eclipse from 256 megs to 512 in the eclipse.ini file. This will speed things up considerably. I start off with the PHP Eclipse distro because, well, I work with PHP a lot. But even if I didn't, it has a lot of the basic tools I use for web dev. Like support for XAMPP, Mysql etc Then I add the Aptana plugin and add it's plugins for Ajax, SVN, AIR support and what ever tickles my fancy at that moment. Some people are very vocal against Aptana (I mean some people just flat out despise it) . It has a nasty habit of firing up it's start up page every time you load it. You can turn this off by going to: Window Preferences Aapata Start up page and disable the start up page If you ask me, Aptana is fantastic for working with (X)HTML, CSS, JS, Ajax, and in particular it's jQuery/JS support. It provides auto suggest, auto complete and inline help CSS, html, JS including all of the major AJAX/JS libraries as well as (inspection) for your own custom JS Libraries (and help as long as you document them). I really like it's CSS editor a lot. Then I add the Adobe CF 8.1 plugins and plop the CF 8.1 docs in the Plugins folder for good measure. Then Finally I install CFEclipse. I also Use XMLBuddy a lot because, well, I like it. Good luck. G! On Wed, Feb 10, 2010 at 9:23 PM, Terry Troxel te...@it-werks.com wrote: I do
Total Two Field From Two Tables
Hello Everybody. I have been thinking and working on this for three days now. I'm looking for some help totaling two fields from two tables. Here is what I have: Sample Tables: Table - fdd_directory fdd_name (Example: ACME Fire Dept) fdd_state (Example: PA) fdd_zip (Example: 12345) Table - states statecodeID (Example: 111) abrev (Example: PA) statename (Example: Pennsylvania) Table - articles zipcode (Example: 12345) !---Here is what I have:--- cfquery name=states datasource=#dsn# SELECT count(fddirectory.fdd_id) AS FDCount, states.statename, states.abrev, states.statecodeID FROMfddirectory, states WHERE fddirectory.fdd_state = states.abrev GROUP BY statename ORDER BY statename /cfquery cfoutput query=states a href=next.cfm?statecodeID=#abrev##states.statename# (#NumberFormat(fdcount)#)/abr / /cfoutput So far, so good... Next.cfm cfquery name=Story datasource=#dsn# SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev FROMfddirectory, states WHERE fddirectory.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND fddirectory.fdd_state = states.abrev ORDER BY fddirectory.fdd_name /cfquery !---Here is where I would like to total articles.zipcode = fddirectory.fdd_zip--- cfoutput query=Story a href=next1.cfm?fdd_id=#story.fdd_id##story.fdd_name#/a (Total Here)br /cfoutput Total Here should equal articles.zipcode = fddirectory.fdd_zip or the number of article(s) from the articles table that match each fdd_name. For Example: ACME FD (Total 38) Thanks, Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT CF 8
Bump ;-) If anyone needs further clarificationplease ask On Sun, 2010-02-14 at 17:41 -0800, Bryan Stevenson wrote: Hey All, Here's my sample code: -- cfdocument format=FlashPaper pagetype=letter orientation=portrait !--- REPORT FOOTER --- cfdocumentitem type=footer REPORT FOOTER - should see at bottom of every page /cfdocumentitem !--- REPORT HEADER --- cfdocumentsection name=report header REPORT HEADER - should only see at top of first page /cfdocumentsection !--- RULE OUTPUT SECTION --- cfdocumentsection name=Rule Section cfdocumentitem type=header This is the Header - Should Repeat on Every Page /cfdocumentitem cfloop from=1 to=150 index=i RULE OUTPUTbr / /cfloop /cfdocumentsection /cfdocument -- I'm expecting output like this: -- REPORT HEADER - should only see at top of first page This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (new page auto-forced) This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (and so on as long as there is content for the Rule Section) - What I'm seeing: - REPORT HEADER - should only see at top of first page [BLANK PAGE] REPORT FOOTER - should see at bottom of every page This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (new page auto-forced) This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (and so on as long as there is content for the Rule Section) - So it seems that CFDOCUMENTSECTION is filling the first page with whitespace...showing the footerthen showing me what I'd expect. It's that first blank page that is killing me. I tried removing the CFDOCUMENTSECTION tags around REPORT HEADER and then that text simply disappears (along with the blank page) Any thoughts? TIA Cheers 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: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Total Two Field From Two Tables
Just add: (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount to the end of your SELECT clause: SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev , (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount FROMfddirectory, states WHERE fddirectory.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND fddirectory.fdd_state = states.abrev ORDER BY fddirectory.fdd_name That should do it for you, cheers, barneyb On Mon, Feb 15, 2010 at 8:50 AM, Barry Mcconaghey bmcconag...@gmail.com wrote: Hello Everybody. I have been thinking and working on this for three days now. I'm looking for some help totaling two fields from two tables. Here is what I have: Sample Tables: Table - fdd_directory fdd_name (Example: ACME Fire Dept) fdd_state (Example: PA) fdd_zip (Example: 12345) Table - states statecodeID (Example: 111) abrev (Example: PA) statename (Example: Pennsylvania) Table - articles zipcode (Example: 12345) !---Here is what I have:--- cfquery name=states datasource=#dsn# SELECT count(fddirectory.fdd_id) AS FDCount, states.statename, states.abrev, states.statecodeID FROM fddirectory, states WHERE fddirectory.fdd_state = states.abrev GROUP BY statename ORDER BY statename /cfquery cfoutput query=states a href=next.cfm?statecodeID=#abrev##states.statename# (#NumberFormat(fdcount)#)/abr / /cfoutput So far, so good... Next.cfm cfquery name=Story datasource=#dsn# SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev FROM fddirectory, states WHERE fddirectory.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND fddirectory.fdd_state = states.abrev ORDER BY fddirectory.fdd_name /cfquery !---Here is where I would like to total articles.zipcode = fddirectory.fdd_zip--- cfoutput query=Story a href=next1.cfm?fdd_id=#story.fdd_id##story.fdd_name#/a (Total Here)br /cfoutput Total Here should equal articles.zipcode = fddirectory.fdd_zip or the number of article(s) from the articles table that match each fdd_name. For Example: ACME FD (Total 38) Thanks, Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Total Two Field From Two Tables
Thanks Barney B. ERROR Message: Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count(*) from articles where zipcode = fddirectory.fdd_z Here is the cfquery: cfquery name=Story datasource=#dsn# SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev, (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount FROMfddirectory, states WHERE fddirectory.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND fddirectory.fdd_state = states.abrev ORDER BY fddirectory.fdd_name /cfquery Just add: (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount to the end of your SELECT clause: SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev , (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount FROMfddirectory, states WHERE fddirectory.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND fddirectory.fdd_state = states.abrev ORDER BY fddirectory.fdd_name That should do it for you, cheers, barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preventing Link-Builders
Thanks for this Hugo. Taking a look at it. Do wonder if we'd end-up doing way more insertions into the system than positive resolutions though. Once I'm back in the office tomorrow, I'll do some checks on the addresses I've already inactivated. Cheers, Kris On Mon, Feb 15, 2010 at 4:54 AM, Hugo Ahlenius hugo.ahlen...@nordpil.comwrote: Kris Jones wrote on 2010-02-12: We've got a very busy legacy home-grown forum that since late August 2009 or so has been getting hit heavily by the Link-Building industry. Posting requires membership, which requires a captcha to be entered, and a confirmation email link to be clicked. Everyday, I search and invalidate hundreds of link-building memberships (the ones I can find). Interestingly, none of the links ever get posted -- we're using akismet, which does a pretty good job of stopping these. Kris - try http://www.stopforumspam.com/apis and look up the e-mail + ip in that database. And report any spammers that are not in that database already, to contribute to the anti-spam community! Cheers, Hugo -- Hugo Ahlenius - Hugo AhleniusE-Mail: hugo.ahlenius(at)nordpil.com Phone:+46 75 7575284 Nordpil Fax: +46 8 6747020 http://nordpil.com Mobile: +46 733 467111 Skype: callto:hugo.ahlenius vCard:http://nordpil.com/hugoahlenius.vcf - ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
What version of MySQL are you using? If it's a really old one that doesn't support subqueries, check out the MySQL docs. They have a section about rewriting subqueries into JOINs. cheers, barneyb On Mon, Feb 15, 2010 at 9:16 AM, Barry Mcconaghey bmcconag...@gmail.com wrote: Thanks Barney B. ERROR Message: Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count(*) from articles where zipcode = fddirectory.fdd_z Here is the cfquery: cfquery name=Story datasource=#dsn# SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev, (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount FROM fddirectory, states WHERE fddirectory.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND fddirectory.fdd_state = states.abrev ORDER BY fddirectory.fdd_name /cfquery Just add: (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount to the end of your SELECT clause: SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev , (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount FROM fddirectory, states WHERE fddirectory.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND fddirectory.fdd_state = states.abrev ORDER BY fddirectory.fdd_name That should do it for you, cheers, barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Phantom Scheduled Tasks
I have a scheduled task that starts a report every 12 minutes. Sometimes a report is started 5 minutes after the scheduled report starts. There is no evidence anywhere of the scheduled task being fired. There is no manual process starting the report. I have discovered long ago that modifying a scheduled task while it is running creates a phantom hidden task that can only be exorcised by rebooting the server. To allow reconfiguration of the task without worrying about this problem I wrote a process that can be configured. The scheduled task calls the process and acts according to its configuration. The scheduled task in question is set to fire a report process every twelve minutes. The process of the report can be followed in an application log. The desired report starts and is logged. At seemingly random times a report starts five minutes later. It is always five minutes never four or six etc. Again, there is no manual process starting this. There is no evidence of the scheduled task firing. There is no loop in the application that could start multiple reports with one url firing. What could be starting the report. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
I'm using MySQL 4.0.20. Is there any other way to total these two fields? Barry What version of MySQL are you using? If it's a really old one that doesn't support subqueries, check out the MySQL docs. They have a section about rewriting subqueries into JOINs. cheers, barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 - Google Maps - Center zoom
Eric. Thank You! After some fiddling, i got it. script type=text/javascript //![CDATA[ function load() { if (GBrowserIsCompatible()) { // It is necessary to make a setCenter call of some description before adding markers // At this point we dont know the real values // map.setCenter(new GLatLng(0,0),0); // = Start with an empty GLatLngBounds object = var bounds = new GLatLngBounds(); var startIcon = new GIcon(); startIcon.image = http://maps.gstatic.com/intl/en_us/mapfiles/ms/micons/red.png;; startIcon.shadow = http://maps.gstatic.com/intl/en_us/mapfiles/ms/micons/msmarker.shadow.png;; startIcon.iconSize = new GSize(32, 32); startIcon.shadowSize = new GSize(59, 32); startIcon.iconAnchor = new GPoint(32, 32); startIcon.infoWindowAnchor = new GPoint(5, 1); var partnerIcon = new GIcon(); partnerIcon.image = http://maps.gstatic.com/intl/en_us/mapfiles/ms/micons/green-dot.png;; partnerIcon.shadow = http://maps.gstatic.com/intl/en_us/mapfiles/ms/micons/msmarker.shadow.png;; partnerIcon.iconSize = new GSize(32, 32); partnerIcon.shadowSize = new GSize(59, 32); partnerIcon.iconAnchor = new GPoint(32, 32); partnerIcon.infoWindowAnchor = new GPoint(16, 1); // = Creates a marker at the given point with the given info window onclick = function createMarker(point, html) { var marker = new GMarker(point, partnerIcon); GEvent.addListener(marker, click, function() { marker.openInfoWindowHtml(html); }); return marker; } var map = new GMap2(document.getElementById(map)); map.setCenter(new GLatLng(cfoutput#fRez.latitude#,#fRez.longitude#/cfoutput)); map.addControl(new GSmallMapControl()); map.addControl(new GMapTypeControl()); // = This is the enterd address == var icon1 = new GIcon(startIcon); var point = new GLatLng(cfoutput#fRez.latitude#,#fRez.longitude#/cfoutput); map.addOverlay(new GMarker(point, icon1)); // = This is the results found within the radius passed. == cfoutput query=g_dis var myhtml = 'b#g_dis.partner_name#/b - cfif Len(g_dis.distance) (#round(g_dis.distance)# miles)/cfif'; var point = new GLatLng(#g_dis.latitude#,#g_dis.longitude#); map.addOverlay(createMarker(point, (myhtml))); // Each time a point is found, extent the bounds auto include it = bounds.extend(point); /cfoutput // = When all points are made - Set Bounds: = // = determine the zoom level from the bounds = map.setZoom(map.getBoundsZoomLevel(bounds)); // = determine the centre from the bounds == map.setCenter(bounds.getCenter()); } } //]] /script ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
You just need a JOIN and GROUP BY clause. Check out the subquery-to-join docs on MySQL's site. They have examples of how to do exactly what you want. cheers, barneyb On Mon, Feb 15, 2010 at 11:19 AM, Barry Mcconaghey bmcconag...@gmail.com wrote: I'm using MySQL 4.0.20. Is there any other way to total these two fields? Barry What version of MySQL are you using? If it's a really old one that doesn't support subqueries, check out the MySQL docs. They have a section about rewriting subqueries into JOINs. cheers, barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Server Outages/ Stops Responding
Hi All, We have a Coldfusion Application. We recently migrated to CF 8.01 as we were having server outage issues with CF MX 6.1. We thought that problems will be resolved but it didn't. We are having same outage issues. We don't know what happens (CF hangs, Jrun freezes etc.) in background but CF just stops processing requests. This has become a serious issue as we are losing customers due to that. Can anyone have any pointers. We have the following environment now. CF 8.01 Enterprise edition SQL Server 2000 IIS 6.0 Thanks! Sanjeev Singla ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT CF 8
Hey All, Can anyone at least confirm/deny that a page break (or something) is added after each CFDOCUMENTSECTION block? It seems that if my first CFDOCUMENTSECTION block ends half way down a page, the next CFDOCUMENTSECTION block will ALWAYS start its display at the top of the next page (leaving loads of empty space). This seems crazy to me (i.e. takes away formatting control). Anyone? Bueller? TIA Cheers On Sun, 2010-02-14 at 17:41 -0800, Bryan Stevenson wrote: Hey All, Here's my sample code: -- cfdocument format=FlashPaper pagetype=letter orientation=portrait !--- REPORT FOOTER --- cfdocumentitem type=footer REPORT FOOTER - should see at bottom of every page /cfdocumentitem !--- REPORT HEADER --- cfdocumentsection name=report header REPORT HEADER - should only see at top of first page /cfdocumentsection !--- RULE OUTPUT SECTION --- cfdocumentsection name=Rule Section cfdocumentitem type=header This is the Header - Should Repeat on Every Page /cfdocumentitem cfloop from=1 to=150 index=i RULE OUTPUTbr / /cfloop /cfdocumentsection /cfdocument -- I'm expecting output like this: -- REPORT HEADER - should only see at top of first page This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (new page auto-forced) This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (and so on as long as there is content for the Rule Section) - What I'm seeing: - REPORT HEADER - should only see at top of first page [BLANK PAGE] REPORT FOOTER - should see at bottom of every page This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (new page auto-forced) This is the Header - Should Repeat on Every Page RULE OUTPUT RULE OUTPUT RULE OUTPUT(to end of page) REPORT FOOTER - should see at bottom of every page (and so on as long as there is content for the Rule Section) - So it seems that CFDOCUMENTSECTION is filling the first page with whitespace...showing the footerthen showing me what I'd expect. It's that first blank page that is killing me. I tried removing the CFDOCUMENTSECTION tags around REPORT HEADER and then that text simply disappears (along with the blank page) Any thoughts? TIA Cheers 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: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Server Outages/ Stops Responding
Off the top of my head, there are THOUSANDS of possibilities in what could be wrong here: - Your database could be overwhelmed by too much traffic. Have you tracked it's current load? - You database design could be horribly flawed. Have you had a a DBA check your design and index structure? - What about hardware? Did you get new servers or are you using the same ones? - Does the database live on the same box as the web server? - How powerful is the hardware? - Do you have enough RAM? - How much traffic is your site taking on? Hundreds of visitors a day, thousands, millions? - You could be suffering from major architectural flaws in you application which is causing memory leaks. - Are you using a framework? Which one? Diagnosing the possible problems is nearly impossible here on the list given what little we know about your application. The first step in working out your problems will be to get some sort of analytics tools up and running on the application. Seefusion( http://www.seefusion.com/) or FusionReactor(http://www.fusion-reactor.com/) are both extremely helpful in determining possible problem areas in the app. Beyond that, there are 3rd party companies that do nothing but help people with this issue.Mike Brunt is one of the best at debugging ColdFusion Apps ( http://www.cfwhisperer.com/) No idea what he's fees($$) are, but I'm certain he's worth it, the man is brilliant. If you could at least post some info on your hardware setup we can at least give some advice on whether or not that could be the culprit and what you can do about those issues. =] On Mon, Feb 15, 2010 at 3:10 PM, SANJEEV SINGLA planetsanj...@gmail.comwrote: Hi All, We have a Coldfusion Application. We recently migrated to CF 8.01 as we were having server outage issues with CF MX 6.1. We thought that problems will be resolved but it didn't. We are having same outage issues. We don't know what happens (CF hangs, Jrun freezes etc.) in background but CF just stops processing requests. This has become a serious issue as we are losing customers due to that. Can anyone have any pointers. We have the following environment now. CF 8.01 Enterprise edition SQL Server 2000 IIS 6.0 Thanks! Sanjeev Singla ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT CF 8
OK...found it buried in the docsit does force a page break at the end of each document sectionpure insanity that this isn't optional!! Does anyone know of a way to override this behavior or are we simply stuck with creating docs with tonnes of whitespace and thus wasted paper when users print them?? Thanks! On Mon, 2010-02-15 at 14:48 -0800, Bryan Stevenson wrote: Hey All, Can anyone at least confirm/deny that a page break (or something) is added after each CFDOCUMENTSECTION block? It seems that if my first CFDOCUMENTSECTION block ends half way down a page, the next CFDOCUMENTSECTION block will ALWAYS start its display at the top of the next page (leaving loads of empty space). This seems crazy to me (i.e. takes away formatting control). Anyone? Bueller? TIA Cheers 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: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
Thanks Barney! The JOIN and GROUP clause might be over my head. Do I use a RecordCount? Barry You just need a JOIN and GROUP BY clause. Check out the subquery-to-join docs on MySQL's site. They have examples of how to do exactly what you want. cheers, barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Server Outages/ Stops Responding
You should also read the JVM Tuning section on my blog. It's free help that may get you going it the right direction. http://www.trunkful.com/index.cfm/JVM-Tuning Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
I think I'm getting closer. This code below works but I don't know how to total each fdd_name. For Example: ACME FD1 (38) ACME FD2 (30) ACME FD3 (20) cfquery name=Zip datasource=#dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state FROM articles a, fddirectory f WHERE a.zipcode = f.fdd_zip AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD GROUP BY f.fdd_name /cfquery cfoutput query=Zip #fdd_name# (Add Total Here)br /cfoutput Thanks, Barry You just need a JOIN and GROUP BY clause. Check out the subquery-to-join docs on MySQL's site. They have examples of how to do exactly what you want. cheers, barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfwindow looks different in cf9
some css overwrites? CF has darn near every HTML tag listed in there and zeroed out. Since cfwindow uses a type of reset css all the main tags padding, margins, padding, borders etc have been reset to 0, and the default inheritance tree from the browsers defaults have been reset to 0 and none etc... This is to maintain the same look cross platform, but it also poses issues of its own when trying to use what you are used to. I'd like to find a way to restate that the cfwindow code (on the page I invoke in the window) should use my main CSS style sheet in its entirety You best bet is to open up the page in Firebug and determine what classes you need to modify and re-define those before the display of the cfwindow. If you redefine any of the classes or defaults inline before your cfwindow call, the cfwindow will use those classes instead of the default. f you need it to use your main site css, you may need to dig around and look for the css that the cfwindow uses by default, then modify that direct, but I would try the former approach first. The reset css approach is becoming a standard way of setting up the base to apply css rules to, it does help the cross platform issues quite a bit, it is not magic, but it is a good way to deal with those padding/border issues. Hope that helps. -- /Kevin Pepperman ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330757 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
PCI Compliance Help
We just had a PCI Compliance scan done through SecurityMetrics and have one issue: Synopsis: The remote web server generates predictable session IDs Description: The remote web server generates a session ID for each connection. A session ID is typically used to keep track of the actions of a user while he visits a web site. The remote server generates non-random session IDs. An attacker might use this flaw to guess the session IDs of other users and therefore steal their session. We are using the UUID for CF Token that is set in the ColdFusion administrator and are also setting : SetClientCookies = No CLIENTMANAGEMENT = No in the cfapplication tag. We are hesitate to use J2EE session management as it might have a negative effect on other sites on our server. If anyone has any advice or experience with this same situation, your help is greatly appreciated. Thanks in advance! Deanna Schwint ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Total Two Field From Two Tables
Barry, Try this: cfquery name=Zip datasource=#dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state, count(distinct a.zipcode) as zip_count FROM articles a, fddirectory f WHERE a.zipcode = f.fdd_zip AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD GROUP BY a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state ORDER BY (whatever order you want them) /cfquery Let me know if this works or not for you. Not sure if it will work right in mySQL or not. If not, try this then: cfquery name=Zip datasource=#dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state FROM articles a, fddirectory f WHERE a.zipcode = f.fdd_zip AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD ORDER BY (whatever order you want them) /cfquery cfquery dbtype=query name= qZipTotals Select zipcode,count(*) as zip_count From Zip Group by zipcode Order by zipcode /cfquery ... now inside your loop, do this: cfloop query=Zip cfquery dbtype=query name=qGetThisZipCount Select zip_count from qZipTotals Where zipcode = cfqueryparam value=#Zip.zipcode# cfsqltype=cf_sql_varchar /cfquery cfoutput#fdd_name# (#qGetThisZipCount.zip_count#)br/cfoutput /cfloop This is using query of queries so you don't have to hit the database twice. There are a number of ways to accomplish this. Dave Phillips ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
Hi Dave. Thanks for the code! Those two did not work. I got two queries to work perfect but I don't know how to display them. !---Get all data--- cfquery name=Story datasource=#request.dsn# SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev FROMfddirectory F, states S WHERE F.fdd_state = cfqueryparam value=MD cfsqltype=CF_SQL_VARCHAR AND F.fdd_state = S.abrev ORDER BY fdd_name /cfquery !---Count each fdd_name--- cfquery name=Zip datasource=#request.dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, count(f.fdd_id) AS FDCount FROM articles a, fddirectory f WHERE a.zipcode = LEFT(f.fdd_zip, 5) AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD GROUP BY f.fdd_name ORDER BY f.fdd_name ASC /cfquery !---Display--- cfoutput query=zip #fdd_name# (#NumberFormat(zip.fdcount)# br /cfoutput This works great but it only displays fdd_name when a.zipcode = LEFT(f.fdd_zip, 5). I would like to display something like this: cfoutput !---Display all fdd_name--- #story.fdd_name# !---Display this if GT '0'--- (#NumberFormat(zip.fdcount)# br /cfoutput Thanks for your time. Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PCI Compliance Help
PCI reports that I've seen show the cookie in question that they think you are using to identify your sessions. The fact of the matter is how can the scanning company know what cookie values you are using to track sessions unless they can see your code. They can't unless they can successfully demonstrate a session highjacking with your server. That means they are guessing. That whole bit kind of irks me. I recently had a PCI scan that claimed I had the same problem. The thing was, the cookies their little automated scanner picked up had absolutely nothing to do with our session tracking and was a random cookie used only to help the load balancer keep server affinity. I was rather annoyed with that prognosis seeing as how any competent programmer worth his salt could look at my response headers and see the jsessionid in there, but a professional PCI compliance scanning company was charging us 600 dollars so their silly automatic scanner could pick up random cookies and assume they had anything at all to do with session tracking. Don't ask me how I really feel. :) So, what do you do? Well, firstly check the report again to see what cookies they think are you session ids. If you are using CFIDs, it probably picked that up because they are too dumb to read Adobe's technotes that clearly state CFID is NEVER used without CFTOKEN (which is random) to identify a session. (http://kb2.adobe.com/cps/404/kb404762.html) If you passed your scan, I wouldn't worry about it-- all you need is a passing grade. If you failed your scan and need to fix it, change to jssessionid and stop using CFID and CFTOKEN. If the cookie they are complaining about turns out NOT to be CFID, then consider refactoring so it is not in use or has a non-sequential value. Lastly, you can submit a rebuttal to them that basically says You don't know what you're talking about and here's why, and they might not make it count against you. ~Brad - Original Message - From: Deanna Schwint dea...@vimm.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, February 15, 2010 8:58 PM Subject: PCI Compliance Help We just had a PCI Compliance scan done through SecurityMetrics and have one issue: Synopsis: The remote web server generates predictable session IDs Description: The remote web server generates a session ID for each connection. A session ID is typically used to keep track of the actions of a user while he visits a web site. The remote server generates non-random session IDs. An attacker might use this flaw to guess the session IDs of other users and therefore steal their session. We are using the UUID for CF Token that is set in the ColdFusion administrator and are also setting : ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Broken images in CFADMIN
In my experience this happens when your CFIDE folder is not web-accessable, but you have a mapping for CFIDE in ColdFusion. The .cfm pages are resolving becuase CF is using the mapping it has, but when IIS is asked for an image (which doesn't involve CF), the path is non-existant. You need to confirm that the CFIDE/administrator directory is actually in the web root of the IIS site you are accessing. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Total Two Field From Two Tables
What didn't work with the second set of queries? Did you get an error message? That logic is sound. There might be some syntax issues as I didn't test it... Dave -Original Message- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Monday, February 15, 2010 10:28 PM To: cf-talk Subject: Re: Total Two Field From Two Tables Hi Dave. Thanks for the code! Those two did not work. I got two queries to work perfect but I don't know how to display them. !---Get all data--- cfquery name=Story datasource=#request.dsn# SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev FROMfddirectory F, states S WHERE F.fdd_state = cfqueryparam value=MD cfsqltype=CF_SQL_VARCHAR AND F.fdd_state = S.abrev ORDER BY fdd_name /cfquery !---Count each fdd_name--- cfquery name=Zip datasource=#request.dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, count(f.fdd_id) AS FDCount FROM articles a, fddirectory f WHERE a.zipcode = LEFT(f.fdd_zip, 5) AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD GROUP BY f.fdd_name ORDER BY f.fdd_name ASC /cfquery !---Display--- cfoutput query=zip #fdd_name# (#NumberFormat(zip.fdcount)# br /cfoutput This works great but it only displays fdd_name when a.zipcode = LEFT(f.fdd_zip, 5). I would like to display something like this: cfoutput !---Display all fdd_name--- #story.fdd_name# !---Display this if GT '0'--- (#NumberFormat(zip.fdcount)# br /cfoutput Thanks for your time. Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
Here is the error message: The string qZipTotals is not a valid ColdFusion variable name. Valid variable names must start with a letter and can only contain letter, numbers, and underscores. Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Server Outages/ Stops Responding
We are having same outage issues. We don't know what happens (CF hangs, Jrun freezes etc.) in background but CF just stops processing requests. 1) Buy SeeFusion for all you servers. 2) Configure database logging and active monitoring alerts 3) Analyze your traffic, memory, slow pages, slow queries, and stack traces 4) Re-factor as needed and go back to step 3 as long as problems persist. If all that sounds too complicated, it's a not really as bad as you think. If you don't have time, call WebApper and pay them to help you. They make SeeFusion, and Mike Brunt works for them so you can't go wrong. :) ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Total Two Field From Two Tables
Hi Dave. I fixed the last error message. There was a space here: name= qZipTotals Now the data is displaying but it is not correct. This code below (ZIP)is correct: !---Count each fdd_name--- cfquery name=Zip datasource=#request.dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, count(f.fdd_id) AS FDCount FROM articles a, fddirectory f WHERE a.zipcode = LEFT(f.fdd_zip, 5) AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD GROUP BY f.fdd_name ORDER BY f.fdd_name ASC /cfquery !---Display--- cfoutput query=zip #fdd_name# (#NumberFormat(zip.fdcount)# br /cfoutput This works great but it only displays fdd_name when a.zipcode = LEFT(f.fdd_zip, 5). I would like to display something like this: cfoutput !---Display all fdd_name--- #story.fdd_name# !---Display this if GT '0'--- (#NumberFormat(zip.fdcount)# br /cfoutput Thanks for your time. Barry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4