ColdFusion

Using ColdFusion 9 and SQL Server 2008. Have cfgrid with dates. The date columns are not displayed but text boxes are bound to those columns and are displayed. The SQL Server data types are datetime which store in this format - mm/dd/yyyy hh:mm:ss. The cfgrid displays the date as 2011-01-20 14:52:32.167. In the cfgrid code I have tried "mask" and "number format" and neither alter the date display. Any suggestions?Could I possibly change the format in the text boxes. I use the data in the text boxes for emails and a more conventional date presentation would better suit the email.Thank you - JSsample code for cfgrid<cfgrid name="reqInfo" query="Req" width="510" visible="yes" format="html" rowheaders="yes" rowheaderwidth="50" selectcolor="orange" selectmode="row" maxrows="25" colheaderbold="yes" colheadertextcolor="Blue" selectOnLoad="no">  <cfgridcolumn name="ID" width="8" display="no" />  <cfgridcolumn name="PIN" display="no" />  <cfgridcolumn name="N

I'm getting the following error when trying to use cfcompile: "Webroot specified does not exist"This is the command I've used:  cfcompile –deploy D:\website D:\website\cfcompilein D:\website\cfcompileoutMy default website which I would think would be my webroot is defined in IIS as D:\website. I've defined the same path as "\" in CF mappings.ColdFusion is installed in C:\coldFusion2016I'm getting the same result on our CF9 installation.Any idea what I'm doing wrong? ThanksBob

Hi,I did a standard Installation on Windows 2008 R2. After creating a solr Collection everything is fine, but the configuration isn't saved in solr.xmlAny idea?And where I can get a actual description for cfindex and cfsearch?BestThomas

I am using the developer version of CF 11 for my test environment.  I tried adding a site in IIS yesterday morning and it wouldn't process CF pages.  So I used the web server connector and added the site.  However, it didn't work.  Every CF page just comes up blank.So I removed everything in the web server connector and re-added for ALL sites.   It looks like everything installed okay. I've checked that the config files are there (in C:\ColdFusion11\config\wsconfig\1\), and I checked that the handlers are correctly configured and they are.  The CFIDE and Jakarta virtual directories are there and pointed to the right place and the Jakarta has execute permissions.  The ISAPI filter is in place as well.  However, now everything including the CF admin comes up blank.Any ideas on where I might look to troubleshoot?

Hi,I'm evaluating ColdFusion Builder 2016 (3.1.0) as a plugin for Eclipse (4.3.2) and with ColdFusion 10. I think it has a lot of nice features that would improve my current development environment but the performance when using it for a large CF project is poor unfortunately and some functionality is not even possible to use. I'm now trying to find out if this is normal and if I can do anything about it. Performance for a small test project is ok, it is when I use it on a big CF project I run into issues. The project has a couple of hundreds cfm files and a couple of thousands cfc files. It also has several thousands other file types (.js, .sql, .html, etc.).Refactoring/renaming: Runs forever (>15 minutes) and sometimes terminates with an out of memory exception. I start Eclipse with 2048m as initial and maximum Java heap size. Using a local web server. Obviously it will be slower with a larger number of files but is this normal? Will it only process cfm and cfc files?Line debuggin

i am facing issues when upgrading coldfusion 6 to coldfusion 10 (Enterprise) using oracle 12c database. in CF10 Administrator data & sources tab selecting others drop down here providing  jdbc:macromedia.oracle:<servername>:port:SID;Driver class name  : macromedia:jdbc:MacromediaDriverhaving jar files are OJDBC7 & OJDBC 14 in my Web sphere CFFUSION/LIB folder .When calling one of the Stored Procedure in my application procedure using 3 reference cursors Getting error message like : Error executing database query : Jdbc  [macromedia ][oracle jbbc drivers][oracle][ora-20001].error encountered -2074-ORA-06512 : cannot set nls in Distributed transcations..There is other senarion which i can able to get the data from other stored procedure if the procedure using 1 or 2 reference cursors..using cfprocresult tag for results in stored proc..Please let me know how do I achieve result by using 3  reference cursors ..Thanks in advance..

I am trying to use Bootstrap with a CF site that makes heavy use of CFChart. Bootstrap has worked fine in the past with pages that don't use CFChart.Bootstrap requires 3 meta tags to appear first in the HTML header:<!DOCTYPE html><html lang="en">  <head>    <meta charset="utf-8">    <meta http-equiv="X-UA-Compatible" content="IE=edge">    <meta name="viewport" content="width=device-width, initial-scale=1">    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->    <title>Bootstrap 101 Template</title>With a CFChart tag in the page, tags are injected into the header above the Bootstrap tags, thus breaking some of the Bootstrap functionality:<!DOCTYPE html><html lang="en">  <head><script type="text/javascript">/* <![CDATA[ */_cf_loadingtexthtml="<img alt=' ' src

