Writing huge data to excel
Hi, I am working on exporting data to excel with multiple sheets. The sheets are dynamic and may range from 2 to more than 5. What is the best way to handle this? 1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation of sheets? I have tried with cfspreadsheet but only the last sheet is displayed in excel 2) Use AJAX? If yes, is there an example on how to achieve this? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358781 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Writing huge data to excel
Thank you. I am not using SpreadSheetWrite function to write to a file. I am storing all the sheets in a variable and using cfheader and cfcontent to prompt the user to save or download. Do you think this is a preferred option? On Tue, Jul 1, 2014 at 2:17 PM, Jon Clausen jon_clau...@silowebworks.com wrote: Iâve actually become quite fond of CF's Spreadsheet functions, though I prefer to use the script versions as I find them more flexible when dealing with large datasets, formatting content for reports and working with multiple sheets: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec1fb12-7fd6.html You can create your workbook and then use SpreadsheetWrite() to write each worksheet to the workbook. I think youâll find that having a dynamic number of sheets in the workbook will be easier using script syntax. HTH, Jon On Jul 1, 2014, at 10:03 AM, funand learning funandlrnn...@gmail.com wrote: Hi, I am working on exporting data to excel with multiple sheets. The sheets are dynamic and may range from 2 to more than 5. What is the best way to handle this? 1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation of sheets? I have tried with cfspreadsheet but only the last sheet is displayed in excel 2) Use AJAX? If yes, is there an example on how to achieve this? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358784 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue with cfspreadsheet
Hi All - I am creating multiple sheets of data using cfspreadsheet and using the script here http://cfsimplicity.com/16/forcing-values-to-be-inserted-into-spreadsheets-as-textto force few columns to be treated as text. The issue I am facing is, when number of records for all the sheets combined reaches few thousands, the columns I am using for text formatting are automatically getting bolded font and gray background. I was wondering if anyone has faced this issue and if there is a way to fix this? Below is the code cfset REQUEST.gen_Excel = spreadsheetNew(Sheet1,true) cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet1) cfscript REQUEST.gen_Excel= spreadsheetAddRowsForceTextFormat ( spreadsheetObject=REQUEST.gen_Excel, data=query1, columnNumbersToFormatAsText=[1,3,4,5], addedHeaderRow=true ); /cfscript cfset REQUEST.gen_Excel = spreadsheetNew(Sheet2,true) cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet2) cfscript REQUEST.gen_Excel = spreadsheetAddRowsForceTextFormat ( spreadsheetObject=REQUEST.gen_Excel, data=query1, columnNumbersToFormatAsText=[1,3,4,5], addedHeaderRow=true ); /cfscript cfset REQUEST.gen_Excel = spreadsheetNew(Sheet3,true) cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet3) cfscript REQUEST.gen_Excel = spreadsheetAddRowsForceTextFormat ( spreadsheetObject=REQUEST.gen_Excel, data=query3, columnNumbersToFormatAsText=[1,3,4], addedHeaderRow=true ); /cfscript cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet1) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Loading message for excel pages
All - I have a following link a href=javascript:callExcel()Generate excel/a the function callExcel() just uses document.form.action='excel.cfm?requesttimeout=1500'; When the 'Generate excel' link is clicked, the user stays on current page, and the excel file is generated. The user never sees the actual 'excel.cfm' which has 'Please wait...' message as we are writing lot of data to excel. I tried to overcome this by going to an intermediate screen which has 'Please wait' message, and then redirecting to excel.cfm page, but once the excel is written, I can still see 'Please wait...' message. What is the best way to handle this? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying page loading message
thank you Jonah. Your solution helped On Mon, Mar 24, 2014 at 5:00 PM, .jonah jonah@creori.com wrote: Display a page with the loading message then a client-side (meta or js) redirect to the slow page. On 3/24/14 1:53 PM, fun and learning wrote: All, I have an issue with displaying a page loading message on a page with heavy database queries. My page has two frames, and I am trying to display loading message on the second frame. I am using cfflush to show the loading message but to no avail. The frame looks blank for 15 seconds and then loading message as well as data is displayed. Can anyone advice what is the best approach to resolve this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Element undefined in SESSION scope
I see that session variables are persisting only after turning on 'use J2EE session variables' setting in coldfusion admin. Here is the link to the question I posted on stackoverflow http://stackoverflow.com/questions/18093985/coldfusion-enabling-j2ee-session-variables-vs-coldfusion-session-variables On Wed, Aug 7, 2013 at 9:11 AM, David Phelan dphe...@emerginghealthit.comwrote: What is your session timeout? Are you setting it in your cfapplication tag or relying on the server settings? Is it possible that the timeout is too small and destroying the session before the form can be submitted? David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: Priya K [mailto:priya23...@gmail.com] Sent: Tuesday, August 06, 2013 8:35 PM To: cf-talk Subject: Re: Element undefined in SESSION scope May be its something to do with cookie path. If you are using cookie, this might mess up your session and just drops it. On Tuesday, August 6, 2013, Mark A Kruger wrote: Trying a resend. Make sure that cgi.http_referer exists before you try to set it. This is a var created by the web server NOT cf ... so it may or may not reliably exist. Also make sure this code is AFTER your cfapplication tag. On your own system try hitting the page after a cf restart. You may be trying to access the session before you have established a session. The reason it works on local is because during coding you established a session at some previous point. That's all I got :) -Mark ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Element undefined in SESSION scope
I am just setting up a variable to capture cgi.http_referer. cfset session.referer = cgi.http_referer. Initially, the variable was set up as input type=hidden name=referer value=#CGI.http_referer# This variable is defined on a form, which submits to itself. I want to capture the initial cgi.http_referer value when the user first lands on the form and save it to database upon successful submission, hence was using hidden value. Recent security scanning has identified the input form variable for XSS, and hence I am changing it to a session value. On Tue, Aug 6, 2013 at 3:01 PM, Alan Rother alan.rot...@gmail.com wrote: Can we see some sample code? On Tue, Aug 6, 2013 at 12:43 PM, fun and learning funandlrnn...@gmail.comwrote: All - I am converting a form variable to a session variable.I enabled session management in application.cfm in cfapplication tag. The change works fine only on my system, but when others try it, they get 'Element undefined in SESSION'. What could be the possible reason? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Element undefined in SESSION scope
Can you please resend the last reply of this post. I am not able to view the reply either in houseoffusion.com nor in my inbox. In inbox I just see the reply starting with 'Make sure...', but when I click the message, it is gone...something is weirdThanks On Tue, Aug 6, 2013 at 3:07 PM, funand learning funandlrnn...@gmail.comwrote: I am just setting up a variable to capture cgi.http_referer. cfset session.referer = cgi.http_referer. Initially, the variable was set up as input type=hidden name=referer value=#CGI.http_referer# This variable is defined on a form, which submits to itself. I want to capture the initial cgi.http_referer value when the user first lands on the form and save it to database upon successful submission, hence was using hidden value. Recent security scanning has identified the input form variable for XSS, and hence I am changing it to a session value. On Tue, Aug 6, 2013 at 3:01 PM, Alan Rother alan.rot...@gmail.com wrote: Can we see some sample code? On Tue, Aug 6, 2013 at 12:43 PM, fun and learning funandlrnn...@gmail.comwrote: All - I am converting a form variable to a session variable.I enabled session management in application.cfm in cfapplication tag. The change works fine only on my system, but when others try it, they get 'Element undefined in SESSION'. What could be the possible reason? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Standard w3c tags
All - What are the list of standard meta tags defined in w3c other than the below given at http://www.w3.org/wiki/HTML/Elements/meta meta http-equiv=Content-Type content=text/html; charset=utf-8 / meta http-equiv=Content-Style-Type content=text/css / meta name=copyright content=© W3C / meta name=author lang=en content= / meta name=robots content=Index,Follow / meta name=description content=The World Wide Web Consortium (W3C) is an international community where Member organizations, a full-time staff, and the public work together to develop Web standards. / meta name=keyword content=W3C, HTML, CSS, SVG, Web standards / I posted the same question in stackoverflow http://stackoverflow.com/questions/16171686/list-of-standard-w3c-meta-tags Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:30 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Standard w3c tags
Apart from the example list provided, are there more meta tags? On Tue, Apr 23, 2013 at 10:52 AM, Raymond Camden raymondcam...@gmail.comwrote: Maybe I'm confused, but wouldn't the spec (your link) be the standard? On Tue, Apr 23, 2013 at 10:41 AM, funand learning funandlrnn...@gmail.comwrote: All - What are the list of standard meta tags defined in w3c other than the below given at http://www.w3.org/wiki/HTML/Elements/meta meta http-equiv=Content-Type content=text/html; charset=utf-8 / meta http-equiv=Content-Style-Type content=text/css / meta name=copyright content=© W3C / meta name=author lang=en content= / meta name=robots content=Index,Follow / meta name=description content=The World Wide Web Consortium (W3C) is an international community where Member organizations, a full-time staff, and the public work together to develop Web standards. / meta name=keyword content=W3C, HTML, CSS, SVG, Web standards / I posted the same question in stackoverflow http://stackoverflow.com/questions/16171686/list-of-standard-w3c-meta-tags Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:32 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Standard w3c tags
Thank you all On Tue, Apr 23, 2013 at 11:09 AM, Dave Watts dwa...@figleaf.com wrote: Well sure, there may be. Any browser can support whatever the heck they wanted. But if you want to know the *official* list, the spec is your best bet. Fortunately, using name meta tags doesn't even require browser support, since browsers don't do anything with them. So, you can use whatever you want. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:38 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Standard w3c tags
I have been asked to add standard meta tags to the web pages. I was only aware of couple them like description and content-type, and wanted to make sure about remaining meta tags On Tue, Apr 23, 2013 at 11:14 AM, Dave Watts dwa...@figleaf.com wrote: Thank you all It might be worthwhile for you to tell us what you're trying to do, rather than asking about specifications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Impact of cross site scripting in google search appliance
All - On our websites, we use google search appliance (GSA). When a user enters a search term, and submits the form, it goes to GSA.We are using GET method hence the search term is passed as a URL variable. There is chance of tampering the search term in the URL, for example adding alert statement to the search term. When this is done, GSA just returns that no search results are available. I am not understanding what is the impact of cross site scripting with google search appliance. Does anyone have an idea on this? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Impact of cross site scripting in google search appliance
Dave, What do you mean when you said that it is possibe to modify default XSLT and do dangerous things with inputs? Thanks, Lavanya On Tue, Mar 26, 2013 at 1:04 PM, Dave Watts dwa...@figleaf.com wrote: On our websites, we use google search appliance (GSA). When a user enters a search term, and submits the form, it goes to GSA.We are using GET method hence the search term is passed as a URL variable. There is chance of tampering the search term in the URL, for example adding alert statement to the search term. When this is done, GSA just returns that no search results are available. I am not understanding what is the impact of cross site scripting with google search appliance. Does anyone have an idea on this? By default, there isn't any impact, because as you observed, the GSA isn't going to do anything with that query parameter other than use it in server-side processing. But it is possible to modify the default XSLT to make it do dangerous things with inputs. You can avoid this problem by using CF as a proxy of sorts - instead of submitting the search form directly to the appliance, you could submit it back to CF, which could either validate values then redirect you to the GSA or make a CFHTTP call on your behalf. These things will increase the complexity of your application, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355149 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Impact of cross site scripting in google search appliance
Dave, What do you mean when you said that it is possible to modify default XSLT and do dangerous things with inputs? Thanks On Tue, Mar 26, 2013 at 1:04 PM, Dave Watts dwa...@figleaf.com wrote: On our websites, we use google search appliance (GSA). When a user enters a search term, and submits the form, it goes to GSA.We are using GET method hence the search term is passed as a URL variable. There is chance of tampering the search term in the URL, for example adding alert statement to the search term. When this is done, GSA just returns that no search results are available. I am not understanding what is the impact of cross site scripting with google search appliance. Does anyone have an idea on this? By default, there isn't any impact, because as you observed, the GSA isn't going to do anything with that query parameter other than use it in server-side processing. But it is possible to modify the default XSLT to make it do dangerous things with inputs. You can avoid this problem by using CF as a proxy of sorts - instead of submitting the search form directly to the appliance, you could submit it back to CF, which could either validate values then redirect you to the GSA or make a CFHTTP call on your behalf. These things will increase the complexity of your application, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Impact of cross site scripting in google search appliance
Ok. With existing XSLT, when I use alert statement in GSA URL, it throws an alert statement but the search results return a message No results available. but when I use the same search term in google.com, it does not throw any alert statement. Do you think I need to update XSLT to not execute any scripts? is this possible? On Tue, Mar 26, 2013 at 1:42 PM, Dave Watts dwa...@figleaf.com wrote: What do you mean when you said that it is possibe to modify default XSLT and do dangerous things with inputs? I mean that the administrator of the GSA could log into the admin console, modify the XSLT manually, and include code to automatically execute JavaScript found in URL parameters. Just like a CF developer could do when writing a CF page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with Session scope
I did enable session management using cfapplication tag. Below is the piece of code cfapplication name=app applicationtimeout=#createtimespan(0, 0, 0, 10)# sessionmanagement=yes clientmanagement=no On Fri, Mar 15, 2013 at 12:15 PM, Bobby bo...@acoderslife.com wrote: Sounds like your sessions aren't persisting across requests. There could be a couple of reasons but the most common, from what I've seen, is that people forget to enable session management in their application. On 3/15/13 10:43 AM, fun and learning funandlrnn...@gmail.com wrote: I am converting a hidden variable to session variable. I am setting a session variable when a page loads. The page consists of a form cfset session.host = cgi.remotehost When the form is submitted, the session variable is saved to a file. The form submits to the same page except there is a condition, cfif isdefined(form.submit) cfinclude template=savetofile.cfm /cfif The problem is when I submit the form on my computer, the session variable exists and form submission works fine. But when I asked some other people at my office to test, they get 'Element host is undefined in session' on form's submission.Looks like it is failing in savetofile.cfm. Why could this be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with Session scope
sorry, it is remote_host in my code. I will try to increase application time out and try On Fri, Mar 15, 2013 at 12:32 PM, Bobby bo...@acoderslife.com wrote: No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is cgi.remote_host. Cgi.remotehost will result in an empty string. On 3/15/13 11:24 AM, Matt Quackenbush quackfu...@gmail.com wrote: Your application timeout is seriously set to 10 seconds?? I suspect that would hose sessions pretty quickly, but not sure, since I've never set an app timeout so short. :-) HTH On Fri, Mar 15, 2013 at 11:18 AM, funand learning funandlrnn...@gmail.comwrote: I did enable session management using cfapplication tag. Below is the piece of code cfapplication name=app applicationtimeout=#createtimespan(0, 0, 0, 10)# sessionmanagement=yes clientmanagement=no On Fri, Mar 15, 2013 at 12:15 PM, Bobby bo...@acoderslife.com wrote: Sounds like your sessions aren't persisting across requests. There could be a couple of reasons but the most common, from what I've seen, is that people forget to enable session management in their application. On 3/15/13 10:43 AM, fun and learning funandlrnn...@gmail.com wrote: I am converting a hidden variable to session variable. I am setting a session variable when a page loads. The page consists of a form cfset session.host = cgi.remotehost When the form is submitted, the session variable is saved to a file. The form submits to the same page except there is a condition, cfif isdefined(form.submit) cfinclude template=savetofile.cfm /cfif The problem is when I submit the form on my computer, the session variable exists and form submission works fine. But when I asked some other people at my office to test, they get 'Element host is undefined in session' on form's submission.Looks like it is failing in savetofile.cfm. Why could this be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with Session scope
also cfid cftoken are same for me before and after form submission. When I asked my colleague to test, I see they are different before and after form submission. I thought this issue happens when we use cflocation, but I am not using this tag either On Fri, Mar 15, 2013 at 11:34 AM, funand learning funandlrnn...@gmail.comwrote: sorry, it is remote_host in my code. I will try to increase application time out and try On Fri, Mar 15, 2013 at 12:32 PM, Bobby bo...@acoderslife.com wrote: No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is cgi.remote_host. Cgi.remotehost will result in an empty string. On 3/15/13 11:24 AM, Matt Quackenbush quackfu...@gmail.com wrote: Your application timeout is seriously set to 10 seconds?? I suspect that would hose sessions pretty quickly, but not sure, since I've never set an app timeout so short. :-) HTH On Fri, Mar 15, 2013 at 11:18 AM, funand learning funandlrnn...@gmail.comwrote: I did enable session management using cfapplication tag. Below is the piece of code cfapplication name=app applicationtimeout=#createtimespan(0, 0, 0, 10)# sessionmanagement=yes clientmanagement=no On Fri, Mar 15, 2013 at 12:15 PM, Bobby bo...@acoderslife.com wrote: Sounds like your sessions aren't persisting across requests. There could be a couple of reasons but the most common, from what I've seen, is that people forget to enable session management in their application. On 3/15/13 10:43 AM, fun and learning funandlrnn...@gmail.com wrote: I am converting a hidden variable to session variable. I am setting a session variable when a page loads. The page consists of a form cfset session.host = cgi.remotehost When the form is submitted, the session variable is saved to a file. The form submits to the same page except there is a condition, cfif isdefined(form.submit) cfinclude template=savetofile.cfm /cfif The problem is when I submit the form on my computer, the session variable exists and form submission works fine. But when I asked some other people at my office to test, they get 'Element host is undefined in session' on form's submission.Looks like it is failing in savetofile.cfm. Why could this be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: question on cfloop
I am sorry, I wasn't clear. the to is arraylen. Sometimes the arraylen is 1 cfloop from=1 to=#ArrayLen(somearray)# index=j /cfloop cfoutput#j#/cfoutput --this returns 2 On Thu, Feb 28, 2013 at 6:34 PM, Phillip Vector vec...@mostdeadlygame.comwrote: Why are you looping from 1 to 1? That isn't a loop. On Thu, Feb 28, 2013 at 7:22 PM, fun and learning funandlrnn...@gmail.com wrote: I have a query on looping in coldfusion.Why does the below loop run twice? cfloop from=1 to=1 index=j cfoutput#j#/cfoutput /cfloop I thought the above code should return only 1, but it returns 1 2 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Question about CF Patches
All - Has anybody faced a problem where you have to clear browser cache for application that requires log in? We have applied patches two weeks back, but last week we were not able to login into an application until the browser cache was cleared, and it repeated again yesterday too. This never happened before applying the patches. We are running Coldfusion 8 Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app response slow
All - Would there be a performance hit if the server monitor is enabled for long periods of time? On Tue, Feb 5, 2013 at 1:57 PM, Russ Michaels r...@michaels.me.uk wrote: Fusionreactor does not have all the info thar the server monitor does, the server monitor is better for drilling down into memory usage. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Feb 5, 2013 7:51 PM, Cameron Childress camer...@gmail.com wrote: On Tue, Feb 5, 2013 at 2:06 PM, J.J. Merrick j...@panos.cc wrote: FusionReactor would be a great tool that would tell you exactly what was going on during the slow down and see what the issue is. +1 -Cameron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app response slow
I am planning to turn it on until I need to recycle the server when application slows down again probably around 5days. Would that be Ok? On Mon, Feb 18, 2013 at 9:42 AM, Russ Michaels r...@michaels.me.uk wrote: it does have a performance hit yes, so I wouldn't leave it running indefinitely. On Mon, Feb 18, 2013 at 3:40 PM, funand learning funandlrnn...@gmail.com wrote: All - Would there be a performance hit if the server monitor is enabled for long periods of time? On Tue, Feb 5, 2013 at 1:57 PM, Russ Michaels r...@michaels.me.uk wrote: Fusionreactor does not have all the info thar the server monitor does, the server monitor is better for drilling down into memory usage. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Feb 5, 2013 7:51 PM, Cameron Childress camer...@gmail.com wrote: On Tue, Feb 5, 2013 at 2:06 PM, J.J. Merrick j...@panos.cc wrote: FusionReactor would be a great tool that would tell you exactly what was going on during the slow down and see what the issue is. +1 -Cameron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issues after applying Coldfusion patches
All - Our admins have been applying patches to our Coldfusion servers (version 8). They said most of the patches affect coldfusion admin. During testing coldfusion administrator after applying patches, I found that verifying databases would throw this error There was an error accessing this page. Check logs for more details..The log file just has this error *There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected.* * * Any suggestions on this? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion log file setting
I figured appFolderCF might be a share created for JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion On Thu, Feb 7, 2013 at 1:46 PM, fun and learning funandlrnn...@gmail.comwrote: All - I have a question related to the Coldfusion directory structure I have the main folder which has all coldfusion files related to website. The folder name is appFolder. On the same server, there is another folder called appFolderCF that has folders like bin, cache, logs, Mail, registry etc. The logs folder has files with modified date similar to log files when viewed from CF Admin, but the log files location is different in CF Admin. What could be the reason that logs directory on appFolderCF is getting updated? The log files have data related to appFolder. Would it be safe to delete appFolderCF? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app response slow
Thank you all for you replies. I will try server monitoring and keep you posted On Tue, Feb 5, 2013 at 1:57 PM, Russ Michaels r...@michaels.me.uk wrote: Fusionreactor does not have all the info thar the server monitor does, the server monitor is better for drilling down into memory usage. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Feb 5, 2013 7:51 PM, Cameron Childress camer...@gmail.com wrote: On Tue, Feb 5, 2013 at 2:06 PM, J.J. Merrick j...@panos.cc wrote: FusionReactor would be a great tool that would tell you exactly what was going on during the slow down and see what the issue is. +1 -Cameron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app response slow
Thanks for your reply. As of now, I do not see any useful information from Coldfusion server monitor (accessed via coldfusion admin). The only information I see on overview page is *JVM Memory(used/total) MB - 107/177.* Do I need to turn on Start Monitoring/Start profiling/Start Memory tracking? In log files I see this warning for some of the scheduled jobs Thread: jrpp-2, processing template:**.cfm, completed in 490 seconds, exceeding the 30 second warning limit On Tue, Feb 5, 2013 at 8:25 AM, Russ Michaels r...@michaels.me.uk wrote: You may simply be running out of memory, too many requests are hung, problems with database connections. Have you looked at your coldfusion serve rmonitor ? Or try FusionReactor. On Tue, Feb 5, 2013 at 2:19 PM, fun and learning funandlrnn...@gmail.com wrote: All - Since couple of months, every couple of days one of the coldfusion app has slow response times. It gets fine once we recycle the coldfusion server. What are the possible ways to troubleshoot or identify the cause? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Changes do not show up on live website
are these cfclasses in WEB-INF folder? On Fri, Dec 14, 2012 at 9:56 AM, Adam Cameron adamcameroncoldfus...@gmail.com wrote: OK, but what about the files in cfclasses? It's unlikely there's old ones in there if the setting is off, but sometimes there's some cruft lying around. -- Adam On 14 December 2012 15:55, fun and learning funandlrnn...@gmail.com wrote: Try switching off save class files and getting rid of all the files in the cfclasses dir. They are more of a blight than a help in my experience. -- Adam On 14 December 2012 15:40, fun and learning funandlrnn...@gmail.com wrote: This option is already unchecked in Coldfusion admin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Changes do not show up on live website
Another question. Is it safe to delete those files? Coldfusion does not use any of those files, right? On Fri, Dec 14, 2012 at 10:05 AM, Adam Cameron adamcameroncoldfus...@gmail.com wrote: Sorry, yes. -- Adam On 14 December 2012 16:04, funand learning funandlrnn...@gmail.com wrote: are these cfclasses in WEB-INF folder? On Fri, Dec 14, 2012 at 9:56 AM, Adam Cameron adamcameroncoldfus...@gmail.com wrote: OK, but what about the files in cfclasses? It's unlikely there's old ones in there if the setting is off, but sometimes there's some cruft lying around. -- Adam On 14 December 2012 15:55, fun and learning funandlrnn...@gmail.com wrote: Try switching off save class files and getting rid of all the files in the cfclasses dir. They are more of a blight than a help in my experience. -- Adam On 14 December 2012 15:40, fun and learning funandlrnn...@gmail.com wrote: This option is already unchecked in Coldfusion admin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Changes do not show up on live website
Thanks Adam and Dave, there were some old files dating back to 2010. We deleted them and restarted the server, but with no change. ANy other clues why this could be happening? On Fri, Dec 14, 2012 at 10:29 AM, Adam Cameron adamcameroncoldfus...@gmail.com wrote: Yep, definitely. When CF compiles your source code (before it runs it), that Save Class Files makes CF write the compiled classes out to that directory. The only benefit this gives is that if you're short on memory, sometimes CF will cycle a compiled class out of memory, which means the next time you use it it will need to be reloaded. If the class file is already there, it'll use that, otherwise CF will need to recompile the source code (which has a performance overhead). CF will, however, attempt to keep commonly used classes in memory, and only cycle-out not-oft-used ones, so this is not much of a problem. Obviously when you chance the source code, CF is supposed to recompile anyhow, but I have found that sometimes it *doesn't* when you've got an already compiled file for that code in that directory. This still happens on CF9, as I experienced it last week. You should try to set your maximum templates setting to be slightly higher than *all* your application's compiled classes (if you have the RAM to do so), and this will mean CF will never cycle anything out of RAM. The other consideration is that when CF restarts, obviously it starts with nothing in memory, so it will need to recompile everything again, which makes start-up a bit slower. On the down side of saving class files is that on Windows I actually find it degrades performance (Charlie Arehart disagrees with me here, and he's more of an expert on the topic, so take my advice with a pinch of salt), because Windows really struggles with more than a few hundred files in one directory, and most CF apps have far more than that. So this means when CF checks whether source code and compiled class file differ (which is every time the code is requested), Windows is very slow to find the file. *nix does not have this issue. On the whole, I have found it better to run *without* this setting on in a production environment. However it has not been my job to troubleshoot this sort of thing for a number of years now, so I would not take my advice as gold. -- Adam On 14 December 2012 16:13, funand learning funandlrnn...@gmail.com wrote: Another question. Is it safe to delete those files? Coldfusion does not use any of those files, right? On Fri, Dec 14, 2012 at 10:05 AM, Adam Cameron adamcameroncoldfus...@gmail.com wrote: Sorry, yes. -- Adam On 14 December 2012 16:04, funand learning funandlrnn...@gmail.com wrote: are these cfclasses in WEB-INF folder? On Fri, Dec 14, 2012 at 9:56 AM, Adam Cameron adamcameroncoldfus...@gmail.com wrote: OK, but what about the files in cfclasses? It's unlikely there's old ones in there if the setting is off, but sometimes there's some cruft lying around. -- Adam On 14 December 2012 15:55, fun and learning funandlrnn...@gmail.com wrote: Try switching off save class files and getting rid of all the files in the cfclasses dir. They are more of a blight than a help in my experience. -- Adam On 14 December 2012 15:40, fun and learning funandlrnn...@gmail.com wrote: This option is already unchecked in Coldfusion admin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Changes do not show up on live website
Thanks a lot for your replies. We found the issue and its a very silly one. We used to have a script that copies files from test server to prod server. I never had to bother what the folder name in prod was as script was written long back and we just run it. Recently the script was broken due to some permissions issues, so we had to copy the files manually. We thought test and prod has same folder structure Prod has a folder with same name as test environment, and an another folder with slightly different name which was actually used. So we copied files into the folder with same name as test environment rather than the other. Can't believe I wasted so much of my time and especially you guys. Sorry about that. On Fri, Dec 14, 2012 at 11:19 AM, Dave Watts dwa...@figleaf.com wrote: Dave, do you know if there's a good reason they'll all stuck in the same dir, as opposed to hierarchically? I suspect it's just an oversight / it not occurring to them on Adobe's part, but perhaps it needs to be this way? It's always bugged me. I don't know if it's an oversight. I think it's easier than the alternative, which involves creating subdirectories based on some naming scheme, then figuring out how to traverse them, etc. Our app will stick about 8 files in that dir if we let it (which we don't). Yeah, that directory can get really crazy - I've seen cases with several hundred thousand files which is s l o w. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfftp error 533
ok very silly mistake on my part. I was using the wrong directory name in the code. On Wed, Dec 5, 2012 at 10:15 PM, fun and learning funandlrnn...@gmail.comwrote: Hi All - I am trying to ftp files using cfftp coldfusion tag. It worked fine until this evening, and all of a sudden, the following error is being thrown An error occurred during the FTP putFile operation. Error: 553 Could not create file However, when I ftp the files using filezilla it works fine. What could be the issue with cfftp? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: duplicate keys in rss xml feed
Ray, Thanks for the suggestion on keys being available as array under the node. I was able to get the values for duplicate keys. Below is the code I used, I guess it can be improved upon cfloop index=x from=1 to=#arrayLen(xmlResult.rss.channel.item)# cfset valueList = cfset count = 0 cfset idx = xmlResult.rss.channel.item[x] cfset keys = #StructKeyList(idx)# cfset keys = ListSort(keys,textnocase,asc,,) cfloop list=#keys# index=key cfif key EQ npr:rmaudio cfset count = count + 1 cfif valueList EQ cfset valueList = #idx[key][count].XmlText# cfelse cfset valueList = valueList , #idx[key][count].XmlText# /cfif /cfif /cfloop /cfloop On Wed, Dec 5, 2012 at 2:54 PM, Raymond Camden raymondcam...@gmail.comwrote: It should be available as an array under the node. Can you share the full URL of the feed? If so I can make a demo for you. On Wed, Dec 5, 2012 at 2:41 PM, fun and learning funandlrnn...@gmail.com wrote: item titlePennsylvania Primary Roundup/title descriptionBarack Obama improved his showing among white, middle-class voters, but not enough to beat Hillary Clinton in the Pennsylvania primary on Tuesday. NPR's National Political Correspondent Mara Liasson analyzes the race with Robert Seigel./description pubDateTue, 22 Apr 2008 21:53:01 -0400/pubDate link http://www.npr.org/stations/force/force_localization.php?station=KSJD_FMamp;url=http://www.npr.org/templates/story/story.php?storyId=89862645amp;ft=1amp;f=2 /link guid http://www.npr.org/templates/story/story.php?storyId=89862645amp;ft=1amp;f=2 /guid npr:wmaudio http://www.npr.org/templates/dmg/dmg_wmref_em.php?id=89863241amp;type=1amp;date=22-Apr-2008amp;mtype=WM /npr:wmaudio npr:rmaudio http://www.npr.org/templates/dmg/dmg_rpm.rpm?id=89863241amp;type=1amp;date=22-Apr-2008amp;mtype=RM /npr:rmaudio npr:rmaudio http://www.npr.org/templates/dmg/dmg_rpm.rpm?id=89863241amp;type=21amp;date=22-Apr-2008amp;mtype=RM /npr:rmaudio /item -- === Raymond Camden, Adobe Developer Evangelist Email : raymondcam...@gmail.com Blog : www.raymondcamden.com Twitter: cfjedimaster ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation not working
I see /test/folder1 On Thu, Nov 15, 2012 at 11:32 AM, Raymond Camden raymondcam...@gmail.comwrote: So when you output cgi.http_url, what do you see? On Thu, Nov 15, 2012 at 11:31 AM, fun and learning funandlrnn...@gmail.comwrote: Hi All - I am using the following code to redirect a page cfif cgi.http_host EQ abc.com cfif cgi.http_url EQ /test/folder1 cflocation statuscode=301 addtoken=false url= http://abc.com/test/folder2; /cfif /cfif The second if statement does not work. if I do the redirect just using the first if statement, it works. ANy ideas on why this could be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation not working
I put this code in application.cfm, but when I put it in some other common include file it works. How to make this work in application.cfm file? On Thu, Nov 15, 2012 at 11:42 AM, Robert Harrison rob...@austin-williams.com wrote: Your problem is the cgi vars. Test it without the if statements and see if it works. If it does, it's you cgi var statements that need some work. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
The requested URL not found
Hi All, We have youtube video with a link to our website embedded on it. The URL has query string as below: www.abc.com/?visitfrom=youtube The above URL is causing an error as The requested URL /?visitfrom=youtube not found on this server. Could this be happening due to / before the start of query string? Do we need to change any settings on the server? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The requested URL not found
Yes, the URL looks like http://abc.com/?visitfrom=youtubehttp://www.abc.com/?visitfrom=youtube On Tue, Jul 24, 2012 at 8:59 AM, Will Swain w...@hothorse.com wrote: Possibly being daft here, but do you have the http:// prefix? will -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: 24 July 2012 14:51 To: cf-talk Subject: The requested URL not found Hi All, We have youtube video with a link to our website embedded on it. The URL has query string as below: www.abc.com/?visitfrom=youtube The above URL is causing an error as The requested URL /?visitfrom=youtube not found on this server. Could this be happening due to / before the start of query string? Do we need to change any settings on the server? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The requested URL not found
What if the URL is getting converted to friendlyURLs? How can this be handled? On Tue, Jul 24, 2012 at 9:14 AM, Russ Michaels r...@michaels.me.uk wrote: Add the fikename to the url and it should work. Regards Russ Michaels On Jul 24, 2012 3:11 PM, funand learning funandlrnn...@gmail.com wrote: Yes, the URL looks like http://abc.com/?visitfrom=youtubehttp://www.abc.com/?visitfrom=youtube On Tue, Jul 24, 2012 at 8:59 AM, Will Swain w...@hothorse.com wrote: Possibly being daft here, but do you have the http:// prefix? will -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: 24 July 2012 14:51 To: cf-talk Subject: The requested URL not found Hi All, We have youtube video with a link to our website embedded on it. The URL has query string as below: www.abc.com/?visitfrom=youtube The above URL is causing an error as The requested URL /?visitfrom=youtube not found on this server. Could this be happening due to / before the start of query string? Do we need to change any settings on the server? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
finding html tags
Hi All - I am trying to find if a particular string has html tags in it. For example cfset myStr = pHello WOrld/p I am using the following line of code to see if p tags exist cfoutput#FindNoCase(p,htmlCodeFormat(myStr))#/cfoutput The above always returns 0. Do I need to use regex to achieve the desired result? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: FarCry CMS question
Yes you are right. go.cfm is using URL.path where as farcry 6 is using furl variable. I am using farcry 6. I have read through the docs, and its not mentioned clearly anywhere about the friendlyURL. Can you tell me if my understanding is correct below: 1) User requests a page with url like www.example.com?objectid=2129873akjlsdlasjdl 2) Farcry checks if the friendly url variable is turned on, and then parses the above URL to a friendly URL 3) Once the friendlyURL is constructed, the page redirects to friendlyURL? Thanks. On Wed, May 9, 2012 at 1:13 PM, Jake Churchill reyna...@gmail.com wrote: I think the table is farFU. I know there's a CFC with that name so it should have been scaffolded or whatever by default. Each object can have multiple friendly URLs (see the SEO tab for pretty much anything in the Site tab in the admin). It's been a while since I messed with this stuff. There used to be a fu.cfc but I don't think that's there anymore and go.cfm might be deprecated as well. In looking at the documentation, it looks like as of version 5, it uses furl instead of path in the URL which looks to be parsed in the core Application.cfc around line 581 for me which makes use of the parseURL method in farFU.cfc. Hope that helps. -Jake On Wed, May 9, 2012 at 12:41 PM, fun and learning funandlrnn...@gmail.comwrote: Jake, Thanks for answering. I already posted in the facry google groups 4 hours back, and the moderators still did not approve my question, so thought I'd take a chance here I already set the apache mod_Rewrite conditions. My question was more when the objectid is parsed to friendly URL. The friendly url converts the objectid into its respective marketing name. I want to check the query it is using to get the marketing name. I am guessing a query like below: select * from table1 where objectid = '#URL.objectid#' Check out the farcry developers group: http://groups.google.com/group/farcry-dev?pli=1 The URL's are parsed to friendly when the page/nav is created. In the admin there's a way to reprocess all friendly URLs but the exact location depends on your version of farcry. You have to be running either apache's re-write mod or ISAPI Rewrite for IIS to get this to work. Everything friendly should filter through the go.cfm file in your root. Look in farcry's wiki, there are rules for how to set up the parsing of friendly urls for apache and ISAPI. Hope that gets you going in the right direction. -Jake On Wed, May 9, 2012 at 12:30 PM, fun and learning funandlrnn...@gmail.comwrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question on scopes
Thanks for the replies. I got my scenario wrong I guess. So when the user select a year say '2000' and proceeds to next page to see some data for that year. then he clicks 'ctrl + n' to open new window. and now he wants to select a different year say 2003 and want to see 2003 data. The purpose for new window is to compare 2000 and 2003 data. I see that session scope/client scope are not valid in this type of case. Any thoughts? On Mon, Sep 19, 2011 at 6:59 AM, Steve 'Cutter' Blades cold.fus...@cutterscrossing.com wrote: C'Mon Claude, store a 4 character value to the db, and hit the db for that value every time a session starts? Just use the cookie. If there's a lot of info, then sure, but don't add unnecessary overhead if you don't have to. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 9/18/2011 5:44 PM, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote: I will need the values to be available for multiple browsers. I mean, the user might want to open a new browser using 'CTRL + N', This is actually not a new browser, but a new window in the same browser. Session variables are available in any window of the same browser. There is no need to save variables in a cookie, session is already maintained through an id in a cookie. If you need to use the same variables across sessions, you will need to save them in the database, set a cookie with some user id. With this id, you can retreive the variables from the database. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question on scopes
@Russ. I am not sure I understand what you are saying. if my index.cfm is as follows: cfset StructClear(session) form name=frm method=post action=results.cfm select name=dd_year option value=20002000/option option value=20012001/option option value=20022002/option option value=20032003/option /select input type=submit value=Submit name=sbtbutton / /form The second page is as follows: *results.cfm* cfset structappend(session,form) cfdump var=#session# a href=onemorepage.cfmGo to next page/a *onemorepage.cfm* cfdump var=#session# a href=index.cfmGo to search page/a I have application.cfm too which has the following line: CFAPPLICATION NAME=myapp setclientcookies=Yes clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(1,0,0,0)# applicationtimeout=#CreateTimeSpan(1,0,0,0)# so now the user is on 'onemorepage.cfm' and from here he opens a new window using 'ctrl + N'. On new window he clicks on 'Go to search page' link, and then select a dfferent tax year. Now, I want the old window to show the old tax year for all pages, and new window to show new tax year for all pages. I tested using both session/client. The problem is If I select a different tax year on new window, and then refresh the old window, the old window shows the new value I hope I am clear. On Mon, Sep 19, 2011 at 10:23 AM, wrote: C'Mon Claude, store a 4 character value to the db If the Tax year is the ONLY information needed, then a cookie may be used. But in my mind, there are often more informations to store about the user, like his name, eMail, address, etc. Then the database approach is better. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question on scopes
@Jonah, Thanks for the solution. Currently, I have been using the same way as you suggested. Was just wondering if there a different way to do the same instead of passing url variables on each page, like define once, use everywhere. (in my case session/client scope have to be ruled out) Thanks. On Mon, Sep 19, 2011 at 12:10 PM, .jonah jonah@creori.com wrote: Ok, that wasn't clear in the beginning. You want to keep track of DIFFERENT years in each window. Since they're both in the same browser and visiting the same site, they'll be receiving the same cookies and therefore the same session. To do this you'll probably need to pass the year along in the URL as you go from page-to-page. On 9/19/11 8:10 AM, funand learning wrote: @Russ. I am not sure I understand what you are saying. if my index.cfm is as follows: cfset StructClear(session) form name=frm method=post action=results.cfm select name=dd_year option value=20002000/option option value=20012001/option option value=20022002/option option value=20032003/option /select input type=submit value=Submit name=sbtbutton / /form The second page is as follows: *results.cfm* cfset structappend(session,form) cfdump var=#session# a href=onemorepage.cfmGo to next page/a *onemorepage.cfm* cfdump var=#session# a href=index.cfmGo to search page/a I have application.cfm too which has the following line: CFAPPLICATION NAME=myapp setclientcookies=Yes clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(1,0,0,0)# applicationtimeout=#CreateTimeSpan(1,0,0,0)# so now the user is on 'onemorepage.cfm' and from here he opens a new window using 'ctrl + N'. On new window he clicks on 'Go to search page' link, and then select a dfferent tax year. Now, I want the old window to show the old tax year for all pages, and new window to show new tax year for all pages. I tested using both session/client. The problem is If I select a different tax year on new window, and then refresh the old window, the old window shows the new value I hope I am clear. On Mon, Sep 19, 2011 at 10:23 AM, wrote: C'Mon Claude, store a 4 character value to the db If the Tax year is the ONLY information needed, then a cookie may be used. But in my mind, there are often more informations to store about the user, like his name, eMail, address, etc. Then the database approach is better. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question on scopes
Thanks for the answer. Between session, client and cookie, I think i will have to use client/cookie to store the values because I will need the values to be available for multiple browsers. I mean, the user might want to open a new browser using 'CTRL + N', so the value of tax year on new window should be the same as the one selected on the old window. One last question is: which is the better option between Client and cookie? On Sun, Sep 18, 2011 at 3:07 PM, .jonah jonah@creori.com wrote: On 9/18/11 11:54 AM, fun and learning wrote: Or you can just do cfset session.dd_year = form.dd_year Yes, in the form submission handler, but you'll need to param session.dd_year otherwise your output will fail until you submit the form. cfparam type=numeric name=session.dd_year default= / Can we use Request scope in this type of situations? No, the request scope only lives for a single page load, everything is gone when the page is sent to the browser. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
Brain, I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing cfset col1 = #'query1.col1# On Tue, Aug 16, 2011 at 4:47 PM, Brian Cain bcc9...@gmail.com wrote: The single quote does not appear. It is a special formatting rule for excel. It makes the column display as a character field by default. It is used specifically to handle leading zeros. Brian Cain On Tue, Aug 16, 2011 at 3:22 PM, funand learning funandlrnn...@gmail.com wrote: If I use a single quote as leading character, then thta single quote would appear in excel sheet right? At what point should I remove the quote? Can anything be done on database side. I mean can the query be formatted in any way? On Tue, Aug 16, 2011 at 2:41 PM, Brian Cain bcc9...@gmail.com wrote: You could also try using a single quote as your leading character. This is how would would enter it in excel without changing the column formatting. BC On Tue, Aug 16, 2011 at 12:56 PM, Brook Davies cft...@logiforms.com wrote: This is an excel issue, not a CF issue. If you set the data type of the column to text it does not happen.. http://www.google.ca/search?hl=enclient=firefox-ahs=vpOrls=org.mozilla%3A en-GB%3Aofficialbiw=1920bih=1084q=excel+truncates+leading+zerobtnG=Searc hoq=excel+truncates+leading+zeroaq=faqi=aql=gs_sm=sgs_upl=0l0l0l18408l 0l0l0l0l0l0l0l0ll0l0 Brook -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: August-16-11 10:35 AM To: cf-talk Subject: coldfusion spreadsheet leading zeroes issue Hi All - I am facing an issue with coldfusion9 spreadsheet functions. It cuts of leading zeroes. This is what I am trying. I am getting array of data and using spreadsheetaddrows. When I am constructing an array, am using quotes so as to preserve the zeroes but with no effect. Adding some characters like ~ helps. But when I am adding space, coldfusion is not preserving the spaces. Is there a better way to handle this issue? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing cfset col1 = #'query1.col1# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
If I use a single quote as leading character, then thta single quote would appear in excel sheet right? At what point should I remove the quote? Can anything be done on database side. I mean can the query be formatted in any way? On Tue, Aug 16, 2011 at 2:41 PM, Brian Cain bcc9...@gmail.com wrote: You could also try using a single quote as your leading character. This is how would would enter it in excel without changing the column formatting. BC On Tue, Aug 16, 2011 at 12:56 PM, Brook Davies cft...@logiforms.com wrote: This is an excel issue, not a CF issue. If you set the data type of the column to text it does not happen.. http://www.google.ca/search?hl=enclient=firefox-ahs=vpOrls=org.mozilla%3A en-GB%3Aofficialbiw=1920bih=1084q=excel+truncates+leading+zerobtnG=Searc hoq=excel+truncates+leading+zeroaq=faqi=aql=gs_sm=sgs_upl=0l0l0l18408l 0l0l0l0l0l0l0l0ll0l0 Brook -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: August-16-11 10:35 AM To: cf-talk Subject: coldfusion spreadsheet leading zeroes issue Hi All - I am facing an issue with coldfusion9 spreadsheet functions. It cuts of leading zeroes. This is what I am trying. I am getting array of data and using spreadsheetaddrows. When I am constructing an array, am using quotes so as to preserve the zeroes but with no effect. Adding some characters like ~ helps. But when I am adding space, coldfusion is not preserving the spaces. Is there a better way to handle this issue? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid bind question
Hi All- I am trying to use cfgrid, as below cfgrid name=usersgrid pagesize=5 format=html width=100% height=200 bind=cfc:SysAdmin.cfc.lookupUsers.getAllUsers({cfgridpage},{cfgridpa gesize},{cfgridsortcolumn},{cfgridsortdirection},{filtercolumn},{filte r}). I also have a application.cfm file which is checking for a URL variable as below: cfif URL.login EQ 0 cflocation url=Login.cfm /cfif The problem is the call to remote cfc is checking for this URL variable. How can I pass a URL variable in the bind attribute? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339780 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfselect and autosuggest
Yes cfselect does not have autosuggest attribute. On Wed, Nov 17, 2010 at 11:15 AM, morgan l greyk...@gmail.com wrote: I'm pretty sure cfselect doesn't have a built-in autosuggest. On Wed, Nov 17, 2010 at 10:08 AM, Azadi Saryev azadi.sar...@gmail.com wrote: On 17/11/2010 22:13 , fun and learning wrote: without using javascript or javascript libraries without *using* js - no. wihtout *writing any js yourself* - yes, if you are on cf8+: use cfinput with autosuggest attribute. Azadi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfssetting showdebugoutput
I am using access=remote in cffunction, and cfsetting showdebugoutput=no immediately after the cfcomponent tag. This does not work either. i also tried using cfsetting in application.cfm with no use. Any other alternatives I can try? On Sun, Oct 10, 2010 at 7:40 PM, enigment enigm...@gmail.com wrote: I'm pretty certain that no, false, and 0 all have the same effect. Dave On Sun, Oct 10, 2010 at 3:43 PM, Reed Powell r...@powellgenealogy.com wrote: You want cfsetting showdebugoutput=No not false. It will stop any debug output, just as if you removed your IP address from the list in cf admin. It will not have any effect on error output, etc. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Extra Comma prepends to a form variable
Hi All, I have a form variable which contains a list for example ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Comma Prepending to a form variable
Hi All, I have a form variable which contains a list of names like input type=hidden name=varList value=coldfusion,java,dotnet when I go from the current page to another page and I check the above form value, I have it as input type=hidden name=varList value=,coldfusion,java,dotnet I am getting that extra comma before the first value. How to make sure I do not have that extra comma? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Comma Prepending to a form variable
You are right guys...Thanks a lot for the hint...that really helped me... On Tue, May 18, 2010 at 1:59 PM, Paul Alkema paulalkemadesi...@gmail.comwrote: Is it possible that you have more than one field with the name varList on the page? If you have two form field on the same page with the same name. Your action page will insert a comma in the form fields to delimit the fields. Paul Alkema http://paulalkema.com/ -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: Tuesday, May 18, 2010 1:50 PM To: cf-talk Subject: Comma Prepending to a form variable Hi All, I have a form variable which contains a list of names like input type=hidden name=varList value=coldfusion,java,dotnet when I go from the current page to another page and I check the above form value, I have it as input type=hidden name=varList value=,coldfusion,java,dotnet I am getting that extra comma before the first value. How to make sure I do not have that extra comma? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: what is wrong with this code
Hey Jason, It works for me too...Thanks a lot... On Thu, Apr 15, 2010 at 5:29 PM, Jason Fisher ja...@wanax.com wrote: This works for me: function jscript1(){ var theString = screen1.cfm; var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href=\##\ onclick=\javascript:return parent.frames[1].XYZ(\' + fileName + \')\Link1/a; alert(callURL); } On 4/15/2010 5:14 PM, fun and learning wrote: callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ(\ + fileName + \)'Link1/a; Does not work..Shows syntax error. On 4/15/2010 4:58 PM, fun and learning wrote: Hi All, I know this is coldfusion forum, but can any one tell me what I am missing to make the fileName get within quotes in javascript. I am getting everything right except in callURL, the fileName is sent as argument, but the real value is not enclosed within quotes. I tried different combinations but its not working. the actual callURL value when outputted should be a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a but the value I am getting right now is a href='##' onClick='javascript:return parent.frames[1]. XYZ(screen)'Link1/a Below is the code: function jscript1(){ var theString = 'screen1.cfm' var fileName = theString.substring(0,theString.lastIndexOf(.)); callURL = a href='##' onClick='javascript:return parent.frames[1]. XYZ( + fileName + )'Link1/a; } ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting frame name in Coldfusion
Is there a way to determine the frame's name in coldfusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332894 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Eclipse search question
Thanks a lot for the replies..it works for me On Sat, Apr 10, 2010 at 11:47 PM, Greg Morphis gmorp...@gmail.com wrote: Ctrl + H and change the scope?.. I usually only have a couple projects open so Workspace works for me On Sat, Apr 10, 2010 at 10:36 PM, fun and learning funandlrnn...@gmail.com wrote: Hi, Is there a way in Eclipse (I am using CFEclipse) to search for something in the entire project folder. I see that option of searching the entire folder in Dreamweaver, but not in eclipse unless I am missing something. Can any one please clarify this? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: test
Actually, I am not able to see my post on houseoffusion.com website. I am able to get them to my gmail immediately.. On Wed, Apr 7, 2010 at 12:32 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Actually it is a header, though maybe not one you would expect. Each email message sent has a unique message-id. When gmail sees 2 emails with the same message-id, it keeps the first (the one you sent) and discards the second (the one from the list). I wrote the list software to keep the message-id of a message sent to the list and duplicate it on the message going out. Two messages of the same message-id, even though they have different bodies and other headers, are the same message according to gmail. All I have to do is assign a new message-id to outgoing emails and they'll show up in gmail no matter what. -- Michael Dinowitz On Wed, Apr 7, 2010 at 11:52 AM, Tom Chiverton tom.chiver...@halliwells.com wrote: On Wednesday 07 Apr 2010, Michael Dinowitz wrote: If there is a call for it, I can alter the list code to 'force' gmail to always display an email that you send to the list, resulting in one Is this just a header or something other software can use ? -- Helping to proactively transition fourth-generation meta-services as part of the IT team of the year 2010, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.cohttp://www.halliwells.co/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Difference between 3 tier architecture and MVC pattern
Hi All, I was trying to understand the concepts of fusebox and came across MVC design pattern, Can anyone please help me in understanding the difference between MVC and 3 tier architecture. I am confused as both are concerened with separation of layers? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading a flat file
Got it...Thanks On Sun, Nov 1, 2009 at 3:54 PM, fun and learning funandlrnn...@gmail.comwrote: Hi, I have a flat file with rows of data as follows: 12/12/2009,AL,Alabama 12/12/2009,AK,Arkansas I am able to read the file using cffile read action. Once I read the file, I should be able to compare the state in the flat file with customer state(which is retrieved from a database). I need to loop over the flat file and store the state in some variable. Can anyone please suggest how can this be accomplished? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327890 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 problem when navigating to a coldfusion page
Thanks a lot Claude. There was an application.cfc file in the webroot which I did not notice. Now its working... On Sat, Jul 25, 2009 at 3:52 PM, Claude Schneegans schneeg...@internetique.com wrote: Can anyone please help me in knowing what is causing this problem? May be some redirection in some /Trying/Jsonlearn/Application.cfm ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: directorywatcher event gateway...doesn't work for me
Is the gateway instance running in Coldfusion admin? You are saying that you have changed a file in the directory?.Was it running fine before the changes? Is the CF path in the admin same as the one in the configuration directory? On Fri, May 1, 2009 at 6:02 PM, Yuliang Ruan yuliangr...@hotmail.comwrote: So I'm setting up a new event gateway instance. I created jobsentry.cfg and jobsentry.cfc and started up the instance. I edited a file in the directory and got an error in the log file that says: Error invoking CFC for gateway JobSentry: null {ORIGINATORID={},CFCMETHOD={onChange},GATEWAYID={JobSentry},DATA={{TYPE={CHANGE},LASTMODIFIED={Fri May 01 16:41:49 CDT 2009},FILENAME={/home/me/files/newfile.log}}},CFCPATH={/home/me/JobSentry.cfc},GATEWAYTYPE={FileWatcher}}. What does it mean? JobSentry.cfg: directory=/home/me/files interval=1000 extensions=log,don changeFunction=onChange addFunction=onAdd deleteFunction=onDelete JobSentry.cfc (I just started as a skeleton: cfcomponent cffunction access=remote name=onAdd output=no cfargument name=cfEvent type=struct required=yes /cffunction cffunction access=remote name=onChange output=no cfargument name=cfEvent type=struct required=yes /cffunction cffunction access=remote name=onDelete output=no cfargument name=cfEvent type=struct required=yes /cffunction /cfcomponent ~| 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:322235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Report Builder and Excel format
Hi Everyone, I was trying to display a report in excel format in report builder. It shows the data, but I do not find the print button options, whereas I can see it with other formats. Is this the way it is, or do I need to format anything more within my report for showing up the print button option?This is only happening for excel format It would be great if someone can help me with this 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:321753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4