ColdFusion

An exception occurred when instantiating a COM object.The cause of this exception was that: AutomationException: 0x80040154 - Class not registered.I get this error when trying to use an old 32bit  .dll.My company has moved from CFMX on Win 2003 to CF10 (64Bit) on Win2008 R2 (64bit). Is there something I can do to get this to work? The .dll has been registered in windows.

I am running ColdFusion 11, and the relevant website works well. However, whenever I apply available update 5, it breaks the website. The error message I receive is the following.Detailed Error Information:Module                     IsapiModuleNotification               ExecuteRequestHandlerHandler                    ISAPI-dllError Code               0x00000000Requested URL       https://website:443/jakarta/isapi_redirect.dllPhysical Path           D:\Programs\ColdFusion11\config\wsconfig\1\isapi_redirect.dllLogon Method          Anon

Hi All,I have a field value that can be stored with many values for a single record: Work_Order = '555555,666666,111111' (note, these are actually stored as a single string value in the db with commas .)I need to parse this field and enter the string values into the where clause of a new query:<CFSET WOIDS = CapProjects.Work_Order> <cfloop condition="#find(',,',WOIDS)#"> <cfset WOIDS = "#rereplace(WOIDS,',,',',null,','ALL')#"><br> </cfloop>  <cfquery name="CapProjectsWOIDS" datasource="#URL.DB#">  SELECT [ENGOPSMTRLSID]      ,[Work_Order]  FROM ENGOPSMTRLS  WHERE<CFOUTPUT>  ENGOPSMTRLSID = #URL.INDEX#</CFOUTPUT>AND<CFOUTPUT>  Work_Order in  (<cfloop index="idx" list="#variables.WOIDS#">        <cfqueryparam                     &nbsp

I'm just starting with Webtrends and have a task to show Webtrends data in a web page portal. What I envision is a HTML div with graphs. Of course, my site is ColdFusion based. Does anyone have suggestions or guidance on how to accomplish this? We're currently running Webtrends version 8.7, but are preparing to upgrade to version 10.

I have just had to rebuild my server and I am trying to get coldfusion reconfigured and I did not configure it the first time.  I have loaded coldfusion 10 on the c:/drive and all my data is on the d:/drive and I cannot get coldfusion to see the data.  What do I need to do?

Postgres doesn't have the USE directive, unlike SQL Server or MySQL. There is the \c <database> command, but that only works in the psql REPL. Is there an alternative to USE that can be used with cfquery in Postgres? We would be using this with CF 11.

I have already made the necessary changes to the RDSServlet settings in web.xml.  This happens on every browser and it doesn't matter if I'm local or remote.

Hello, all,I've got a query flattened into a JSON string.  The query does contain double-quotes in some of the data, so I try to strip that out.  I'm replacing " with "HOWEVER, the action page is using regex replacement to convert back to ", but it isn't completely working.I've tried the following with ReplaceNoCase() and REReplaceNoCase() - neither is working.<cfset form.XLJson = ReplaceNoCase(form.XLJson,'"','"','ALL') />The above code will take:Smith, John "Johnny"turn it into Smith, John "Johnny"BUT, what it changes back to isSmith, John ";Johnny";Am I missing something, here?V/r,^_^

Hello, all,I've got a few pages that I'm working on where, after the page loads, I use Javascript to dynamically create a form, then use CF to convert a query object to JSON, insert that into the form, and submit it (as opposed to running the same query twice), and the action page will DeserializeJSON()  to generate an Excel spreadsheet from the query.These pages are all working flawlessly.Now, I'm trying to do the same thing, except insead of using CF to convert a query into JSON, I'm creating a Javascript JSON of the data to pass to the form.  But when the page submits, DeserializeJSON() isn't working, even though I'm using the same format that CF uses.I'm getting the following error:JSON parsing failure: Expected ',' or ']' at character 60721:'M' in ... (JSON string)Well, at almost 100,000 characters, I'm having trouble finding that position (Word is useless for this), so can't view the issue directly.  However, I'm wondering if anyone knows a way to take a Javascript

The first time I installed CB3, it works fine. My workspace is under wwwroot. When I run the project, it runs in HTML.I have to reinstall CB3 per recommendation from Adobe after I had trouble create CFC using Extension.After I reinstalled the CB3, the page cannot be loaded in HTML. Instead it returns in Notepad with error message:The filename, directory name or volume label syntax is incorrect.Please help.Thank you.Shen

I had ColdFusion installed on my Mac Yosemite tonight and I'm running into a blank http://127.0.0.1:8500/CFIDE/administrator/index.cfm ‌page. I did a little bit of searching throughout the forum, but I couldn't find much relating to my problem.I followed the instructions from this video tutorial.   I thought I did everything correctly when the browser window popped up, but I guess not. I'm not sure where or how to proceed.. ColdFusion noob.I would greatly appreciate any advice/help/suggestions

Hello all,I'm trying to get my checkbox functionality to work depends on if check box is checked or not. If I click on the checkbox and is Checked I should send value="0" with my Ajax call. In other case if I unchecked my checkbox I should send value="1" with my Ajax. Here is the code that I have so far: <td><input type="checkbox" name="block" id="block" onChange="updateTable('#CustomerID#')"></td>function updateTable(CustomerID){     if(document.getElementById('block').checked == true){           var blocked = 0;           var whObj = {"url":"/apps/StudentAdmin/ParentTeacherConfScheduler/PTCAjaxFunction.cfc?method=UpdateSchedule&returnformat=json"};           gwAjaxPost(whObj,{"CustomerID":CustomerID,"blocked":block},Result);      }else if(document.getElementById('block').chec