This is less a request for help and more a beware for the unexpected...I’m using CF11 and encountered a strange issue when trying to use UTC timestamps for comparison. It appears there is a hidden time zone indicator associated with CFs datetime object -- and I’m guessing it with the underlying Java datetime object. If all datetime comparisons happens during the request and no string conversion or database storage of the datetime objects happen, no issues. But if you convert a UTC converted datetime object to a string or store it in a database for a future comparison, you will receive some unexpected result as the comparison seems to take into account the hidden time zone and this field is not preserved when converted to a string or retrieved from a database. Example:<cfscript>            local.dttm1 = createDateTime(2017,02,01,01,00,00);            local.dttm1UTC = dateC

CF Version: 2016,0,03,300466 (Standard)DB Driver: com.microsoft.sqlserver.jdbc.SQLServerDriverI don't know if this is a bug or a feature, but when a query fails within a cftry/cfcatch block that is surrounded by a cftransaction tag, and that query is executed again in the cfcatch block (i.e. for timeout or deadlock purposes), all queries that ran before the cftry/cfcatch block are rolled back. For instance:<cftransaction><cfquery name="query_1" datasource="#my_ds#">     INSERT INTO Table1(Field1, Field2)     VALUES(          <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#val1#"/>,          <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#val2#"/>     )</cfquery><cfquery name="query_2" datasource="#my_ds#">     UPDATE Table2     SET Field1 = <cfqueryparam cfsq

Hello, all,I am just fiddling around, a bit, trying to learn something new:  setting up and using an MS Access db in CF10.  Simple, right?No.. not really.  But I didn't start this thread to give you the details and minutiae regarding getting it to work.  It works.The issue I'm having is that I wrote a simple query to fetch data from the FIRST table I created (Games) and am retrieving six columns of data.I'm running a query, using CFDUMP to display it.I went into the Access database and added three rows of info.  When I refresh the page, the CFDUMP shows only the first three rows.I deleted those three rows from the Access db, refreshed the page, and still see those three rows of data - nothing else.  Not the new rows I entered.  Nothing changes.Not sure what to do next.  Please help?V/r,^_^

Hi,I am in the process of translating a CF application to PHP.I have a question about queries, please tell me if I'm right:If I understand well, the major difference  between CF queries and PHP queries is that in CF, the whole set of records is fetched and an array is generated containing all data in one shot. On the other hand in PHP, only one row is returned and one has to fetch rows one by one so it takes very less memory at a time.Is this right ?My application uses only rather small queries and the use of memory has never been a problem in the CF version, so I intend to emulate the way CF works in PHP to simplify the work of translation.Any comment ?

I am currently converting/upgrading a CF9.0.2 application (Windows 2008R2/IIS 7, SQL Server 2008R2) environment to an internal company Share Hosting Environment that is CF11.  My CF9 environment is very basic; it began in 2000 in CF 4.5 and new development was done in the newest version that was available - so nothing has been rewritten to the latest version.Our SHE sets up the DATASOURCE for us - but we need to set the datasource, username and password into a passwords.cfm module in a restricted directory and therefore pass those parameters to each and every query.  I cannot put this information an application.cfm or application.cfc.I now have to bring my CF9 code to the SHE requirements, and one of the first I need to tackle is updating my CFGRIDS to HTML.  I know the arguments of CFGRID - I don't need to be lectured about them please.  All of the grids have sorts and 90% are selectmode=row (I have spent to much time trying to convert them to regular tables).&nbsp

Hello all,I'm hoping someone can help me with a problem I'm having.  I know some of the problems I'm having are due to poor application design, but this was all stuff done before I started working on the application and changing it is not likely any time soon.  That said... we are currently running ColdFusion 9 on a fairly large application.  We never upgraded to 10 because of a problem with being able to set the isolation level on datasource connections to the database.  Since CF 2016 released recently, I decided to play with this some again.  We are running an informix database and so have their jdbc drivers, and I have them added to the class path.  All of that works fine.I can add the datasource directly in the coldfusion administrator, and it works, accept for the isolation level.  The way the application was designed and written it requires the default isolation level to be set to dirty read (read uncommitted) on some of the datasources.  I

Pretty straight forward here, I have defined this.customTagPaths to include two directories. Within both of those directories I have a script, lets say test.cfm, with different contents. For discussion lets say one writes out "You found tag 1", the other writes "You found tag 2".I then call <cf_test>, and the result is the same no matter what I do to the order of directories listed in this.customTagPaths. My application has a this.name, and I've tried changing it at the same time I change this.customTagPaths. I've tried renaming the tag directories to see if possibly it was sorted by name. I cannot find a reliable way to predict which tag will execute.Using <cfmodule> is not an option at this point.Currently testing in Windows, CF11.

HI We are using to CF Builder 3.1.0 and its too much slow. We are trying to Update it But its throwing error.Need Help !!!

