Re: cf open shopping cart
lol. Now that is just funny Dave. First off, I'm offended. I play PS2...not xbox. Second, conflict of interests means my company is building an e-commerce system (database already done and is quite intense in terms of functionality) that won't be free so why would I take the same knowledge (or even files) to an OS project that will directly compete with our (possibly flagship) project? I wouldn't and, I'm guessing, neither would the majority of the people in my position (that's like Adobe building an open source Flash IDE...why would they do that? For the love of the community? Not if Flash 9 (and so on) is still being built and sold). Initially the project sounded like it was only a shopping cart (not a full site + database) so I was willing to write shopping cart code (add, delete, modify, payment gateways, etc) or use code I already have from prior e-comm sites. Doing a full blown site+db simply conflicts with our e-comm product. If you want previous code I've written for Authorize.net I will gladly pass it on. It isn't encapsulated but I can delete the extra. Don't be so offensive man. Calm down and bang it out yourself if you have to. Like someone said, taking the app on by yourself, or with a very small team IMO, should yield better results than throwing 500 developers on one project. In doing this you end up right where you are now...no one to help which is most likely due to no agreement on the project specs (seemed to be the entire conversation when I listened to the posts). So you know (and can remove me from your low as dirt selfish cf developer list), we have built a project the community can use for free. It hasn't launched yet (few more bugs to tweak and an interface to throw on it) but hopefully it will benefit the community. It isn't anything new but hopefully the wow factor will help it out a bit. As a personal note, ask me before making such strong statements and showing your ignorance in relation to my intentions, abilities, and/or desires. If you want to discuss that statement I suggest take it off list (email, phone, IM, whatever) and we can continue from there. BTW, PHP may have a larger following because it is...ummm...FREE! I am a PHP developer and on a php list. The main argument folks have is it is free. Well, and the fact you have to use tags in CF...they don't like that. And what you do with the php ppl is your business. ;-) On 1/9/06, dave [EMAIL PROTECTED] wrote: No but you can help and thats the point, its pretty pathic when there are thousands of ppl on the list and there are like 3 ppl who volunteered to help. And the message was posted here to try and get a few of you off your fat overweight asses and lend a hand to help out the community. You can bitch that php has all these cool free things but very few of you actually do anything besides bitch about it ( this isnt including the people like ray and james and those who do stuff). A conflict of interest? What was your xbox calling? Funny how ppl dont have time to help but they can go home and play xbox all night but not to help a community project. Yeah I coulda posted to the cart list but I'm quite sure all 3 of us on there are aware.. We can't all be held accountable for the project You are right... Some mystical magical force straight outta the xbox is gunna come do it all for us. Maybe we should just ask the php ppl to come wipe our asses and build us stuff, since obviously our community is lacking so bad that we can't get-r-done. That's cool I wont ask about it anymore or try to help out the community since most of you are just so great that you are above helping out ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: John C. Bland II [EMAIL PROTECTED] Sent: Monday, January 09, 2006 6:16 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cf open shopping cart Not the cf-talk group. We can't all be held accountable for the project not going anywhere. I started but soon let everyone know it was a conflict in interest, once I realized the full scope, and I backed out. So, to post your message here seems inappropriate. IMO, you should post to the site/forum where the project was being developed since everyone on it is directly related to the project. On 1/9/06, dave wrote: And you are.. saying its pretty damn pathetic that no one is helping out with the damn project. been what? 2 months now and whats been done? nothing. and don't you think that is pathetic of us as a group? I do. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Andy Sent: Monday, January 09, 2006 5:27 PM To: CF-Talk Subject: RE: cf open shopping cart And you are..
Big Gateways
Hi, I have a gateway CFC that returns queries for medications. Medications are complex things that have many properties and require many tables to store all the info. As well, there are hundreds of different ways to query the meds. My question is how do people break up their methods in these cases? In one extreme you can have 1 method that accepts many arguments, does some conditional processing and returns a query based on your arguments. In the other extreme you can have hundreds of methods that take no arguments and return a specific query for your specific situation. The advantage of the former case is that it's easy to maintain and make updates since there is only one query. But because of all the conditional processing, every query will run slower. In the latter case, your queries run very fast and serve one simple, logical purpose, but you have hundreds to write and maintain with a lot of code duplication. Like if I needed to change the FROM clause, I'd have to do it for every single one. Does anyone have a good rule of thumb of how to break up their queries? Cheers, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
Well I for one was watching this project kick off with interest. Initially I saw it as an opportunity for me to contribute something back to the community that has been so good to me over quite a few years now. I thought I would gain from it because it would also be good for me to be involved in a collaborative project, because I do nearly everything by myself these days. I know I have some expertise in some aspects of this project, and nearly no expertise in other aspects so I thought I could contribute as well as learn. So i was about to put my hand up and say I'll dive in and help. Then the bickering started. Back and forth about what it was going to be, and what it was going to do. First it was going to be like this, then like that, then like something else, without anyone offering a clear idea of what it was going to be. uh oh, I said to myself this looks just like x - a nighmare of a project I was involved in years ago and it'll be ages before anyone gets anywhere with it. I was about to suggest a functional spec, when someone else pooh-poohed the use of CFCs. Someone said they didnt want to use this new-fangled CFC stuff.They wanted to write the shopping cart using more conventional procedural code. To be frank I saw this as adding nothing to the cf community. there is already an excellent procedural shopping cart thanks to Ben Forta in the CFWACK and quite frankly I dont see what you could do in an open source cart that wasn't already there in the book, and which I've already used, adapted and modified several times. I didnt say anything at the time because most of the participants seemed to like that approach. Rather than try to rain on the parade, I put my hand back down and decided to go my own way. If you guys want to build a new procedural shopping cart, good luck to you, I'll be standing there applauding when and if it's finished. However if anyone wants to take this project in a different direction, I am more than willing to put my shoulder to the wheel.But I'd say there has to be a few things different: - someone has to be elected, appointed or self-appointed as the project leader (look at the success of the model-glue project - due in no small part to the fact that Joe Rinehart has put his personal goolies on the line and has taken charge of it) - There has to be a clear definition of what the project is for. I'm afraid, open source shopping cart doesnt cut it. There are already several that if not free are close to it. Most people either have CFWACK or know someone who has and there have ready access to how to build a procedural shopping cart..What's going to be different about this one? From these two things will flow a proper functional spec and a direction to the project. At this point, since I havent been following the details of the project, you may well have defined the project, but I havent seen it, so I cant offer my help. I'll be glad to add whatever skills and energy I have that might contribute to an open source shopping cart if it's going to be a project that works. And if it's going to add something new to the world. Just another 'me too' shopping cart isnt worth the effort, except that it gives the contributors experience and new skills. And to put it bluntly, I'm interested in developing my skills in the use of CFCs and OOP, not just redoing something I've been doing for eight years now. And that fact that you're lashing about Dave, tells me this project is a mess right now. It needs an objective that will inspire people to be involved. The CFEclipse project has inspired it's contributors because they saw deficiencies in the existing tools and figured they could do a better one. I reckon if they'd started out saying lets build a development tool that's like notepad with a couple of other features it would have gone nowhere. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229000 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: lets give these ppl hell!
Ken, Is it really necessary to disparage an ad campaign of a company that might just have people on this list? (READ THE SIGNATURE) Thanks, Steve -- Steve Durette Mgr - Results Mechanization ATT -Original Message- From: Ken Ketsdever [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 6:15 PM To: CF-Talk Subject: RE: lets give these ppl hell! Consider yourself part of the lucky half. -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 3:09 PM To: CF-Talk Subject: Re: lets give these ppl hell! Also Talk about marketing to the masses. I'm still trying to figure out this one. ATT Online Campaign to Reach Half of Web Users http://www.marketingvox.com/archives/2006/01/09/att_online_campaign_to_r each_half_of_web_users/ The massive ATT campaign launched on New Year's Day will hit the web on Jan. 9 with a splash that the company says will be among the largest in internet history, according to AdAge (via MediaBuyerPlanner). Just about half of all web users - about 137.8 million unique users - will see ads for the newly merged company. I haven't seen it yet... Casey On 1/9/06, Bryan Stevenson [EMAIL PROTECTED] wrote: and how does one get 800,000 friends Dave? ;-) Me thinks that's the hard part if you're not a cute young lass showing a little skin. I mean come onguys are the reason sex sells!! Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229001 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Hear hear! Mike Same experience I had and that's not being critical just a factual observation. I too wanted to learn from and participate in such a project b/c I'm a sole developer who doesn't have that group project opportunity. But after a several days of seeing the same thing you saw, it was clear the organization and direction of this project was unclear, so I bailed. Maybe things have changed at this point, I don't know Tim -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 6:06 AM To: CF-Talk Subject: Re: cf open shopping cart Well I for one was watching this project kick off with interest. Initially I saw it as an opportunity for me to contribute something back to the community that has been so good to me over quite a few years now. I thought I would gain from it because it would also be good for me to be involved in a collaborative project, because I do nearly everything by myself these days. I know I have some expertise in some aspects of this project, and nearly no expertise in other aspects so I thought I could contribute as well as learn. So i was about to put my hand up and say I'll dive in and help. Then the bickering started. Back and forth about what it was going to be, and what it was going to do. First it was going to be like this, then like that, then like something else, without anyone offering a clear idea of what it was going to be. uh oh, I said to myself this looks just like x - a nighmare of a project I was involved in years ago and it'll be ages before anyone gets anywhere with it. I was about to suggest a functional spec, when someone else pooh-poohed the use of CFCs. Someone said they didnt want to use this new-fangled CFC stuff.They wanted to write the shopping cart using more conventional procedural code. To be frank I saw this as adding nothing to the cf community. there is already an excellent procedural shopping cart thanks to Ben Forta in the CFWACK and quite frankly I dont see what you could do in an open source cart that wasn't already there in the book, and which I've already used, adapted and modified several times. I didnt say anything at the time because most of the participants seemed to like that approach. Rather than try to rain on the parade, I put my hand back down and decided to go my own way. If you guys want to build a new procedural shopping cart, good luck to you, I'll be standing there applauding when and if it's finished. However if anyone wants to take this project in a different direction, I am more than willing to put my shoulder to the wheel.But I'd say there has to be a few things different: - someone has to be elected, appointed or self-appointed as the project leader (look at the success of the model-glue project - due in no small part to the fact that Joe Rinehart has put his personal goolies on the line and has taken charge of it) - There has to be a clear definition of what the project is for. I'm afraid, open source shopping cart doesnt cut it. There are already several that if not free are close to it. Most people either have CFWACK or know someone who has and there have ready access to how to build a procedural shopping cart..What's going to be different about this one? From these two things will flow a proper functional spec and a direction to the project. At this point, since I havent been following the details of the project, you may well have defined the project, but I havent seen it, so I cant offer my help. I'll be glad to add whatever skills and energy I have that might contribute to an open source shopping cart if it's going to be a project that works. And if it's going to add something new to the world. Just another 'me too' shopping cart isnt worth the effort, except that it gives the contributors experience and new skills. And to put it bluntly, I'm interested in developing my skills in the use of CFCs and OOP, not just redoing something I've been doing for eight years now. And that fact that you're lashing about Dave, tells me this project is a mess right now. It needs an objective that will inspire people to be involved. The CFEclipse project has inspired it's contributors because they saw deficiencies in the existing tools and figured they could do a better one. I reckon if they'd started out saying lets build a development tool that's like notepad with a couple of other features it would have gone nowhere. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe:
Re: Big Gateways
I'd say there's one issue with your logic If all you mean by conditional processing is a bunch of extra IF's and CFSWITCH's etc, then the speed impact of those compared to database queries should be negligible. For example, if you have 10 different paths through your big cfc method, based on your arguments, but each path is as tight as it can be (no redundant queries, file access etc... only what you need for that path, etc) then you wouldnt be adding any speed by breaking it up. That said, however, the larger and more complex your single method becomes, the less maintainable it will be, and more difficult to debug. In fact, my last resort for long debugging sessions in cases like this IS to break a large method up. So, the answer is, no it probably won't speed things up if there are no steps you can eliminate (plain IFs and Switches are not speed killers compared to extra redundant query or file I/O), but YES, you should split things up in certain places... Example: let's say you have something like this: function bigMethod(arg1, arg2, argn){ set sql=; if (this or that) sql+=something; else { more stuff } switch (arg3){ case a: sql+= something else... ... ... } if (arg4){ return QUERY x with sql string} if (arg5) Return query y with sql string... } To break things up, you should think about 2 things. The methods you are offerring consumers of your CFC , as well as private utility methods, etc. First break up internal processing into private methods a little bit. This will help you create building blocks. For example If you always need to format your query results, make a private method called formatResults(Qry). If you always need to build dynamic sql (Even if the FROM tables might differ) create buildDynamicColumnList(arg-list) and buildDynamicCriteria(arg-list) If you need to add session/application/permissions, create a addPermissions(userid) to return custom SQL to append to any query. (Ex: and UserID=#session.userid#) If you always need to dynamically select tables, make a selectTables(args) function Then your complicated function will look like this: bigFunction (args) { set sql= SELECT buildDynamicQuery(args) FROM selectTables(args) WHERE buildDynamicCriteria(args) AND addPermissions(session.userid); CFQUERY name=foo #sql...#/cfquery return #formatResults(foo)# } This is just an example off the top of my head. Something along these lines will make the internal code easier to follow, easy to maintain, and also allow you to have multiple smaller public methods which dont have code that needs lots of changes when a database table is renamed, etc. Hope this makes some sense (Too early for what I wrote to make complete sense, I'm sure) -Dov Hi, I have a gateway CFC that returns queries for medications. Medications are complex things that have many properties and require many tables to store all the info. As well, there are hundreds of different ways to query the meds. My question is how do people break up their methods in these cases? In one extreme you can have 1 method that accepts many arguments, does some conditional processing and returns a query based on your arguments. In the other extreme you can have hundreds of methods that take no arguments and return a specific query for your specific situation. The advantage of the former case is that it's easy to maintain and make updates since there is only one query. But because of all the conditional processing, every query will run slower. In the latter case, your queries run very fast and serve one simple, logical purpose, but you have hundreds to write and maintain with a lot of code duplication. Like if I needed to change the FROM clause, I'd have to do it for every single one. Does anyone have a good rule of thumb of how to break up their queries? Cheers, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
umm .. I've got my cart written in the last month ;) lol -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 09 January 2006 22:33 To: CF-Talk Subject: RE: cf open shopping cart And you are.. saying its pretty damn pathetic that no one is helping out with the damn project. been what? 2 months now and whats been done? nothing. and don't you think that is pathetic of us as a group? I do. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Andy [EMAIL PROTECTED] Sent: Monday, January 09, 2006 5:27 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: cf open shopping cart And you are.. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229004 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
good old CFLOCK question
I know locking questions have come up before... but it's a quickie... Is there ever a reason to lock an entire scope instead of using named locks? It seems that locking an entire scope just causes extreme inefficiency without any advantages... Thanks, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Dave ... other communities don't have that excuse... I think that's a stretch. I would wager that in other communities (as well as life church and your local elementary) about 10% of the people end up doing about 90% of the work. -Mark P.S. Where are these hot chics who do geek-podcasts? -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 10:14 PM To: CF-Talk Subject: Re: cf open shopping cart I agree with some of justins points but the other communities don't seem to have that excuse so why should we? It's just people being lazy is all it is Personally, I don't care, if i need a quick solution I'll just go over to the php community and get it. With my tail between my legs and be ridiculed because the cfm community is so self centered and lame. They are right, we don't have crap, no wonder why we are perceived how we are. Casey, you could be right to but why even try, can't you see that cfm dev'rs don't care enough, except the rays of the community which aren't very many. I'd be first on board but now i'm gunna be like everyone else and say sorry but I'm too important to help with such a petty project, instead I'm gunna go drive around in my yugo and listen to geek podcasts while stalking hot chics... Personally, I think most people on here are to selfconscious to let us all see the code THEY actually write. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Casey Dougall [EMAIL PROTECTED] Sent: Monday, January 09, 2006 10:56 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cf open shopping cart Right on Justin, trying to START a project like this as a community effort will lead to disaster. I think this is a case of oscommerce envy. People love Open-Source and Free but haven't been around enough to see just how much hassle it it to keep something like that going. I bet Harald the man who started it all at OSC from time to time held his finger on the kill button saying GADS Just shut up already! But some how kept that project going. Granted it's got some little flaws but dam... Mind you I rember when Hostscripts.com listed more Perl scripts then PHP. If you can make that in coldfusion and have the developer network to back it up, I all about assisting, buy why? People are still selling online but it's so centralized that a shopping cart of that nature takes hours of hacking to get where you client might need so why bother. As long as the Gateway API's keep rolling out who cares about full shopping carts. When I look at hotscripts.com I see huge potentle for Coldfusion developers to pick it up a notch and show the world we actually can work for free. Who's first? Casey ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229006 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Dave, Ok - what's the site for the new open shopping cart I haven't even looked at it (sorry). -mark -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 10:14 PM To: CF-Talk Subject: Re: cf open shopping cart I agree with some of justins points but the other communities don't seem to have that excuse so why should we? It's just people being lazy is all it is Personally, I don't care, if i need a quick solution I'll just go over to the php community and get it. With my tail between my legs and be ridiculed because the cfm community is so self centered and lame. They are right, we don't have crap, no wonder why we are perceived how we are. Casey, you could be right to but why even try, can't you see that cfm dev'rs don't care enough, except the rays of the community which aren't very many. I'd be first on board but now i'm gunna be like everyone else and say sorry but I'm too important to help with such a petty project, instead I'm gunna go drive around in my yugo and listen to geek podcasts while stalking hot chics... Personally, I think most people on here are to selfconscious to let us all see the code THEY actually write. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Casey Dougall [EMAIL PROTECTED] Sent: Monday, January 09, 2006 10:56 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cf open shopping cart Right on Justin, trying to START a project like this as a community effort will lead to disaster. I think this is a case of oscommerce envy. People love Open-Source and Free but haven't been around enough to see just how much hassle it it to keep something like that going. I bet Harald the man who started it all at OSC from time to time held his finger on the kill button saying GADS Just shut up already! But some how kept that project going. Granted it's got some little flaws but dam... Mind you I rember when Hostscripts.com listed more Perl scripts then PHP. If you can make that in coldfusion and have the developer network to back it up, I all about assisting, buy why? People are still selling online but it's so centralized that a shopping cart of that nature takes hours of hacking to get where you client might need so why bother. As long as the Gateway API's keep rolling out who cares about full shopping carts. When I look at hotscripts.com I see huge potentle for Coldfusion developers to pick it up a notch and show the world we actually can work for free. Who's first? Casey ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229007 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: good old CFLOCK question
I'm inclined to agree - use named locks. On 1/10/06, Baz [EMAIL PROTECTED] wrote: I know locking questions have come up before... but it's a quickie... Is there ever a reason to lock an entire scope instead of using named locks? It seems that locking an entire scope just causes extreme inefficiency without any advantages... -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229008 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: good old CFLOCK question
I would think that named locks would end up being difficult to manage. You would have to remember that you locked session.variablename with the lock lockname. My question would be is does locking lock the scope for the whole box, or only for that application and that scope. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229009 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Data Import into ACCESS through CF
I would try to do it in Access before I would try to do it in CF. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229010 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Mike, Well said. I had much the same reaction as you. I would even devote some company resources to it - but it sounded a little fuzzy from the outset. In my experience most projects ar spear-headed by a person or very small team who direct the vision. There's a reason the communist never built a decent car (Dave's Yugo notwithstanding :)I'll second your offer with one of my own. I will promise to add enough deficiencies to inspire a host of developers (ha). -Mark -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 5:06 AM To: CF-Talk Subject: Re: cf open shopping cart Well I for one was watching this project kick off with interest. Initially I saw it as an opportunity for me to contribute something back to the community that has been so good to me over quite a few years now. I thought I would gain from it because it would also be good for me to be involved in a collaborative project, because I do nearly everything by myself these days. I know I have some expertise in some aspects of this project, and nearly no expertise in other aspects so I thought I could contribute as well as learn. So i was about to put my hand up and say I'll dive in and help. Then the bickering started. Back and forth about what it was going to be, and what it was going to do. First it was going to be like this, then like that, then like something else, without anyone offering a clear idea of what it was going to be. uh oh, I said to myself this looks just like x - a nighmare of a project I was involved in years ago and it'll be ages before anyone gets anywhere with it. I was about to suggest a functional spec, when someone else pooh-poohed the use of CFCs. Someone said they didnt want to use this new-fangled CFC stuff.They wanted to write the shopping cart using more conventional procedural code. To be frank I saw this as adding nothing to the cf community. there is already an excellent procedural shopping cart thanks to Ben Forta in the CFWACK and quite frankly I dont see what you could do in an open source cart that wasn't already there in the book, and which I've already used, adapted and modified several times. I didnt say anything at the time because most of the participants seemed to like that approach. Rather than try to rain on the parade, I put my hand back down and decided to go my own way. If you guys want to build a new procedural shopping cart, good luck to you, I'll be standing there applauding when and if it's finished. However if anyone wants to take this project in a different direction, I am more than willing to put my shoulder to the wheel.But I'd say there has to be a few things different: - someone has to be elected, appointed or self-appointed as the project leader (look at the success of the model-glue project - due in no small part to the fact that Joe Rinehart has put his personal goolies on the line and has taken charge of it) - There has to be a clear definition of what the project is for. I'm afraid, open source shopping cart doesnt cut it. There are already several that if not free are close to it. Most people either have CFWACK or know someone who has and there have ready access to how to build a procedural shopping cart..What's going to be different about this one? From these two things will flow a proper functional spec and a direction to the project. At this point, since I havent been following the details of the project, you may well have defined the project, but I havent seen it, so I cant offer my help. I'll be glad to add whatever skills and energy I have that might contribute to an open source shopping cart if it's going to be a project that works. And if it's going to add something new to the world. Just another 'me too' shopping cart isnt worth the effort, except that it gives the contributors experience and new skills. And to put it bluntly, I'm interested in developing my skills in the use of CFCs and OOP, not just redoing something I've been doing for eight years now. And that fact that you're lashing about Dave, tells me this project is a mess right now. It needs an objective that will inspire people to be involved. The CFEclipse project has inspired it's contributors because they saw deficiencies in the existing tools and figured they could do a better one. I reckon if they'd started out saying lets build a development tool that's like notepad with a couple of other features it would have gone nowhere. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229011 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
RE: Big Gateways
Dov, You bring up a lot of good points. Here is a trimmed down example of one of my queries in a method: cfquery name=local.ReturnStruct.Query SELECT DISTINCT MedicationID, Medication, MedicationC cfif not arguments.DistinctMedication , BrandNameID, BrandNameManufacturer, BrandName /cfif FROM (long from statement) WHERE 1=1 cfif isDefined('arguments.MedicationID') AND MedicationID in (cfqueryparam value=#arguments.MedicationID# ) /cfif cfloop index=local.Keyword list=#arguments.Keywords# delimiters= AND (Medication like '%#local.Keyword#%' OR BrandNameManufacturer like '%#local.Keyword#%' OR BrandName like '%#local.Keyword#%') /cfloop cfif arguments.DistinctMedication ORDER BY Medication cfelse cfif len(arguments.OrderBy) ORDER BY #arguments.OrderBy# /cfif /cfif LIMIT #local.ReturnStruct.StartRow-1#,#local.ReturnStruct.MaxRows# /cfquery Now keep in mind that the real query is much longer with more IF's and arguments. But in this case, for example, I could break up the method so that it only takes a MedicationID and make another method to search the keywords. But then I would duplicate 90% of the query... Thoughts? Baz -Original Message- From: Dov Katz [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 6:39 AM To: CF-Talk Subject: Re: Big Gateways I'd say there's one issue with your logic If all you mean by conditional processing is a bunch of extra IF's and CFSWITCH's etc, then the speed impact of those compared to database queries should be negligible. For example, if you have 10 different paths through your big cfc method, based on your arguments, but each path is as tight as it can be (no redundant queries, file access etc... only what you need for that path, etc) then you wouldnt be adding any speed by breaking it up. That said, however, the larger and more complex your single method becomes, the less maintainable it will be, and more difficult to debug. In fact, my last resort for long debugging sessions in cases like this IS to break a large method up. So, the answer is, no it probably won't speed things up if there are no steps you can eliminate (plain IFs and Switches are not speed killers compared to extra redundant query or file I/O), but YES, you should split things up in certain places... Example: let's say you have something like this: function bigMethod(arg1, arg2, argn){ set sql=; if (this or that) sql+=something; else { more stuff } switch (arg3){ case a: sql+= something else... ... ... } if (arg4){ return QUERY x with sql string} if (arg5) Return query y with sql string... } To break things up, you should think about 2 things. The methods you are offerring consumers of your CFC , as well as private utility methods, etc. First break up internal processing into private methods a little bit. This will help you create building blocks. For example If you always need to format your query results, make a private method called formatResults(Qry). If you always need to build dynamic sql (Even if the FROM tables might differ) create buildDynamicColumnList(arg-list) and buildDynamicCriteria(arg-list) If you need to add session/application/permissions, create a addPermissions(userid) to return custom SQL to append to any query. (Ex: and UserID=#session.userid#) If you always need to dynamically select tables, make a selectTables(args) function Then your complicated function will look like this: bigFunction (args) { set sql= SELECT buildDynamicQuery(args) FROM selectTables(args) WHERE buildDynamicCriteria(args) AND addPermissions(session.userid); CFQUERY name=foo #sql...#/cfquery return #formatResults(foo)# } This is just an example off the top of my head. Something along these lines will make the internal code easier to follow, easy to maintain, and also allow you to have multiple smaller public methods which dont have code that needs lots of changes when a database table is renamed, etc. Hope this makes some sense (Too early for what I wrote to make complete sense, I'm sure) -Dov Hi, I have a gateway CFC that returns queries for medications. Medications are complex things that have many properties and require many tables to store all the info. As well, there are hundreds of different ways to query the meds. My question is how do people break up their methods in these cases? In one extreme you can have 1 method that accepts many arguments, does some conditional processing and returns a query based on your arguments. In the other extreme you can have hundreds of methods that take no arguments and return a specific query for your specific situation. The advantage of the former case is that it's easy to maintain and make updates since there is only one query. But because of all the conditional processing, every query
RE: good old CFLOCK question
Baz, Think this through locking the session scope locks THIS session, so you are really keeping the user from interfering with himself. In a sense, using named locks for session scope may be overkill unless you have some kind of polling or long running scripts, or perhaps you are setting or updating the same variable constantly - in that case a named locke would be a good choice I think. Locking the Application scope does indeed lock it for everyone, but the Application scope is usually used in a write once read many fashion. I do not typically lock reads anymore for that scope - just writes so if I'm writing to the scope once (with a scope lock) and then reading from it, there's no real penalty there that I can see. In addition, the Application.cfc approach negates the need to add specific locks because I can now use the onApplicationStart( ) script to set up my variables. The Exception in the case of the application variable is a counter or tracking variable that is updated regularly - tracking logged in users for example. In that case a named lock would keep you from locking the entire scope and make perfect sense. That's my take. -Mark -Original Message- From: Baz [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 7:21 AM To: CF-Talk Subject: good old CFLOCK question I know locking questions have come up before... but it's a quickie... Is there ever a reason to lock an entire scope instead of using named locks? It seems that locking an entire scope just causes extreme inefficiency without any advantages... Thanks, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229013 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: good old CFLOCK question
An application scoped lock works just for that application. A session scoped lock works just for that user's session. It's all a matter of how an app is structured. Take 10 threads that need to write to different data in the application scope for an app; named locks let them all operate at once, while a scoped lock single-threads the app. On 1/10/06, Robert Everland III [EMAIL PROTECTED] wrote: I would think that named locks would end up being difficult to manage. You would have to remember that you locked session.variablename with the lock lockname. My question would be is does locking lock the scope for the whole box, or only for that application and that scope. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229014 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: good old CFLOCK question
In my CF4 and CF5 days I found that it was actually faster to lock an entire scope (application) then set multiple variables in that scope before releasing the lock. I'd do something like: cflock scope=Application timeout=30 type=exclusive cfscript if(not isDefined(Application.datasource)) Application.datasource = mydatasource; if(not isDefined(Application.adminname)) Application.adminname = Steve!; ... /cfscript /cflock This ran MUCH faster than doing each one individually. I've just kept in that habit since then, but I don't think there is a speed difference with MX or MX7. Thanks, Steve -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 8:33 AM To: CF-Talk Subject: Re: good old CFLOCK question I'm inclined to agree - use named locks. On 1/10/06, Baz [EMAIL PROTECTED] wrote: I know locking questions have come up before... but it's a quickie... Is there ever a reason to lock an entire scope instead of using named locks? It seems that locking an entire scope just causes extreme inefficiency without any advantages... -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229015 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
I have been following the post on both sites since it was posted, and its not been clear where we are going. I won't be quick to accuse anyone of sitting around when there still isn't a clear-cut approach to the development defined. We all have other responsibilities and are willing to contribute but the foundation needs to be clearly defined. m2cents -Original Message- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 8:48 AM To: CF-Talk Subject: RE: cf open shopping cart umm .. I've got my cart written in the last month ;) lol -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 09 January 2006 22:33 To: CF-Talk Subject: RE: cf open shopping cart And you are.. saying its pretty damn pathetic that no one is helping out with the damn project. been what? 2 months now and whats been done? nothing. and don't you think that is pathetic of us as a group? I do. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Andy [EMAIL PROTECTED] Sent: Monday, January 09, 2006 5:27 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: cf open shopping cart And you are.. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229016 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Mike, I feel the same -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 9:36 AM To: CF-Talk Subject: RE: cf open shopping cart Mike, Well said. I had much the same reaction as you. I would even devote some company resources to it - but it sounded a little fuzzy from the outset. In my experience most projects ar spear-headed by a person or very small team who direct the vision. There's a reason the communist never built a decent car (Dave's Yugo notwithstanding :)I'll second your offer with one of my own. I will promise to add enough deficiencies to inspire a host of developers (ha). -Mark -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 5:06 AM To: CF-Talk Subject: Re: cf open shopping cart Well I for one was watching this project kick off with interest. Initially I saw it as an opportunity for me to contribute something back to the community that has been so good to me over quite a few years now. I thought I would gain from it because it would also be good for me to be involved in a collaborative project, because I do nearly everything by myself these days. I know I have some expertise in some aspects of this project, and nearly no expertise in other aspects so I thought I could contribute as well as learn. So i was about to put my hand up and say I'll dive in and help. Then the bickering started. Back and forth about what it was going to be, and what it was going to do. First it was going to be like this, then like that, then like something else, without anyone offering a clear idea of what it was going to be. uh oh, I said to myself this looks just like x - a nighmare of a project I was involved in years ago and it'll be ages before anyone gets anywhere with it. I was about to suggest a functional spec, when someone else pooh-poohed the use of CFCs. Someone said they didnt want to use this new-fangled CFC stuff.They wanted to write the shopping cart using more conventional procedural code. To be frank I saw this as adding nothing to the cf community. there is already an excellent procedural shopping cart thanks to Ben Forta in the CFWACK and quite frankly I dont see what you could do in an open source cart that wasn't already there in the book, and which I've already used, adapted and modified several times. I didnt say anything at the time because most of the participants seemed to like that approach. Rather than try to rain on the parade, I put my hand back down and decided to go my own way. If you guys want to build a new procedural shopping cart, good luck to you, I'll be standing there applauding when and if it's finished. However if anyone wants to take this project in a different direction, I am more than willing to put my shoulder to the wheel.But I'd say there has to be a few things different: - someone has to be elected, appointed or self-appointed as the project leader (look at the success of the model-glue project - due in no small part to the fact that Joe Rinehart has put his personal goolies on the line and has taken charge of it) - There has to be a clear definition of what the project is for. I'm afraid, open source shopping cart doesnt cut it. There are already several that if not free are close to it. Most people either have CFWACK or know someone who has and there have ready access to how to build a procedural shopping cart..What's going to be different about this one? From these two things will flow a proper functional spec and a direction to the project. At this point, since I havent been following the details of the project, you may well have defined the project, but I havent seen it, so I cant offer my help. I'll be glad to add whatever skills and energy I have that might contribute to an open source shopping cart if it's going to be a project that works. And if it's going to add something new to the world. Just another 'me too' shopping cart isnt worth the effort, except that it gives the contributors experience and new skills. And to put it bluntly, I'm interested in developing my skills in the use of CFCs and OOP, not just redoing something I've been doing for eight years now. And that fact that you're lashing about Dave, tells me this project is a mess right now. It needs an objective that will inspire people to be involved. The CFEclipse project has inspired it's contributors because they saw deficiencies in the existing tools and figured they could do a better one. I reckon if they'd started out saying lets build a development tool that's like notepad with a couple of other features it would have gone nowhere. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~|
Re: Intranet Based on CF7 and Contribute
I think users that have a difficulty using a web browser are going to have as much difficulty handling Contribute. I think any application that allows users to affect pages by deleting portions of the code and creating application errors is the wrong way to go about doing content management. Regardless if you make it easy to fix by including only one line of code. Content management should be allowing the user to edit and add the content, not affect the code in anyway. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229018 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Intranet Based on CF7 and Contribute
I think users that have a difficulty using a web browser are going to have as much difficulty handling Contribute. I think any application that allows users to affect pages by deleting portions of the code and creating application errors is the wrong way to go about doing content management. Regardless if you make it easy to fix by including only one line of code. Content management should be allowing the user to edit and add the content, not affect the code in anyway. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229019 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFFILE Upload weirdness
Hi. One of the strangest things I've seen yet. This happens on one CF server running 7,0,1,116466 (a client's) but not mine, running the same code and the same version. Simple custom tag. Here is the cffile. cffile action=upload filefield=#filefield# destination=#Attributes.directory##attributes.id# nameconflict=overwrite accept=#accept# When uploading a jpg, named test1.jpg (the name on my computer) to a file named test2.jpg, CF creates a directory named test2.jpg and uploads. If I place the following code right after the cffile. CFOUTPUT#Attributes.directory##attributes.id#/CFOUTPUTcfexit It correctly shows this: C:websites\atip\ezcart\products_tn\test2.jpg Yet the file it places on the server is this: C:websites\atip\ezcart\products_tn\test2.jpg\test1.jpg test2.jpg being a directory created during the process. #file.serverfile# also shows the name as test1.jpg so it's not happening sometime after the initial upload. I've also tried upload a file named as it will be on the server, but then I just get test2.jpg/test2.jpg. I don't get it. Anyone seen this? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229020 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SMTP - socket error.
We are running a smtp server that gets mail generated from coldfusion. But having problems with intermitment connection timeouts from both the default windows iis smtp, and another SMTP server both seem to be having connection issues. We have run a certain SMTP server previously on this exact machine. So we know it CAN work. I've lowered the send /recieve thread count. Restarted ( which only works for a while )running out of ideas... its like the SMTP runs for a while and then just disconnects. Just wondering if anyone had any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Big Gateways
OK, so if this is what the query looks like (but larger), its probably pretty efficent, but if you want to break things up, I'd say to do it by grouping ideas together... Group 1: Brand, Manufacturer, and Medication name Group 2: Types of Medical Conditions Group 3: Active Ingredients, Allergy concerns Group 4: Price, Generic Equivalents, or something.. Your private variables/methods could be: Private variable selectStatement=select FROMx join y Everything in the from statement WHERE 1=1 Private function runQuery(String queryString){ CFQUERY name=foo #local.SelectStatement# #queryString# /CFQUERY return foo; } Private _GetMedsByName(keywords){ cfset qryString= CFIF./CFIF return qryString; } Private _GetMedsByCondition(keywords){ cfset qryString= CFIF./CFIF return qryString; } Private _GetMedsByIngredients(keywords){ cfset qryString= CFIF./CFIF return qryString; } Private _GetMedsByPrice(keywords){ cfset qryString= CFIF./CFIF qryString; } Then you can make public methods like: GetMedsByName(keywords){ return runQuery(_GetMedsByName(keywords); GetMedsByCondition(keywords){ return runQuery(_GetMedsByCondition(keywords); } GetMedsByIngredients(keywords){ return runQuery(_GetMedsByIngredients(keywords); } GetMedsByPrice(keywords){ return runQuery(_GetMedsByIngredients(keywords); } Stuff like this helps you make a rich API for users to query... Then you can make your existing method be: GetMedsByKeywords(keywords){ cfset qryString=_GetMedsByName(keywords) _GetMedsByCondition(keywords) _GetMedsByIngredients(keywords) _GetMedsByPrice(keywords) return runQuery(qryString); } This is all assuming you still want to break it up... No redundancy if you do it this way, since everything reusable is reused. dov -Original Message- From: Baz [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 8:41 AM To: CF-Talk Subject: RE: Big Gateways Dov, You bring up a lot of good points. Here is a trimmed down example of one of my queries in a method: cfquery name=local.ReturnStruct.Query SELECT DISTINCT MedicationID, Medication, MedicationC cfif not arguments.DistinctMedication , BrandNameID, BrandNameManufacturer, BrandName /cfif FROM (long from statement) WHERE 1=1 cfif isDefined('arguments.MedicationID') AND MedicationID in (cfqueryparam value=#arguments.MedicationID# ) /cfif cfloop index=local.Keyword list=#arguments.Keywords# delimiters= AND (Medication like '%#local.Keyword#%' OR BrandNameManufacturer like '%#local.Keyword#%' OR BrandName like '%#local.Keyword#%') /cfloop cfif arguments.DistinctMedication ORDER BY Medication cfelse cfif len(arguments.OrderBy) ORDER BY #arguments.OrderBy# /cfif /cfif LIMIT #local.ReturnStruct.StartRow-1#,#local.ReturnStruct.MaxRows# /cfquery Now keep in mind that the real query is much longer with more IF's and arguments. But in this case, for example, I could break up the method so that it only takes a MedicationID and make another method to search the keywords. But then I would duplicate 90% of the query... Thoughts? Baz -Original Message- From: Dov Katz [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 6:39 AM To: CF-Talk Subject: Re: Big Gateways I'd say there's one issue with your logic If all you mean by conditional processing is a bunch of extra IF's and CFSWITCH's etc, then the speed impact of those compared to database queries should be negligible. For example, if you have 10 different paths through your big cfc method, based on your arguments, but each path is as tight as it can be (no redundant queries, file access etc... only what you need for that path, etc) then you wouldnt be adding any speed by breaking it up. That said, however, the larger and more complex your single method becomes, the less maintainable it will be, and more difficult to debug. In fact, my last resort for long debugging sessions in cases like this IS to break a large method up. So, the answer is, no it probably won't speed things up if there are no steps you can eliminate (plain IFs and Switches are not speed killers compared to extra redundant query or file I/O), but YES, you should split things up in certain places... Example: let's say you have something like this: function bigMethod(arg1, arg2, argn){ set sql=; if (this or that) sql+=something; else { more stuff } switch (arg3){ case a: sql+= something else... ... ... } if (arg4){ return QUERY x with sql string} if (arg5) Return query y with sql string... } To break things up, you should think about 2 things. The methods you are offerring
RE: Big Gateways
Dov, Great stuff! Gonna implement it.. Cheers, Baz -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 9:14 AM To: CF-Talk Subject: RE: Big Gateways OK, so if this is what the query looks like (but larger), its probably pretty efficent, but if you want to break things up, I'd say to do it by grouping ideas together... Group 1: Brand, Manufacturer, and Medication name Group 2: Types of Medical Conditions Group 3: Active Ingredients, Allergy concerns Group 4: Price, Generic Equivalents, or something.. Your private variables/methods could be: Private variable selectStatement=select FROMx join y Everything in the from statement WHERE 1=1 Private function runQuery(String queryString){ CFQUERY name=foo #local.SelectStatement# #queryString# /CFQUERY return foo; } Private _GetMedsByName(keywords){ cfset qryString= CFIF./CFIF return qryString; } Private _GetMedsByCondition(keywords){ cfset qryString= CFIF./CFIF return qryString; } Private _GetMedsByIngredients(keywords){ cfset qryString= CFIF./CFIF return qryString; } Private _GetMedsByPrice(keywords){ cfset qryString= CFIF./CFIF qryString; } Then you can make public methods like: GetMedsByName(keywords){ return runQuery(_GetMedsByName(keywords); GetMedsByCondition(keywords){ return runQuery(_GetMedsByCondition(keywords); } GetMedsByIngredients(keywords){ return runQuery(_GetMedsByIngredients(keywords); } GetMedsByPrice(keywords){ return runQuery(_GetMedsByIngredients(keywords); } Stuff like this helps you make a rich API for users to query... Then you can make your existing method be: GetMedsByKeywords(keywords){ cfset qryString=_GetMedsByName(keywords) _GetMedsByCondition(keywords) _GetMedsByIngredients(keywords) _GetMedsByPrice(keywords) return runQuery(qryString); } This is all assuming you still want to break it up... No redundancy if you do it this way, since everything reusable is reused. dov -Original Message- From: Baz [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 8:41 AM To: CF-Talk Subject: RE: Big Gateways Dov, You bring up a lot of good points. Here is a trimmed down example of one of my queries in a method: cfquery name=local.ReturnStruct.Query SELECT DISTINCT MedicationID, Medication, MedicationC cfif not arguments.DistinctMedication , BrandNameID, BrandNameManufacturer, BrandName /cfif FROM (long from statement) WHERE 1=1 cfif isDefined('arguments.MedicationID') AND MedicationID in (cfqueryparam value=#arguments.MedicationID# ) /cfif cfloop index=local.Keyword list=#arguments.Keywords# delimiters= AND (Medication like '%#local.Keyword#%' OR BrandNameManufacturer like '%#local.Keyword#%' OR BrandName like '%#local.Keyword#%') /cfloop cfif arguments.DistinctMedication ORDER BY Medication cfelse cfif len(arguments.OrderBy) ORDER BY #arguments.OrderBy# /cfif /cfif LIMIT #local.ReturnStruct.StartRow-1#,#local.ReturnStruct.MaxRows# /cfquery Now keep in mind that the real query is much longer with more IF's and arguments. But in this case, for example, I could break up the method so that it only takes a MedicationID and make another method to search the keywords. But then I would duplicate 90% of the query... Thoughts? Baz -Original Message- From: Dov Katz [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 6:39 AM To: CF-Talk Subject: Re: Big Gateways I'd say there's one issue with your logic If all you mean by conditional processing is a bunch of extra IF's and CFSWITCH's etc, then the speed impact of those compared to database queries should be negligible. For example, if you have 10 different paths through your big cfc method, based on your arguments, but each path is as tight as it can be (no redundant queries, file access etc... only what you need for that path, etc) then you wouldnt be adding any speed by breaking it up. That said, however, the larger and more complex your single method becomes, the less maintainable it will be, and more difficult to debug. In fact, my last resort for long debugging sessions in cases like this IS to break a large method up. So, the answer is, no it probably won't speed things up if there are no steps you can eliminate (plain IFs and Switches are not speed killers compared to extra redundant query or file I/O), but YES, you should split things up in certain places... Example: let's say you have something like this: function bigMethod(arg1, arg2, argn){ set sql=; if (this or that) sql+=something; else { more stuff } switch (arg3){ case a: sql+= something
ot - trying to find blog owner for Rapid CF Developer's Blog
Sorry for the OT post - but if the owner of the Rapid CF Developer's Blog is here, please email me. URL is http://rayhorn.contentopia.net/blog/index.cfm -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229024 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL query to get first sentence (using mySQL)
Anyone have ideas on this? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 9:35 AM To: CF-Talk Subject: SOT: SQL query to get first sentence (using mySQL) I've got a text field from which I'd like to extract the first sentence for each record. Here's the query I've got so far. SELECT SUBSTRING_INDEX(j.job_desc,'.',1) AS job_desc FROM jobs The problem is that in some of the records, the first sentence is terminated by a question mark (or exclamation point) rather than a period and I need to get those sentences as well. I'm trying to find out how I can say the first sentence instead of the first sentence ending in a period. Does anyone have any ideas? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229025 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: lets give these ppl hell!
LOL... now that's fresh. !K -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: January 10, 2006 5:37 AM To: CF-Talk Subject: RE: lets give these ppl hell! Ken, Is it really necessary to disparage an ad campaign of a company that might just have people on this list? (READ THE SIGNATURE) Thanks, Steve -- Steve Durette Mgr - Results Mechanization ATT -Original Message- From: Ken Ketsdever [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 6:15 PM To: CF-Talk Subject: RE: lets give these ppl hell! Consider yourself part of the lucky half. -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 3:09 PM To: CF-Talk Subject: Re: lets give these ppl hell! Also Talk about marketing to the masses. I'm still trying to figure out this one. ATT Online Campaign to Reach Half of Web Users http://www.marketingvox.com/archives/2006/01/09/att_online_campaign_to_r each_half_of_web_users/ The massive ATT campaign launched on New Year's Day will hit the web on Jan. 9 with a splash that the company says will be among the largest in internet history, according to AdAge (via MediaBuyerPlanner). Just about half of all web users - about 137.8 million unique users - will see ads for the newly merged company. I haven't seen it yet... Casey On 1/9/06, Bryan Stevenson [EMAIL PROTECTED] wrote: and how does one get 800,000 friends Dave? ;-) Me thinks that's the hard part if you're not a cute young lass showing a little skin. I mean come onguys are the reason sex sells!! Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229026 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: action script copy by value
Hey Brad, This may seem a little ridiculous, but have you cleared your cache lately? It is still Flash after all... Cheers, Kevin -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: January 9, 2006 11:25 AM To: CF-Talk Subject: action script copy by value I am going insane here. I am trying to implement an example from asfusion.com Filtering a cfgrid as you type -revisited- http://www.asfusion.com/blog/entry/filtering-a-cfgrid-as-you-type--revisite d- There is a line of action script where this happens: _global.backupDP = grd_reconcile.dataProvider.slice(0); This is supposed to copy all items form the dataProvider property of my grid into a list called backupDp in the _global scope. I don't know why, but it doesn't seem to work. If I run this and then alert _global.backupDP.length I should get the length of the list, but I get an empty alert box. It is as if the variable is just empty and I don't know how to do an equivalent to dumping it to see what is in it. If I do this line of code: _global.backupDP = grd_reconcile.dataProvider; Without the slice it works perfectly, but IT COPIES BY REFERENCE NOT BY VALUE. I have seen several examples of people copying all the items in a list with the slice(0) but it just doesn't seem to work for me. Does anyone know what the heck I am doing wrong? Thanks! ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229027 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL query to get first sentence (using mySQL)
Outside of a query you could do something like... - Loop through all your delimiters getting the first index of each. So . may be at index 29, ! at index 40 and ? at index 18. - Use the lowest one in your query below to denote the end of the first sentence. In a query, how about... - Replace all possible ends of sentences with a full stop (period). - Then look for the first occurrence. Something like... SELECT SUBSTRING_INDEX(REPLACE(j.job_desc, '!', '.'), '.', 1) AS job_desc FROM jobs You'll need to nest more REPLACEs for each possible sentence end char. Ade -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 09 January 2006 15:35 To: CF-Talk Subject: SOT: SQL query to get first sentence (using mySQL) I've got a text field from which I'd like to extract the first sentence for each record. Here's the query I've got so far. SELECT SUBSTRING_INDEX(j.job_desc,'.',1) AS job_desc FROM jobs The problem is that in some of the records, the first sentence is terminated by a question mark (or exclamation point) rather than a period and I need to get those sentences as well. I'm trying to find out how I can say the first sentence instead of the first sentence ending in a period. Does anyone have any ideas? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229028 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFILE Upload weirdness
On 1/10/06, Bud [EMAIL PROTECTED] wrote: Hi. One of the strangest things I've seen yet. This happens on one CF server running 7,0,1,116466 (a client's) but not mine, running the same code and the same version. Simple custom tag. Here is the cffile. cffile action=upload filefield=#filefield# destination=#Attributes.directory##attributes.id# nameconflict=overwrite accept=#accept# When uploading a jpg, named test1.jpg (the name on my computer) to a file named test2.jpg, CF creates a directory named test2.jpg and uploads. If I place the following code right after the cffile. CFOUTPUT#Attributes.directory##attributes.id#/CFOUTPUTcfexit It correctly shows this: C:websites\atip\ezcart\products_tn\test2.jpg Yet the file it places on the server is this: C:websites\atip\ezcart\products_tn\test2.jpg\test1.jpg test2.jpg being a directory created during the process. #file.serverfile# also shows the name as test1.jpg so it's not happening sometime after the initial upload. I've also tried upload a file named as it will be on the server, but then I just get test2.jpg/test2.jpg. I don't get it. Anyone seen this? While it looks like you're experiencing the issue in this TechNote, http://www.macromedia.com/go/f97044e, you should make sure that you have the cumulative updater to Merrimack installed, found here: http://www.macromedia.com/go/aae43964. I think that should resolve things. One thing that has changed in MX 7 is that you can't just use the serial number to determine what patch level you're at. You need to check the Update Level line as well on the System Information page. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229029 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: lets give these ppl hell!
Sorry it you took offense, the comment had nothing to do with ATT. But rather about the quantity of email received. Personally, I would be thankful for one less undesired email be it from ATT, SBCGlobal or Mothers Cookies (unless it came with a sample, love Mothers Oatmeal Cookies). I have yet to receive an email from ATT, so either I am not on the list, or my spam filter removed it. I am now interested enough to want to see one. Are you part of the campaign team? How in the world did ATT get Just about half of all web users - about 137.8 million unique users to opt-in? That is an amazing. Ken -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Ken, Is it really necessary to disparage an ad campaign of a company that might just have people on this list? (READ THE SIGNATURE) Thanks, Steve -- Steve Durette Mgr - Results Mechanization ATT Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229030 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: CF Webtools looking for designers
CF Webtools is looking for designers for contract work. We need: Good turn around on Mockups Good slicer CSS expertise (if you are 5 levels deep table person please refrain from responding. We already have 3 of those - ha). We have 2 to 5 projects per month requiring design work. If you are a free lancer (or looking for outside work) let us know. Please include URL we can view as samples of your work - thanks! -mark Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: action script copy by value
Kevin, I haven't cleared my cache recently, but I did find out why it wasn't working. If I just have a cfgrid populated by a query, I can do myGrid.dataProvider.slice(0) and get a copy of all the items in the list. I found out the PROBLEM is when I change the data provider with flash remoting: myGrid.dataProvider = results; After I do that, slice(0) magically stops returning anything, and if I get rid of the slice, I get a pointer to the data, not a copy of it. My work around for now is simply to loop over the dataProvider list and build a new array one item at a time like this: var backupDP = []; for(var i:Number = 0; i grd_reconcile.dataProvider.length; i++) { backupDP.push(grd_reconcile.dataProvider.getItemAt(i)); } Probably not the most efficient, but it works for now. It seems every decent language should have a way to copy by reference AND by value (without a slice(0) hack), but I haven't figured it out yet with Actionscript. On a funny note-- I posted a question to the flex livedocs the other day asking if the columns in a data grid object could be made draggable (in order to let the users drag them around and order them easily) I got a reply back from an employee of Macromedia telling me that he didn't know the answer to my question. Now tell me, if the company who WROTE the software can't answer questions about it, who can?? He referred me to the macromedia forumns. Nice try-- I asked that exact question in the forums a couple weeks ago and never got a SINGLE reply. *sigh* ~Brad -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 9:05 AM To: CF-Talk Subject: RE: action script copy by value Hey Brad, This may seem a little ridiculous, but have you cleared your cache lately? It is still Flash after all... Cheers, Kevin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229032 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
If you REALLY want an open-source shopping cart in CF, someone, one person, will just need buckle down and write a feature set, decide on a framework, and CODE MOST OF IT OUT. Hasn't Ben Forta done that? Mine was based on the one out of WACK 4, a lng time ago. :) I've been working on cf_ezcart for 6 years. I've sold well over 500 licenses and I think I've added a new feature for 3 out of 4 of those sales. Every freaking body that buys a shopping carts wants something different. Crazy pricing schemes. And shipping? Unbelievable some of the weird stuff people come up with. Anyway, as a fellow cf developer, I wish everyone luck. As a competitor, I hope your project falls on it's butt. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229033 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: lets give these ppl hell!
The campaign wasn't e-mail based (as far as I know). ATT bought up a HUGE amount of banner space. HUGE amounts of screen space in New York when the ball came down. I don't know where they got the numbers from but my guess is that it was the fact that they put banner adds anywhere they could find them and then went with the hits/users that the ad companies reported to them. Again I was NOT part of the ad team, so all of my opinions are my own. :) Steve -Original Message- From: Ken Ketsdever [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 10:26 AM To: CF-Talk Subject: RE: lets give these ppl hell! Sorry it you took offense, the comment had nothing to do with ATT. But rather about the quantity of email received. Personally, I would be thankful for one less undesired email be it from ATT, SBCGlobal or Mothers Cookies (unless it came with a sample, love Mothers Oatmeal Cookies). I have yet to receive an email from ATT, so either I am not on the list, or my spam filter removed it. I am now interested enough to want to see one. Are you part of the campaign team? How in the world did ATT get Just about half of all web users - about 137.8 million unique users to opt-in? That is an amazing. Ken -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Ken, Is it really necessary to disparage an ad campaign of a company that might just have people on this list? (READ THE SIGNATURE) Thanks, Steve -- Steve Durette Mgr - Results Mechanization ATT Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229034 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Like was said before, what this project needs is a good project manager to manage the whole thing. Somebody needs to either a. build the whole thing themselves and let people add features or b. figure out the spec and possibly through a round of RFC's solidify it and then break it up and have different developers work on it. The project will never take off the ground if somebody doesn't take lead. It doesn't have to be the best shopping cart right off the bat, I'm sure that there will be a lot of learning while the cart gets to v1, and probably a huge revamp to get to v2, where it will probably finally be a usable product. So who's it going to be? Who's going to take the lead and manage this thing? -Original Message- From: Aldon [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 9:06 AM To: CF-Talk Subject: RE: cf open shopping cart Mike, I feel the same -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 9:36 AM To: CF-Talk Subject: RE: cf open shopping cart Mike, Well said. I had much the same reaction as you. I would even devote some company resources to it - but it sounded a little fuzzy from the outset. In my experience most projects ar spear-headed by a person or very small team who direct the vision. There's a reason the communist never built a decent car (Dave's Yugo notwithstanding :)I'll second your offer with one of my own. I will promise to add enough deficiencies to inspire a host of developers (ha). -Mark -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 5:06 AM To: CF-Talk Subject: Re: cf open shopping cart Well I for one was watching this project kick off with interest. Initially I saw it as an opportunity for me to contribute something back to the community that has been so good to me over quite a few years now. I thought I would gain from it because it would also be good for me to be involved in a collaborative project, because I do nearly everything by myself these days. I know I have some expertise in some aspects of this project, and nearly no expertise in other aspects so I thought I could contribute as well as learn. So i was about to put my hand up and say I'll dive in and help. Then the bickering started. Back and forth about what it was going to be, and what it was going to do. First it was going to be like this, then like that, then like something else, without anyone offering a clear idea of what it was going to be. uh oh, I said to myself this looks just like x - a nighmare of a project I was involved in years ago and it'll be ages before anyone gets anywhere with it. I was about to suggest a functional spec, when someone else pooh-poohed the use of CFCs. Someone said they didnt want to use this new-fangled CFC stuff.They wanted to write the shopping cart using more conventional procedural code. To be frank I saw this as adding nothing to the cf community. there is already an excellent procedural shopping cart thanks to Ben Forta in the CFWACK and quite frankly I dont see what you could do in an open source cart that wasn't already there in the book, and which I've already used, adapted and modified several times. I didnt say anything at the time because most of the participants seemed to like that approach. Rather than try to rain on the parade, I put my hand back down and decided to go my own way. If you guys want to build a new procedural shopping cart, good luck to you, I'll be standing there applauding when and if it's finished. However if anyone wants to take this project in a different direction, I am more than willing to put my shoulder to the wheel.But I'd say there has to be a few things different: - someone has to be elected, appointed or self-appointed as the project leader (look at the success of the model-glue project - due in no small part to the fact that Joe Rinehart has put his personal goolies on the line and has taken charge of it) - There has to be a clear definition of what the project is for. I'm afraid, open source shopping cart doesnt cut it. There are already several that if not free are close to it. Most people either have CFWACK or know someone who has and there have ready access to how to build a procedural shopping cart..What's going to be different about this one? From these two things will flow a proper functional spec and a direction to the project. At this point, since I havent been following the details of the project, you may well have defined the project, but I havent seen it, so I cant offer my help. I'll be glad to add whatever skills and energy I have that might contribute to an open source shopping cart if it's going to be a project that works. And if it's going to add something new to the world. Just another 'me too' shopping cart isnt worth the effort, except that it gives the contributors experience
RE: lets give these ppl hell!
When I saw the comment from ATT about half all web users etc.. I jumped to the conclusion it was an email campaign. Obviously I was wrong, my apologies. I guess I am the half that is out of the loop because I don't recall seeing any advertisements from ATT recently, online or otherwise, Either that I just tune out advertisements. Come to think of it the only ads I remember recently are those damn blinking ads online. Don't know what they are advertising I just know they are annoying as all hell. Oh yeah and those panic ads for energy bills, cell phones, etc.. on the radio. The one where some lady walks in to find her husband passed out on the floor from having opened the outrageous bill. Then as he comes to, she looks at the bill and passes out. I don't have enough stress and anxiety in my life I need some panic attack on the radio too. I know the concept of the ad but I have idea of the specific product being advertised. I usually turn the station. Moved to cf-community as Annoying commercials. Again, sorry for offending you that wasn't my intent. -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] The campaign wasn't e-mail based (as far as I know). ATT bought up a HUGE amount of banner space. HUGE amounts of screen space in New York when the ball came down. I don't know where they got the numbers from but my guess is that it was the fact that they put banner adds anywhere they could find them and then went with the hits/users that the ad companies reported to them. Again I was NOT part of the ad team, so all of my opinions are my own. :) Steve Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229036 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
-Crickets- *no one moves* :) What is an RFC? (Sorry for the stupid question.) ~Brad So who's it going to be? Who's going to take the lead and manage this thing? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229037 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Fusebox IFrame Bug
Not sure who to blame on this one but what I'm finding is that when using FuseBox 4.1 framework I have a page that has an Iframe in the middle of it which shows another page from the framework - When the entire page is loaded all at once, I'll get random Framework/Fusebox errors within the Iframe window Every Time the main page is loaded I.e. Element FUSEBOX.FUSEACTIONVARIABLE is undefined in APPLICATION Or other errors that seem to come from my application - Process is: a. User navigates to URL index.cfm?fuse=x.y b. Page is loaded and has an embedded Iframe which calls index.cfm?fuse=x.z c. Iframe area always throws a Fusebox type error in the window instead of properly loading index.cfm?fuse=x.z d. I right click and reload Iframe window - works fine every time. So I right click and refresh/reload the IFRame all by itself, the page comes up fine, the url is the same and no errors ever. It's like there's some sort of 'conflict' for the framework call when there is a fusebox page that has an Iframe embedded in itself which calls another framework circuit. Anyone ever encounter this before or know of a work around? (Other than putting the IFRame page call outside of the Framework) Thanks Kevin Penny, MMCP ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229038 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
That's cool I wont ask about it anymore or try to help out the community since most of you are just so great that you are above helping out ~Dave the disruptor~ Cool your jets big guy and try not to tar the entire list with the same brush and feathers ;-) Some of uswell work for a living...hehe Personally I have just taken on 2 new staff2 more coming in the next month or so. These folks are working for me on a HUGE federal government project which is an equally HUGE change in the way they do business. To top it off this project has spurred on some much needed house cleaning from a data standpointcreating a bunch of spin-off projects. These are CF 7, Oracle 9i, JS/DMHTML/AJAX. So now I'm overseeing the project and the staff along with my own workload. I simply do not have time to give to this project although I'd love to do it. So the way I can give back is to continue to provide advice on this list which I have been a member of since around 98/99. I do not own an XBOXI prefer physical activity (no swaying on the couch to the movements of the game does not constitute physical activity). I go out on my 2000 Yamaha SuperJet and keep practing my areial tricks...was out last weekend actually (no fat ass here pal). So there ya go Dissy D...it ain't all black and white ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229039 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
undefined struct element
We occasionally see users come to the site with bad cookies, meaning that if I dump the cookies, i find an entry (say foo) whose value is: [undefined struct element] I think that isDefined(cookie.foo) returns TRUE, but if I try to do this: cfset variables.foo = cookie.foo then variable.foo is undefined. i see this most frequently in IE5, but have seen in IE6 and others as well. Any ideas what it could be, or at least how to trap it? Thanks, Greg Saunders Vice-President, Technology, Trump University 40 Wall Street New York, NY 10005 http://www.trumpuniversity.com [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229040 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
RFC is a request for comments. We can't have everybody try to set the specs, but someone should write out the specs, and then post it for everyone else to critique. After a few rounds of critique, most of the kinks should be worked out. This is how new standards get set in place. SMTP, HTTP are a few examples. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 11:09 AM To: CF-Talk Subject: RE: cf open shopping cart -Crickets- *no one moves* :) What is an RFC? (Sorry for the stupid question.) ~Brad So who's it going to be? Who's going to take the lead and manage this thing? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229041 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fusebox IFrame Bug
Weird, do you have any variable locking problems where two concurrent page requests from the same session are hitting heads? What happens if you type the address of the iframe in the main url and load that page by itself? Is there any # or characters getting in the iframe src that could be screwing with the iframe's url parameters? ~Brad -Original Message- From: Kevin Penny [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 10:12 AM To: CF-Talk Subject: Fusebox IFrame Bug Not sure who to blame on this one but what I'm finding is that when using FuseBox 4.1 framework I have a page that has an Iframe in the middle of it which shows another page from the framework - When the entire page is loaded all at once, I'll get random Framework/Fusebox errors within the Iframe window Every Time the main page is loaded I.e. Element FUSEBOX.FUSEACTIONVARIABLE is undefined in APPLICATION Or other errors that seem to come from my application - Process is: a. User navigates to URL index.cfm?fuse=x.y b. Page is loaded and has an embedded Iframe which calls index.cfm?fuse=x.z c. Iframe area always throws a Fusebox type error in the window instead of properly loading index.cfm?fuse=x.z d. I right click and reload Iframe window - works fine every time. So I right click and refresh/reload the IFRame all by itself, the page comes up fine, the url is the same and no errors ever. It's like there's some sort of 'conflict' for the framework call when there is a fusebox page that has an Iframe embedded in itself which calls another framework circuit. Anyone ever encounter this before or know of a work around? (Other than putting the IFRame page call outside of the Framework) Thanks Kevin Penny, MMCP ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229042 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Aqua Studio / Oracle
Hi guys, I don't know whether anyone has used Aqua Studio before but in case you have then maybe you can help. I am trying to create a field with an incremental ID. I found this clever script: CREATE SEQUENCE supplier_seq    MINVALUE 1    START WITH 1    INCREMENT BY 1    CACHE 20; but i have no idea where i should run that script. Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) Thanks, Saturday ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229043 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
I think your judgment of others not wanting to join your project is a little off. It's kind of odd to attack others for not sharing desire to work on a particular project. Why is it that you think everyone in the community should share YOUR priorities? Why do you think everyone else should necessarily think the project is important or would be worth spending their time working on? Maybe if you want cheapie free crap, PHP is where you should be looking in the first place. It's not all attributable to laziness. Take me for instance, few people in this world would ever call me lazy, but you'll certainly not catch me participating in a project like this. I wish those who do all the best, but there's just no upside in it for me. It's certainly not something I'd ever choose to do with my spare time, of which I have very little to begin with. I work my ass off all day long and then I go home and concentrate on my #1 priority - kids. Then, in the small amount of spare time I do have, I'll work on attaining new rental property, playing hockey and climbing. I can't tell you how far down the list of leisure-time activities I'd have to go before I found the bullet point, working on an open source project. So, I think it's more a matter of people's priorities than it is with whether or not they're lazy. Some of you guys like to go home from your dev jobs and sit in front of a computer and that's fine for you. For those like me though, we'd have to be forced at gunpoint to stare at a monitor for more time than it takes to add some new stuff to the iPod after getting home from a long day at work. I'm guessing that's the main reason that these projects are difficult to get done and it's hardly something for which they/we ought to be attacked. If you want to do something and it's important to you, then why don't you get off YOUR lazy ass and do it instead of expecting others to get it done and attacking the community at large for not sharing your desire to work on it. --Ferg dave wrote: I agree with some of justins points but the other communities don't seem to have that excuse so why should we? It's just people being lazy is all it is Personally, I don't care, if i need a quick solution I'll just go over to the php community and get it. With my tail between my legs and be ridiculed because the cfm community is so self centered and lame. They are right, we don't have crap, no wonder why we are perceived how we are. Casey, you could be right to but why even try, can't you see that cfm dev'rs don't care enough, except the rays of the community which aren't very many. I'd be first on board but now i'm gunna be like everyone else and say sorry but I'm too important to help with such a petty project, instead I'm gunna go drive around in my yugo and listen to geek podcasts while stalking hot chics... Personally, I think most people on here are to selfconscious to let us all see the code THEY actually write. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229044 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
I don't know whether anyone has used Aqua Studio before but in case you have then maybe you can help. I am trying to create a field with an incremental ID. I found this clever script: CREATE SEQUENCE supplier_seq MINVALUE 1 START WITH 1 INCREMENT BY 1 CACHE 20; but i have no idea where i should run that script. Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) If you're talking about opening up a query window, select the server, the database and the table on the left and hit CTRL-Q (or right click and select New Query Window) Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229045 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: action script copy by value
Hey Brad, I've been working with Flash longer than most, so I'll try and answer your questions. It seems every decent language should have a way to copy by reference AND by value (without a slice(0) hack), but I haven't figured it out yet with Actionscript. --Nope. You can use an loop or a couple different hacks. myGrid.dataProvider = results; After I do that, slice(0) magically stops returning anything, and if I get rid of the slice, I get a pointer to the data, not a copy of it. --The statement above is using the remoting bindings and 'results' refers to an object, not an array. If the columns in a data grid object could be made draggable (in order to let the users drag them around and order them easily). --Short answer... no. Long answer... by subclassing the datagrids classes and than extending the columns class, you could do it. Of course you'd need a pretty deep knowledge of the AS2 framework and UIObject though... Cheers, Kevin -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: January 10, 2006 9:32 AM To: CF-Talk Subject: RE: action script copy by value Kevin, I haven't cleared my cache recently, but I did find out why it wasn't working. If I just have a cfgrid populated by a query, I can do myGrid.dataProvider.slice(0) and get a copy of all the items in the list. I found out the PROBLEM is when I change the data provider with flash remoting: myGrid.dataProvider = results; After I do that, slice(0) magically stops returning anything, and if I get rid of the slice, I get a pointer to the data, not a copy of it. My work around for now is simply to loop over the dataProvider list and build a new array one item at a time like this: var backupDP = []; for(var i:Number = 0; i grd_reconcile.dataProvider.length; i++) { backupDP.push(grd_reconcile.dataProvider.getItemAt(i)); } Probably not the most efficient, but it works for now. It seems every decent language should have a way to copy by reference AND by value (without a slice(0) hack), but I haven't figured it out yet with Actionscript. On a funny note-- I posted a question to the flex livedocs the other day asking if the columns in a data grid object could be made draggable (in order to let the users drag them around and order them easily) I got a reply back from an employee of Macromedia telling me that he didn't know the answer to my question. Now tell me, if the company who WROTE the software can't answer questions about it, who can?? He referred me to the macromedia forumns. Nice try-- I asked that exact question in the forums a couple weeks ago and never got a SINGLE reply. *sigh* ~Brad -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 9:05 AM To: CF-Talk Subject: RE: action script copy by value Hey Brad, This may seem a little ridiculous, but have you cleared your cache lately? It is still Flash after all... Cheers, Kevin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Aqua Studio / Oracle
I think there are some tools that let you run sql like osql.exe (not sure if it comes if you don't have enterprise manager). You can also just stick it into a CF page inside a cfquery and assuming you have the right permissions to the database it should create sequence for you. -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 11:32 AM To: CF-Talk Subject: SOT: Aqua Studio / Oracle Hi guys, I don't know whether anyone has used Aqua Studio before but in case you have then maybe you can help. I am trying to create a field with an incremental ID. I found this clever script: CREATE SEQUENCE supplier_seq    MINVALUE 1    START WITH 1    INCREMENT BY 1    CACHE 20; but i have no idea where i should run that script. Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) Thanks, Saturday ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229047 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: lets give these ppl hell!
And the best of luck to you Dave. I hope your new method of spamming, as there's no way to argue that in the end that's what it is, makes you incredibly rich! --Ferg dave wrote: sounds like a personal problem ;) it's a great marketing tool, just look at forbidden (who cart we all bashed on here), she probably made more $$ in 2 days than the highest paid person on here makes a year. All because she has 800,000 friends, she launcher her site and the servers where overloaded for weeks. 29,000,000 was just the number the person in front of my used (exaggeration) real world example: If we can get cfm girl aka alix up to 800,000 friends and using simple business logic says 1% of those sign up for her site then MY PROFIT(and just mine not any of the other ppl involved) is around $60,000 a month. So go ahead and make fun and ignore the opportunity it provided, I plan on making money off of it! ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Ken Ferguson [EMAIL PROTECTED] Sent: Monday, January 09, 2006 10:04 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: lets give these ppl hell! I have just the opposite problem. I can't keep the friends I have now from pissin' ME off; I don't need 29M for me to be mad at! I think they'd be better off advertising on your ability to choose 5 friends from a pool of 29 million. I'm betting NOBODY wants 29M friends. I question that number in the first place. 10% of the entire United States would be just over 29M people. Depending on which survey you use, that's also between about 3.5 and 5 percent of all the people in the entire world who use the internet, which is estimated to be between 650M and 800M! So, color me skeptical. --Ferg Bobby Hartsfield wrote: Hell, I can't keep from pissin off the 3 I have now... I definitely don't need 29,000,000 of them mad at me. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Michael Clayton [mailto:[EMAIL PROTECTED] Sent: Saturday, January 07, 2006 11:59 AM To: CF-Talk Subject: Re: lets give these ppl hell! I want 29,000,000 friends too! *scoff* ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229048 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: action script copy by value
Kevin, thank you very much for your help. --The statement above is using the remoting bindings and 'results' refers to an object, not an array. That makes perfect sense. I had just assumed that the results object would be a list-based object and inherit the length property etc... Other than looping, why other way IS there to copy the grid items when the dataProvider is bound to the object returned by remoting? --Short answer... no. Long answer... by subclassing the datagrids classes and than extending the columns class, you could do it. Of course you'd need a pretty deep knowledge of the AS2 framework and UIObject though... Cool. I figured as much. At first I was hoping maybe someone else had done that before and would have a copy and paste answer-- but I get the impression a lot of people really haven't dived too deep into pushing flash forms to the limits. :) Maybe you can answer some of my other quandaries I have found. The biggest still being how on Earth to attach a click listener to checkbox in a cfgrid when using cfgridcolumn type=Boolean I have attaching every listener to the grid itself with zero luck. The check box always eats the event and doesn't pass it along to cellClick or cellPress. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229049 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
Thanks for that Hatton. I managed to get the query window open and put a query inside but seem to get some errors. CREATE SEQUENCE PATCHID    MINVALUE 1    MAXVALUE 999    START WITH 1    INCREMENT BY 1    CACHE 20; Do you know whether my sequence should have a semi-colan at the end? Also, the actual field name is called PATCHID, should i call this sequence something else? If i take off the semi-colan and give the seq a random name it seems to come up with no errors but is there a way i can see whether it actually did anything? Thanks for your time, Saturday From: C. Hatton Humphrey [EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 11:40 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: SOT: Aqua Studio / Oracle I don't know whether anyone has used Aqua Studio before but in case you have then maybe you can help. I am trying to create a field with an incremental ID. I found this clever script: CREATE SEQUENCE supplier_seq MINVALUE 1 START WITH 1 INCREMENT BY 1 CACHE 20; but i have no idea where i should run that script. Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) If you're talking about opening up a query window, select the server, the database and the table on the left and hit CTRL-Q (or right click and select New Query Window) Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229050 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusebox IFrame Bug
you'll get the same behaviour using normal frames too - the problem is the two requests are running and one request overwrites the application stored structure - if you change the mode from development to production the problem will go away as the application structure will not be recreated on every request, john. Weird, do you have any variable locking problems where two concurrent page requests from the same session are hitting heads? What happens if you type the address of the iframe in the main url and load that page by itself? Is there any # or characters getting in the iframe src that could be screwing with the iframe's url parameters? ~Brad -Original Message- From: Kevin Penny [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 10:12 AM To: CF-Talk Subject: Fusebox IFrame Bug Not sure who to blame on this one but what I'm finding is that when using FuseBox 4.1 framework I have a page that has an Iframe in the middle of it which shows another page from the framework - When the entire page is loaded all at once, I'll get random Framework/Fusebox errors within the Iframe window Every Time the main page is loaded I.e. Element FUSEBOX.FUSEACTIONVARIABLE is undefined in APPLICATION Or other errors that seem to come from my application - Process is: a. User navigates to URL index.cfm?fuse=x.y b. Page is loaded and has an embedded Iframe which calls index.cfm?fuse=x.z c. Iframe area always throws a Fusebox type error in the window instead of properly loading index.cfm?fuse=x.z d. I right click and reload Iframe window - works fine every time. So I right click and refresh/reload the IFRame all by itself, the page comes up fine, the url is the same and no errors ever. It's like there's some sort of 'conflict' for the framework call when there is a fusebox page that has an Iframe embedded in itself which calls another framework circuit. Anyone ever encounter this before or know of a work around? (Other than putting the IFRame page call outside of the Framework) Thanks Kevin Penny, MMCP ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229051 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
I'm not familiar with that particular tool. But, it shouldn't matter that you have a column named patchid. It would matter if you had another object called patchid (table, trigger, proc, etc). In which case you should get an error about it already existing. You can just run the query select patchid.nextval from dual; to see if it worked properly. Also, in the tool that I use, there are two ways to execute - either via script or as a statement. If you're executing as a statement, you can't have the semi-colon. As script you can. In my tool, you get an error that says, invalid character if you try to execute something as a statment that's actually a script. I use TOAD, by the way, which has a free version. Tis very nice, I highly recommend it. As an aside, you do realize that your'e not creating an auto-incrementing field ala access or sql server, right? You're creating a sequence that you can use to populate the field. -d On 1/10/06, Stuart Kidd [EMAIL PROTECTED] wrote: Thanks for that Hatton. I managed to get the query window open and put a query inside but seem to get some errors. CREATE SEQUENCE PATCHID MINVALUE 1 MAXVALUE 999 START WITH 1 INCREMENT BY 1 CACHE 20; Do you know whether my sequence should have a semi-colan at the end? Also, the actual field name is called PATCHID, should i call this sequence something else? If i take off the semi-colan and give the seq a random name it seems to come up with no errors but is there a way i can see whether it actually did anything? Thanks for your time, Saturday ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229052 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
raptor...still SOT(WAS Re: SOT: Aqua Studio / Oracle)
fyi, Oracle has a new tool called Raptor http://www.oracle.com/technology/products/database/project_raptor/index.html I have been using it for a week now...nice. DK On 1/10/06, Stuart Kidd [EMAIL PROTECTED] wrote: Thanks for that Hatton. I managed to get the query window open and put a query inside but seem to get some errors. CREATE SEQUENCE PATCHID MINVALUE 1 MAXVALUE 999 START WITH 1 INCREMENT BY 1 CACHE 20; Do you know whether my sequence should have a semi-colan at the end? Also, the actual field name is called PATCHID, should i call this sequence something else? If i take off the semi-colan and give the seq a random name it seems to come up with no errors but is there a way i can see whether it actually did anything? Thanks for your time, Saturday From: C. Hatton Humphrey [EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 11:40 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: SOT: Aqua Studio / Oracle I don't know whether anyone has used Aqua Studio before but in case you have then maybe you can help. I am trying to create a field with an incremental ID. I found this clever script: CREATE SEQUENCE supplier_seq MINVALUE 1 START WITH 1 INCREMENT BY 1 CACHE 20; but i have no idea where i should run that script. Is there a way to create a seq via the GUI? (I'm missing Enterprise Manager!) If you're talking about opening up a query window, select the server, the database and the table on the left and hit CTRL-Q (or right click and select New Query Window) Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Javascript timeout
Hi Guys. I used Bobby's script located at http://www.mcfedries.com/JavaScript/timer.asp and it works. However, when the user hits the back button, the timer again starts at 10 seconds. Is there a way to stop that from happening. I do not want to reset the time if the back-button is used. It should say Time Over. Any ideas? On 1/9/06, Bobby Hartsfield [EMAIL PROTECTED] wrote: http://www.mcfedries.com/JavaScript/timer.asp first link I saw on google. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 2:07 PM To: CF-Talk Subject: Javascript timeout Hi. I have a form where the user is entering info. There is a closing time for that posting in the db. I want to give regular reminders to the user, that so many minutes are remaining to complete it. I want to give a javascript alert 30 mins, 5 mins, 1 mins and then finally when the time is over, show them an alert and go away from that page. Please help with sample script. Thanks, Ken ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229054 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
On 1/10/06, Stuart Kidd [EMAIL PROTECTED] wrote: Thanks for that Hatton. I managed to get the query window open and put a query inside but seem to get some errors. CREATE SEQUENCE PATCHID MINVALUE 1 MAXVALUE 999 START WITH 1 INCREMENT BY 1 CACHE 20; If you don't want a max value, use the NOMAXVALUE attribute instead of the MAXVALUE with that number. Do you know whether my sequence should have a semi-colan at the end? Also, the actual field name is called PATCHID, should i call this sequence something else? In AquaData, no, you don't want the semi-colon at the end. If i take off the semi-colan and give the seq a random name it seems to come up with no errors but is there a way i can see whether it actually did anything? SELECT patchid.nextval FROM dual Thanks for your time, Your welcome. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229055 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Aqua Studio / Oracle
I typically prepend my sequence names with SEQ_ and then the table that I intend to use it with. So if for table PATCHES I would call mine SEQ_PATCHES. Then if I was populating that PATCHID field with the sequence value through a trigger I would have a trigger named TRG_PATCHES On 1/10/06, Stuart Kidd [EMAIL PROTECTED] wrote: Thanks for that Hatton. I managed to get the query window open and put a query inside but seem to get some errors. CREATE SEQUENCE PATCHID MINVALUE 1 MAXVALUE 999 START WITH 1 INCREMENT BY 1 CACHE 20; Do you know whether my sequence should have a semi-colan at the end? Also, the actual field name is called PATCHID, should i call this sequence something else? If i take off the semi-colan and give the seq a random name it seems to come up with no errors but is there a way i can see whether it actually did anything? Thanks for your time, Saturday ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: action script copy by value
The biggest still being how on Earth to attach a click listener to checkbox in a cfgrid when using cfgridcolumn type=Boolean -- I haven't dove too deep into Flash Forms (Flex2 is my next endeavor), so I might be off in left field... From within Flash, to even get a checkbox or anything other than plaintext into a datagrid cell, you have to use a custom cell renderer. This renderer is really just a class that receives the data for the cell and provides the layout and even capabilities for the cell. Within this class, you could further alter how events are handled. Here's my quick fix for this. If you can get any event at all for the contents of the cell, than trigger the event for the other or simply include the event's callback within only 1 handler and act accordingly. So if you had... function handleCKBox ():Void { trace (Checkbox clicked); } function handleCell ():Void { trace (Cell clicked); } Than you could just combine them and use conditionals to handle it... function handleEvent ():Void { trace (Checkbox clicked); trace (Cell clicked); } Cheers, Kevin -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: January 10, 2006 10:53 AM To: CF-Talk Subject: RE: action script copy by value Kevin, thank you very much for your help. --The statement above is using the remoting bindings and 'results' refers to an object, not an array. That makes perfect sense. I had just assumed that the results object would be a list-based object and inherit the length property etc... Other than looping, why other way IS there to copy the grid items when the dataProvider is bound to the object returned by remoting? --Short answer... no. Long answer... by subclassing the datagrids classes and than extending the columns class, you could do it. Of course you'd need a pretty deep knowledge of the AS2 framework and UIObject though... Cool. I figured as much. At first I was hoping maybe someone else had done that before and would have a copy and paste answer-- but I get the impression a lot of people really haven't dived too deep into pushing flash forms to the limits. :) Maybe you can answer some of my other quandaries I have found. The biggest still being how on Earth to attach a click listener to checkbox in a cfgrid when using cfgridcolumn type=Boolean I have attaching every listener to the grid itself with zero luck. The check box always eats the event and doesn't pass it along to cellClick or cellPress. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: ColdFusion Podcast Episode 10
We're talking about AJAX,OO Programming, and the future of web applications this week. Let us know your comments! Thanks, Michael http://www.coldfusionpodcast.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229058 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Stored Procedure Help
Does anyone know how to loop over a list that you have passed into a stored procedure (from within the stored procedure)? I am trying to insert some relationships into a table: i.e. insert user details and pass a list of permissions (e.g. 1, 4, 6, 8) loop over user permission list insert permission end loop this is with MS SQL. Sorry for the OT but I thought someone here might know... been making my bald spot bigger by the amount of head-scratching I am going through -- Mark Drew http://www.markdrew.co.uk/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229059 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: action script copy by value
Thanks Kevin. I had assumed that Cold Fusion simply assigned a special cellRenderer to that column to generate the check box. The only think is, I don't have access to the code in that cellRenderer since it is encapsulated in the cfgridcolumn tag. I don't know if it is possible to modify the cellRenderer after the form loads, or if all of its internal methods are private. I have a feeling that the current cellRenderer is eating the click event and not passing it along to the grid. If I could find an already-made checkbox cellRenderer then I could to use that one instead and then have the ability to tweak the code. I'm not sure where to look online a pre-built example of something like that. If I were to have code I could modify I would do a lot better than having to write something myself. ~Brad -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 11:30 AM To: CF-Talk Subject: RE: action script copy by value The biggest still being how on Earth to attach a click listener to checkbox in a cfgrid when using cfgridcolumn type=Boolean -- I haven't dove too deep into Flash Forms (Flex2 is my next endeavor), so I might be off in left field... From within Flash, to even get a checkbox or anything other than plaintext into a datagrid cell, you have to use a custom cell renderer. This renderer is really just a class that receives the data for the cell and provides the layout and even capabilities for the cell. Within this class, you could further alter how events are handled. Here's my quick fix for this. If you can get any event at all for the contents of the cell, than trigger the event for the other or simply include the event's callback within only 1 handler and act accordingly. So if you had... function handleCKBox ():Void { trace (Checkbox clicked); } function handleCell ():Void { trace (Cell clicked); } Than you could just combine them and use conditionals to handle it... function handleEvent ():Void { trace (Checkbox clicked); trace (Cell clicked); } Cheers, Kevin -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: January 10, 2006 10:53 AM To: CF-Talk Subject: RE: action script copy by value Kevin, thank you very much for your help. --The statement above is using the remoting bindings and 'results' refers to an object, not an array. That makes perfect sense. I had just assumed that the results object would be a list-based object and inherit the length property etc... Other than looping, why other way IS there to copy the grid items when the dataProvider is bound to the object returned by remoting? --Short answer... no. Long answer... by subclassing the datagrids classes and than extending the columns class, you could do it. Of course you'd need a pretty deep knowledge of the AS2 framework and UIObject though... Cool. I figured as much. At first I was hoping maybe someone else had done that before and would have a copy and paste answer-- but I get the impression a lot of people really haven't dived too deep into pushing flash forms to the limits. :) Maybe you can answer some of my other quandaries I have found. The biggest still being how on Earth to attach a click listener to checkbox in a cfgrid when using cfgridcolumn type=Boolean I have attaching every listener to the grid itself with zero luck. The check box always eats the event and doesn't pass it along to cellClick or cellPress. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229060 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: action script copy by value
I'm not sure if you can use a cellRenderer, but you could at least use labelfunction to alter each cell as they were set. http://www.asfusion.com/blog/entry/using-labelfunction-to-format-cfgrid Cheers, Kevin -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: January 10, 2006 11:52 AM To: CF-Talk Subject: RE: action script copy by value Thanks Kevin. I had assumed that Cold Fusion simply assigned a special cellRenderer to that column to generate the check box. The only think is, I don't have access to the code in that cellRenderer since it is encapsulated in the cfgridcolumn tag. I don't know if it is possible to modify the cellRenderer after the form loads, or if all of its internal methods are private. I have a feeling that the current cellRenderer is eating the click event and not passing it along to the grid. If I could find an already-made checkbox cellRenderer then I could to use that one instead and then have the ability to tweak the code. I'm not sure where to look online a pre-built example of something like that. If I were to have code I could modify I would do a lot better than having to write something myself. ~Brad -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 11:30 AM To: CF-Talk Subject: RE: action script copy by value The biggest still being how on Earth to attach a click listener to checkbox in a cfgrid when using cfgridcolumn type=Boolean -- I haven't dove too deep into Flash Forms (Flex2 is my next endeavor), so I might be off in left field... From within Flash, to even get a checkbox or anything other than plaintext into a datagrid cell, you have to use a custom cell renderer. This renderer is really just a class that receives the data for the cell and provides the layout and even capabilities for the cell. Within this class, you could further alter how events are handled. Here's my quick fix for this. If you can get any event at all for the contents of the cell, than trigger the event for the other or simply include the event's callback within only 1 handler and act accordingly. So if you had... function handleCKBox ():Void { trace (Checkbox clicked); } function handleCell ():Void { trace (Cell clicked); } Than you could just combine them and use conditionals to handle it... function handleEvent ():Void { trace (Checkbox clicked); trace (Cell clicked); } Cheers, Kevin -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: January 10, 2006 10:53 AM To: CF-Talk Subject: RE: action script copy by value Kevin, thank you very much for your help. --The statement above is using the remoting bindings and 'results' refers to an object, not an array. That makes perfect sense. I had just assumed that the results object would be a list-based object and inherit the length property etc... Other than looping, why other way IS there to copy the grid items when the dataProvider is bound to the object returned by remoting? --Short answer... no. Long answer... by subclassing the datagrids classes and than extending the columns class, you could do it. Of course you'd need a pretty deep knowledge of the AS2 framework and UIObject though... Cool. I figured as much. At first I was hoping maybe someone else had done that before and would have a copy and paste answer-- but I get the impression a lot of people really haven't dived too deep into pushing flash forms to the limits. :) Maybe you can answer some of my other quandaries I have found. The biggest still being how on Earth to attach a click listener to checkbox in a cfgrid when using cfgridcolumn type=Boolean I have attaching every listener to the grid itself with zero luck. The check box always eats the event and doesn't pass it along to cellClick or cellPress. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229061 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Actually of that is to do with rhe fact that no-one in the cf community wants to give away anything for free. Everyone who writes some crappy tag tries to sell it. Snake -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 10 January 2006 04:14 To: CF-Talk Subject: Re: cf open shopping cart I agree with some of justins points but the other communities don't seem to have that excuse so why should we? It's just people being lazy is all it is Personally, I don't care, if i need a quick solution I'll just go over to the php community and get it. With my tail between my legs and be ridiculed because the cfm community is so self centered and lame. They are right, we don't have crap, no wonder why we are perceived how we are. Casey, you could be right to but why even try, can't you see that cfm dev'rs don't care enough, except the rays of the community which aren't very many. I'd be first on board but now i'm gunna be like everyone else and say sorry but I'm too important to help with such a petty project, instead I'm gunna go drive around in my yugo and listen to geek podcasts while stalking hot chics... Personally, I think most people on here are to selfconscious to let us all see the code THEY actually write. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Casey Dougall [EMAIL PROTECTED] Sent: Monday, January 09, 2006 10:56 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cf open shopping cart Right on Justin, trying to START a project like this as a community effort will lead to disaster. I think this is a case of oscommerce envy. People love Open-Source and Free but haven't been around enough to see just how much hassle it it to keep something like that going. I bet Harald the man who started it all at OSC from time to time held his finger on the kill button saying GADS Just shut up already! But some how kept that project going. Granted it's got some little flaws but dam... Mind you I rember when Hostscripts.com listed more Perl scripts then PHP. If you can make that in coldfusion and have the developer network to back it up, I all about assisting, buy why? People are still selling online but it's so centralized that a shopping cart of that nature takes hours of hacking to get where you client might need so why bother. As long as the Gateway API's keep rolling out who cares about full shopping carts. When I look at hotscripts.com I see huge potentle for Coldfusion developers to pick it up a notch and show the world we actually can work for free. Who's first? Casey ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Procedure Help
Not sure if this works, I grabbed it from a bunch of snippets I have. DECLARE @list VARCHAR(100), @loop BIT, @item INT SET @list = '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15' SET @loop = 1 WHILE @loop = 1 BEGIN -- If we can't find the delimiter the last element is all that's left of the list IF CHARINDEX(',', @list, 1) = 0 BEGIN SET @item = @list SET @loop = 0 END ELSE BEGIN -- Extract the first element SET @item = SUBSTRING(@list, 0, CHARINDEX(',', @list, 1)) -- Remove the first element from the list SET @list = SUBSTRING(@list, LEN(@item) + 2, LEN(@list)) END SELECT @item 'List Item' END Ade -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 10 January 2006 17:52 To: CF-Talk Subject: OT: Stored Procedure Help Does anyone know how to loop over a list that you have passed into a stored procedure (from within the stored procedure)? I am trying to insert some relationships into a table: i.e. insert user details and pass a list of permissions (e.g. 1, 4, 6, 8) loop over user permission list insert permission end loop this is with MS SQL. Sorry for the OT but I thought someone here might know... been making my bald spot bigger by the amount of head-scratching I am going through -- Mark Drew http://www.markdrew.co.uk/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229063 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Professional Opinions on HostMySite.com
All, The company that I work for is considering HostMySite.com to host our web and email presence. (I use them to host my personal site http://www.sstwebworks.com http://www.sstwebworks.com/ ) I need to know who's got a small business web presence with HostMySite and what your experience has been (good and bad) Thanks sas Scott A. Stewart Webmaster/Developer 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229064 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fusebox IFrame Bug
You the man John - Thanks a ton - (is this documented anywhere? - Known issues?) -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 10:04 AM To: CF-Talk Subject: Re: Fusebox IFrame Bug you'll get the same behaviour using normal frames too - the problem is the two requests are running and one request overwrites the application stored structure - if you change the mode from development to production the problem will go away as the application structure will not be recreated on every request, john. Weird, do you have any variable locking problems where two concurrent page requests from the same session are hitting heads? What happens if you type the address of the iframe in the main url and load that page by itself? Is there any # or characters getting in the iframe src that could be screwing with the iframe's url parameters? ~Brad -Original Message- From: Kevin Penny [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 10:12 AM To: CF-Talk Subject: Fusebox IFrame Bug Not sure who to blame on this one but what I'm finding is that when using FuseBox 4.1 framework I have a page that has an Iframe in the middle of it which shows another page from the framework - When the entire page is loaded all at once, I'll get random Framework/Fusebox errors within the Iframe window Every Time the main page is loaded I.e. Element FUSEBOX.FUSEACTIONVARIABLE is undefined in APPLICATION Or other errors that seem to come from my application - Process is: a. User navigates to URL index.cfm?fuse=x.y b. Page is loaded and has an embedded Iframe which calls index.cfm?fuse=x.z c. Iframe area always throws a Fusebox type error in the window instead of properly loading index.cfm?fuse=x.z d. I right click and reload Iframe window - works fine every time. So I right click and refresh/reload the IFRame all by itself, the page comes up fine, the url is the same and no errors ever. It's like there's some sort of 'conflict' for the framework call when there is a fusebox page that has an Iframe embedded in itself which calls another framework circuit. Anyone ever encounter this before or know of a work around? (Other than putting the IFRame page call outside of the Framework) Thanks Kevin Penny, MMCP ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229065 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
or so. These folks are working for me on a HUGE federal government project which is an equally HUGE change in the way they do business. To top it off this project has spurred on some much needed house cleaning from a data standpointcreating a bunch of spin-off projects. These are CF 7, Oracle 9i, JS/DMHTML/AJAX. Careful with that AJAX stuff and the Feds, they'll go all 508 on ya :) -Joe -- Get Glued! The Model-Glue ColdFusion Framework http://www.model-glue.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229066 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Eclipse is the One Ring?
LOL, yeah I guess if you follow the logic through from the books, then that would be the correct conclusion. But really this was just a silly diversion. I currently use Eclipse with CFEclipse, EPIC for perl, JSEclipse for JavaScript, and XMLBuddy. So I would be very upset if Eclipse were destroyed. ;) -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 9:36 PM To: CF-Talk Subject: Re: OT: Eclipse is the One Ring? Um, so are you saying that Eclipse must be destroyed? On 1/10/06, Munson, Jacob [EMAIL PROTECTED] wrote: 9 tools were given to the leaders of open source, for they were the weakest. 7 to Microsoft developers, who loved darkness, gold, and war. 3 were given to web developers, the fairest and wisest of all. In darkness and with guile, one tool was crafted in the depths of silicon volcano. One tool to rule them all, one tool to find them, one tool to bring them all and in the darkness bind them. After the fall of IBM, the One Tool was lost to the developers. But one day it fell into the hands of the most curious of creatures. An innocent startup who would forever change the course of Middle IT. http://www.bsdg.org/2006/01/lord-of-tools.shtml This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229067 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Retaining form data after navigating away?
I'm sure there is an elegant solution to this, I just don't know what it is. I have a form. Text fields, dropdowns, that sort of thing. One dropdown field has companies with a listing of companies. If a company is not in the dropdown, the user needs to add that company to the database, which is a form on a different page. This requires that the user navigates away from the form, but they might have already entered some data in the original form. I don't want to have them retype the info. The approach I am headed towards now is having the add company link actually submit the form to an interstitial page that dumps the form data into a session.redirect structure that I created, then redirects the user to the add company form. The problem I am having is that the data in the session.redirect structure is being lost when the interstitial page redirects to the add company form, so all the original form data (and the URL that should be navigated back to) is being lost. Is there a more elegant solution to this problem? Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229068 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Professional Opinions on HostMySite.com
I have heard a lot of good things about them, but lately their response has been less then stellar. It's true that when you call them up you get to speak to somebody most of the time. Except that somebody is usually either a CSR or a low level tech. If you need something to get done that requires any skill at all, it will be forwarded to a higher level tech that's impossible to get on the phone. So far I've been very disappointed. Now, perhaps, what I'm asking for is unreasonable (I need a load balancer configured a certain way), but the response I've been getting is horrible. It takes them half a day to respond to a ticket on this issue, and they tell me it's done, and when I test it, it still doesn't work. And same thing the next day. If they are really as good as people say they are then in my opinion they are very understaffed right now, so I wouldn't expect to get good support. If you can afford it, go with rackspace. They have great support, and you can actually speak on the phone to a real tech that handles your problem. I can't tell you how frustrating it is to communicate to the tech handling my situation either through email or playing broken telephone with a CSR. Just my $0.02 Russ -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 1:12 PM To: CF-Talk Subject: Professional Opinions on HostMySite.com All, The company that I work for is considering HostMySite.com to host our web and email presence. (I use them to host my personal site http://www.sstwebworks.com http://www.sstwebworks.com/ ) I need to know who's got a small business web presence with HostMySite and what your experience has been (good and bad) Thanks sas Scott A. Stewart Webmaster/Developer 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229069 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Professional Opinions on HostMySite.com
Scott Stewart wrote: All, The company that I work for is considering HostMySite.com to host our web and email presence. (I use them to host my personal site http://www.sstwebworks.com http://www.sstwebworks.com/ ) I need to know who's got a small business web presence with HostMySite and what your experience has been (good and bad) Thanks sas Scott A. Stewart Webmaster/Developer 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 Are you considering one of their VPS Plans or one of their Shared Hosting plans? Experiences may vary depending on the plan. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229070 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Professional Opinions on HostMySite.com
Probably the shared hosting... sas Scott A. Stewart ColdFusion Developer GNSI 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 1:35 PM To: CF-Talk Subject: Re: Professional Opinions on HostMySite.com Scott Stewart wrote: All, The company that I work for is considering HostMySite.com to host our web and email presence. (I use them to host my personal site http://www.sstwebworks.com http://www.sstwebworks.com/ ) I need to know who's got a small business web presence with HostMySite and what your experience has been (good and bad) Thanks sas Scott A. Stewart Webmaster/Developer 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 Are you considering one of their VPS Plans or one of their Shared Hosting plans? Experiences may vary depending on the plan. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229071 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
508?? Careful with that AJAX stuff and the Feds, they'll go all 508 on ya :) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229072 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Retaining form data after navigating away?
I have done this before by having them add the company in a popup window. After the popup saves and right before it closes, call a function in the opener window to reload the options in the drop down. A hidden iframe works nicely here. Refresh the iframe which has a query-built JavaScript loop to rebuild the option in the dropdown which is in its parent. I think that sounded more complicated than it actually is-- once you get it working it is kind of nice. If you really to pass everything along, you can just keep track of it in hidden fields, or loop over your form collection and built a query string of names and values you can store in a hidden fields and pass back in when they make it full circle back to the original form. Of course, the form will need to be coded properly to repopulate itself. I'd go with the pop up and the iframe trick. ~Brad -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 12:18 PM To: CF-Talk Subject: Retaining form data after navigating away? I'm sure there is an elegant solution to this, I just don't know what it is. I have a form. Text fields, dropdowns, that sort of thing. One dropdown field has companies with a listing of companies. If a company is not in the dropdown, the user needs to add that company to the database, which is a form on a different page. This requires that the user navigates away from the form, but they might have already entered some data in the original form. I don't want to have them retype the info. The approach I am headed towards now is having the add company link actually submit the form to an interstitial page that dumps the form data into a session.redirect structure that I created, then redirects the user to the add company form. The problem I am having is that the data in the session.redirect structure is being lost when the interstitial page redirects to the add company form, so all the original form data (and the URL that should be navigated back to) is being lost. Is there a more elegant solution to this problem? Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
Careful with that AJAX stuff and the Feds, they'll go all 508 on ya :) We're in Canada...no such beastie as 508 here (although we have an equivalent)no matter thoughinternal app so those rules do not applythansk though ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229074 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
A, you lucky Canadians and your common-sense approach to self-governance! I took my first trip to Canada last spring, and thought it was an absolutely great country. -Joe On 1/10/06, Bryan Stevenson [EMAIL PROTECTED] wrote: Careful with that AJAX stuff and the Feds, they'll go all 508 on ya :) We're in Canada...no such beastie as 508 here (although we have an equivalent)no matter thoughinternal app so those rules do not applythansk though ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229075 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
A, you lucky Canadians and your common-sense approach to self-governance! I took my first trip to Canada last spring, and thought it was an absolutely great country. -Joe Come back and see us anytime Joeglad ya liked it ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229076 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Podcast Episode 10
From: http://www.dcooper.org/blog//client/index.cfm?mode=entryentry=A1B8B067-4E22 -1671-5161C140E81A92B3 As you may know, the Adobe ColdFusion team is hard at work on Scorpio, the next major release of the ColdFusion product. We're making great progress, but we've decided some functionality in particular is just too sweet to hold onto till then, and so the next stop will be Mystic. Does this mean CF7.5? Ade -Original Message- From: Michael T. Haynie [mailto:[EMAIL PROTECTED] Sent: 10 January 2006 17:42 To: CF-Talk Subject: OT: ColdFusion Podcast Episode 10 We're talking about AJAX,OO Programming, and the future of web applications this week. Let us know your comments! Thanks, Michael http://www.coldfusionpodcast.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229077 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
508 = accessibility compliance Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229078 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Podcast Episode 10
That's awesome. Too bad we're not even using MX 7 yet. :( !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 1:25 PM To: CF-Talk Subject: RE: ColdFusion Podcast Episode 10 From: http://www.dcooper.org/blog//client/index.cfm?mode=entryentry=A1B8B067-4E22 -1671-5161C140E81A92B3 As you may know, the Adobe ColdFusion team is hard at work on Scorpio, the next major release of the ColdFusion product. We're making great progress, but we've decided some functionality in particular is just too sweet to hold onto till then, and so the next stop will be Mystic. Does this mean CF7.5? Ade ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229079 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
Damn... lost another one to #replace(str, Geiko, Canada)#... ;-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 2:09 PM To: CF-Talk Subject: Re: cf open shopping cart A, you lucky Canadians and your common-sense approach to self-governance! I took my first trip to Canada last spring, and thought it was an absolutely great country. -Joe Come back and see us anytime Joeglad ya liked it ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229080 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Retaining form data after navigating away?
If you can depend on JS, I'd go with it. You could have a link that pops up a window with the company name form (or even makes a hidden div with the form in it visible). When it's submitted, add it to the database and append the new option to the drop down (via JS) with the new company info. Then close the company form or whatever... But you never leave the primary form this way. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 1:18 PM To: CF-Talk Subject: Retaining form data after navigating away? I'm sure there is an elegant solution to this, I just don't know what it is. I have a form. Text fields, dropdowns, that sort of thing. One dropdown field has companies with a listing of companies. If a company is not in the dropdown, the user needs to add that company to the database, which is a form on a different page. This requires that the user navigates away from the form, but they might have already entered some data in the original form. I don't want to have them retype the info. The approach I am headed towards now is having the add company link actually submit the form to an interstitial page that dumps the form data into a session.redirect structure that I created, then redirects the user to the add company form. The problem I am having is that the data in the session.redirect structure is being lost when the interstitial page redirects to the add company form, so all the original form data (and the URL that should be navigated back to) is being lost. Is there a more elegant solution to this problem? Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229081 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Javascript timeout
That might be a tough one. AJAX comes to mind (back button would do the user no good if they didn't leave the page) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 12:09 PM To: CF-Talk Subject: Re: Javascript timeout Hi Guys. I used Bobby's script located at http://www.mcfedries.com/JavaScript/timer.asp and it works. However, when the user hits the back button, the timer again starts at 10 seconds. Is there a way to stop that from happening. I do not want to reset the time if the back-button is used. It should say Time Over. Any ideas? On 1/9/06, Bobby Hartsfield [EMAIL PROTECTED] wrote: http://www.mcfedries.com/JavaScript/timer.asp first link I saw on google. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 2:07 PM To: CF-Talk Subject: Javascript timeout Hi. I have a form where the user is entering info. There is a closing time for that posting in the db. I want to give regular reminders to the user, that so many minutes are remaining to complete it. I want to give a javascript alert 30 mins, 5 mins, 1 mins and then finally when the time is over, show them an alert and go away from that page. Please help with sample script. Thanks, Ken ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Stored Procedure Help
Does anyone know how to loop over a list that you have passed into a stored procedure (from within the stored procedure)? I am trying to insert some relationships into a table: i.e. insert user details and pass a list of permissions (e.g. 1, 4, 6, 8) loop over user permission list insert permission end loop this is with MS SQL. Sorry for the OT but I thought someone here might know... been making my bald spot bigger by the amount of head-scratching I am going through -- Mark Drew http://www.markdrew.co.uk/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229083 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusebox IFrame Bug
I have an entry on my blog concerning it - http://john.beynon.org.uk/index.cfm/2005/1/18/framesets-and-Fusebox-41 :) On 1/10/06, Kevin Penny [EMAIL PROTECTED] wrote: You the man John - Thanks a ton - (is this documented anywhere? - Known issues?) -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 10:04 AM To: CF-Talk Subject: Re: Fusebox IFrame Bug you'll get the same behaviour using normal frames too - the problem is the two requests are running and one request overwrites the application stored structure - if you change the mode from development to production the problem will go away as the application structure will not be recreated on every request, john. Weird, do you have any variable locking problems where two concurrent page requests from the same session are hitting heads? What happens if you type the address of the iframe in the main url and load that page by itself? Is there any # or characters getting in the iframe src that could be screwing with the iframe's url parameters? ~Brad -Original Message- From: Kevin Penny [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 10:12 AM To: CF-Talk Subject: Fusebox IFrame Bug Not sure who to blame on this one but what I'm finding is that when using FuseBox 4.1 framework I have a page that has an Iframe in the middle of it which shows another page from the framework - When the entire page is loaded all at once, I'll get random Framework/Fusebox errors within the Iframe window Every Time the main page is loaded I.e. Element FUSEBOX.FUSEACTIONVARIABLE is undefined in APPLICATION Or other errors that seem to come from my application - Process is: a. User navigates to URL index.cfm?fuse=x.y b. Page is loaded and has an embedded Iframe which calls index.cfm?fuse=x.z c. Iframe area always throws a Fusebox type error in the window instead of properly loading index.cfm?fuse=x.z d. I right click and reload Iframe window - works fine every time. So I right click and refresh/reload the IFRame all by itself, the page comes up fine, the url is the same and no errors ever. It's like there's some sort of 'conflict' for the framework call when there is a fusebox page that has an Iframe embedded in itself which calls another framework circuit. Anyone ever encounter this before or know of a work around? (Other than putting the IFRame page call outside of the Framework) Thanks Kevin Penny, MMCP ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229084 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Procedure Help
Is this a comma delimited list, or an xml document. I use xml a lot when I want to pass in a variable length list of items to change. Very handy MS SQl's XML functionality. ~Brad -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 11:41 AM To: CF-Talk Subject: OT: Stored Procedure Help Does anyone know how to loop over a list that you have passed into a stored procedure (from within the stored procedure)? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229085 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Retaining form data after navigating away?
This sounds like the ideal approach. Do you have any code samples? Thanks, Pete On 1/10/06, Brad Wood [EMAIL PROTECTED] wrote: I have done this before by having them add the company in a popup window. After the popup saves and right before it closes, call a function in the opener window to reload the options in the drop down. A hidden iframe works nicely here. Refresh the iframe which has a query-built JavaScript loop to rebuild the option in the dropdown which is in its parent. I think that sounded more complicated than it actually is-- once you get it working it is kind of nice. If you really to pass everything along, you can just keep track of it in hidden fields, or loop over your form collection and built a query string of names and values you can store in a hidden fields and pass back in when they make it full circle back to the original form. Of course, the form will need to be coded properly to repopulate itself. I'd go with the pop up and the iframe trick. ~Brad -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 12:18 PM To: CF-Talk Subject: Retaining form data after navigating away? I'm sure there is an elegant solution to this, I just don't know what it is. I have a form. Text fields, dropdowns, that sort of thing. One dropdown field has companies with a listing of companies. If a company is not in the dropdown, the user needs to add that company to the database, which is a form on a different page. This requires that the user navigates away from the form, but they might have already entered some data in the original form. I don't want to have them retype the info. The approach I am headed towards now is having the add company link actually submit the form to an interstitial page that dumps the form data into a session.redirect structure that I created, then redirects the user to the add company form. The problem I am having is that the data in the session.redirect structure is being lost when the interstitial page redirects to the add company form, so all the original form data (and the URL that should be navigated back to) is being lost. Is there a more elegant solution to this problem? Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229086 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Optimizing IIS6 for CFMX
Hola. Does anyone know of a good link to a page that discusses best practices for dealing with IIS6 and CFMX 7 Thanks! Tony ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229087 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Optimizing IIS6 for CFMX
If you find anything that doesn't make the list please forward your findings. Thanks, Ken -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 12:53 PM To: CF-Talk Subject: Optimizing IIS6 for CFMX Hola. Does anyone know of a good link to a page that discusses best practices for dealing with IIS6 and CFMX 7 Thanks! Tony ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229088 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Retaining form data after navigating away?
How about, on the same form, you give them the option to enter the name of the nonexistent company. Then, on your action page, if you detect that they entered a new company, catch that and have them finish entering that data. Then you can continue and handle the results of the first form after that... --Ferg Pete Ruckelshaus wrote: I'm sure there is an elegant solution to this, I just don't know what it is. I have a form. Text fields, dropdowns, that sort of thing. One dropdown field has companies with a listing of companies. If a company is not in the dropdown, the user needs to add that company to the database, which is a form on a different page. This requires that the user navigates away from the form, but they might have already entered some data in the original form. I don't want to have them retype the info. The approach I am headed towards now is having the add company link actually submit the form to an interstitial page that dumps the form data into a session.redirect structure that I created, then redirects the user to the add company form. The problem I am having is that the data in the session.redirect structure is being lost when the interstitial page redirects to the add company form, so all the original form data (and the URL that should be navigated back to) is being lost. Is there a more elegant solution to this problem? Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229089 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Professional Opinions on HostMySite.com
I've got a couple of small sites (~1000 sessions/day) on their CF Builder+ plan (which they recently more-or-less doubled the specs of at no cost). Been very happy with them. Had one or two problems with their control panel admin interface but when I submit a support ticket everything gets dealt with very quickly. They keep wishing me in a good evening when it's the middle of the day but that's because they're in some wacky time zone (i.e. the US). -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 January 2006 7:31 a.m. To: CF-Talk Subject: Professional Opinions on HostMySite.com All, The company that I work for is considering HostMySite.com to host our web and email presence. (I use them to host my personal site http://www.sstwebworks.com http://www.sstwebworks.com/ ) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229090 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Professional Opinions on HostMySite.com
BTW they have a good range of custom tags installed too. http://www.hostmysite.com/support/cfusion/cftags/ -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 January 2006 7:31 a.m. To: CF-Talk Subject: Professional Opinions on HostMySite.com All, The company that I work for is considering HostMySite.com to host our web and email presence. (I use them to host my personal site http://www.sstwebworks.com http://www.sstwebworks.com/ ) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229091 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Professional Opinions on HostMySite.com
Scott, I have sites for three of my clients hosted there. I've been generally happy with them. We've had a few technical difficulties, but the problems were addressed. The sites that I have there depend on regular FTP uploads from the client's location, and we have had two problems with that. 1. Two of the sites were apparently at one datacenter and one was at the other. On the two, the FTP upload would fail. It took a bit of legwork to prove to hostmysite that the problem was on their end...but once they realized that I had a site at one datacenter that was working well, they moved both of the other sites there as well...no problems since. 2. Whatever program they use for FTP keeps a cached value for your disk limit. As you FTP items up, it adds to that value. In the case of these sites, we FTP a lot up, but it is not all kept up there...there is further processing that may delete some items or overwrite others. But the FTP program thinks you have reached your limit when you haven't and you have to call them to reset the value. They turned off the checking for the main site where this was a problem when I pointed this out. And generally I have had a human who was reasonably competent answering the phone when I called. The only other CF host I have had much experience with is Intermedia...and hostmysite beats them hands down. Hope that helps, Jim Wright Wright Business Solutions 919-417-2257 [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229092 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Professional Opinions on HostMySite.com
I have nothing but good things to say about their hosting. A client of mine is using them now and I have used them in the past. Excellent service, not that I have had anything complicated like adjusting load balancing. Uptime has been great. I would use them again for sure. Jeff On 1/10/06, Scott Stewart [EMAIL PROTECTED] wrote: Probably the shared hosting... sas Scott A. Stewart ColdFusion Developer GNSI 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 1:35 PM To: CF-Talk Subject: Re: Professional Opinions on HostMySite.com Scott Stewart wrote: All, The company that I work for is considering HostMySite.com to host our web and email presence. (I use them to host my personal site http://www.sstwebworks.com http://www.sstwebworks.com/ ) I need to know who's got a small business web presence with HostMySite and what your experience has been (good and bad) Thanks sas Scott A. Stewart Webmaster/Developer 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 Are you considering one of their VPS Plans or one of their Shared Hosting plans? Experiences may vary depending on the plan. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Combining verity results with database query
As a follow up to this post, in case anybody has the same problem I did, I had to put the word key in brackets...something like... WHERE dbResults.primaryID = verityResults.[key] This was in MX7 running on a W2K Server box. -jim And did you try it without table aliases and with the join in the where clause: SELECT dbResults.primaryID AS primaryID, verityResults.score AS score FROM dbResults, verityResults WHERE dbResults.primaryID = verityResults.key ORDER BY verityResults.score DESC This has definitely worked for me in the past (on CF5) Pascal George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229094 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Combining verity results with database query
Why not just use a UNION in a QoQ? Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229095 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Retaining form data after navigating away?
Here are some snippets of code. I actually use a handy custom tag so most of this doesn't have to be re-written every time I want to dynamically change a drop down. It is pretty flexible, but I am sure you can take from it what you want/need when you see what it is doing. There are several ways to skin this cat. Let me know if this all makes any sense. :-) After your popup saves to the database, you would run something like this from the popup: script language=JavaScript1.1 opener.window.reload_dropdown(); window.close(); /script The main page with the form would have something like this: iframe frameborder=0 width=0 height=0 name=iframe_reloader id= iframe_reloader src=about:blank scrolling=Yes/iframe script language=javaScript function reload_dropdown() { document.iframe_reloader.location.href = 'reloader.cfm'; } /script In your reloader.cfm file (any of the options can be passed in to control how this works dynamically.): Run a query to get the new list of companies... cfparam name=url.formname default= name_of_your_form cfparam name=url.formfield default= company_dropdown_field cfparam name=url.valuefield default= query_column_for_option_value cfparam name=url.displayfield default= query_column_for_option_text cfparam name=url.selectedindex default= cfparam name=url.suppress_first_blank_option default=false script language=JavaScript1.1 cfset selectedindexset = 0 var mForm = parent.document.#url.formname#; var i; //alert(#url.selectedindex#); cfif locRecordCount gt 0 cfset locIndex = 0 cfif not url.suppress_first_blank_option cfset locRecordCount = locRecordCount + 1 mForm.#url.formfield#.options.length = #locRecordCount#; mForm.#url.formfield#.options[#locIndex#].text = ''; mForm.#url.formfield#.options[#locIndex#].value = ''; cfset locIndex = locIndex + 1 cfelse mForm.#url.formfield#.options.length = #locRecordCount#; /cfif cfloop query=query_name mForm.#url.formfield#.options[#locIndex#].text = '#jsstringformat(evaluate(url.displayfield))#'; mForm.#url.formfield#.options[#locIndex#].value = '#jsstringformat(evaluate(url.valuefield))#'; //alert('#url.selectedindex# \n #evaluate(url.valuefield)#'); cfif url.selectedindex EQ evaluate(url.valuefield) OR url.selectedindex EQ evaluate(url.displayfield) cfset selectedindexset = 1 mForm.#url.formfield#.selectedIndex = #locIndex#; //alert(#locIndex#); !--- If there is only one record on the preload, automatically select that option by default --- cfelseif locRecordCount EQ 2 cfset selectedindexset = 1 mForm.#url.formfield#.selectedIndex = #locIndex#; /cfif cfset locIndex = locIndex +1 /cfloop cfelse mForm.#url.formfield#.length = 1; mForm.#url.formfield#.options[0].text = ''; mForm.#url.formfield#.options[0].value = ''; /cfif cfif selectedindexset EQ 0 mForm.#url.formfield#.selectedIndex = -1; /cfif /script -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 2:45 PM To: CF-Talk Subject: Re: Retaining form data after navigating away? This sounds like the ideal approach. Do you have any code samples? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229096 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFILE Upload weirdness
dave wrote: While it looks like you're experiencing the issue in this TechNote, http://www.macromedia.com/go/f97044e, you should make sure that you have the cumulative updater to Merrimack installed, found here: http://www.macromedia.com/go/aae43964. I think that should resolve things. One thing that has changed in MX 7 is that you can't just use the serial number to determine what patch level you're at. You need to check the Update Level line as well on the System Information page. Yes, I found that after i emailed the list. Thanks. I wish MM would quit changing perfectly logical behaviors for stuff that just doesn't make sense. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229097 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54