Displaying page loading message
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:358073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfquery multiple column search
All - I am working on a search functionality for multiple columns of data. I using 'OR' condition for searching on a single search input. For example on front end i have a search input box, and I can enter either numeric or alphabets or alphanumeric characters. How can I handle this using cfqueryparam? if the database column is a numeric, and I enter alphabets, I get errors like Invalid data %0% for CFSQLTYPE CF_SQL_INTEGER. I am first retreiving the full result set and performing query of queries to filter on the search criteria. my query of query looks like below. The above error happens on col5 search when I search string characters like 'abc'. Are there any functions in coldfusion that help with this kind of scenarios? cfquery name=getinfo dbtype=query SELECT col1, col2, col3, col4, col5 FROM getinfo WHERE (lower(col2) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col3) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col4) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col5) like lower(cfqueryparam cfsqltype=cf_sql_integer value=%#val(Arguments.search)#%) ) /cfquery ~| 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:357647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Element undefined in SESSION scope
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:356405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
java.lang.IllegalArgumentException
We have hidden form variable whose value is set to #cgi.remote_address#. For testing security vulnerabilities, add on like hackbar is used to inject a different value for the hidden variable like below. Variable1=%u002e%u002e%u2215%u002e%u002e%variable2= When the form is run using the firefox add on, an error occurs as below. The error message java.lang.IllegalArgumentException is reported as a vulnerability for information leakage. We already have a custom error message but this error does not seem to be handled by it. What would be the best way to handle this? ROOT CAUSE: java.lang.IllegalArgumentException at coldfusion.filter.FormScope.parseName(FormScope.java:400) at coldfusion.filter.FormScope.parseQueryString(FormScope.java:358) at coldfusion.filter.FormScope.parsePostData(FormScope.java:327) at coldfusion.filter.FormScope.fillForm(FormScope.java:277) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:438) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:33) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) javax.servlet.ServletException: ROOT CAUSE: java.lang.IllegalArgumentException at coldfusion.filter.FormScope.parseName(FormScope.java:400) at coldfusion.filter.FormScope.parseQueryString(FormScope.java:358) at coldfusion.filter.FormScope.parsePostData(FormScope.java:327) at coldfusion.filter.FormScope.fillForm(FormScope.java:277) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:438) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:33) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:70) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at
Issue with Session scope
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:355026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
question on cfloop
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:354738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
question on cfloop
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:354739 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
Try to Check and fine tune your jvm settings. On Feb 5, 2013 11:06 PM, J.J. Merrick j...@panos.cc wrote: Would there be a performance hit if the server monitor is enabled for long periods of time? ~| 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:354570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion log file setting
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:354355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion app response slow
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:354298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Redirecting PDF documents
Just wondering if it possible to redirect a pdf document. In coldfusion, I am assuming no since we need to have some kind of redirect code on that particular page we want to redirect? ~| 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:353578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfftp with SSL (Coldfusion 8)
All - Is it possible to use cfftp to connect to a secure ftp server over SSL? Thank you. ~| 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:353532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfftp with SSL (Coldfusion 8)
From memory, SFTP support was added to ColdFusion in version 8. So, yes. SSL FTP is available to you. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Tue, Dec 18, 2012 at 11:35 AM, fun and learning funandlrnn...@gmail.comwrote: All - Is it possible to use cfftp to connect to a secure ftp server over SSL? Thank you. ~| 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:353536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfftp with SSL (Coldfusion 8)
But livedocs show support only for SSH http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_18.html. The same steps do not work when connecting to SSL. From memory, SFTP support was added to ColdFusion in version 8. So, yes. SSL FTP is available to you. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Tue, Dec 18, 2012 at 11:35 AM, fun and learning funandlrnn...@gmail.comwrote: All - Is it possible to use cfftp to connect to a secure ftp server over SSL? Thank you. ~| 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:353537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Changes do not show up on live website
Hi All - We are using Coldfusion with farcry CMS. I made some changes and pushed them live, but changes do not seem to reflect on the site. We recycled the servers, and the change showed up, but after a page refresh it stopped showing up. Can anyone have any clues 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:353462 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
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:353464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
duplicate keys in rss xml feed
Hi All - I am parsing rss feed. The feed has custom data and custom data can have duplicate attributes. I am following the example at http://www.raymondcamden.com/index.cfm/2008/4/23/Ask-a-Jedi-Handling-RSS-feeds-with-custom-data. For example if the feed has following data, and the last custom attribute npr:rmaudio is defined twice but with different values. How can I get those two values. Currently, I am able to get the first value only. 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 linkhttp://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 guidhttp://www.npr.org/templates/story/story.php?storyId=89862645amp;ft=1amp;f=2/guid npr:wmaudiohttp://www.npr.org/templates/dmg/dmg_wmref_em.php?id=89863241amp;type=1amp;date=22-Apr-2008amp;mtype=WM/npr:wmaudio npr:rmaudiohttp://www.npr.org/templates/dmg/dmg_rpm.rpm?id=89863241amp;type=1amp;date=22-Apr-2008amp;mtype=RM/npr:rmaudio npr:rmaudiohttp://www.npr.org/templates/dmg/dmg_rpm.rpm?id=89863241amp;type=21amp;date=22-Apr-2008amp;mtype=RM/npr:rmaudio /item ~| 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:353366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: parsing rss feed in Coldfusion
Thanks for the reply. It was happening because the feed has ' ', in some of the entries. I am just using replace function to replace it with 'and ' I think it might be a white space problem. Ben Nadel wrote a helpful blog about it sometime ago http://www.bennadel. com/blog/1206-Conten t-Is-Not-Allowed-In-Prolog-ColdFusion-XML-And-The-Byte-Order-Mark-BOM-. htm Matt Sent from my iPhone On 4 Dec 2012, at 21:45, fun and learning funandlrnn...@gmail.com wrote: Hi All - I am trying to parse a wordpress feed in Coldfusion. Below is the code I have. cfhttp url=http://test.com/feed/; result=objGet/cfhttp The result dump works fine cfdump var=#objGet# The problem is when parsing the XML. cfset xmlResult = XmlParse(objGet.FileContent) / I get this error An error occured while Parsing an XML document. The entity name must immediately follow the '' in the entity reference. I tried using XMLFormat to escape special characters, but I get this error when I use XMLFormat - An error occured while Parsing an XML document. Reference is not allowed in prolog Any suggestions on how to fix 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:353367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfftp error 533
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:353373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
parsing rss feed in Coldfusion
Hi All - I am trying to parse a wordpress feed in Coldfusion. Below is the code I have. cfhttp url=http://test.com/feed/; result=objGet/cfhttp The result dump works fine cfdump var=#objGet# The problem is when parsing the XML. cfset xmlResult = XmlParse(objGet.FileContent) / I get this error An error occured while Parsing an XML document. The entity name must immediately follow the '' in the entity reference. I tried using XMLFormat to escape special characters, but I get this error when I use XMLFormat - An error occured while Parsing an XML document. Reference is not allowed in prolog Any suggestions on how to fix 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:353361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
parsing rss feed in Coldfusion
Hi All - I am trying to parse a wordpress feed in Coldfusion. Below is the code I have. cfhttp url=http://test.com/feed/; result=objGet/cfhttp The result dump works fine cfdump var=#objGet# The problem is when parsing the XML. cfset xmlResult = XmlParse(objGet.FileContent) / I get this error An error occured while Parsing an XML document. The entity name must immediately follow the '' in the entity reference. I tried using XMLFormat to escape special characters, but I get this error when I use XMLFormat - An error occured while Parsing an XML document. Reference is not allowed in prolog Any suggestions on how to fix 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:353362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cflocation not working
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:353184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cflocation not working
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:353185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue with scheduled task
All - I have a scheduled a task to run weekly. When it did not run (it should send an email when it finished running), I tried running it by going to scheduled tasks page in cf admin and clicking on 'Run Scheduled task'. AFter a min or so, it throws the following error There was an error running your scheduled task. Reasons for which scheduled tasks might fail include: The scheduled task is paused The URL is a redirection URL. The URL is protected by IIS NT Challenge/Response or Apache .htaccess password. The Username and Password text fields for editing a scheduled task are intended to support Basic Authentication only. The Domain Name lookup failed. Try using the IP address of the domain whenever possible. The URL is an SSL site, but the SSL port was specified incorrectly. The Web site is not responding. The directory specified for published results does not exist. What is the best way to find out what the issue could be from the above list ~| 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:353069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
alias URL not recognizing relative paths
Hi All - I have an issue with the following scenario. I have a website www.abc.com. For the path www.abc.com/test, an alias is defined as test.com which points to www.abc.com/test. The new alias test.com is not recognizing the relative paths defined in www.abc.com/test. I am using IIS server. Do I need to update any other settings in IIS for the alias to work properly? 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:353013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: alias URL not recognizing relative paths
I have a website www.abc.com. For the path www.abc.com/test, an alias is defined as test.com which points to www.abc.com/test. The new alias test.com is not recognizing the relative paths defined in www.abc. com/test. I am using IIS server. Do I need to update any other settings in IIS for the alias to work properly? I'm not sure what you did exactly, but you can't create an alias (virtual web server) and have it inherit other aliases (virtual directories). Each virtual server has to have its own virtual directories created specifically for it. 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. Thanks Dave, but I am not sure I follow you. In my case, both the websites www.abc.com and test.com are hosted on same server. but test.com points to abc.com/test. Are you saying that test.com cannot access the resources under abc.com using relative path? ~| 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:353015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: alias URL not recognizing relative paths
I have a website www.abc.com. For the path www.abc.com/test, an alias is defined as test.com which points to www.abc.com/test. The new alias test.com is not recognizing the relative paths defined in www.abc. com/test. I am using IIS server. Do I need to update any other settings in IIS for the alias to work properly? I'm not sure what you did exactly, but you can't create an alias (virtual web server) and have it inherit other aliases (virtual directories). Each virtual server has to have its own virtual directories created specifically for it. 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. I apologize, but all the settings look right but this issue seems to be happening in in chrome and safari... ~| 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:353016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
converting EST to CST
Hi ALl - Here is the scenario I am working on. We have certain data that should not be displayed until a certain date and time. For example, in database we save this date and time and on web page we check if the data has passed that date and time. All the data is assumed to be saved in CST since our local time zone is CST Now, it is required to assume that the time saved is in EST. So when we set that the data should not be displayed until 10/11/2012 12PM, the data should be displayed at 11AM CST on 10/11/2012 instead of 12PM CST. How can I update my query to subtract one hour? query would be like: select * from tbl where date #Now()# 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:352883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: converting EST to CST
Have you looked at the date functions? Like, say, dateAdd()? On Wed, Oct 10, 2012 at 4:34 PM, fun and learning funandlrnn...@gmail.comwrote: Yes, I did see that after posting the message. I think this would do it DateAdd(h, -1, #Now()#) 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:352885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Resolving security vulnerability
Hi All, I am using input hidden fields for some CGI variables. The security scan has issued 'information leakage' threat. These variables are defined in a file and the file is included in various places. What is the best way to resolve this vulnerability? 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:352852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Resolving security vulnerability
what information is passed around in the hidden fields, is it anything that could be used to hijack sessions, get into users accounts or personal details etc ? On Thu, Oct 4, 2012 at 3:11 PM, Rob Voyle robvo...@voyle.com wrote: It is remotehost,remoteaddress ~| 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:352855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
calling coldfusion page from SSIS package
Hi All - I have the following scenario 1) Coldfusion page is run as a scheduled job 2) After the above script is run, a SSIS package is run. I want to make sure that the Coldfusion job is successful before running the SSIS package. Is there a way to call the coldfusion job from SSIS package to syncrhonize both the jobs? ~| 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:352651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: calling coldfusion page from SSIS package
If it is the CF job that executes the SSIS package, surely the very fact that it running is proof that the cf job executed. On Tue, Sep 18, 2012 at 4:35 PM, fun and learning funandlrnn...@gmail.comwrote: No it is not the cf job that executes the SSIS job. They are run independent of each other. I am trying to synchronize them. 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:352654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
question on cfhtmlhead
Hi - I want to exclude one of the page from search engine crawling. I am using the following tag meta name=robots content=noindex,nofollow Also I am inserting the above tag through cfhtmlhead. My question is if search engine would recognize this meta tag that is inserted into head later in the page. I hope I made myself clear. 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:352247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: question on cfhtmlhead
They will. Before search engine sees your pages, CF processes the cfhtmlhead and inserts the meta tag into the head of the page. Same as with an end-user. On Tue, Aug 21, 2012 at 3:09 PM, fun and learning funandlrnn...@gmail.comwrote: Thanks a lot. all your answers are really helpful ~| 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:352252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfcalendar does not work in chrome
Hi All - I am using cf 9 version and cfcalendar. This does not seem to be working only on chrome. The date value is not getting passed to the next page. I get the following error in chrome console Uncaught ReferenceError: updateHiddenValue is not defined And in network tab of chrome, the following returns 304 not modified cfform.swc.cfswf Does anybody have an idea why this could be happening? 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:352203 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:351957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfhttp issue
Issue with cfhttp I am using cfhttp get to request an xml file that resides on the same server. It was working fine until yesterday, but it throws the following error now I keep getting that the user trying to access the page has ben logged in successfully but the user does not have permission to open the file. The permissions looks fine Any idea 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:351324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfhttp issue
Issue with cfhttp I am using cfhttp get to request an xml file that resides on the same server. It was working fine until yesterday, but it throws the following error now I keep getting that the user trying to access the page has ben logged in successfully but the user does not have permission to open the file. The permissions looks fine Any idea on why this could be happening JUST for the information, I am able to access the xml file directly in 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:351325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfhttp issue
Issue with cfhttp JUST for the information, I am able to access the xml file directly in the browser Never mind it was some anonymous user authentication issue. got it working now ~| 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:351326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
query of query strange error
Hi All- I am facing a strange error with query of query as follows: I am first constructing a query using 'QueryNew' as Cfset newQuery = QueryNew(id, status, label, name) the status column is a numeric column in database with values of 1,2,3,4,5,6 and NULL When I do a query of query as below, I get an error 'The value '' cannot be converted to a number'. This does not happen always: cfquery dbtype=query name=qoq select * from newQuery /cfquery ANy thoughts 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:351284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
apache for both coldfusion and php at same time
Hi All, On local development at home, I use coldfusion built in Jrun. I am trying to install farcry and learn on friendly urls, so thought it is good idea to install coldfusion with apache. I already using WAMP on local machine for learning wordpress. Is it possible to use apache simultaneously for coldfusion as well as php? Please advice ~| 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:351120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
FarCry CMS question
I hope someone with knowledge of farcry CMS sees this question I am new to farcry and looking at some existing code. I have a question on friendly URL. At what time of the application do the actual URL gets parsed to friendly URL. Suppose I have a href link as a href=www.example.com?objectid=123askjhdakjshdkasjhdGo to new page/a When I click the above link, the new page URL is a friendly URL. I checked in onApplicationStart, but the URL is constructed even before that. Can you let me know at what time is the URL parsed, and which function does it? Is it fixURL function in utils.cfc? ~| 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:351085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: FarCry CMS question
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:351087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion MS acess question
Hi All - I am have a strange problem with a query which works directly on MS Access but fails when used inline in Coldfusion. I am using SELECT datepart(q, datecolumn), column1, column2 FROM table When I remove the datepart in coldfusion, it works fine. Any idea why this could he 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:350794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion MS acess question
datepart(q, datecolumn), column1, column2 It might be that the query has no name for the datepart column. Try datepart(q, datecolumn) AS quarter, column1, column2 The error says Too few parameters. Expected 1. I did use an alias for the column, but it does not help ~| 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:350798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion MS acess question
Too few parameters. Expected 1 This is supposed to mean that one of le column names is not found in the table. Why don't you post the whole query here? ~| 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:350802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion MS acess question
Too few parameters. Expected 1 This is supposed to mean that one of le column names is not found in the table. Why don't you post the whole query here? The query works fine in MS Access, but creating problems in ColdFusion. Instead I have decided to use ColdFusion quarter function to achieve the same result. Thanks for the answers ~| 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:350803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 9 certification
Hi All - Having worked with Coldfusion for the past three years, I am planning to get a Coldfusion certification. Since Coldfusion 9 is the latest stable version,I am planning to get certified in it (My main aim in getting certified is I may get to learn stuff I have never used, and to go in depth for some of the topics). What do you people suggest? Are there any mock tests for CF9 like CF8 buster? 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:350577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Opening a word document saved on a server
Hi All - I have used cfcontent to write some data to excel docs. I am trying to do the following - I have a drop down, and when one of the value is selected, I need to open a word document that is saved on the server. opendoc.cfm cfset dir = #GetDirectoryFromPath(cgi.cf_template_path)# cfheader name=Content-Disposition value=inline; filename=myworddoc.doc cfcontent type=application/msword file=#dir#myworddoc.doc When the user selects a dropdown value, I am calling a javascript fucntion with following code window.open(opendoc.cfm); The above coldfusion code fails. Let me know if its possible to open a word document from server using cfcontent and cfheader ~| 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:349510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Opening a word document saved on a server
What do you mean fails? On Mon, Jan 16, 2012 at 14:58, fun and learning funandlrnn...@gmail.comwrote: It does not work. It does not throw any error. It tries to open a tab and immediately closes it. ~| 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:349512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Troubleshooting slow web service calls
I have a web service created in coldfusion, and consumed from a coldfusion page. The problem is that the web service call is very fast in development environment, where as its very very slow in production environment. What is the best way to go about troubleshooting what is causing the problem? The database calls are fast too. Any help would be great. 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:349381 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfstored proc question
Hi All - In our coldfusion code, there is a cfstoredproc block in which some parameters are being passed in. Couple of paramaters are of out type. cfstoredproc procedure=proc_save datasource=#Application.DSN# cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=#FORM.FirstName# dbvarname=p_firstName cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=#FORM.LastName# dbvarname=p_lastName cfprocparam type=Out cfsqltype=CF_SQL_VARCHAR variable=#Form.Roll_Id# dbvarname=p_roll_id cfprocparam type=Out variable=Variables.retval cfsqltype=CF_SQL_VARCHAR dbvarname=p_retvalue /cfstoredproc In the above code, the third paramter is a out type, and the variable attribute is surrounded by hashes. What does that mean? In some cases, the procedure works fine, but in some cases it throws the following error You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. ~| 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:348950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfstored proc question
Never mind. I understood my problem. ~| 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:348951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Question on scopes
Hi All- I have a question on variable scopes. I have the following scenario. Suppose I have a dropdown as below with some tax years: 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 So once the user logins and selects a year from the drop down, upon clicking the submit button, the year value should be available across all pages. What is the best way to store the value? I mean in which scope? 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:347501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question on scopes
Or you can just do cfset session.dd_year = form.dd_year I swear.. Sometimes, people make things more convoluted then they have to. :) On Sun, Sep 18, 2011 at 11:18 AM, Steve 'Cutter' Blades cold.fus...@cutterscrossing.com wrote: Can we use Request scope in this type of situations? ~| 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:347505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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:346789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
excel sheets poiutility.cfc
Hi All - This is a third version of generating to excel options that I am trying. I was going through the examples. If I am using apache poi, should I always write to excel, then read it and display it to the user? Is it possible to just read it directly from the query and display it to the user? ~| 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:346808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
quick excel question
Hi All - I am trying to generate excel using xml. I have a scenario where only 7 columns will be static and other columns are dynamic and may range from 1 to as many as 300 columns. And number of rows would be around 1000. What is the best approach for this situation. I tried new cf9 spreadhsheet but it failed just for few columns. XML workbook works fine where cf9 spreadsheet failed. I am just wondering will using apache poi directly will be of any use since I think cf9 spreadhseet also uses poi 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:346699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Using excel NumberFormat in coldfusion
Hi All - As suggested by a couple of coldfusion developers a weeks ago, I am using xml to generate excel sheets from coldfusion. I am stuck with the following issue. Style ss:ID=s71 Borders Border ss:Position=Bottom ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Left ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Right ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Top ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ /Borders NumberFormat ss:Format=#,##0/ /Style The number format within Style tags above has pound signs which Coldfusion does not like. Escaping them does not produce the desired result. Can anyone suggest a work around for this issue? ~| 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:346616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf9 multiple sheet excel
Hi All - I am trying to generate a multiple tabs excel sheet. I have the following code. The excel code is copied from coldfusionjedi.com cfset q = queryNew(Name,Beers,Vegetables,Fruits,Meats, cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer) cfloop index=x from=1 to=10 cfset queryAddRow(q) cfset querySetCell(q, Name, Name1) cfset querySetCell(q, Beers, 2) cfset querySetCell(q, Vegetables, 15) cfset querySetCell(q, Fruits, 33) cfset querySetCell(q, Meats, 3) /cfloop cfset filename = expandPath(./myexcel.xls) !--- cfspreadsheet action=write query=q filename=#filename# overwrite=true --- !--- Make a spreadsheet object --- cfset s = spreadsheetNew() !--- Add header row --- cfset spreadsheetAddRow(s, Name,Beers,Vegetables,Fruits,Meats) !--- format header --- cfset spreadsheetFormatRow(s, { bold=true, fgcolor=lemon_chiffon, fontsize=14 }, 1) !--- Add query --- cfset spreadsheetAddRows(s, q) cfset SpreadsheetCreateSheet (s, EvaluationSheet) cfheader name=content-disposition value=attachment; filename=myexcel.xls cfcontent type=application/msexcel variable=#spreadsheetReadBinary(s)# reset=true So the first sheet displays fine. To create a new sheet, I am using spreadsheetCreateSheet. How can I add data to the sheet? I mean I can use cfspreadsheet with action write, but I do not want to save the excel, rather have the user save it. ~| 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:346420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfspreadsheet question
Hi All - In coldfusion 8, we use cfcontent and html to display data in excel, and a save dialog box would be shown. In coldfusion 9, is it possible to show save dialog box when using cfspreadsheet? ~| 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:346401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IIS Question
Hi All - I have a IIS/coldfusion question. I am working with a client, who has both production and development stuff on the same machine. He has two drives, C and E. C drive has development files and E drive has production. The IIS configuration points to E drive. C drive the has the following structure: C:/ - Coldfusion 9 - Inetpub - coldfusion files E:/ - Web - coldfusion files But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question Thanks a lot. ~| 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:343911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IIS Question
Hi All - I have a IIS/coldfusion question. I am working with a client, who has both production and development stuff on the same machine. He has two drives, C and E. C drive has development files and E drive has production. The IIS configuration points to E drive. C drive the has the following structure: C:/ - Coldfusion 9 - Inetpub - coldfusion files E:/ - Web - coldfusion files But confused if IIS can point to two different drives? How to find out which drive the IIS point out to.. I hope I am not vague with my question Thanks a lot. ~| 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:343912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What does this URL mean?
http://localhost/students/index.cfm/register?action=studentreg I did not understand the use of 'register' after index.cfm. Can anyone please help me understand what it could mean? There is a index.cfm file in students folder. Could register be a folder name? ~| 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:343634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Javascript question
Hi All - I am trying to get the following working. It seemed to work initially, but somehow it stopped working I have a row like below tr id=row_1_4_2009_abc class=rowclick td/td /tr I am using jquery to get the id on click of a row: $(.rowclick).click(function() { var row_id = $(this).attr(id); var getAttributes = row_id.split(_); var setCommonAttr = getAttributes[1] + _ + getAttributes[2] + _ + getAttributes[3] + _ + getAttributes[4]; var new_row_id = document.getElementById(new_row_ + setCommonAttr).value; }); Can anyone let me know what is wrong with the above code. Tried different options but with no success ~| 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:342959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Javascript question
Hi All - I am trying to get the following working. It seemed to work initially, but somehow it stopped working I have a row like below tr id=row_1_4_2009_abc class=rowclick td/td /tr I am using jquery to get the id on click of a row: $(.rowclick).click(function() { var row_id = $(this).attr(id); var getAttributes = row_id.split(_); var setCommonAttr = getAttributes[1] + _ + getAttributes[2] + _ + getAttributes[3] + _ + getAttributes[4]; var new_row_id = document.getElementById(new_row_ + setCommonAttr).value; }); Can anyone let me know what is wrong with the above code. Tried different options but with no success ~| 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:342960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Jquery ajax and CFC ioutside webroot
Hi All - Can I use jquery ajax to call a cfc that is located outside the webroot? I tried it but I think it is trying to look for the cfc within web root. How can I get it to point to a cfc outside the webroot? 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:342952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Jquery ajax and CFC ioutside webroot
Hello, in your jquery ajax call, just give the full http address of your cfc, like so : $.ajax({ url: 'http://www.yoursite.com/cfc/yourCFC. cfc?yourmethodyourargumentsIfAny', type: POST, dataType:json}); Cheers Hi All - Can I use jquery ajax to call a cfc that is located outside the webroot? I tried it but I think it is trying to look for the cfc within web root. How can I get it to point to a cfc outside the webroot? Thanks HI, The cfc is located outside of webroot. I cant access it using full site address the structure is as follow: E --Cfc -- website ~| 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:342954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfdocument and javascript
Hi All, I am using cfdocument with format = pdf. I am displaying some dynamic data. I need to have an expand/collapse functionality within the pdf. Is it possible to implement the same using javascript in cfdocument? 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:342782 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Multiline - Dynamic Tabs
Hi All, I am creating dynamic tabs using Coldfusion, HTML(ul and li). I was just wondering if its possible to make them like windows styled tabs, that is if a tab in first line is selected, I want to push it to the second line. The problem I have is I am creating dynamic tabs. Is it possible using Javascript/jquery, to calculate the widths of each tab and determine at which point a second line of tabs would be started? Here is a sample code of what I am doing. http://jsfiddle.net/syEJx/5/ ~| 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:342518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiline - Dynamic Tabs
Hi All, I am creating dynamic tabs using Coldfusion, HTML(ul and li). I was just wondering if its possible to make them like windows styled tabs, that is if a tab in first line is selected, I want to push it to the second line. The problem I have is I am creating dynamic tabs. Is it possible using Javascript/jquery, to calculate the widths of each tab and determine at which point a second line of tabs would be started? Here is a sample code of what I am doing. http://jsfiddle.net/syEJx/5/ I solved the problem. 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:342524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
HTML to excel format
Hi All - I have been using cfcontent to generate excel files in coldfusion. The problem is I need to write two different sets of HTMl code because the cfcontent does not recognize .css files. So for cfcontent part I am using inline style for each row and column. There are lot of reports I need to convert to excel. Is there an alternative way of converting or dumping the html contents into excel? 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:342068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HTML to excel format
I doubt cfcontent is the issue. How are you including the css? Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL I am using it in Application.cfm as a cfinclude. cfinclude template=style.css ~| 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:342076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion webroot and multiple domain names
The client said that using one IP address, several domain names can be used- multiple sites using host header names. I am not sure what that means It means that you'll probably have to create virtual directories for both sites, as several people have mentioned. 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. Thanks for replying. Everything is set up and I am able to access individual sites. The problem is with the images folder. I am not able to get the images to be displayed. Any ideas on this. I gave my directory structure in my initial question. There is another folder at the same level as images and it contains all cfm files. Am able to include cfm files from that folder but not any images. 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:341478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion webroot and multiple domain names
You'll want to create an alias to the images folder between sites. What web server are you using? Sent from my HTC on the Now Network from Sprint! - Reply message - From: fun and learning funandlrnn...@gmail.com Date: Mon, Jan 24, 2011 20:02 Subject: Coldfusion webroot and multiple domain names To: cf-talk cf-talk@houseoffusion.com Hi All - I am new to this multiple domain thing. Am working on a project, where there multiple domain projects under on webroot. Like www.abc.com, www. def.com under one root. The folder structure is something like below: E: webroot --INCLUDES --IMAGES --image.gif -- www.abc.com --folder1 --index.cfm -- www.def.com So the above two diff domains share two common folders. When I use an include file of form .cfm, I can get it to work. But somehow the images are not displayed. I tried the following syntaxes Suppose I want to access images from index.cfm under www.abc. com/folder1, i tried the following: img src=../../IMAGES/image.gif(does not work) img src=E:/webroot/IMAGES/image.gif) (also does not work. The image symbol is shown but the entire image is not shown). Any thoughts on how to get this working? Hi All- Thanks for replying.The client said that using one IP address, several domain names can be used- multiple sites using host header names. I am not sure what that means ~| 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:341231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion webroot and multiple domain names
Hi All - I am new to this multiple domain thing. Am working on a project, where there multiple domain projects under on webroot. Like www.abc.com, www.def.com under one root. The folder structure is something like below: E: webroot --INCLUDES --IMAGES --image.gif -- www.abc.com --folder1 --index.cfm -- www.def.com So the above two diff domains share two common folders. When I use an include file of form .cfm, I can get it to work. But somehow the images are not displayed. I tried the following syntaxes Suppose I want to access images from index.cfm under www.abc.com/folder1, i tried the following: img src=../../IMAGES/image.gif(does not work) img src=E:/webroot/IMAGES/image.gif) (also does not work. The image symbol is shown but the entire image is not shown). Any thoughts on how to get this working? ~| 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:341160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
relative path for images
Hi All - I have a strange situation with relative paths. When I use a relative path in cfinclude it works. But when I use a relative path is src attribute of img, it does not work. Can anyone suggest why could this be happening? 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:341100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
debugging information and scrollbar
Hi All - I am getting a vertical scrollbar even when the contents fit properly on the screen. I am using jqgrid, and using cfsetting showdebugoutput=no on all pages. The scrollbar does not make any sense as there is no content to scroll. Is there a way to remove this, or any pointers on why is this 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:341077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CGI.querystring
Hi All - I have the following piece of code. form name=langchooser action= select name=language size=1 onChange=javascript:if(this.form.language.options[this.form.language.selectedIndex].value!='null'){location.href=this.form.language.options[this.form.language.selectedIndex].value} class=select2 !--- WHAT A piece of c??? #cgi.query_string#language=#langcode# IS WAY OFF; --- cfoutput query=languages !--- cfset structdelete(cgi.query_string,language) --- cfif parameterexists(switch) is yes option value=index.cfm?#cgi.query_string#language=#langcode#switch=#switch# cfif session.language eq langcode selected /cfif#evaluate(session.language _language)#/option cfelse option value=index.cfm?#cgi.query_string#language=#langcode# cfif session.language eq langcode selected /cfif#evaluate(session.language _language)#/option /cfif /cfoutput /select /form As you can see in the options, For the first time I need the 'language' parameter. But when the I change the drop down, the language parameter gets added to the #CGI.querystring#. And on the second refresh, the language variable gets added again to the querystring. Is there a way I can delete the variable from the query string before i change the language option in the drop down? ~| 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:340596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CGI.querystring
Russ, I think you really meant cfset QS = ListAppend(QS, key '=' url[key], ) Azadi On 10/01/2011 07:00 , Russ Michaels wrote: cfset QS = ListAppend(QS,key,) Thanks Russ, Azadi, That worked. ~| 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:340601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Array/List questions
Hi All- I am trying to build a list with following values: cfset list = {name:'col1', index:'col1', sorttype:'string'},{name:'col2', index:'col2', sorttype:'string'},{name:'col3', index:'col3', sorttype:'string'} So the above list has 3 values with each value enclosed within the brackets. When i convert it into array, am getting back 18 values as it is counting each attribute in the value. How can I make it to consider them as 3 values? ~| 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:340522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Array/List questions
So the above list has 3 values with each value enclosed within the brackets. ColdFusion doesn't know that and is seeing ALL of the commas as list delimiters. You'll need to change the delimiter to something else and then break it apart: cfset list = {x,x,x},{x,x,x},{x,x,x} / cfset list = replace(list, },{, }#chr(255){ / cfset theArray = listToArray(list, chr(255)) / What we're doing here is changing the desired delimited (between the closing and opening brackets) to some other unused character (ascii 255 in this case) and then using that as the delimiter for the break, ignoring the commas entirely. -Justin Thanks for replying. I get other problem now. The above list is converted as below: cfset list = {name:'col1', index:'col1', sorttype:'string'},{name:'col2', index:'col2', sorttype:'string'},{name:'col3', index:'col3', sorttype:'string'} Each name:value is getting surrounded by double quotes. How to ignore these? ~| 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:340529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Grid Suggestion
Hi All- Currently i have a grid with around 25 to 30 columns. a)The first 5 columns are frozen columns. The data for these columns are text values or simple numbers b) The values for other 25 columns are images. c) Also implementing highlight row functionality on hover and on click of the row. d) The database queries are very fast, but the UI rendering is very sluggish. The above table is right now implemented using HTML, css, javascript. Tried using alternatives like jqgrid, but it does not have column freezing functionality. Are there any other grids out there which would be a much better choice. Is using Flex a good idea? 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:340465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grid Suggestion
Not sure about column freezing but I'd take a look at SlickGrid: https://github.com/mleibman/SlickGrid/wiki On Wed, Jan 5, 2011 at 10:05 AM, fun and learning funandlrnn...@gmail.comwrote: Hi Michael, Thanks for the suggestion. is there an example of using slickgrid with coldfusion for dynamically loading data? ~| 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:340468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
display html in coldfusion
Hi All- I have a database column whose values are anchor tags: a href=http://www.website.com; target=_blank When I query the table and try to display the column, the value would not display. What could be the 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:340315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
question for jquery experts here
hi All - I am using the following jquery script to hover and click on table rows: $(.simplehighlight).click(function() { $(this).children().addClass('clicked'); $(this).siblings().children().removeClass('clicked'); }); $(.simplehighlight).hover(function() { $(this).children().css('backgroundColor', '#ffdc87'); }, function() { $(this).children().css('backgroundColor', ''); }); 'simplehighlight' is the class name of a tr. The script works fine in Firefox, but the problem comes with IE8. I have around 20 to 25 columns, and For hover, it takes some milliseconds to catch up with the cursor, and with click, it takes around two seconds. Any suggestions on this? I am asking this question in this forum, because lot of Coldfusion developers use jquery. So trying my luck here too. ~| 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:340112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion json truncates leading zeroes
Hi All - I am using jquery jqgrid with Coldfusion. I have a cfc whose return format is JSON. I have a database column of type varchar, but it returns values which starts with zeroes. On displaying data, the leading zeroes are truncated. I verified in firebug, the JSON response itself is cutting off the leading zeroes. Any suggestions or thoughts on 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:340027 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},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},{filtercolumn},{filter}). 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:339783 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:339785 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:339786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfselect and autosuggest
Is there a way to implement autosuggest within cfselect using coldfusion without using javascript or javascript libraries? ~| 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:339306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion and Jquery UI Dialog
HI All - I am trying to create a login popup form using Jquery UI Dialog plugin and coldfusion. I am not able to understand how to authenticate the user on the popup. Whenever I say login, the form is submitted with form variables appended to the url. Can anyone let me know the flow that has to be followed? Below is the code !DOCTYPE html html lang=en head meta charset=utf-8 titlejQuery UI Dialog - Modal form/title link rel=stylesheet href=../../themes/base/jquery.ui.all.css script src=../../jquery-1.4.3.js/script script src=../../external/jquery.bgiframe-2.1.2.js/script script src=../../ui/jquery.ui.core.js/script script src=../../ui/jquery.ui.widget.js/script script src=../../ui/jquery.ui.mouse.js/script script src=../../ui/jquery.ui.button.js/script script src=../../ui/jquery.ui.draggable.js/script script src=../../ui/jquery.ui.position.js/script script src=../../ui/jquery.ui.resizable.js/script script src=../../ui/jquery.ui.dialog.js/script script src=../../ui/jquery.effects.core.js/script link rel=stylesheet href=../demos.css style body { font-size: 62.5%; } label, input { display:block; } input.text { margin-bottom:12px; width:95%; padding: .4em; } fieldset { padding:0; border:0; margin-top:25px; } h1 { font-size: 1.2em; margin: .6em 0; } div#users-contain { width: 350px; margin: 20px 0; } div#users-contain table { margin: 1em 0; border-collapse: collapse; width: 100%; } div#users-contain table td, div#users-contain table th { border: 1px solid #eee; padding: .6em 10px; text-align: left; } .ui-dialog .ui-state-error { padding: .3em; } .validateTips { border: 1px solid transparent; padding: 0.3em; } /style script $(function() { // a workaround for a flaw in the demo system (http://dev.jqueryui.com/ticket/4375), ignore! $( #dialog:ui-dialog ).dialog( destroy ); var name = $( #username ), //email = $( #email ), password = $( #password ), allFields = $( [] ).add( name ).add( password ), tips = $( .validateTips ); function updateTips( t ) { tips .text( t ) .addClass( ui-state-highlight ); setTimeout(function() { tips.removeClass( ui-state-highlight, 1500 ); }, 500 ); } function checkLength( o, n, min, max ) { if ( o.val().length max || o.val().length min ) { o.addClass( ui-state-error ); updateTips( Length of + n + must be between + min + and + max + . ); return false; } else { return true; } } function checkRegexp( o, regexp, n ) { if ( !( regexp.test( o.val() ) ) ) { o.addClass( ui-state-error ); updateTips( n ); return false; } else { return true; } } $( #dialog-form ).dialog({ autoOpen: false, height: 300, width: 350, modal: true, buttons: { Create an account: function() { var bValid = true; allFields.removeClass( ui-state-error ); //bValid = bValid checkLength( name, username, 3, 16 ); bValid = bValid checkLength( username, username, 6, 80 ); bValid = bValid checkLength( password, password, 5, 16 ); //bValid = bValid checkRegexp( name, /^[a-z]([0-9a-z_])+$/i, Username may consist of a-z, 0-9, underscores, begin with a letter. ); // From jquery.validate.js (by joern), contributed by Scott Gonzalez: http://projects.scottsplayground.com/email_address_validation/ bValid = bValid checkRegexp( username,
converting excel to text file
HI All - I am uploading an excel file using coldfusion. Once the file has been uploaded, I want to convert it to a text file. What I am trying to do now is once the file is uploaded, I am reading the excel file and then writing the output to text file. but the write method creates all junk in the text file. What is the best way to do 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:338992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
dropdown question
Hello All - I have a dropwown with multiple option. When the user selects a value, goes to some other screen, and comes back he will be able to see the value selected. This is all fine. But if the user selects some last value in the dropdwon, he has to scroll down to see what has been selected. is there a way to make the dropdown scroll down to the last value automatically? ~| 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:338948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: dropdown question
you just need to set the selected item as selected in the dropdown select name=acme option value=abc selectedtext/option /select when the user submit the form, just store the seelected value in a session variable and use this to set the SELECTED attribute. e.g. select name=acme option value=abc #IIF(StructKeyExists(session,'acme'), 'selected',''))#text/option /select -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk Yes I am doing that with the help of some form variables. I am able to see the selected value. My question is - suppose there are 1000 values in the dropdown and the dropdown is of type 'multiple', and the user selected the 1000nd value, the drop down should be scrolled down to that value when the user does some other stuff and comes back to the screen. ~| 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:338950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
MS Access Coldfusion
Hi All - I am trying to make a query to work in Coldfusion. The query works in MS Access though. I have a column called 'language' in the database table. When I try to refer the column in Coldfusion, I get an error like value '' is invalid. Query is something like select * from table where language = 'english'. When I remove the language criteria, its working fine. I am working in eclipse, and the word language is highlighted like other key words. Is there a way I can work around this problem? 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:338701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS Access Coldfusion
When using reserved word you can put them in [square brackets] and it should still work. So select * from [table] -- Russ Michaels http://www.bluethunderinternet.com: B2B hosting, VPS's, Exchange, CF, Railo www.cfmldeveloper.com : CFML community, FREE ColdFusion/Railo hosting http://www.michaels.me.uk : My Blog skype me : russmichaels Thanks All. Enclosing the column within [] has worked for me. ~| 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:338710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
href mailto
Hi All - I am trying to use mailto functionality with email addresses populated from database and separated by semicolons.. a href=mailto:cfoutput query=email#email#;/cfoutput the funcionaility works sometimes and it does not. I hardcoded around 85 emails and seen that it does not open the mail client at all. It throws an error email client not installed properly around 80 emails, but works fine with 79. Did anyone face this kind of problem? ~| 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:338614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
generating eticket
Hi All - I was just curious if this can be done using coldfusion. Can we generate an e-ticket in Coldfusion. Suppose a user books a movie ticket or a bus ticket, can we send an email with eticket embedded in it ~| 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:338423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm