Also, as Jason said, if you have a current support contract, you can contact Adobe and they can still send you the original 9.0.0 installer.  They pulled them from the website because the license agreement with Verity expired, and created the 9.0.2 installer (without Verity). -Carl V. ... View more

Without the 9.0.0 download, you can't install 9.0.1 (which was only an update).  So to start a new installation you'd need the 9.0.0 installer.  Otherwise, I'd agree that the OP probably needs Verity. -Carl V. ... View more

I would expect localhost and 127.0.0.1 to behave exactly the same, so that seems very odd.  What browser are you using?  I know there are some peculiar settings within Windows Internet Properties for Intranet site security that have caused me issues in the past.  I think Chrome relies on the same settings. ... View more

Is 127.0.0.1 in the list of allowed IP addresses (if you try to connect using http://localhost:8500)? Or the action IP address of the server if you are using the IP address or hostname of the server? ... View more

I was going to recommend that instead of what I posted, but didn't want to have to get into explaining escaping the hash/pound symbols that weren't part of the variable outputs.  Oh well... ... View more

Are you using IIS in front of ColdFusion?  I've had the same problem on my Win2008R2 server with CF10 Standard when going through IIS. -Carl V. ... View more

Maybe it would help to see more of your code, including the queries, and especially whatever surrounds the line you referenced in your original post. -Carl V. ... View more

@wycks, Not sure why the post_id is outputting twice, but that code can be cleaned up a bit.  Remove the inner </cfoutput> and <cfoutput> tags so it looks more like this: <a href="?post_id=<cfoutput>#rsGenPost.post_id#&user_id=#rsGenReplies.user_id#</cfoutput>##replytest" class="redlink"><strong>Post Reply</strong></a> I am assuming rsGenPost is a query?  If so, are there multiple rows returned in that query (that may have the same post_id value repeated)? -Carl V. ... View more

I don't believe that the OP was talking about properties of the order, but items included in the order (at least that was the impression I got from the previous entries on this thread). -Carl V. ... View more

The common pattern for storing orders and items is to put the order-specific details in one table ("orders" maybe), and put the items in a separate related table ("orderitems" maybe).  The primary key of the "orders" table (maybe "orderID") would then be stored in a column in the "orderitems" table, and would be used as a foreign key to link back to "orders".  That way you can have any number of items associated with an order.  You also don't store a bunch of null values in your orders table for item-related columns that are not used. -Carl V. ... View more

@cover, I see two things you might change, but I don't know if they will solve the problem.  First, you don't need the "dbtype" attribute anymore with CFQuery, unless it's dbtype="query".  Second, it's possible you have a race condition on your query results variable ("data").  You might add a line right below the CFArgument tag: <cfset var data = ""> This will make the "data" variable local to the function. Other than that, I can't see anything obvious.  I'm not at all versed in WDDX, so maybe someone else will have some better ideas. -Carl V. ... View more

Quick update: same issue with Update 5.  I started a new thread about this here: http://forums.adobe.com/message/4835676 -Carl V. ... View more

@cf_junkie, When you say "the db only has room for 20", do you mean the table you are saving to only has 20 columns to store products on an order, or something like that?  If so, you need to rethink your database structure. -Carl V. ... View more

ColdFusion 10 (the current version) is not yet compatible with Windows 8/Windows Server 2012.  Adobe plans to release a compatible ColdFusion 10 installer within the next few months. -Carl V. ... View more

Since the "sm_user" is a custom value, I wouldn't expect ColdFusion to expose it via CGI (although if it did previously in CF9 or earlier, I'd say then you have a valid bug).  However, it should still be accessible (just not in the CGI scope).  You might be able to see the "sm_user" value if you use getHTTPRequestData(): public string function getSM_User output='false'       {            var httpRequest = GetHttpRequestData();            if(structKeyExists(httpRequest, "headers")                 && structKeyExists(httpRequest.headers, "sm_user"))            {                 return httpRequest.headers.sm_user;            } return ''; } ... View more

I ran into some wierd issues with Updater 4 too.  I posted on the ColdFusion Server Administration forum with my issues. -Carl V. ... View more

@Richard350, I just replied to your SO post.  Bottom line, make sure you have the correct IIS components installed before running the Web Server Configuration Tool: CGI .Net Extensibility ASP.NET ISAPI Extensions ISAPI Filters For those who can get "per-site" connectors working but not "All" sites, what account are you logged in as when you run the Web Server Configuration Tool?  Does that account have administrative rights on the computer?  The "ALL" websites configuration writes changes into the IIS configuration (which requires Administrator privileges) and each site's web.config file (which doesn't necessarily require Administrator privileges), while the "per-site" connectors write changes ONLY to web.config. -Carl V. ... View more

@Reed, I guess I stand corrected.  This blog post from Brent Frye outlines the steps to make that work.  I think I had fought to get CF10 64-bit on Windows Server 2008R2 working with Access 2010 databases, and was never able to get it working.  I've seen a number of other people having that same experience, and when they respond to the question the OP was asking (either on this forum or CF-Talk), the responses are generally those that I listed above. I was going to test this on my dev machine, but I realized that when I installed ColdFusion 10, I intentionally didn't install the ODBC support.  I'm not sure if I can install it without having to do a full reinstall of ColdFusion (which I am loathe to do since I just got done upgrading it from CF9). -Carl V. ... View more

In fact, you should be able to eliminate the last query by combining it with the one Dan and I suggested: <cfquery name="updatePoints" datasource="#dsn#"> UPDATE leaderboard SET points1=points2, points2=NULL WHERE (points2 IS NOT NULL) AND tournID =1 </cfquery> This will be safe because when you do an UPDATE in most databases, it loads the record as it currently is into memory as a snapshot, makes the changes, then writes it back to the database.  So while the update is processing, the points2 hasn't been reset to NULL yet, and the value can be copied into points1. -Carl V. ... View more

