Do each of your sites have a "jakarta" virtual directory created in them? ... View more

Make sure the web connector properly installed the wildcard mappings.  In IIS Manager, click on the server (not any of the sites), and then open the Handler Mappings feature.  You should have some entries like this: Also make sure that the "tomcat" ISAPI filter is installed.  Again, click on the server (not any of the sites), and then open the ISAPI Filters feature.  It should look something like: The ISAPI filter is what handles the URL's with no explicit filename/extension. -Carl V. ... View more

Vincent, SQL Server stores it's databases as *.MDF files, and the associated transaction logs as *.ldf files.  You should NEVER move these files around after a SQL Server database is created, unless you absolutely have to, and even then only if you really know what you are doing.  Also, you shouldn't need to specify the file location of your SQL Server database in ColdFusion Administrator.  The server name or IP address and database name should be sufficient, along with username and password of a SQL Server user that has access to the database.  So if you haven't repointed SQL Server to the new database file location, put the files back where they originally were and make sure that you can access and query the database from within SQL Server Management Studio or whatever SQL tool you are using. I don't believe your problems stem from SQL Server not knowing where the databases are.  It is much more likely an issue with the ColdFusion connection to SQL Server. From your previous messages, I think maybe you are confusing the login/password to the CF Administrator itself with the login and password that are needed in your data source.  Can you confirm that you are only talking about the database username and password in your last two posts? Confirm all of the above, and then we can try to help you get your CF connection working. -Carl V. ... View more

If /MyComp is in a parallel directory to /www, then an Application.cfc must also be in /www for it to be called for *.cfm files that are in /www.  Is /www the root folder for this application? ... View more

Glad it's working for you now! ... View more

Emily, OK.  Yes it is possible.  Change your first query to: SELECT  DISTINCT TOWNSHIP_RANGE           FROM  slco_sire.dbo.area_reference_plats_doc INNER JOIN slco_sire.dbo.area_reference_plats_page           ON    slco_sire.dbo.area_reference_plats_doc.doc_id = slco_sire.dbo.area_reference_plats_page.doc_id           ORDER BY TOWNSHIP_RANGE </CFQUERY> Notice I removed any mention of SECTION, because it's irrelevant to generating a unique list of TOWNSHIP_RANGE.  Also, GROUP BY is not needed, but an ORDER BY will sort the records in alphanumeric order. Then you need to modify your code where you generate the option list for the first pulldown: <option value="#get_Main_Group.TOWNSHIP_RANGE#" <cfif StrucKeyExists(form,'select_Main_Group') AND form.select_Main_Group eq "#get_Main_Group.TOWNSHIP_RANGE#">selected</cfif>>#get_Main_Group.TOWNSHIP_RANGE#</option> Here I did a couple of things beside changing SECTION references to TOWNSHIP_RANGE .  It's a good idea to add the query name prefix to column names when you output them so that you avoid collisions with variables that have the same name.  I also reduced your <CFIF> statements to one compound statement for simplicity, and replaced the IsDefined with a StructKeyExists function.  This is considered to be better practice and won't throw an error when used in a compound statement (if you kept the IsDefined statement and tried that in a compound selection, it can sometimes throw errors if the variable in the IsDefined doesn't exist). Now, your second query should be something like: <cfquery name="get_Sub_Group" datasource="ds" dbtype="odbc">         SELECT DISTINCT SECTION         FROM  slco_sire.dbo.area_reference_plats_doc INNER JOIN slco_sire.dbo.area_reference_plats_page                     ON    slco_sire.dbo.area_reference_plats_doc.doc_id = slco_sire.dbo.area_reference_plats_page.doc_id         WHERE TOWNSHIP_RANGE = '#page.select_Main_Group#'         ORDER BY SECTION    </cfquery> Here I changed the WHERE clause to filter based on the TOWNSHIP_RANGE you selected in the first pull-down.  This should now return a list of SECTIONs that match the TOWNSHIP_RANGE selected in the first pull-down. Lastly, some minor changes to the option list for the second pulldown:   <option value="#get_Sub_Group.SECTION#">#get_Sub_Group.SECTION#</option> One other thing I noticed.  If you are on ColdFusion 8 or 9, the dbytpe="odbc" is no longer needed.  I'm assuming you are using an ODBC database connection to something like MS Access.  If so, you can omit the dbytype entirely.  It's only needed now if you do query-of-query queries, where it would be dbtype="query". HTH, -Carl V. ... View more

Emily, I've been trying to wrap my head around this, and I'm struggling a bit.  Should the first pull-down provide a unique list of Township/Ranges, or Sections?  Is the second pull-down just Sections that match the selection from the first list? ... View more

That Ben Nadel post is excellent! I had previously found another blog post that addressed my specific issue in the onError() method of Application.cfc that may also be useful to you: http://blog.pengoworks.com/index.cfm/2012/6/28/Forcing-your-ApplicationonError-event-to-run-to-completion-in-ColdFusion I implemented this in my Application.cfc and I have yet to see a timeout error falsely charged to the cfmail again. ... View more

