Re: CF8 and CFDUMP was: (Re: Coldspring error)
Well it beats me. I can run a page with cfdump var=#session# / and that displays just fine. But change that line to cfdump var=#beanfactory# / and the getClass() error we've been talking about pops up. Which things can you CFDUMP and which things can't? What a learning exercise I started this whole thing because i have a major rebuild of a client's site, and before i headed down the coldspring road with weeks of development, i wanted to make sure coldspring did actually work in this environment, and i wouldnt get to the end of the road only to find when i deployed the project that it didnt work.For example one possiblity i figured might trip me up is if someone had already set up a coldfuson mapping called coldspring. I needed to make sure nothing like that was going to render the whole project unworkable. In the process i've learned that CFDUMP= one of the most valuable debugging tools in coldfusion doesnt work. yes it does. No it doesnt. Well it kind of works. Actually it does work but only on some kinds of variables. HUH Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 10/25/07, James Holmes [EMAIL PROTECTED] wrote: Aha - there you go. In that case I predict that they do indeed allow access to the internal java objects. On 10/25/07, Brian Kotek [EMAIL PROTECTED] wrote: Actually, I stand corrected. Even though I still think it would be insane if the host isn't disabling access to the internal CF Java components, calling getClass() on any CFC throws the same error, regardless of whether the CF Java object access is disabled or not. On 10/25/07, Brian Kotek [EMAIL PROTECTED] wrote: ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using ColdFusion to determine if user has Flash player?
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: The flash detection kit is the way to go: SWFObject is nicer. -- Tom Chiverton Helping to apprehensively innovate virtual segments on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 and CFDUMP was: (Re: Coldspring error)
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: cfdump var=#beanfactory# / I cfdump'ed our application.beanfactory just yesterday, on CF7 on our own servers. It's 'normally' fine. -- Tom Chiverton Helping to heterogeneously maximize bricks-and-clicks data on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
I whole-heartedly agree and when I get some time I will do some testing. What I imagine to be the case is that the more complex the SQL required, the more likely it is that a stored procedure is beneficial but perhaps this is wrong (it is certainly blind assumption). Regardless of that, I like to contain all my data logic inside the database itself - feels clear in my head that way. Anyways, this is drifting off topic - just wanted to give an alternative to the OPs solution to his problem ;) Dom On 24/10/2007, Mark A Kruger [EMAIL PROTECTED] wrote: Dom, To know this you have to test. SPs are marginally faster in most cases - and just like cfqueries they have to be well written. There is not enough of a boost in performance (when comparing SPs to well written queries using cfqueryparam to bind the data) to make a hard and fast rule that SPs are best practice in all cases - that's my .02. Having said that, in a team enviornment there is some division of labor benefits. -Mark -- Blog it up: http://fusion.dominicwatson.co.uk ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Working with CFGRID
Thanks for that guys i got it working eventually!!! ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam and dynamically-created SQL
Yep, I think like with queryparam, you have to look outside of the performance benefits when working with stored procedures. The other benefits come when you have very complex queries that are accessed from several locations within an application, or multiple applications, this means not having to duplicate the query SQL code, it also helps with maintenance of the query down the line if needs be. There are probably performance benefits, but I'd imagine that if performance is a REAL concern to you, there are plenty of other places within your application where your time would be better spent optimizing, you'll likely get better performance benefits by considering things like caching of queries and objects and so on. Like the other guys have picked up on, the biggest performance on queries will come from good SQL code, you're best off spending some time in your database studio checking query performance times and looking at execution plans, playing with the SQL and table Indexing. Rob -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: 25 October 2007 09:50 To: CF-Talk Subject: Re: cfqueryparam and dynamically-created SQL I whole-heartedly agree and when I get some time I will do some testing. What I imagine to be the case is that the more complex the SQL required, the more likely it is that a stored procedure is beneficial but perhaps this is wrong (it is certainly blind assumption). Regardless of that, I like to contain all my data logic inside the database itself - feels clear in my head that way. Anyways, this is drifting off topic - just wanted to give an alternative to the OPs solution to his problem ;) Dom On 24/10/2007, Mark A Kruger [EMAIL PROTECTED] wrote: Dom, To know this you have to test. SPs are marginally faster in most cases - and just like cfqueries they have to be well written. There is not enough of a boost in performance (when comparing SPs to well written queries using cfqueryparam to bind the data) to make a hard and fast rule that SPs are best practice in all cases - that's my .02. Having said that, in a team enviornment there is some division of labor benefits. -Mark -- Blog it up: http://fusion.dominicwatson.co.uk ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFMX 7 - Jrun 100%
Back to the drawing board. It is a Verity collection indexing process that is causing Jrun to run high. I have it set as a scheduled hourly event. I have two Verity collections, let's call them Site A and Site B. Site A has been up and running for about 2 years. I added Site B last week. Indexing for Site B is running fine. Indexing for Site A causes Jrun to run at 100%. I have tried deleting then recreating the Site A collection, but as soon as I run the indexing Jrun again runs out of control. Does anyone know what I can do to resolve this please? Many thanks, Jenny -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 24 October 2007 21:38 To: CF-Talk Subject: RE: CFMX 7 - Jrun 100% Many thanks all for replies on this. It turned out to be a rogue app messing up Jrun. I uploaded the cfide from another server and all appears to be well. Jenny -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: 23 October 2007 17:19 To: CF-Talk Subject: Re: CFMX 7 - Jrun 100% Lots of things could cause JRun to max out, including but not limited too; bad code or client variable clean up. Check your logs to see what's going on. No, you don't need to have CF6 installed to upgrade to 7. After you stick in your CF7 upgrade key, the install process should detect it's an upgrade and simply ask for your CF6 license key. Andy On 23/10/2007, Jenny Gavin-Wear [EMAIL PROTECTED] wrote: Hi, I'm running CFMX 7 on a Windows 2003 Server - Standard Edition. I upgraded from MX 6 using the upgrade procedure during the MX7 install. After installing, I disabled MX6 in services. All has been running great for some months now, at least 6. My problem is that the jrun.exe process has suddenly started running at 98% plus. I recalled this was a problem with MX6 so I decided to uninstall MX6, as I'm no longer using it. This promptly removed my cfide directories :/ I then tried reinstalling CFMX7 assuming this would give me the CFIDE, at which point I got a message suggesting that for an upgrade, the CFMX6 needs to be intalled. So, I have two questions: 1. What could be causing Jrun to be running at 98%+ ? 2. Do I HAVE to have CFMX6 installed to run my upgrade edition of MX7? Many thanks, Jenny ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: installing CF 5 on Vista
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: Hi. I read the posts on installing CF 5 on Vista Any reason not to install on an older Windows box, maybe inside something like VMWare ? -- Tom Chiverton Helping to administratively fashion essential networks on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
I totally agree. I like to put code in stored procs for organisational reasons more than performance ones in most cases. However, I was recently updating a site that used dynamic SQL to generate some reports and the performance of this was becoming a huge issue. The logic was so complicated that approximately 1MB of SQL code was being sent to the SQL server (cfqueries within cfloops of other queries) - eek! In this instance I chose to rewrite the SQL from scratch (bad code was the biggest flaw) and also put each report into a stored procedure. The performance was an issue and the boost was huge. Dominic On 25/10/2007, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Yep, I think like with queryparam, you have to look outside of the performance benefits when working with stored procedures. The other benefits come when you have very complex queries that are accessed from several locations within an application, or multiple applications, this means not having to duplicate the query SQL code, it also helps with maintenance of the query down the line if needs be. There are probably performance benefits, but I'd imagine that if performance is a REAL concern to you, there are plenty of other places within your application where your time would be better spent optimizing, you'll likely get better performance benefits by considering things like caching of queries and objects and so on. Like the other guys have picked up on, the biggest performance on queries will come from good SQL code, you're best off spending some time in your database studio checking query performance times and looking at execution plans, playing with the SQL and table Indexing. Rob -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: 25 October 2007 09:50 To: CF-Talk Subject: Re: cfqueryparam and dynamically-created SQL I whole-heartedly agree and when I get some time I will do some testing. What I imagine to be the case is that the more complex the SQL required, the more likely it is that a stored procedure is beneficial but perhaps this is wrong (it is certainly blind assumption). Regardless of that, I like to contain all my data logic inside the database itself - feels clear in my head that way. Anyways, this is drifting off topic - just wanted to give an alternative to the OPs solution to his problem ;) Dom On 24/10/2007, Mark A Kruger [EMAIL PROTECTED] wrote: Dom, To know this you have to test. SPs are marginally faster in most cases - and just like cfqueries they have to be well written. There is not enough of a boost in performance (when comparing SPs to well written queries using cfqueryparam to bind the data) to make a hard and fast rule that SPs are best practice in all cases - that's my .02. Having said that, in a team enviornment there is some division of labor benefits. -Mark -- Blog it up: http://fusion.dominicwatson.co.uk ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Lock question
I have a flex app that uses a single cfc method to populate all of its drop down lists. The method is called getListData It runs 55 queries, and stores the results of those queries in a structure, and returns the structure to Flex. This works great, but it's a performance drag - especially if 10 or more people attempt to launch the application at the same time (like in training). I'm using shared objects to reduce the load on the server (the data is only retrieved once per day). But in an effort to improve performance, since the data being returned is the same for *ALL* users, I'm thinking of storing the whole structure in the application scope. I want to do locking on this so that only one thread can access the code within the getlistdata method at a time so I'm thinking of doing something like this. cffunction name=getlistdata .. cfset var retVal=structNew() cflock name=foo type=exclusive cfif isDefined(application.enquireListData) cfreturn application.enquireListData cfelse cfquery name=retVal.states... .../cfquery cfquery name=retVal.countries... .../cfquery cfquery name=retVal.etc... .../cfquery cfset application.enquireListData = retVal /cfif /cflock cfreturn retVal /cffunction So even if 10 peole access it at the same time, only the first one is going to get the lock.. the first one will run the queries and create the application variable, while the others wait for the lock to be released. The 50 queries only take about a second or two to run, so the wait for the lock won't be that long. Am I on the right track here? -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Lock question
Yeah, that sounds right. A refinement would be to only lock if the application data was not defined (so, test for it and return if it is defined) and, within the lock, to retest for it being defined (just as you have now). The test within the lock is to avoid a race condition where many clients hit at once before the data is loaded, and all of them hit the cflock and block. One of them wins the lock and loads the data, then each of the other clients gets the lock and can see that they have nothing to do. Thanks Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 8:33 AM To: CF-Talk Subject: Lock question I have a flex app that uses a single cfc method to populate all of its drop down lists. The method is called getListData It runs 55 queries, and stores the results of those queries in a structure, and returns the structure to Flex. This works great, but it's a performance drag - especially if 10 or more people attempt to launch the application at the same time (like in training). I'm using shared objects to reduce the load on the server (the data is only retrieved once per day). But in an effort to improve performance, since the data being returned is the same for *ALL* users, I'm thinking of storing the whole structure in the application scope. I want to do locking on this so that only one thread can access the code within the getlistdata method at a time so I'm thinking of doing something like this. cffunction name=getlistdata .. cfset var retVal=structNew() cflock name=foo type=exclusive cfif isDefined(application.enquireListData) cfreturn application.enquireListData cfelse cfquery name=retVal.states... .../cfquery cfquery name=retVal.countries... .../cfquery cfquery name=retVal.etc... .../cfquery cfset application.enquireListData = retVal /cfif /cflock cfreturn retVal /cffunction So even if 10 peole access it at the same time, only the first one is going to get the lock.. the first one will run the queries and create the application variable, while the others wait for the lock to be released. The 50 queries only take about a second or two to run, so the wait for the lock won't be that long. Am I on the right track here? -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Lock question
You could have a block of code inside of OnApplicationStart where all the query caching takes place, and put a cflock around that block of code, instead of altering all 55 queries. If the queries are cached OnApplicationStart, I would have high confidence that you wouldn't need to lock them when used in the site. The thing to watch out for is that you will need some code to refresh the cache, in case you want to change the content of the drop down list without waiting for a service restart. If someone loads a drop down list while you are refreshing the cache, then they could see a list that only has half the entries it should. The risk of this depends on how often you would have to update the cache while the site is being actively used. A list showing 50 states probably doesn't change much. Also, if you are running CF8, maybe this query loading code is a good chance to experiment with the cfthread tag, since I bet the queries are independent. -Mike Chabot On 10/25/07, Rick Root [EMAIL PROTECTED] wrote: I have a flex app that uses a single cfc method to populate all of its drop down lists. The method is called getListData It runs 55 queries, and stores the results of those queries in a structure, and returns the structure to Flex. This works great, but it's a performance drag - especially if 10 or more people attempt to launch the application at the same time (like in training). I'm using shared objects to reduce the load on the server (the data is only retrieved once per day). But in an effort to improve performance, since the data being returned is the same for *ALL* users, I'm thinking of storing the whole structure in the application scope. I want to do locking on this so that only one thread can access the code within the getlistdata method at a time so I'm thinking of doing something like this. cffunction name=getlistdata .. cfset var retVal=structNew() cflock name=foo type=exclusive cfif isDefined(application.enquireListData) cfreturn application.enquireListData cfelse cfquery name=retVal.states... .../cfquery cfquery name=retVal.countries... .../cfquery cfquery name=retVal.etc... .../cfquery cfset application.enquireListData = retVal /cfif /cflock cfreturn retVal /cffunction So even if 10 peole access it at the same time, only the first one is going to get the lock.. the first one will run the queries and create the application variable, while the others wait for the lock to be released. The 50 queries only take about a second or two to run, so the wait for the lock won't be that long. Am I on the right track here? -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Lock question
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: Yeah, that sounds right. You could add a call to wget (or whatever) the results to your server's start up script too. -- Tom Chiverton Helping to simultaneously conquer enterprise action-items on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Lock question
On 10/25/07, Gaulin, Mark [EMAIL PROTECTED] wrote: A refinement would be to only lock if the application data was not defined (so, test for it and return if it is defined) and, within the lock, to retest for it being defined (just as you have now). The test within the lock is to avoid a race condition where many clients hit at once before the data is loaded, and all of them hit the cflock and block. One of them wins the lock and loads the data, then each of the other clients gets the lock and can see that they have nothing to do. That makes sense... I think I'll do that and see how it goes. -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
odd caching issue
i'm having this really strange caching issue with my application on a cf8 vps... and it doesn't happen on my local at all. for some reason, portions of code that i've commented out entirely, still parse and show up in the browser... and when i put them back in, they actually duplicate in the browser. for example, you should not see any left menu or logo here, because all the code that is supposed to generate that is commented out: http://64.118.74.81/appDesign/index.cfm?m=stockbrokers if i put that code back in, the menu and logo literally will duplicate. i've made sure that cold fusion's caching is turned off... and am at a bit of a loss for what could be causing this. -jim ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 CFGRID bind problem on include
What does the AJAX debugging window say? It's nothing but INFO's It shows where the CFC is invoked and I see the recordset there. Something does strike me as odd though - The top line is: info: http: CFC invocation response: then it shows the HTML and CFMenu that go above the grid (are there from an include) followed by the contents of the recordset. Not sure if that is showing what it should or not. Like I said, I had this working when it was a single page with no includes. I use the Application.cfc onRequestStart and OnRequestEnd to include the header and footer files. Surely that wouldn't be affecting things? Hatton ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
error with long form post
Have you ever had a problem with a form post being too long? I am trying to post a form that uses fckeditor to post a large amount of rich text. 5000+ chars. I have also tried this with out fck editor and just a normal textarea and still get the problem. If the chars is small then the post works. I have read that different brioswers have url lenght limist, but this is in a form post so it shouldnt be in the url. Am I missing something that is making the form data end up in the url? I get a error that says url too long. this appears to be a browser error and not a cfm or web server error. I increased the limit in the cf admin to 1000 MB per post and still had the same error. (I set that back to a lower amount after testing) The setup/environment: I am using the post method in the form, cfserver 7.02 enterprise, windows server 2000, have tried it with IE6 and the latest firefox. IE wont even submit the form, and firefox gives the error. Also using a standard submit buttton, and have tried with a button calling the submit via javascript After the post with a smaller amount of data all the data is in the url of the address bar. Is there a way to block that so the form post isnt in the url? I havent had this problem before. Any feedback would be great Thanks Greg ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How should SQL handle same named columns from different tables?
You'll have to reference them as alias.columnname or select them with a different alias like... Select a.userID as AuserID, b.userID as BuserID I would say that they are the same in most cases though yes? If so, there's no need to select both at all. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 2:03 PM To: CF-Talk Subject: How should SQL handle same named columns from different tables? SELECT a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid WHERE username = 'bsmith' In the query there's a common column named 'userid'. Should the query retun 1) one column named userid 2) two columns named userid 3) two columns with some type of unique name for each I find that the CF8 'Microsoft Access with Unicode' driver does #3, which I hadn't seen before in other ODBC drivers. It returns two columns named 'a.userid' and 'b.userid'. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: error with long form post
Greg, Make sure your form method is set as POST and not GET. You may have just inadvertantly set it this way (as I think some editors insert the GET as a default. Dean On 10/25/07, Greg benson [EMAIL PROTECTED] wrote: Have you ever had a problem with a form post being too long? I am trying to post a form that uses fckeditor to post a large amount of rich text. 5000+ chars. I have also tried this with out fck editor and just a normal textarea and still get the problem. If the chars is small then the post works. I have read that different brioswers have url lenght limist, but this is in a form post so it shouldnt be in the url. Am I missing something that is making the form data end up in the url? I get a error that says url too long. this appears to be a browser error and not a cfm or web server error. I increased the limit in the cf admin to 1000 MB per post and still had the same error. (I set that back to a lower amount after testing) The setup/environment: I am using the post method in the form, cfserver 7.02 enterprise, windows server 2000, have tried it with IE6 and the latest firefox. IE wont even submit the form, and firefox gives the error. Also using a standard submit buttton, and have tried with a button calling the submit via javascript After the post with a smaller amount of data all the data is in the url of the address bar. Is there a way to block that so the form post isnt in the url? I havent had this problem before. Any feedback would be great Thanks Greg -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: odd caching issue
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: if i put that code back in, the menu and logo literally will duplicate. How are you editing/uploading changes ? -- Tom Chiverton Helping to confidentially unleash leading-edge e-services on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 CFGRID bind problem on include
Not sure if that is showing what it should or not. Like I said, I had this working when it was a single page with no includes. I use the Application.cfc onRequestStart and OnRequestEnd to include the header and footer files. Surely that wouldn't be affecting things? Apparently it does affect things! I moved the layout CFINCLUDE tags out of the onRequestStart and onRequestEnd and put them in the CFM page itself and things started working again. This is acceptable in this instance but does not make a whole lot of sense. What it says to me is that the HTML being generated by other CFC's interferes with the data being returned by CFC's referenced for the BIND attribute. Has this been addressed? Hatton ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with login in the Application.cfc (saving additional info in the session scope)
hi, I have a bit of a problem, and I know that happens sometimes when the sessi= on expires (and may be have something to do with the application expiration= ). OK this is it: Every time I authenticate an user (this is made by an object created in the= session scope) I create a struct that contains all the user information. T= his struct resides in the session scope and should be available while the s= ession is active. When the user logout I delete this struct. Everything wor= ks fine, but some times when the session expires and the user re-login, the= server do not run the authentication neither the login part of my code. So= I ended without my struct and with a logged in user. This is my simplified Application.cfc, I do not know what I am missing: cfcomponent displayname =Application !--- Atributes --- cfscript this.loging = true; this.name = APP; this.Sessionmanagement = true; this.Sessiontimeout = #createtimespan(0,0,1,0)#; this.applicationtimeout = #createtimespan(0,1,0,0)#; this.loginstorage = session; /cfscript !--- onApplicationStart --- cffunction name =onApplicationStart cfif this.loging cflog file =#This.Name# type =Information text =Started / /cfif cfscript application.sessions = 0; /cfscript /cffunction !--- onApplicationEnd --- cffunction name =onApplicationEnd cfargument name =ApplicationScope required =true / cfif this.loging cflog file =#this.Name# type =Information text =#ApplicationScope.applicationname# Ended / /cfif /cffunction !--- onRequestStart --- cffunction name =onRequestStart cfparam name =act default =0 !--- If we want to logout --- cfif act is logout cfset clearSession() cflogout /cfif !--- the user is not login --- cflogin cfif NOT IsDefined(cflogin) !--- the action of the login form point to index.cfm --- cfinclude template =login_form.cfm / cfabort !--- Validate --- cfelse !--- object that autenticates the user --- !--- this object also creates a session struct session.userInfo with aditional user info --- cfset roles=session.security.login(cflogin.name,cflogin.password) !--- If the user has any role --- cfif roles is not NONE cfloginuser name=#cflogin.name# Password = #cflogin.password# roles =#roles# --- the times that I have the error the user is loged in by ColdFusion but this test code is not executed --- cfdump var =#session# !--- This is not a valid user --- cfelse !--- the action of the login form points to index.cfm --- cfinclude template =login_form.cfm / cfabort /cfif /cfif /cflogin !--- here is the problem and this is the solution that I made 'but I do not like it' --- !--- sometimes I get here and the struct dose not exist --- cfif NOT isDefined(session.userInfo) cfset session.security.load_user() /cfif cfset this.start =now() /cffunction !--- onRequest --- cffunction name =onRequest cfargument name =targetPage type =String required =true / !--- This is a minimal example of an onRequest filter. --- cfsavecontent variable =content cfinclude template =#ARGUMENTS.TargetPage# / /cfsavecontent cfoutput #content# /cfoutput /cffunction !--- onSessionStart --- cffunction name =onSessionStart cfscript session.started = now(); clearSession(); /cfscript !--- Create the security object --- cfobject component =#application.core#.aspects.Security name =session.security type =component / cflock timeout =5 throwontimeout =no type =exclusive scope=application cfset application.sessions = application.sessions + 1 / /cflock cfif this.loging cflog file =#this.Name# type =Information text =Session: #Session.sessionid# started / /cfif /cffunction !--- onSessionEnd --- cffunction name =onSessionEnd cfargument name = SessionScope required =true / cfif this.loging cflog file =#this.Name# type =Information text =Session: #arguments.SessionScope.sessionid# ended / /cfif /cffunction !--- - PRIVATE FUNCTIONS -- --- !--- Clear Session ---
Dual CORE/Quad for CF8
If I am going to run a Web/.NET/CF8 server, will these applications take advantage of dual or quad core processers? Rick Colman ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 and CFDUMP was: (Re: Coldspring error)
You can dump the bean factory itself just fine (or at least I can). It's when you try to call getClass() on it that it won't work. Something inside CFDUMP is trying to call getClass() on the bean factory. Why, I have no idea, but it is, and that's why it's blowing up. If Mike can dump it fine on his local machine, I still think we're back to some kind of configuration issue on the host. On 10/25/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: cfdump var=#beanfactory# / I cfdump'ed our application.beanfactory just yesterday, on CF7 on our own servers. It's 'normally' fine. -- Tom Chiverton Helping to heterogeneously maximize bricks-and-clicks data on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: error with long form post
Greg, Can you post the actual error message that you are receiving? Also, what are you doing with the post? Are you placing it into a database? Is that database column setup for text fields of this size? William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Greg benson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 6:48 AM To: CF-Talk Subject: error with long form post Have you ever had a problem with a form post being too long? I am trying to post a form that uses fckeditor to post a large amount of rich text. 5000+ chars. I have also tried this with out fck editor and just a normal textarea and still get the problem. If the chars is small then the post works. I have read that different brioswers have url lenght limist, but this is in a form post so it shouldnt be in the url. Am I missing something that is making the form data end up in the url? I get a error that says url too long. this appears to be a browser error and not a cfm or web server error. I increased the limit in the cf admin to 1000 MB per post and still had the same error. (I set that back to a lower amount after testing) The setup/environment: I am using the post method in the form, cfserver 7.02 enterprise, windows server 2000, have tried it with IE6 and the latest firefox. IE wont even submit the form, and firefox gives the error. Also using a standard submit buttton, and have tried with a button calling the submit via javascript After the post with a smaller amount of data all the data is in the url of the address bar. Is there a way to block that so the form post isnt in the url? I havent had this problem before. Any feedback would be great Thanks Greg ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SeeFusion vs. FusionReactor
Even with that change to the licensing, that still costs more than Fusion Reactor when you have 6 CF instances on one box. 1 Fusion Reactor License or 3 SeeFusion licenses. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 3:10 PM To: CF-Talk Subject: RE: SeeFusion vs. FusionReactor Actually, the SeeFusion pricing is a little different then that. http://www.seefusion.com/index.cfm?do=c.whatsnew The last item on this page details their 2 for 1 pricing model. == New 2-for-1 pricing model for individual servers For any single physical server, every 2 ColdFusion instances that you want to monitor now require just 1 SeeFusion license. So for a server with 4 ColdFusion instances that you want to monitor, you'd need 2 SeeFusion licenses. Or, for 2 physical servers each with 2 ColdFusion instances you want to monitor, you'd also still only need 2 SeeFusion licenses. == ~Brad A SeeFusion license had to be purchased for each instance of ColdFusion running on the server. Whereas, one FusionReactor license was used per server (not instance). ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using ColdFusion to determine if user has Flash player?
I know that I can use javascript to get those values, but I'm writing a browser detection suite and I'd love to get as much as possible using server-side code. I already have about half of what I need (cookies, timestamp, browser/version, operating system), but Flash is one of the last pieces I'd really like to get with SS code. Anyway, my goal was to still get as many of these values as I can if a person had JS disabled. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 4:53 PM To: CF-Talk Subject: Using ColdFusion to determine if user has Flash player? Anyone know if this is possible through whatever means? My company currently uses Browserhawk to detect this, but we'd like to do away with BH (and the cost). Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 and CFDUMP was: (Re: Coldspring error)
Mikes' local machine is CF7 and the host is CF8. On 10/25/07, Brian Kotek [EMAIL PROTECTED] wrote: You can dump the bean factory itself just fine (or at least I can). It's when you try to call getClass() on it that it won't work. Something inside CFDUMP is trying to call getClass() on the bean factory. Why, I have no idea, but it is, and that's why it's blowing up. If Mike can dump it fine on his local machine, I still think we're back to some kind of configuration issue on the host. On 10/25/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: cfdump var=#beanfactory# / I cfdump'ed our application.beanfactory just yesterday, on CF7 on our own servers. It's 'normally' fine. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using ColdFusion to determine if user has Flash player?
Andy, Because you are talking about 2 different sides of the 'firewall' Client and Server. You will be restricted to what the browser sent as it's 'identifier' message. I have not looked to see if the user can customize their browser to identify which flash version that they have when they call your web pages, however, the default settings do not report this information. Since this information is not reported by the initial web page call, the only way to 'successfully' get this information sent is to wait for the second web page call, where you would instruct your code to send a form/url/cookie variable back with the new page request identifying the browser's flash capabilities. You could accomplish this with a 'landing page'. This is an 'initial' page that is sent to the user and the user much 'click' on an element or wait a pre-determined number of seconds for the page to reload to the actual application. You could have the 'click' send a form post. You could have the 'load' to create a javascript cookie. And you could have a javascript or meta 'refresh' occur after a number of seconds. As 'dirty' as this sounds, and is, it would give your application more information about the user's environment. You 'could' mask the page as a 'loading' page and have a flash or animated gif showing some 'loading' script, while the background is collecting the browser data that you need and shuttling it back to the Server. Just an idea, William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 8:02 AM To: CF-Talk Subject: RE: Using ColdFusion to determine if user has Flash player? I know that I can use javascript to get those values, but I'm writing a browser detection suite and I'd love to get as much as possible using server-side code. I already have about half of what I need (cookies, timestamp, browser/version, operating system), but Flash is one of the last pieces I'd really like to get with SS code. Anyway, my goal was to still get as many of these values as I can if a person had JS disabled. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: error with long form post
Is your form action set to GET (or not defined) instead of set to POST? If you're getting a URL too long error it sounds like your form data/text is being passed in the URL string. Jon On Oct 25, 2007, at 11:00 AM, William Seiter wrote: I get a error that says url too long. this appears to be a browser error and not a cfm or web server error. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: weird message on logs (CF8)
If it *is* high traffic at all, storing data in the registry could really bork your server. The windows registry does have a size limit, I would set it to cookie (if you are storing only non-secure data that is small) or database if you have a zippy one available. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 11:25 AM To: CF-Talk Subject: Re: weird message on logs (CF8) These error messages are being generated when Coldfusion writes the client data to the Windows Registry - a setting which is adjusted in the Client Variables section of the CF Administrator. It could be a permissions issue with Coldfusion writing to the Registry. I did a search for this specific error and couldn't find anything conclusive. If you're running the developer edition, I would assume there aren't a ton of requests on the server so it probably isn't something to worry about. On production servers, it's a good idea set your client storage to Cookies or create a client storage database and use that - assuming your application isn't high traffic with a large number of concurrent requests to the database. HTH, Jon On Oct 23, 2007, at 12:09 PM, João_Fernandes wrote: Has anyone notice weird messages in their logs for CF8? I have some entries like this HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\77908-41216193: Windows error 0 occurred.The operation completed successfully. 10/22 23:26:51 Information [scheduler-0] - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\77909-83396251: Windows error 0 occurred.The operation completed successfully. 10/22 23:26:51 Information [scheduler-0] - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\7791-52723081: Windows error 0 occurred.The operation completed successfully. 10/22 23:26:51 Information [scheduler-0] - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\7791-a6c17dfcd6cd280d-328f67c8-1279-d050-4e5bcef42995e6dd: Windows error 0 occurred.The operation completed successfully. I don't know what have changed but it seems it started to happen when trial reverted to Developer version. It happens to all our CF instances. Any ideas? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SeeFusion vs. FusionReactor
Regardless, I currently have one instance on one server. So licensing structure isn't a big deal. --Ben Doom DURETTE, STEVEN J (ATTASIAIT) wrote: Even with that change to the licensing, that still costs more than Fusion Reactor when you have 6 CF instances on one box. 1 Fusion Reactor License or 3 SeeFusion licenses. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 3:10 PM To: CF-Talk Subject: RE: SeeFusion vs. FusionReactor Actually, the SeeFusion pricing is a little different then that. http://www.seefusion.com/index.cfm?do=c.whatsnew The last item on this page details their 2 for 1 pricing model. == New 2-for-1 pricing model for individual servers For any single physical server, every 2 ColdFusion instances that you want to monitor now require just 1 SeeFusion license. So for a server with 4 ColdFusion instances that you want to monitor, you'd need 2 SeeFusion licenses. Or, for 2 physical servers each with 2 ColdFusion instances you want to monitor, you'd also still only need 2 SeeFusion licenses. == ~Brad A SeeFusion license had to be purchased for each instance of ColdFusion running on the server. Whereas, one FusionReactor license was used per server (not instance). ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: weird message on logs (CF8)
These error messages are being generated when Coldfusion writes the client data to the Windows Registry - a setting which is adjusted in the Client Variables section of the CF Administrator. It could be a permissions issue with Coldfusion writing to the Registry. I did a search for this specific error and couldn't find anything conclusive. If you're running the developer edition, I would assume there aren't a ton of requests on the server so it probably isn't something to worry about. On production servers, it's a good idea set your client storage to Cookies or create a client storage database and use that - assuming your application isn't high traffic with a large number of concurrent requests to the database. HTH, Jon On Oct 23, 2007, at 12:09 PM, João_Fernandes wrote: Has anyone notice weird messages in their logs for CF8? I have some entries like this HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\77908-41216193: Windows error 0 occurred.The operation completed successfully. 10/22 23:26:51 Information [scheduler-0] - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\77909-83396251: Windows error 0 occurred.The operation completed successfully. 10/22 23:26:51 Information [scheduler-0] - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\7791-52723081: Windows error 0 occurred.The operation completed successfully. 10/22 23:26:51 Information [scheduler-0] - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion \Clients\7791-a6c17dfcd6cd280d-328f67c8-1279-d050-4e5bcef42995e6dd: Windows error 0 occurred.The operation completed successfully. I don't know what have changed but it seems it started to happen when trial reverted to Developer version. It happens to all our CF instances. Any ideas? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with login in the Application.cfc (saving additional info in the session scope)
Placing the following in the onSessionEnd method should solve the problem: cfif getAuthUser() NEQ cflogout/ /cfif Option B is to persist some cookie data which will re-login the user when the session ends. As a side note, you can also use the cflogin name to create a list. The you can use the getAuthUser() as a list and use that list to recreate the session structure: cflogin cfloginuser name=#arguments.userid#,#arguments.username#... The you would use listFirst(getAuthUser()) to pull the userID and regenerate the user's session structure when it does not exist. HTH, Jon On Oct 25, 2007, at 11:14 AM, Adalberto Gallardo wrote: hi, I have a bit of a problem, and I know that happens sometimes when the sessi= on expires (and may be have something to do with the application expiration= ). OK this is it: Every time I authenticate an user (this is made by an object created in the= session scope) I create a struct that contains all the user information. T= his struct resides in the session scope and should be available while the s= ession is active. When the user logout I delete this struct. Everything wor= ks fine, but some times when the session expires and the user re- login, the= server do not run the authentication neither the login part of my code. So= I ended without my struct and with a logged in user. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dual CORE/Quad for CF8
Yes, they will. IIS and CF are fully multi-threaded. Any web or database server that takes multiple simultaneous requests will certainly take advantage of more than one CPU, even if the CPUs are hardwired together. -- nathan strutz http://www.dopefly.com/ On 10/25/07, Richard Colman [EMAIL PROTECTED] wrote: If I am going to run a Web/.NET/CF8 server, will these applications take advantage of dual or quad core processers? Rick Colman ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam and dynamically-created SQL
1. I believe stored procs are generally faster than sending the same query to SQL Server due to query optimisation(?) The only query optimization that goes on is the building of an execution plan. Using conditional logic in a stored procedure can have very harmful effects on the reusability of an execution plan. I'd rather have multiple queries, each with its own optimal execution plan, than one stored procedure with a potentially suboptimal execution plan. 2. Less data is being sent to the SQL server In most cases, this is trivial. 3. Less CF application process before the code is run on the SQL server weighed against more SQL application process after the code is run on your CF server. Would you think otherwise? I think it's very dangerous to attempt predictions of performance based on what feels right to us, as we often do. Very often, in my experience, load testing tends to overturn those predictions. 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! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFZIP and CFINDEX
That's not what I see here. I used cfzip to create a zip. I included the zip in a collection. When I searched against the collection, Verity found a match in my zip. I had problems indexing zip files with Verity in the past; I shouldn't have assumed they were never fixed. 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! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using ColdFusion to determine if user has Flash player?
Another method is to have a flash movie on your first page that redirects users to a second page...if it doesn't redirect them, then flash isn't running. - Christopher Vigliotti Sr. ColdFusion Developer AboutWeb LLC http://www.aboutweb.com On 10/25/07, William Seiter [EMAIL PROTECTED] wrote: Andy, Because you are talking about 2 different sides of the 'firewall' Client and Server. You will be restricted to what the browser sent as it's 'identifier' message. I have not looked to see if the user can customize their browser to identify which flash version that they have when they call your web pages, however, the default settings do not report this information. Since this information is not reported by the initial web page call, the only way to 'successfully' get this information sent is to wait for the second web page call, where you would instruct your code to send a form/url/cookie variable back with the new page request identifying the browser's flash capabilities. You could accomplish this with a 'landing page'. This is an 'initial' page that is sent to the user and the user much 'click' on an element or wait a pre-determined number of seconds for the page to reload to the actual application. You could have the 'click' send a form post. You could have the 'load' to create a javascript cookie. And you could have a javascript or meta 'refresh' occur after a number of seconds. As 'dirty' as this sounds, and is, it would give your application more information about the user's environment. You 'could' mask the page as a 'loading' page and have a flash or animated gif showing some 'loading' script, while the background is collecting the browser data that you need and shuttling it back to the Server. Just an idea, William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 8:02 AM To: CF-Talk Subject: RE: Using ColdFusion to determine if user has Flash player? I know that I can use javascript to get those values, but I'm writing a browser detection suite and I'd love to get as much as possible using server-side code. I already have about half of what I need (cookies, timestamp, browser/version, operating system), but Flash is one of the last pieces I'd really like to get with SS code. Anyway, my goal was to still get as many of these values as I can if a person had JS disabled. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: installing CF 5 on Vista
If you get CF 5 working directly in Vista please post a how-to guide! VMWare running an older OS is going to be much easier for you. - Christopher Vigliotti Sr. ColdFusion Developer AboutWeb, LLC http://www.aboutweb.com On 10/25/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: Hi. I read the posts on installing CF 5 on Vista Any reason not to install on an older Windows box, maybe inside something like VMWare ? -- Tom Chiverton Helping to administratively fashion essential networks on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFZIP and CFINDEX
One thing to not forget (I'm sure you know this), in CF7, Adobe did a major update of the embedded Verity engine, so it would surprise me if it didn't work in the past. On 10/25/07, Dave Watts [EMAIL PROTECTED] wrote: That's not what I see here. I used cfzip to create a zip. I included the zip in a collection. When I searched against the collection, Verity found a match in my zip. I had problems indexing zip files with Verity in the past; I shouldn't have assumed they were never fixed. 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How should SQL handle same named columns from different tables?
From: Kris Jones In general, it is up to the developer to alias the columns so that they can be referenced appropriately in such a scenario. I also am not a fan of the * in queries. And, I wonder, in the example you have given, why this is an issue, since the values for the columns will be exactly the same? It's not a matter of the values, but the column names. Moving an application from a CF5 server using Microsoft ODBC drivers to a CF8 server, I found that this 'Access with Unicode' driver behaves differently than the ODBC driver that had been used previously, and also differently from the other Access driver included with CF8. The application expects to have a column named 'userid' returned in the query, but it doesn't exist. I'd never run into the issue before trying to use this particular Access driver, so wasn't aware that doing this could cause confusion. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: odd caching issue
ftp. it turns out that my footer became my header. really odd, because my local copy was correct, but the remote copy had all my header code in it. no idea how that happened. -jim On 10/25/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: if i put that code back in, the menu and logo literally will duplicate. How are you editing/uploading changes ? -- Tom Chiverton Helping to confidentially unleash leading-edge e-services on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How should SQL handle same named columns from different tables?
I get it now. Yes, indeed, how weird. Do you have to use the Unicode driver? Does that make a difference? It's not a matter of the values, but the column names. Moving an application from a CF5 server using Microsoft ODBC drivers to a CF8 server, I found that this 'Access with Unicode' driver behaves differently than the ODBC driver that had been used previously, and also differently from the other Access driver included with CF8. The application expects to have a column named 'userid' returned in the query, but it doesn't exist. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dual CORE/Quad for CF8
I installed CF8/IIS/2003 R2 on a dual quad core setup with 16GB of RAM just for $h!ts and giggles... CF flies on it. Too bad the system is for my SQL server... -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 7:41 AM To: CF-Talk Subject: Dual CORE/Quad for CF8 If I am going to run a Web/.NET/CF8 server, will these applications take advantage of dual or quad core processers? Rick Colman ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
I want to re-authenticate the user
The problem is not when the session ends, but when the user enters again to the system after his(her) session ended. The applications shows the login template, the user enter the user name and password and the application (I do not know how) authenticates the user and let him(her) to enter without running my: cfset roles=session.security.login(cflogin.name,cflogin.password) Nor my: cfloginuser name=#cflogin.name# Password=#cflogin.password# roles =#roles# And that is why I end up with a loged in user without my âsession.userInfoâ variable. I already try loging out the user in the onSessionEnd but it did not work either. My solution works but I want to know why is this happening, and why sometimes its authenticates and sometimes not. hi, I have a bit of a problem, and I know that happens sometimes when the sessi= on expires (and may be have something to do with the application expiration= ). OK this is it: Every time I authenticate an user (this is made by an object created in the= session scope) I create a struct that contains all the user information. T= his struct resides in the session scope and should be available while the s= ession is active. When the user logout I delete this struct. Everything wor= ks fine, but some times when the session expires and the user re-login, the= server do not run the authentication neither the login part of my code. So= I ended without my struct and with a logged in user. This is my simplified Application.cfc, I do not know what I am missing: cfcomponent displayname =Application !--- Atributes --- cfscript this.loging = true; this.name = APP; this.Sessionmanagement = true; this.Sessiontimeout = #createtimespan(0,0,1,0)#; this.applicationtimeout = #createtimespan(0,1,0,0)#; this.loginstorage = session; /cfscript !--- onApplicationStart --- cffunction name =onApplicationStart cfif this.loging cflog file =#This.Name# type =Information text =Started / /cfif cfscript application.sessions = 0; /cfscript /cffunction !--- onApplicationEnd --- cffunction name =onApplicationEnd cfargument name =ApplicationScope required =true / cfif this.loging cflog file =#this.Name# type =Information text =#ApplicationScope.applicationname# Ended / /cfif /cffunction !--- onRequestStart --- cffunction name =onRequestStart cfparam name =act default =0 !--- If we want to logout --- cfif act is logout cfset clearSession() cflogout /cfif !--- the user is not login --- cflogin cfif NOT IsDefined(cflogin) !--- the action of the login form point to index.cfm --- cfinclude template =login_form.cfm / cfabort !--- Validate --- cfelse !--- object that autenticates the user --- !--- this object also creates a session struct session.userInfo with aditional user info --- cfset roles=session.security.login(cflogin.name,cflogin.password) !--- If the user has any role --- cfif roles is not NONE cfloginuser name=#cflogin.name# Password = #cflogin.password# roles =#roles# --- the times that I have the error the user is loged in by ColdFusion but this test code is not executed --- cfdump var =#session# !--- This is not a valid user --- cfelse !--- the action of the login form points to index.cfm --- cfinclude template =login_form.cfm / cfabort /cfif /cfif /cflogin !--- here is the problem and this is the solution that I made 'but I do not like it' --- !--- sometimes I get here and the struct dose not exist --- cfif NOT isDefined(session.userInfo) cfset session.security.load_user() /cfif cfset this.start =now() /cffunction !--- onRequest --- cffunction name =onRequest cfargument name =targetPage type =String required =true / !--- This is a minimal example of an onRequest filter. --- cfsavecontent variable =content cfinclude template =#ARGUMENTS.TargetPage# / /cfsavecontent cfoutput #content# /cfoutput /cffunction !--- onSessionStart --- cffunction name =onSessionStart cfscript session.started = now(); clearSession(); /cfscript !--- Create the security object --- cfobject component =#application.core#.aspects.Security name =session.security type =component / cflock timeout =5 throwontimeout =no type =exclusive
Doctor's appt on Monday
Hey Aaron... Just wanted to let you know in advance that I have a Drs. appt on Monday at 9am. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Doctor's appt on Monday
That's good to know, Andy. I hope everything is okay. did you intend to send that to the entire CF-Talk list? ;o) Chris On 10/25/07, Andy Matthews [EMAIL PROTECTED] wrote: Hey Aaron... Just wanted to let you know in advance that I have a Drs. appt on Monday at 9am. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Doctor's appt on Monday
Just a minor procedure guysa little back hair removal. Strictly outpatient. -Original Message- From: Chris Jordan [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 3:05 PM To: CF-Talk Subject: Re: Doctor's appt on Monday That's good to know, Andy. I hope everything is okay. did you intend to send that to the entire CF-Talk list? ;o) Chris On 10/25/07, Andy Matthews [EMAIL PROTECTED] wrote: Hey Aaron... Just wanted to let you know in advance that I have a Drs. appt on Monday at 9am. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Doctor's appt on Monday
This thread has been deleted. Please do not reply to it. Thank you. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Deleting Attachments Immediately After CFMAIL
Is there any way to safely delete files that were attached using a cfmailparam tag to an email that was generated with the cfmail tag? If you delete the attached file too soon, then the file doesn't get attached to the email, at best, and at worst, the email fails altogether. cfmail to=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=See Attachment cfmailparam file=#theFullFilePath# See attached file, #GetFileFromPath(theFullFilePath)# /cfmail cffile action=delete file=#theFullFilePath# I know for a fact that this worked just fine in CF 5, because the contents of the attached file would be included as a base64 string in the .mail file that was written to the spool. In the MX versions of CF, only path of the attached file is put in the .mail file, meaning the attached file had to stick around until the .mail file in the spool could be processed. It seems like a significant feature digression, but I have found zero documentation on this from Adobe. It is quite a hindrance if you are attaching (gasp) dynamically generated files to emails to create an entire separate process to manually clean up the files from the file system. Does anybody know how attachments work in CF 8? I haven't tried it yet, and I would be curious if it works the same as CF 7. Has anyone heard of future plans by Adobe to allow attached files to be automatically deleted after the spool file has been processed. Maybe something similar to the cfcontent tag? cfmailparam file=#theFullFilePath# delete=yes And finally, has anyone ever tried to somehow force the contents of the file into the body of the email so it is indeed written to the spool file? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL Stored Procedure Help!
Hey, I have posted a couple of times on getting a hierarchal tree 22 levels deep programmed for an MLM company. My original coding was using too much memory, as I was more or less creating a FILO type structure with several arrays. I have looked over the various methods for displaying hierarchal data with MySql, and there don't really seem to be many elegant solutions-- the best method (according to many) seemed to be creating a column for lft rgt values as a nested tree structure, which is completely impractical in this situation because I would have to re-assign those variable every single time somebody inserted a record into my database (which should be many times/day). The best method I have found (I think...) is to create a temporary FILO stack table using a stored procedure. I found the syntax here: http://www.evolt.org/node/4047 however, I know basically nothing about proper syntax for stored procedures, and have really not found a lot that has helped. Why, oh, why is this syntax giving me errors? (other than the obvious change the variables to match those in my database). I'm using navicat 8 for mysql for my database interactions, dunno if that could be the cause or not... Equally as important, does this method of creating a temp table seem like an appropriate solution to my problem? Will this method even work if I have several people wanting to access their genealogy at the same time? Sigh... I feel so over my head... thanks for the help, regardless=). ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
PAYPAL PRO CFC
I need someone who has working knowledge of PAYPAL PRO and PAYPAL's CFC code. If you do please contact me at 570-686-2300 or [EMAIL PROTECTED] ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Deleting Attachments Immediately After CFMAIL
Nathan, Is there any way to safely delete files that were attached using a cfmailparam tag to an email that was generated with the cfmail tag? If you delete the attached file too soon, then the file doesn't get attached to the email, at best, and at worst, the email fails altogether. cfmail to=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=See Attachment cfmailparam file=#theFullFilePath# See attached file, #GetFileFromPath(theFullFilePath)# /cfmail cffile action=delete file=#theFullFilePath# I know for a fact that this worked just fine in CF 5, because the contents of the attached file would be included as a base64 string in the .mail file that was written to the spool. In the MX versions of CF, only path of the attached file is put in the .mail file, meaning the attached file had to stick around until the .mail file in the spool could be processed. It seems like a significant feature digression, but I have found zero documentation on this from Adobe. It is quite a hindrance if you are attaching (gasp) dynamically generated files to emails to create an entire separate process to manually clean up the files from the file system. Adobe did this to speed up mass e-mailings that all use a common set of attachments--which is common when doing bulk mailings. Obviously in this case there's considerably less disk space used and does speed things up. However, when you're trying to send dynamically generated content it's a real PITA. Here's a blog entry I wrote a while back which shows how the JavaMail API can be used directly to send SMTP without needing to write attachments to disk: http://blog.pengoworks.com/blogger/index.cfm?action=blog:584 There's also this blog entry over at Charlie Arehart's site which discusses some alternatives (see the comments): http://carehart.org/blog/client/index.cfm/2007/1/13/cfdocument_name_attribut e -Dan ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Best regex for this, getting software version numbers
I have these strings: Firefox 2.0.0.8 (Firefox 2.0) Internet Explorer 7.0 (Internet Explorer 7.0) Googlebot 2.1 (Googlebot 2.1) Yahoo! Slurp (Yahoo! Slurp) etc. I'd like to grab everything up to a second period (if it exists). What I want is in parens next to each string. Anyone have any ideas? Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deleting Attachments Immediately After CFMAIL
Without having tried it, the first thing that springs to mind is to turn off mail spooling. In theory, attaching files should not be that much of a bother. I think you have to add a header specifying filename, MIME header, etc., and you have to add the file as a base-64 encoded block at the end of the email. Others (Jochem -- I'm looking at you!) could probably advise better about this. HTH --Ben Doom Nathan Wells wrote: Is there any way to safely delete files that were attached using a cfmailparam tag to an email that was generated with the cfmail tag? If you delete the attached file too soon, then the file doesn't get attached to the email, at best, and at worst, the email fails altogether. cfmail to=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=See Attachment cfmailparam file=#theFullFilePath# See attached file, #GetFileFromPath(theFullFilePath)# /cfmail cffile action=delete file=#theFullFilePath# I know for a fact that this worked just fine in CF 5, because the contents of the attached file would be included as a base64 string in the .mail file that was written to the spool. In the MX versions of CF, only path of the attached file is put in the .mail file, meaning the attached file had to stick around until the .mail file in the spool could be processed. It seems like a significant feature digression, but I have found zero documentation on this from Adobe. It is quite a hindrance if you are attaching (gasp) dynamically generated files to emails to create an entire separate process to manually clean up the files from the file system. Does anybody know how attachments work in CF 8? I haven't tried it yet, and I would be curious if it works the same as CF 7. Has anyone heard of future plans by Adobe to allow attached files to be automatically deleted after the spool file has been processed. Maybe something similar to the cfcontent tag? cfmailparam file=#theFullFilePath# delete=yes And finally, has anyone ever tried to somehow force the contents of the file into the body of the email so it is indeed written to the spool file? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best regex for this, getting software version numbers
Without testingL ^.*?($|\d+\.\d+) Which is, basically, beginning of string, shortest possible string, (end of string or digits dot digits). --Ben Doom Andy Matthews wrote: I have these strings: Firefox 2.0.0.8 (Firefox 2.0) Internet Explorer 7.0 (Internet Explorer 7.0) Googlebot 2.1 (Googlebot 2.1) Yahoo! Slurp (Yahoo! Slurp) etc. I'd like to grab everything up to a second period (if it exists). What I want is in parens next to each string. Anyone have any ideas? Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Best regex for this, getting software version numbers
I came up with this: ([a-zA-Z0-9 !]+).?([a-zA-Z0-9]+) Is there a better way to do this? -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 4:27 PM To: CF-Talk Subject: Best regex for this, getting software version numbers I have these strings: Firefox 2.0.0.8 (Firefox 2.0) Internet Explorer 7.0 (Internet Explorer 7.0) Googlebot 2.1 (Googlebot 2.1) Yahoo! Slurp (Yahoo! Slurp) etc. I'd like to grab everything up to a second period (if it exists). What I want is in parens next to each string. Anyone have any ideas? Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFQueryParam apostrophe problem when using SET NOCOUNT
All: I've stumbled onto a strange problem that I'm hoping someone can help out with. I've built a standard CRUD setup, using CFQueryParam tags on the backend. For this particular situation, after adding an item to the database, I need to retrieve the itemID. So, I've setup the query along the following lines: CFQUERY SET NOCOUNT ON [Actual SQL code with CFQueryParam tags] SELECT ThisID = @@Identity SET NOCOUNT OFF /CFQUERY With this setup, what I noticed was, when I insert an item, any apostrophes get stripped from string values. However, when I update the item, the apostrophes stayed put. Additionally, when I removed everything but the actual SQL/CFQueryParam code from the insert query, the apostrophes worked fine. So, my assumption is that the SET NOCOUNT is causing the problem for some reason. I found that earlier versions of CF had a similar problem in that apostrophes were stripped when using a CFQueryParam tag (no SET NOCOUNT required). However, hotfixes were issued as far back as CFMX and, I'm assuming, that problem has been resolved. Does anyone have any additional information or ideas for fixing this problem? Adobe's knowledge base doesn't seem to have anything about it. And I realize that I can work around it but I'd rather not kludge up the code if possible. TIA -- Mosh Teitelbaum evoch, LLC WWW: http://www.evoch.com/ ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQueryParam apostrophe problem when using SET NOCOUNT
With this setup, what I noticed was, when I insert an item, any apostrophes get stripped from string values. However, when I update the item, the apostrophes stayed put. Additionally, when I removed everything but the actual SQL/CFQueryParam code from the insert query, the apostrophes worked fine. So, my assumption is that the SET NOCOUNT is causing the problem for some reason. Why do you have SET NOCOUNT in the first place? 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! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Deleting Attachments Immediately After CFMAIL
Nathan, Adobe did this to speed up mass e-mailings that all use a common set of attachments--which is common when doing bulk mailings. Obviously in this case there's considerably less disk space used and does speed things up. However, when you're trying to send dynamically generated content it's a real PITA. Here's a blog entry I wrote a while back which shows how the JavaMail API can be used directly to send SMTP without needing to write attachments to disk: http://blog.pengoworks.com/blogger/index.cfm?action=blog:584 There's also this blog entry over at Charlie Arehart's site which discusses some alternatives (see the comments): http://carehart.org/blog/client/index.cfm/2007/1/13/cfdocument_name_attribut e -Dan Dan, Thanks a lot for the references. They both look very promising for our needs. Our applications don't send that many emails, but I knew I wasn't the first one to run into problems like this. You saved me some time searching in the dark. Nathan ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX 7 - Jrun 100%
sorry .. a bit desperate here .. does anyone know how i can repair this Verity mess please? Thanks -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 October 2007 12:14 To: CF-Talk Subject: RE: CFMX 7 - Jrun 100% Back to the drawing board. It is a Verity collection indexing process that is causing Jrun to run high. I have it set as a scheduled hourly event. I have two Verity collections, let's call them Site A and Site B. Site A has been up and running for about 2 years. I added Site B last week. Indexing for Site B is running fine. Indexing for Site A causes Jrun to run at 100%. I have tried deleting then recreating the Site A collection, but as soon as I run the indexing Jrun again runs out of control. Does anyone know what I can do to resolve this please? Many thanks, Jenny -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 24 October 2007 21:38 To: CF-Talk Subject: RE: CFMX 7 - Jrun 100% Many thanks all for replies on this. It turned out to be a rogue app messing up Jrun. I uploaded the cfide from another server and all appears to be well. Jenny -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: 23 October 2007 17:19 To: CF-Talk Subject: Re: CFMX 7 - Jrun 100% Lots of things could cause JRun to max out, including but not limited too; bad code or client variable clean up. Check your logs to see what's going on. No, you don't need to have CF6 installed to upgrade to 7. After you stick in your CF7 upgrade key, the install process should detect it's an upgrade and simply ask for your CF6 license key. Andy On 23/10/2007, Jenny Gavin-Wear [EMAIL PROTECTED] wrote: Hi, I'm running CFMX 7 on a Windows 2003 Server - Standard Edition. I upgraded from MX 6 using the upgrade procedure during the MX7 install. After installing, I disabled MX6 in services. All has been running great for some months now, at least 6. My problem is that the jrun.exe process has suddenly started running at 98% plus. I recalled this was a problem with MX6 so I decided to uninstall MX6, as I'm no longer using it. This promptly removed my cfide directories :/ I then tried reinstalling CFMX7 assuming this would give me the CFIDE, at which point I got a message suggesting that for an upgrade, the CFMX6 needs to be intalled. So, I have two questions: 1. What could be causing Jrun to be running at 98%+ ? 2. Do I HAVE to have CFMX6 installed to run my upgrade edition of MX7? Many thanks, Jenny ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFMX 7 - Jrun 100%
does anyone know how i can repair this Verity mess please? Identify the offending document(s) by indexing them serially. 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! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQueryParam apostrophe problem when using SET NOCOUNT
What version are you using? I don't notice the problem with mx 7.0.2 Why do you have SET NOCOUNT in the first place? The resulset generated by the insert can prevent cfquery from picking up the SELECT @@identity statement. SET NOCOUNT supresses the insert's resulset. Though they should be using SCOPE_IDENTITY() Janet ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PAYPAL PRO CFC
What code? If you are talking about payflow pro on riaforge I am the creator and would be happy to help, just email me back. On 10/25/07, Elliott Kayne [EMAIL PROTECTED] wrote: I need someone who has working knowledge of PAYPAL PRO and PAYPAL's CFC code. If you do please contact me at 570-686-2300 or [EMAIL PROTECTED] ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Sending data to Actionpage
Hi, I have a grid of data that is managed by javascript on one of my pages. At the moment i am not looking heavily into Ajax to transfer any data changes to the server but was wondering of the best way to pass the data to the actionpage. when the user clicks save i was thinking that a good way would be to store the data in hidden cfinput fields then submit the form. however some of the data may be very large, so my question is, do the hidden cfinput fields have a limit to the amount of data they can contain? i would like each hidden input field to store an array of data then send it to the actionpage i would appreciate your advice thanks Richard ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending data to Actionpage
On 10/25/07, Richard White [EMAIL PROTECTED] wrote: i would like each hidden input field to store an array of data then send it to the actionpage if you're referring to a true array, you can't store it in a hidden field (not without serializing it into a string via CFWDDX first). how about a session variable? -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Stored Procedure Help!
We have built several programs that build a tree structure an infinite amount of levels deep. the best way we have found to do it is to have a table that contains all items each with a unique reference. for example with 2 columns folderId and folderName; Then have another table called folderchildren with columns parentFolderID and childFolderID. both the columns in the folderchildren table are primary and foreign keys referencing the main folder table. then each time you add a new folder you add it in the main folder table then take its parent id and save it in folderchildren table. then when building the tree you start with the top node and run a recursive function that keeps checking for any children each time it adds a new folder. we have found this very effective but of course it is managed and built through the server code as opposed to being built from within mysql. if you need any more help just let me know. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sending data to Actionpage
thanks charlie, a session variable would be great but of course i am manipulating the data on the client in javascript and by the time i click save - its just getting the data over to the server to store it in a session variable! hmmm not sure what is the best way to do this, i suppose i may have to look into ajax? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sending data to Actionpage
If you use get you will run into limites. If you use post your form with large sets of hidden data will work fine. Regards Dale Fraser http://learncf.com -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Friday, 26 October 2007 10:46 AM To: CF-Talk Subject: Sending data to Actionpage Hi, I have a grid of data that is managed by javascript on one of my pages. At the moment i am not looking heavily into Ajax to transfer any data changes to the server but was wondering of the best way to pass the data to the actionpage. when the user clicks save i was thinking that a good way would be to store the data in hidden cfinput fields then submit the form. however some of the data may be very large, so my question is, do the hidden cfinput fields have a limit to the amount of data they can contain? i would like each hidden input field to store an array of data then send it to the actionpage i would appreciate your advice thanks Richard ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending data to Actionpage
ok thanks, ok ill give it a go and see what happens! thought id get some advice before attempting it :) thanks Dale ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Stored Procedure Help!
try this link we found it really useful although we built the database tables slightly different: http://www.dougboude.com/blog/1/2006/06/Recursive-Functions-in-ColdFusion.cfm ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sending data to Actionpage
Looping over the array and building one or many hidden form fields is perfectly valid. Although doing this with Ajax on CF8 would be fairly easy also. Regards Dale Fraser http://learncf.com -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Friday, 26 October 2007 11:00 AM To: CF-Talk Subject: Re: Sending data to Actionpage thanks charlie, a session variable would be great but of course i am manipulating the data on the client in javascript and by the time i click save - its just getting the data over to the server to store it in a session variable! hmmm not sure what is the best way to do this, i suppose i may have to look into ajax? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4