Like Dan said before, I think you could replace this: <!--- query to get all points ---> <cfquery name="getPoints" datasource="#dsn#"> SELECT leaderID, points2 from leaderboard where (points2 IS not NULL) AND (tournID = 1) </cfquery> <!--- loop the points into the new column: points2 ---> <cfloop query="getPoints" startrow=1 >   <CFQUERY NAME="DoUpdate" DATASOURCE="#dsn#">        UPDATE leaderboard        SET points1=#getPoints.points2#        WHERE (leaderID=#getPoints.leaderID#) AND (tournID = 1)     </CFQUERY> </cfloop> With this: <cfquery name="updatePoints" datasource="#dsn#"> UPDATE leaderboard SET points1=points2 WHERE (points2 IS NOT NULL) AND tournID =1 </cfquery> Update queries run record by record, so you don't have to worry about it scrambling the values between rows (which you expressed as a concern in reply to Dan).  It's best to let the database handle this rather than by looping in ColdFusion - it will be much more efficient that way. -Carl V. ... View more

@Adam - You beat me to it! ... View more

Do you realize that you posted a comment related to CF10 on the CF9 docs? ... View more

@rickaclark54, In your revised code, are you still running a select query and then running update queries in a loop as before?  If so, you could do the update in one query and eliminate the loop entirely.  Maybe you can post your revised code. -Carl V. ... View more

You cannot use the 32-bit ODBC driver with 64-bit ColdFusion.  You have a number of options, though: Install 32-bit ColdFusion instead, then you can use the 32-bit ODBC driver. Install Microsoft Office and the Microsoft Access 64-bit drivers (downloadable from Microsoft). Import your Access database into another RDBMS system, such as Microsoft SQL Server Express, MySQL, PosgreSQL (all free), or the Derby database system that comes with ColdFusion 10. HTH, -Carl V. ... View more

@Aegis, Local accounts are unique to a specific server, and are not recognized by other servers.  That's why it's recommended to create the ColdFusion service account as Active Directory (AD) account - then it would be "universally" recognized across all servers in your domain. You cannot add a local account or account group to an AD group, but you can add AD accounts/groups to local groups. -Carl V. ... View more

@Aegis, If I understand the Lockdown guide, it's saying I should make an "IIS Service" account (local) and then use IT to be the LOGONAS for all the IIS service.  If this is TRUE, though, would it not be right to think that this IIS Service account would need the cumulative abilities that LocalSystem and LocalService have (cause those were the default accounts on these services) I don't think the lockdown guide says anywhere to change the LOGONAS for any of the IIS services.  You only assign the application pools to the IIS Service account.  Leave the actual IIS services (as viewed in the Services administration applet) alone. -Carl V. ... View more

The best practices wants me to create a local group (which I did, called COMPUTERNAME\Web Services) and to add the DOMAIN\WebAdmin, Local System and Local Service accounts to it.  Well, I added the DOMAIN\WebAdmin, but when I did a search for all local security principal accounts, it listed: NT AUTHORITY\Network NT AUTHORITY\Network Service NT AUTHORITY\Service NT AUTHORITY\Local Service NT AUTHORITY\System Notice that there's no 'NT AUTHORITY\Local System'.  My thought is that the 'Network Service' and 'Local Service' are legit, but where is 'Local System'?  There's only 'System'  So if the OS is using 'System' instead of 'Local System', then maybe 'Network' (for Network Service) and Service (for Local Service) are the actual accounts I need to add.  I have done extensive Google searching, and cannot find a site that tells me the difference between Network vs. Network Service and Service vs. Local Service. I think the CF9 Lockdown guide only suggests putting the ColdFusion and IIS Service account in the Web Services group.  I don't htink Local System and Local Service are necessary. As for your explanation of how you setup your website, that makes a lot of sense now.  Putting the CF service on that folder root with those rights ensures that all sites with home directories under it will have CF rights on their folders inherited from that level.  You pretty much did similar with the IIS service account.  The local Users account, in my case, being on a domain, I would add DOMAIN\Domain Users group to it so for Windows Authenticated Sites, I could use that 'Users' group to define what areas of access they have. I think my initial problem was that for 1 request, I was assuming that only 1 service ultimately was checked, and as we see here, CF and IIS can both have permission checks done per request. I think you're on the right track here.  Let me clarify something I stated earlier about CF and IIS accessing files.  When a user attempts to go to index.cfm (or any other .cfm page), the request first goes to IIS.  If the IIS credentials (whether it's the app pool for anonymous or the Users group for WIndows authentication) don't allow access to the file, you'll get an error (I think one of the 401 errors).  If IIS can access the file, it will pass the request to ColdFusion for processing.  At that point, the ColdFusion service needs to have permissions to access the file. If you really want to lock down your apps, only grant the IIS service account access to files/folders from the webroot on.  This is especially true if you use a framework or methodology that puts your model/service/controller files outside the webroot.  IIS should only be able to access files that should be directly accessible via the web browser (or via AJAX requests from within your application).  On the other hand, ColdFusion needs to have access to any file that will be processed by ColdFusion (whether accessed via mappings, or via CFINCLUDE/CFINVOKE/CFFILE or other tags/functions). Also, if you intend to serve files on a remote server via IIS Virtual Directories, the same IIS credential rules apply.  If you intent to access/process files on a remote server inside ColdFusion code, you'll need to make sure to grant access to the ColdFusion service account. -Carl V. ... View more