ColdFusion

Hello,Last week we began seeing some timeout errors, but today there have been much more of them and I’m not sure how to proceed in troubleshooting.We have 2 load balanced app servers:Windows Server 2008 R2 (virtualized)ColdFusion 8, EnterpriseAnd a database server:Windows Server 2008 R2SQL 2012The error in “coldfusion-out.log” is:A non-SQL error occurred while requesting a connection from <DSN>.Timed out trying to establish connectionThis only happens on one of the web servers, but it happens more frequently when the app servers is under a heavier load. Most of the day it works fine, but 4 or 5 times throughout the day we will have 1 – 15 requests timeout in a row(always varies), and then things will be fine again w/out restarting or doing anything.The database server is much more powerful than the app server, and I don't believe the issue involves long running queries or the DB server being under heavy load.I’m a DBA who is temporarily handling System Admin responsibilities, an

I have a data table which displays data like this:0-11-311-1414-21DEPT3.77 0.94 3.46 11.95 SALESSo I have many columns for the 'valuecolumn', and only one column for the 'itemcolumn'. But it looks like in the tag it will only accept one 'valuecolumn' even though I have many. How would I make this work? <cfchartseries type="bar"query="stats"valuecolumn="0-1"itemcolumn="DEPT"</cfchartseries>As you can see I can't put multiple columns into the valuecolumn attribute

I would like to build my first web site on ColdFusion build in server.I would like to know should I just create a folder on C:\ColdFusion10\cfusion\wwwroot for my site or I can use admin web site to creat a new web site?Your information and help is great appreciated,Regards,Iccsi,

I created a few database source on ColdFusion server and used Dreamweaver or ColdFusion Report Builder to access RDS server.I just realized that I can access all datasource from Dreamweaver and ColdFusion Report Builder.I would like to know is it possible to create user rights which only can access the database rights grant.Your information and help is great appreciated,Regards,Iccsi,

I have ColdFusion 10 Report  isntalled and connected to RDS server.I just see tables and views, but not stored procedures.I would like to know is ti possible to use stored procedures for the report data source.Your help and information is great appreciated,Regards,Iccsi,

I would like to use CFMail to send out email.Does CFMail need SMTP mail server to install or ColdFusion has email server?Yuor help and information is great appreciated,Regards,Iccsi,

I would like to know if is possible to create user role on the CodldFusion server.Your help iand information is great appreciated,Regards,iccsi,

I've successfully installed Tomcat 7 on a Macintosh running 10.7.5.  The ColdFusion WAR file deployed successfully, but when I try to start the service, I get a raft of errors in the Catalina.out log file:INFO: Deploying web application archive /usr/local/Tomcat7/webapps/cfusion.warjava.lang.ExceptionInInitializerError          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) ...          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)          at java.lang.Thread.run(Thread.java:680)Caused by: org.apache

I would like to know IsUserInRole ColdFusion function to use get user role, but how I can create user role from ColdFusion?Any function to creat euser role or uses ColdFusion server admin to create or create a role in the backend database?Your help and information is great appreciated,Regards,Iccsi,

Hi,the code below is displayed 5 text boxes but how can i made at least one is required?<cfform name="search" action="insert.cfm" method="post"><cfloop index="email" from="1" to="5"> <cfinput type="text" name="email">   </cfloop>    <cfinput type="submit" name="submit" value="Save"></cfform>thanks

Does anyone know how to extract the value of a cftextarea (html and all) without actually submitting the form? **EDIT** Sorry I forgot to say it was a rich text feild

