CF Collaboration Chat - the Sequel

2009-12-07 Thread s. isaac dealey
Tomorrow, Tuesday around 6pm Central I plan to open up the CF Community Collaboration Chat room again for another session. This is an informal discussion of tools and techniques for improving collaboration within the ColdFusion community and encouraging integration between various open-source

Re: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-07 Thread asha kasala
Hi John, I dont know how it was working before but the behaviour now seems to be right. 1)Since C:\inetpub\wwwroot\mysite_com\website is your webroot you need to use controller.MyFuse not website.controller.MyFuse. We actually check in the mappings before checking in webroot thats why when you

Re: ColdFusion 8.0.1 cumulative hot fix 4

2009-12-07 Thread John M Bliss
I dont know how it was working before but the behaviour now seems to be right. Second part of that statement seems good and right and I concur with it. First part is a bit scary. Seems likely that other people will have similar problems... On Mon, Dec 7, 2009 at 4:56 AM, asha kasala

ColdFusion could not delete the file

2009-12-07 Thread Stefan Richter
Hi all, what may be causing the following error and what - if anything - could I do to prevent it? This is on a Windows server with CF8. ColdFusion could not delete the file C:\Inetpub\...\folder\file.ppt for an unknown reason. This happens when I run cfdirectory action=delete

Re: ColdFusion could not delete the file

2009-12-07 Thread Barney Boisvert
If you just want to silently ignore, wrap with CFTRY..CFCATCH and nothing in the CFCATCH. Typically windows has this problem if another process has the file open for some reason (or just hasn't cleaned up it's handles). cheers, barneyb On Mon, Dec 7, 2009 at 7:37 AM, Stefan Richter

Re: ColdFusion could not delete the file

2009-12-07 Thread Stefan Richter
Thanks Barney, I'm already catching it. I was wondering if there's a way to force delete it somehow - any process that is still hanging onto it would likely be CF or the webserver. On the other hand, how can I find out what's holding onto it? I know how to do this on OSX... Cheers Stefan

CFmail problem - Error - Mail Respool not working now

2009-12-07 Thread wayne gregori
CFmail has stopped working. I have an application that send mail through CF that has been working reliably for years. The problem is that CF does not recognize that the mail has been sent and moves the message to the undeliverable folder. I have a program that scans the undeliverable folder

Re: ColdFusion could not delete the file

