TheUrbanBrain wrote: Is it possible to use UNION or some other JOIN to bring these together?  I'm trying to bring in data from a second table but the count comes from a table that only tracks the id.  The WHERE Table1.pid = Table2.pid is the ANSI syntax for doing an inner join.  You could replace the FROM and WHERE clause with: FROM Table1 INNER JOIN Table2 ON Table1.pid = Table2.pid and get the same result. -Carl V. ... View more

@TheUrbanBrain, BKBK's version is close.  The problem is that any columns in your SELECT statement that aren't part of aggregate functions (like your COUNT function) must be named in the GROUP BY clause.  So a small to tweak to BKBK's code: SELECT Table2.name, Table1.pid, COUNT(Table2.pid) AS pcount FROM Table1, Table2 WHERE Table1.pid = Table2.pid GROUP BY Table2.name, Table1.pid ORDER BY pcount DESC should fix your issue. -Carl V. ... View more

ColdFusion and IIS "see" things differently.  ColdFusion doesn't care about IIS settings or permissions granted to the application pool identity.  It will use the ColdFusion service identity only.  So whatever files/folders you have granted the ColdFusion service account access to, that's all it can see/interact with (think how this applies to CFINCLUDE, CFINVOKE, CFFILE, etc.). IIS, on the other hand, is more complex.  If you enable Anonymous authentication on a web site, any requested files will only be accessible if permissions to those files/folders have been granted to the appropriate application pool identity.  If you are using Windows authentication, any requested files will only be accessible if permissions have been granted to the Windows user that is browsing that site. On my web server, I put all of my web applications inside of a E:\WebSites folder.  I have granted the following permissions on that folder: ColdFusion Service Account: Modify, Read & execute, List, Read, Write.  I might be able to restrict that to just read if ColdFusion isn't creating/modifying files in my apps (I'll have to check that further). IIS Service Account (this is the Application Pool root user): Read & execute, List, Read. Users (this Local group account usually includes the AD Domain Users group account): Read & execute, List, Read. If your web application, or portions of it, should only be accessible to a select group of users, then don't use Anonymous authentication, and don't give the local Users group access to the restricted areas.  Create an AD Group that contains that select group of users, and grant that AD Group the Read & execute, List, and Read permissions to those restricted areas. -Carl V. ... View more

I have a couple of ideas, but before I make suggestions, can you show the structure of both Table1 and Table2 (what columns are in each table). Also, to clarify what you need - you are looking to pull back the count of occurrences of each "pid" in Table1, and join that to the name for each "pid" (and the name can be found in Table2)? -Carl V. ... View more

@Aegis, As far as the ColdFusion Services and IIS Services, I can provide limited insight: COLDFUSION SERVICES ColdFusion 10 .Net Service - have never used this, so I'm not sure what account is appropriate here ColdFusion 10 Application Server - run this as your "cfusion" local or AD account ColdFusion 10 Jetty Service - run this as your "cfusion" local or AD account ColdFusion 10 ODBC Agent/Server - not sure you need to alter these from whatever the default is.  I don't use ODBC anymore, so hopefully someone else can offer an opinion IIS SERVICES I'm running all these under the default accounts without issue. As to what the Network Service/Local Service/Local System accounts do, I would suggest some Google search time on this.  I haven't spent much time myself worrying about them, to be honest. HTH, -Carl V. ... View more

@Aegis, Hopefully this clarifies the Domain Account/Local Account question: If ColdFusion needs access (or may every need access) to any files that exist on a separate server from your web server, then you need an Active Directory (AD) account for it to run as so that it can be granted access to those files on whatever server they reside on.  If ColdFusion will never need to access files that exist on a different server on your network, then you don't need an AD account for it to run as (a regular Windows account created on the local server will do). The CF9 Lockdown guide shows how to create accounts and assign permissions to folders (see pages 2-5).  The only change I might suggest is that instead of creating the "cfusion" account (the account you will set the ColdFusion service to run as) as a local account on the server, create it in Active Directory as a domain account.  That way if you ever need ColdFusion to access files on other servers, you will be able to assign permissions to those files/folders to that AD account. HTH, -Carl V. ... View more

Hollar at me if you need help with the user rights stuff.  I've been doing Active Directory stuff for longer than I care to remember. -Carl V. ... View more

That's pretty common with Tomcat/IIS integration.  The last time I checked, OpenBD and Railo were doing the same thing for IIS integration (although that may have changed in the newer installers that VivioTech produces). -Carl V. ... View more

Also, I believe a ColdFusion 10 Lockdown Guide is in the works.  Not sure when it will be released, but it is coming. -Carl V. ... View more

