Questions

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

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?