2009-12-07 Thread Barney Boisvert
procexp (Process Explorer) from sysinternals (http://www.sysinternals.com/ or http://live.sysinternals.com/procexp.exe) will let you browse open handles on files and see what process(es) have them open. I don't know how to do it programatically (like from CF), but you might find a command-line

CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-07 Thread Steve Paulson
We make use of ColdFusion.Ajax.submitForm to do the login for our site. If the user/password provided is not found I do a cfthrow with a custom error message that gets picked up by the errorHandler and updates the screen with the message User not found. This worked fine till we upgraded the

Re: ColdFusion could not delete the file

2009-12-07 Thread Stefan Richter
excellent, thanks On 7 Dec 2009, at 16:07, Barney Boisvert wrote: procexp (Process Explorer) from sysinternals (http://www.sysinternals.com/ or http://live.sysinternals.com/procexp.exe) will let you browse open handles on files and see what process(es) have them open. I don't know

Character Encoding Issues?

2009-12-07 Thread Robert Nurse
From a CF template, I'm performing an insert into an Oracle (10g) VARCHAR2 column. The characters I'm trying to insert contain #8212. After retrieving the column and displaying it in the browser, #8212 is replaced with an odd character. #8212 is not even in the DB! This leads me to believe

Basic user stats via Coldfusion

2009-12-07 Thread Ian Vaughan
On our intranet I have a coldfusion script that captures a user's network/loginid cfset user = listLast(cgi.REMOTE_USER,\) This variable is then run against a user table with the following 'where' clause WHERE uPPER(NETWORK_ID) = '#ucASE(user)#' This then captures user info such as Loginid

admin

2009-12-07 Thread Orlini, Robert
I know this has been touched on many times before, but how do I recover the admin password in CF MX? Thx. RO HWW ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion

Re: Basic user stats via Coldfusion

2009-12-07 Thread Gerald Guido
How would you restrict the query so it only runs once on each page per day for each user, instead of running every time the page is loaded? Set a cookie that expires after 24 hours. If the cookie doesn't exist, run the query. And where would this query be better placed, as I don't really

RE: Basic user stats via Coldfusion

2009-12-07 Thread Jason Durham
Am I properly restating this... You want to track what pages each user hits in a day. How many pages are we talking about? Couple dozen? Couple hundred? Couple thousand? -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Monday, December 07, 2009

RE: admin

2009-12-07 Thread Andy Matthews
I'd suggest a search of the HoF mailing list. Probably the quickest way to start. -Original Message- From: Orlini, Robert [mailto:rorl...@hwwilson.com] Sent: Monday, December 07, 2009 11:12 AM To: cf-talk Subject: admin I know this has been touched on many times before, but how do I

RE: admin

2009-12-07 Thread Orlini, Robert
done... thanks -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, December 07, 2009 12:36 PM To: cf-talk Subject: RE: admin I'd suggest a search of the HoF mailing list. Probably the quickest way to start. -Original Message- From: Orlini,

Re: admin

2009-12-07 Thread Charlie Griefer
Or a google search :) http://www.google.com/search?q=coldfusion+recover+admin+password On Mon, Dec 7, 2009 at 9:35 AM, Andy Matthews li...@commadelimited.comwrote: I'd suggest a search of the HoF mailing list. Probably the quickest way to start. -Original Message- From: Orlini,

Re: Basic user stats via Coldfusion

2009-12-07 Thread Mike Chabot
Log minimal data to a database table and process the results when the server is less busy. Possibly skip the processing until the report needs to be generated. All you need to store is the page identifier, the user identifier, and the timestamp. You can screen out duplicate page hits in the

re: Basic user stats via Coldfusion

2009-12-07 Thread Jason Fisher
Include it in the onSessionStart method of Application.cfc and it will run only once per login. If you really only want it once per day (if, for example, users sometimes logout/in several times per day), then you could add a date test to the log INSERT query: cfquery ... IF NOT EXISTS (

RE: Character Encoding Issues?

2009-12-07 Thread Lonny Eckert
Oracle is recognizing that as a variable because of the ampersand. You can replace the ampersand with the appropriate ascii escape sequence in your procedure. From: Robert Nurse [mailto:rnu...@gmail.com] Sent: Mon 12/7/2009 11:54 AM To: cf-talk Subject:

Possible thread issue?

2009-12-07 Thread Andre Kapp
I'v now come across a code problem that I simply cannot understand what is happending here. The code is part of a cfc module that is behind a web-service. This is not inside a loop - just a normal cfc with a function that enter, process and returns data... The problem here is the

Re: Setting Static Image Expire

2009-12-07 Thread Dave Watts
Oh!  Sorry, I'm testing on IE 7.  Sry if this was ot-- I was thinking I would probably need to implement a cfheader somehow to get the browser to cache images, i was just stuck on how to change the http header for the images that are loades... so not really an issue with CF, just one I

Re: Basic user stats via Coldfusion

2009-12-07 Thread Dave Watts
How would you restrict the query so it only runs once on each page per day for each user, instead of running every time the page is loaded? Set a cookie that expires after 24 hours. If the cookie doesn't exist, run the query. That probably wouldn't be a good idea, as you'd be setting a

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-07 Thread Matthew Small
Hi Steve, Internal Server Error usually manifests itself in IIS as an HTTP 500 - you can check the IIS logs to see if that's what you're getting. If that's the case, you will usually find some clue to the root cause by investigating the system and application event logs - depending on

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-07 Thread Steve Paulson
Matt, Thanks for responding. My issue isn't so much that the internal server error is being raised in fact Im the one that is raising it by using CFTHROW. My issue is that IIS7 intercepts my error message and replaces it with its own where IIS6 did not. For the life of me I cannot determine

RE: Possible thread issue?

2009-12-07 Thread William Seiter
Last_insert_id does just that, gets the last inserted id. No matter who entered it. This means that under intense traffic, that select may not return the id associated with that transactions action. You should find the mysql equivalent to ScopeIdentity() Or if you are using a newer version of

Re: Possible thread issue?

2009-12-07 Thread Andrew Grosset
I was under the impression that Last_Insert_ID() in MySQL was the equilavent of Scope_Identity() in MSSQL.please correct me if I'm wrong. Andrew. Last_insert_id does just that, gets the last inserted id. No matter who entered it. This means that under intense traffic, that select may

Re: Possible thread issue?

2009-12-07 Thread Dave Watts
I was under the impression that Last_Insert_ID() in MySQL was the equilavent of Scope_Identity() in MSSQL.please correct me if I'm wrong. You're wrong, I think. From the MySQL docs: For LAST_INSERT_ID(), the most recently generated ID is maintained in the server on a per-connection

Re: Possible thread issue?

2009-12-07 Thread Andrew Grosset
maybe not (wrong)... The ID that was generated is maintained in the server on a per-connection basis. This means that the value returned by the function to a given client is the first AUTO_INCREMENT value generated for most recent statement affecting an AUTO_INCREMENT column by that client.

Re: Setting Static Image Expire

2009-12-07 Thread Dominic Watson
I just checked the site out using YSlow and it scored pretty well. However, it very quickly pointed out the problems: * Add expires headers (this is why your images are not being cached) * Compress components using GZip * Configure Entity Tags (ETags) Check your IIS settings for expires headers

Re: Possible thread issue?

2009-12-07 Thread Jaime Metcher
Andrew, I can't help thinking the code you haven't shown is important. Are you creating a CF thread? And are any of your variables in shared scopes? Transactions and threads don't necessarily work the way you might expect. There are lots of possibilites for cross-talk between threads,

Re: Possible thread issue?

2009-12-07 Thread Jaime Metcher
Andrew G, But...:) A single request won't necessarily keep the same connection, especially under load. So unless you use a transaction, it's entirely possible for the insert query to run on one connection, and the select last_insert_id() to run on another connection. See

Re: Setting Static Image Expire

2009-12-07 Thread Dominic Watson
Oh my god, I'm an ass. Just read your post properly - apologies for my previous post. Having a host that doesn't have IIS setup for these basic things and that won't change them when you point them out is definitely the main problem, change if you can (ideally to a VPS). If you/the client really

Re: Possible thread issue?

2009-12-07 Thread Andrew Grosset
thanks Jaime, I'll make sure that I use cftransaction. Andrew. Andrew G, But...:) A single request won't necessarily keep the same connection, especially under load. So unless you use a transaction, it's entirely possible for the insert query to run on one connection, and the select

Re: Possible thread issue?

2009-12-07 Thread Dave Watts
A single request won't necessarily keep the same connection, especially under load.  So unless you use a transaction, it's entirely possible for the insert query to run on one connection, and the select last_insert_id() to run on another connection. See http://lagod.id.au/blog/?p=41 If you

Re: Possible thread issue?

2009-12-07 Thread Dave Watts
The ID that was generated is maintained in the server on a per-connection basis. This means that the value returned by the function to a given client is the first AUTO_INCREMENT value generated for most recent statement affecting an AUTO_INCREMENT column by that client. This value cannot

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-07 Thread Matthew Small
Hi Steve, I haven't done any CF server configuration in years, but I don't think that IIS is catching the throw that you're performing. A CFTHROW ought to be caught by the CF ISAPI or whatever is driving it these days, and CF should show a CF error message which IIS will send back to the

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-07 Thread Dave Watts
   I haven't done any CF server configuration in years, but I don't think that IIS is catching the throw that you're performing.  A CFTHROW ought to be caught by the CF ISAPI or whatever is driving it these days, and CF should show a CF error message which IIS will send back to the client

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-07 Thread Matthew Small
That begs the question - is this an IIS 500 or a CF 500? I imagine they look a lot different.    I haven't done any CF server configuration in years, but I don't think that IIS is catching the throw that you're performing.  A CFTHROW ought to be caught by the CF ISAPI or whatever is

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-07 Thread Dave Watts
That begs the question - is this an IIS 500 or a CF 500?  I imagine they look a lot different. I think that it's the job of the application server to provide error information, generally, so 500 errors will depend on the specific application server. If you just have static content, you don't

Re: Possible thread issue?

2009-12-07 Thread Andre Kapp
Tks for all the feedback so far. The problem is that the ID is returned correctly in the first place(first cflog), but when the variable is referenced later on in the code, it has changed (second cflog)! The total big picture is: One CF server running a program that generates 10 threads.