Re: OnEnter issues
I don't know if there is an onenter input attribute... that might be a problem. In your case tho, I think you could just do this, and fake the enter key listener (since it's in a form, enter is bound by default to submit). I think. form onsubmit=entermessage();return false; Which I hope would fire every time enter is pressed, but don't know for sure. Otherwise you'd have to listen for a keypress, I guess, and see if the key pressed was the enter key. I've got some examples of that lying around if you need it. The interweb has 'em too. ~| 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:280735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How many CF developers does it take to manage a site ???
Yeah, same with us, although we have over 300 independent sites they currenty all share the same code base etc so we manage one code base and 300 sites within our web farm. So, yes we manage 300 but in all reality we may not touch any of them since launch: This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Brad Wood To: CF-Talk Sent: Mon Jun 11 15:54:32 2007 Subject: RE: How many CF developers does it take to manage a site ??? So many variables... Our company is at least 2000 employees, we have 5 CF developers and 6 SQL developers, but only 2 sites. Of course they are pretty complex and very database driven, support over 50 child-companies, and require constant new development for new features and functionality. If we were simply maintaining a set code-base, it would only take a few of us though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 9:00 AM To: CF-Talk Subject: How many CF developers does it take to manage a site ??? I was just curious ... about how many live corporate Web sites does the average CF developer manage? I'm not talking side jobs, or pet projects. I'm talking you work for XYZ company with more than 100 employyes and manage x number of Web sites all by yourself. The reason why I ask is I'm managing 6 and throughout most of my career I've only had to manage 1. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the easiest way to do this?
Yes, this is a task well suited to AJAX. Perhaps look at AjaxCFC (the JQuery version) or mxAjax so that you get an integrated CF solution out of the box. As I use mxAjax, I'd use the mxData component to run a CFC method that returns values based on those dropdowns; then I'd write the new data into the last dropdown (perhaps with the DOM or with innerHTML). On 6/12/07, Will Tomlinson [EMAIL PROTECTED] wrote: I have a form that uses qForms for 7 dynamic select menus. There's one other dataset/filter I need to add, but it isn't directly connected with the data in the related menus. I can query this data and filter it using the related selects, but I only know how to do it the old fashioned way - hit the server with a submit button and return the data to a newly shown dropdown for courses. How could I do this with say, a button, Show course filter. You click the button and it asynchrously runs the course query, using the filters from the related selects. Then display it in a another dropdown filter. I know this has AJAX written all over it, but could somebody point me in the right direction? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OnEnter issues
I think a better practice would be to not use the enter button. What Ajax framework if any are you using? Most should have a watcher / observer event type system to monitor changes to a specific element. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Phillip M. Vector To: CF-Talk Sent: Tue Jun 12 00:18:05 2007 Subject: OnEnter issues I have a form that I'm using with AJAX calls to the DB. I'd like to use Enter to call the AJAX function. However, the form is trying to submit itself when I press enter. Is there a way of disableing enter from submitting a form on a page? Or is there a workaround that someone can think of? I've tried redirecting the form back to the form itself, but the problem becomes that I have a onkeydown already defined and that seems to be taking presidence on the calls. So it goes to the keydown and doesn't go to enter.. Any ideas? body onload=showmessages() cfoutput form action=#self#Chat.Default method=Post Message: input type=text id=Message onenter=entermessage() onkeydown=showmessages() size=40 input type=Hidden id=Room value=1 /form /cfoutput HR ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using sessions with Flash Remoting
Well onSessionStart and onSessionEnd must go in Application.cfc. This will need to go in a folder somewhere above the files that your remoting calls are hitting. I assume you're handling the cookies for sessions somewhere in your client code? On 6/12/07, John Robinson [EMAIL PROTECTED] wrote: I should note that I'm specifically having trouble with onSessionStart and onSessionEnd... basically where to put them (in someFile.cfc or Application.cfc or Application.cfm or?). What I want is to run a sql query in onSessionEnd, using the vars from the session (or cookie... I don't really care where they're stored, as long as they're unique to each user). -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OnEnter issues
Actually you are right I missed that, the event is actually onKeyDown or onKeyUp I believe.. On 6/12/07, Dinner [EMAIL PROTECTED] wrote: I don't know if there is an onenter input attribute... that might be a problem. In your case tho, I think you could just do this, and fake the enter key listener (since it's in a form, enter is bound by default to submit). I think. form onsubmit=entermessage();return false; Which I hope would fire every time enter is pressed, but don't know for sure. Otherwise you'd have to listen for a keypress, I guess, and see if the key pressed was the enter key. I've got some examples of that lying around if you need it. The interweb has 'em too. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OnEnter issues
AJax is javascript... So unless you want to submit the form, then no you do not need the form. Which is handy because then you do not need to override or cancel the onSubmit. On 6/12/07, Phillip M. Vector [EMAIL PROTECTED] wrote: Andrew Scott wrote: I am not sure what your question is asking. When you say enter Button, are you referring to hitting the enter key? Because I do not see a button in your code? Yes. I mean the enter key. :) On a side note, this is not an Ajax problem but what it appears to be if I am guessing right is that the call to the server via var url=index.cfm?fuseaction=Chat.CheckMessages; May be throwing an error at a guess. CheckMessages works perfectly. It's the other one that isn't (EnterMessage). Might I suggest getting firefox, downloading the plugin fireDebug and switching on HTTPRequests this will at least give you more information on whether the call to the server is in fact throwing an error. Or you could just look into the CF logs, but fireDebug is an easier and quicker way of knowing. I have firebug installed before. The call isn't happening at all. I get the onkeydown call, but not the onenter call. Also by looking at your code, you have no submit button. Which means that to wrap the input type=text in a form is not necessary either. Unless you want to submit the entire form, but judging by your code this is not what you are doing. So the form tags are not needed in this example. Oh? I thought you needed the form tag for ajax calls. Good to know. :) ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: embedded cfml in system messaging...
On Monday 11 Jun 2007, D F wrote: What would the advantage be with transmorphing CF tags to another language ( ie % ). You need to separate code that needs to run when the page is displayed vs. code that is run to generate that code. couldn't it just populate a textarea and use JS to limit the editability of the embedded CFML code? or is this barking up the wrong tree? You could do that too. If you were going to let your users enter 'real' CFML, you'll have to trust them and be fairly careful what you allow. -- Tom Chiverton Helping to completely pursue holistic appliances on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the 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. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: CSS Question
Rick Faircloth wrote: Hi, all... I'm wondering if anyone knows why and what to do about aligning a div background image to the right top corner of a div. IE 7 and FF display it as expected...IE 6 just leaves it in the *left* upper corner. Here's the code: div class=section style=width:100%; height:200px; background:url(images/dove-section-bg.png) top right no-repeat; /div Rick, That code snippet you provided works fine in IE6 at my end (in isolation), so something else is going on. Seeing the page in question would really help define exactly what - do you have a link for perusal? Mark ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280743 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: CSS Question
I will have to agree, works here too. but one thing I have also noticed is that in some case of heritance of styles, the image class needs to have margin-left: auto; and margin-right: auto; I have also found that in fireDebug, if you start to disable inherit css elements you can quickly identify the problem too. On 6/12/07, Mark Henderson [EMAIL PROTECTED] wrote: Rick Faircloth wrote: Hi, all... I'm wondering if anyone knows why and what to do about aligning a div background image to the right top corner of a div. IE 7 and FF display it as expected...IE 6 just leaves it in the *left* upper corner. Here's the code: div class=section style=width:100%; height:200px; background:url(images/dove-section-bg.png) top right no-repeat; /div Rick, That code snippet you provided works fine in IE6 at my end (in isolation), so something else is going on. Seeing the page in question would really help define exactly what - do you have a link for perusal? Mark ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: CSS Question
Hi, Andrew... check out my response to Mark Mik for the explanation I came upon for the problem. Let me know if you don't see it. Rick -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 5:29 AM To: CF-Talk Subject: Re: OT: CSS Question I will have to agree, works here too. but one thing I have also noticed is that in some case of heritance of styles, the image class needs to have margin-left: auto; and margin-right: auto; I have also found that in fireDebug, if you start to disable inherit css elements you can quickly identify the problem too. On 6/12/07, Mark Henderson [EMAIL PROTECTED] wrote: Rick Faircloth wrote: Hi, all... I'm wondering if anyone knows why and what to do about aligning a div background image to the right top corner of a div. IE 7 and FF display it as expected...IE 6 just leaves it in the *left* upper corner. Here's the code: div class=section style=width:100%; height:200px; background:url(images/dove-section-bg.png) top right no-repeat; /div Rick, That code snippet you provided works fine in IE6 at my end (in isolation), so something else is going on. Seeing the page in question would really help define exactly what - do you have a link for perusal? Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: CSS Question
Oh, and I meant to give you and Mik a link to show what I'm working on... http://hfumc.whitestonemedia.com Looks fine in IE7 and FF2, which support png transparency, but not in IE6 where I have to use the AlphaImageTransparency filter... :o( Rick -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 4:53 AM To: CF-Talk Subject: Re: OT: CSS Question Rick Faircloth wrote: Hi, all... I'm wondering if anyone knows why and what to do about aligning a div background image to the right top corner of a div. IE 7 and FF display it as expected...IE 6 just leaves it in the *left* upper corner. Here's the code: div class=section style=width:100%; height:200px; background:url(images/dove-section-bg.png) top right no-repeat; /div Rick, That code snippet you provided works fine in IE6 at my end (in isolation), so something else is going on. Seeing the page in question would really help define exactly what - do you have a link for perusal? Mark ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: CSS Question
I may just have to give up my gradient background image for the mid-section and go to a white background and just give my images a white background and avoid the AlphaImageTransparency filter, altogether. That way I can CSS positioning on the background element... Rick -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 4:53 AM To: CF-Talk Subject: Re: OT: CSS Question Rick Faircloth wrote: Hi, all... I'm wondering if anyone knows why and what to do about aligning a div background image to the right top corner of a div. IE 7 and FF display it as expected...IE 6 just leaves it in the *left* upper corner. Here's the code: div class=section style=width:100%; height:200px; background:url(images/dove-section-bg.png) top right no-repeat; /div Rick, That code snippet you provided works fine in IE6 at my end (in isolation), so something else is going on. Seeing the page in question would really help define exactly what - do you have a link for perusal? Mark ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: CSS Question
Hi, Mark Mik... I figured out what was causing the problem after I posted. I'm using the Microsoft AlphaImageLoader filter to create a pseudo transparency for the .png and the filter actually creates a new image, which is not a true background image, therefore the typical CSS background attributes don't apply. My only other option, that I'm aware of, is to use absolute positioning of the div's to create an overlap. That is the only way to get two div's to overlap, isn't it? I tried every other way, including using z-index and floating without absolute positioning, but could get everything to stack up. Thoughts, Thanks, Rick -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 4:53 AM To: CF-Talk Subject: Re: OT: CSS Question Rick Faircloth wrote: Hi, all... I'm wondering if anyone knows why and what to do about aligning a div background image to the right top corner of a div. IE 7 and FF display it as expected...IE 6 just leaves it in the *left* upper corner. Here's the code: div class=section style=width:100%; height:200px; background:url(images/dove-section-bg.png) top right no-repeat; /div Rick, That code snippet you provided works fine in IE6 at my end (in isolation), so something else is going on. Seeing the page in question would really help define exactly what - do you have a link for perusal? Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Odd session behavior
Our production site is having some issues. We are getting some feedback that sessions are going AWOL. Some people are unable to add products to their cart, some can but they quickly vanish leaving them with empty carts after 30-60 seconds. Everyone here has tried and our carts last for weeks with no trouble. Could as many of you as possible please try adding stuff to your cart and if strange things happen to it could you let me know your OS/browser combo and anything else that could be causing problems at your end like programs that delete cookies etc... Link: http://www.uwish.co.uk -- Jay ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Odd session behavior
James, I've just played around and everything seemed to work a real charm, changed quantities, deleted items, added new ones and everything works great for me, nice site *:o) I'm running IE7, Rob -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 12 June 2007 11:14 To: CF-Talk Subject: Odd session behavior Our production site is having some issues. We are getting some feedback that sessions are going AWOL. Some people are unable to add products to their cart, some can but they quickly vanish leaving them with empty carts after 30-60 seconds. Everyone here has tried and our carts last for weeks with no trouble. Could as many of you as possible please try adding stuff to your cart and if strange things happen to it could you let me know your OS/browser combo and anything else that could be causing problems at your end like programs that delete cookies etc... Link: http://www.uwish.co.uk -- Jay ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280750 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the easiest way to do this?
As I use mxAjax, I'd use the mxData component to run a CFC method that returns values based on those dropdowns; then I'd write the new data into the last dropdown (perhaps with the DOM or with innerHTML). Thanks james. I'll investigate this. Will ~| 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:280751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd session behavior
On Tuesday 12 Jun 2007, James Smith wrote: Link: http://www.uwish.co.uk Seems fine, Firefox 2.0/Linux. -- Tom Chiverton Helping to appropriately transition B2B niches on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the 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. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Next meeting of the Capitol Hill User Group: 6/19 3PM
Capitol Hill User Group (CHUG) Organizational Meeting and ColdFusion 8 6/19/07 3:00 PM Senate Dirksen Office Building - Room 192 In our next meeting we'll deal with some organizational issues, and we want to hear from YOU so we make sure the group best meets your needs. We'll also demo some of the great new features in ColdFusion 8. Note: anyone with anything to do with web development on Capitol Hill is welcome. Dirksen is open to the public. All are welcome! RSVP at http://www.capitolhillusergroup.org/ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the easiest way to do this?
James,
Will this work if I have multiple form fields that need to be passed to the
cfc?
What's mixing me up is the source attribute. Here's what I'm passing. 3 items,
from 3 formfields.
!--- Start ajaxcfc call ---
cfoutput
script type='text/javascript' src='../mxAjax/core/js/prototype.js'/script
script type='text/javascript' src='../mxAjax/core/js/mxAjax.js'/script
script type='text/javascript' src='../mxAjax/core/js/mxSelect.js'/script
/cfoutput
script language=javascript
var url = cfoutput#ajaxUrl#/cfoutput;
function init() {
new mxAjax.Select({
parser: new mxAjax.CFArrayToJSKeyValueParser(),
executeOnLoad: true,
target: course,
paramArgs: new
mxAjax.Param(url,{param:eval={eval},T7={Tier7},T6={Tier6}, httpMethod:get,
cffunction:getCourses}),
source: eval,Tier7,Tier6
});
}
addOnLoadEvent(function() {init();});
/script
If I change one of the dropdowns, nothing happens.
Thanks,
Will
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280754
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OnEnter issues
That did it! THANK YOU! :) Dinner wrote: I don't know if there is an onenter input attribute... that might be a problem. In your case tho, I think you could just do this, and fake the enter key listener (since it's in a form, enter is bound by default to submit). I think. form onsubmit=entermessage();return false; Which I hope would fire every time enter is pressed, but don't know for sure. Otherwise you'd have to listen for a keypress, I guess, and see if the key pressed was the enter key. I've got some examples of that lying around if you need it. The interweb has 'em too. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OnEnter issues
I'm not using any specific framework. My knowledge of AJAX is about *looks at watch* 2 days worth. :) It's for a personal website right now and I hope to get a book about it soon to get more advanced. Robertson-Ravo, Neil (RX) wrote: I think a better practice would be to not use the enter button. What Ajax framework if any are you using? Most should have a watcher / observer event type system to monitor changes to a specific element. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Phillip M. Vector To: CF-Talk Sent: Tue Jun 12 00:18:05 2007 Subject: OnEnter issues I have a form that I'm using with AJAX calls to the DB. I'd like to use Enter to call the AJAX function. However, the form is trying to submit itself when I press enter. Is there a way of disableing enter from submitting a form on a page? Or is there a workaround that someone can think of? I've tried redirecting the form back to the form itself, but the problem becomes that I have a onkeydown already defined and that seems to be taking presidence on the calls. So it goes to the keydown and doesn't go to enter.. Any ideas? body onload=showmessages() cfoutput form action=#self#Chat.Default method=Post Message: input type=text id=Message onenter=entermessage() onkeydown=showmessages() size=40 input type=Hidden id=Room value=1 /form /cfoutput HR ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the easiest way to do this?
Instead of using the mxselect use mxdata - this will let you pass in
each dropdown value as an argument to your CFC and get a return you
can use to build the last dropdown. Check my blog or the mxdata
example for some more details on mxdata. If you have more problems
with it let me know and I'll blog a solution.
On 6/12/07, Will Tomlinson [EMAIL PROTECTED] wrote:
James,
Will this work if I have multiple form fields that need to be passed to the
cfc?
What's mixing me up is the source attribute. Here's what I'm passing. 3
items, from 3 formfields.
!--- Start ajaxcfc call ---
cfoutput
script type='text/javascript' src='../mxAjax/core/js/prototype.js'/script
script type='text/javascript' src='../mxAjax/core/js/mxAjax.js'/script
script type='text/javascript' src='../mxAjax/core/js/mxSelect.js'/script
/cfoutput
script language=javascript
var url = cfoutput#ajaxUrl#/cfoutput;
function init() {
new mxAjax.Select({
parser: new mxAjax.CFArrayToJSKeyValueParser(),
executeOnLoad: true,
target: course,
paramArgs: new
mxAjax.Param(url,{param:eval={eval},T7={Tier7},T6={Tier6},
httpMethod:get, cffunction:getCourses}),
source: eval,Tier7,Tier6
});
}
addOnLoadEvent(function() {init();});
/script
If I change one of the dropdowns, nothing happens.
Thanks,
Will
~|
CF 8 â Scorpio beta now available,
easily build great internet experiences â Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280757
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Large CSV File
I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: A Date Problem that's got me tearing out my hair!
AJ Mercer wrote: could there be a database trigger on the table that is manipulating the date? Nothing. It's a straight insert. It *has* to be something related to the two different server locations, but I'll be darned if I can figure it out. For now, I'm just going to have to use DateAdd to all entered dates. What I'm worried about though, is I bet there'll be one particular time of day where it *doesn't* transpose the dates (exactly 2 minutes and 15 seconds after midnight or something stupid...) and they still get screwed up. So far, I haven't found such an anomaly yet, but it's already weird enough as it is. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Large CSV File
Is it all brand new records? or will most of the data after the first be already in there and need to be updated? I learned that the best way to parse it is to set up a upload once (using cffile) and then every week, load the csv file into an array and then compare it with the data already there. Of course, if it's always new data, see if you can convince them to do uploads every night so that you can handle the data without to much hit on your server. Les Mizzell wrote: I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280760 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Large CSV File
For that much data I am not sure I'd want it all loaded into CF vars, nor passed back and forth using lots and lots of queries. You may be better off loading the entire thing into an import table in your database, and then using process on thee DBMS to do the synchronization and/or analysis work (a scheduled stored procedure, a trigger on INSERT on that import table, or something like that). --- Ben -Original Message- From: Phillip M. Vector [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 10:06 AM To: CF-Talk Subject: Re: Large CSV File Is it all brand new records? or will most of the data after the first be already in there and need to be updated? I learned that the best way to parse it is to set up a upload once (using cffile) and then every week, load the csv file into an array and then compare it with the data already there. Of course, if it's always new data, see if you can convince them to do uploads every night so that you can handle the data without to much hit on your server. Les Mizzell wrote: I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| 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:280761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT:Great CSS Selector test suite
Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT:Great CSS Selector test suite
and then try running it with FF, IE, and now Safari. Safari is definitely a rump kicker in the javascript dept. On 6/12/07, Andy Matthews [EMAIL PROTECTED] wrote: Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large CSV File
DTS bulk import into SQL Server, then query away as usual. DTS is incredibly fast, and there are tutorials (google pengowrks and dts) on how exactly to set it up using stored procedures and CF. On 6/12/07, Les Mizzell [EMAIL PROTECTED] wrote: I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| 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:280764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT:Great CSS Selector test suite
Very interesting - on FF, Prototype was the only one without an error and it was nearly as quick as MooTools. On 6/12/07, Andy Matthews [EMAIL PROTECTED] wrote: Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT:Great CSS Selector test suite
Yeah. It always seems to be the hardest to work with and every library seems to have issues with it at some point. I wish Apple would get off their rears and help out with this. Its shameful when IE performs better than Safari. Rey Zaphod Beeblebrox wrote: and then try running it with FF, IE, and now Safari. Safari is definitely a rump kicker in the javascript dept. On 6/12/07, Andy Matthews [EMAIL PROTECTED] wrote: Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Large CSV File
Eek! A file of that size and complexity needs to be handled by the database, putting it into an array would be a nightmare. It would be fine for smaller files, but something that size would probably push the server over. Les, what database are you using? *Crosses fingers he says something decent :-D I would import into the database and then do the manipulation there with stored procs for sure. Rob -Original Message- From: Phillip M. Vector [mailto:[EMAIL PROTECTED] Sent: 12 June 2007 15:06 To: CF-Talk Subject: Re: Large CSV File Is it all brand new records? or will most of the data after the first be already in there and need to be updated? I learned that the best way to parse it is to set up a upload once (using cffile) and then every week, load the csv file into an array and then compare it with the data already there. Of course, if it's always new data, see if you can convince them to do uploads every night so that you can handle the data without to much hit on your server. Les Mizzell wrote: I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large CSV File
Another option will be to use ODBC file connection if you are on windows. HTH On 6/12/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Eek! A file of that size and complexity needs to be handled by the database, putting it into an array would be a nightmare. It would be fine for smaller files, but something that size would probably push the server over. Les, what database are you using? *Crosses fingers he says something decent :-D I would import into the database and then do the manipulation there with stored procs for sure. Rob -Original Message- From: Phillip M. Vector [mailto:[EMAIL PROTECTED] Sent: 12 June 2007 15:06 To: CF-Talk Subject: Re: Large CSV File Is it all brand new records? or will most of the data after the first be already in there and need to be updated? I learned that the best way to parse it is to set up a upload once (using cffile) and then every week, load the csv file into an array and then compare it with the data already there. Of course, if it's always new data, see if you can convince them to do uploads every night so that you can handle the data without to much hit on your server. Les Mizzell wrote: I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Large CSV File
Yeah. After I hit send, I realized my mistake. :) I stand corrected. Robert Rawlins - Think Blue wrote: Eek! A file of that size and complexity needs to be handled by the database, putting it into an array would be a nightmare. It would be fine for smaller files, but something that size would probably push the server over. Les, what database are you using? *Crosses fingers he says something decent :-D I would import into the database and then do the manipulation there with stored procs for sure. Rob -Original Message- From: Phillip M. Vector [mailto:[EMAIL PROTECTED] Sent: 12 June 2007 15:06 To: CF-Talk Subject: Re: Large CSV File Is it all brand new records? or will most of the data after the first be already in there and need to be updated? I learned that the best way to parse it is to set up a upload once (using cffile) and then every week, load the csv file into an array and then compare it with the data already there. Of course, if it's always new data, see if you can convince them to do uploads every night so that you can handle the data without to much hit on your server. Les Mizzell wrote: I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280769 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT:Great CSS Selector test suite
Yeah. The PT have made some tremendous improvements in DOM querying in v1.5x. Rey... James Holmes wrote: Very interesting - on FF, Prototype was the only one without an error and it was nearly as quick as MooTools. On 6/12/07, Andy Matthews [EMAIL PROTECTED] wrote: Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large CSV File
Les, what database are you using? *Crosses fingers he says something decent :-D MySQL I really see no way to do anything with this without doing a database import first. What's going to make it interesting is that the file is named according to date, so it will have a different name each time they ftp it over. I gotta figure how to automate something with that. Otherwise, I get to do it manually each week (and probably will the first few times anyway to be sure it's working correctly) ~| 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:280771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form strangeness
Hello all, Quick question, I'm wondering if anyone has ever encountered this. I have a page that submits a form back to itself. I'm testing for the contents by doing a simple cfdump for the form scope. When I submit the form, the page reloads, and nothing submits. The form scope shows an empty structure. Here's what it looks like: cfif IsDefined(Form.MM_SendCampaign) and Form.MM_SendCampaign eq Submit cfinvoke component=com.members.congress method=processCampaign returnvariable=message cfinvokeargument name=form value=#form# cfinvokeargument name=orgid value=#application.app.orgid# cfinvokeargument name=memberid value=#client.memberid# cfinvokeargument name=campaignid value=#request.rq.campaignid# /cfinvoke !--- OUTPUT RESULTS FROM CAMPAIGN PROCESSING --- h3cfoutput#message#/cfoutput/h3 /cfif FORM METHOD=POST ACTION=#actionpage# div id=campaigninfo div id=memberform Some logic to determine which fields to display. This is working properly /div h5img src=/images/alert.gifFinished? input name=submit type=submit value=Send my message!/h5 /div input type=hidden name=MM_SendCampaign value=Submit /FORM -- Charles Sheehan-Miles http://www.sheehanmiles.com Author of Republic: A Novel of America's Future http://www.amazon.com/gp/product/0979411424?tag=sheehanmiles-20 ~| 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:280772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Large CSV File
On Tuesday 12 Jun 2007, Les Mizzell wrote: to date, so it will have a different name each time they ftp it over. I Just grab the newest file from the directory. -- Tom Chiverton Helping to completely unleash fourth-generation data on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the 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. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Large CSV File
What's going to make it interesting is that the file is named according to date, so it will have a different name each time they ftp it over. I Shouldn't be a problem, just have them ftp it to an empty directory then use a cfdirectory to get the name of the only file in the directory, do your import, then either move the file to an archive folder if you will need to refer back to it or delete the file if not (either with cffile) then the directory will be empty for next time. -- Jay ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AJAX Libraries
I suggest experimenting with a few to see what best supports your needs. Folks have already given a lot of great suggestions. What I found, as I am working on a VERY AJAX intensive app right now, is that all of the libraries have strengths and weaknesses, and you may run into a deal breaker weakness, or a must have strength with a particular library that will help shape your decision. I do highly suggest playing the the various Ajax stuff in the CF8 beta - it's pretty compelling, and will greatly minimize the amount of JavaScript you need to write. If its capabilities fit your needs, it is probably the easiest path. One very interesting alternative I didn't see mentioned is the Google Web Toolkit. (http://code.google.com/webtoolkit/) It uses a very unique approach - it's basically a set of Java libraries that generates JavaScript code. You write the UI/Ajax stuff in Java, compile it, and include the resulting JavaScript in your page. The advantage of writing in Java rather than JS directly is that Java is a much more sane language than JavaScript, and there are far far better Java development tools available than there are JS ones. It's much easier to debug, unit test, etc. You don't have to be a Java guru by any means. I got very far with a fairly rudimentary understanding of Java. In addition, there is a very nice (though commercial) Eclipse plug-in, GWT Designer (http://www.instantiations.com/gwtdesigner/index.html), that lets you visually build out the UI. I ended up not using GWT only because I had a couple of very specific requirements that I couldn't do cleanly enough - namely adding widgets to certain other widgets - but the latest release candidate solves that. Just some food for thought. On 6/9/07, Brook Davies [EMAIL PROTECTED] wrote: Hello, Does anyone have suggestions on an ajax library? I read that CF8 has an integrated AJAX 'gateway', but is that really worth waiting for? There most be some good AJAX libraries out there. Has anyone had success with cfajax or mxAjax? Brook ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280775 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT:Great CSS Selector test suite
actually, on my tests, Safari was the fastest by far. IE was the performance dog. On 6/12/07, Rey Bango [EMAIL PROTECTED] wrote: Yeah. It always seems to be the hardest to work with and every library seems to have issues with it at some point. I wish Apple would get off their rears and help out with this. Its shameful when IE performs better than Safari. Rey Zaphod Beeblebrox wrote: and then try running it with FF, IE, and now Safari. Safari is definitely a rump kicker in the javascript dept. On 6/12/07, Andy Matthews [EMAIL PROTECTED] wrote: Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280776 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: PHP and MYSQL install help.
hi there... i know, completely wrong forum however, since im a lifer here, and i know there are some gurus that can quickly help, please read... i can pay for 1 hour of time, if someone can please just help me. i need to get slideshowpro director working on my box. i have everything installed, and mysql/php look like they are working right, i just cant get the app to work as it should. i can pay, i just need someone who KNOWS PHP and MYSQL and can do it quickly to do so... anyone thanks! -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT:Great CSS Selector test suite
Performance isn't the issue, its compatibility. Safari is consistently the hardest browser to accommodate for. Rey Zaphod Beeblebrox wrote: actually, on my tests, Safari was the fastest by far. IE was the performance dog. On 6/12/07, Rey Bango [EMAIL PROTECTED] wrote: Yeah. It always seems to be the hardest to work with and every library seems to have issues with it at some point. I wish Apple would get off their rears and help out with this. Its shameful when IE performs better than Safari. Rey Zaphod Beeblebrox wrote: and then try running it with FF, IE, and now Safari. Safari is definitely a rump kicker in the javascript dept. On 6/12/07, Andy Matthews [EMAIL PROTECTED] wrote: Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: PHP and MYSQL install help.
On Tuesday 12 Jun 2007, Tony wrote: some gurus that can quickly help, please read... Well, just this once :-) i can pay for 1 hour of time, if someone can please just help me. If you can paste the error message in to here, you can probably skip paying :-) -- Tom Chiverton Helping to proactively entrench open-source e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the 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. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the easiest way to do this?
Thanks a ton james! Let me ask you something. I've spent quite a bit of time integrating qForms into this page to get the organization dropdowns talkin' to one another. http://208.106.220.252/soundings/T8Report.cfm It all works perfectly. Choose test eval 1 in the eval dropdown. Then Business Technologies Information technologies ITN. At that point you can click refresh and I'm just submitting that form to populate the course dropdown. So depending on what you select in those three dropdowns, the form submits and it runs a query of courses with those criterias. THAT's the part I'd like to sub out with Ajax. So to get to my question, do you think I can integrate CFAjax for this? And it won't affect my qForms? I'm hopin' it will, since the target course dropdown really isn't involved in the qForm calls. Except the course dropdown IS in the qForm object. Just wanna make sure I don't waste alot of time on somethin' that may not work anyway. Thanks much, Will ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280781 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Large CSV File
CF may be able to do the same thing, but the fact that Ben Forta didn't mention it doesn't bode well for that being true. It's doable, via the text ODBC driver, but it's slow, and the SQL is a pain. I still think the best option is to do this in the DBMS. --- Ben -Original Message- From: James Wolfe [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 10:55 AM To: CF-Talk Subject: Re: Large CSV File If you have MS SQL at your disposal, load the stuff into a table and query that. You can use DTS (though that's harder to do on the fly) or you can simply use the BULK INSERT command which is super fast and is very easy. If you dont have a database available to you, you can use ASP (let the flaming begin). ASP can load a CSV file into a recordset using a custom query and is pretty fast at doing it. You can even customize the field names and field types using an config file. CF may be able to do the same thing, but the fact that Ben Forta didn't mention it doesn't bode well for that being true. I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| 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:280782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: PHP and MYSQL install help.
ok, here is a snippet of what i sent to the company who makes the app im trying to use... when i try to run this: http://localhost:81/ssp_director/mysql_test.php i get this: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\wamp\www\ssp_director\mysql_test.php on line 4 MySQL Error: Can't connect to MySQL server on 'localhost' (10061) when i try to connect during the initial setup of director, it gives me this... test SlideShowPro Director * Database Connection Error The connection to your database has failed. Make sure the database is up and operational and make sure none of your details have have changed in conf.php. SlideShowPro Director 1.0.9.9 (c) 2005-2007 Bradleyboy Productions and Dominey Design. All Rights Reserved. User Guide | Forums | SlideShowPro thanks! tony On 6/12/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 12 Jun 2007, Tony wrote: some gurus that can quickly help, please read... Well, just this once :-) i can pay for 1 hour of time, if someone can please just help me. If you can paste the error message in to here, you can probably skip paying :-) -- Tom Chiverton Helping to proactively entrench open-source e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280783 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the easiest way to do this?
Yes, that should work fine with mxAjax (or any of the other choices you have). It can even be triggered in the onChange on the tier5 box, just like the qforms scripts are triggered on the others. On 6/12/07, Will Tomlinson [EMAIL PROTECTED] wrote: Thanks a ton james! Let me ask you something. I've spent quite a bit of time integrating qForms into this page to get the organization dropdowns talkin' to one another. http://208.106.220.252/soundings/T8Report.cfm It all works perfectly. Choose test eval 1 in the eval dropdown. Then Business Technologies Information technologies ITN. At that point you can click refresh and I'm just submitting that form to populate the course dropdown. So depending on what you select in those three dropdowns, the form submits and it runs a query of courses with those criterias. THAT's the part I'd like to sub out with Ajax. So to get to my question, do you think I can integrate CFAjax for this? And it won't affect my qForms? I'm hopin' it will, since the target course dropdown really isn't involved in the qForm calls. Except the course dropdown IS in the qForm object. Just wanna make sure I don't waste alot of time on somethin' that may not work anyway. -- mxAjax / 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://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Large CSV File
A number of excellent database-based solutions have already been posted (and a database solution is probably preferred), but don't overlook CFHTTP. CFHTTP is actually quite good at parsing a CSV and spooling it into a CFQUERY. Depending on exactly what you want to do with your data, this may be a good solution. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT:Great CSS Selector test suite
looking at that test, firefox failed in exactly the same spot on each test as safari did. (11 failures for each, in the same tests for the same libraries) In what ways (truly interested) is Safari harder to accommodate for? On 6/12/07, Rey Bango [EMAIL PROTECTED] wrote: Performance isn't the issue, its compatibility. Safari is consistently the hardest browser to accommodate for. Rey Zaphod Beeblebrox wrote: actually, on my tests, Safari was the fastest by far. IE was the performance dog. On 6/12/07, Rey Bango [EMAIL PROTECTED] wrote: Yeah. It always seems to be the hardest to work with and every library seems to have issues with it at some point. I wish Apple would get off their rears and help out with this. Its shameful when IE performs better than Safari. Rey Zaphod Beeblebrox wrote: and then try running it with FF, IE, and now Safari. Safari is definitely a rump kicker in the javascript dept. On 6/12/07, Andy Matthews [EMAIL PROTECTED] wrote: Evaluates the speed of the various JS libraries at querying the dom. http://ajaxian.com/archives/slickspeed-css-selector-testsuite Interesting results. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| 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:280786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the easiest way to do this?
Yes, that should work fine with mxAjax (or any of the other choices you have). It can even be triggered in the onChange on the tier5 box, just like the qforms scripts are triggered on the others. oops, I meant mxAjax. I've been lookin' at so many the last day or so I can't keep'em straight. :) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: PHP and MYSQL install help.
On Tuesday 12 Jun 2007, Tony wrote: when i try to run this: http://localhost:81/ssp_director/mysql_test.php ... Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\wamp\www\ssp_director\mysql_test.php on line 4 MySQL Error: Can't connect to MySQL server on 'localhost' (10061) OK. 1) Is it running ? Is there a firewall blocking the port ? 2) Is the account created (remember MySQL accounts are tied to particular hosts, not just a username and password) ? -- Tom Chiverton Helping to competently network distributed niches on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the 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. ~| 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:280788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
var keyword in cfcs ... needed for query names?
When using the var keyword at the beginning of a cfc function, does one need to specify using var the variable names of any queries which are to be defined within that cfc function? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280789 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the easiest way to do this?
Yes, this is a task well suited to AJAX. Perhaps look at AjaxCFC (the JQuery version) or mxAjax so that you get an integrated CF solution out of the box. I'm hijackin' code from yer blog right now. Gonna try and make this work. I'll keep ya posted. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280790 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large CSV File
If you have MS SQL at your disposal, load the stuff into a table and query that. You can use DTS (though that's harder to do on the fly) or you can simply use the BULK INSERT command which is super fast and is very easy. If you dont have a database available to you, you can use ASP (let the flaming begin). ASP can load a CSV file into a recordset using a custom query and is pretty fast at doing it. You can even customize the field names and field types using an config file. CF may be able to do the same thing, but the fact that Ben Forta didn't mention it doesn't bode well for that being true. I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: var keyword in cfcs ... needed for query names?
Absolutely. You must specify var scoping for ALL method local variables including query names and loop indexes. On 6/12/07, D F [EMAIL PROTECTED] wrote: When using the var keyword at the beginning of a cfc function, does one need to specify using var the variable names of any queries which are to be defined within that cfc function? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280791 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: var keyword in cfcs ... needed for query names?
Absolutely. Queries are usually the first thing overlooked and need to be var scoped because in the end it is just a variable holding complex data. Always var your query names to keep the data local to the function. Dan Vega http://www.danvega.org/blog/ On 6/12/07, D F [EMAIL PROTECTED] wrote: When using the var keyword at the beginning of a cfc function, does one need to specify using var the variable names of any queries which are to be defined within that cfc function? ~| 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:280792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form strangeness
Be sure the form tag, which includes #actionpage# is within a cfoutput block. Take a look at the source of your form to be certain it's set to post to the right page. Koen ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280793 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Conditional SQL
I currently have a (very complex) query in the format... SELECT Title, ProductID FROM aTable WHERE Stock 0 cfif len(trim(queryParams.productgroupid)) GT 0 AND ProductGroupID = #val(productgroupid)# /cfif I wish to move this query into MSSQL server for performance reasons, how do I go about running the conditional code? I have tried... DECLARE @productgroupid bigint; SET @productgroupid = 5; SELECT Title, ProductID FROM aTable WHERE Stock 0 IF @productgroupid 0 AND m.ProductGroupID = @productgroupid But just get syntax errors, is there a way to get the IF...ELSE into the sql or do I have to reformat it into... IF @productgroupid 0 SELECT fields FROM tables WHERE someCondition AND anotherCondition ELSE SELECT fields FROM tables WHERE someCondition Because that is going to make for some really unreadable and LONG code once all my conditions are coded for! -- Jay ~| 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:280794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conditional SQL
Try this: DECLARE @productgroupid bigint; SET @productgroupid = 5; SELECT Title, ProductID FROM aTable WHERE Stock 0 AND (m.ProductGroupID = @productgroupid AND @productgroupid 0) Koen ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: var keyword in cfcs ... needed for query names?
so a simple ... cfset var qryMyQuery = would do, or is there a better way? Absolutely. Queries are usually the first thing overlooked and need to be var scoped because in the end it is just a variable holding complex data. Always var your query names to keep the data local to the function. Dan Vega http://www.danvega.org/blog/ On 6/12/07, D F [EMAIL PROTECTED] wrote: When using the var keyword at the beginning of a cfc function, does one need to specify using var the variable names of any queries which are to be defined within that cfc function? ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280796 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conditional SQL
You can do the following cfparam name=queryParams.productgroupid default=-10001 and then run the query as cfquery DECLARE @productgroupid int; SET @productgroupid = #queryParams.productgroupid#; SELECT Title, ProductID FROM aTable WHERE Stock 0 AND m.ProductGroupID = coalesce(nullIf(@productgroupid,-10001),m.ProductGroupID) /cfquery What that will do is the following: if @productgroupid is -10001 it will set it to null, and then the coalesce will set the right side of the where clause to m.ProductGroupID which will mean the where clause says AND m.ProductGroupID = m.ProductGroupID which is always true and therefore not limiting. If however its not -10001, then it will run the actual query as you want it to. I currently have a (very complex) query in the format... SELECT Title, ProductID FROM aTable WHERE Stock 0 cfif len(trim(queryParams.productgroupid)) GT 0 AND ProductGroupID = #val(productgroupid)# /cfif I wish to move this query into MSSQL server for performance reasons, how do I go about running the conditional code? I have tried... DECLARE @productgroupid bigint; SET @productgroupid = 5; SELECT Title, ProductID FROM aTable WHERE Stock 0 IF @productgroupid 0 AND m.ProductGroupID = @productgroupid But just get syntax errors, is there a way to get the IF...ELSE into the sql or do I have to reformat it into... IF @productgroupid 0 SELECT fields FROM tables WHERE someCondition AND anotherCondition ELSE SELECT fields FROM tables WHERE someCondition Because that is going to make for some really unreadable and LONG code once all my conditions are coded for! -- Jay ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280797 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form strangeness
Ok ... Now this is weird. With some more exploring on this, I found that when the form is submitted, I get the following in the cgi scope: Content_type: application/x-www-form-urlencoded Request_method: GET Even though the form is clearly a POST. Has anyone encountered this? On 6/12/07 10:45 AM, Charles Sheehan-Miles [EMAIL PROTECTED] wrote: Hello all, Quick question, I'm wondering if anyone has ever encountered this. I have a page that submits a form back to itself. I'm testing for the contents by doing a simple cfdump for the form scope. When I submit the form, the page reloads, and nothing submits. The form scope shows an empty structure. Here's what it looks like: cfif IsDefined(Form.MM_SendCampaign) and Form.MM_SendCampaign eq Submit cfinvoke component=com.members.congress method=processCampaign returnvariable=message cfinvokeargument name=form value=#form# cfinvokeargument name=orgid value=#application.app.orgid# cfinvokeargument name=memberid value=#client.memberid# cfinvokeargument name=campaignid value=#request.rq.campaignid# /cfinvoke !--- OUTPUT RESULTS FROM CAMPAIGN PROCESSING --- h3cfoutput#message#/cfoutput/h3 /cfif FORM METHOD=POST ACTION=#actionpage# div id=campaigninfo div id=memberform Some logic to determine which fields to display. This is working properly /div h5img src=/images/alert.gifFinished? input name=submit type=submit value=Send my message!/h5 /div input type=hidden name=MM_SendCampaign value=Submit /FORM -- Charles Sheehan-Miles http://www.sheehanmiles.com Author of Republic: A Novel of America's Future http://www.amazon.com/gp/product/0979411424?tag=sheehanmiles-20 ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280799 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
Yeah, it is. Actually, it's going to the right page, but I found that for some reason its doing a GET instead of a POST I looked through the archives and found some folks who've had the same problem but only with IE7. I'm hitting this on all browsers. On 6/12/07 12:10 PM, koen darling [EMAIL PROTECTED] wrote: Be sure the form tag, which includes #actionpage# is within a cfoutput block. Take a look at the source of your form to be certain it's set to post to the right page. Koen ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conditional SQL
You could use the CASE statement instead. Or you could write a stored procedure which does exactly the thing you want. DECLARE @productgroupid bigint; SET @productgroupid = 5; IF @productgroupid 0 BEGIN SELECT Title, ProductID FROM aTable WHERE Stock 0 AND m.ProductGroupID = @productgroupid END ELSE BEGIN SELECT Title, ProductID FROM aTable WHERE Stock 0 AND SOMTETHINGELSE END Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ James Smith schrieb: I currently have a (very complex) query in the format... SELECT Title, ProductID FROM aTable WHERE Stock 0 cfif len(trim(queryParams.productgroupid)) GT 0 AND ProductGroupID = #val(productgroupid)# /cfif I wish to move this query into MSSQL server for performance reasons, how do I go about running the conditional code? I have tried... DECLARE @productgroupid bigint; SET @productgroupid = 5; SELECT Title, ProductID FROM aTable WHERE Stock 0 IF @productgroupid 0 AND m.ProductGroupID = @productgroupid But just get syntax errors, is there a way to get the IF...ELSE into the sql or do I have to reformat it into... IF @productgroupid 0 SELECT fields FROM tables WHERE someCondition AND anotherCondition ELSE SELECT fields FROM tables WHERE someCondition Because that is going to make for some really unreadable and LONG code once all my conditions are coded for! -- Jay ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280800 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conditional SQL
I wish to move this query into MSSQL server for performance reasons, how do I go about running the conditional code? I have tried... I'm not sure you are going to get the performance benefit you are looking for. Doing the conditional processing in SQL isn't necessarily going to be faster...but you could do... DECLARE @productgroupid bigint; SET @productgroupid = 5; SELECT Title, ProductID FROM aTable WHERE Stock 0 AND ProductGroupID = CASE WHEN @productgroupid 0 THEN @productgroupid ELSE ProductGroupID END ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Server Cluster
-Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 5:51 PM To: CF-Talk Subject: Re: Server Cluster Actually, you can't just use the same copy of Windows Server in multiple virtual machines. Microsoft has a VM licensing calendar here: http://www.microsoft.com/windowsserver2003/howtobuy/licensing/calculator.m sp x Good catch, I would have missed that. This is weird. I remember reading somewhere that an Enterprise version of Windows lets you run unlimited virtual instances on one physical machine. According to this, you need the datacenter edition. Does anyone else remember reading what I did? Russ ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280802 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: var keyword in cfcs ... needed for query names?
What was the reason for doing this again... to prevent race conditions? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280803 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: var keyword in cfcs ... needed for query names?
To keep them private to the functions. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: D F To: CF-Talk Sent: Tue Jun 12 17:33:19 2007 Subject: Re: var keyword in cfcs ... needed for query names? What was the reason for doing this again... to prevent race conditions? ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: var keyword in cfcs ... needed for query names?
What was the reason for doing this again... to prevent race conditions? You declare local variables in a function so that they don't clobber any variables with the same names in the script that calls the function. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280805 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conditional SQL
James Smith wrote: SELECT Title, ProductID FROM aTable WHERE Stock 0 cfif len(trim(queryParams.productgroupid)) GT 0 AND ProductGroupID = #val(productgroupid)# /cfif I wish to move this query into MSSQL server for performance reasons Which performance reasons? Why do you expect an improvement of the performance from moving the condition to the DB? Jochem ~| 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:280806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: var keyword in cfcs ... needed for query names?
On 6/12/07, Brian Kotek [EMAIL PROTECTED] wrote: Absolutely. You must specify var scoping for ALL method local variables including query names and loop indexes. you *SHOULD* ... not *MUST* Just being argumentative :) . If must was the right word, then CF would generate an error if you didn't. Personally, I think that'd be nice. but they'll never do it. I think they should automatically var scope EVERYTHING in a method unless otherwise specifically scoped elsewhere. Rick ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: var keyword in cfcs ... needed for query names?
On 6/12/07, Dave Watts [EMAIL PROTECTED] wrote: You declare local variables in a function so that they don't clobber any variables with the same names in the script that calls the function. That's for UDFs. For methods in CFCs, you var-declare local variables so they don't clobber any variables with the same names in the VARIABLES scope of the component itself. (I know Dave knows this - I'm just clarifying for folks reading who might not appreciate the difference) -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using sessions with Flash Remoting
Thanks James. That's about what I figured. I'm trying a very simplified example but no luck... Here's what I have so far: Application.cfm cfcomponent output=false cfset this.name = testSessions cfset this.applicationTimeout = createTimeSpan(0,0,1,0) cfset this.clientManagement = true cfset this.clientStorage = cookie cfset this.loginStorage = session cfset this.sessionManagement = true cfset this.sessionTimeout = createTimeSpan(0,0,0,30) cfset this.setClientCookies = true cfset this.setDomainCookies = false cfset this.scriptProtect = false cffunction name=onApplicationStart returnType=boolean output=false cfset Client.testVar = onApplicationStart cfreturn true /cffunction !--- I removed onApplicationEnd, onRequestStart, onRequestEnd, onError for clarity --- cffunction name=onSessionStart returnType=void output=false cfargument name=sessionScope required=yes cfargument name=appScope required=no cfset appScope.Client.testVar = onSessionStart /cffunction cffunction name=onSessionEnd returnType=void output=false cfset appScope.Client.testVar = onSessionEnd /cffunction /cfcomponent Then in my cfc (or cfm file), I have a function that contains this line: cfset Client.testVar = SomeOtherVar Any ideas? To me it seems like none of the methods in my Application.cfc are firing at all. The directory structure looks like so: /Application.cfc /test/index.cfm Thanks, John On Jun 12, 2007, at 3:26 AM, James Holmes wrote: Well onSessionStart and onSessionEnd must go in Application.cfc. This will need to go in a folder somewhere above the files that your remoting calls are hitting. I assume you're handling the cookies for sessions somewhere in your client code? On 6/12/07, John Robinson [EMAIL PROTECTED] wrote: I should note that I'm specifically having trouble with onSessionStart and onSessionEnd... basically where to put them (in someFile.cfc or Application.cfc or Application.cfm or?). What I want is to run a sql query in onSessionEnd, using the vars from the session (or cookie... I don't really care where they're stored, as long as they're unique to each user). ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: var keyword in cfcs ... needed for query names?
Also, aren't they deleted after the function runs? Meaning that they no longer take up that memory allocation? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 11:50 AM To: CF-Talk Subject: RE: var keyword in cfcs ... needed for query names? What was the reason for doing this again... to prevent race conditions? You declare local variables in a function so that they don't clobber any variables with the same names in the script that calls the function. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280810 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: var keyword in cfcs ... needed for query names?
Well, yeah they exist only within the functions duration - i.e. Call. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andy Matthews To: CF-Talk Sent: Tue Jun 12 18:00:27 2007 Subject: RE: var keyword in cfcs ... needed for query names? Also, aren't they deleted after the function runs? Meaning that they no longer take up that memory allocation? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 11:50 AM To: CF-Talk Subject: RE: var keyword in cfcs ... needed for query names? What was the reason for doing this again... to prevent race conditions? You declare local variables in a function so that they don't clobber any variables with the same names in the script that calls the function. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conditional SQL
the query is actually very complex involving several loops and a few conditional clauses and I am hoping that by sticking it all into a stored procedure it will be precompiled by MSSQL and therefore more efficient. On 12/06/07, Jochem van Dieten [EMAIL PROTECTED] wrote: James Smith wrote: SELECT Title, ProductID FROM aTable WHERE Stock 0 cfif len(trim(queryParams.productgroupid)) GT 0 AND ProductGroupID = #val(productgroupid)# /cfif I wish to move this query into MSSQL server for performance reasons Which performance reasons? Why do you expect an improvement of the performance from moving the condition to the DB? Jochem ~| 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:280812 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
Yeah, it is. Actually, it's going to the right page, but I found that for some reason its doing a GET instead of a POST Did you try giving your form tag a name attribute? Shouldn't make a difference but that's the only thing I see that's out of the ordinary. -- Josh ~| 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:280813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: var keyword in cfcs ... needed for query names?
I use cfset var local = StructNew() at the top of my functions, and then in the body of the function you could say cfquery name=local.queryName without worrying about it. You are basically creating a local scope for use within the function, and I find this much easier to stick with then varing each variable at the top of the function. Mark -Original Message- From: D F [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 12:18 PM To: CF-Talk Subject: Re: var keyword in cfcs ... needed for query names? so a simple ... cfset var qryMyQuery = would do, or is there a better way? Absolutely. Queries are usually the first thing overlooked and need to be var scoped because in the end it is just a variable holding complex data. Always var your query names to keep the data local to the function. Dan Vega http://www.danvega.org/blog/ On 6/12/07, D F [EMAIL PROTECTED] wrote: When using the var keyword at the beginning of a cfc function, does one need to specify using var the variable names of any queries which are to be defined within that cfc function? ~| 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:280814 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
Hmm. Yeah -- tried that. Tried to explicitly set the encoding type. I just went through the IIS logs, and they show the request as a POST. So it's somewhere in the processing in the Coldfusion side. I'm banging my head into the wall at this point. On 6/12/07 1:09 PM, Josh Nathanson [EMAIL PROTECTED] wrote: Yeah, it is. Actually, it's going to the right page, but I found that for some reason its doing a GET instead of a POST Did you try giving your form tag a name attribute? Shouldn't make a difference but that's the only thing I see that's out of the ordinary. -- Josh ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280815 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: var keyword in cfcs ... needed for query names?
And what of variables that aren't prefixed with var in a cfc? Does that mean that their memory allocation persists? if so, for how long? BTW That was a good idea to create a local structure and store all your local var variables there... good one. Also, aren't they deleted after the function runs? Meaning that they no longer take up that memory allocation? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 11:50 AM To: CF-Talk Subject: RE: var keyword in cfcs ... needed for query names? What was the reason for doing this again... to prevent race conditions? You declare local variables in a function so that they don't clobber any variables with the same names in the script that calls the function. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
I looked through the archives and found some folks who've had the same problem Yeap! Can you dump CGI.REQUEST_METHOD variable and see if it contains GET or POST? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
The form says POST CGI.REQUEST_METHOD shows GET IIS logs show POST Weird. On 6/12/07 1:23 PM, Claude Schneegans [EMAIL PROTECTED] wrote: I looked through the archives and found some folks who've had the same problem Yeap! Can you dump CGI.REQUEST_METHOD variable and see if it contains GET or POST? -- Charles Sheehan-Miles http://www.sheehanmiles.com Author of Republic: A Novel of America's Future http://www.amazon.com/gp/product/0979411424?tag=sheehanmiles-20 ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using sessions with Flash Remoting
On 6/12/07, John Robinson [EMAIL PROTECTED] wrote: cffunction name=onApplicationStart returnType=boolean output=false cfset Client.testVar = onApplicationStart This stores the client.testVar in VARIABLES.client.testVar which is essentially thrown away after the request runs. Then in my cfc (or cfm file), I have a function that contains this line: cfset Client.testVar = SomeOtherVar That is setting a different variable to any of the stuff in your Application.cfc. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: var keyword in cfcs ... needed for query names?
On 6/12/07, D F [EMAIL PROTECTED] wrote: And what of variables that aren't prefixed with var in a cfc? Does that mean that their memory allocation persists? if so, for how long? those variables exist as long as the components variables scope exists. Ie, until the request ends - unless the component is loaded into a persistent scope like thee application scope, and then those variables exist until the component is destroyed. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form strangeness
Has anyone encountered this? Yes, from time to time. Now you say that you are getting this error when the form resubmits itself? This is a new element in the puzzle. And also, you confirm that IIS received it as POST, then it looks like the problem is CF related. I thought that it was under IE 7 only, because the first time I noticed it, it happened only with users who recently switched for IE7, but it may be only a coincidence after all. Are you under CF 5 or CFMX? Are you having the problem EVERY time, or just from time to time? I'll check my code to see if I have forms that resumbit themselves. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
The form says POST CGI.REQUEST_METHOD shows GET Exactly the same problem here :-( ~| 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:280822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Nested structs in SOAP web service request
I'm trying to interact with the ebay API through SOAP, and I'm not able to run any methods that contain nested arguments. For example, this method call works fine because the arguments, version and title, are not nested: ws = CreateObject(webservice, urltosomewebservice/webservice.wsdl); theRequest = structNew(); theRequest.version = 123; theRequest.title = SomeTitle; ws.AddItem(AddItemRequest = #theRequest#); But if the method requires any nested arguments, CF does not properly map CF structs to the complex arguments that SOAP is expecting. For example, assume one of the arguments to AddItem is an Item object that has three attributes of its own: title, price, and quantity. Logically, I'd like to be able to do something like this, but this fails: ws = CreateObject(webservice, urltosomewebservice/webservice.wsdl); theRequest = structNew(); theRequest.version = 123; theRequest.item = structNew(); theRequest.item.title = ItemTitle; theRequest.item.price = 5.00; theRequest.item.quantity = 3; ws.AddItem(AddItemRequest = #theRequest#); I have not found any answers on the web. This page ( http://russ.michaels.me.uk/index.cfm/2007/5/18/ColdFusion-Web-Services-and-SOAP) says that he ran into the same problem and got around it by posting raw XML via CFHTTP, which I'd prefer not to do. The LiveDocs page for handling complex data types in web services ( http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/webservices6.htm) gives a fine example when none of the arguments are nested, but does not even mention the possibility of nested arguments to a web service. If anybody knows of a workaround or has a good resource for integrating CF with the ebay API, I'd really appreciate it. Thanks, Conan ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Execute a batch file with CFEXECUTE
Hello, Is it possible to use CFEXECUTE to excute a batch file? I'm trying to use the CFEXECUTE to execute a batch file i created to copy a file from one location to another. It does not work when I use CFEXECUTE to run batch file. Any assistance will be helpful. thanks Here is my code. cfexecute name=D:\CreditRpt.bat/cfexecute Here is my batch file net use z: \\112.5.6.40\d$ /user:admin pass4u copy D:\cme\cmecredits.txt z:\tmp net use z: /delete ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
Hmm. I'm using CFMX. I'm getting it consistently on this particular form, but what's strange is the form used to work -- I first observed the problem yesterday, and it has been absolutely consistent since then. I'm not sure what you mean about the form resubmitting itself. It's pretty basic: form on a page. User hits submit, and it should go back to the same page to process. Nothing there in the form scope. I've got a lot of forms in this application which operate the same way, and as far as I can tell, the rest of them work. Definitely cross-browser -- I've testing IE7, Camino, Firefox and Safari, all have the same problem. I did have it processing out of a CFC, but I've taken the logic out, placed it in a standalone template, and get the same failure. Now I'm eliminating chunks of code line by line to see if I can identify a particular element that is causing it. On 6/12/07 1:33 PM, Claude Schneegans [EMAIL PROTECTED] wrote: Has anyone encountered this? Yes, from time to time. Now you say that you are getting this error when the form resubmits itself? This is a new element in the puzzle. And also, you confirm that IIS received it as POST, then it looks like the problem is CF related. I thought that it was under IE 7 only, because the first time I noticed it, it happened only with users who recently switched for IE7, but it may be only a coincidence after all. Are you under CF 5 or CFMX? Are you having the problem EVERY time, or just from time to time? I'll check my code to see if I have forms that resumbit themselves. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the easiest way to do this?
Ok James, I'm gettin close! I have it runnin the query when the page loads,
which is of course not what I want. But this tells me things are workin.
I've modified the example on your blog. Now, I'm REAL slow when it comes to JS,
so bear with me here.
Here's my JS call:
script language=javascript
var url = cfoutput#ajaxUrl#/cfoutput;
cfoutput
function init() {
new mxAjax.Data({
executeOnLoad:true,
paramArgs: new
mxAjax.Param(url,{param:eval=#FORM.eval#,T7=#FORM.Tier7#,T6=#FORM.Tier6#,
cffunction:getCourses}),
postFunction: handleData
});
function handleData(response) {
var myHTMLOutput = JSON.parse(response);
document.getElementById(myTargetSpan).innerHTML =
myHTMLOutput;
}
}
addOnLoadEvent(function() {init();});
/cfoutput
/script
I left executeonload to true because This script is wrapped with a cfif
anyway. It won't fire when the page loads, so I'm good to go there.
Here's the function I stuck in example.cfc:
cffunction name=getCourses output=true
cfargument name=eval
cfargument name=T7
cfargument name=T6
cfset var courseArray = ArrayNew(1)
cfset var getCourses =
cfquery datasource=#APPLICATION.dsn# name=getCourses
SELECT
SectionID,
Section,
evalid,
Title,
StudentID,
Course
FROM tblstudentcourses
!--- Get courses for the evaluation selected ---
WHERE evalid =
cfqueryparam cfsqltype=cf_sql_integer value=#ARGUMENTS.eval#
!--- Filter courses according to any organizational filters submitted ---
cfif Len(ARGUMENTS.T7) AND ARGUMENTS.T7 NEQ All
AND orgtier7code =
cfqueryparam value=#ARGUMENTS.T7#
/cfif
cfif Len(ARGUMENTS.T6) AND ARGUMENTS.T6 NEQ All
AND orgtier6code =
cfqueryparam value=#ARGUMENTS.T6#
/cfif
/cfquery
cfsavecontent variable=showCourseMenu
select name=course
option value=AllAll/option
cfoutput query=getCourses
option value=#sectionid##section# - #title#/option
/cfoutput
/select
/cfsavecontent
cfreturn showCourseMenu
/cffunction
Up to this point, things are workin nicely. That menu pops right up when an
eval is chosen in the top dropdown - This is the coolest thing I've ever done!
Here's my trouble. How do I get it to fire off when any of those organization
filters are changed?
I already have an onChange in them for the qForms. Here's an example of Tier 7
(stripping out the conditional stuff for easier reading:
select name=Tier7
onChange=objForm.Tier6.populate(stcTiers[objForm.Tier7.getValue()], null,
null, stcBlank);
option value=AllAll/option
cfoutput query=get7OrgTiers group=orgtier7id
cfoutput group=orgtier7id
option value=#orgtier7code##orgtier7title#/option
/cfoutput
/select
How do you fire this thing off? Can it be appended to the onChange?
Thanks a ton james!
Will
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280826
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Execute a batch file with CFEXECUTE
Run cmd.exe and pass the batch file to it, see http://www.forta.com/blog/index.cfm/2006/7/31/Using-CFEXECUTE-To-Execute-Com mand-Line-Utilities. --- Ben -Original Message- From: Calvin Trinh [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 1:30 PM To: CF-Talk Subject: Execute a batch file with CFEXECUTE Hello, Is it possible to use CFEXECUTE to excute a batch file? I'm trying to use the CFEXECUTE to execute a batch file i created to copy a file from one location to another. It does not work when I use CFEXECUTE to run batch file. Any assistance will be helpful. thanks Here is my code. cfexecute name=D:\CreditRpt.bat/cfexecute Here is my batch file net use z: \\112.5.6.40\d$ /user:admin pass4u copy D:\cme\cmecredits.txt z:\tmp net use z: /delete ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Form strangeness
Is this perhaps not the only form.. on the page? -Original Message- From: Charles Sheehan-Miles [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 11:14 AM To: CF-Talk Subject: Re: Form strangeness Ok ... Now this is weird. With some more exploring on this, I found that when the form is submitted, I get the following in the cgi scope: Content_type: application/x-www-form-urlencoded Request_method: GET Even though the form is clearly a POST. Has anyone encountered this? On 6/12/07 10:45 AM, Charles Sheehan-Miles [EMAIL PROTECTED] wrote: Hello all, Quick question, I'm wondering if anyone has ever encountered this. I have a page that submits a form back to itself. I'm testing for the contents by doing a simple cfdump for the form scope. When I submit the form, the page reloads, and nothing submits. The form scope shows an empty structure. Here's what it looks like: cfif IsDefined(Form.MM_SendCampaign) and Form.MM_SendCampaign eq Submit cfinvoke component=com.members.congress method=processCampaign returnvariable=message cfinvokeargument name=form value=#form# cfinvokeargument name=orgid value=#application.app.orgid# cfinvokeargument name=memberid value=#client.memberid# cfinvokeargument name=campaignid value=#request.rq.campaignid# /cfinvoke !--- OUTPUT RESULTS FROM CAMPAIGN PROCESSING --- h3cfoutput#message#/cfoutput/h3 /cfif FORM METHOD=POST ACTION=#actionpage# div id=campaigninfo div id=memberform Some logic to determine which fields to display. This is working properly /div h5img src=/images/alert.gifFinished? input name=submit type=submit value=Send my message!/h5 /div input type=hidden name=MM_SendCampaign value=Submit /FORM -- Charles Sheehan-Miles http://www.sheehanmiles.com Author of Republic: A Novel of America's Future http://www.amazon.com/gp/product/0979411424?tag=sheehanmiles-20 ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form strangeness
In my case, the problem happens under CF5. The problem might be occuring ever time under some circumstances, but I've never been able to reproduce it. Now I'm eliminating chunks of code line by line to see if I can identify a particular element that is causing it. Very good way to find the problem. Please let us know if you find something. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form strangeness
All right. I don't have a clue why this worked. The application uses a function called in application.cfc to deconstruct friendly urls into ... Well ... Not so friendly urls. The page I was calling: /page/memberhome/action/action/campaignid/12 When I changed the form to call: /index.cfm?page=memberhomeaction=actioncampaignid=12 It worked fine. What doesn't make sense is that I use the same url scheme everywhere else in my app, and the forms work just fine. Hmmm. On 6/12/07 1:52 PM, Claude Schneegans [EMAIL PROTECTED] wrote: In my case, the problem happens under CF5. The problem might be occuring ever time under some circumstances, but I've never been able to reproduce it. Now I'm eliminating chunks of code line by line to see if I can identify a particular element that is causing it. Very good way to find the problem. Please let us know if you find something. -- Charles Sheehan-Miles http://www.sheehanmiles.com Author of Republic: A Novel of America's Future http://www.amazon.com/gp/product/0979411424?tag=sheehanmiles-20 ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form strangeness
The page I was calling: /page/memberhome/action/action/campaignid/12 When I changed the form to call: /index.cfm?page=memberhomeaction=actioncampaignid=12 It worked fine. Hmmm... Could it be some problem with the cache? The first address shows no parameter, so it could be interpreted as the same page as the first call to the form which was probably with method GET by default. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form strangeness
On 6/12/07, Claude Schneegans [EMAIL PROTECTED] wrote: The page I was calling: /page/memberhome/action/action/campaignid/12 When I changed the form to call: /index.cfm?page=memberhomeaction=actioncampaignid=12 It worked fine. Hmmm... Could it be some problem with the cache? The first address shows no parameter, so it could be interpreted as the same page as the first call to the form which was probably with method GET by default. Actually, it sounds like a redirect issue. Do you have a custom 404 error handler defined in IIS or are you using something like isapi-rewrite to restructure your url? If your rewrite mechanism is not working properly then the 404 would redirect you using a GET, not the original POST. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| 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:280832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conditional SQL
James Smith wrote: the query is actually very complex involving several loops and a few conditional clauses Your query has several loops? You mean you actually use the new hierargical query features of MS SQL 2005? Or does the CF code that generates the query involve several loops and conditions? and I am hoping that by sticking it all into a stored procedure it will be precompiled by MSSQL and therefore more efficient. So what part of the current execution time is spent in the compilation step? Because that is the maximum you will gain from it being precompiled. Jochem ~| 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:280833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form strangeness
The application uses a function called in application.cfc to deconstruct friendly urls into ... Well ... Not so friendly urls. Ok, but how ist the correct template finally called by the function? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
