Steve, Yes I have done that but CF seems to ignore it. Thanks for your help anyway!
Nick -----Original Message----- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 14:41 To: CF-Talk Subject: RE: NTFS File Settings - advice required Oh ok, I see what you mean, Did you check to make sure that the Anonymous user name in IIS's security settings matches that of the user your trying to allow access to in the security settings of your folder? It should be something like IUSR_ComputerName, you should allow that user everything but modify or full control I believe. ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com -----Original Message----- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 9:32 AM To: CF-Talk Subject: RE: NTFS File Settings - advice required Thanks Steve. Problem is we need anonymous access as we do not want people to login to these sites. Nick -----Original Message----- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 14:24 To: CF-Talk Subject: RE: NTFS File Settings - advice required If you just want to secure a web folder in the IIS manager snap-in, just right click on the folder name that you want secured, and select properties, then go into the Directory Security and turn off anonymous access. Make sure you select Basic Authentication to allow users to login through a web page. If you want the entire site secured, do the same but on Default Web Site. ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com -----Original Message----- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 9:17 AM To: CF-Talk Subject: NTFS File Settings - advice required I have CF5.0 installed and running on one of my web servers. I was trying to secure my site through IIS and NTFS. However, coldfusion seems to ignore the account set in IIS for anonymous web browsing and only works using the "everyone" group. Is this normal? surely it can be changed somewhere to another account?? TIA Nick -----Original Message----- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 13:54 To: CF-Talk Subject: RE: Query error in aggregate function You could either use the GROUP BY statement: SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID FROM t_msg GROUP BY t_mess, t_subcat_id or do a subquery: SELECT t_subcat_ID, (SELECT MAX(t_mess) FROM t_msg) AS RECHIGH FROM t_msg ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com -----Original Message----- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 8:36 AM To: CF-Talk Subject: Query error in aggregate function I want to run a query (using Access) which will return the most recent record ID # (t_mess) and one other column (t_subcat_ID). When I run it without the t_subcat_ID field, it runs great, bringing me the most recent record. When I add t_subcat_ID, I receive the following error: ------------------------------- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 't_subcat_ID' as part of an aggregate function. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (30:1) to (33:39). ------------------------------- And here's the query expression: <CFQUERY NAME="q_mostrecent" DATASOURCE="uspc"> SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID FROM t_msg </CFQUERY> <cfoutput>#q_mostrecent.rechigh# #q_mostrecent.t_subcat_ID#</cfoutput><cfabort> -------------------------------- How do I fix this? Thanks in advance. Mark ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