When I've had timeout errors thrown on the cfmail tag, the timeout usually is happening somewhere else in the code prior to the actual cfmail tag.  I have a cfmail tag in my Application.cfc onError() method to send me alerts.  If an extremely long-running page times out, the error that gets logged links the timeout to the cfmail tag when it is really the code that proceeds the cfmail tag that has timed out. So in other words, check the rest of your code before accepting the error message at face value. ... View more

Sorry about that.  Yes, NEQ or IS NOT would be the appropriate operators.  Alternatively, you could also do <CFIF Len(MemberNumberLst.MemberNumberB)> which would be true if anything other than a NULL or blank value was in that column of the table. -Carl V. ... View more

@earwig75, Can you elaborate on: When I output from the same query you gave me it still shows both member numers from both tables. Maybe an example screenshot to show what you mean?  Maybe an example dump of the results from your CFC query? ... View more

alecken, Try using the "scale" paramenter in your <cfqueryparam> tags and the "decimal" cfsqltype: <cfqueryparam cfsqltype="decimal" scale="2" value="#Cash#"> Set scale to the number of decimal places you need to use. According to the Adobe docs (http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html), "decimal" corresponds to the Oracle "Number" data type. HTH, -Carl V. ... View more

GKiew, Jason (@12Robots) is spot on about onSessionStart() not being necessary if you don't need to use it.  In fact, all of the functions/methods in Application.cfc are optional - just use the ones you need.  Each provides a hook into the various events that occur during the lifecycle of a ColdFusion application.  You don't have to use them. -Carl V. ... View more

GKiew, No.  The correct way to establish those settings in Application.cfc is to put them in the pseudo constructor (using the "this" scope), before any of the functions.  Here is an example (with all of the functions omitted for simplicity): <cfcomponent...>      <cfset THIS.Name = "YourApplicationNameHere">      <cfset THIS.ApplicationTimeout = CreateTimeSpan(1, 0, 0, 0)>      <cfset THIS.SessionManagement = true>      <cfset THIS.SessionTimeout = CreateTimeSpan(0,1,0,0)>      <cfset THIS.SetClientCookies = true>      <cfset THIS.ClientManagement = false>      <cffunction ...>      </cffunction> </cfcomponent> See the following in the CF 9 Docs for more information: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-750b.html Ben Nadel's classic blog post gives you a pretty complete explanation of how all the parts to Application.cfc work: http://www.bennadel.com/blog/726-ColdFusion-Application-cfc-Tutorial-And-Application-cfc-Reference.htm HTH, -Carl V. ... View more

Adam, Tasktop (which I think is a paid service) is Mylyn on steroids.  It adds a whole lot of additional capabilities to Mylyn (I think the free Mylyn plugin itself is actually made by the same people who do Tasktop). -Carl V. ... View more

ggantzer2, Have you used the new Server Updates feature in CF10 to apply the Update 1 (10.0.1) that just came out?  I believe it included several fixes related to scheduled tasks.  You can install the update from inside the CF Administrator (expand the Server Update section in the left-side navigation panel, then select Updates).  If you havent' done it yet, try the update and see if it resolves your issues.  If not, reply back and I'm sure someone will jump in with some further suggestions. -Carl V. ... View more

I don't know who you talked to at Adobe support, but a CF10 license can be "downgraded" to CF 9.0.2.  If you spoke to an Adobe sales rep, they (sadly) may not be aware of that.  Contact Adobe support again to get a CF9 serial number. Here is a previous thread that contains the phone number you need (see last post in the thread): http://forums.adobe.com/message/4640556 -Carl V. ... View more

RLS, Are you running the latest version of CF Builder by any chance (2.0.1)?  If not, you might want to download and install it.  It actually uninstalls the previous version of CF Builder (2.0.0) and installs the new version (becuase 2.0.1 uses a newer major build of Eclipse).  This will allow you to start with a "clean slate" when it comes to which add-ons are installed, but it should maintain all of your project settings. Another idea, although this one could be pretty dangerous.  If you feel comfortable trying this, close CF Builder and: Make a copy of your \Program Files\Adobe\Adobe\ColdFusion Builder 2\features and \Program Files\Adobe\Adobe\ColdFusion Builder 2\plugins folders as a backup.  Make copies of \Program Files\Adobe\Adobe ColdFusion Builder 2\configuration\org.eclipse.equinox.simpleconfigurator\bundles.info and \Program Files (x86)\Adobe\Adobe ColdFusion Builder 2\configuration\org.eclipse.update\platform.xml as backups. Browse each of those folders from step 1 and find any folders and files with "Tasktop" in the name.  Delete just those files and folders. Open \Program Files\Adobe\Adobe ColdFusion Builder 2\configuration\org.eclipse.equinox.simpleconfigurator\bundles.info in a text editor and remove lines that have references to Tasktop. Open \Program Files (x86)\Adobe\Adobe ColdFusion Builder 2\configuration\org.eclipse.update\platform.xml in a text editor and remove lines that have references to Tasktop. Launch CF Builder. If CF Builder wont' run after that, revert the folders and files to the copies you made in steps 1 and 2 above. Good luck, -Carl V. ... View more