@Bandeira1820, That is correct.  Inside <CFOUTPUT> tags (and other tags that process and render ColdFusion variables), the pound sign has special meaning.  It is a token that marks the start and end of a ColdFusion variable.  So inside <CFOUTPUT>, ColdFusion will stop at the tokens, extract the name of the variable that is between the tokens, look up the value of that variable, and then insert the value in place of the tokenized variable name.  When it is finished, all you see is the HTML content returned to your browser. Outside of <CFOUTPUT>, the pound sign reverts to whatever meaning it has within the HTML language.  If you are inside of <CFOUTPUT> and wish to actually pass a literal pound sign (as you do in this particular case), you have to escape it by adding a second pound sign right next to it.  Thus, when ColdFusion processes this bit of code, it sees the two pound signs together and knows that there is not a variable name to be found here, so it replaces the double pound sign with a single pound sign and moves on. -Carl V. ... View more

If the HREF tag is somewhere inside a <CFOUTPUT> tag, then you need to escape the pound sign by adding a second pound sign next to it (i.e. href="##" instead of href="#"). -Carl V. ... View more

I've never been able to get that to work.  I have only been able to use SQL Authentication (an actual account created on the SQL Server instance rather than a Windows account).  However, I think it might be possible if you install Microsoft's SQL Server JDBC driver and tweak the connection string (I have a vague recollection of seeing someone talk about this either in a blog post or on CF-Talk (http://www.houseoffusion.com). -Carl V. ... View more

Is it possible you installed ColdFusion Builder 2.0.1 (the version compatible with ColdFusion 10)?  If you did, the updater does not apply, as it was for ColdFusion Builder 2.0.0.  Otherwise, it sounds like the installer was corrupted during download.  Maybe try to download it again? -Carl V. ... View more

I agree with Jason on this.  But, just out of curiosity, how many columns are being returned in your query?  Forty seconds is not out of the question, especially if there are many columns. -Carl V. ... View more

Possibly, although as a an enterprise application, it makes sense for Adobe to focus their testing and certification of OS compatibility on enterprise OS's.  Windows 7 Home is not an enterprise OS.  My guess is a very small minority of ColdFusion developers are using Windows 7 Home as their OS for development. -Carl V. ... View more

There is no reason it shouldn't work.  According to Microsoft Technet, IIS can be installed on Home Premium (it's not installed by default) by using the Add Features tool in the Programs Control Panel applet, or by downloading and installing Web PI. There shouldn't be anything inherently different between Windows 7 Home and Pro that would prevent ColdFusion from installing, since it is a Java Servlet running on top of Tomcat (which definitely will run on Windows 7 Home).  The real issue would be the Tomcat/IIS integration, and there shouldn't be any issues there because Windows Home and Pro use the same version of IIS. -Carl V. ... View more

While I don't have any insight on this (I don't work with web services much), the additional information should make it easier for others to assist you. -Carl V. ... View more

@Aegis,  I totally get it.  I agree with the aesthetics issue.  I tend to write code using the camel casing for consistency, but I usually don't pay too much attention to the way CF mangles it in <cfdump> output.  Except when I do... ... View more

Just so you know, casing on variable names is generally unimportant unless you work with AJAX requests.  ColdFusion is case-insensitive, while JavaScript is case-sensitive. -Carl V. ... View more

You can do <cfset APPLICATION['coms'] = {}> and the casing will be maintained. -Carl V. ... View more

What is the Web Service expecting as a parameter?  More information is needed. -Carl V. ... View more

OK.  Just wanted to eliminate that.  Hopefully someone else will chime in. -Carl V. ... View more

May seem like a stupid question, but: are you absolutely sure the file you are uploading is actually an Excel file and not a Word file that got renamed to .XLS?  The reason I ask is that with CF10, CF no longer just looks at file extensions to determine MIME type - it sniffs the file headers to determine type. -Carl V. ... View more

This needs to be updated, as the Solr architecture changed in ColdFusion 10, at least for Windows. There is no longer a "ColdFusion # Solr Service" (and especially not a "ColdFusion 9 Solr Service"). The file to modify is jetty.lax not solr.lax, and the default memory option is now -Xmx512m instead of -Xmx256m. ... View more

I think you are posting to the wrong forum.  I'd post this in the Premier forum: http://forums.adobe.com/community/premiere/premierepro_current -Carl V. ... View more

The wildcard handler handles urls without filenames (http://www.kyndoutdoors.com/), and that appears to be working.  However, the specific IIS handler mappings for "*.cfm" does not appear to be.  You might try using the ColdFusion Web Server Configuration Tool (WSConfig) to remove the IIS connectors (then restart IIS), and then re-add the connectors. Another thought: were your IIS sites added to IIS after ColdFusion was installed and configured for IIS?  If so, the connectors appear to not be propogating forward for new sites.  I've seen this behavior before with ColdFusion 9 and IIS 7.5, but CF10 seems to handle this better.  Again, removing and re-adding the connectors seems to resolve these situations for me. EDIT: Hmmm. 404 errror actually makes me think this may be a file permissions issue.  What account is the ColdFusion service running as?  Make sure that account has permissions to the folder containing your website(s). -Carl V. Message was edited by: Carl Von Stetten ... View more

You say "THIS.rawCode" at the top of your post, but refer to "THIS.rawOutput" in the method call. -Carl V. ... View more