After many years of dire predictions from myself about using MS Access for a production website, my office has finally bitten the bullet and provided me with MSSQL Enterprise.  FINALLY I no longer have to append disclaimers and apologies to my requests for assistance (unless it's about my sloppy coding).One of the changes in this switch is that my 14 or so existing Access databases have been "squished" into one huge MSSQL database.  The resulting database has around 115 tables, and with no MDB file to open up and look at, I decided to build a "table browser" for my coders to use.  Most of the information that we change frequently already has a web interface, but some of the tables we rarely touch.  Still, I wanted a way to "look around" inside the database.The page I've built basically creates an unordered list of table names in a scrolling left column.  When you click a table name, it expands into a nested list of row names. This all works quite well.  Co

i have a table that has two date fields (dateinx and dateoutx) and i need to find all the results for todays date that both fall between and on that date for a given customer: cID.if todays date is 12/2/2012examples of vialable entries:dateinx=12/2/2012 and dateoutx = 12/5/2012dateinx=11/2/2012 and dateoutx = 12/2/2012dateinx=11/2/2012 and dateoutx = 12/25/2012i am using "smalldatetime" in msSQL2005 and also would like to create a mask so that only date: 1/1/2012 would be saved. same for time: 1:30AM in a seperate field. msSQL is saving now as 1/1/2012 01:30:00AM or some such...querey at this point looks like:SELECT *FROM schdlWHERE (cID = #cID#) AND ....tnx in advanceandy

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7fb9.html

Hi!Many of my websites are using an external stylesheet such as this:<link rel="stylesheet" type="text/css" href="test.css" title="This is a test" />In my 2 laptops, 1 has CF8 and the other has CF10, I just downloaded a few minutes ago.My Boss wanted me to compare because he is thinking of upgrading it to CF10.After I'm done setting up everything (IIS, datasource, etc), I launched my website in both laptops and the result on laptop with CF10 is quite surprising.When I took out: <link rel="stylesheet" type="text/css" href="test.css" title="This is a test" /> from <head></head> and replace it with:<style> css codes from test.css </style>  I got my style back.So, for some reason, CF10 ignores <head><link rel="stylesheet" type="text/css" href="test.css" title="This is a test" /></head>Does CF10 can't work with external stylesheet anymore? or is there setting in administrator if I want the old fashion way in using external setting?

Anyone out there using JasperReports with Coldfusion 8? cfdocument and cfReport have such a performance hit on our box when we try to run certain reports. IE - Report Cards We need something that would be able to run 100+ pages of dynamic data quickly and efficiently. If anyone has any suggestions of what we could look into or how to get Jasper up and running I would appreciate any help. Thanks. Becky

Hello,We have been installing CF 9.0 to IIS 7 on a new server for the first time. The installation was working fine until we tried to install add-ons such as the CF 9.01 installer or a Java JDK. After one of these was installed, the CF 9 application server would not start. We got a message saying "Windows could not start the ColdFusion 9 Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2."We reviewed the System Event logs and found error logs saying "The ColdFusion 9 Application Server service terminated with service-specific error They system cannot find the file specified." The error did not state what file that is.We tried uninstalling and re-installing CF 9.0 a handful of times and then applied either the 9.01 installer or JDK. We continued to get above error message when trying to start services.Has anybody experienced this issue before?

Hi,I have couple table with join query and they are from the diffrent database server.  How can I do this? look at the example below.<cfquery name="getall"> select *    from tbl1 inner join tbl2    on tbl1.saleID = tbl2.saleID</cfquery>tbl1 is from server1/Database1 and tbl2 is from server2/Database2Thanks

Hi,Is there a cold fusion function that checks the complete date (mm/dd/yyyy) against another compelete date (mm/dd/yyyy)?I have used the DateCompare but it only checks the month, day or year depending on the precision being used.Thanks,Mike

Hello, everyone.Quick question.  In CF9 Server Admin, if I use the Admin to create a collection, is there a way for someone else to see the details for that collection (ie, what folder(s), filetypes, etc.)?I have not yet found how to do this.  We have a collection, but it was created so long ago that no one remembers which directory(ies) or what file extensions it is indexing.  We may need to rebuild it.Thank you,^_^

I would like to know do I need enable IIS on Windows to install CF 10.IIS is diabled by default on Windows system.I see that C:\ColdFusion10\cfusion\wwwroot folder exists after install CF10.I just wonder can I just use cfusion\wwwroot folder without enable IIS on Windows.Your help and informtion is great appreciated,regards,Iccsi,

We are migrating some websites onto a cloud infrastructure running Windows 2008 virtual machines.  These websites all run on ColdFusion with MySQL databases.  They currently are running in our CoLo with no problems.  Additionally, they are running on our development network in our offices with no problems.We are setting up our cloud to match as closely as possible the configuration we currently use which is, essentially, CF10 + IIS on one server and MySQL on a separate machine.  We are 99% finished and most things are running great.  However....We have run into a couple, as in 2, places where we click a link/button and are greeted with:Error Executing Database Query. Communications link failure The last packet successfully received from the server was 0 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. Scanning the stack-trace I also find: `Caused by: java.net.SocketException: Connection reset`The communications link erro

HiWhen I log into my CF Admin (CF10) the little alert says I have 2 updates to apply, so I run the updater, get the confirmation messages that it's updating and when CF restarts and I log back into CF Admin the same alert says I have 2 updates to apply. I've not gotten any error messages and only confirmation messages that the updates were succssful, any ideas?Thanks in advance,Rich

I have coldfusion 10 running on IIS 7.5. The websites are protected by SiteMinder web agent. When a user makes a request, IIS sends the request to Siteminder which adds custom value (e.g., sm_user) to the header. I can see the values in IIS but when this request is redirected to the application via the coldfusion 10 isapi_redirect.dll file, the user is denied access and the user value is missing. Looks like isapi_redirect.dll is stripping off the user information due to which the user is getting access denied messages. I have checked the version of isapi_redirect.dll file which is 1.2.32.Any help is greatly appreciated.

Hello!  I am using Coldfusion 9 as well as the current version of MySQL.  My current query is throwing an error:<CFQUERY NAME="getmemgal" DATASOURCE="#ds#">SELECT usrid, usrmem, usrlogin, usrastro, memid, memlast, memfirst, memend, memlifeFROM usr, memWHERE usrmem LIKE memidAND usrastro LIKE 1AND ( memlife LIKE 1 OR CreateODBCDate(CreateDate(memend+1,1,15)) > CreateODBCDate(Now()) )ORDER BY memlast, memfirst</CFQUERY>Right now, the database stores the most recent year for which dues are paid as an integer, in "memend".  This query gives the members a 15-day grace period before their member photo gallery stops showing up on the site.  This means that a member who last paid for 2012 will have until January 15, 2013 to pay their dues.  Hence this part of the query:AND ( memlife LIKE 1 OR CreateODBCDate(CreateDate(memend+1,1,15)) > CreateODBCDate(Now()) )So you can see that their membership expires on January 15 of the year following the end of th