I've spent 2 days trying to set up a ColdFusion dsn in the cf admin.Is there some trick to this??Using CF11 / SQL SERVER 2014I have tried windows authentication and SQL authenticationI've opened pipes and portsI've tried regular SQL dsnI've tried other : JDBC driver connectionHere is the latest error messageConnection verification failed for data source: testdsnjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The connection to the host PAT-2016, named instance SQL2014 has failed. Error: "Receive timed out". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The connection to the host PAT-2016, named instance SQL2014 has failed. Error: "Receive timed out". Verify the server and instance names, check that no f

Hi,We have a cfgrid populated from a database with date columns.When the user sorts the date columns the columns are getting sorted in string format instead of date formateven though we are setting the mask="M/d/y" and type =date the column is still getting sorted in string format

Hi,Can some provide the URL to obtain the latest update for Cold Fusion 11 for 32 bit?Thanks,Mike

I need to be able to completely setup and configure Coldfusion 2016 on Windows. Is this possible?Using the silent.properties file I am able to silently install Coldfusion. What I need to do from this point is enable the built-in web server and then set the root for path for it. Is this possible to do via command line, scripts or batch files?I have searched the forums and the web and have been unable to come up with anything concrete.Thanks in advance for any assistance.

I am having an issue with CF 10 -22 that gives me an ERROR 500 page when I attempt to click the Schedule Task page of coldfusion. The error log produces the following' The specific sequence of files included or processed is: C:\ColdFusion10\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm, line: 188 "Any help would be greatly appreciated.

<CFSTOREDPROC PROCEDURE="create_reprice_decision"    DATASOURCE="#DSN#"  returnCode="Yes" >I'm running ColdFusion11, I have the above line, if i remove the returnCode="Yes", it is working. But it i leave it in, I'm getting the below error.Error Executing Database Query. - [macromedia][Oracle JDBC Driver]Unhandled sql type

I am creating a data source and I get this error when I verify the connectio.Connection verification failed for data source: brnjava.sql.SQLException: [Oracle JDBCDriver][Oracle]ORA-01882: timezone region not found The root cause was that: java.sql.SQLException:[Macromedia][Oracle JDBC Driver][Oracle]ORA-01882: timezone region not found Any assistance please? Thank you.

<!--- using cfgridcolum type="date" ---><cfset emps = querynew("firstname,department, salary,startdate")><cfset queryaddrow(emps,3)><cfset querysetcell(emps,"firstname","Debra",1)><cfset querysetcell(emps,"department","Accounting",1)><cfset querysetcell(emps,"salary","100000",1)><cfset querysetcell(emps,"startdate","2009/11/09",1)><cfset querysetcell(emps,"firstname","Doherty",2)><cfset querysetcell(emps,"department","Finance",2)><cfset querysetcell(emps,"salary","120000",2)><cfset querysetcell(emps,"startdate","2005/09/02",2)><cfset querysetcell(emps,"firstname","Ben",3)><cfset querysetcell(emps,"department","Law",3)><cfset querysetcell(emps,"salary","200000",3)><cfset querysetcell(emps,"startdate","2010/08/09",3)><cfform name="form01">    <cfgrid format="html"  insert="yes" insertButton="Add Row"        name="grid01"  &nbs

Hi,We upgraded to coldfusion11. Our application is overlayed with in cfusion.war. And we bundled two more web modules(module2.war, module3.war) in the same cfusion.ear.we share the session from cfusion.war to module2.war by using include method, this worked before the upgrade. After the upgrade the session is not carried over to the module2.war. RequestDispatcher rd = null;  rd = context.getContext("/module2").getRequestDispatcher("/WEB-INF/LoginServlet");  rd.include(req, resp);LoginServlet of module2.war saves the session setSessionAttribute(session, SessionConstants.USER_ID, req.getAttribute("user_id"));After user_id is set in login, when we request for other pages we check for (String)session.getAttribute(SessionConstants.USER_ID)!=null, if this check passes, it works.If someone can give clue of what changed in ColdFusion11 can help us troubleshooting this. Any help is appreciated.Thanks,Aruna.

A java class I'm trying to use needs to create a listening socket, but I receive an error when I try to use this class. The error is "Security: The requested template has been denied access to localhost:1024-". Further on down in the error it says "(java.net.SocketPermission localhost:1024- listen,resolve)". I have ColdFusion 8 Standard on Windows 2003 server. I have the security sandbox enabled. I have no IP:PORT restrictions. From what little I've found online so far this seems to be a problem only when the sandbox is enabled (which I must have so I can limit access to certain resources). Furthermore I believe it's being triggered because there's a java security policy somewhere that does not include a grant permission on listening sockets. {CF_ROOT}\runtime\jre\lib\security\java.policy does contain, by default, a line granding listen permissions on localhost to any port above 1024. {CF_ROOT}\runtime\lib\jrun.policy contains even more permissions as it pertains to sockets. I've