RLS, Here is the link to the uninstall section of the Tasktop User Guide: http://help.tasktop.com/help/index.jsp?topic=/com.tasktop.help.ui/userguide/install-e35.html It's another way of getting to the same dialog I mentioned before.  However, if selecting the Tasktop item doesn't enable the Uninstall button, I'm not sure what else you can do. Something else you can try from the same dialog.  Go to the "Installation History" tab.  Browse the history items to see when you installed Tasktop.  You can revert back to a previous configuration (prior to Tasktop installation).  If you added features after you installed Tasktop, you will have to reinstall those features. HTH, -Carl V. ... View more

You have to remove it from inside CF Builder.  Launch CF Builder, click on "Install New Software" on the Help menu.  Once the Install dialog comes up, look for a blue link on the right side, in the lower third of the dialog, that reads "What is already installed?".  Click the link, and another dialog opens.  Select the add-ons you want to uninstall, then click the Uninstall button. This applies to CF Builder 2.0.1.  If you have not updated CF Builder 2 to the latest, the dialogs may be different. HTH, -Carl V. Message was edited by: Carl Von Stetten ... View more

Make sure that you are properly scoping your variables in your CFC.  Use the 'var' keyword when you create variables used inside your CFC functions, even query names.  Define all of your variables used inside the CFC immediately after any CFARGUMENT tags and before any other logic.  Something like this pseudo-code: <cffunction name="myFunction" ...>      <cfargument name="myArg1" ...>      <cfargument name="myArg2" ...>      <!--- Declare variables --->      <cfset var myVar = "">      <cfset var myQuery = "">      <!--- Function logic ---> </cffunction> HTH, -Carl V. ... View more

I'll add that if you are not on a Windows system, if you are using the Registry option then ColdFusion is writing out the Client variables to a flat file on the hard disk.  As this file grows, performance can drop off precipitously because the flat file is not indexed in any way. If you are not storing more than a few "simple" datatypes in Client variables, then the cookie option is probably easiest.  Otherwise, using a database can provide excellent performance. ... View more

How about treating the resulting elements as a list as well (delimited by the forward slash): <cfset itemID = ""> <cfset itemValue = ""> <cfloop index = "ListElement" list = "#nenen#" delimiters = ","> <cfset itemID = listFirst(ListElement, "/")> <cfset itemValue = listLast(ListElement, "/") <!--- Do your comparison stuff here ---> </cfloop> HTH, Carl V. ... View more

The AJAX request will hit the ColdFusion page in much the same way as if you did a normal form submit, rather than via AJAX.  All of the form data will either be in the page's URL scope (if the form's method is GET) or the page's FORM scope (if the form's method is POST).  So all the fields should be accessible either as URL.fieldname or FORM.fieldname. As far as manipulating the data, that totally depends on what you want to accomplish with it. You'll have to provide a lot more information for assistance with that. With regard to returning data, what are you expecting to have the ColdFusion page return? -Carl V. Message was edited by: Carl Von Stetten ... View more

If you are not using the Verity search catalogs in your applications, then replacing your 9.0.1 install with 9.0.2 may be less of a headache than installing all of the hotfixes and updates.  The other Carl makes good suggestions on how to preserve your settings. Keep in mind that either way, one or two of the security hotfixes for 9.0.1 (and that are integrated into 9.0.2 already) may require some thinking about your application code - particularly the Form Post Parameter limit.  Read the docs carefully before proceeding. -Carl V. @cfvonner on Twitter ... View more

Harris_PW, Does the login appear inside the web page, or in a dialog pop-up?  If the latter, that is IIS asking for a domain login/password for authentication.  If you have set up the IIS web site to require authentication, you may encounter this. If, however, it is the login/password entry fields that are on the CF administrator page itself, then is it possible you mis-typed the password when installing ColdFusion? HTH, Carl ... View more

Akalan, Since you are talking about group policies and ActiveX controls, I assume you are working on a Windows machine.  Group policies for trusted sites only apply to primary domain names.  Thus, IE assumes that sites are only accessed via port 80 (standard HTTP port) or port 443 (standard HTTPS port).  Port 8500 is a non-standard port used by ColdFusion's built-in web server and would not be recognized by IE's security policies. As an alternative, you might install IIS web server on your local machine.  If you are on Windows Vista or Windows 7, IIS supports multiple hosts, so creating a host for each application you develop is feasible.  If you are on Windows XP, that version of IIS only supports one host (localhost).  An alternative to IIS would be Apache, which would allow you to run multiple local hosts even on Windows XP. HTH, Carl ... View more