Re: Possible thread issue?
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. These thread then issues a request via a web-service invocation. The thread requests are issued to an external hardware load balancer which in turn route the request to one of two CF servers(physically seperate hardware and software) running the webservice. The webservice invokes this bit of code. So the bit where it all goes wrong is behind the web service. There is no custom threads, etc on the web service side. I can understand if the first ID returned is getting confused, but it is not. It only happens later on in the code... Tks Andre > > 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 be affected > by other clients, even if they generate > > AUTO_INCREMENT values of their own. This behavior ensures that each > client can retrieve its own ID without concern for the > > activity of other clients, and without the need for locks or > transactions. > > Remember, though, that CF isn't the client - your individual CF files > are the clients. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working
> 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 get 500 errors, so I don't think there's really an "IIS" 500 error. There are, of course, standard error messages for ASP.NET and "classic" ASP 500 errors. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working
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 driving it > these days, and CF should show a CF error message > > which IIS will send back to the client as an HTTP 200 - otherwise CF > custom error handling wouldn't work at all. > > If this is not the case, then it's a bug or poor design feature in > CF - IIS doesn't hijack stuff unless something goes wrong in the > > processing of the CF ISAPI, which it will then catch the error and > issue the 500. > > CF errors are no longer returned as 200 by default. They are now > returned as 500. This has been the case since at least CF 6.x, I > believe. The CF error message can be shown by the browser with a 500 > error message, though, unless you're using IE with the "show friendly > HTTP error messages" option enabled. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more informat ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working
> 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 as an HTTP 200 - otherwise CF custom > error handling wouldn't work at all. > If this is not the case, then it's a bug or poor design feature in CF - IIS > doesn't hijack stuff unless something goes wrong in the > processing of the CF ISAPI, which it will then catch the error and issue the > 500. CF errors are no longer returned as 200 by default. They are now returned as 500. This has been the case since at least CF 6.x, I believe. The CF error message can be shown by the browser with a 500 error message, though, unless you're using IE with the "show friendly HTTP error messages" option enabled. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informat ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working
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 client as an HTTP 200 - otherwise CF custom error handling wouldn't work at all. If this is not the case, then it's a bug or poor design feature in CF - IIS doesn't hijack stuff unless something goes wrong in the processing of the CF ISAPI, which it will then catch the error and issue the 500. - Matt > 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 the correct configuration to make it stop hijacking > my application specific error messages. > > I'll try tracing the logs and see if that shows me anything though. > Thanks again, > Steve > > > 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 > > what CF logs in there. > > > Additionally, you can enable FREB logging to get an overview of the > > > request as it passes through the IIS request pipeline. Just bing it > > > or go to http://iis.net to see how to enable freb logging. > > > > - Matt > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
> 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 be affected by other > clients, even if they generate > AUTO_INCREMENT values of their own. This behavior ensures that each client > can retrieve its own ID without concern for the > activity of other clients, and without the need for locks or transactions. Remember, though, that CF isn't the client - your individual CF files are the clients. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328938 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
> 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 have "Maintain Connections" enabled in the CF Administrator, my understanding is that a single page request will keep the open connection until it has finished using it. If another page request needs a similar connection, it will grab another from the pool if there is one, or create a new one. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
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 last_insert_id() to >run on another connection. See http://lagod.id.au/blog/?p=41 >Jaime > > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting Static Image Expire
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 can't do that, then using cf to serve images with custom expires headers is a reasonable workaround. Dominic 2009/12/7 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 and gzipping of text/js, > text/css and text/html. Scoring well on the ETags test is a little esoteric > though; basically, in IIS, you need to add a custom header value named > 'ETag' with a blank value, scrapping the ETag - basically they're more > effort than they're worth for the client, so Yahoo advise they be turned > off. > > Once you've fixed those problems, your YSlow score will be excellent and > the site will be performing very well from a front end point of view > (depending on your server, of course) and you can stop using CF to serve > images (a really horrid idea). > > As for the huge background image - I quickly knocked it down to 85% quality > in The GIMP and it shrunk the image size by 75%. The difference in the image > was barely noticeable. After you've done that (or perhaps a little less > lossy if the designer can't bear it), you can then use YSlow once again to > compress it as far as it will go without losing any image quality - just go > to the Components tab, find the background image and then click the > smush.it link. > > I'll repeat: install and use YSlow and Firebug add-ons for firefox, they > are revelatory! > > Dominic > > > 2009/12/7 Jessica Kennedy > > >> Oh! Sorry, I'm testing on IE 7. Sry if this was ot-- I was thinking I >> would probably need to implement a 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 thought >> it could fix... but apparently not =( >> >> appreciate the help regardless, though! >> >> >>> nothing... really? >> > >> >Yes really. Not to be a jerk or anything but this is OT. You might be >> better >> >of hitting up a UI list as this is not a cf issue but a browser issue or >> >even worse a (shudder) IE issue. You have not told us what version of IE >> you >> >are using so we can check it. That is a critical piace of info. There are >> 3 >> >versions of IE in common use these days 7, 8 and the dreaded 6. >> > >> >I know, cross browser UI can be a total pain... wait strike that... a >> LIVING >> >NIGHTMARE when it comes to IE. So I feel your pain. >> > >> >It literally could be anything. I would start commenting out parts of the >> >page until you find the offending piece of code. I have had hidden form >> >fields and JS blocks throw off page elements before. I would also try >> using >> >other roll over techniques (There are dozens) and see if that fixes the >> >problem. >> > >> >HTH and Godspeed. >> > >> >G! >> > >> > >> >On Sat, Dec 5, 2009 at 1:14 PM, Jessica Kennedy < >> >police_kidnapped_your_child...@yahoo.com> wrote: >> > >> >> >> >> nothing... really? >> >> >> >> >> >> >> >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
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 http://lagod.id.au/blog/?p=41 Jaime On Tue, Dec 8, 2009 at 8:51 AM, Andrew Grosset wrote: > > 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. This value cannot be > affected by other clients, even if they generate AUTO_INCREMENT values of > their own. This behavior ensures that each client can retrieve its own ID > without concern for the activity of other clients, and without the need for > locks or transactions. > > > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id > > > > 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 basis." > > > > If two page requests are running simultaneously, they're not using > > the > > same connection. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > > > Fig Leaf Software provides the highest caliber vendor-authorized > > instruction at our training centers in Washington DC, Atlanta, > > Chicago, Baltimore, Northern Virginia, or on-site at your location. > > Visit http://training.figleaf.com/ for more > information! > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
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, connections and transaction in a CF thread scenario, particularly where shared scopes are involved. Jaime On Tue, Dec 8, 2009 at 5:22 AM, Andre Kapp wrote: > > 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 transID. > When you start putting a bit of load on this code, the transID gets > mangled/confused/ > When looking at the first cflog here, the trans id is the correct value is > an thedatabase table. > However, after the values are assigned to stTrans, the trans id is > different! It is that of another tx that happend later on... > > > > Nowere is the transID updated in the code between the two cflog's. The > value in the cflog is correct, as it is this value that I receive on the > other side of the WebService module > > > > > Here is the logfile output > Look for card no 00213 > > > > Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS","Process tx for > xxx00213 with tx id 163537 and Thread.txid is 163537" > > > "Information","jrpp-0","12/07/09","20:11:27","GCCSVPWS"," Process tx (after > transaction) for x000346 with tx id 163537 and Thread.txid is 163537" > "Information","jrpp-4","12/07/09","20:11:27","GCCSVPWS"," Process tx (after > transaction) for 38304 with tx id 163537 and Thread.txid is 163537" > "Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for > 254" > "Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for > xxx0270" > "Information","jrpp-16","12/07/09","20:11:27","GCCSVPWS"," Process tx > (after transaction) for xx005097 with tx id 163537 and Thread.txid is > 163537" > "Information","jrpp-18","12/07/09","20:11:27","GCCSVPWS"," Process tx > (after transaction) for xx00239 with tx id 163537 and Thread.txid is > 163537" > "Information","jrpp-19","12/07/09","20:11:27","GCCSVPWS"," Process tx > (after transaction) for xx00304 with tx id 163537 and Thread.txid is > 163537" > "Information","jrpp-8","12/07/09","20:11:27","GCCSVPWS","Process tx for > x12 with tx id 163538 and Thread.txid is 163538" > "Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for > x270 with tx id 163539 and Thread.txid is 163539" > "Information","jrpp-3","12/07/09","20:11:27","GCCSVPWS"," Process tx (after > transaction) for 0288 with tx id 163539 and Thread.txid is 163539" > "Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for > xxx254 with tx id 163540 and Thread.txid is 163540" > "Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS"," Process tx (after > transaction) for xx0213 with tx id 163540 and Thread.txid is 163540" > > > > > > > > I found a problem when I did code optimizationon the other side of the > webservice. First thought it was the web service, but trace it right down to > this bit of code on the one server. > > > > This is happening on my Mac's VM's running CentOS 5.2 and Coldfusion 8 on > top of that. > > Coldfusion details: > Server Product ColdFusion > Version 8,0,1,195765 > > > Operating SystemUNIX > OS Version 2.6.18-128.2.1.el5 > JVM Details > Java Version1.6.0_04 > > > > Database is MySQL version 5.0 > > > > > > Any any any ideas will be appreciated! > > > > > > > > snipped > > > >SELECT last_insert_id() AS transid; > > > > > > > > type="information"> > > > >UPDATE acct_balances >SET >acct_balance = acct_balance + #arguments.amount#, >acct_balance_available = acct_balance_available + > #arguments.amount# >WHERE >acct_id = value="#arguments.acctid#"> > > > > > > > > > > CHECK FOR NEG to POS > > > > > GTE 0> > >UPDATE fees_collection >SET >settled = cfsqltype="CF_SQL_INTEGER" value="1">, >settled_trans_id = cfsqltype="CF_SQL_INTEGER" value="#theTransID#">, >settled_dttm = NOW() >WHERE >acct_id = cfsqltype="CF_SQL_INTEGER" value="#arguments.acctid#"> AND >
Re: Setting Static Image Expire
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 and gzipping of text/js, text/css and text/html. Scoring well on the ETags test is a little esoteric though; basically, in IIS, you need to add a custom header value named 'ETag' with a blank value, scrapping the ETag - basically they're more effort than they're worth for the client, so Yahoo advise they be turned off. Once you've fixed those problems, your YSlow score will be excellent and the site will be performing very well from a front end point of view (depending on your server, of course) and you can stop using CF to serve images (a really horrid idea). As for the huge background image - I quickly knocked it down to 85% quality in The GIMP and it shrunk the image size by 75%. The difference in the image was barely noticeable. After you've done that (or perhaps a little less lossy if the designer can't bear it), you can then use YSlow once again to compress it as far as it will go without losing any image quality - just go to the Components tab, find the background image and then click the smush.itlink. I'll repeat: install and use YSlow and Firebug add-ons for firefox, they are revelatory! Dominic 2009/12/7 Jessica Kennedy > > Oh! Sorry, I'm testing on IE 7. Sry if this was ot-- I was thinking I > would probably need to implement a 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 thought > it could fix... but apparently not =( > > appreciate the help regardless, though! > > >>> nothing... really? > > > >Yes really. Not to be a jerk or anything but this is OT. You might be > better > >of hitting up a UI list as this is not a cf issue but a browser issue or > >even worse a (shudder) IE issue. You have not told us what version of IE > you > >are using so we can check it. That is a critical piace of info. There are > 3 > >versions of IE in common use these days 7, 8 and the dreaded 6. > > > >I know, cross browser UI can be a total pain... wait strike that... a > LIVING > >NIGHTMARE when it comes to IE. So I feel your pain. > > > >It literally could be anything. I would start commenting out parts of the > >page until you find the offending piece of code. I have had hidden form > >fields and JS blocks throw off page elements before. I would also try > using > >other roll over techniques (There are dozens) and see if that fixes the > >problem. > > > >HTH and Godspeed. > > > >G! > > > > > >On Sat, Dec 5, 2009 at 1:14 PM, Jessica Kennedy < > >police_kidnapped_your_child...@yahoo.com> wrote: > > > >> > >> nothing... really? > >> > >> > >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
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. This value cannot be affected by other clients, even if they generate AUTO_INCREMENT values of their own. This behavior ensures that each client can retrieve its own ID without concern for the activity of other clients, and without the need for locks or transactions. http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id > > 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 basis." > > If two page requests are running simultaneously, they're not using > the > same connection. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
> 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 basis." If two page requests are running simultaneously, they're not using the same connection. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible thread issue?
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 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 cf, the generatedkeys. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Possible thread issue?
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 cf, the generatedkeys. -Original Message- From: Andre Kapp Sent: Monday, December 07, 2009 11:22 AM To: cf-talk Subject: Possible thread issue? 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 transID. When you start putting a bit of load on this code, the transID gets mangled/confused/ When looking at the first cflog here, the trans id is the correct value is an thedatabase table. However, after the values are assigned to stTrans, the trans id is different! It is that of another tx that happend later on... Nowere is the transID updated in the code between the two cflog's. The value in the cflog is correct, as it is this value that I receive on the other side of the WebService module Here is the logfile output Look for card no 00213 Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS","Process tx for xxx00213 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-0","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for x000346 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-4","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for 38304 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for 254" "Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for xxx0270" "Information","jrpp-16","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx005097 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-18","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx00239 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-19","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx00304 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-8","12/07/09","20:11:27","GCCSVPWS","Process tx for x12 with tx id 163538 and Thread.txid is 163538" "Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for x270 with tx id 163539 and Thread.txid is 163539" "Information","jrpp-3","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for 0288 with tx id 163539 and Thread.txid is 163539" "Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for xxx254 with tx id 163540 and Thread.txid is 163540" "Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx0213 with tx id 163540 and Thread.txid is 163540" I found a problem when I did code optimizationon the other side of the webservice. First thought it was the web service, but trace it right down to this bit of code on the one server. This is happening on my Mac's VM's running CentOS 5.2 and Coldfusion 8 on top of that. Coldfusion details: Server Product ColdFusion Version 8,0,1,195765 Operating SystemUNIX OS Version 2.6.18-128.2.1.el5 JVM Details Java Version1.6.0_04 Database is MySQL version 5.0 Any any any ideas will be appreciated! snipped SELECT last_insert_id() AS transid; UPDATE acct_balances SET acct_balance = acct_balance + #arguments.amount#, acct_balance_available = acct_balance_available + #arguments.amount# WHERE acct_id = UPDATE fees_collection SET settled = , settled_trans_id = , settled_dttm = NOW() WHERE acct_id = AND settled = 0 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.house
Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working
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 the correct configuration to make it stop hijacking my application specific error messages. I'll try tracing the logs and see if that shows me anything though. Thanks again, Steve > 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 > what CF logs in there. > Additionally, you can enable FREB logging to get an overview of the > request as it passes through the IIS request pipeline. Just bing it > or go to http://iis.net to see how to enable freb logging. > > - Matt > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working
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 what CF logs in there. Additionally, you can enable FREB logging to get an overview of the request as it passes through the IIS request pipeline. Just bing it or go to http://iis.net to see how to enable freb logging. - Matt > 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 server to IIS7. Now all I get is the "Internal > Server Error." > > I have googled the issue and searched these forums and found various > threads about changing the errorMode or setting the existingResponse > to passthrough in the IIS7 config. I have tried these and still not > gotten anything to work. The only change I get is if I update the > coldfusion config to not pass in the HTTP error codes but in that case > my error message simply becomes "OK". Not too helpful of a message. > > My question is. Has anyone else run into these issues on IIS7 with > Coldfusion 8 and if so, how did you configure the server to stop > blocking the custom errors? Any help would be appreciated. At this > point I just want to hit IIS7 with blunt objects,not that it would > help. > > Thanks in advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Basic user stats via Coldfusion
> > 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 lot of cookies - presumably one per page. Eventually, you'd reach the limit of the number of cookies per domain, which is pretty low as I recall. A better approach would be to track the pages visited in the Session scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting Static Image Expire
> Oh! Sorry, I'm testing on IE 7. Sry if this was ot-- I was thinking I would > probably need to implement a 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 thought it could fix... but apparently not =( You could use CF to serve images, and control their caching that way. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informatio ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Possible thread issue?
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 transID. When you start putting a bit of load on this code, the transID gets mangled/confused/ When looking at the first cflog here, the trans id is the correct value is an thedatabase table. However, after the values are assigned to stTrans, the trans id is different! It is that of another tx that happend later on... Nowere is the transID updated in the code between the two cflog's. The value in the cflog is correct, as it is this value that I receive on the other side of the WebService module Here is the logfile output Look for card no 00213 Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS","Process tx for xxx00213 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-0","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for x000346 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-4","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for 38304 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for 254" "Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for xxx0270" "Information","jrpp-16","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx005097 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-18","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx00239 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-19","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx00304 with tx id 163537 and Thread.txid is 163537" "Information","jrpp-8","12/07/09","20:11:27","GCCSVPWS","Process tx for x12 with tx id 163538 and Thread.txid is 163538" "Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for x270 with tx id 163539 and Thread.txid is 163539" "Information","jrpp-3","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for 0288 with tx id 163539 and Thread.txid is 163539" "Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for xxx254 with tx id 163540 and Thread.txid is 163540" "Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS"," Process tx (after transaction) for xx0213 with tx id 163540 and Thread.txid is 163540" I found a problem when I did code optimizationon the other side of the webservice. First thought it was the web service, but trace it right down to this bit of code on the one server. This is happening on my Mac's VM's running CentOS 5.2 and Coldfusion 8 on top of that. Coldfusion details: Server Product ColdFusion Version 8,0,1,195765 Operating SystemUNIX OS Version 2.6.18-128.2.1.el5 JVM Details Java Version1.6.0_04 Database is MySQL version 5.0 Any any any ideas will be appreciated! snipped SELECT last_insert_id() AS transid; UPDATE acct_balances SET acct_balance = acct_balance + #arguments.amount#, acct_balance_available = acct_balance_available + #arguments.amount# WHERE acct_id = UPDATE fees_collection SET settled = , settled_trans_id = , settled_dttm = NOW() WHERE acct_id = AND settled = 0 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Character Encoding Issues?
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: Character Encoding Issues? >From a CF template, I'm performing an insert into an Oracle (10g) VARCHAR2 >column. The characters I'm trying to insert contain —. After retrieving >the column and displaying it in the browser, — is replaced with an odd >character. — is not even in the DB! This leads me to believe that some >sort of transformation took place. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Basic user stats via Coldfusion
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: IF NOT EXISTS ( SELECT loginID FROM loginLog WHERE loginID = '#uCase(user)#' AND loginTime = ) BEGIN INSERT INTO loginLog ( loginID, name, jobTitle, department ... [and so on] END ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Basic user stats via Coldfusion
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 report or even delete them in a nightly scheduled process. Databases are optimized for querying sets of data. Meaning if you can bundle up a bunch of individual lookups into one big lookup, the overall processing time should be less. Are you familiar with OnRequestStart and an OnRequestEnd? Are you using Application.cfc or Application.cfm? Good luck, Mike Chabot On Mon, Dec 7, 2009 at 12:05 PM, Ian Vaughan wrote: > > On our intranet I have a coldfusion script that captures a user's > network/loginid > > > > 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 > Name > Job Title > Department > IP address etc > > > 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? > > > And where would this query be better placed, as I don't really want to > include it in each page manually. > > > Any ideas would be welcome? > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: admin
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 wrote: > > 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 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 mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: admin
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, 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 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 mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: admin
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 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 mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Basic user stats via Coldfusion
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 11:06 AM To: cf-talk Subject: Basic user stats via Coldfusion On our intranet I have a coldfusion script that captures a user's network/loginid 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 Name Job Title Department IP address etc 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? And where would this query be better placed, as I don't really want to include it in each page manually. Any ideas would be welcome? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Basic user stats via Coldfusion
> > >>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 want to > include it in each page manually. > In Application.cfm or Application.cfc HTH G! On Mon, Dec 7, 2009 at 12:05 PM, Ian Vaughan < i.vaug...@neath-porttalbot.gov.uk> wrote: > > On our intranet I have a coldfusion script that captures a user's > network/loginid > > > > 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 > Name > Job Title > Department > IP address etc > > > 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? > > > And where would this query be better placed, as I don't really want to > include it in each page manually. > > > Any ideas would be welcome? > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
admin
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 mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Basic user stats via Coldfusion
On our intranet I have a coldfusion script that captures a user's network/loginid 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 Name Job Title Department IP address etc 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? And where would this query be better placed, as I don't really want to include it in each page manually. Any ideas would be welcome? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Character Encoding Issues?
>From a CF template, I'm performing an insert into an Oracle (10g) VARCHAR2 >column. The characters I'm trying to insert contain —. After retrieving >the column and displaying it in the browser, — is replaced with an odd >character. — is not even in the DB! This leads me to believe that some >sort of transformation took place. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion could not delete the file
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 how to do it programatically (like from CF), but you might find a > command-line utility in the sysinternals package that you can run with > CFEXECUTE if you dig a bit. There's all kinds of goodies in there. > > cheers, > barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working
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 server to IIS7. Now all I get is the "Internal Server Error." I have googled the issue and searched these forums and found various threads about changing the errorMode or setting the existingResponse to passthrough in the IIS7 config. I have tried these and still not gotten anything to work. The only change I get is if I update the coldfusion config to not pass in the HTTP error codes but in that case my error message simply becomes "OK". Not too helpful of a message. My question is. Has anyone else run into these issues on IIS7 with Coldfusion 8 and if so, how did you configure the server to stop blocking the custom errors? Any help would be appreciated. At this point I just want to hit IIS7 with blunt objects,not that it would help. Thanks in advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion could not delete the file
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 utility in the sysinternals package that you can run with CFEXECUTE if you dig a bit. There's all kinds of goodies in there. cheers, barneyb On Mon, Dec 7, 2009 at 8:01 AM, Stefan Richter wrote: > > 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 > > > > On 7 Dec 2009, at 15:40, Barney Boisvert wrote: > >> >> 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 >> wrote: >>> >>> 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 >>> >> recurse="yes"> >>> >>> Regards, >>> >>> Stefan >>> >>> > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFmail problem - Error - Mail Respool not working now
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 and moves files back to the spool folder... and the system sends the message again. Trouble is that CF does recognize when it sends some messages as you can see in the mailsent.log. the snippets below are from various log files. Thanks for any help that you might provide. mailsent.log "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail42216.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail42217.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail42218.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail42219.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail42220.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail42221.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail4.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-4","12/06/09","20:36:42",,"Moved undelivered mail: Mail42223.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-1","12/06/09","21:08:58",,"Mail: 'Error - OpenFence (12/06/2009: 21:08:56)' From:'er...@openfence.net' To:'er...@openfence.net' was successfully sent using mail.sfnet.com" "Information","scheduler-1","12/06/09","21:09:43",,"Mail: 'Error - OpenFence (12/06/2009: 21:09:28)' From:'er...@openfence.net' To:'er...@openfence.net' was successfully sent using mail.sfnet.com" "Information","scheduler-2","12/06/09","21:11:58",,"Mail: 'COMMENT - Posted on OpenFence Biz Buzz' From:'nore...@openfence.net' To:'kree...@hotmail.com' was successfully sent using mail.sfnet.com" "Information","scheduler-2","12/06/09","21:14:59",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-2","12/06/09","21:14:59",,"Mail: 'COMMENT - Posted' From:'nore...@openfence.net' To:'comme...@openfence.net' was successfully sent using mail.sfnet.com" "Information","scheduler-2","12/06/09","21:14:59",,"Mail: 'ACTION REQIURED - Complete your OpenFence Comment' From:'nore...@openfence.net' To:'twomu...@yahoo.com' was successfully sent using mail.sfnet.com" "Information","scheduler-2","12/06/09","21:16:14",,"Mail: 'Customer Comment Posted on OpenFence' From:'nore...@openfence.net' To:'kree...@hotmail.com' was successfully sent using mail.sfnet.com" "Information","scheduler-1","12/06/09","21:27:59",,"Mail: 'SFNET Sign-in ID and Password' From:'ad...@sfnet.net' To:'kree...@hotmail.com' was successfully sent using mail.sfnet.com" "Information","scheduler-1","12/06/09","21:41:59",,"Mail: 'Error - 1031resource (12/06/2009: 21:41:58)' From:'dataer...@sfnet.com' To:'dataer...@sfnet.com' was successfully sent using mail.sfnet.com" "Information","scheduler-2","12/06/09","22:03:15",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-3","12/06/09","23:03:02",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-2","12/06/09","23:33:03",,"Mail: 'myIRAresource Website Upgrade Instructions' From:'upgr...@myiraresource.com' To:'al.ziel...@prurealty.com' was successfully sent using mail.sfnet.com" "Information","scheduler-0","12/07/09","00:03:05",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-0","12/07/09","00:03:05",,"Mail: '[OpenFence] School Revenue Update' From:'ofsanlean...@sfnet.com' To:'ofsanlean...@sfnet.com' was successfully sent using mail.sfnet.com" "Information","scheduler-0","12/07/09","00:03:05",,"Mail: '(OpenFence report) Pre-Marketing Advertising Report' From:'ad...@openfence.net' To:'ad...@openfence.net' was successfully sent using mail.sfnet.com" "Information","scheduler-4","12/07/09","01:03:07",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-1","12/07/09","02:03:11",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-0","12/07/09","03:03:12",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-5","12/07/09","04:03:14",,"Moved undelivered mail: Mail42231.cfmail to C:\CFusionMX/Mail/Undelivr directory" "Information","scheduler-5","12/07/09","04:03:14",,"Mail:
Re: ColdFusion could not delete the file
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 On 7 Dec 2009, at 15:40, Barney Boisvert wrote: > > 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 > wrote: >> >> 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 >> >> >> Regards, >> >> Stefan >> >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion could not delete the file
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 wrote: > > 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 > > > Regards, > > Stefan > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion could not delete the file
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 Regards, Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8.0.1 cumulative hot fix 4
> > 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 wrote: > > 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 used mapping /website -> C:\inetpub\wwwroot\mysite_com\website it worked > for you. > > 2)In your second case http://www.mysite.com/mysite_com_model/.../MyCFC.cfc > We dont use mappings to resolve the url path it is the connector which does > that. > Thats why when you created a virtual directory /mysite_com_model - > C:\inetpub\wwwroot\mysite_com\website\model it worked for you because > connector gets the realpath from webserver and in your case gets the path > for the virtual directory. > > Thanks, > Asha. > Adobe ColdFusion Team. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8.0.1 cumulative hot fix 4
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 used mapping /website -> C:\inetpub\wwwroot\mysite_com\website it worked for you. 2)In your second case http://www.mysite.com/mysite_com_model/.../MyCFC.cfc We dont use mappings to resolve the url path it is the connector which does that. Thats why when you created a virtual directory /mysite_com_model - C:\inetpub\wwwroot\mysite_com\website\model it worked for you because connector gets the realpath from webserver and in your case gets the path for the virtual directory. Thanks, Asha. Adobe ColdFusion Team. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Collaboration Chat - the Sequel
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 (and/or commercial) projects. http://experts.na3.acrobat.com/collab/ In the weeks since the first chat, we've made good progress on the FreeAgent project, which is designed as a system for creating applications that can be easily installed into any of the MVC frameworks for ColdFusion. I'll talk a bit about what we're doing with this project, and probably show some code and I hope as well that some of you will bring your thoughts, tips, tools and techniques that you've used to create integration between projects. Or even just your thoughts on the subject, since this isn't something we see much in the community yet. :) Had a great time last time, and although I know this is short notice, I expect to have a good fun session this time as well. :) See you there! p.s. If you want to get a look at FreeAgent before the chat, you'll find it at http://freeagent.riaforge.org - and we have a discussion group at http://groups.google.com/group/free-agent -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
