ColdFusion

Googled this for several hours, hope I'm missing the obvious as usual...I'm using CF9 and IIS7. Followed/tailored simple autosuggest code from Ben Forta. Came up with HTML:<cfinput type="text" name="Employer" size="50" autosuggest="cfc:employer.lookupEmployer({cfautosuggestvalue})">and a CFC named employer.cfc in the current template folder:<cfcomponent output="false">     <cffunction name="lookupEmployer" access="remote" returntype="array">          <cfargument name="search" type="any" required="false" default="">          <cfset var data="">          <cfset var result=ArrayNew(1)>          <cfquery name="data" datasource="Binkley">               Select lname   &n

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

Good day,Im trying to install coldfusion 10,(also tryied 9) on kubunu 12.10.I have installed many times on 12.04 and before.When installing when i try to add apache web config and i get to this question.Which directory contains your Apache configuration file (httpd.conf)? (For    example, on Red Hat Linux it could be located in the /etc/httpd/conf    directory if you installed from an rpm, or for SuSe Linux, it could be in    /etc/apache2)      Directory: /etc/apache2      Invalid path to configuration directory (the path does not exist or does not   contain the configuration file).   Which directory contains your Apache configuration file (httpd.conf)? (For    example, on Red Hat Linux it could be located in the /etc/httpd/conf    directory if you installed from an rpm, or for SuSe Linux, it could be in    /etc/apache2)However the problem is that  /etc/apache2 i

I converted some XML into a query (just two columns - a date and description).  If I cfdump my query, I get the following:DescriptiontheDateabc{ts '2012-11-05 00:00:00'}cde{ts '2012-11-06 00:00:00'}efg{ts '2012-12-04 00:00:00'}ghi{ts '2012-12-01 00:00:00'}What I want to do now is just a simple query to get the records with a date >= today's date.<cfquery name="datetest" dbType="query">SELECT * FROM myqueryWHERE theDate >= now()</cfquery>This of course does not work.  When I created the original query represented by the table above, I did:<cfset myquery = QueryNew("theDate, description", "date, varchar")>I'm hoping this is just a simple syntax issue, but I really need to be able to do date comparison in my query of a query.  Any help?

I'm writing a cftry/cfcatch to handle a RequestTimedOutException error that has happened a few times and we cannot replicate on demand.   I want to write a catch that will notify me when it does happen -- is there any way to test my code by forcing a timeout error?

Hello,We have just recently upgraded our site ColdFusion 9. We are also on IIS 6. Before we performed the upgrade, we switched IP addresses between the production server and a clone server. Traffic would temporarily go to the clone server while we performed the upgrade on the production server. Once the upgrade was done. We wanted to revert the IP addresses back so traffic can start going to the production server. Strangely visitors were not able to reach the site on the production server. Our system administrator had thoroughly and repeatedly verified that the IP address and DNS settings are correct as well as the settings on IIS management. His conclusion is that the upgrade of ColdFusion has something to do with this issue.Has anybody ever come across such an issue? If so, how did you get around it? Thanks.Best regards,Chung Lee

I bought CF Builder back on 8/31. Installed it and I'm fairly certain I entered the serial number for it. But now it just told me that my trial period has expired and it is in limited-use mode. When I select the registration option from the Help menu, nothing happens. What's going on here?

I just installed CF 9.0.2 on Windows 7 Ultimate x64, and I am getting a 404.3 error when I try to access the CF Administrator. I did turn on ISAPI Extensions and IIS Metabase/IIS 6 configuration compatibility. Here's the error I'm getting when I try to access the admin:HTTP Error 404.3 - Not FoundThe page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.Detailed Error InformationModuleStaticFileModuleNotificationExecuteRequestHandlerHandlerStaticFileError Code0x80070032Requested URLhttp://127.0.0.1:80/CFIDE/administrator/index.cfmPhysical PathC:\inetpub\wwwroot\CFIDE\administrator\index.cfmLogon MethodAnonymousLogon UserAnonymous

Anyone know the Regex to find if a variable contains a word eg this var has "Surplus Percentage Total in the Amount of $2000.00"So I need to know it contains the word 'Percentage'?Here is my codecfset xyz='Surplus Percentage Total in the Amount of $2000.00'cfset foundword= REFind('Percentage', xyz)The above is not working

Yep, I'm maintaining a Flash type cfform that was authored a few years ago. The application is on CF9 now.How can my application sense when a user has keypressed within a CFGRID cell?I've introduced a change event listener to the cfgrid via the onchange tag attribute. The event fires when the mouse clicks within any cell.But keyboard navigation or individual cell keystrokes to not trigger a change, even when traversing to another cell via Tab or Enter.I've also tried using the keyDown event, but that is only triggered when navigating the overall grid. It does not fire when a cell has focus - the user is typing within it.keyUp doesn't work either, nor does keypress, keydown, keyup or any of my other exhaustive deriviation attempts. I've tried to locate a complete list of AS 2.0 event names, but have had no luck, even within Adobe's own pdf docs. If anyone has an example from their own personal museam, I'd love to see it.Did I mention that this is a Flash cfform? Thought so...

I have been looking all over the coldfusion forums (here and on the net) and it seems this is an ongoing problem with the <cfselect> not being able to validate even though the option is there. Plus it also shows that it available on the adobe cf9 docs that i use for reference, but doesn't wok unless you change a file on the server (according to a solution is found on the net), and we all know not everyone is going to be allowed to rewrite a file on "their" server to make it work. Anyone know or even have an idea why this has been a problem for this long and hasn't been fixed? Some of the forum posts have seen date back a couple of years.

I've upgraded from CF9 to CF10 on a Windows IIS6 box.CF seems to run, however:1. the default document is not working (an url without "/index.cfm" is not working, adding "/index.cfm" solves the problem).2. all url's seems to have become case sensitive, which breaks almost every single app I've build.I already have re-applied the IIS connector and I've installed all the latest patches.What now?

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

As usual, every time I go to install a new Version of CF it never installs.  This time, I have installed it, got .ASP net error out of the way.  And IIS7 seems to look exactly the same as on another development box. (Except that's running 9)So I have the directory mapped properly, and can see it in CF.  But I get ... HTTP Error 404.3 - Not FoundThe page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.What I do notice is that in neither box do I see .cfm listed as a MIME type.When installing CF I did tell it to install as non IIS as IIS was not correctly installed and cannot tell now if it using built in web server, or IIS7. Went to uninstall and reinstall as IIS but it would only let me reinstall as JRUN as it detected CF already installed and I cannot figure out how to uninstall if I wanted to. Probably a quick fix? Thanks.

Running CF9 64-bit on Win Server 2008 R2, and all my Oracle connections have SIDs.  Just got a new Oracle DB that I need to connect to, but doesn't have a SID, it has a Service Name.  Was unabl to connect using the default ORACLE connector in CF9. Have read thru messages, but am still not clear on how to add an Oracle server with a Service Name and not a SID.  Would appreciate any help/advice on the correct syntax for using OTHER, if this is the best (or only) way to add this type of Oracle DB connection.I've successfully added OTHER connections for Teradata and IBM-DB2, but I knew that was the direction to go, and was able to obtain the info, syntax, etc. for creating these OTHER (JDBC) connections.  Thank you.Gary

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