Re: special characters in mysql
thanks guys, still having trouble but have managed to upload content directly to the database (bypassing cms). tiny mce seems to be my problem now as it converts the correct content back to something else then i am back at the start. arrghh. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about next/prev browsing
Nathan Strutz wrote: 1) cache it in ColdFusion - just use the cachedWithin attribute of cfquery, it's easy, it works great. Set it to a day or 5 minutes or 1 minute or even 10 seconds if you're concerned about the data being out of date. This is Hey Nathan, The only think that I'm confused about is that if I'm using the caching, does it makes sense to retrieve all of the records? What if the user decides to jump to the end of the list... that would mean that I have to have the entire recordset cached, right? And remember, for server-side paging (next/prev buttons, etc), you should use my CFC - http://paginationcfc.riaforge.org/ Yeah, I've downloaded it, just haven't had a chance to play with it yet. Thanks! Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FireFox getElementById issue?
MemberName should have ID and NAME If it works in IE, that means that MemberName only has NAME since IE resolves the getElementById function to both the ID and NAME of the object in this code example, both selects will work in IE but only the second one will work in FF select name=MemberName onchange=alertList(); option value=/value option value=/value option value=/value /select select name=MemberName2 id=MemberName2 onchange=alertList2(); option value=/value option value=/value option value=/value /select script function alertList(){ var list = document.getElementById(MemberName); alert(list.options.length); } function alertList2(){ var list = document.getElementById(MemberName2); alert(list.options.length); } /script Austin Band wrote: Hello, I need a little help. I have javascript that works with IE but not FireFox. The code: script = Javascript1.2 function addItemsToParent(){ var MemberList= ; var list = document.getElementById(MemberName).value; for(var i=0; ilist.options.length; ++i) if(list.options[i].selected){ MemberList = MemberList + ,+list.options[i].value; } opener.document.MemberName.value = MemberList; self.close(); } /script The error returned in Error Console is that the list is null. This works correctly in IE. The goal is to select a name and it displays in the textbox ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: special characters in mysql
Might want to post *that* question to the TinyMCE forums...? http://tinymce.moxiecode.com/punbb/ (I looked through http://wiki.moxiecode.com/index.php/TinyMCE:Index and did not see anything obvious.) On Thu, Feb 19, 2009 at 2:21 AM, Mike Little m...@nzsolutions.co.nz wrote: thanks guys, still having trouble but have managed to upload content directly to the database (bypassing cms). tiny mce seems to be my problem now as it converts the correct content back to something else then i am back at the start. arrghh. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with cfinput tag - when validation on, field requires an entry
i have a cfform input tag for email address. it is not required that they enter one. on the script below, it works fine when they enter something in field but opens an invalid entry popup if field is left empty. i have required=no... also there are 4 email fields in the form: blm_eml1, blm_eml2.so on cfinput type=Text name=blm_eml1 validateat=onSubmit message=One of your Email addresses in invalid! validate=regular_expression pattern=^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$ required=No visible=Yes enabled=Yes showautosuggestloadingicon=False typeahead=No size=25 maxlength=50 class=style6a id=blm_eml1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strange rounding issue displaying numbers
Hi all, I have a weird issue with some number formatting, or more specifically I think it is a rounding issue. I have a cfc result that is being used in a query of queries, and the results are being output into a table of numeric values, like an invoice. On my local development environment the figures are displaying correctly using this code: #decimalformat(variables.qPayments.refundamt * variables.mult)# #NumberFormat(variables.qPayments.refundamt, __.__)# #LSNumberFormat(variables.qPayments.refundamt * variables.mult, __.__)# So a value of 24.95 will actually display as 24.95. As soon as I move the code to our testing server it rounds the numbers out! so the value becomes 24.00. Both servers are running cf8. Anyone got any ideas? Thanks Shaun McCran E: sh...@mccran.com W: www.mccran.co.uk _ Discover Bird's Eye View now with Multimap from Live Search http://clk.atdmt.com/UKM/go/111354026/direct/01/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with cfinput tag - when validation on, field requires an entry
The RegEx pattern is what's insisting on content there. Add a ? at the end of it to allow 0 or 1 of the pattern, and that should then allow the field to be blank. Something like: pattern=^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})?$ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with cfinput tag - when validation on, field requires an entry
Why not just use cfinput type=text name=blm_eml1 validate=email ? On Thu, Feb 19, 2009 at 6:42 AM, Jason Fisher ja...@wanax.com wrote: The RegEx pattern is what's insisting on content there. Add a ? at the end of it to allow 0 or 1 of the pattern, and that should then allow the field to be blank. Something like: pattern=^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})?$ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query Caching Limit?
The default limit in CF Admin for cached queries is 100. We do cache queries, but have had some issues with query timeout. Is there a larger limit I can set that would be reasonable? Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query Caching Limit?
On the issue of query time outs, some of the queries which have time out are really simple (e.g., select the top 2 rows, 10 fields from one table), so it's not related to the query. This started after our ISP moved the server to a new data center. All that has changed are the IPs of the servers. Is there anything specific we should be looking at? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Thursday, February 19, 2009 9:15 AM To: 'cf-talk@houseoffusion.com' Subject: Query Caching Limit? The default limit in CF Admin for cached queries is 100. We do cache queries, but have had some issues with query timeout. Is there a larger limit I can set that would be reasonable? Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP and SSL v3
Mary Jo, I think it would be the underlying protocol of Java not the web server - right? Does CF pass an HTTP request back through IIS or apache? I think it accesses the stack using it's own internal libraries. I guess we wait till they have a new test server ready eh? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mary Jo Sminkey [mailto:mary...@cfwebstore.com] Sent: Wednesday, February 18, 2009 8:38 PM To: cf-talk Subject: Re: CFHTTP and SSL v3 I'm confused SSL 3.0 does not necessarily need a client cert - does it? The connection would still use the public key right? Are you saying that Auth.net is requiring you to specify the client cert as a part of the handshake? Mark, I checked with AuthNet and you're right, they are not requiring a client cert. So it looks like this will be a bit less of a concern, assuming that CFHTTP is using the same protocol as the underlying web server (most of which are going to be at least v3.0). It may however still be a problem on some older CF versions, I would expect CF5 might have problems with it. In corresponding with AuthNet, they did say that they will try to roll out the requirement on the test server first so we can check our sites and make sure they are still working, but I don't have a date from them yet on when they expect to be able to do that. --- Mary Jo Sminkey CFWebstore, ColdFusion-based Ecommerce http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
AW: Query Caching Limit?
Robert, did you have any performance issues before? BTW: 100 queries is a very low number. I have seen servers that use the highest amount possible which was and it still wasn't enough... Anyway. Just imagine a query consisting out of 2 rows with let's say 25 columns each containing around 25 bytes - makes 2*25*25 = 1250 bytes or approx 1KB (plus some metadata so around 1.5KB). So with 100 queries you will have around 100KB to 150KB which is nothing at all!!! So you can really increase this number to a higher amount without any issue. If you are querying caching let's say 100 records the same structure you would be reserving around 10 MB which still is nothing. Just really calculate it a little yourself and then increase the number until it suits you. Now for your newly popped up issue you should definitely check the basic configuration. If you need help, then on or off list :-) Greetings from Switzerland Gert Franz Railo Technologies GmbH gert.fr...@railo.ch www.railo.ch Join our Mailing List german: http://de.groups.yahoo.com/group/railo/ english:http://groups.yahoo.com/group/railo_talk/ linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 Bug tracker:http://jira.jboss.org/jira/browse/RAILO Railo Blog: http://www.railo-technologies.com/blog -Ursprüngliche Nachricht- Von: Robert Harrison [mailto:rob...@austin-williams.com] Gesendet: Donnerstag, 19. Februar 2009 15:20 An: cf-talk Betreff: RE: Query Caching Limit? On the issue of query time outs, some of the queries which have time out are really simple (e.g., select the top 2 rows, 10 fields from one table), so it's not related to the query. This started after our ISP moved the server to a new data center. All that has changed are the IPs of the servers. Is there anything specific we should be looking at? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Thursday, February 19, 2009 9:15 AM To: 'cf-talk@houseoffusion.com' Subject: Query Caching Limit? The default limit in CF Admin for cached queries is 100. We do cache queries, but have had some issues with query timeout. Is there a larger limit I can set that would be reasonable? Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Binary output in CFContent ?
Ok, I think what I hear is this: If a user actually clicks on a link to the word document, then you're calling it read. So that's easy. On your DocDisplay.cfm (which I'm assuming is the file with the cfcontent) put in a SQL insert there to mark the document as read, then use your cfcontent to send the file. Then, on your page with the listing of the document, query the database to see if there's an entry for that user. Is that right? If it still doesn't make sense, let me know and I'll throw together some sample code. Thanks for the ideas. All I am after is when a user who will be authenticated by CF with the GAL I.E. cfset user = listLast(cgi.REMOTE_USER,\) If they have not read a document, on the docdisplay,.cfm page it will display next to the document listing 'not read', if they have opened the word doc and read it (could this be done by embedding a link to a cfm page in the word doc which would pass the users details to the database, and would set the status to 'viewed') i.e. ID, Name, LoginID, Document, Status, Date Then on the docdisplay.cfm page, next to the document it will display 'viewed' for that user.? Does this make sense, and is this the best way of implementing this? The problem I am having is in the link from the word doc to the cfm page to set the status and time etc, how could I do this? i.e. what parameters would I need to pass from the link in the word doc to the cfm page? Hope this makes sense? Hmmm Well, this is telling the browser to actually download the document. My only thought would be to do an inline word document with a frameset and have a frame at the top with your checkbox. I'm not exactly sure that's what you're looking for or even the most portable solution, but it might work. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about next/prev browsing
Our data is constantly changing so caching really wasn't an option and we saw no need to retrieve 10k records from the db but only show the user 25 or 50 or 100 of them at a time. So in Oracle you can set a start/limit in the query like so: (Might be a syntax error in there as I haven't had any coffee yet :-) ) Select * From ( Select rownum rnum, p.* From ( SELECT count(1) Over() totalCount, a.columns, b.columns FROM table a, table b WHERE a.id = b.id ORDER BY a.name ) p Where rownum = #Abs((start + Limit) - 1)# ) Where rnum = #start# The paging is simple enough to implement and even easier using EXT. Obviously if you're not using Oracle this won't work but I'm sure the other db's have a similar way to accomplish this. Nick On Thu, Feb 19, 2009 at 12:34 AM, Mike Soultanian msoul...@csulb.eduwrote: Nathan Strutz wrote: 1) cache it in ColdFusion - just use the cachedWithin attribute of cfquery, it's easy, it works great. Set it to a day or 5 minutes or 1 minute or even 10 seconds if you're concerned about the data being out of date. This is Hey Nathan, The only think that I'm confused about is that if I'm using the caching, does it makes sense to retrieve all of the records? What if the user decides to jump to the end of the list... that would mean that I have to have the entire recordset cached, right? And remember, for server-side paging (next/prev buttons, etc), you should use my CFC - http://paginationcfc.riaforge.org/ Yeah, I've downloaded it, just haven't had a chance to play with it yet. Thanks! Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange rounding issue displaying numbers
Have you checked the raw result coming back from the DB (i.e. #qPayments.refundamt#)? That might be the difference. cheers, barenyb On Thu, Feb 19, 2009 at 3:38 AM, shaun mccran houseoffus...@mccran.co.uk wrote: Hi all, I have a weird issue with some number formatting, or more specifically I think it is a rounding issue. I have a cfc result that is being used in a query of queries, and the results are being output into a table of numeric values, like an invoice. On my local development environment the figures are displaying correctly using this code: #decimalformat(variables.qPayments.refundamt * variables.mult)# #NumberFormat(variables.qPayments.refundamt, __.__)# #LSNumberFormat(variables.qPayments.refundamt * variables.mult, __.__)# So a value of 24.95 will actually display as 24.95. As soon as I move the code to our testing server it rounds the numbers out! so the value becomes 24.00. Both servers are running cf8. Anyone got any ideas? Thanks Shaun McCran E: sh...@mccran.com W: www.mccran.co.uk _ Discover Bird's Eye View now with Multimap from Live Search http://clk.atdmt.com/UKM/go/111354026/direct/01/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP and SSL v3
I think it would be the underlying protocol of Java not the web server - right? Does CF pass an HTTP request back through IIS or apache? I think it accesses the stack using it's own internal libraries. I guess we wait till they have a new test server ready eh? CF doesn't use the web server to send HTTP requests; it does this itself. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP and SSL v3
I think it would be the underlying protocol of Java not the web server - right? That would have been my assumption as well, the support from AuthNet seemed to think otherwise, but I certainly don't trust their knowledge of CF and its inner workings. Which still brings me back to trying to determine exactly *which* versions of CF do support SSL v3.0 by default. Like you, I'm hoping they get the test server ready sooner rather than later so we can run some tests with different versions and see what works and what doesn't and go from there. --- Mary Jo Sminkey CFWebstore, ColdFusion-based Ecommerce http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP and SSL v3
Mary Jo, Hmmm... You know the more I think of it the more I believe you should only be concerned about CF 5. SSL 3.0 came out in 1996 and I think it's the version that supports chaining certificates. I have certainly dealt with cert chain issues in both CF 6 and CF 7 - so I'm of a mind to believe those must be SSL 3.0 compliant. Also, I think that 3.0 can respond to 2.0 requests... It's really about dictating the encryption standard that's used. But perhaps Dave or someone can shed a bit more light on it. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mary Jo Sminkey [mailto:mary...@cfwebstore.com] Sent: Thursday, February 19, 2009 10:54 AM To: cf-talk Subject: Re: CFHTTP and SSL v3 I think it would be the underlying protocol of Java not the web server - right? That would have been my assumption as well, the support from AuthNet seemed to think otherwise, but I certainly don't trust their knowledge of CF and its inner workings. Which still brings me back to trying to determine exactly *which* versions of CF do support SSL v3.0 by default. Like you, I'm hoping they get the test server ready sooner rather than later so we can run some tests with different versions and see what works and what doesn't and go from there. --- Mary Jo Sminkey CFWebstore, ColdFusion-based Ecommerce http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP and SSL v3
Hmmm... You know the more I think of it the more I believe you should only be concerned about CF 5. SSL 3.0 came out in 1996 and I think it's the version that supports chaining certificates. I have certainly dealt with cert chain issues in both CF 6 and CF 7 - so I'm of a mind to believe those must be SSL 3.0 compliant. From what we've been able to determine in some limited testing, I would have to agree with that. Someone on the Railo list did a little test that showed that CF7, CF8 and Railo all did a connection using a v3 SSL cipher so we're fairly sure that those servers at least will be okay. --- Mary Jo Sminkey CFWebstore, ColdFusion-based Ecommerce http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and SSL v3
That would have been my assumption as well, the support from AuthNet seemed to think otherwise, but I certainly don't trust their knowledge of CF and its inner workings. Which still brings me back to trying to determine exactly *which* versions of CF do support SSL v3.0 by default. Like you, I'm hoping they get the test server ready sooner rather than later so we can run some tests with different versions and see what works and what doesn't and go from there. I think this is less a CF issue and more a JVM issue. It looks to me like 1.4.2 supports SSL3/TLS1, so you should be ok with any version of CF 6.x+ running on that. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL - Querying tax total for each month
MySQL 5 My client wants to run a report on taxes collected for a given month in a given year. I have a typical orders table with an âordertaxâ field and âorderdateâ field. Iâm remote right now so I canât test this, but how could I spit out order totals for each month. Hereâs what Iâm thinking⦠select month(orderdate), sum(ordertax) as totalMonthTaxes from tblorders where year(orderdate) = 2008 group by month(orderdate) order by month(orderdate) Any better ideas? Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8/Win/IIS: What do I need to run JSP's?
I teach high school comp sci. CF is our primary web development language, and I have a dev server running CF8 Standard, Windows 2003 Server, and IIS, but a student would like to explore JSP development. What's the best, most direct route to take to be able to run JSP's on the server? Is there a way in CF8 to essentially run JSP code on CF pages? I seem to remember that there was. Thanks Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Googlebot got me good last night...
This happened on a small site with a user admin system that's password protected. Seems Googlebot managed to get into the admin system last night, started crawling admin pages, and ended up munging half the database: 1. Clicking archive or mark inactive buttons on admin area index pages 2. In a few cases, actually seemed to SUBMIT a form, updating data. I'm still scratching my head over how Googlebot got into the admin system to start with. It looks legit from the logs. The IP address, user-agent and everything else checks out. Luckily, this isn't a mission-critical site, and database backups are done nightly, but now it's got me worried for other sites. Googlebot has *never* caused any problems with password protected admin systems before, my robots.txt file usually excludes the admin folder (and you can be sure I'm checking the ones I'm not sure about right now) and the login stuff I use I thought was pretty standard. My login code is below. Tell me I'm a complete idiot. So, 1. Anybody else have this problem recently? 2. I'm an idiot I guess, how *should* I be doing my login systems? (One site on CF8, others still CF7) 4. If you're doing anything like I am, then maybe we're *all* idiots at this point and need to redo our login pages to use whatever somebody much smarter than I says to do in #2 above. - Application.cfm page for the admin folder: - !--- Define that this user is logged out by default --- CFPARAM NAME=session.allowin DEFAULT=false !--- Define this user id to zero by default --- CFPARAM NAME=session.user_id DEFAULT=0 !--- If the variable session.allowin does not equal true, send user to the login page --- cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../admin_login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- Not logged in, alert user and redirect --- script !---alert(You must login to access this area!);--- self.location=../admin_login.cfm; /script /cfif /cfif - login_process page: - **QUERY TO CHECK USER/PASS HERE cfif Verify.RecordCount !--- logged in ... set the value of the session.allowin value --- cfset session.allowin = True / cfset session.user_id = Verify.id / script self.location=idx_admin.cfm; /script cfelse !--- not logged in, redirect to the login page --- script alert(Your credentials could not be verified, please try again!!!); self.location=../admin_login.cfm; /script /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319536 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/Win/IIS: What do I need to run JSP's?
What's the best, most direct route to take to be able to run JSP's on the server? Create a JSP page and run it. CF server runs JSP's out of the box. I am not sure about running JSP code on a CF page. G! On Thu, Feb 19, 2009 at 2:36 PM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: I teach high school comp sci. CF is our primary web development language, and I have a dev server running CF8 Standard, Windows 2003 Server, and IIS, but a student would like to explore JSP development. What's the best, most direct route to take to be able to run JSP's on the server? Is there a way in CF8 to essentially run JSP code on CF pages? I seem to remember that there was. Thanks Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319537 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/Win/IIS: What do I need to run JSP's?
If you install the developer version of ColdFusion in either multi-home or j2ee flavors so that you get the full, underlining JRun server, you can then use it has a JSP server. You can also install anything like Tomcat to the same affect. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
Yeah, I hate to say it but Your problem is that you are relying on Javascript as your security. Anybody an tell their browser to ignore your security, thus they will not get redirected to the login page. You need to either use cflocation to redirect them to your login page or a cfinclude of the login page followed by cfabort. Ideally, this login check code is in your application.cfm or Application.cfc. These changes will prevent this kind on unwanted access as they will occur on the server side processing rather than on the client side processing. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../admin_login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- Not logged in, alert user and redirect --- script !---alert(You must login to access this area!);--- self.location=../admin_login.cfm; /script /cfif /cfif Why are you using JS? I usually cfinclude the login form. Never rely on JS for anything like this. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Googlebot got me good last night...
Turn off Javascript in your browser and then try to use your admin pages. It looks like your security 'requires' javascript to be turned on. Spiders tend to ignore javascript entirely. I would change the javascript 'self.location' to a 'cflocation' tag. This will force the browser to the login page. William -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Thursday, February 19, 2009 12:10 PM To: cf-talk Subject: Googlebot got me good last night... This happened on a small site with a user admin system that's password protected. Seems Googlebot managed to get into the admin system last night, started crawling admin pages, and ended up munging half the database: 1. Clicking archive or mark inactive buttons on admin area index pages 2. In a few cases, actually seemed to SUBMIT a form, updating data. I'm still scratching my head over how Googlebot got into the admin system to start with. It looks legit from the logs. The IP address, user-agent and everything else checks out. Luckily, this isn't a mission-critical site, and database backups are done nightly, but now it's got me worried for other sites. Googlebot has *never* caused any problems with password protected admin systems before, my robots.txt file usually excludes the admin folder (and you can be sure I'm checking the ones I'm not sure about right now) and the login stuff I use I thought was pretty standard. My login code is below. Tell me I'm a complete idiot. So, 1. Anybody else have this problem recently? 2. I'm an idiot I guess, how *should* I be doing my login systems? (One site on CF8, others still CF7) 4. If you're doing anything like I am, then maybe we're *all* idiots at this point and need to redo our login pages to use whatever somebody much smarter than I says to do in #2 above. - Application.cfm page for the admin folder: - !--- Define that this user is logged out by default --- CFPARAM NAME=session.allowin DEFAULT=false !--- Define this user id to zero by default --- CFPARAM NAME=session.user_id DEFAULT=0 !--- If the variable session.allowin does not equal true, send user to the login page --- cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../admin_login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- Not logged in, alert user and redirect --- script !---alert(You must login to access this area!);--- self.location=../admin_login.cfm; /script /cfif /cfif - login_process page: - **QUERY TO CHECK USER/PASS HERE cfif Verify.RecordCount !--- logged in ... set the value of the session.allowin value --- cfset session.allowin = True / cfset session.user_id = Verify.id / script self.location=idx_admin.cfm; /script cfelse !--- not logged in, redirect to the login page --- script alert(Your credentials could not be verified, please try again!!!); self.location=../admin_login.cfm; /script /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
I don't believe the googlebot can be stopped by Javascript, and nevertheless it's probably never a really good idea to prevent access to admin pages with JS only as disabling Javascript is relatively easy. Using cflocation would probably take care of it, though, and effectively redirects the user (or bot) to the appropriate page. Francois Levesque http://blog.critical-web.com/ On Thu, Feb 19, 2009 at 3:09 PM, Les Mizzell lesm...@bellsouth.net wrote: This happened on a small site with a user admin system that's password protected. Seems Googlebot managed to get into the admin system last night, started crawling admin pages, and ended up munging half the database: 1. Clicking archive or mark inactive buttons on admin area index pages 2. In a few cases, actually seemed to SUBMIT a form, updating data. I'm still scratching my head over how Googlebot got into the admin system to start with. It looks legit from the logs. The IP address, user-agent and everything else checks out. Luckily, this isn't a mission-critical site, and database backups are done nightly, but now it's got me worried for other sites. Googlebot has *never* caused any problems with password protected admin systems before, my robots.txt file usually excludes the admin folder (and you can be sure I'm checking the ones I'm not sure about right now) and the login stuff I use I thought was pretty standard. My login code is below. Tell me I'm a complete idiot. So, 1. Anybody else have this problem recently? 2. I'm an idiot I guess, how *should* I be doing my login systems? (One site on CF8, others still CF7) 4. If you're doing anything like I am, then maybe we're *all* idiots at this point and need to redo our login pages to use whatever somebody much smarter than I says to do in #2 above. - Application.cfm page for the admin folder: - !--- Define that this user is logged out by default --- CFPARAM NAME=session.allowin DEFAULT=false !--- Define this user id to zero by default --- CFPARAM NAME=session.user_id DEFAULT=0 !--- If the variable session.allowin does not equal true, send user to the login page --- cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../admin_login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- Not logged in, alert user and redirect --- script !---alert(You must login to access this area!);--- self.location=../admin_login.cfm; /script /cfif /cfif - login_process page: - **QUERY TO CHECK USER/PASS HERE cfif Verify.RecordCount !--- logged in ... set the value of the session.allowin value --- cfset session.allowin = True / cfset session.user_id = Verify.id / script self.location=idx_admin.cfm; /script cfelse !--- not logged in, redirect to the login page --- script alert(Your credentials could not be verified, please try again!!!); self.location=../admin_login.cfm; /script /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
Just another note on this. I've heard of people setting up proxies that ignored all redirect headers sent back to them. This means that if you use cflocation to locate to your login page, you should also ensure that the requested page does not show up should the cflocation fail. ie. cflocation url=/login /cfabort / Or somesuch. Dominic 2009/2/19 Alan Rother alan.rot...@gmail.com: You need to either use cflocation to redirect them to your login page or a cfinclude of the login page followed by cfabort. Ideally, this login check code is in your application.cfm or Application.cfc. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion Hosts
I am trying to find a decent CF8 hosting company that offers SQL Server. The company I am working with now (remotely) does not have a dev server, so I am looking for something that is going to have very little traffic, simply just allowing him to review. No email is needed, etc Thanks! I've had a lot of very good experience with CFDynamics.com. While they're not the cheapest, they have extremely good service. http://www.cfdynamics.com regards, larry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
How about: --- login process: --- cfif qVerify.RecordCount !--- LOGGED IN --- cfset session.allowin = True / cfset session.user_id = qVerify.id / cflocation url=idx_admin.cfm / cfelse !--- NOT LOGGED IN --- script alert(Your credentials could not be verified, please try again!!!); /script cflocation url=../login.cfm / cfabort /cfif --- Application --- CFPARAM NAME=session.allowin DEFAULT=false cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- NOT LOGGED IN --- cflocation url=../login.cfm / /cfif /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
Plus Google usually abides by robots.txt. Make sure you disallow your admin pages/folders to all bots. At least this will stop the honest ones. Wil Genovese On Thu, Feb 19, 2009 at 2:41 PM, Dominic Watson watson.domi...@googlemail.com wrote: Just another note on this. I've heard of people setting up proxies that ignored all redirect headers sent back to them. This means that if you use cflocation to locate to your login page, you should also ensure that the requested page does not show up should the cflocation fail. ie. cflocation url=/login /cfabort / Or somesuch. Dominic 2009/2/19 Alan Rother alan.rot...@gmail.com: You need to either use cflocation to redirect them to your login page or a cfinclude of the login page followed by cfabort. Ideally, this login check code is in your application.cfm or Application.cfc. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
Dominic Watson wrote: Just another note on this. I've heard of people setting up proxies that ignored all redirect headers sent back to them. This means that if you use cflocation to locate to your login page, you should also ensure that the requested page does not show up should the cflocation fail. ie. When CFLOCATION is used, ColdFusion sets the location header in the response, doesn't send any page output that would normally get sent, and stops processing the page. Essentially, there's an implied CFABORT when you use CFLOCATION so it's not required to have one in your code. -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
Les Mizzell wrote: !--- NOT LOGGED IN --- script alert(Your credentials could not be verified, please try again!!!); /script cflocation url=../login.cfm / cfabort Since CFLOCATION won't send your JavaScript output, you'll need to pass your message along on the URL and have the login page look for it/display it instead. The CFABORT isn't required either. cflocation url=../login.cfm?msg=#URLEncodedFormat('Your credentials...')# / In login.cfm... cfif isDefined(url.msg) and len(trim(url.msg)) script type=text/javascript alert('cfoutput#JSStringFormat(trim(url.msg))#/cfoutput'); /script /cfif -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
So, 1. Anybody else have this problem recently? 2. I'm an idiot I guess, how *should* I be doing my login systems? (One site on CF8, others still CF7) 4. If you're doing anything like I am, then maybe we're *all* idiots at this point and need to redo our login pages to use whatever somebody much smarter than I says to do in #2 above. 1. Not that I've heard about. 2. As others have said, JavaScript != Security. You have much to learn, young padawan, but you are in the right place. The fact that you are reaching out (and have a database backup!) means you are on the right path. 3. No #3? I'm curious about what happened to #3. 4. I haven't seen anything like this in a while, but I seem to recall some of my own code being, um, not so great, way back when I first got started. -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfinclude template issues
First, I have no clue about CF. We had a developer make a site in CF and now he is gone. I'm simply trying to add a new page to the existing site and it does not work. Here is the response that I get: Could not find the included template /products/bf.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred in D:\inetpub\wwwroot\server.com\products\index.cfm: line 101 101 :td colspan=3 rowspan=6 valign=top bgcolor=#5E5E5Ecfinclude template=#GetPageContent.PageInclude#/td If I look at the template #GetPageContent.PageInclude# it goes to this: cfquery name=GetPageContent datasource=web SELECT * FROM dbo.ProductPages WHERE PageID = '#URL.p#' /cfquery which is at the top of the index.cfm file. All other pages that were made this way work, except any new ones I create. I have to be missing something that is not making this work.. Any ideas on where I can start looking? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319550 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/Win/IIS: What do I need to run JSP's?
Create a JSP page and run it. CF server runs JSP's out of the box. I am not sure about running JSP code on a CF page. CF Standard doesn't execute JSPs or servlets, if I recall correctly. That requires CF Enterprise/Developer/Trial. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
Just another note on this. I've heard of people setting up proxies that ignored all redirect headers sent back to them. This means that if you use cflocation to locate to your login page, you should also ensure that the requested page does not show up should the cflocation fail. ie. cflocation url=/login /cfabort / CFLOCATION aborts the processing of the current page. Any output generated before the CFLOCATION may be shown if the user agent doesn't follow the redirection. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinclude template issues
You need to add the filename of the page you're adding to the PageInclude column of the database table (dbo.ProductPages), and a then pass the pageID code of the new item to index.cfm (index.cfm?p=[PageID]). On second glance, it looks like you may have already done this part--your message says it cannot find /products/bf.cfm. Maybe the file you created needs to be in a different location in the file system? You'll also probably want to wash the URL param p before passing it into your database, using cfqueryparam, otherwise you subject yourself to SQL injection attacks. cfquery name=GetPageContent datasource=web SELECT * FROM dbo.ProductPages WHERE PageID = cfqueryparam cfsqltype=cf_sql_integer value=#url.p# /cfquery On Thu, Feb 19, 2009 at 3:22 PM, Scott Weber swe...@thanksal.com wrote: First, I have no clue about CF. We had a developer make a site in CF and now he is gone. I'm simply trying to add a new page to the existing site and it does not work. Here is the response that I get: Could not find the included template /products/bf.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred in D:\inetpub\wwwroot\server.com\products\index.cfm: line 101 101 :td colspan=3 rowspan=6 valign=top bgcolor=#5E5E5Ecfinclude template=#GetPageContent.PageInclude#/td If I look at the template #GetPageContent.PageInclude# it goes to this: cfquery name=GetPageContent datasource=web SELECT * FROM dbo.ProductPages WHERE PageID = '#URL.p#' /cfquery which is at the top of the index.cfm file. All other pages that were made this way work, except any new ones I create. I have to be missing something that is not making this work.. Any ideas on where I can start looking? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfinclude template issues
CF uses / to indicate a mapping (an alias to a specific location). by default, the / alone is a mapping to the web root. in the CF Admin, you can set up additional mappings, such that /products could point to c:\inetpub\wwwroot\foo\bar\products since you're using /products/bf.cfm, unless there is a mapping set up for /products, that would look in your web root for a folder called 'products' and a file inside called 'bf.cfm'. if you're using a mapping (either in the Admin or, if you're on CF 8 it could be in the Application.cfc), you'd need to see what the mapping for '/products' points to (and then look in that location for 'bf.cfm'). On Thu, Feb 19, 2009 at 1:22 PM, Scott Weber swe...@thanksal.com wrote: First, I have no clue about CF. We had a developer make a site in CF and now he is gone. I'm simply trying to add a new page to the existing site and it does not work. Here is the response that I get: Could not find the included template /products/bf.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred in D:\inetpub\wwwroot\server.com\products\index.cfm: line 101 101 :td colspan=3 rowspan=6 valign=top bgcolor=#5E5E5Ecfinclude template=#GetPageContent.PageInclude#/td If I look at the template #GetPageContent.PageInclude# it goes to this: cfquery name=GetPageContent datasource=web SELECT * FROM dbo.ProductPages WHERE PageID = '#URL.p#' /cfquery which is at the top of the index.cfm file. All other pages that were made this way work, except any new ones I create. I have to be missing something that is not making this work.. Any ideas on where I can start looking? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfinclude template issues
Hi Scott After your /cfquery, add this to see exactly what the query is returning: cfdump var=#GetPageContent# cfabort The first line will dump the query (or any variable, which is very handy), and cfabort will end the page (before the error hits). If the dump doesn't show a column called PageInclude, or if that value doesn't look like a decent template name, then this query (or something) is the problem. (Remove the debugging code when you're done.) If the query looks right then add a simple cfinclude template=... and hard-code the query's value as the template. Follow this by cfabort and your page should do the cfinclude and then stop; if you get an error then the template you are trying to include is either missing or not reachable from your page. (You can put this tag near the top of the page... All you want to verify is that cfinclude works or doesn't. Remove the cfinclude after the test.) Post your results. Thanks Mark -Original Message- From: Scott Weber [mailto:swe...@thanksal.com] Sent: Thursday, February 19, 2009 4:23 PM To: cf-talk Subject: cfinclude template issues First, I have no clue about CF. We had a developer make a site in CF and now he is gone. I'm simply trying to add a new page to the existing site and it does not work. Here is the response that I get: Could not find the included template /products/bf.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred in D:\inetpub\wwwroot\server.com\products\index.cfm: line 101 101 :td colspan=3 rowspan=6 valign=top bgcolor=#5E5E5Ecfinclude template=#GetPageContent.PageInclude#/td If I look at the template #GetPageContent.PageInclude# it goes to this: cfquery name=GetPageContent datasource=web SELECT * FROM dbo.ProductPages WHERE PageID = '#URL.p#' /cfquery which is at the top of the index.cfm file. All other pages that were made this way work, except any new ones I create. I have to be missing something that is not making this work.. Any ideas on where I can start looking? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8/Win/IIS: What do I need to run JSP's?
CF server runs JSP's out of the box. Strike that. The CF server standard (stand alone install) will not run JSP's and will throw 500 A License Exception has been thrown error ( tested on CF7). But on my evaluation version it ran fine. According to Kristen Schofield, ColdFusion Enterprise is free for learning purposes and that includes the multi-home and j2ee versions. http://www.webbschofield.com/index.cfm/2008/9/2/ColdFusion-8-Now-Available-to-Students-and-Educators-for-Free So you are good to go with that. Sorry for the misinformation. G! On Thu, Feb 19, 2009 at 3:15 PM, Gerald Guido gerald.gu...@gmail.comwrote: What's the best, most direct route to take to be able to run JSP's on the server? Create a JSP page and run it. CF server runs JSP's out of the box. I am not sure about running JSP code on a CF page. G! -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFuison Course display
I have a code that i wrote looking for the specific courses and check for the completion. Now the requirenment has changed. 4. Date Rule: This will have a number of possibilities. 0: Ignore start and end dates. Display this course for all EDITs 1: This course will be displayed to an edit if the EDIT date is after the Start date. 2: This course will be displayed to an edit if the EDIT date is before the End date. 3: This course will be displayed to an edit if the EDIT date is between the Start date and the End date. 5. Equivalent Course: Chosen from a dropdown list of all Sunrise courses. If the main course has been completed display that one. If the main course has not been completed but the Equivalent one has, then display the equivalent one. If neither have been done then display main course but without a completion date. The EDIT may put in a completion if course rules allow this. Note the date rules still apply. The Equivalent course is to be a list of courses. This will allow a course to be equivalent to 2 or 3 courses. If displaying the Equivalents display all the courses in the list. 6. Online: Yes or no. Display only this is automated by the system and cannot be set by the Administrator. If the course is an online course the EDIT will not be able to input a completion date. This completion date will then be automated. The Equivalent stored in the list. How would I achieve this code change Here is my current code !--- Get employee --- cfquery name=getEmployee datasource=cfelsunrise dbtype=ODBC select * from Employee e Join EmployeeJobHistory h on e.EmployeeID = h.EmployeeID inner join JobAssignment a on (h.sequence = a.sequence and a.EndDate is NULL) inner join Location l ON l.LocationID = a.LocationID inner join JobCode_List j on h.JobCode = j.JobCode where e.terminationdate is NULL and e.EmployeeID = #sel_EmpID# Order by a.startDate DESC /cfquery cfquery name=getDynamicCourses datasource=cfelsunrise Select d.Courseid,d.ISoNLINE,c.description,c.name,d.equivalentto from DynamicCourseList d inner join Course_catalog c on c.courseID = d.courseID where whatFor = 'EDIT' /cfquery cfset lstartDt = DateFormat(getEmployee.StartDate, mm/dd/yy) cfset ReqCourseNrray = ArrayNew(1) cfset ReqCourserray = ArrayNew(1) cfset ReqdEquivalentCourserray = ArrayNew (1) cfif getDynamicCourses.recordcount gt 0 cfloop query=getDynamicCourses cfset ArrayAppend(ReqCourseNrray, #getDynamicCourses.description#) cfset ArrayAppend(ReqCourserray, #getDynamicCourses.name#) /cfloop /cfif ! get non-requiredmtraining --- cfset lLast_Name = getEmployee.Last_Name cfset lFirst_Name = getEmployee.First_Name cfset lmiddle_Name = getEmployee.middle_Name cfset lEmployeeID = getEmployee.EmployeeID cfset lName = getEmployee.Name cfset lState = getEmployee.State cfset lDeptName = getEmployee.DeptName cfset lBusiness = getEmployee.Business cfset lHireDate = getEmployee.HireDate cfset lServiceDate = getEmployee.ServiceDate cfset lReHireDate = getEmployee.ReHireDate cfset lpositionDate = getEmployee.StartDate cfset reqdHrs = 0 cfset reqdHrsCompl = 0 cfset TotalHrs = 0 !--- Display info --- div align=center !--- If Basic, display the current page. If book, include the book page if misc, include misc page --- cfset lasttg = ** table width=100% align=center border=0 tr td align=center valign=bottomfont size=2bCourse/Certification /b/font/td td width=11 align=left valign=bottomfont size=2bAttended/b/font/td td valign=bottom align=leftfont size=2bFacilitator/SME/b/font/td td valign=bottom
RE: cfinclude template issues
All existing pages work. I'm just copying the way he did it on the old pages. I add an entry into the DB and point it to this file which is in the same sub folder as the other working ones. I added that code and on the working pages, nothing happened. On the new page I added I got the same debug message at the bottom like I posted previously. I will try your second option and see, but like I said all other pages are working. -Original Message- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: Thursday, February 19, 2009 3:52 PM To: cf-talk Subject: RE: cfinclude template issues Hi Scott After your /cfquery, add this to see exactly what the query is returning: cfdump var=#GetPageContent# cfabort The first line will dump the query (or any variable, which is very handy), and cfabort will end the page (before the error hits). If the dump doesn't show a column called PageInclude, or if that value doesn't look like a decent template name, then this query (or something) is the problem. (Remove the debugging code when you're done.) If the query looks right then add a simple cfinclude template=... and hard-code the query's value as the template. Follow this by cfabort and your page should do the cfinclude and then stop; if you get an error then the template you are trying to include is either missing or not reachable from your page. (You can put this tag near the top of the page... All you want to verify is that cfinclude works or doesn't. Remove the cfinclude after the test.) Post your results. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFuison Course display
http://www.catb.org/~esr/faqs/smart-questions.html ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfinclude template issues
I got it all figured it and im pretty much a dumb azz... Sorry for the interruption.. It's all my fault. I guess I now know more about CF then I did yesterday... Scott -Original Message- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: Thursday, February 19, 2009 3:52 PM To: cf-talk Subject: RE: cfinclude template issues Hi Scott After your /cfquery, add this to see exactly what the query is returning: cfdump var=#GetPageContent# cfabort The first line will dump the query (or any variable, which is very handy), and cfabort will end the page (before the error hits). If the dump doesn't show a column called PageInclude, or if that value doesn't look like a decent template name, then this query (or something) is the problem. (Remove the debugging code when you're done.) If the query looks right then add a simple cfinclude template=... and hard-code the query's value as the template. Follow this by cfabort and your page should do the cfinclude and then stop; if you get an error then the template you are trying to include is either missing or not reachable from your page. (You can put this tag near the top of the page... All you want to verify is that cfinclude works or doesn't. Remove the cfinclude after the test.) Post your results. Thanks Mark -Original Message- From: Scott Weber [mailto:swe...@thanksal.com] Sent: Thursday, February 19, 2009 4:23 PM To: cf-talk Subject: cfinclude template issues First, I have no clue about CF. We had a developer make a site in CF and now he is gone. I'm simply trying to add a new page to the existing site and it does not work. Here is the response that I get: Could not find the included template /products/bf.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred in D:\inetpub\wwwroot\server.com\products\index.cfm: line 101 101 :td colspan=3 rowspan=6 valign=top bgcolor=#5E5E5Ecfinclude template=#GetPageContent.PageInclude#/td If I look at the template #GetPageContent.PageInclude# it goes to this: cfquery name=GetPageContent datasource=web SELECT * FROM dbo.ProductPages WHERE PageID = '#URL.p#' /cfquery which is at the top of the index.cfm file. All other pages that were made this way work, except any new ones I create. I have to be missing something that is not making this work.. Any ideas on where I can start looking? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Best practice - registration activation by email
Just wondering how others are dealing with public member signups that require an email activation? What I'm doing on a new site that I recently set up is sending out the activation as soon as someone registers. If a user tries to login with an account still in the unactivated state, they're shown an appropriate error message and given the option of having another activation email sent to them. I expire the unactivated accounts after 48 hours, deleting them completely from the books. This should allow someone to re-register using the same email address, in case their activation email was lost, overlooked, or caught by a spam filter. Other approaches? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfinclude template issues
No problem, this is a good list so feel free to ask more questions. -- Josh -Original Message- From: Scott Weber [mailto:swe...@thanksal.com] Sent: Thursday, February 19, 2009 2:52 PM To: cf-talk Subject: RE: cfinclude template issues I got it all figured it and im pretty much a dumb azz... Sorry for the interruption.. It's all my fault. I guess I now know more about CF then I did yesterday... Scott -Original Message- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: Thursday, February 19, 2009 3:52 PM To: cf-talk Subject: RE: cfinclude template issues Hi Scott After your /cfquery, add this to see exactly what the query is returning: cfdump var=#GetPageContent# cfabort The first line will dump the query (or any variable, which is very handy), and cfabort will end the page (before the error hits). If the dump doesn't show a column called PageInclude, or if that value doesn't look like a decent template name, then this query (or something) is the problem. (Remove the debugging code when you're done.) If the query looks right then add a simple cfinclude template=... and hard-code the query's value as the template. Follow this by cfabort and your page should do the cfinclude and then stop; if you get an error then the template you are trying to include is either missing or not reachable from your page. (You can put this tag near the top of the page... All you want to verify is that cfinclude works or doesn't. Remove the cfinclude after the test.) Post your results. Thanks Mark -Original Message- From: Scott Weber [mailto:swe...@thanksal.com] Sent: Thursday, February 19, 2009 4:23 PM To: cf-talk Subject: cfinclude template issues First, I have no clue about CF. We had a developer make a site in CF and now he is gone. I'm simply trying to add a new page to the existing site and it does not work. Here is the response that I get: Could not find the included template /products/bf.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred in D:\inetpub\wwwroot\server.com\products\index.cfm: line 101 101 :td colspan=3 rowspan=6 valign=top bgcolor=#5E5E5Ecfinclude template=#GetPageContent.PageInclude#/td If I look at the template #GetPageContent.PageInclude# it goes to this: cfquery name=GetPageContent datasource=web SELECT * FROM dbo.ProductPages WHERE PageID = '#URL.p#' /cfquery which is at the top of the index.cfm file. All other pages that were made this way work, except any new ones I create. I have to be missing something that is not making this work.. Any ideas on where I can start looking? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinclude template issues
On Thu, Feb 19, 2009 at 2:51 PM, Scott Weber swe...@thanksal.com wrote: I guess I now know more about CF then I did yesterday... That's a good thing :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
Aha - that kicks ass :) I wish I knew that when I was having a discussion with the php developer telling me about the proxy ignoring headers while he was also dissing cf! Next time. 2009/2/19 Dave Watts dwa...@figleaf.com: CFLOCATION aborts the processing of the current page. Any output generated before the CFLOCATION may be shown if the user agent doesn't follow the redirection. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
You have much to learn, young padawan, but you are in the right place. You're telling me. Fusebox 5.x has me tearing my hair out. Maybe somebody will release Dummies Guide to Fusebox at some point. I'm going to need it ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
read the fusebox 4 book from techspedition. While it's not completely up-to-date, I think it would still help on the conceptual level. FB 5.x still maintains backwards compatibility with 4.x applications with some new features added, as documented on the FB site. btw, if you want to make your life easier, check out FuseBuilder. It's definitely the best thing since sliced bread!! Mike Les Mizzell wrote: You have much to learn, young padawan, but you are in the right place. You're telling me. Fusebox 5.x has me tearing my hair out. Maybe somebody will release Dummies Guide to Fusebox at some point. I'm going to need it ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about next/prev browsing
Ehh.. I'd rather do it at the CF level right now, but I appreciate the suggestion.. thanks, Mike Nick Giovanni wrote: I'd do it at the DB level, easy to implement in Oracle not sure about the others. On Wed, Feb 18, 2009 at 11:48 AM, Mike Soultanian msoul...@csulb.eduwrote: If I have a table with 60,000 records - should I use query caching for the next/prev browsing, or should I pull the next/prev page of records every time the user presses the next/prev buttons? I'm leaning towards the latter as it just seems to make more sense memory-wise. Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
http://tech.groups.yahoo.com/group/fusebox5/ On Thu, Feb 19, 2009 at 3:53 PM, Les Mizzell lesm...@bellsouth.net wrote: You're telling me. Fusebox 5.x has me tearing my hair out. Maybe somebody will release Dummies Guide to Fusebox at some point. I'm going to need it ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
Les Mizzell wrote: You have much to learn, young padawan, but you are in the right place. You're telling me. Fusebox 5.x has me tearing my hair out. Maybe somebody will release Dummies Guide to Fusebox at some point. I'm going to need it There used to be books on Fusebox several years ago. I had a copy of Discovering Fusebox 4 when it first came out in 2003. I switched jobs in 2005 to a company that doesn't use Fusebox, so I've been out of the loop on new developments since then. It appears the books didn't get updated though which is unfortunate. -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best practice - registration activation by email
Jim McAtee wrote: Just wondering how others are dealing with public member signups that require an email activation? I've essentially done the same thing at DtDNS for ten years without any trouble. If they try to log in they get the error and are directed to the lost password routine. If this is used for a non-activated account it just sends a new copy of the activation code instead of the password. Accounts that aren't activated within a couple of days get removed automatically as part of the daily maintenance cycle. -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about next/prev browsing
Nick G wrote: Select * From ( Select rownum rnum, p.* From ( SELECT count(1) Over() totalCount, a.columns, b.columns FROM table a, table b WHERE a.id = b.id ORDER BY a.name ) p Where rownum = #Abs((start + Limit) - 1)# ) Where rnum = #start# Yeah, that's kinda similar to what I did using the MySQL-specific LIMIT statement. It seems to work well - I just didn't know if using caching would or wouldn't be the right thing to do, especially when I have 60k records. Obviously there are many ways to skin the cat, just trying to find the best way. Now, when people are dealing with query caching, how many records do you pull out, generally speaking? What if you get to the end of the cached recordset, is it normal practice to have to put logic to run another query and cache those results? The paging is simple enough to implement and even easier using EXT. Obviously if you're not using Oracle this won't work but I'm sure the other db's have a similar way to accomplish this. I'm assuming EXT is Oracle-specific? I'm using MySQL. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Question about next/prev browsing
The paging is simple enough to implement and even easier using EXT. Obviously if you're not using Oracle this won't work but I'm sure the other db's have a similar way to accomplish this. I'm assuming EXT is Oracle-specific? I'm using MySQL. Sorry I really made that sound like EXT was part of Oracle. Ext is a cross browser jscript library. I believe underneath CF using ext 1.1 for it's grids and some of the other objects. Simple enough to write the grids in Ext though. http://extjs.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...Application.cfm question
--- Application --- CFPARAM NAME=session.allowin DEFAULT=false cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- NOT LOGGED IN --- cflocation url=../login.cfm / /cfif /cfif Right now, I can login, and go to a page in the admin folder, copy the address, close the browser, and for the next 10 minutes, still get back in simply by putting the page address back in again. Currently, looking at my application.cfm file: clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,10,0)# applicationtimeout=#CreateTimeSpan(0,0,10,0)# What's the best docs I need to be looking at to be **sure** that when they close their browser they are *OUT* and can't get back in without loggin in again REGARDLESS. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...Application.cfm question
cfif structKeyExists(cookie, CFID) AND structKeyExists(cookie, CFTOKEN) cfcookie name=CFID value=#cookie.cfid# / cfcookie name=CFTOKEN value=#cookie.cftoken# / /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...Application.cfm question
use j2ee sessions (setting in cf admin) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Les Mizzell wrote: Right now, I can login, and go to a page in the admin folder, copy the address, close the browser, and for the next 10 minutes, still get back in simply by putting the page address back in again. Currently, looking at my application.cfm file: clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,10,0)# applicationtimeout=#CreateTimeSpan(0,0,10,0)# What's the best docs I need to be looking at to be **sure** that when they close their browser they are *OUT* and can't get back in without loggin in again REGARDLESS. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...Application.cfm question
Matt Quackenbush wrote: cfif structKeyExists(cookie, CFID) AND structKeyExists(cookie, CFTOKEN) cfcookie name=CFID value=#cookie.cfid# / cfcookie name=CFTOKEN value=#cookie.cftoken# / /cfif OK, that works, but I don't get exactly what it's doing. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...Application.cfm question
Matt Quackenbush wrote: cfif structKeyExists(cookie, CFID) AND structKeyExists(cookie, CFTOKEN) cfcookie name=CFID value=#cookie.cfid# / cfcookie name=CFTOKEN value=#cookie.cftoken# / /cfif Hey Matt, I use that same code - how does it actually work? I never quite understood how it accomplished the goal killing the session when you closed the browser. Thanks! Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...Application.cfm question
Les Mizzell wrote: Matt Quackenbush wrote: cfif structKeyExists(cookie, CFID) AND structKeyExists(cookie, CFTOKEN) cfcookie name=CFID value=#cookie.cfid# / cfcookie name=CFTOKEN value=#cookie.cftoken# / /cfif OK, that works, but I don't get exactly what it's doing. It replaces the two standard CF-generated cookies which don't expire with two that will expire immediately the browser closes (the default behaviour of cfcookie). -- Yours, Kym Kovan mbcomms.net.au ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
This is where I should post links to Fusebox 5 FLiP and How To Drive Fusebox 5.5 but protonarts.com is down. Anyone have any ideas and/or Jeff Peters on speed dial...? On Thu, Feb 19, 2009 at 6:48 PM, Justin Scott jscott-li...@gravityfree.comwrote: Les Mizzell wrote: You have much to learn, young padawan, but you are in the right place. You're telling me. Fusebox 5.x has me tearing my hair out. Maybe somebody will release Dummies Guide to Fusebox at some point. I'm going to need it There used to be books on Fusebox several years ago. I had a copy of Discovering Fusebox 4 when it first came out in 2003. I switched jobs in 2005 to a company that doesn't use Fusebox, so I've been out of the loop on new developments since then. It appears the books didn't get updated though which is unfortunate. -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319579 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflayout annoying issue
Hi Bob, That didn't work, same kind of layout bug. Thanks anyway. MS On Wed, Feb 18, 2009 at 6:17 PM, Bob sol_xp...@yahoo.com wrote: I think what you need is as follows : html head /head body leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0 marginwidth=0 marginheight=0 cflayout name=outerlayout type=vbox style=height:100%; cflayoutarea style=height:15%; background-color:##FFCCFF h3header/h3 /cflayoutarea cflayoutarea style=height:80%; cflayout name=thelayout type=border cflayoutarea position=left This is text in layout area 2: leftbr / You can close and collapse this area. /cflayoutarea cflayoutarea position=center This is text in layout area 3: centerbr / /cflayoutarea cflayoutarea position=right This is text in layout area 4: rightbr / You can collapse this, but not close it.br / It is initially collapsed. /cflayoutarea /cflayout /cflayoutarea cflayoutarea style=height:5%; background-color:##FFCCFF CENTERfooter/CENTER /cflayoutarea /cflayout /body /html regards Bob From: MS madsy...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, February 18, 2009 12:41:43 AM Subject: cflayout annoying issue Hi all Quick cflayout question. I have a normal layout (positions = TOP, LEFT, CENTER, RIGHT, BOTTOM) page. Problem: if the center inside the CENTER cflayoutarea is larger than the screen, I'm getting a scroll bar just in that CENTER cflayoutarea. Instead, the whole page should expand to accommodate the height of CENTER. I tried playing with height:100% everywhere and I can't do the trick. cflayout cflayoutarea position=top Top /cflayoutarea cflayoutarea position=left Left /cflayoutarea cflayoutarea position=center BIG CONTENT (in height) BIG CONTENT (in height) BIG CONTENT (in height) ** I want this to expand and cause scrollbars to appear on the whole page, not just on this DIV /cflayoutarea cflayoutarea position=right Right /cflayoutarea /cflayout Hope it makes sense. Cheers, MS ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cflayout annoying issue
Good to know Steve, I wish I had asked before, it would have saved me some hours. Thanks! MS On Thu, Feb 19, 2009 at 12:57 AM, Cutter (CFRelated) cold.fus...@cutterscrossing.com wrote: MS, The Ext Viewport doesn't work in this fashion (that's the underlying component of cflayout). The Viewport will only take up the viewable area of the browser, with the 'center' view always taking up the remaining space (only area that doesn't require explicit dimensions). What you need is straight HTML and CSS. I would suggest you look at the Three Column Layout (flanking menus) in The Layout Reservoir of BlueRobot.com You don't need Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com MS wrote: Hi all Quick cflayout question. I have a normal layout (positions = TOP, LEFT, CENTER, RIGHT, BOTTOM) page. Problem: if the center inside the CENTER cflayoutarea is larger than the screen, I'm getting a scroll bar just in that CENTER cflayoutarea. Instead, the whole page should expand to accommodate the height of CENTER. I tried playing with height:100% everywhere and I can't do the trick. cflayout cflayoutarea position=top Top /cflayoutarea cflayoutarea position=left Left /cflayoutarea cflayoutarea position=center BIG CONTENT (in height) BIG CONTENT (in height) BIG CONTENT (in height) ** I want this to expand and cause scrollbars to appear on the whole page, not just on this DIV /cflayoutarea cflayoutarea position=right Right /cflayoutarea /cflayout Hope it makes sense. Cheers, MS ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
HTTP_USER_AGENT question
In working out my Googlebot problem, I came across an idea of using HTTP_USER_AGENT to identify a bot, and then exclude it from an area or whatever (redirect it to www.disney.com or something... that's a joke) ... assuming it gets in despite the robots.txt file. So, this looks like a good starting point to modify from: http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm I see how to deal with bots you can identify. Can anybody think of a way or have an example of how to figure out that it's a unidentifiable bot (rather than a real user with a browser) and redirect/whatever? Just asking ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...Application.cfm question
Nobody else mentioned it yet, but I had something similar happen many years ago - a link checking program was accidentally run on a password protected area of the website and did a lot of funny things to our database.. ever since then, I never use a link to make a change in my database. It is just too easy to trigger it by accident. I changed everything to use forms, or where that is not practical, javascript with a confirmation, in such a way that if javascript is disabled, the link can't work. And I always log every change made, (a copy of the old data, new data, user who changed it, datestamp, IP address of user) so in case of problems, I can reverse the damage (in addition to insanely frequent backups to multiple locations) As a bonus, I use this log to display the last 10 changes made on the website in my footer... so for example, when entering checks received, the user can see the last few things he entered and if there was a mistake, he can easily go back and edit it. Takes some fear out of computer illiterate people if they know they can fix any mistakes. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flashpaper and Forms Submission
Hi All, Is is technically possible to have some sort of conversion process that converts existing form documents (word PDF froms)to a flashpaper format (ie retaining all the formating and branding of the document), while allowing (or adding) the ability to send the form results to either a DB or to a PDF file through the flashpaper file? I basically want to be able to have the embed ability and format retention of flashpaper, while allowing form fields to be sumbitted from this flashpaper document. Your thoughts? Cheers Dean ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HTTP_USER_AGENT question
It's trivial to fake this header and many bad bots (i.e. the ones that ignore robots.txt) will pretend to be IE or another browser. Claude S has posted his solutions in the past and that should all be in the archives. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/20 Les Mizzell lesm...@bellsouth.net: In working out my Googlebot problem, I came across an idea of using HTTP_USER_AGENT to identify a bot, and then exclude it from an area or whatever (redirect it to www.disney.com or something... that's a joke) ... assuming it gets in despite the robots.txt file. So, this looks like a good starting point to modify from: http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm I see how to deal with bots you can identify. Can anybody think of a way or have an example of how to figure out that it's a unidentifiable bot (rather than a real user with a browser) and redirect/whatever? Just asking ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfinclude template issues
Scott, I would suggest doing Mark's first suggestion. Then open the page using a product that 'used' to work (or still does work). And write down the EXACT value that is displayed for GetPageContent.PageInclude. Then compare that value to the one that is generated when you try to open your new page (that doesn't work). I am guessing that the value in the database for the working page has no initial '/' symbol, while the value for the not working page has that '/' symbol. William -Original Message- From: Scott Weber [mailto:swe...@thanksal.com] Sent: Thursday, February 19, 2009 2:20 PM To: cf-talk Subject: RE: cfinclude template issues All existing pages work. I'm just copying the way he did it on the old pages. I add an entry into the DB and point it to this file which is in the same sub folder as the other working ones. I added that code and on the working pages, nothing happened. On the new page I added I got the same debug message at the bottom like I posted previously. I will try your second option and see, but like I said all other pages are working. -Original Message- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: Thursday, February 19, 2009 3:52 PM To: cf-talk Subject: RE: cfinclude template issues Hi Scott After your /cfquery, add this to see exactly what the query is returning: cfdump var=#GetPageContent# cfabort The first line will dump the query (or any variable, which is very handy), and cfabort will end the page (before the error hits). If the dump doesn't show a column called PageInclude, or if that value doesn't look like a decent template name, then this query (or something) is the problem. (Remove the debugging code when you're done.) If the query looks right then add a simple cfinclude template=... and hard-code the query's value as the template. Follow this by cfabort and your page should do the cfinclude and then stop; if you get an error then the template you are trying to include is either missing or not reachable from your page. (You can put this tag near the top of the page... All you want to verify is that cfinclude works or doesn't. Remove the cfinclude after the test.) Post your results. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Googlebot got me good last night...Application.cfm question
I think it is probably a moot point, but it probably bears repeating. If you can run a link checker on your 'password protected' site, and that link checker can cause 'damage' to anything. Then you are not properly protecting your area. I have not yet come across a link checker that can submit a form, so the link checker should never have the authorization to run those pages in the protected area. An easy way to check this, without endangering your database, is to call a properly 'protected' page in your area directly from a browser that has it's javascript turned off and has had all of its cookies/session cookies, flushed. If the page runs as normal, then you have done something wrong. The good news is that we are here to help out. If, of course, you just need someone to do it for you. don't lose my number. :^) William -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Thursday, February 19, 2009 8:46 PM To: cf-talk Subject: Re: Googlebot got me good last night...Application.cfm question Nobody else mentioned it yet, but I had something similar happen many years ago - a link checking program was accidentally run on a password protected area of the website and did a lot of funny things to our database.. ever since then, I never use a link to make a change in my database. It is just too easy to trigger it by accident. I changed everything to use forms, or where that is not practical, javascript with a confirmation, in such a way that if javascript is disabled, the link can't work. And I always log every change made, (a copy of the old data, new data, user who changed it, datestamp, IP address of user) so in case of problems, I can reverse the damage (in addition to insanely frequent backups to multiple locations) As a bonus, I use this log to display the last 10 changes made on the website in my footer... so for example, when entering checks received, the user can see the last few things he entered and if there was a mistake, he can easily go back and edit it. Takes some fear out of computer illiterate people if they know they can fix any mistakes. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JavaScript Validation in ColdFusion
Hi all, I have an issue Have a form and have the three raio buttons and I grouped it. Need to select one option and depending on the option need to fill texboxes. I am able to select the radio button and produce the error message. I am trying to disable and enable textboxes and validate them depends on radio button selection. I am able to disable and enable texboxes but unable to validate boxes. If I select Option1 It will disable text boxes If I select option2 or option3 --- enable extboxes and validate boxes textbox1 --- should validate the length=12, should be numeric, should not be empty textbox2 --- should validate the length=10, should be numeric, should not be empty Thanks, Can anyone hel with this cfform name='form1' cfinput type=radio name=rb_deposit value= id =id_check onclick =funcone() required=yes message=Please select optionspanOption1/spanbr/ cfinput type=radio name=rb_deposit value= id =id_check1 onclick=check1()spanOption2/spanbr/ cfinput type=radio name=rb_deposit value= id =id_check2 onclick=check1()spanOption3/spanbr/ input type=text name=text1 value= id =text_id onBlur=check2() spanlabel1/spanbr/ input type=text name=text2 value= id =text_id1 onBlur=check3()spanlabel2/spanbr/ cfinput name=submit value=submit id=submit_1 type='submit'br/ /cfform script type=text/javascript function funcone(){ if(document.form1.id_check.checked) { document.form1.text_id.disabled = true; document.form1.text_id1.disabled = true; return false; } else{return true;} } function check1() { if (document.form1.text_id.disabled = true) { document.form1.text_id.disabled =false; document.form1.text_id1.disabled = false; return false; } else{return true;} } function check2() { if(document.form1.id_check1.checked || document.form1.id_check2.checked) { document.form1.text1.focus(); if(document.form1.text1.value== ||!isNaN(document.form1.text1.value)||document.form1.text1.length !='12') { alert(Please enter BankNumber); document.form1.text1.focus(); }else {return true;} } function check3() { if(document.form1.text1.value!= ||!isNaN(document.form1.text1.value)) { if(document.form1.text2.value= || isNaN(document.form1.text2.value)) { alert(Please enter Routing Number); document.form1.text2.focus(); return false; } else {return true;} } } } /script ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HTTP_USER_AGENT question
Yeah, as a general rule-- never base security off anything in the cgi scope. Anything that comes in the request header can be spoofed. ~Brad Original Message Subject: Re: HTTP_USER_AGENT question From: James Holmes james.hol...@gmail.com Date: Thu, February 19, 2009 11:47 pm To: cf-talk cf-talk@houseoffusion.com It's trivial to fake this header and many bad bots (i.e. the ones that ignore robots.txt) will pretend to be IE or another browser. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HTTP_USER_AGENT question
I use this in my application.cfc right at top. It notes the more common bots (google) and assigns them a timeout of 2 seconds. You can use the same logic for whatever you want. IF (REFindNoCase('Slurp|Google|BecomeBot|msnbot|ZyBorg|RufusBot|EMonitor|java', cgi.http_user_agent)) This.sessionTimeout=createtimespan(0,0,0,2); On Thu, Feb 19, 2009 at 10:22 PM, Les Mizzell lesm...@bellsouth.net wrote: In working out my Googlebot problem, I came across an idea of using HTTP_USER_AGENT to identify a bot, and then exclude it from an area or whatever (redirect it to www.disney.com or something... that's a joke) ... assuming it gets in despite the robots.txt file. So, this looks like a good starting point to modify from: http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm I see how to deal with bots you can identify. Can anybody think of a way or have an example of how to figure out that it's a unidentifiable bot (rather than a real user with a browser) and redirect/whatever? Just asking ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4