I can't seem to get a J2EE session to persist across subdomains, even when setDomainCookies is true.This appears to be true in both CF10 and CF11.  Is there a way to make this work?It's very important for my project, and our security people want J2EE sessions.Thanks for any assistance,- Don

Here is the sample code. The first PDF file is created just fine, but the rest files are missing background image. Similar issue was reported here Very odd CFDOCUMENT Bug | Raymond Camden's Blog, but I could not find a solution to this issue. Would appreciate any input!<cfloop query = "MyQuery"> <cfdocument    format = "PDF" filename="./docs/#filename#"         overwrite="yes"        localurl="true"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head>    <style type="text/css">        body                {                background-image:url('image.jpg');      &

I've an SQL Statement Which works in MS Access 2010, but not in Coldfusion 7.  It's a way to achieve a display of most recent prices for my services, from a table of prices, which includethe date of each new price for each service; there are many services.  I have 2 tables.  the first table lists the services, one record for each service.  The 2nd table lists multiple instances of many of the services from the first table, each instance being a new price.  I do this to keep track of my price history.  The webpage throws an error, stating that: A CFML variable name cannot end with a "." character. SELECT SH1.rpr_srvc_hst_dt, rpr_srvcs.[rpr_srvc], SH1.[rpr_srvc_hst_amt_] FROM rpr_srvc_hst AS SH1 INNER JOIN rpr_srvcs ON SH1.[rpr_srvc_hst_srvc_] = rpr_srvcs.[rpr_srvcID] WHERE (((SH1.[rpr_srvc_hst_dt])=(SELECT MAX(rpr_srvc_hst_dt)     FROM rpr_srvc_hst AS SH2     WHERE SH2.[rpr_srvc_hst_srvc_] = SH1.[rpr_srvc_hst_srvc_]))

I need the url to download coldfusion 10.  I have my serial number and everything and cannot find a way  to download my software.

I'm using CF7 (it might even be CF6.5).  My hosting administrator is vague; it's rented space. Because of this dilemma, many solutions are not pertinent, because the version is antiquated.  I cannot help this.For now, though, my CF code is displaying all my pennies as whole dollars.  I have:#dollarformat(rpr_srvc_hst_amt_)#My CSS aligns the values to the right, but I'm not sure if it's affecting the $59.99 becoming $60.00 Also, I'd prefer to eliminate the dollar sign, and just have 59.99 and other similar values (i.e. 49.99, 19.99).  This may entail another function besides dollarFormat.  I tried NumberFormat, but it rounds off also. Please help.

I have my simple cfquery that should delete records base on the date, start time and end time that have been passed with the arguments. My cfquery looks like this:<cfquery name="qryDelete" datasource="test">   Delete From Table   Where DateS = <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.DateSch#">   and Start = <cfqueryparam cfsqltype="cf_sql_time" value="#arguments.Stime#">   and End = <cfqueryparam cfsqltype="cf_sql_time" value="#arguments.Etime#"></cfquery>I tried to output my argument values, they look like this:DateSch 12/10/2015Etime  08:25 AMStime  08:00 AMFor some reason after I tried to delete records I got an error that looks like this:"The data types time and datetime are incompatible in the equal to operator"I'm wondering why my date and times can not be compared with values in database. Should I convert or format my argument values differently before I pass them in my cfquery for de

Good day everyone please i'm a beginner in coldfusion. i really need your help i've read books about coldfusion but i dont understand them.  is there any book for a beginner like me

How do I update Coldfusion 10?

I'm testing an upgrade to CF11.  Everything is working except my flash form.  When I check the web.xml file, the CFFormGateway servlet mapping is commented out as well as the CFFormGateway filter-mapping.  The CFFormGateway servlet description indicates that this servlet "allows flash forms to connect to CFML and CFC templates".I found references to a possible work-around created by Josh Koop with the HouseofFusion but can't find details about that possible solution; especially since HoF is defunct.I've checked and verified the necessary .js, .cfm, and .swc files are in the CFIDE directory.  I've also verified there is a specified height and width indicated within the cfform tag. Will un-commenting the CFFormGateway servlet and filter resolve this issue with the cfform format="flash"?The pages render but a 404 error - file or directory not found - message is what is actually being displayed.Under the current version, the cfform successfully renders.

After installing CF 10 Hotfix 18, our PostgreSQL (9.2.14) datasources would not verify.   All gave error "timed out waiting for connection".  The log of hotfix install said it installed driver postgresql-9.3-1101.jdbc41.jar in the CF lib folder and modified script postgresql.cfm in the CFIDE/administrator/datasources folder. As a workaround, I saved the previous postgresql.cfm script, and saved the driver we were using successfully before the hotfix (postgresql-9.4-1202.jdbc4.jar).  After applying the hotfix, I replaced the postgresql.cfm script with the previous version.  I also got rid of the new postgresql-9.3-1101.jdbc41.jar driver and kept our previous driver postgresql-9.4-1202.jdbc4.jar in the lib folder.   Then I restarted Coldfusion, and after this all of our postgresql datasources did verify.  I have tested multiple CF scripts that use our postgres databases and all seems to be working fine. The last time we installed a hotfix (hotfix 1

Bonjourpourquoi CGI.PATH_INFO sous coldfusion 11 (server 2008 64bit) ne fonctionne plus ? qu'elle est la solution ? merci

I have multiple systems offline that need to be updated to CF11 update 7.I am unable to configure CF Administrator to locate the files to upgrade.Any help would be much appreciated.Thank you in advance.