ColdFusion

I have a query that is looped through on the page into two columns via array.  Is there a way in an CFLOOP to have static text without it repeating for the number or records in the query?  (in this case in a third colunm)

My company want some management charts making (dashboards) and I don't understand the difference between using Flex or ColdFusion for the task.My natural instinct is to make a ColdFusion page and use CF's charting capabilities. I understand that Flex is more about presentation layer so does that mean Flex's charting features are much better than ColdFusion's? Also why use Flex at all for presentation when there is already Flash available?I'm sorry I don't understand the difference in these products.

I'm using CF8 and Oracle 11gI've been calling Oracle procedure many manyy times from CF <cfstoreproc with no problem.I even get the result back from calling an Oracle Package. But since yesterday I can't get the result back from calling this str. procedure. I even get an error that says:Error Executing Database Query.  [Macromedia][Oracle JDBC Driver]Unhandled sql type    The error occurred in /space/users/www/mywebdir/test/cbiorpt.cfm: line 2220 :      <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="#Trim(Form.Year)#"> 21 : 22 :      <cfprocresult name="q_bio">23 :  24 :    </cfstoredproc>This is how I call the procedure and try to capture the result back:--------------------------------------------------------------------------   <cfstoredproc procedure="SP_STRpt" datasource="#Application.DSN#" returncode="yes">     <cfprocparam typ

Please provide detailed steps to configure ColdFusion 10 and IIS 7.5, each residing on different machines.Does IIS services need to be enabled on the CF box as well, even though we want to have the IIS 7.5 websites on a different machine?

I'm new to this, but I wanted to use the CF adminAPI, so I wrote:<cfset adminObj = new 'cfide.adminapi.administrator'()><cfset result = adminObj.login(adminUserID = 'admin',adminPassword = 'HASHED_ADMIN_PASSWORD',isHashed = true)><cfdump var="#result#" abort="1">And it reports back: falseI don't want to supply the unhashed value in the code itself, and I used the BIF hash() to hash the actual password (which is supplied in the above as 'HASHED_ADMIN_PASSWORD')  Can anyone help point out to me what I'm doing wrong?

My first attempt at this is not going well.Here's what I have:<cfscript>function calbox(topic) {    queryService = new query();     queryService.setDatasource("hepoffice");     queryService.setName("getevents");     queryService.addParam(name="topic",value="arguments.topic",cfsqltype="cf_sql_numeric");     result = queryService.execute(sql="SELECT event_title" &                                            ", event_desc" &                                            ", event_star

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSe9cbe5cf462523a0-187f93d8122075814b3-7fff.html

I upgraded from CFMX7 Standard to CF9 Enterprise this week. Since the upgrade, I am unable to create a new datasource using either the ODBC Socket driver or the Microsoft Access driver. When I attempt to add an ODBC Socket ds, I get this message:The ColdFusion ODBC Server service is not running or has not been installed.Both the ODBC Server service, and the ODBC Agent service are installed and running. I tried uninstalling and reinstalling the services (using the instructions in the comment of this tech note) but the problem was not solved.  I also had to fix port numbers as described in this post. (After my original install, none of my imported datasources worked until I changed those ports from 19999/20000 to 19997/19998)Has anyone run into this issue? I've googled it for days and I have an open case with Adobe, but so far we have not been able to solve it. I appreciate any suggestions. Other install details: Windows Server 2003 Web Edition SP2, using IIS v6.0. Also using Sequel

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-75a8.html

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

IIS7.5 in the release site, how to publish content on other computer.

I am new with CF. I am using CF 10 on WIN XP. I am pulling a distinct list of data and want the user to select one to open a new page (detail.cfm) and pass that value to the next page to be used for other queries.can it be done?Here is my code for cfselect .What am I missing<cfform name = "Form" action="detail.cfm"                    <cfselect name="trip"                    query="gettri"                 value="district_name"                 required="yes"                 multiple="yes"             

Is it possible to check the value of an input field (regular input, not cfinput) against a database to check for duplicate values?

I have a form that have two field inputs. I would like to repeat the form fields as part of a cfoutput query. The first field of the form automatically populates the different person's name (via cfoutput query) and this form field is called "tenant". The next field of the form is called "sales". The sales field is left open for user imput. The entire form is in between the cfoutput query tags. When the cfoutput query is executed, Both form fields of the form is displayed with each tenant name listed in each of the first form fields of each row. The problem I'm running into is that even though the form elements appear to display correctly, I would like the name of each of my form elements in the cfoutput query, of each row to have a different form field name like, tenant2, sales2, tenant3, sales3 etc. is that possible? Here's what my code look like.<cfform action= "addsales.cfm" method="post"><cfoutput query="tenantsales"><Input name="tenant" type="text" value="#office.te

