RE: Quick question on cflock...
Brad or Dave... I take it that I don't want to have one unique name, eh? Would it make more sense to do something like the code snippet below? A combination of a descriptive phrase and a unique identifier? Thanks, Che. cflock name=sessioncart-#session.sessionid# type=exclusive timeout=20 cfset structDelete(session.cart, url.sku) /cflock -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, September 09, 2009 5:19 PM To: cf-talk Subject: Re: Quick question on cflock... Except for the fact that session.cart appears to be a struct, and lock names must be a string. You might want to take off those pound signs. :) Except that if you remove the hashes, you'd have a single name session.cart for all shopping cart locks across all sessions. D'oh! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on cflock...
Brad or Dave... I take it that I don't want to have one unique name, eh? Would it make more sense to do something like the code snippet below? A combination of a descriptive phrase and a unique identifier? Thanks, Che. cflock name=sessioncart-#session.sessionid# type=exclusive timeout=20 cfset structDelete(session.cart, url.sku) /cflock Yes, that would be a good approach. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informat ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick question on cflock...
What is the best pratice when in comes to using cflock looking at the code snippets below? Basically does a session-based cfif block need to be nested within a cflock or not? I'm pretty sure it does. Thanks, Che cflock timeout=20 throwontimeout=No type=READONLY scope=SESSION cfif arrayLen(session.customer.custerrors) some code here... /cfif /cflock or... cfif arrayLen(session.customer.custerrors) cflock timeout=20 throwontimeout=No type=READONLY scope=SESSION some code here... /cflock /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Quick question on cflock...
If you are on CF8+, then my understanding is that locking READ functions is no longer required. If you're still on CFMX 7, then, yes, cfif arrayLen(session.customer.custerrors) is a READ function and should be locked. Or was it is CFMX 7 that made the READ lock less important? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on cflock...
On Wed, Sep 9, 2009 at 11:04 AM, Jason Fisher ja...@wanax.com wrote: If you are on CF8+, then my understanding is that locking READ functions is no longer required. If you're still on CFMX 7, then, yes, cfif arrayLen(session.customer.custerrors) is a READ function and should be locked. Or was it is CFMX 7 that made the READ lock less important? I think it was CFMX 7 that made it less important. IIRC, pre-CFMX 7, there was the possibility of memory corruption if reads weren't properly locked. As of CF 7 (and still true now), the only reason to lock would be if the potential for a race condition existed. AND if it mattered whether or not there was a race condition (sometimes it really doesn't) :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on cflock...
I'm on CF8. It would be great to get a definitive answer - are read locks necessary on CF8? Also, back to my original question, should the cflock surround the cfif or is it the other way around with session vars? -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, September 09, 2009 2:05 PM To: cf-talk Subject: re: Quick question on cflock... If you are on CF8+, then my understanding is that locking READ functions is no longer required. If you're still on CFMX 7, then, yes, cfif arrayLen(session.customer.custerrors) is a READ function and should be locked. Or was it is CFMX 7 that made the READ lock less important? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on cflock...
Thanks for the clarification, Charlie. Something in the back of my mind was hollering CF7 at the end of that last post, which is what made me post that last caveat. Your point about the race conditions is the key, definitely. In most of my apps, the chance of a race condition within the SESSION scope is nearly zero, but in an app that might set session vars in an iFrame or with an Ajax call, there could clearly be a chance of a race on read/write, and that's where a lock would be invaluable, no matter what version of CF. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326149 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick question on cflock...
On CF8, following Charlie's response earlier, you do NOT need a READ lock, unless you think there could be race conditions (a pending Ajax call that writes the var you're trying to read, for example). If you DO need to lock, then, yes, the lock would go *outside* of the CFIF statement, since the cfif arrayLen(session.var) is a READ function. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on cflock...
Muchas gracias... thanks Jason... thanks for the affirmation... -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, September 09, 2009 2:22 PM To: cf-talk Subject: RE: Quick question on cflock... On CF8, following Charlie's response earlier, you do NOT need a READ lock, unless you think there could be race conditions (a pending Ajax call that writes the var you're trying to read, for example). If you DO need to lock, then, yes, the lock would go *outside* of the CFIF statement, since the cfif arrayLen(session.var) is a READ function. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on cflock...
I think it was CFMX 7 that made it less important. Actually, no, that was CF 6.x. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on cflock...
What is the best pratice when in comes to using cflock looking at the code snippets below? Basically does a session-based cfif block need to be nested within a cflock or not? I'm pretty sure it does. Thanks, Che cflock timeout=20 throwontimeout=No type=READONLY scope=SESSION cfif arrayLen(session.customer.custerrors) some code here... /cfif /cflock or... cfif arrayLen(session.customer.custerrors) cflock timeout=20 throwontimeout=No type=READONLY scope=SESSION some code here... /cflock /cfif Actually, neither of those approaches a best practice standard in CF 6+. First, you don't need to lock variables unless a race condition may occur. So the real question is, what other code might be running in the same session to write to those variables while they're being read? Second, you don't need to lock variables unless you're concerned about the outcome of the race condition. For example, when you reinitialize your application scope, you typically use the same values that were there before, so it doesn't matter that one request is writing to them while another is reading from them. Third, you DON'T WANT TO LOCK AN ENTIRE SCOPE! This is why God* gave us named locks. In CF 5 and earlier, you had to lock the scope to prevent serious problems unrelated to the actual race condition. But in 6+, you can create lock names and lock only the things that need to be locked. Locking the entire session or application scopes is asking for performance trouble under load. It simply won't scale. * or the CF development team, rather. 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on cflock...
Dave, would this be a better approach? Also, can you use any name you want as long as you are consistent? See below. Thanks, Che cflock name=#session.cart# type=exclusive timeout=20 cfset structDelete(session.cart, url.sku) /cflock -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, September 09, 2009 2:46 PM To: cf-talk Subject: Re: Quick question on cflock... Third, you DON'T WANT TO LOCK AN ENTIRE SCOPE! This is why God* gave us named locks. In CF 5 and earlier, you had to lock the scope to prevent serious problems unrelated to the actual race condition. But in 6+, you can create lock names and lock only the things that need to be locked. Locking the entire session or application scopes is asking for performance trouble under load. It simply won't scale. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326157 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on cflock...
This all depends on what the some code here... does. Let's be clear on what people mean when they say cflock is less important now. cflock is no longer required to ensure that memory does not get corrupted and variables aren't read at the same time they are being written. That being said, there are very good reasons to use cflock. So back your some code here... code-- Does it require that the arrayLen be the same at the time the if statement was run? If the code in the if statement will error if the length of session.customer.custerrors is zero, then you need to go with your first option to make sure no one changes that variable while you are in the cfif since your if statement was entered under the assumption that the array had length. *IMPORTANT* This will ONLY work if you _also_ wrap every place that modified the session.customer.custerrors variable with an exclusive lock. And on that note, I would use a named lock, not a session-wide lock since it is a shame to lock the entire scope if you really only care about one variable. I generally name the lock after the variable I am accessing. And, is there a reason you didn't want to throw an error on lock timeout? If the application requires the code in the if statement to run, code farther down the page might be borked if you just silently let the cflock get skipped. cflock timeout=20 throwontimeout=Yes type=READONLY name=session.customer.custerrors cfif arrayLen(session.customer.custerrors) cfset session.customer.custerrors[1] = 'foo'!--- this line would error if the array was emptied before we reached it --- /cfif /cflock ~Brad Original Message Subject: Quick question on cflock... From: Che Vilnonis ch...@asitv.com Date: Wed, September 09, 2009 12:54 pm To: cf-talk cf-talk@houseoffusion.com What is the best pratice when in comes to using cflock looking at the code snippets below? Basically does a session-based cfif block need to be nested within a cflock or not? I'm pretty sure it does. Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on cflock...
Dave, would this be a better approach? Also, can you use any name you want as long as you are consistent? See below. Thanks, Che cflock name=#session.cart# type=exclusive timeout=20 cfset structDelete(session.cart, url.sku) /cflock Yes, that would be a better approach, and yes, you can use any name you want as long as you're consistent. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informat ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on cflock...
Except for the fact that session.cart appears to be a struct, and lock names must be a string. You might want to take off those pound signs. :) ~Brad Original Message Subject: Re: Quick question on cflock... From: Dave Watts dwa...@figleaf.com Date: Wed, September 09, 2009 3:13 pm To: cf-talk cf-talk@houseoffusion.com Dave, would this be a better approach? Also, can you use any name you want as long as you are consistent? See below. Thanks, Che cflock name=#session.cart# type=exclusive timeout=20 cfset structDelete(session.cart, url.sku) /cflock Yes, that would be a better approach, and yes, you can use any name you want as long as you're consistent. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on cflock...
Except for the fact that session.cart appears to be a struct, and lock names must be a string. You might want to take off those pound signs. :) Except that if you remove the hashes, you'd have a single name session.cart for all shopping cart locks across all sessions. D'oh! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dave, A Quick Question
Yeah. Maybe if you ask nicely, Mike D (not this Mike D, the HOF one :-) can remove the post from the archives so at least it disappears from Google. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/28 Dawson, Michael m...@evansville.edu: I didn't want to submit this to the list as obviously my name would be attached and googled right next to it. But, if you have any experience or any suggestions where I can go to find some facts and figures I appreciate it. Ooops! The list saw it. m!ke ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dave, A Quick Question
Hey Dave, I wanted to ask you a quick question since you have been in the CF world for so long. I am trying to get some real world information on CF jobs in a secure environment. Currently, I have a Secret clearance and I'm working in a job that uses that. However, hopefully in a few months I will have a Top Secret with SCI and a full scope with poly. I'm not sure if you have worked jobs that require this and I know its going to be and even rarer bird to have a CF developer with that. The reason I ask, is I was contacted by the potential project manger and she would like to ask me for a salary range for that position and with that clearance. I didn't want to submit this to the list as obviously my name would be attached and googled right next to it. But, if you have any experience or any suggestions where I can go to find some facts and figures I appreciate it. Oh, and I've been working with CF for about 10 years. I'm currently ina Sr. Level position now and this job will also be for a Sr. Cold Fusion Developer and a perm position. Thanks Dave! Mallory ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dave, A Quick Question
I didn't want to submit this to the list as obviously my name would be attached and googled right next to it. But, if you have any experience or any suggestions where I can go to find some facts and figures I appreciate it. Ooops! The list saw it. m!ke ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on session issue (hopefully)
Create a new folder with nothing but a new App.cfm with a unique name along with two more test pages. Chances are, something in your app is causing the problem. Don't feel bad about this either, any time I change the way I do authentication it takes me a short while to remember all the details too. Adrian Building a database of ColdFusion errors at http://cferror.org/ -Original Message- From: Dave Phillips Sent: 15 November 2008 23:30 To: cf-talk Subject: Re: Quick question on session issue (hopefully) Well, that didn't help either. I moved it to another server and it works fine, so apparently my code is not the issue. I restarted ColdFusion and that didn't help the situation either. The bottom line is, my session variables aren't getting persisted, but only on this machine. Again, I've tried with two different browsers, and even verified with firefox that my cookies are there and have the right CFID CFTOKEN. I really need to be able to develop this app locally, so if anyone has any other suggestions, please let me know. Dave Try appending cfid and cftoken to the url before going to your statistics page. If the cfid/cftoken stays the same and your session sticks, then you'll know that something is going on with the cookies. Judah ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Quick question on session issue (hopefully)
Hey folks, I have a quick question (hopefully). Something weird is going on, and I canât place it, and Iâm feeling like I'm having a brain freezeâ¦. This shouldnât be an issue. I have a simple application in MX 7. Application.cfm has the following: cfapplication name=zarts_tag5 sessionmanagement=true sessiontimeout=#createTimeSpan(7,0,0,0)# applicationtimeout=#createTimeSpan(30,0,0,0)# setclientcookies=true I have an index.cfm with a simple login form (username and password). That form posts to a file called âlogin_exec.cfmâ. This file then authenticates the user and after authentication is successful, I have: cfset session.isAuthorized = true If I put a dump of the session scope right after this, I can see that the variable IS getting set to true. So, after this, I had a CFLOCATION to my statistics.cfm page. But on the statistics.cfm page, a dump revealed that session.isAuthorized was now false. Now, I seemed to remember a bug in MX (or 5.0, canât remember which) that you couldnât do a cflocation after a set of cookies or session variables on a page or you would lose the variables. So, thinking this was my problem, I changed the cflocation to the following: script window.location = âstatistics.cfmâ; /script However, that didnât help the problem. The changes to the session scope that are made in login_exec.cfm are NOT persisting through to the next page, even with a client side re-direct. I have 10+ years experience in CF and the fact that I havenât figured this out yet is driving me nuts. Iâm sure itâs something simple that Iâm just not seeing. I guess hitting 40 will do that to you. :/ Anyone got any ideas where my culprit is? Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on session issue (hopefully)
Is statistics.cfm on the same domain? Dump out your cfid and cftoken to see if they stay the same on the redirect. ~Brad - Original Message - From: Dave Phillips [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, November 15, 2008 2:08 PM Subject: Quick question on session issue (hopefully) Hey folks, I have a quick question (hopefully). Something weird is going on, and I canâ?Tt place it, and Iâ?Tm feeling like I'm having a brain freezeâ?¦. This shouldnâ?Tt be an issue. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on session issue (hopefully)
Dave, If your browser is blocking cookies and you're not passing in the session tokens, then your session info will be lost. Make sure that the cookies are indeed being used by your browsers and try passing the session tokens to the URL in your window.location call. -Dan On Sat, Nov 15, 2008 at 3:08 PM, Dave Phillips [EMAIL PROTECTED] wrote: Hey folks, I have a quick question (hopefully). Something weird is going on, and I can't place it, and I'm feeling like I'm having a brain freeze . This shouldn't be an issue. I have a simple application in MX 7. Application.cfm has the following: cfapplication name=zarts_tag5 sessionmanagement=true sessiontimeout=#createTimeSpan(7,0,0,0)# applicationtimeout=#createTimeSpan(30,0,0,0)# setclientcookies=true I have an index.cfm with a simple login form (username and password). That form posts to a file called 'login_exec.cfm'. This file then authenticates the user and after authentication is successful, I have: cfset session.isAuthorized = true If I put a dump of the session scope right after this, I can see that the variable IS getting set to true. So, after this, I had a CFLOCATION to my statistics.cfm page. But on the statistics.cfm page, a dump revealed that session.isAuthorized was now false. Now, I seemed to remember a bug in MX (or 5.0, can't remember which) that you couldn't do a cflocation after a set of cookies or session variables on a page or you would lose the variables. So, thinking this was my problem, I changed the cflocation to the following: script window.location = 'statistics.cfm'; /script However, that didn't help the problem. The changes to the session scope that are made in login_exec.cfm are NOT persisting through to the next page, even with a client side re-direct. I have 10+ years experience in CF and the fact that I haven't figured this out yet is driving me nuts. I'm sure it's something simple that I'm just not seeing. I guess hitting 40 will do that to you. :/ Anyone got any ideas where my culprit is? Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on session issue (hopefully)
To answer both Brad and Dan: Brad: Yes, I have dumped the session and CFID, CFTOKEN and SESSION ID are all the same in both dumps. The dump in login_exec.cfm that shows session.isAuthorized value of true, and the dump in statistics.cfm that shows session.isAuthorized false, right after the client side redirects. Dan: I verified my cookies were on. I have been using IE 7, so I fired up firefox (pun intended) and tried it there. Same result. I even looked at the cookies in Firefox and found both the CFID and the CFTOKEN cookies with the same values that matches my dump. Do you think it has anything to do with developing on http://localhost:8300/ ? I can't imagine as I've done that for years. I'm sure it's something simple I'm missing. But I'm at least glad that no one had an answer yet! (so I don't look dumb) :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on session issue (hopefully)
different application names? On 11/15/08, Dave Phillips [EMAIL PROTECTED] wrote: To answer both Brad and Dan: Brad: Yes, I have dumped the session and CFID, CFTOKEN and SESSION ID are all the same in both dumps. The dump in login_exec.cfm that shows session.isAuthorized value of true, and the dump in statistics.cfm that shows session.isAuthorized false, right after the client side redirects. Dan: I verified my cookies were on. I have been using IE 7, so I fired up firefox (pun intended) and tried it there. Same result. I even looked at the cookies in Firefox and found both the CFID and the CFTOKEN cookies with the same values that matches my dump. Do you think it has anything to do with developing on http://localhost:8300/ ? I can't imagine as I've done that for years. I'm sure it's something simple I'm missing. But I'm at least glad that no one had an answer yet! (so I don't look dumb) :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on session issue (hopefully)
This sounds really simple, but there aren't any hidden cfsets that might be changing your value back are there? Are you on a multi-instance environment where you are hitting two instances and not giving them time to replicate session data? What if you comment out the redirect and manually load page 1 and then page 2 right in a row in two different tabs? If you refresh page 1 again, does it still show true, or has it reverted? ~Brad - Original Message - From: Dave Phillips [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, November 15, 2008 2:33 PM Subject: Re: Quick question on session issue (hopefully) To answer both Brad and Dan: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on session issue (hopefully)
Same application name. I even tried this: Instead of redirecting, I did the following in login_exec.cfm: cfdump var=#session# cfset session.isAuthorized = true a href=statistics.cfmStatistics/a cfdump var=#session# cfabort When I got to this page, I could see my session.isAuthorized was set to false before the cfset and true after it. Then, I clicked on the statistics link, and the cfdump var=#session# on that page shows: Same application name Same CFID Same CFTOKEN Same Session ID but session.isAuthorized shows false. :( I'm going to try putting the code on another machine to see if it solves the problem or not. I'm pulling my hair out (well, if I had any hair!). Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on session issue (hopefully)
Try appending cfid and cftoken to the url before going to your statistics page. If the cfid/cftoken stays the same and your session sticks, then you'll know that something is going on with the cookies. Judah On Sat, Nov 15, 2008 at 1:11 PM, Dave Phillips [EMAIL PROTECTED] wrote: Same application name. I even tried this: Instead of redirecting, I did the following in login_exec.cfm: cfdump var=#session# cfset session.isAuthorized = true a href=statistics.cfmStatistics/a cfdump var=#session# cfabort When I got to this page, I could see my session.isAuthorized was set to false before the cfset and true after it. Then, I clicked on the statistics link, and the cfdump var=#session# on that page shows: Same application name Same CFID Same CFTOKEN Same Session ID but session.isAuthorized shows false. :( I'm going to try putting the code on another machine to see if it solves the problem or not. I'm pulling my hair out (well, if I had any hair!). Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on session issue (hopefully)
Well, that didn't help either. I moved it to another server and it works fine, so apparently my code is not the issue. I restarted ColdFusion and that didn't help the situation either. The bottom line is, my session variables aren't getting persisted, but only on this machine. Again, I've tried with two different browsers, and even verified with firefox that my cookies are there and have the right CFID CFTOKEN. I really need to be able to develop this app locally, so if anyone has any other suggestions, please let me know. Dave Try appending cfid and cftoken to the url before going to your statistics page. If the cfid/cftoken stays the same and your session sticks, then you'll know that something is going on with the cookies. Judah ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8.0 clustering - quick question.
I think one requirement for session replication is to turn on J2EE sessions - do you have that on? On Sat, April 19, 2008 13:30, WebSite CFtalk wrote: Hello, I'm struggling with a cluster setup. (IIS6/CF8, 2 servers with 2 instances each) The problem is session replication - tons of errors regarding session replication failed in the logs: 19/04 19:01:40 error Setup of session replication failed. [2]java.io.StreamCorruptedException: unexpected end of block data And a lot of these: 19/04 19:01:40 error unexpected end of block data java.io.StreamCorruptedException: unexpected end of block data As soon as I turn off session replication the errors disappear. This also happens when running a cluster with 2 instances on one server - i.e. no network trouble. One thing is unclear (or obvious?..) in the references I've found: Should the jndi ports and proxy ports be different on each server instance, or should they be the same all over? Anyone? Thanks, Helge ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303815 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8.0 clustering - quick question.
You also need to name your instances uniquely. Even if you just copied the ear/war file, the instance names in the Enterprise Admin (JRun admin) cannot match. Just another thing to check. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion 8.0 clustering - quick question.
Yes, It's on, I've been through every setting on the servers that I can think of - and everything I've found on different blogs. Have also tried to tweak TCP settings as described on some forums: http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/c om.ibm.websphere.express.doc/info/exp/ae/tprf_tunewindows.html I give up for now, no session replication for me yet.. lol If I find out something I'll post back Thanks Helge -Original Message- From: Maureen Barger [mailto:[EMAIL PROTECTED] Sent: 20. april 2008 13:20 To: CF-Talk Subject: Re: ColdFusion 8.0 clustering - quick question. I think one requirement for session replication is to turn on J2EE sessions - do you have that on? On Sat, April 19, 2008 13:30, WebSite CFtalk wrote: Hello, I'm struggling with a cluster setup. (IIS6/CF8, 2 servers with 2 instances each) The problem is session replication - tons of errors regarding session replication failed in the logs: 19/04 19:01:40 error Setup of session replication failed. [2]java.io.StreamCorruptedException: unexpected end of block data And a lot of these: 19/04 19:01:40 error unexpected end of block data java.io.StreamCorruptedException: unexpected end of block data As soon as I turn off session replication the errors disappear. This also happens when running a cluster with 2 instances on one server - i.e. no network trouble. One thing is unclear (or obvious?..) in the references I've found: Should the jndi ports and proxy ports be different on each server instance, or should they be the same all over? Anyone? Thanks, Helge ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion 8.0 clustering - quick question.
we have unique ports per server (that is port 8301 8302 is used on two server), but we are having issues adding a third server to the cluster - I too would be interested in hearing a authoritative view on this question. On Sun, Apr 20, 2008 at 1:30 AM, WebSite CFtalk [EMAIL PROTECTED] wrote: Hello, I'm struggling with a cluster setup. (IIS6/CF8, 2 servers with 2 instances each) The problem is session replication - tons of errors regarding session replication failed in the logs: 19/04 19:01:40 error Setup of session replication failed. [2]java.io.StreamCorruptedException: unexpected end of block data And a lot of these: 19/04 19:01:40 error unexpected end of block data java.io.StreamCorruptedException: unexpected end of block data As soon as I turn off session replication the errors disappear. This also happens when running a cluster with 2 instances on one server - i.e. no network trouble. One thing is unclear (or obvious?..) in the references I've found: Should the jndi ports and proxy ports be different on each server instance, or should they be the same all over? Anyone? Thanks, Helge ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion 8.0 clustering - quick question.
Hello, I'm struggling with a cluster setup. (IIS6/CF8, 2 servers with 2 instances each) The problem is session replication - tons of errors regarding session replication failed in the logs: 19/04 19:01:40 error Setup of session replication failed. [2]java.io.StreamCorruptedException: unexpected end of block data And a lot of these: 19/04 19:01:40 error unexpected end of block data java.io.StreamCorruptedException: unexpected end of block data As soon as I turn off session replication the errors disappear. This also happens when running a cluster with 2 instances on one server - i.e. no network trouble. One thing is unclear (or obvious?..) in the references I've found: Should the jndi ports and proxy ports be different on each server instance, or should they be the same all over? Anyone? Thanks, Helge ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick question on presentation
Hi, I have a small cfwindow in my app. Currently this window displays a) bla bla... b) blaB blaB... c) blaC blaC... What is more desirable presentation-wise (for clarity, non cluttered overall presentation) would be: Display a) only and upon mouse over to this window, display b) and c) as well. Background info: 1) all elements including a), b) and c) come from a db dynamically as one row; 2) they(a,b and c) are wrapped inside a usual HTML table. Do you have some idea? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on presentation
Can you post the code you are using to generate this display currently? This way we can help you alter it to get the results that you desire. William On Mar 14, 2008, at 9:59 AM, Don L wrote: Hi, I have a small cfwindow in my app. Currently this window displays a) bla bla... b) blaB blaB... c) blaC blaC... What is more desirable presentation-wise (for clarity, non cluttered overall presentation) would be: Display a) only and upon mouse over to this window, display b) and c) as well. Background info: 1) all elements including a), b) and c) come from a db dynamically as one row; 2) they(a,b and c) are wrapped inside a usual HTML table. Do you have some idea? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on presentation
Hi William, short version - 1. run a qry 2. display data table cfoutput query=getStuff trtd valign=top colspan=3b#title#/bbr/ #ParagraphFormat(description)#/td /tr /cfoutput /table -- notes: the above Description column may have 3 paragraphs but I only want to display the first paragraph when the page is first loaded. And display/show all content for this row when the cursor is moved over to this window. Thanks. Don Can you post the code you are using to generate this display currently? This way we can help you alter it to get the results that you desire. William On Mar 14, 2008, at 9:59 AM, D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on presentation
Not tested, but should at least get you started.
style
.showdiv {visibility: visible; display: block;}
.hidediv {visibility: hidden; display: none;}
/style
table
div onMouseOver=showMore() onMouseOut=showLess()
cfoutput query=getStuff
trtd valign=top colspan=3div id=row#currentrow#
class=#iif(currentrow neq 1, de('hidediv'), de('showdiv'))
#b#title#/bbr/
#ParagraphFormat(description)#/div/td
/tr
/cfoutput
/div
/table
script
function showMore() {
for(x=2;x=#getStuff.recordcount#;x++) {
document.getElementById('row' + x).className =
showdiv;
}
}
function showLess() {
for(x=2;x=#getStuff.recordcount#;x++) {
document.getElementById('row' + x).className =
hidediv;
}
}
/script
On Mar 14, 2008, at 10:36 AM, Don L wrote:
Hi William,
short version
-
1. run a qry
2. display data
table
cfoutput query=getStuff
trtd valign=top colspan=3b#title#/bbr/
#ParagraphFormat(description)#/td
/tr
/cfoutput
/table
-- notes:
the above Description column may have 3 paragraphs but I only want
to display the first paragraph when the page is first loaded. And
display/show all content for this row when the cursor is moved over
to this window.
Thanks.
Don
Can you post the code you are using to generate this display
currently? This way we can help you alter it to get the results that
you desire.
William
On Mar 14, 2008, at 9:59 AM, D
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301297
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on presentation
William,
Would the intent of the following code extract each paragraph from ONE/SAME
row, hence, show/display the First Paragraph by default, then use OnMouseOver,
OnMouseOut event handlers to show the rest paragraph as well?
trtd valign=top colspan=3div id=row#currentrow#
class=#iif(currentrow neq 1, de('hidediv'), de('showdiv'))
#b#title#/bbr/
#ParagraphFormat(description)#/div/td
/tr
Thanks.
Don
Not tested, but should at least get you started.
style
.showdiv {visibility: visible; display: block;}
.hidediv {visibility: hidden; display: none;}
/style
table
div onMouseOver=showMore() onMouseOut=showLess()
cfoutput query=getStuff
trtd valign=top colspan=3div id=row#currentrow#
class=#iif(currentrow neq 1, de('hidediv'), de('showdiv'))
#b#title#/bbr/
#ParagraphFormat(description)#/div/td
/tr
/cfoutput
/div
/table
script
function showMore() {
for(x=2;x=#getStuff.recordcount#;x++) {
document.getElementById('row' + x).className =
showdiv;
}
}
function showLess() {
for(x=2;x=#getStuff.recordcount#;x++) {
document.getElementById('row' + x).className =
hidediv;
}
}
/script
On Mar 14, 2008, at 10:36 AM, D
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301306
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on presentation
the intent is to display the first query result in full. When the
table area is moused over, then display all of the other results.
Once you mouseout of the table area, only the first result should be
showing.
If I have your intention incorrect, please let me know and I will try
to assist further.
William
On Mar 14, 2008, at 11:08 AM, Don L wrote:
William,
Would the intent of the following code extract each paragraph from
ONE/SAME row, hence, show/display the First Paragraph by default,
then use OnMouseOver, OnMouseOut event handlers to show the rest
paragraph as well?
trtd valign=top colspan=3div id=row#currentrow#
class=#iif(currentrow neq 1, de('hidediv'), de('showdiv'))
#b#title#/bbr/
#ParagraphFormat(description)#/div/td
/tr
Thanks.
Don
Not tested, but should at least get you started.
style
.showdiv {visibility: visible; display: block;}
.hidediv {visibility: hidden; display: none;}
/style
table
div onMouseOver=showMore() onMouseOut=showLess()
cfoutput query=getStuff
trtd valign=top colspan=3div id=row#currentrow#
class=#iif(currentrow neq 1, de('hidediv'), de('showdiv'))
#b#title#/bbr/
#ParagraphFormat(description)#/div/td
/tr
/cfoutput
/div
/table
script
function showMore() {
for(x=2;x=#getStuff.recordcount#;x++) {
document.getElementById('row' + x).className =
showdiv;
}
}
function showLess() {
for(x=2;x=#getStuff.recordcount#;x++) {
document.getElementById('row' + x).className =
hidediv;
}
}
/script
On Mar 14, 2008, at 10:36 AM, D
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301311
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on presentation
Sorry, William, your interpretation wasn't in 'snyc' with me. The intent was, extract each paragraph from ONE/SAME row, hence, show/display the First Paragraph by default, then use OnMouseOver, OnMouseOut event handlers to show the rest paragraph and all the rest. There might be p tag within the text and there might not be. I appreciate your effort but it may not be worth the time and may slow down the loading quite a bit... So, I'll probably think up something else. Truly appreciate it. Don the intent is to display the first query result in full. When the table area is moused over, then display all of the other results. Once you mouseout of the table area, only the first result should be showing. If I have your intention incorrect, please let me know and I will try to assist further. William On Mar 14, 2008, at 11:08 AM, D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on presentation
I can think of several different ways to accomplish what you are looking for, but each one of them would add a little bit of processing to the CF side of things, as well as the javascript code (which shouldn't slow the download at all). How slow is your page to load already? William On Mar 14, 2008, at 12:14 PM, Don L wrote: Sorry, William, your interpretation wasn't in 'snyc' with me. The intent was, extract each paragraph from ONE/SAME row, hence, show/display the First Paragraph by default, then use OnMouseOver, OnMouseOut event handlers to show the rest paragraph and all the rest. There might be p tag within the text and there might not be. I appreciate your effort but it may not be worth the time and may slow down the loading quite a bit... So, I'll probably think up something else. Truly appreciate it. Don the intent is to display the first query result in full. When the table area is moused over, then display all of the other results. Once you mouseout of the table area, only the first result should be showing. If I have your intention incorrect, please let me know and I will try to assist further. William On Mar 14, 2008, at 11:08 AM, D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on presentation
for instance, since you are using the paragraphformat function, you
can have a 2nd function that checks to see if there is more than 1
open 'p' tag in the results. If there is, then have it add a 'span'
tag before the 2nd 'p' tag and then a closing 'span' tag at the end.
have this span tag default to the 'hide' classname. when the
mouseover event occurs, have it send the row to the function and then
the function would only toggle that rows 'rest of detaiil' information.
style
.showdiv {visibility: visible; display: block;}
.hidediv {visibility: hidden; display: none;}
/style
script
function showMore(x) {
document.getElementById('row' + x).className = showdiv;
}
function showLess(x) {
document.getElementById('row' + x).className =
hidediv;
}
/script
table
div onMouseOver=showMore() onMouseOut=showLess()
cfoutput query=getStuff
trtd valign=top colspan=3b#title#/bbr/
#customHideCodeFunction(ParagraphFormat(description))#/td
/tr
/cfoutput
/div
/table
On Mar 14, 2008, at 11:20 AM, William Seiter wrote:
I can think of several different ways to accomplish what you are
looking for, but each one of them would add a little bit of
processing to the CF side of things, as well as the javascript code
(which shouldn't slow the download at all). How slow is your page to
load already?
William
On Mar 14, 2008, at 12:14 PM, Don L wrote:
Sorry, William, your interpretation wasn't in 'snyc' with me. The
intent was,
extract each paragraph from ONE/SAME row,
hence, show/display the First Paragraph by default, then use
OnMouseOver,
OnMouseOut event handlers to show the rest paragraph and all the
rest.
There might be p tag within the text and there might not be. I
appreciate your effort but it may not be worth the time and may
slow down the loading quite a bit...
So, I'll probably think up something else.
Truly appreciate it.
Don
the intent is to display the first query result in full. When the
table area is moused over, then display all of the other results.
Once you mouseout of the table area, only the first result should be
showing.
If I have your intention incorrect, please let me know and I will
try
to assist further.
William
On Mar 14, 2008, at 11:08 AM, D
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301325
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on presentation
Very much appreciate it, William, it's not on my priority list for now... let's deal with it another day... the window is not slow (but I'm a speed/efficiency maniac...) for instance, since you are using the paragraphformat function, you can have a 2nd function that checks to see if there is more than 1 open 'p' tag in the results. If there is, then have it add a 'span' tag before the 2nd 'p' tag and then a closing 'span' tag at the end. have this span tag default to the 'hide' classname. when the mouseover event occurs, have it send the row to the function and then the function would only toggle that rows 'rest of detaiil' information. On Mar 14, 2008, at 11:20 AM, William Seiter wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Quick Question About Dbase Architecture
I have a profile form that has about 7 drop-down menus (marital status, education level, etc.), all required fields. How do most handle this? Do you create a separate table for each collection and then have foreign keys on the profile table, or do you simply pass in literal values to the database from the select fields? Obviously, with the latter, any changes to the structure of the collections would be difficult and bulky. But with the former, will there be a significant database toll for all of the joins in the sql statement that will be necessary to display literal values of the foreign keys? Is there a better third (or forth) option besides these? Thanks! ~| 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:288698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question About Dbase Architecture
Joel, if you want to have your database relational to 3rd normal form then yes you should have separate tables for all of your lookups. Databases are designed to work well with joins of that nature and if you build your indexes correctly you should be ok. A lot of people forget to add indexes on foreign key columns which will obviously hurt performance. For improved performance you could build views that join the tables together. Views are faster than running plain old select queries and doing all the joins. -- Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:288709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question About Dbase Architecture
Joel, if you want to have your database relational to 3rd normal form then yes you should have separate tables for all of your lookups. Databases are designed to work well with joins of that nature and if you build your indexes correctly you should be ok. A lot of people forget to add indexes on foreign key columns which will obviously hurt performance. For improved performance you could build views that join the tables together. Views are faster than running plain old select queries and doing all the joins. -- Gary Gilbert http://www.garyrgilbert.com/blog Gary -- Thanks for the input. I have not utilized views, but I think with this project I will definitely look into those as I expect to have quite a few of these regular kind of relationships between the tables. Thanks again for the explanation! Joel ~| 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:288710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question About Dbase Architecture
For improved performance you could build views that join the tables together. Views are faster than running plain old select queries and doing all the joins. This is not generally true, actually. To improve performance, views have to be indexed or materialized, and they generally aren't by default. They can, of course, still be useful as a way to flatten the relational structure of your database so that it's easier to work with. 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! ~| 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:288715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question About Dbase Architecture
I can tell you what I do... I have a utility table which has groups that populate all my drop downs. I store the utility_id as a foreign key and then join to get the actual display value. The utility table is small and utility_id is the primary key so those joins are pretty fast. The good thing is I can rename options, add options, or inactivate options and the entire site updates instantly without any new CF code. ~Brad -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 18, 2007 11:08 AM To: CF-Talk Subject: Quick Question About Dbase Architecture I have a profile form that has about 7 drop-down menus (marital status, education level, etc.), all required fields. How do most handle this? Do you create a separate table for each collection and then have foreign keys on the profile table, or do you simply pass in literal values to the database from the select fields? Obviously, with the latter, any changes to the structure of the collections would be difficult and bulky. But with the former, will there be a significant database toll for all of the joins in the sql statement that will be necessary to display literal values of the foreign keys? Is there a better third (or forth) option besides these? Thanks! ~| 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:288724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question About Dbase Architecture
A single lookup table should work fine for this. I don't see a need to create a different table for each lookup. Field structure ID (int, indexed) ItemType (varchar 25, indexed) ItemStored (char3) ItemDisplay(varchar 25) The field lengths above are not set in stone, and I am assuming your profile table does not have any one-to-many relationships with the drop-down data (there's only oging to be one marital status per individual profiled, for example). Data would be stored in the profile table in individual dedicated fields. I don't see a reason to have a foreign key in the lookup table. To edit all lookups you can develop a simple data grid that dumps them all out, sorted, or get fancy and make one data grid per field name. Drop-down display results from a simple select statement with one filter for itemtype. ItemType gets the form field name, perhaps. ItemStored is what is put into the db and ItemDisplay is what is visible to the user in the drop-down. I suppose if you were a fanatic about data normalization you would create a table for 'lookups' and have it contain only ID and ItemType. Then your lookup table has an indexed ParentID field (foreign key) replacing the ItemType field. Not something I would do unless I was trying to impress a professor in a class project. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.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:288734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question About Dbase Architecture
On 9/18/07, Matt Robertson [EMAIL PROTECTED] wrote:... I suppose if you were a fanatic about data normalization you would create a table for 'lookups' and have it contain only ID and ItemType. Then your lookup table has an indexed ParentID field (foreign key) replacing the ItemType field. Not something I would do unless I was trying to impress a professor in a class project. It's funny- my boss forwarded me this article on the next big thing in DBs- From the inventor of relational DBs himself- :-) apparently now everyone is going to be switching to column based DBs. It's the future, you see! I think Issac(?)* and I were discussing systems where we'd done similar, which is, interesting, but pretty cool for a CMSCMS type deal. I thought. I sorta laughed when I saw the article tho. *Maybe it was Aaron? Hmm... ~| 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:288761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question about quot;upgradingquot; to CF 8
Hi Tom, You said: Or you can make a CAR of your CF7 settings How do I do this? Once I have CF8 running, how do I import the settings? -Jim ~| 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:285929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick Question about upgrading to CF 8
I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it over top of 7? I have no problem just upgrading 8 over 7, thinking that it will just update all relevant parts, but I just wanted to see what the consensus was, or if there's actually a somewhat official position... Any ideas? ~| 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:285680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question about upgrading to CF 8
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it over top of 7? I believe by default CF8 installs into a different directory, and imports all your CF7 settings. Or you can make a CAR of your CF7 settings, uninstall CF7 and install CF8 fresh. -- Tom Chiverton 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 Law Society. 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. ~| 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:285682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question about upgrading to CF 8
LHWH Interactive wrote: I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Install CF 8 next to it so you can use them both. Or install a CF 8 EAR in a CF 7 instance and run CF 8 on top of CF 7. Jochem ~| 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:285726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question about upgrading to CF 8
It's always better to do a clean install...but CF 8 will also import setting from CF7 (and I believe 6). Eric -Original Message- From: LHWH Interactive [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 8:37 AM To: CF-Talk Subject: Quick Question about upgrading to CF 8 I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it over top of 7? I have no problem just upgrading 8 over 7, thinking that it will just update all relevant parts, but I just wanted to see what the consensus was, or if there's actually a somewhat official position... Any ideas? ~| 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:285760 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Quick question about character sets
Can someone please explain to me what is gained by doing something like this: cfset setEncoding(form,utf-8) cfset setEncoding(url,utf-8) I've never concerned myself with character sets, and everything seems to be okay for me. Are there any risks to *not* doing this? Thanks, Chris -- http://cjordan.us ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question about character sets
Christopher Jordan wrote: cfset setEncoding(form,utf-8) cfset setEncoding(url,utf-8) ensures that your URL form scope vars are *always* interpreted as utf-8 if that was your original intent. these days, i guess it's normally used when your encoding isn't utf-8 (though i have vague recollections that these scopes used to default to latin-1). be okay for me. Are there any risks to *not* doing this? depends on your apps but if your encoding is front-to-back utf-8 you have some way to make sure it stays that way, probably not much risk involved in not using these. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
If there is a race condition and you don't use readonly locks you are going to get inconsistent data from that read. On 1/31/07, Matt Robertson [EMAIL PROTECTED] wrote: writes=yes. reads=no. At least thats my basic rule of thumb nowadays -- with the race condition caveat. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
Dave, are you saying that it is NOT best practice, unnecessary in MX, and a bad idea in previous versions to (at beginning of script) copy your session structures to the request scope, utilize them from the request scope during processing, and then copy them back to session at the end? You thinking that's wrong seems to fly in the face of pretty much everything I've ever read on the subject. On 1/30/07, Dave Watts [EMAIL PROTECTED] wrote: And yes, I konw that it's best practice to read session vars into something like the request scope and then reference that new scope. That is not a best practice. It is completely unnecessary in CFMX, and generally a bad idea in previous versions. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
to (at beginning of script) copy your session structures to the request scope, utilize them from the request scope during processing, and then copy them back to session at the end? Definitely unnecessary in CFMX. I'd certainly be interested to see where you have been reading that! The only reason to do this pre-MX would be to avoid having to locks all over the place, so might be done if you had a variable you accessed a lot in your application. Generally though if that was the case, it would be best to not use a complex structure that needed duplication. Now, you only have to worry about race conditions for reads and writes in the session scope, which as Dave says, are fairly rare. I'm not sure I've run across any, but then I don't tend to have stuff in Session scope used for computations. One thing to keep in mind is there are times you may want to lock other than just race conditions. However, those generally are more for application and server scope where you may want to lock to prevent multiple threads trying to create them at the same time when under load. --- Mary Jo ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
When you're talking about only reading, I think you're right, but Dave seemed to go more general than that. I would much rather have full unlocked access to a request scope structure to do writes to, than to have to throw in locks around my writes to session scope. With what I'm saying, you would only have one exclusive lock on the page, but what you guys are saying is that you would rather have multiple exclusive locks, so that you can reference your session scopes directly. But perhaps I misunderstand. On 1/31/07, Mary Jo Sminkey [EMAIL PROTECTED] wrote: to (at beginning of script) copy your session structures to the request scope, utilize them from the request scope during processing, and then copy them back to session at the end? Definitely unnecessary in CFMX. I'd certainly be interested to see where you have been reading that! The only reason to do this pre-MX would be to avoid having to locks all over the place, so might be done if you had a variable you accessed a lot in your application. Generally though if that was the case, it would be best to not use a complex structure that needed duplication. Now, you only have to worry about race conditions for reads and writes in the session scope, which as Dave says, are fairly rare. I'm not sure I've run across any, but then I don't tend to have stuff in Session scope used for computations. One thing to keep in mind is there are times you may want to lock other than just race conditions. However, those generally are more for application and server scope where you may want to lock to prevent multiple threads trying to create them at the same time when under load. --- Mary Jo ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
David Gardner wrote: Dave, are you saying that it is NOT best practice, unnecessary in MX, and a bad idea in previous versions to (at beginning of script) copy your session structures to the request scope, utilize them from the request scope during processing, and then copy them back to session at the end? Imagine the following scenario: - request A arrives at the server, copies the persistent information from the session to the request and starts a long query; - user gets impatient and clicks some other link; - request B arrives at the server, copies the persistent information from the session to the request and starts processing; - request B does something that is supposed to be persistent; - request B is ready and writes its data back to the session; - request A is finally ready and writes its data back to the session, overwriting the changes request A just made. You thinking that's wrong seems to fly in the face of pretty much everything I've ever read on the subject. Depends on your definition of wrong. I do not think it is wrong if other people do that and then call us in to clean up the mess :) Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268200 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
When you're talking about only reading, I think you're right, but Dave seemed to go more general than that. I would much rather have full unlocked access to a request scope structure to do writes to, than to have to throw in locks around my writes to session scope. You do NOT have to lock writes in session scope unless there is a possibility of a race conditionone that would have ramifications for your application. --- Mary Jo ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
keep reading that post you copied in your message. You missed something. and as Dave said... a meaningful race condition is not particularly likely in any event in the session scope. On 1/31/07, James Holmes [EMAIL PROTECTED] wrote: If there is a race condition and you don't use readonly locks you are going to get inconsistent data from that read. On 1/31/07, Matt Robertson [EMAIL PROTECTED] wrote: writes=yes. reads=no. At least thats my basic rule of thumb nowadays -- with the race condition caveat. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick Question: Should I lock Session Scope Reads in MX 7
Should I lock Session Scope Reads in MX 7? There shouldn't be a race condition problem. I know to lock writes, but how about Reads? Additionally, If I'm on a shared server, how can I tell if they've enabled automatic read locking ? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
And yes, I konw that it's best practice to read session vars into something like the request scope and then reference that new scope. But I'm in someone else's code. On 1/30/07, David Gardner [EMAIL PROTECTED] wrote: Should I lock Session Scope Reads in MX 7? There shouldn't be a race condition problem. I know to lock writes, but how about Reads? Additionally, If I'm on a shared server, how can I tell if they've enabled automatic read locking ? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
Should be safe (if auto0locking is on).and ask the ISP if they've turned on the auto-locking feature.if notyou must lock ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
If race conditions shouldn't be a problem, there's no reason to lock. Pre-MX, yes. Aside from race condition issues there were issues of memory corruption. Nowadays, you kids have it easy :) (not sure how about determining if the automatic locking is enabled...but assuming i'm not totally off base in my response, it should be a moot point) On 1/30/07, David Gardner [EMAIL PROTECTED] wrote: Should I lock Session Scope Reads in MX 7? There shouldn't be a race condition problem. I know to lock writes, but how about Reads? Additionally, If I'm on a shared server, how can I tell if they've enabled automatic read locking ? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
Ah, so I've got one Yes and one No! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
well now we went and gave him conflicting info :) i'm under the impression that, as of MX+, locking is only necessary in instances where race conditions could occur. he had originally stated that race conditions shouldn't be a concern here. am I understanding incorrectly (don't get me wrong...wouldn't be the first time) :) On 1/30/07, Bryan Stevenson [EMAIL PROTECTED] wrote: Should be safe (if auto0locking is on).and ask the ISP if they've turned on the auto-locking feature.if notyou must lock ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
he had originally stated that race conditions shouldn't be a concern here. shouldn't does not mean won't ;-) (sorry if that's too nit picky) I'd just call the ISP and confirm if auto-locking is turned on (think it is by default).if it's not...then we can clarify (I'm not sure either if it's only if race conditions may occur). I just use cookies so that sessions don't get lost when/if the server/CF service is restarted. and around and around we go..hehe Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
Yeah, there are ways around using session vars, but we don't have to go there because that point is moot for my question. I'm stuck with the other guy's code. So are you saying that if auto-locking is OFF, that I would have to lock session var reads? and around and around we go..hehe ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
Nope I said I'm not 100% sure if it would be required for reads (mainly because I don't use them). My understanding of the auto-locking feature was if it's on you're fine and if it's not then you must lock. Charlie thinks that for reads you should be OK. So it may not be as black white as I think. Sorry I can't confirm or deny on this one ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
In CFMX, locking is only necessary if a race condition can be encountered. Since this is the session scope, unless you are using frames or otherwise simulrtaneously requesting data from the same session, race conditions will not occur. You therefore do not need to lock if this criterion is met. On 1/31/07, Bryan Stevenson [EMAIL PROTECTED] wrote: Nope I said I'm not 100% sure if it would be required for reads (mainly because I don't use them). My understanding of the auto-locking feature was if it's on you're fine and if it's not then you must lock. Charlie thinks that for reads you should be OK. So it may not be as black white as I think. Sorry I can't confirm or deny on this one ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick Question: Should I lock Session Scope Reads in MX 7
There were memory corruption issues pre MX (I believe). Currently, I don't believe you ever need to lock, unless you are running code that needs a lock. You can generate race conditions on the session scope by opening multiple windows to the same site, so just because you're not using frames, it doesn't mean you don't have race conditions. You don't need to lock reads unless you really care about those reads. Something like this: cfset amount=session.total cfset amount=amount-form.amount cfset session.total=amount It's possible that there could be a race condition here, and you would need to lock the whole block in an exclusive lock to prevent it. Russ -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 30, 2007 7:04 PM To: CF-Talk Subject: Re: Quick Question: Should I lock Session Scope Reads in MX 7 In CFMX, locking is only necessary if a race condition can be encountered. Since this is the session scope, unless you are using frames or otherwise simulrtaneously requesting data from the same session, race conditions will not occur. You therefore do not need to lock if this criterion is met. On 1/31/07, Bryan Stevenson [EMAIL PROTECTED] wrote: Nope I said I'm not 100% sure if it would be required for reads (mainly because I don't use them). My understanding of the auto-locking feature was if it's on you're fine and if it's not then you must lock. Charlie thinks that for reads you should be OK. So it may not be as black white as I think. Sorry I can't confirm or deny on this one ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question: Should I lock Session Scope Reads in MX 7
writes=yes. reads=no. At least thats my basic rule of thumb nowadays -- with the race condition caveat. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick Question: Should I lock Session Scope Reads in MX 7
Should be safe (if auto0locking is on).and ask the ISP if they've turned on the auto-locking feature.if notyou must lock ;-) As of CF 6, there is no auto-locking feature. And, the danger of race conditions is pretty minimal in the Session scope, in my experience. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question: Should I lock Session Scope Reads in MX 7
And yes, I konw that it's best practice to read session vars into something like the request scope and then reference that new scope. That is not a best practice. It is completely unnecessary in CFMX, and generally a bad idea in previous versions. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick question on dynamic sorting
What is the best way to do dynamic sorting? I have a recordset that has several columns, and the title row is a link that sends a URL parameter Sort with the sort variable. Specifically what should I do with the query results. Should I cache the results so I can use it each time they click on a sort link? Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267790 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick question on dynamic sorting
What is the best way to do dynamic sorting? I have a recordset that has several columns, and the title row is a link that sends a URL parameter Sort with the sort variable. Specifically what should I do with the query results. Should I cache the results so I can use it each time they click on a sort link? If your dataset is relatively small, your best bet in many cases might be to do it client-side, with JavaScript/DHTML. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on dynamic sorting
Well that is the problem. There are so far over 40K records, and if the user does not pick anything at all, then they get all of the records. So it could be as small as one record or over 40K. On 1/26/07, Dave Watts [EMAIL PROTECTED] wrote: What is the best way to do dynamic sorting? I have a recordset that has several columns, and the title row is a link that sends a URL parameter Sort with the sort variable. Specifically what should I do with the query results. Should I cache the results so I can use it each time they click on a sort link? If your dataset is relatively small, your best bet in many cases might be to do it client-side, with JavaScript/DHTML. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on dynamic sorting
Well that is the problem. There are so far over 40K records, and if the user does not pick anything at all, then they get all of the records. So it could be as small as one record or over 40K. Do you display them all within a single page? Have you considered requiring filters? Nobody in their right mind wants to see 40,000 records in a single page. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267810 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on dynamic sorting
No, of course not. I am using Next N navigation, showing only 20 rows at a time. On 1/26/07, Dave Watts [EMAIL PROTECTED] wrote: Well that is the problem. There are so far over 40K records, and if the user does not pick anything at all, then they get all of the records. So it could be as small as one record or over 40K. Do you display them all within a single page? Have you considered requiring filters? Nobody in their right mind wants to see 40,000 records in a single page. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267815 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question on dynamic sorting
No, of course not. I am using Next N navigation, showing only 20 rows at a time. Do you want to resort just within those 20 rows, or across the entire dataset? If you want to resort across the entire dataset, it would be easier for you to do that on the server. You can use query-of-queries for this purpose. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on dynamic sorting
OK. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question
#chr(10)##chr(13)# will simulate a carriage return combination. Then when you need to modify the string that has delimeters in it, you can use ListChangeDelims to change delimeters or StripCR to yank out the trailing 10-13 comination. Teddy ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question
chr(10) chr(13) isn't it? On Windows, text files use carriage return/line feed to begin a new line. On Unix, text files use line feed alone, and on Mac Classic text files use carriage return alone. The ASCII code for carriage return is 13, and the code for line feed is 10, so if you want to specify a new line in Windows you use both characters in that order (not 10-13). 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! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick Question
Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question
ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question
try: cfset myList = test1 test2 test3 cfset newList = listchangedelims(myList,-, ) cfoutput#mylist#, #newlist#/cfoutput On 8/31/06, Doug Brown [EMAIL PROTECTED] wrote: Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question
I thought the second parameter was the new list delimiter? (third the old) ? On 8/31/06, Ben Forta [EMAIL PROTECTED] wrote: ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick Question
Ah... another obscure function I forgot about... Tell the truth Ben, you have one of those big charts of tags and functions from teratech hanging on the wall next to you - right? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 7:50 AM To: CF-Talk Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question
cfset myList = test1 test2 test3 cfset myNewList=ListChangeDelims(myList, , -) cfoutput#myNewlist#/cfoutput Why is it not working? - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, August 31, 2006 6:50 AM Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question
Sometimes I think I need one of those - I must be gettin' old because my memory's leaving me. The other day I typed structKeyFind(...) and couldn't figure out for the life of me why it wasn't working. I bet I looked at it for 5 minutes before I realized the idiotic mistake I had made. Luckily I realized what the problem was before I asked anyone else to look at it. --Ferg -Original Message- From: Mkruger [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:09 AM To: CF-Talk Subject: RE: Quick Question Ah... another obscure function I forgot about... Tell the truth Ben, you have one of those big charts of tags and functions from teratech hanging on the wall next to you - right? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 7:50 AM To: CF-Talk Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick Question
Wouldn't help, I'd need to carry a big old wall with me wherever I went, not practical. But what does help is the cfdoc IM bot, I use that extensively for this type of stuff: AIM: cflivedocs Yahoo!: cflivedocs GoogleTalk: [EMAIL PROTECTED] -- Ben -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:39 AM To: CF-Talk Subject: RE: Quick Question Sometimes I think I need one of those - I must be gettin' old because my memory's leaving me. The other day I typed structKeyFind(...) and couldn't figure out for the life of me why it wasn't working. I bet I looked at it for 5 minutes before I realized the idiotic mistake I had made. Luckily I realized what the problem was before I asked anyone else to look at it. --Ferg -Original Message- From: Mkruger [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:09 AM To: CF-Talk Subject: RE: Quick Question Ah... another obscure function I forgot about... Tell the truth Ben, you have one of those big charts of tags and functions from teratech hanging on the wall next to you - right? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 7:50 AM To: CF-Talk Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question
Doug, You could also try this.. cfset myNewList2='#ReReplace(mylist, ,-,all)#' cfoutput#myNewlist2#/cfoutput Enjoy, Brian -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:11 AM To: CF-Talk Subject: Re: Quick Question cfset myList = test1 test2 test3 cfset myNewList=ListChangeDelims(myList, , -) cfoutput#myNewlist#/cfoutput Why is it not working? - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, August 31, 2006 6:50 AM Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251607 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick Question
Doug, Also I just noticed in Ben's last, the and - are reversed... That's why it's not working for you.. Enjoy! -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:11 AM To: CF-Talk Subject: Re: Quick Question cfset myList = test1 test2 test3 cfset myNewList=ListChangeDelims(myList, , -) cfoutput#myNewlist#/cfoutput Why is it not working? - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, August 31, 2006 6:50 AM Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question
cfset myList = test1 test2 test3 cfset myNewList=ListChangeDelims(myList, -, ) cfoutput#myNewlist#/cfoutput You had it backwards. It is new delimeter then old delimeter. Teddy On 8/31/06, Doug Brown [EMAIL PROTECTED] wrote: cfset myList = test1 test2 test3 cfset myNewList=ListChangeDelims(myList, , -) cfoutput#myNewlist#/cfoutput Why is it not working? - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, August 31, 2006 6:50 AM Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick Question
That rocks! I never knew such a beast existed. Thanks Ben. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:34 AM To: CF-Talk Subject: RE: Quick Question Wouldn't help, I'd need to carry a big old wall with me wherever I went, not practical. But what does help is the cfdoc IM bot, I use that extensively for this type of stuff: AIM: cflivedocs Yahoo!: cflivedocs GoogleTalk: [EMAIL PROTECTED] -- Ben -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:39 AM To: CF-Talk Subject: RE: Quick Question Sometimes I think I need one of those - I must be gettin' old because my memory's leaving me. The other day I typed structKeyFind(...) and couldn't figure out for the life of me why it wasn't working. I bet I looked at it for 5 minutes before I realized the idiotic mistake I had made. Luckily I realized what the problem was before I asked anyone else to look at it. --Ferg -Original Message- From: Mkruger [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:09 AM To: CF-Talk Subject: RE: Quick Question Ah... another obscure function I forgot about... Tell the truth Ben, you have one of those big charts of tags and functions from teratech hanging on the wall next to you - right? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 7:50 AM To: CF-Talk Subject: RE: Quick Question ListChangeDelims() In your example: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:43 AM To: CF-Talk Subject: Quick Question Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3 Sorry for the newb question!! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