I have an app that runs under CF9 to automatically check a couple of remote SFTP sites for available files, and transfer them to my server when they show up.  I just added a new client's SFTP info to the setup, and am seeing an odd problem.  They had both small (5-10 KB) and large (20MB+) files.  The small ones transferred just fine.  Every one of the large ones failes with a CFFTP error of -1.First thing I thought of was timeouts.  So I set the CFFTP timeout to 300, and the page request timeout to 9999 (which shouldn't matter anyway because I have the cfadmin box for timing out long-running pages unchecked).  Did not make a difference.  In fact, the CFFTP throws the -1 error after about a minute or less - which is far below the 5 minutes (300 seconds) that I set the CFFTP timeout param to be.I tried downloading one of the large files with FileZilla, and it copied just fine.Anyone have any ideas, either for the solution or something else to try to deb

All of a sudden I am getting this error when I try to verify my Microsoft Access with Unicode files. My other connections still work.Connection verification failed for data source: bct_dbcom.inzoom.jdbcado.JdbcAdoException: could not load izmjniado.dll Can't load library: c:\program files\infozoom\izmjniado.dllThe root cause was that: com.inzoom.jdbcado.JdbcAdoException: could not load izmjniado.dll Can't load library: c:\program files\infozoom\izmjniado.dllHow do I fix this?

I did a WEBMAIL using CFPOP.I want now to use CFIMAP,but when checking date (sentdate), I have a problem :I use function isDate(sentdate), it is OK, passI then I use ParseDateTime with POP attribute<cfif isDate(sentdate)>     <cfset l_date=ParseDateTime(sentdate,"pop")> I get an error : {ts '2011-12-09 14:03:53'} is not a valid date formatHow to get a valid date with this ?It did work with CFPOP and variable "date"Thanks for any suggestion about this change of date formatbetween CFPOP and CFIMAP.What do I need to use to get a valid date with CFIMAP and "sentdate" ?Pierre.

I have installed CF 8.0.1 in my machine and I want to upgrade it to CF 9 because it is the version required by our software. Any ideas is greatly appreciated.Thanks in advance!

I am using Homesite for many years,I would like to switch to CFbuilder,but it does not seem so easy ,My main problem, is that I used to work from my local sites directoriesand not from a working space or projects.So I would like to retrieve in CFbuilder a simple acces to my local websitesin my wwwroot server, and call files from this space.Should I have to declare a project for each website, which is a simple directory in the wwwroot ?And so, how.Thanks for help.Pierre.

It gives errorInvocation of this Java application has caused an invocation targetexception.Alsowhen I click detailZeroGu6: Windows DLL failed to load          at ZeroGa2.b(DashoA10*..)          at ZeroGa2.b(DashoA10*..)          at com.zerog.ia.installer.LifeCycleManager.b(DashoA10*..)          at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)          at com.zerog.ia.installer.Main.main(DashoA10*..)          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delega

In the yellow bar Dreamweaver informs me that: "Dynamically related files could not be resolved because your credentials don't allow file activity on the server." I'm quite new to al lthis so I'm not sure what the problem is or where it is. SO I try describe the problem with screenshots.I have set permissions to be allowed to connect from my IP adress in hostgator.The first two images are of me trying to add a recordset. I get the error that Dreamweaver can't connect to _mmServerScripts. Yet mmScripts i located on the root of the site at home/the ace as in other screenshots.The image on the left shows the error I get when I run the test. All the fields in it are filled out the same way as on the screen on the right except I add the "Root Directory" home/theace.Without adding the root directory(same as on the right screeenshot) I get succesfull connection to the SERVERDatabase screen                 &nb

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

HelloI'm trying to set up a connection to a dbf file. Don't ask me what kind of dbf. Most probably NOT FoxPro but may be "open" dbf. First I tried to set up a data source connection in the Coldfusion administration interface. I was choosing "DB2" as database type but I did not understand how to fill in the fields. Then I tried without setting up a data source connection and I found on the web something like:<CFQUERY NAME="myquery" DBTYPE="dynamic" CONNECTSTRING="Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\Inetpub\wwwroot\dbf\sample.dbf;">SELECT * FROM ???????</CFQUERY>Puhhhhhh, I do not understand this stuff. Can somebody help me out?Thank you

Hello, I purchased and installed Coldfusion 10 enterprise on a webserver that previously had CF 9..cfm compression was working fine on CF 9 but after I uninstalled CF 9 and installed CF 10 the compressionstopped working.The metabase.xml configuration is intact and the server runs windows server 2003 64 bit - IIS 6 - Coldfusion Enterprise 10 64 bits.What am I missing? 

I have  Windows 7 64bit, Coldfusion 10 64bit, I have tried add csv driver and MS Access at 32bit ODBC driver, but still cannot work.Please help what should I do?thanks!