Re: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree
Richard Heiser wrote: > Yeah - I've been looking around and I think you're > right. > > This is really quite astonishing - seems like a pretty > fundamental concept... Not astonishing at all. SQL is a data access language, it was not intended to be computationally complete. I think this recursion feature was only added to the standard because people set up adjacency lists models quite often while they would be better served with nested tree models and then they need something to clean up the mess. Not because recursion fits in a relational model very well. But as I said, file a feature request for WITH RECURSIVE and use one of the available stored procedures for now. Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: DWMX 2004 - Whats new for us?
> Speaking for myself, I do question the commitment from a marketing > standpoint for CF. oh, plea lets do some simple math dreamweaver mx updates: 6.1 =1 coldfusion mx updates: 1 2 3 6.1 (red sky) =4 humm.. > You said that they wished to target the PHP and ASP market, but this > doesn't explain why there was no mention of CF specific products in > their initial marketing campaign. hello, you just got red sky and php got ziltch & asp got ziltch & .net got ziltch. seems too me that they(non cf crowd) should be the ones complaing since those users probably make up 75% of the ppl who buy dw. so are you saying that we should have MM say screw u too the php & asp & only concentrate on cf? if thats the case, say goodbye too cf i surely dont see enough cf'ers too support it. personally, i see MM do a hell of a lot for the cf crowd. if you dont think so, go to adobe or M$ and see what they will do for you, LMFAO! sure we need people to voice their needs but this is getting ridulous. as far as someone mentioning their cf survey & they didnt get all they want.. i wont even comment on that no brainer. maybe im just in a bad mood & i appologize for that, but come on. folks at MM, i think you are doing a great job & thank you for that. maybe once ppl stop pouting and get more ppl too use coldfusion then the finacial capibilities will be there for MM to do something just for the coldfusion crowd. > > In the offical campaign they mention improvements for .ASP and .PHP. > But on these lists they say that us CF Coders have so much to look > forward to, > yet none of these are worth mentioning in the official marketing > campaign??? helloo. RED SKYRED SKYRED SKY..RED SKY > That does not compute. thats not the only thing thats not computing, lol > Speaking for myself, I do question the commitment from a marketing > standpoint for CF. > > You said that they wished to target the PHP and ASP market, but this > doesn't explain why there was no mention of CF specific products in > their initial marketing campaign. > > That contradicts a company wide commitment to a product and a cohesive > vision for a line of utilities that includes that product. > > It's like New Atlanta came out with an IDE for CFML and in the next > revision mentioning pages upon pages of new features for .Net and > nothing for the standard Bluedragon server, whilst saying outside the > offical marketing campaign there have been several 'exciting' > improvements for standard Bluedragon. > > That's akin to what MM is doing with their marketing. > > In the offical campaign they mention improvements for .ASP and .PHP. > But on these lists they say that us CF Coders have so much to look > forward to, > yet none of these are worth mentioning in the official marketing > campaign??? > > That does not compute. > > -Angel > > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 3:27 PM > To: CF-Talk > Subject: RE: DWMX 2004 - Whats new for us? > > For those of you who question the commitment to CF, um, hello? Did you > miss 6.1? I for one think that CFMX 6.1 is a very significant upgrade, > you may feel otherwise and are entitled to do so. Regardless, investing > as we did in CF and then releasing it as a free upgrade to me spells > Commitment (with a capital C). Yes, I know there are other departments > and product teams within Macromedia who like to play Switzerland and not > marry themselves to any product for fear of alienating users of other > technologies, but that is marketing and should be recognized as such. I > beat up on them for it, you should feel free to do the same. If you hear > nothing from the CF team for a while, get worried, until then realize > that Macromedia is a big company (i.e., not Allaire) selling lots of > products many of which generate far greater revenue than does > ColdFusion. > > --- Ben > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Index.cfm problem again
> Someone had run a "hardening" program on the IIS server and > it changed the permission settings on the directory that had > .cfm files in it. > > For any website that has cold fusion (.cfm files) on IIS, you > must set the sharing permissions to also allow "Everyone > Read". Once you do that, the cold fusion file will run fine. > > Don't forget to let the permissions propagate down thru the > sub directories or you'll be back again doing each one of them. Not to be too picky, but I'd recommend that you use the "Authenticated Users" group, or better yet, just the IUSR_MACHINENAME account if possible - if you're not using Windows authentication - instead of "Everyone". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: DWMX 2004 - Whats new for us?
> Speaking for myself, I do question the commitment from a > marketing standpoint for CF. > > You said that they wished to target the PHP and ASP market, > but this doesn't explain why there was no mention of CF > specific products in their initial marketing campaign. > > That contradicts a company wide commitment to a product > and a cohesive vision for a line of utilities that includes > that product. > > It's like New Atlanta came out with an IDE for CFML and in > the next revision mentioning pages upon pages of new features > for .Net and nothing for the standard Bluedragon server, > whilst saying outside the offical marketing campaign there > have been several 'exciting' improvements for standard > Bluedragon. > > That's akin to what MM is doing with their marketing. > > In the offical campaign they mention improvements for .ASP > and .PHP. But on these lists they say that us CF Coders have > so much to look forward to, yet none of these are worth > mentioning in the official marketing campaign??? > > That does not compute. It computes just fine to me. As a CF developer, I'm keenly aware of all upcoming MM product releases. If I were a PHP developer instead, I might not even know that MM has something I can use. Macromedia needs to sell to new customers if they want to be profitable. While it might boost our egos as CF developers if Macromedia focused all its marketing on us, it wouldn't be good for any of us in the long run. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF Version for RedSky
Thanks Jim: Hey, just out of curiousity, if you use #SERVER.COLDFUSION.ProductVersion# what do you get in the output? --David K. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Finding element in list of values in a query field.
I've seen an example somewhere that was more robust on this, but something like this might help... SELECT Firstname FROM myTable WHERE Talents LIKE '%dancing,' OR Talents LIKE '%,dancing,%' OR Talents LIKE ',dancing%' OR Talents = 'dancing' - Calvin - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 1:34 PM Subject: SQL : Finding element in list of values in a query field. > Hey all, > > Say for example I have a table: > > Firstname > Lastname > Address > Talents. > > > Talents for one record is: acting,dancing,singing. > > For another record it is : dancing,singing,music > > > I want to construct a query to find all those with dancing as a talent. > > How would I do that using SQL...*can* I do that using SQL? > > -Angel > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Appointment Times, Dates & Scheduling Issues - Best Practices?
Howdy, I recently took over a CF 4.51 site and am in the process of redesigning it for a client. Database is MS Access. The site is for a massage company that lets corporate clients sign up for on-site massages. Administrators can print copies of the day's on-site massage appointment schedule for massage therapists to take with them to a client's site. Anyway, I'm wondering about the best way to handle building the appointment schedules. The way it is right now, a day's schedule of appointments is created by looping over an "event" (a date/location) and then an inner loop hits the database for each time slot and builds the appointment/schedule table. There are only about 20 appointment slots per event schedule, but this doesn't seem very efficient to me. For those of you who've worked with building date/time schedules, would it make more sense to convert to using arrays or structures for something like this? I can show representative blocks of code the way it is right now if necessary. Thanks in advance for your thoughts. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CFMX 6.1 FreeBSD
Has anyone tried CFMX 6.1 with FreeBSD? Any luck? -Buddy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: DWMX 2004 - Whats new for us?
AMEN ty Adam > Right on Ben! > > I seriously just don't get this thread at all. Never once in my life > have I ever noticed a difference in coding speed based on the IDE I was > using. I can just see the expression on my boss's face if I'd say "sorry > I missed the deadline, but my IDE slowed me down" or "this would have > been done sooner had I had a built in debugger". > > D-Dub is a fine tool. If it's too slow for you, I suggest you buy a new > computer. I'm working on a 2-year old box and it runs like a champ. > > Quite frankly this argument has been running for so long that it's lost > all meaning to me. These issues seem like a security blanket issue, with > developers who don't want to give up on something they had for so many > years. Personally I got bored with CFStudio/Homesite (after several > years). I tried DWMX exclusively for one month and never looked back. > (Even though my initial intentions were to try it for 1-month so I could > load up on bad things to say MM about) > > Macromedia is constantly making my life easier with updates to CF and > Flash and they have supported our community like no other (even more > than Allaire imho). Is it really fair to blast them over the features of > one of their IDEs vs another? I mean they _do_ have two separate IDEs. > The _only_ reason Homesite is still around is because of the critics. > > Some of these issues are def legit, but the longer this thread goes on, > the more it is starting to sound like whining. I mean a lot of you are > just complaining about CFMX 6.1! Seriously if you guys don't like MM > that much, maybe you should go .NET and see how much MS listens to your > suggestions. > > I suggest everyone at least try mx2k4 for a month. I assure you you'll > still be able to code, and at the very least you'll have tried > something, dare I say. new. > > Adam Wayne Lehman > Web Systems Developer > Johns Hopkins Bloomberg School of Public Health > Distance Education Division > > > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 3:27 PM > To: CF-Talk > Subject: RE: DWMX 2004 - Whats new for us? > > > > I've been watching this thread with interest, and have also been > forwarding the juicy bits to all sorts of folks within Macromedia. I've > stayed out of the discussion thus far, but ... > > I use Dreamweaver. I also use HomeSite. I also use CodeWrite (which I > migrated to after Sage which I migrated to after Brief). I'd love one > editor that did it all, it does not exist yet, so I use multiple. It > seems that many of you do the same. > > And no, I do not have to use Dreamweaver, I don't even have to like > Dreamweaver, no one (not even my employer) gets to tell me what editor I > should use or like. (Anyone who thinks otherwise does not know me). I > have been a semi-advocate of Dreamweaver since DWMX (I had been a vocal > critic of Dreamweaver prior to that), I have been on the backs of the > Dreamweaver team to improve CF support for a long time and continue to > do so, I publicly acknowledge what I like about Dreamweaver, and have no > qualms about stating what it is that I don't like. I have been very > honest in discussing Dreamweaver, and have never positioned it as a CF > Studio replacement, and always positioned it as "another tool in the > tool box" while stating that the Dreamweaver team had expressed a > commitment to continue to improve ColdFusion integration. > > It's that last point that seems to be the crux of this all. And for > those of you who have complained that Dreamweaver MX 2004 does not do > enough for ColdFusion developers, well, I agree. It has improved, and > some of the biggest complaints from ColdFusion users (including the > speed and needing to always define sites) have been addressed. I would > really have liked to have seen more, and as much as I don't like the > fact that the Dreamweaver team dedicated resources to improving support > for ASP.NET and PHP I also understand the economics. This is a business, > Macromedia needs to continue to sell lots of Dreamweaver. The product > has 2,000,000+ users (or something like that) most of whom do not use > ColdFusion, the static page market is saturated and they need to go > after where the big bucks are, targeting PHP and ASP.NET users make > sense. (Whether or not those users will buy the story remains to be > seen, but the Dreamweaver team had to make that effort). It is less "we > don't care about CF" and more "we care lots about those massive user > bases". Context. > > I have a laundry list of stuff I want in Dreamweaver (or HomeSite, or > any editor). Many of the items are my own wants, others are user > suggestions, all are shared by the wider community. I want data > awareness in the IDE, I want right click introspection everywhere and > anywhere, I want IntelliJ type intelligence so that when I change a CFC > method I can keep all invocations in synch, I want speed, I want decent >
RE: DWMX 2004 - Whats new for us?
> Would you all agree, that us ColdFusion developers deserve > some love too!! For the past year and a half haven't you all > felt marginalized. Sure ColdFusion MX sports a bunch of new > features that are fantastic and the as for old advanced > features - they're tighter than ever. I'm loving cffunction, > I'm all over cfc's, and ColdFusion's ability to integrate > with FLASH is the best thing since the last "best thing". So, you're saying that CFMX, the biggest sea change in CF's history, came out and you feel marginalized? The entire product was rewritten in Java, it has all sorts of new stuff, and this makes you feel marginalized? I frankly can't imagine what herculean effort would be required to make you feel less marginalized. > However, despite all of these wonderful improvements in the > server application, I'm still not convinced that they have > committed to providing us with a solid "Development > Environment" that supports the work habits of the > sophisticated ColdFusion Developer. Think about. > Dreamweaver, a designer's tool has "component browsing" but > Homesite doesn't. What is up with that? I think it's a mistake to call Dreamweaver a "designer's tool". To me, it's a tool that's useful for both designers and developers, and in a team environment where you have both, it works very well. > ColdFusion Studio 5 was great because to me, it was well > aligned with ColdFusion 5 the server. Dreamweaver still > seems to be an overkill designers solutions. If Dreamweaver did everything that CF Studio did, and other "designers' solutions" stuff as well, would you be happy with that? I think that's Macromedia's goal. I think it's useful to chart Microsoft's progress with Visual Studio as a comparison. When they started out, Visual Studio was pretty bad - it was basically a bunch of IDEs bundled together. Today, VS.NET 2003 is a very slick editor for any .NET programming you're doing - ASP.NET, traditional Windows applications, etc. > Homesite 5.5 looks to be moving in the direction of a very > "good" HTML editor, and as for Contribute, it must have been > the boses, daughter's boyfriend cousin's idea. Well, if that's so, someone should hire the cousin right away - he's a very smart guy. Contribute is an incredible product! Is it suitable for you or me? No. But it's by far the best product of its kind available, by a long shot. Not everyone is writing CF code, you know. There are plenty of people who just want to write and maintain a few web pages without having to learn HTML. Contribute is for those people, and it works very well for them. It's a content management tool that doesn't require a complex CMS package. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: DWMX 2004 - Whats new for us?
I was wondering when you (Ben) would get involved in this thread. Good to hear from you and good to hear your points. I think (I can only speak for myself) people want to "vote with their money" to send a message to MM that they would be willing to buy HomeSite+ alone to reinforce that there is a community of CF developers that want a tool like homesite+. Maybe it is based on a fear that MM will drop HomeSite+ since it is kinda a "freebie" and freebies don't make company money. (I know it is not really a freebie) Now don't get me wrong! I like that DWMX is only $199 and HomeSite+ is included in the deal. I use both DWMX and HS+. I personally would like to see this synergy of the two products continue Or for DWMX to be made into the UBER tool that I have been dreaming of. Just my $0.02 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:27 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? I've been watching this thread with interest, and have also been forwarding the juicy bits to all sorts of folks within Macromedia. I've stayed out of the discussion thus far, but ... I use Dreamweaver. I also use HomeSite. I also use CodeWrite (which I migrated to after Sage which I migrated to after Brief). I'd love one editor that did it all, it does not exist yet, so I use multiple. It seems that many of you do the same. And no, I do not have to use Dreamweaver, I don't even have to like Dreamweaver, no one (not even my employer) gets to tell me what editor I should use or like. (Anyone who thinks otherwise does not know me). I have been a semi-advocate of Dreamweaver since DWMX (I had been a vocal critic of Dreamweaver prior to that), I have been on the backs of the Dreamweaver team to improve CF support for a long time and continue to do so, I publicly acknowledge what I like about Dreamweaver, and have no qualms about stating what it is that I don't like. I have been very honest in discussing Dreamweaver, and have never positioned it as a CF Studio replacement, and always positioned it as "another tool in the tool box" while stating that the Dreamweaver team had expressed a commitment to continue to improve ColdFusion integration. It's that last point that seems to be the crux of this all. And for those of you who have complained that Dreamweaver MX 2004 does not do enough for ColdFusion developers, well, I agree. It has improved, and some of the biggest complaints from ColdFusion users (including the speed and needing to always define sites) have been addressed. I would really have liked to have seen more, and as much as I don't like the fact that the Dreamweaver team dedicated resources to improving support for ASP.NET and PHP I also understand the economics. This is a business, Macromedia needs to continue to sell lots of Dreamweaver. The product has 2,000,000+ users (or something like that) most of whom do not use ColdFusion, the static page market is saturated and they need to go after where the big bucks are, targeting PHP and ASP.NET users make sense. (Whether or not those users will buy the story remains to be seen, but the Dreamweaver team had to make that effort). It is less "we don't care about CF" and more "we care lots about those massive user bases". Context. I have a laundry list of stuff I want in Dreamweaver (or HomeSite, or any editor). Many of the items are my own wants, others are user suggestions, all are shared by the wider community. I want data awareness in the IDE, I want right click introspection everywhere and anywhere, I want IntelliJ type intelligence so that when I change a CFC method I can keep all invocations in synch, I want speed, I want decent DB integration tools, I want a real debugger, I could go on and on and on ... I'll keep pushing and nagging. So is the new Dreamweaver the ColdFusion aware IDE I wanted? Nope. Is it a useful tool? Yes. It is an improvement over Dreamweaver MX, even for us CFers? Yes. Is it good enough to be the exclusive editor for ColdFusion developers? I'd say that depends on the developer, for experienced developers I'd say no. Is it compelling enough for Studio and HomeSite users to abandon those tools entirely for it? No. Does it have any value at all for ColdFusion developers? Absolutely. I am at least thankful that HomeSite has been given a new lease on life. HomeSite 5.5 is not a major upgrade, but it does add some important enhancements some of which I may want to use. Some of you complained about having to buy Dreamweaver to get HomeSite+, and that one irked me a bit. We seem to have forgotten that CF Studio used to sell for, what was it? $300? $400? I forget. Paying $199 for Dreamweaver + HomeSite+ is less than you paid for CF Studio itself back then. Even if you never ever look at Dreamweaver you are ahead of the game. I think that those
RE: DWMX 2004 - Whats new for us?
> That's fine. But before they make attractive for other > technologies, can they at least make it attractive to us, > coldfusion developers. I can't see an ASP or PHP developer > using a tool so oriented towards ColdFusion. Just I wouldn't > use a tool design specifically for PHP to code ColdFusion. > Who is running MACR's Dreamweaver Department. Sounds like > they have some serious ego, power, tripping issues. They > trying to be all to all. Yes, they're trying to build a good editor that can be used with multiple server-side languages. What's wrong with that? How different are CFML, ASP, and PHP when you come right down to it? Why can't we have a single tool that works with any of them? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: DWMX 2004 - Whats new for us?
> It's like New Atlanta came out with an IDE for CFML and in the next > revision mentioning pages upon pages of new features for .Net and > nothing for the standard Bluedragon server, whilst saying outside the > offical marketing campaign there have been several 'exciting' > improvements for standard Bluedragon. > Is the above meant to be hypothetical? New Atlanta has not come out with an IDE for CFML. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Caching CFCs... again
I posted earlier, but I'm still trying to figure this out (sorta new to CFCs)... My CFC is over 1200 lines of code. I can't put it into server or application scope because if the CFC is executed by simultaneous requests, a second call to the CFC might overwrite data in the first call. How might cflock come into play? The only thing I think I'm left with is the session scope, but it seems like I'd get better performance by just not caching it. Thoughts? I hope this makes sense... like I said, I'm just getting into CFCs and lots of questions are racing around in my head. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: DWMX 2004 - Whats new for us?
"Ben Forta" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > It's that last point that seems to be the crux of this all. And for > those of you who have complained that Dreamweaver MX 2004 does not do > enough for ColdFusion developers, well, I agree. It has improved, and > some of the biggest complaints from ColdFusion users (including the > speed and needing to always define sites) have been addressed. I would > really have liked to have seen more, and as much as I don't like the > fact that the Dreamweaver team dedicated resources to improving support > for ASP.NET and PHP I also understand the economics. This is a business, > Macromedia needs to continue to sell lots of Dreamweaver. The product > has 2,000,000+ users (or something like that) most of whom do not use > ColdFusion, the static page market is saturated and they need to go > after where the big bucks are, targeting PHP and ASP.NET users make Let me just jump and say that while the list of new features in DW 2004 target to CF developers is pretty small, the equivalent list for ASP.NET is almost shorter (DW/.NET guys are upset all over the places!). Things are just a little bit better for PHP, but that's only because PHP in DW MX was really missing a bunch of pieces (mostly issued as extensions inside the DRKs) so the "new" PHP features listed on MM website are just those neccesarely to bridge the gaps left with DW MX. It's not like CF got less, the whole release just heavily focused on CSS and other things that aren't related to *any* specific language. In a certain sense DW went back to its roots. For the vast majority of DW userbase (including me) the new CSS editing/rendering alone are worth the upgrade > So is the new Dreamweaver the ColdFusion aware IDE I wanted? Nope. Is it > a useful tool? Yes. It is an improvement over Dreamweaver MX, even for > us CFers? Yes. Is it good enough to be the exclusive editor for > ColdFusion developers? I'd say that depends on the developer, for > experienced developers I'd say no. Is it compelling enough for Studio > and HomeSite users to abandon those tools entirely for it? No. Does it > have any value at all for ColdFusion developers? Absolutely. > > I am at least thankful that HomeSite has been given a new lease on life. > HomeSite 5.5 is not a major upgrade, but it does add some important > enhancements some of which I may want to use Ben, I can't explain how I 100% agree on *every* single word you wrote above You expressed my very own feelings so well! Not being an english native speaker can be frustrating and I am glad you managed to summarize things in a way that I wasn't able to do so far Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFHTTP to remotely submit form?
> Can I remotely submit a form with cfhttp. I have been able to > successfully fill the form in, I just odnt know how to autmoate > the submission http://myserver/myactionpage.cfm"; method="post"> Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: DWMX 2004 - Whats new for us?
I agree with you on that one. Excuses aside, the marketing concentrates on those other features because there is more to say about them. As I already said, there are indeed benefits for us CF folks but they are incremental, not major new features (that I know of). CF should have been been more prominent, they screwed up, and we're not letting them live it down, but at the same time that wasn't a whole lot more to say (that was CF specific). Ben -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:17 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? Speaking for myself, I do question the commitment from a marketing standpoint for CF. You said that they wished to target the PHP and ASP market, but this doesn't explain why there was no mention of CF specific products in their initial marketing campaign. That contradicts a company wide commitment to a product and a cohesive vision for a line of utilities that includes that product. It's like New Atlanta came out with an IDE for CFML and in the next revision mentioning pages upon pages of new features for .Net and nothing for the standard Bluedragon server, whilst saying outside the offical marketing campaign there have been several 'exciting' improvements for standard Bluedragon. That's akin to what MM is doing with their marketing. In the offical campaign they mention improvements for .ASP and .PHP. But on these lists they say that us CF Coders have so much to look forward to, yet none of these are worth mentioning in the official marketing campaign??? That does not compute. -Angel -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 3:27 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? For those of you who question the commitment to CF, um, hello? Did you miss 6.1? I for one think that CFMX 6.1 is a very significant upgrade, you may feel otherwise and are entitled to do so. Regardless, investing as we did in CF and then releasing it as a free upgrade to me spells Commitment (with a capital C). Yes, I know there are other departments and product teams within Macromedia who like to play Switzerland and not marry themselves to any product for fear of alienating users of other technologies, but that is marketing and should be recognized as such. I beat up on them for it, you should feel free to do the same. If you hear nothing from the CF team for a while, get worried, until then realize that Macromedia is a big company (i.e., not Allaire) selling lots of products many of which generate far greater revenue than does ColdFusion. --- Ben ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CFMAIL 6.1 ARRGH!
and that has to be the most eloquent statement I've seen from Ben since I started CFing in 98 ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 1:07 PM Subject: RE: CFMAIL 6.1 ARRGH! > And to those who say MM does not listen > ppphhhbbbttthh!! > > I'd like to see any developer from Microsoft or Sun or IBM or any other > company post a message like that, and that quickly too! > > > > > -Original Message- > From: Tom Jordahl [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 3:36 PM > To: CF-Talk > Subject: RE: CFMAIL 6.1 ARRGH! > > > This is definitely a bug and has been reported as bug 53329 (which I > have fixed). > > We *DO* test these things, but unfortunately our tests for REPLYTO did > not include a QUERY attribute, which is the root of the problem as Dina > pointed out. > > There should be a hotfix made available for this shortly, but if you > would like to fix this yourself, you can edit the cfml_data.xml (NOT FOR > THE FAINT OF HEART!) file in cfusion.jar. > > 0. Shutdown CF. > 1. Make a backup of the cfml_data.xml file in cfusion.jar > 2. Edit cfml_data.xml in cfusion.jar > 3. Search for "REPLYTO". Fix the 3 lines which have ",QUERY(REPLYTO,)?" > change it to ",QUERY(,REPLYTO)?" 4. Save the file and replace the one in > cfusion.jar with the new version. 5. restart CF - test > > I am sorry for the problem this caused you. And yes, this was my typo. > :-( > > -- > Tom Jordahl > Macromedia CF development > > Here is the diff for the fix: > > 4206c4206 > < > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXRO > WS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(REPLYTO,)?(,SERVER)?(,Spool > Enable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT > )? > --- > > > > > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXRO > WS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(,REPLYTO)?(,SERVER)?(,Spool > Enable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT > )? > 4208c4208 > < > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCaseSe > nsitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY > (REPLYTO,)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(, > TYPE)?(,USERNAME)?(,WRAPTEXT)? > --- > > > > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCase > > Sensitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,Q > > UERY(,REPLYTO)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT) > > ?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT)? > > > -Original Message- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 11:35 AM > To: CF-Talk > Subject: RE: CFMAIL 6.1 ARRGH! > > > It's become VERY obvious to me after repeated testing that the new > "replyto" parameter inside CFMail 6.1 does not work and is the cause of > the errors being thrown. If I remove this parameter from the cfmail tag, > the mail goes right through. I'm going back to the cfmailparam tags for > reply-to. I sure wish MM would test this stuff before putting it into > the marketplace - accountability is lacking. > > I'm reporting this to the bug line. > > Thanks, Mark > > -Original Message- > From: Dina Hess [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 10:37 AM > To: CF-Talk > Subject: Re: CFMAIL 6.1 ARRGH! > > > > Required attributes: 'from,group,query,subject,to'. Optional attributes: > 'bcc,cc,charset,debug,failto,groupcasesensitive,mailerid,maxrows,mimeatt > ach, > password,port,queryreplyto,server,spoolenable,startrow,timeout,type,user > name > ,wraptext'. > > > According to the error message, the "replyto" attribute is not supported > when you use "from,group, query, subject, and to." Try "queryreplyto" > instead, I guess. :) > > ~Dina > > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: DWMX 2004 - Whats new for us?
Right on Ben! I seriously just don't get this thread at all. Never once in my life have I ever noticed a difference in coding speed based on the IDE I was using. I can just see the expression on my boss's face if I'd say "sorry I missed the deadline, but my IDE slowed me down" or "this would have been done sooner had I had a built in debugger". D-Dub is a fine tool. If it's too slow for you, I suggest you buy a new computer. I'm working on a 2-year old box and it runs like a champ. Quite frankly this argument has been running for so long that it's lost all meaning to me. These issues seem like a security blanket issue, with developers who don't want to give up on something they had for so many years. Personally I got bored with CFStudio/Homesite (after several years). I tried DWMX exclusively for one month and never looked back. (Even though my initial intentions were to try it for 1-month so I could load up on bad things to say MM about) Macromedia is constantly making my life easier with updates to CF and Flash and they have supported our community like no other (even more than Allaire imho). Is it really fair to blast them over the features of one of their IDEs vs another? I mean they _do_ have two separate IDEs. The _only_ reason Homesite is still around is because of the critics. Some of these issues are def legit, but the longer this thread goes on, the more it is starting to sound like whining. I mean a lot of you are just complaining about CFMX 6.1! Seriously if you guys don't like MM that much, maybe you should go .NET and see how much MS listens to your suggestions. I suggest everyone at least try mx2k4 for a month. I assure you you'll still be able to code, and at the very least you'll have tried something, dare I say. new. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 3:27 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? I've been watching this thread with interest, and have also been forwarding the juicy bits to all sorts of folks within Macromedia. I've stayed out of the discussion thus far, but ... I use Dreamweaver. I also use HomeSite. I also use CodeWrite (which I migrated to after Sage which I migrated to after Brief). I'd love one editor that did it all, it does not exist yet, so I use multiple. It seems that many of you do the same. And no, I do not have to use Dreamweaver, I don't even have to like Dreamweaver, no one (not even my employer) gets to tell me what editor I should use or like. (Anyone who thinks otherwise does not know me). I have been a semi-advocate of Dreamweaver since DWMX (I had been a vocal critic of Dreamweaver prior to that), I have been on the backs of the Dreamweaver team to improve CF support for a long time and continue to do so, I publicly acknowledge what I like about Dreamweaver, and have no qualms about stating what it is that I don't like. I have been very honest in discussing Dreamweaver, and have never positioned it as a CF Studio replacement, and always positioned it as "another tool in the tool box" while stating that the Dreamweaver team had expressed a commitment to continue to improve ColdFusion integration. It's that last point that seems to be the crux of this all. And for those of you who have complained that Dreamweaver MX 2004 does not do enough for ColdFusion developers, well, I agree. It has improved, and some of the biggest complaints from ColdFusion users (including the speed and needing to always define sites) have been addressed. I would really have liked to have seen more, and as much as I don't like the fact that the Dreamweaver team dedicated resources to improving support for ASP.NET and PHP I also understand the economics. This is a business, Macromedia needs to continue to sell lots of Dreamweaver. The product has 2,000,000+ users (or something like that) most of whom do not use ColdFusion, the static page market is saturated and they need to go after where the big bucks are, targeting PHP and ASP.NET users make sense. (Whether or not those users will buy the story remains to be seen, but the Dreamweaver team had to make that effort). It is less "we don't care about CF" and more "we care lots about those massive user bases". Context. I have a laundry list of stuff I want in Dreamweaver (or HomeSite, or any editor). Many of the items are my own wants, others are user suggestions, all are shared by the wider community. I want data awareness in the IDE, I want right click introspection everywhere and anywhere, I want IntelliJ type intelligence so that when I change a CFC method I can keep all invocations in synch, I want speed, I want decent DB integration tools, I want a real debugger, I could go on and on and on ... I'll keep pushing and nagging. So is the new Dreamweaver the ColdFusion aware IDE I wanted? Nope. Is it a useful tool?
RE: CFHTTP to remotely submit form?
Kris, Not suere what you are after here. Do you mean you have a form in a browser (i.e. client) that you have populated and you want to submit it to a server automatically? If you just want to post to a server using cfhttp you can do that without bothering with a form at all ... the handling server will see the post submission and posted variables. http://www.somedomain.com/someform.cfm"; method="post"> Of course - its up to you to handle the response by unpacking the cfhttp.filecontent and header variables. -Mark -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:44 PM To: CF-Talk Subject: CFHTTP to remotely submit form? Can I remotely submit a form with cfhttp. I have been able to successfully fill the form in, I just odnt know how to autmoate the submission Any ideas? KP Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFMAIL 6.1 ARRGH!
I think you are on the wrong lists because Sun and IBM developers are quite responsive on some lists I am apart of. Can't really speak for Microsoft. -Matt On Wednesday, August 27, 2003, at 04:07 PM, Ben Forta wrote: > And to those who say MM does not listen > ppphhhbbbttthh!! > > I'd like to see any developer from Microsoft or Sun or IBM or any other > company post a message like that, and that quickly too! > > > > > -Original Message- > From: Tom Jordahl [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 3:36 PM > To: CF-Talk > Subject: RE: CFMAIL 6.1 ARRGH! > > > This is definitely a bug and has been reported as bug 53329 (which I > have fixed). > > We *DO* test these things, but unfortunately our tests for REPLYTO did > not include a QUERY attribute, which is the root of the problem as Dina > pointed out. > > There should be a hotfix made available for this shortly, but if you > would like to fix this yourself, you can edit the cfml_data.xml (NOT > FOR > THE FAINT OF HEART!) file in cfusion.jar. > > 0. Shutdown CF. > 1. Make a backup of the cfml_data.xml file in cfusion.jar > 2. Edit cfml_data.xml in cfusion.jar > 3. Search for "REPLYTO". Fix the 3 lines which have > ",QUERY(REPLYTO,)?" > change it to ",QUERY(,REPLYTO)?" 4. Save the file and replace the one > in > cfusion.jar with the new version. 5. restart CF - test > > I am sorry for the problem this caused you. And yes, this was my typo. > :-( > > -- > Tom Jordahl > Macromedia CF development > > Here is the diff for the fix: > > 4206c4206 > < > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXR > O > WS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(REPLYTO,)?(,SERVER)?(,Spoo > l > Enable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEX > T > )? > --- >> >> > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXR > O > WS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(,REPLYTO)?(,SERVER)?(,Spoo > l > Enable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEX > T > )? > 4208c4208 > < > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCaseS > e > nsitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUER > Y > (REPLYTO,)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO( > , > TYPE)?(,USERNAME)?(,WRAPTEXT)? > --- >> >> (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCase >> Sensitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,Q >> UERY(,REPLYTO)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT) >> ?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT)? > > > -Original Message- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 11:35 AM > To: CF-Talk > Subject: RE: CFMAIL 6.1 ARRGH! > > > It's become VERY obvious to me after repeated testing that the new > "replyto" parameter inside CFMail 6.1 does not work and is the cause of > the errors being thrown. If I remove this parameter from the cfmail > tag, > the mail goes right through. I'm going back to the cfmailparam tags for > reply-to. I sure wish MM would test this stuff before putting it into > the marketplace - accountability is lacking. > > I'm reporting this to the bug line. > > Thanks, Mark > > -Original Message- > From: Dina Hess [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 10:37 AM > To: CF-Talk > Subject: Re: CFMAIL 6.1 ARRGH! > > > > Required attributes: 'from,group,query,subject,to'. Optional > attributes: > 'bcc,cc,charset,debug,failto,groupcasesensitive,mailerid,maxrows,mimeat > t > ach, > password,port,queryreplyto,server,spoolenable,startrow,timeout,type,use > r > name > ,wraptext'. > > > According to the error message, the "replyto" attribute is not > supported > when you use "from,group, query, subject, and to." Try "queryreplyto" > instead, I guess. :) > > ~Dina > > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re:Re:RE: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree
Yeah - I've been looking around and I think you're right. This is really quite astonishing - seems like a pretty fundamental concept... Thanks anyway! --- Chris <[EMAIL PROTECTED]> wrote: > No similar operation in SQL unfortunately. Wish > there was though... > > Good Luck. > Chris > > -- > Original Message > From: "Richard Heiser"<[EMAIL PROTECTED]> > Subject: Re:RE: SQL syntax for Supertypes-Subtypes > AKA Circular Reference > AKA Entity Tree > Date: Wed, 27 Aug 2003 10:32:02 -0700 (PDT) > > >Um, I appreciate the response! But this is way > over > >my head. Does SQL Server really not have a > >counterpart to Oracle's functions "START WITH" and > >"CONNECT BY PRIOR"??? > > > >Seemed like such a simply query in Oracle: > > > >> >> DATASOURCE="MyDatasource"> > >> > SELECT iEntityID, iSubEntityOf, sName > >> > FROM Mytable > >> > WHERE NOT iEntityID > >> > START WITH iEntityID=1 > >> > CONNECT BY PRIOR iEntityID=iSubEntityOf > >> > > > > >Thanks! > > > >-Richard > > > > > >--- Chris <[EMAIL PROTECTED]> wrote: > >> Here is a stored procedure I used for an old > forum > >> app. Should work for > >> your situation. > >> > >> --DROP TABLE #stack > >> --DROP TABLE #x > >> --DROP TABLE #y > >> --CREATE PROCEDURE expand (@current int) as > >> DECLARE @current int > >> DECLARE @level int, @line char(20) > >> DECLARE @Pos int > >> DECLARE @PrevReplyTo int > >> CREATE TABLE #stack (item int, Thislevel int) > >> CREATE TABLE #x (ID int, Name varchar(256), > >> DateCreated datetime, InReplyTo > >> int, Topic int, TotalReply int, Creator int, > IsTop > >> bit, Root int, TopDate > >> datetime, _USER_ID int, MessageFrom > >> varchar(256),ThisLevel int, Position > >> int) > >> CREATE TABLE #y (ID int, InReplyTo int, Root int) > >> SET @current = 94 > >> SET @Pos = 0 > >> SET @PrevReplyTo = @current > >> INSERT #y > >>SELECT ID,InReplyTo, Root > >>FROM Threads > >>WHERE Root = @current > >>ORDER BY DateCreated DESC > >> > >> INSERT #x > >>SELECT Threads.ID AS "ID", > >>Threads.Name AS "Name", > >>Threads.DateCreated AS "DateCreated", > >>Threads.InReplyTo AS "InReplyTo", > >>Threads.Topic AS "Topic", > >>Threads.TotalReply AS "TotalReply", > >>Threads.Creator AS "Creator", > >>Threads.IsTop AS "IsTop", > >>Threads.Root AS "Root", > >>Threads.TopDate AS "TopDate", > >>Users.ID AS "_USER_ID", > >>Users.Userid AS "MessageFrom", > >>0, > >>0 > >>FROM Threads,Users > >>WHERE Threads.Root = @current AND > Threads.Creator = > >> Users.ID > >> > >> SET NOCOUNT ON > >> INSERT INTO #stack VALUES (@current, 1) > >> SELECT @level = 1 > >> > >> WHILE @level > 0 > >> BEGIN > >>IF EXISTS (SELECT * FROM #stack WHERE Thislevel > = > >> @level) > >>BEGIN > >>-- If an item on the stack exists at this > level, > >> grab it > >>SELECT @current = item FROM #stack WHERE > Thislevel > >> = @level > >> > >>-- Increment the position > >>SET @Pos = @Pos + 1 > >>-- Update the table with the new position > >>UPDATE #x SET Position = @Pos, ThisLevel = > @level > >> - 1 WHERE ID = @current > >>-- Delete this entry from the temp table (#y) > >>DELETE FROM #y WHERE ID = @current > >> > >>-- Delete this entry from the stack > >>DELETE FROM #stack WHERE Thislevel = @level AND > >> item = @current > >>-- Insert into the stack any IDs that are > replies > >> to the CURRENT ID > >>INSERT #stack SELECT ID, @level + 1 FROM #y > WHERE > >> InReplyTo = @current > >>-- If any were found, increment the level > >> > >>IF @@ROWCOUNT > 0 > >>SELECT @level = @level + 1 > >>END > >>ELSE > >>SELECT @level = @level - 1 > >> > >> > >>IF ((SELECT COUNT(*) FROM #y) > 0 AND (SELECT > >> COUNT(*) FROM #stack) = 0) > >>BEGIN > >>IF @level = 0 > >>SELECT @level = @level + 1 > >> > >>INSERT #stack > >>SELECT ID, @level + 1 FROM #y > >>SELECT * FROM #stack > >>END > >> > >> END -- WHILE > >> > >> DROP TABLE #stack > >> SELECT ID,Name,ThisLevel,Position FROM #x ORDER > BY > >> Position,DateCreated > >> > >> > >> DROP TABLE #x > >> DROP TABLE #y > >> > >> > >> > >> > >> > >> -- > >> Original Message > >> From: "Hagan, Ryan Mr (Contractor > >> ACI)"<[EMAIL PROTECTED]> > >> Subject: RE: SQL syntax for Supertypes-Subtypes > AKA > >> Circular Reference AKA > >> Entity Tree > >> Date: Wed, 27 Aug 2003 11:21:52 -0400 > >> > >> >I asked a very similar question a few weeks ago. > > >> O
Re: CF Version for RedSky
From my admin login screen: 6,1,0,63958 - Jim David K wrote: >Anyone kow what the version number is for the release version of RedSky (cf >6.1)? > >Fromm MM website: > >6,0,0,48097 -- ColdFusion MX >6,0,0,52311 -- ColdFusion MX + Updater 1 >6,0,0,55693 -- ColdFusion MX + Updater 2 >6,0,0,58500 -- ColdFusion MX + Updater 3 > >TIA > >--David K. > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: DWMX 2004 - Whats new for us?
> In the offical campaign they mention improvements for .ASP and .PHP. > But on these lists they say that us CF Coders have so much to look > forward to, > yet none of these are worth mentioning in the official marketing > campaign??? > > That does not compute. Angel, would you believe me if I say that those .NET and PHP listed on MM's website are barely worth mentioning? The PHP developers just got the missing pieces that were left out in DW MX. ASP:NET people just got some minor things related to form controls and they are screaming all over the places Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFHTTP to remotely submit form?
Not sure exactly but it involves setting the type to post and using cfhttpparam's Tyler Clendenin GSL Solutions -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:44 PM To: CF-Talk Subject: CFHTTP to remotely submit form? Can I remotely submit a form with cfhttp. I have been able to successfully fill the form in, I just odnt know how to autmoate the submission Any ideas? KP Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
CF Version for RedSky
Anyone kow what the version number is for the release version of RedSky (cf 6.1)? Fromm MM website: 6,0,0,48097 -- ColdFusion MX 6,0,0,52311 -- ColdFusion MX + Updater 1 6,0,0,55693 -- ColdFusion MX + Updater 2 6,0,0,58500 -- ColdFusion MX + Updater 3 TIA --David K. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DWMX 2004 - Whats new for us?
Speaking for myself, I do question the commitment from a marketing standpoint for CF. You said that they wished to target the PHP and ASP market, but this doesn't explain why there was no mention of CF specific products in their initial marketing campaign. That contradicts a company wide commitment to a product and a cohesive vision for a line of utilities that includes that product. It's like New Atlanta came out with an IDE for CFML and in the next revision mentioning pages upon pages of new features for .Net and nothing for the standard Bluedragon server, whilst saying outside the offical marketing campaign there have been several 'exciting' improvements for standard Bluedragon. That's akin to what MM is doing with their marketing. In the offical campaign they mention improvements for .ASP and .PHP. But on these lists they say that us CF Coders have so much to look forward to, yet none of these are worth mentioning in the official marketing campaign??? That does not compute. -Angel -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 3:27 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? For those of you who question the commitment to CF, um, hello? Did you miss 6.1? I for one think that CFMX 6.1 is a very significant upgrade, you may feel otherwise and are entitled to do so. Regardless, investing as we did in CF and then releasing it as a free upgrade to me spells Commitment (with a capital C). Yes, I know there are other departments and product teams within Macromedia who like to play Switzerland and not marry themselves to any product for fear of alienating users of other technologies, but that is marketing and should be recognized as such. I beat up on them for it, you should feel free to do the same. If you hear nothing from the CF team for a while, get worried, until then realize that Macromedia is a big company (i.e., not Allaire) selling lots of products many of which generate far greater revenue than does ColdFusion. --- Ben ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CFMAIL 6.1 ARRGH!
And to those who say MM does not listen ppphhhbbbttthh!! I'd like to see any developer from Microsoft or Sun or IBM or any other company post a message like that, and that quickly too! -Original Message- From: Tom Jordahl [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 3:36 PM To: CF-Talk Subject: RE: CFMAIL 6.1 ARRGH! This is definitely a bug and has been reported as bug 53329 (which I have fixed). We *DO* test these things, but unfortunately our tests for REPLYTO did not include a QUERY attribute, which is the root of the problem as Dina pointed out. There should be a hotfix made available for this shortly, but if you would like to fix this yourself, you can edit the cfml_data.xml (NOT FOR THE FAINT OF HEART!) file in cfusion.jar. 0. Shutdown CF. 1. Make a backup of the cfml_data.xml file in cfusion.jar 2. Edit cfml_data.xml in cfusion.jar 3. Search for "REPLYTO". Fix the 3 lines which have ",QUERY(REPLYTO,)?" change it to ",QUERY(,REPLYTO)?" 4. Save the file and replace the one in cfusion.jar with the new version. 5. restart CF - test I am sorry for the problem this caused you. And yes, this was my typo. :-( -- Tom Jordahl Macromedia CF development Here is the diff for the fix: 4206c4206 < (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXRO WS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(REPLYTO,)?(,SERVER)?(,Spool Enable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT )? --- > > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXRO WS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(,REPLYTO)?(,SERVER)?(,Spool Enable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT )? 4208c4208 < (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCaseSe nsitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY (REPLYTO,)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(, TYPE)?(,USERNAME)?(,WRAPTEXT)? --- > > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCase > Sensitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,Q > UERY(,REPLYTO)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT) > ?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT)? -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 11:35 AM To: CF-Talk Subject: RE: CFMAIL 6.1 ARRGH! It's become VERY obvious to me after repeated testing that the new "replyto" parameter inside CFMail 6.1 does not work and is the cause of the errors being thrown. If I remove this parameter from the cfmail tag, the mail goes right through. I'm going back to the cfmailparam tags for reply-to. I sure wish MM would test this stuff before putting it into the marketplace - accountability is lacking. I'm reporting this to the bug line. Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:37 AM To: CF-Talk Subject: Re: CFMAIL 6.1 ARRGH! Required attributes: 'from,group,query,subject,to'. Optional attributes: 'bcc,cc,charset,debug,failto,groupcasesensitive,mailerid,maxrows,mimeatt ach, password,port,queryreplyto,server,spoolenable,startrow,timeout,type,user name ,wraptext'. According to the error message, the "replyto" attribute is not supported when you use "from,group, query, subject, and to." Try "queryreplyto" instead, I guess. :) ~Dina ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Index.cfm problem again
I had the exact same problem... index.cfm failed with 404, renamed to index.htm and it worked. But, all fixed now. Someone had run a "hardening" program on the IIS server and it changed the permission settings on the directory that had .cfm files in it. For any website that has cold fusion (.cfm files) on IIS, you must set the sharing permissions to also allow "Everyone Read". Once you do that, the cold fusion file will run fine. Don't forget to let the permissions propagate down thru the sub directories or you'll be back again doing each one of them. Understand?? ps: I didn't see an answer here so if I overlooked it and someone already answered the question, sorry for the duplicate... -pat- ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: (Admin) List Question
Matt Liotta wrote: > I wasn't aware that SMTP had that provision. Typical SMTP command sequence is: HELO MAIL FROM: RCPT TO: DATA QUIT If a message has multiple recipients at one domain the "RCPT TO:" line can be repeated for each recipient, but the message is still only sent once. > Although, I thought that > the expected behavior of SMTP is to deliver all available mail destined > for a server in the same connection. Yes. Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CFMX and AS/400
Where can I find the link on the IBM site? >I am running ColdFusionMX 6.1 and I am using the JTOpen JDBC driver >from the IBM site. I was not able to get the DB2 JDBC to work. > >Chris > > >>Hello, >> >> >> >>In the process of upgrading from CF 5.0 to CFMX 6.1. I am using an >AS/400 >>for some of apps. Does the DB2 Driver that comes with CFMX 6.1 able >to >>connect to an AS/400 without using DB2 Connect software? >> >> >> >>James Taavon >>Senior Web Developer >>Department of Labor, Licensing and Regulation >>1100 N. Eutaw Street >>Room 203 >>Baltimore, MD 21201 >>Ph: 410 767-8190 >>Fx: 410 333-5203 >> >> >> > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: CF_ADVANCEDEMAIL and CF_ADVANCEDEMAILPARAM
David K wrote: > > Did RedSky fix the performance issues with Insert() Don't know. > and, if so, do you > intend to release an MX version of CF_ADVANCEDEMAIL and > CF_ADVANCEDEMAILPARAM? No. Check out cfmailpart. Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: DWMX 2004 - Whats new for us?
Well not to introduce something else into this discusion but will there ever be something that lends itself to the modular (ex. fusebox) programing methodologies for debugging. Currently Alt-Tab Then F5 is the only way I know of. How nice it would be to set watches on variables instead of having to write it to a page during development. Tyler Clendenin GSL Solutions ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DWMX 2004 - Whats new for us?
I've been watching this thread with interest, and have also been forwarding the juicy bits to all sorts of folks within Macromedia. I've stayed out of the discussion thus far, but ... I use Dreamweaver. I also use HomeSite. I also use CodeWrite (which I migrated to after Sage which I migrated to after Brief). I'd love one editor that did it all, it does not exist yet, so I use multiple. It seems that many of you do the same. And no, I do not have to use Dreamweaver, I don't even have to like Dreamweaver, no one (not even my employer) gets to tell me what editor I should use or like. (Anyone who thinks otherwise does not know me). I have been a semi-advocate of Dreamweaver since DWMX (I had been a vocal critic of Dreamweaver prior to that), I have been on the backs of the Dreamweaver team to improve CF support for a long time and continue to do so, I publicly acknowledge what I like about Dreamweaver, and have no qualms about stating what it is that I don't like. I have been very honest in discussing Dreamweaver, and have never positioned it as a CF Studio replacement, and always positioned it as "another tool in the tool box" while stating that the Dreamweaver team had expressed a commitment to continue to improve ColdFusion integration. It's that last point that seems to be the crux of this all. And for those of you who have complained that Dreamweaver MX 2004 does not do enough for ColdFusion developers, well, I agree. It has improved, and some of the biggest complaints from ColdFusion users (including the speed and needing to always define sites) have been addressed. I would really have liked to have seen more, and as much as I don't like the fact that the Dreamweaver team dedicated resources to improving support for ASP.NET and PHP I also understand the economics. This is a business, Macromedia needs to continue to sell lots of Dreamweaver. The product has 2,000,000+ users (or something like that) most of whom do not use ColdFusion, the static page market is saturated and they need to go after where the big bucks are, targeting PHP and ASP.NET users make sense. (Whether or not those users will buy the story remains to be seen, but the Dreamweaver team had to make that effort). It is less "we don't care about CF" and more "we care lots about those massive user bases". Context. I have a laundry list of stuff I want in Dreamweaver (or HomeSite, or any editor). Many of the items are my own wants, others are user suggestions, all are shared by the wider community. I want data awareness in the IDE, I want right click introspection everywhere and anywhere, I want IntelliJ type intelligence so that when I change a CFC method I can keep all invocations in synch, I want speed, I want decent DB integration tools, I want a real debugger, I could go on and on and on ... I'll keep pushing and nagging. So is the new Dreamweaver the ColdFusion aware IDE I wanted? Nope. Is it a useful tool? Yes. It is an improvement over Dreamweaver MX, even for us CFers? Yes. Is it good enough to be the exclusive editor for ColdFusion developers? I'd say that depends on the developer, for experienced developers I'd say no. Is it compelling enough for Studio and HomeSite users to abandon those tools entirely for it? No. Does it have any value at all for ColdFusion developers? Absolutely. I am at least thankful that HomeSite has been given a new lease on life. HomeSite 5.5 is not a major upgrade, but it does add some important enhancements some of which I may want to use. Some of you complained about having to buy Dreamweaver to get HomeSite+, and that one irked me a bit. We seem to have forgotten that CF Studio used to sell for, what was it? $300? $400? I forget. Paying $199 for Dreamweaver + HomeSite+ is less than you paid for CF Studio itself back then. Even if you never ever look at Dreamweaver you are ahead of the game. I think that those comments are more an emotional reaction to having to buy a box with the dreaded D on it, than anything else. Well, get over it. For those of you who question the commitment to CF, um, hello? Did you miss 6.1? I for one think that CFMX 6.1 is a very significant upgrade, you may feel otherwise and are entitled to do so. Regardless, investing as we did in CF and then releasing it as a free upgrade to me spells Commitment (with a capital C). Yes, I know there are other departments and product teams within Macromedia who like to play Switzerland and not marry themselves to any product for fear of alienating users of other technologies, but that is marketing and should be recognized as such. I beat up on them for it, you should feel free to do the same. If you hear nothing from the CF team for a while, get worried, until then realize that Macromedia is a big company (i.e., not Allaire) selling lots of products many of which generate far greater revenue than does ColdFusion. Ok, I am way off on a tangent now, so, back to where I started ... No one is forcing you to use Dreamweaver. I personally
Queries timeout in CFMX 6.1
Platform: CFMX6.1/Win2K/IIS5 All-- Just installed CFMX 6.1 to run alongside an existing CF5 on a standalone server. The install looks OK--no errors, the CF Admin works fine and CFML statements (ie, "#DateFormat(Now())#") execute properly. But when I try to use CFQUERY, the query just runs and runs and never returns anything. The DSN verifies in CF Admin but even a simple SQL statement fails: SELECT * FROM dual I don't understand why the DSN verifies in the Admin but doesn't work with a simple query. I know I've seen someone discuss DSN issues on the list but I can't find them in the archive. I remember something about refreshing connectors or something. Could that be the issue? The docs that came with MX are thin on this. Thanks, Chris ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: URL string format
Robert: Look into the HTMLEditFormat() function. The specific problem here is likely the double-quotes in your string. The browser sees the quotes and assumes that the value of the HTML attribute ends with that double-quote. The HTMLEditFormat() function escapes the quotes for just such a reason. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 2:30 PM > To: CF-Talk > Subject: URL string format > > > I have a string in a field in an SQL table such as: face="Arial" size="2">American > Book of Days, 4th Ed.. > I pass this and other fields in this record to an update form so > I can edit the record. The fields display in input text boxes. > > The problem I have is this particular text displays partly inside > the box and partly outside. It seems to have a problem > interpreting the string. > > What CF command can I add to #getbookid.url# to make the URL > string display in the text box? Is there some string format command? > > > > Thanks. > > Robert O. > HWW > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: (Admin) List Question
The single connection for all mail on the same domain has been in iMS for a while now. The problem is that if there are 3 people in the domain then there are 3 messages sent on that connection. If they weren't all unique then maybe that one connection could send 1 message to 3 people. Howie, you know more about the core of SMTP and mail servers. Can you chime in here? > I wasn't aware that SMTP had that provision. Although, I thought that > the expected behavior of SMTP is to deliver all available mail destined > for a server in the same connection. > > -Matt > > On Wednesday, August 27, 2003, at 03:05 PM, Michael Dinowitz wrote: > > > If there's an SMTP feature to send one message and have it delivered > > to two > > separate people at the same domain then it's something that Howie > > would deal > > with in iMS (it's probably there). > > Note the line in the footer that says unsubscribe. It's customized for > > you and > > you alone. Each post has its own unsubscribe line with the users > > information. > > Can't share that. > > This stops the multiple people on the To/CC line as well. It would be > > nice for a > > single message but then I'd have to remove the nice unsubscribe > > feature. > > > >> We've got two people at our company subscribed to the cf-talk list. > >> I notice > >> in my mail server's SMTP logs what appears to be two copies of the > >> message > >> being delivered from HOF's server. Both addresses here are in the > >> same domain > >> name. I thought there was an SMTP provision to deliver a single > >> message to > >> multiple recipients in a domain. Barring that, couldn't the same > >> thing be > >> accomplished just by specifying multiple recipients in the TO address? > >> > >> > >> > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFMAIL 6.1 ARRGH!
This is definitely a bug and has been reported as bug 53329 (which I have fixed). We *DO* test these things, but unfortunately our tests for REPLYTO did not include a QUERY attribute, which is the root of the problem as Dina pointed out. There should be a hotfix made available for this shortly, but if you would like to fix this yourself, you can edit the cfml_data.xml (NOT FOR THE FAINT OF HEART!) file in cfusion.jar. 0. Shutdown CF. 1. Make a backup of the cfml_data.xml file in cfusion.jar 2. Edit cfml_data.xml in cfusion.jar 3. Search for "REPLYTO". Fix the 3 lines which have ",QUERY(REPLYTO,)?" change it to ",QUERY(,REPLYTO)?" 4. Save the file and replace the one in cfusion.jar with the new version. 5. restart CF - test I am sorry for the problem this caused you. And yes, this was my typo. :-( -- Tom Jordahl Macromedia CF development Here is the diff for the fix: 4206c4206 < (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(REPLYTO,)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT)? --- > > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(,REPLYTO)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT)? 4208c4208 < (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCaseSensitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(REPLYTO,)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT)? --- > > (BCC,)?(CC,)?(CHARSET,)?(DEBUG,)?(FAILTO,)?FROM,GROUP(,GroupCaseSensitive)?(,MAILERID)?(,MAXROWS)?(,MIMEATTACH)?(,PASSWORD)?(,PORT)?,QUERY(,REPLYTO)?(,SERVER)?(,SpoolEnable)?(,STARTROW)?,SUBJECT(,TIMEOUT)?,TO(,TYPE)?(,USERNAME)?(,WRAPTEXT)? -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 11:35 AM To: CF-Talk Subject: RE: CFMAIL 6.1 ARRGH! It's become VERY obvious to me after repeated testing that the new "replyto" parameter inside CFMail 6.1 does not work and is the cause of the errors being thrown. If I remove this parameter from the cfmail tag, the mail goes right through. I'm going back to the cfmailparam tags for reply-to. I sure wish MM would test this stuff before putting it into the marketplace - accountability is lacking. I'm reporting this to the bug line. Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:37 AM To: CF-Talk Subject: Re: CFMAIL 6.1 ARRGH! Required attributes: 'from,group,query,subject,to'. Optional attributes: 'bcc,cc,charset,debug,failto,groupcasesensitive,mailerid,maxrows,mimeattach, password,port,queryreplyto,server,spoolenable,startrow,timeout,type,username ,wraptext'. According to the error message, the "replyto" attribute is not supported when you use "from,group, query, subject, and to." Try "queryreplyto" instead, I guess. :) ~Dina ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: DWMX 2004 - Whats new for us?
Correct; I have one that I am working on now in my spare time. Although, it is functional enough for me to use at this point, so I do all my CFML development in Eclipse. See my earlier message for what is does and what I hope it to do in the future. -Matt On Wednesday, August 27, 2003, at 02:52 PM, Calvin Ward wrote: > Matt, > > Are you talking about doing an Eclipse plug in for CFML development? > > - Calvin > > - Original Message - > From: "Matt Liotta" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 27, 2003 2:43 PM > Subject: Re: DWMX 2004 - Whats new for us? > > >> I agree as well. I have been working on an Eclipse plug-in in my spare >> time that does all of what you mention. Right now, all I have is >> syntax >> highlighting and J2EE deployment management. Hoping to add something >> like intellisense and syntax debugging in the future, but as always, >> side projects are slow going. >> >> -Matt >> >> On Wednesday, August 27, 2003, at 02:23 PM, Tony Weeg wrote: >> >>> I couldn't have said it better myself. >>> >>> CFS with some VBStudio like tools, intellisense, breakpoints, >>> etcwould just plain rock >>> >>> tony weeg >>> sr. web applications architect >>> navtrak, inc. >>> [EMAIL PROTECTED] >>> www.navtrak.net >>> office 410.548.2337 >>> fax 410.860.2337 >>> >>> >>> -Original Message- >>> From: Calvin Ward [mailto:[EMAIL PROTECTED] >>> Sent: Wednesday, August 27, 2003 2:21 PM >>> To: CF-Talk >>> Subject: Re: DWMX 2004 - Whats new for us? >>> >>> >>> I would have to disagree. >>> >>> For example, a language centric tool could leverage strong server >>> debug >>> capabilities. >>> >>> Wouldn't you like to be able to open a page within the IDE, go >>> through >>> your application, have debug output in another panel of your IDE for >>> that page and it's include files, be able to set break points, and >>> trace >>> variable values to reduce debugging needs, and come across >>> an >>> error, click on the error within your IDE, have it open the offending >>> .cfm page in your IDE, and highlight the error. >>> >>> Wouldn't that be powerful? And doesn't that sound familiar (except >>> that >>> it works so clunkily and problematically in CFS...)? >>> >>> Divorcing the language from the tool does the developer a disservice, >>> you can write CFML in notepad, but why should you? CFS is far >>> superior >>> with it's help/reference system alone (language specific), not to >>> mention the color coding (language specific), and the toolbar >>> (language >>> specific), and so forth. >>> >>> What we need is a ColdFusion centric IDE, that also strongly supports >>> the rest of the stuff we'll be reasonably expected to work within >>> (xml, >>> html, css, javascript). >>> >>> If it can be used for other things, great. But let's take the tools >>> to >>> another level, I can't understand why after 4 years, CFS and DWMX is >>> still the best we can have to support CFML development specifically. >>> >>> - Calvin >>> >>> - Original Message - >>> From: "Jerry Johnson" <[EMAIL PROTECTED]> >>> To: "CF-Talk" <[EMAIL PROTECTED]> >>> Sent: Wednesday, August 27, 2003 2:01 PM >>> Subject: Re: DWMX 2004 - Whats new for us? >>> >>> I see it from exactly the opposite point of view. I am forever thankful Allaire (and Macromedia) have divorced the language >>> from the development environment. I'm glad I can use whatever editor I like to manipluate the source. I've >>> used textpad, CF Studio, Dreamweaver, Editplus, Ultradev, grep. I like (and use) CF Studio. It is my current favorite. But as with any >>> editor, it will take the back seat at some point to my new favorite >>> (whatever it is going to be). I also like that Studio isn't CF centric. I use it to edit perl, php, >>> vbscript, bat files, cshell scripts, jsp, hts. It still isn't as good as Brief or the Turbo Pascal 5.0 editor (for what >>> they did at the time). But it is the best I have at the moment. And I >>> would keep it for the extended search and replace even if nothing >>> else >>> worked. Just my opinion Jerry Johnson >>> [EMAIL PROTECTED] 08/27/03 01:51PM >>> You make some valid points. In fact your points support my arguments. >>> At >>> the end of the day, we are still left with out a "ColdFusion >>> Centered" >>> IDE. We still have to make do with what's available. No doubt >>> Dreamweaver leverages ColdFusion MX better than every thing else on >>> the >>> market but its still a 20% ColdFusion / 80% every thing else tool. >>> We >>> should have to do all this jumping around. Some of use using jedit, >>> others you dreamweaver, some in HomeSite, and proably most still in >>> Studio. As far as the survey. I would like to see the survey results. I want >>> to >>> know how many serious CF developers have completely adopted. I want
CFHTTP to remotely submit form?
Can I remotely submit a form with cfhttp. I have been able to successfully fill the form in, I just odnt know how to autmoate the submission Any ideas? KP Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: DWMX 2004 - Whats new for us?
-Original Message- From: Jerry Johnson Sent: Wednesday, August 27, 2003 2:02 PM To: CF-Talk Subject: Re: DWMX 2004 - Whats new for us? >I see it from exactly the opposite point of view. >I am forever thankful Allaire (and Macromedia) have divorced the language from the development environment. >I also like that Studio isn't CF centric. I use it to edit perl, php, vbscript, bat files, cshell scripts, jsp, hts. +1 I hate having to use different editors for different tasks. I'm pretty sure its argued in Code Complete or a similar book that programmers should master one editor and use that editor for everything. Now if only they would make it so I could view more than one document at the same time in Studio... ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: (Admin) List Question
I wasn't aware that SMTP had that provision. Although, I thought that the expected behavior of SMTP is to deliver all available mail destined for a server in the same connection. -Matt On Wednesday, August 27, 2003, at 03:05 PM, Michael Dinowitz wrote: > If there's an SMTP feature to send one message and have it delivered > to two > separate people at the same domain then it's something that Howie > would deal > with in iMS (it's probably there). > Note the line in the footer that says unsubscribe. It's customized for > you and > you alone. Each post has its own unsubscribe line with the users > information. > Can't share that. > This stops the multiple people on the To/CC line as well. It would be > nice for a > single message but then I'd have to remove the nice unsubscribe > feature. > >> We've got two people at our company subscribed to the cf-talk list. >> I notice >> in my mail server's SMTP logs what appears to be two copies of the >> message >> being delivered from HOF's server. Both addresses here are in the >> same domain >> name. I thought there was an SMTP provision to deliver a single >> message to >> multiple recipients in a domain. Barring that, couldn't the same >> thing be >> accomplished just by specifying multiple recipients in the TO address? >> >> >> > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL : Finding element in list of values in a query field.
sure...but his data isnt like that, whatever, the bottom line is bad db design and that should be rectified prior to continuation! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 3:01 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. The suggestion Brian made about adding commas around the values is actually a VERY good suggestion. Here's why. With string items such as "dancing" or "running", you're probably okay without the commas, but what if your table looked like this: NAME | LUCKY NUMBERS - bob | "1,3,15,26" susan | "1,4,17,26" joe | "2,6,14,28" To get a list of a people whose lucky numbers are "7", you'd run a query that looked like this: SELECT name FROM luckyNums WHERE luckynumbers LIKE '%7%' Your query returned "susan" which is incorrect. However, if we reformed the table to look like this: NAME | LUCKY NUMBERS - bob | ",1,3,15,26," susan | ",1,4,17,26," joe | ",2,6,14,28," And altered the query to look like so: SELECT name FROM luckyNums WHERE luckynumbers LIKE '%,7,%' Then your query returned ZERO rows, which *IS* correct. And THAT'S why Brian was suggesting adding the extra commas. They ARE VERY important, depending on what type of data you have. For the record, I agree that the CORRECT solution is to create another table and a linking table. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:38 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. it would work to do... select * from [table] where talent like '%dancing%' nothing else is necessary :) tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:40 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. Would it work to just do SELECT * FROM [table] WHERE ',' + talents + ',' LIKE '%,#aTalent#,%' Tyler Clendenin GSL Solutions -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:20 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
CF_ADVANCEDEMAIL and CF_ADVANCEDEMAILPARAM
Hey, Jochem: Just wondering... Did RedSky fix the performance issues with Insert() and, if so, do you intend to release an MX version of CF_ADVANCEDEMAIL and CF_ADVANCEDEMAILPARAM? --David K. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: SQL : Finding element in list of values in a query field.
The suggestion Brian made about adding commas around the values is actually a VERY good suggestion. Here's why. With string items such as "dancing" or "running", you're probably okay without the commas, but what if your table looked like this: NAME | LUCKY NUMBERS - bob | "1,3,15,26" susan | "1,4,17,26" joe | "2,6,14,28" To get a list of a people whose lucky numbers are "7", you'd run a query that looked like this: SELECT name FROM luckyNums WHERE luckynumbers LIKE '%7%' Your query returned "susan" which is incorrect. However, if we reformed the table to look like this: NAME | LUCKY NUMBERS - bob | ",1,3,15,26," susan | ",1,4,17,26," joe | ",2,6,14,28," And altered the query to look like so: SELECT name FROM luckyNums WHERE luckynumbers LIKE '%,7,%' Then your query returned ZERO rows, which *IS* correct. And THAT'S why Brian was suggesting adding the extra commas. They ARE VERY important, depending on what type of data you have. For the record, I agree that the CORRECT solution is to create another table and a linking table. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:38 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. it would work to do... select * from [table] where talent like '%dancing%' nothing else is necessary :) tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:40 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. Would it work to just do SELECT * FROM [table] WHERE ',' + talents + ',' LIKE '%,#aTalent#,%' Tyler Clendenin GSL Solutions -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:20 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: DWMX 2004 - Whats new for us?
Matt, Are you talking about doing an Eclipse plug in for CFML development? - Calvin - Original Message - From: "Matt Liotta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 2:43 PM Subject: Re: DWMX 2004 - Whats new for us? > I agree as well. I have been working on an Eclipse plug-in in my spare > time that does all of what you mention. Right now, all I have is syntax > highlighting and J2EE deployment management. Hoping to add something > like intellisense and syntax debugging in the future, but as always, > side projects are slow going. > > -Matt > > On Wednesday, August 27, 2003, at 02:23 PM, Tony Weeg wrote: > > > I couldn't have said it better myself. > > > > CFS with some VBStudio like tools, intellisense, breakpoints, > > etcwould just plain rock > > > > tony weeg > > sr. web applications architect > > navtrak, inc. > > [EMAIL PROTECTED] > > www.navtrak.net > > office 410.548.2337 > > fax 410.860.2337 > > > > > > -Original Message- > > From: Calvin Ward [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 27, 2003 2:21 PM > > To: CF-Talk > > Subject: Re: DWMX 2004 - Whats new for us? > > > > > > I would have to disagree. > > > > For example, a language centric tool could leverage strong server debug > > capabilities. > > > > Wouldn't you like to be able to open a page within the IDE, go through > > your application, have debug output in another panel of your IDE for > > that page and it's include files, be able to set break points, and > > trace > > variable values to reduce debugging needs, and come across an > > error, click on the error within your IDE, have it open the offending > > .cfm page in your IDE, and highlight the error. > > > > Wouldn't that be powerful? And doesn't that sound familiar (except that > > it works so clunkily and problematically in CFS...)? > > > > Divorcing the language from the tool does the developer a disservice, > > you can write CFML in notepad, but why should you? CFS is far superior > > with it's help/reference system alone (language specific), not to > > mention the color coding (language specific), and the toolbar (language > > specific), and so forth. > > > > What we need is a ColdFusion centric IDE, that also strongly supports > > the rest of the stuff we'll be reasonably expected to work within (xml, > > html, css, javascript). > > > > If it can be used for other things, great. But let's take the tools to > > another level, I can't understand why after 4 years, CFS and DWMX is > > still the best we can have to support CFML development specifically. > > > > - Calvin > > > > - Original Message - > > From: "Jerry Johnson" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, August 27, 2003 2:01 PM > > Subject: Re: DWMX 2004 - Whats new for us? > > > > > >> I see it from exactly the opposite point of view. > >> > >> I am forever thankful Allaire (and Macromedia) have divorced the > >> language > > from the development environment. > >> > >> I'm glad I can use whatever editor I like to manipluate the source. > >> I've > > used textpad, CF Studio, Dreamweaver, Editplus, Ultradev, grep. > >> > >> I like (and use) CF Studio. It is my current favorite. But as with any > > editor, it will take the back seat at some point to my new favorite > > (whatever it is going to be). > >> > >> I also like that Studio isn't CF centric. I use it to edit perl, php, > > vbscript, bat files, cshell scripts, jsp, hts. > >> > >> It still isn't as good as Brief or the Turbo Pascal 5.0 editor (for > >> what > > they did at the time). But it is the best I have at the moment. And I > > would keep it for the extended search and replace even if nothing else > > worked. > >> > >> Just my opinion > >> Jerry Johnson > >> > > [EMAIL PROTECTED] 08/27/03 01:51PM >>> > >> You make some valid points. In fact your points support my arguments. > > > >> At > > the end of the day, we are still left with out a "ColdFusion Centered" > > IDE. We still have to make do with what's available. No doubt > > Dreamweaver leverages ColdFusion MX better than every thing else on the > > market but its still a 20% ColdFusion / 80% every thing else tool. We > > should have to do all this jumping around. Some of use using jedit, > > others you dreamweaver, some in HomeSite, and proably most still in > > Studio. > >> > >> As far as the survey. I would like to see the survey results. I want > > > >> to > > know how many serious CF developers have completely adopted. I want to > > see bar charts and pie graphs and stuff. Are they giving us what we > > asked for? > >> > >> Heck, they can just take the "application" panel in Dreamweaver, drop > >> it > > into Studio then Update the Studio interface to be consistant with > > other > > products in the family and tah dah.. there you have it. > >> > >> My point is we need a ColdFusion Centered IDE; one that MACR should be > > proud of. > >> > >> > >> > >> > >> > >
Re: DWMX 2004 - Whats new for us?
> >What we need is a ColdFusion centric IDE, that also strongly supports the >rest of the stuff we'll be reasonably expected to work within (xml, html, >css, javascript). > >If it can be used for other things, great. But let's take the tools to >another level, I can't understand why after 4 years, CFS and DWMX is still >the best we can have to support CFML development specifically. > !!BINGO!! Is this really to much to ask? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL : Finding element in list of values in a query field.
Not true, certainly all of this is unnessecary since the database should be designed differently anyway but just doing a talent LIKE '%dancing%' would be even worse. What happens if there are two things like dancing and dancings in there. Definitley not accounting for possibilities. Tyler Clendenin GSL Solutions -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:38 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. it would work to do... select * from [table] where talent like '%dancing%' nothing else is necessary :) tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:40 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. Would it work to just do SELECT * FROM [table] WHERE ',' + talents + ',' LIKE '%,#aTalent#,%' Tyler Clendenin GSL Solutions -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:20 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: XML request/response issues - Still
cf5 shouldn't matter. can you simply hit the cfhttp page you are trying to hit, minus the xml info? just to see if its valid? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Matt Blatchley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:39 PM To: CF-Talk Subject: XML request/response issues - Still I still trying to send an XML request to a server, but I get a Connection Failed Error in the response when I use CFHTTP. I know I'm doing something wrong becuase the log file is processing the request correctly, but the response is never getting back. The CFHTTP.FileContent is saying Connection Failed. I'm still new to XML so I'm not sure what I'm doing incorrectly. Here's the Request: http://someIP"; method="post" name="XML_name" resolveurl="false"> #CFHTTP.FileContent# Is there a better way to do this in CF? In the log file I get for the response... xml_request_text=IDID ER2798971 2003-08-21 13:41:12 -0400 Dump: [7197]Sending Response ER279897 IndexTools IndexTools IndexTools 8 STAT1 IndexTools 2003-07-22 -2 0 0 0 6 9.95 2003-07-24 t t t 8 STAT3 2003-07-22 -2 0 0 0 8 38.80 2003-07-22 2003-08-21 13:41:12 -0400 Error: [7197]Error receive data in socket. 2003-08-21 13:41:12 -0400 Dump: [7197]Service task finished. 2003-08-21 13:42:11 -0400 Message: New client connected. 2003-08-21 13:42:11 -0400 Dump: [7272]Start service task 2003-08-21 13:42:11 -0400 Dump: [7272]Processing GET_ACCOUNT_LIST Request POST / HTTP/1.0 Host: someIP Referer: http://someIP User-Agent: ColdFusion Content-type: application/x-www-form-urlencoded Content-length: 167 The Host and the Referer IP are the sameI'm thinking this might be why I can't get the resonse. We're using CF5.0 and I know the WDDX packets won't be able to put the XML in the right format due to the <>'s. So far I'm at a loss. Any sugesstions would be greatly appreciated. Matt ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: (Admin) List Question
If there's an SMTP feature to send one message and have it delivered to two separate people at the same domain then it's something that Howie would deal with in iMS (it's probably there). Note the line in the footer that says unsubscribe. It's customized for you and you alone. Each post has its own unsubscribe line with the users information. Can't share that. This stops the multiple people on the To/CC line as well. It would be nice for a single message but then I'd have to remove the nice unsubscribe feature. > We've got two people at our company subscribed to the cf-talk list. I notice > in my mail server's SMTP logs what appears to be two copies of the message > being delivered from HOF's server. Both addresses here are in the same domain > name. I thought there was an SMTP provision to deliver a single message to > multiple recipients in a domain. Barring that, couldn't the same thing be > accomplished just by specifying multiple recipients in the TO address? > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL : Finding element in list of values in a query field.
I found it! It was back in January of this year that I ran into a similar problem. Ewika and Phil helped me then and I even wrote a lengthy email to the list about the solution. In this instance it may be hard to break out the talents into proper fields since I am going to have to do a Batch update from an Excel file which has a fixed format. I don't know if I can get the company to change this format, and then use a CF page to parse the Excel file and insert records into the database properly. I do know, however, that they aren't paying me enough for a reusable Import routine for their data. Here is the code which uses a single SQL LIKE statement: or ',' & coatings & ',' LIKE '%,#i#,%' This obviates the need to modify entries in the database itself. But I suppose it would still be better to find a way to break this out in a separate table? -Gel -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: XML request/response issues - Still
Have you tried sending your post as a raw XML post instead? Simply change your cfhttpparam type to XML. -Matt On Wednesday, August 27, 2003, at 02:38 PM, Matt Blatchley wrote: > I still trying to send an XML request to a server, but I get a > Connection > Failed Error in the response when I use CFHTTP. I know I'm doing > something > wrong becuase the log file is processing the request correctly, but the > response is never getting back. The CFHTTP.FileContent is saying > Connection > Failed. > > I'm still new to XML so I'm not sure what I'm doing incorrectly. > > > Here's the Request: > > "resellerpassword password> uestid>ER#RandRange(1,99)#1 requestcode> request>"> > > http://someIP"; method="post" name="XML_name" > resolveurl="false"> > value="#xml_request_text#"> > > > #CFHTTP.FileContent# > > Is there a better way to do this in CF? > > In the log file I get for the response... > > xml_request_text=IDID password> > ER2798971 > > 2003-08-21 13:41:12 -0400 Dump: [7197]Sending Response > > ER279897 > > > > IndexTools > > IndexTools > > > > IndexTools > > 8 > > STAT1 > > IndexTools > > 2003-07-22 > > -2 > > 0 > > 0 > > 0 > > 6 > > > > 9.95 > > 2003-07-24 > > > > > > t > > t > > > > t > > 8 > > STAT3 > > > > 2003-07-22 > > -2 > > 0 > > 0 > > 0 > > 8 > > > > 38.80 > > 2003-07-22 > > > > > > > > 2003-08-21 13:41:12 -0400 Error: [7197]Error receive data in > socket. > > 2003-08-21 13:41:12 -0400 Dump: [7197]Service task finished. > > 2003-08-21 13:42:11 -0400 Message: New client connected. > > 2003-08-21 13:42:11 -0400 Dump: [7272]Start service task > > 2003-08-21 13:42:11 -0400 Dump: [7272]Processing GET_ACCOUNT_LIST > Request POST / HTTP/1.0 > > Host: someIP > > Referer: http://someIP > > User-Agent: ColdFusion > > Content-type: application/x-www-form-urlencoded > > Content-length: 167 > > > The Host and the Referer IP are the sameI'm thinking this might be > why I > can't get the resonse. > We're using CF5.0 and I know the WDDX packets won't be able to put the > XML > in the right format due to the <>'s. So far I'm at a loss. > > Any sugesstions would be greatly appreciated. > > Matt > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
XML request/response issues - Still
I still trying to send an XML request to a server, but I get a Connection Failed Error in the response when I use CFHTTP. I know I'm doing something wrong becuase the log file is processing the request correctly, but the response is never getting back. The CFHTTP.FileContent is saying Connection Failed. I'm still new to XML so I'm not sure what I'm doing incorrectly. Here's the Request: http://someIP"; method="post" name="XML_name" resolveurl="false"> #CFHTTP.FileContent# Is there a better way to do this in CF? In the log file I get for the response... xml_request_text=IDID ER2798971 2003-08-21 13:41:12 -0400 Dump: [7197]Sending Response ER279897 IndexTools IndexTools IndexTools 8 STAT1 IndexTools 2003-07-22 -2 0 0 0 6 9.95 2003-07-24 t t t 8 STAT3 2003-07-22 -2 0 0 0 8 38.80 2003-07-22 2003-08-21 13:41:12 -0400 Error: [7197]Error receive data in socket. 2003-08-21 13:41:12 -0400 Dump: [7197]Service task finished. 2003-08-21 13:42:11 -0400 Message: New client connected. 2003-08-21 13:42:11 -0400 Dump: [7272]Start service task 2003-08-21 13:42:11 -0400 Dump: [7272]Processing GET_ACCOUNT_LIST Request POST / HTTP/1.0 Host: someIP Referer: http://someIP User-Agent: ColdFusion Content-type: application/x-www-form-urlencoded Content-length: 167 The Host and the Referer IP are the sameI'm thinking this might be why I can't get the resonse. We're using CF5.0 and I know the WDDX packets won't be able to put the XML in the right format due to the <>'s. So far I'm at a loss. Any sugesstions would be greatly appreciated. Matt ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: DWMX 2004 - Whats new for us?
> For example, a language centric tool could leverage strong > server debug capabilities. Why would it need to be "language-centric" to leverage strong server debug capabilities? > Wouldn't you like to be able to open a page within the IDE, > go through your application, have debug output in another > panel of your IDE for that page and it's include files, be > able to set break points, and trace variable values to reduce > debugging needs, and come across an error, click > on the error within your IDE, have it open the offending .cfm > page in your IDE, and highlight the error. > > Wouldn't that be powerful? And doesn't that sound familiar > (except that it works so clunkily and problematically in > CFS...)? Frankly, I never found pre-CFMX server debugging using Studio to be very useful. It usually took me longer to do that than to just figure out the problem the "old-fashioned" way. In addition, it was so unstable as to be generally unreliable. But, that's irrelevant with regard to whether it could be done in Dreamweaver. I see no reason why it couldn't be done, except that to my knowledge, CFMX doesn't support it. > What we need is a ColdFusion centric IDE, that also strongly > supports the rest of the stuff we'll be reasonably expected > to work within (xml, html, css, javascript). For "the rest of the stuff", Dreamweaver MX is so far ahead of CF Studio and HomeSite+ that there's no real comparison. > If it can be used for other things, great. But let's take the > tools to another level, I can't understand why after 4 years, > CFS and DWMX is still the best we can have to support CFML > development specifically. Maybe this is because CF development just isn't that complicated, compared to alternatives. Not that much has changed in four years, as far as CF programming goes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CFMX and AS/400
I am running ColdFusionMX 6.1 and I am using the JTOpen JDBC driver from the IBM site. I was not able to get the DB2 JDBC to work. Chris >Hello, > > > >In the process of upgrading from CF 5.0 to CFMX 6.1. I am using an AS/400 >for some of apps. Does the DB2 Driver that comes with CFMX 6.1 able to >connect to an AS/400 without using DB2 Connect software? > > > >James Taavon >Senior Web Developer >Department of Labor, Licensing and Regulation >1100 N. Eutaw Street >Room 203 >Baltimore, MD 21201 >Ph: 410 767-8190 >Fx: 410 333-5203 > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: DWMX 2004 - Whats new for us?
I agree as well. I have been working on an Eclipse plug-in in my spare time that does all of what you mention. Right now, all I have is syntax highlighting and J2EE deployment management. Hoping to add something like intellisense and syntax debugging in the future, but as always, side projects are slow going. -Matt On Wednesday, August 27, 2003, at 02:23 PM, Tony Weeg wrote: > I couldnt have said it better myself. > > CFS with some VBStudio like tools, intellisense, breakpoints, > etcwould just plain rock > > tony weeg > sr. web applications architect > navtrak, inc. > [EMAIL PROTECTED] > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -Original Message- > From: Calvin Ward [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 2:21 PM > To: CF-Talk > Subject: Re: DWMX 2004 - Whats new for us? > > > I would have to disagree. > > For example, a language centric tool could leverage strong server debug > capabilities. > > Wouldn't you like to be able to open a page within the IDE, go through > your application, have debug output in another panel of your IDE for > that page and it's include files, be able to set break points, and > trace > variable values to reduce debugging needs, and come across an > error, click on the error within your IDE, have it open the offending > .cfm page in your IDE, and highlight the error. > > Wouldn't that be powerful? And doesn't that sound familiar (except that > it works so clunkily and problematically in CFS...)? > > Divorcing the language from the tool does the developer a disservice, > you can write CFML in notepad, but why should you? CFS is far superior > with it's help/reference system alone (language specific), not to > mention the color coding (language specific), and the toolbar (language > specific), and so forth. > > What we need is a ColdFusion centric IDE, that also strongly supports > the rest of the stuff we'll be reasonably expected to work within (xml, > html, css, javascript). > > If it can be used for other things, great. But let's take the tools to > another level, I can't understand why after 4 years, CFS and DWMX is > still the best we can have to support CFML development specifically. > > - Calvin > > - Original Message - > From: "Jerry Johnson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 27, 2003 2:01 PM > Subject: Re: DWMX 2004 - Whats new for us? > > >> I see it from exactly the opposite point of view. >> >> I am forever thankful Allaire (and Macromedia) have divorced the >> language > from the development environment. >> >> I'm glad I can use whatever editor I like to manipluate the source. >> I've > used textpad, CF Studio, Dreamweaver, Editplus, Ultradev, grep. >> >> I like (and use) CF Studio. It is my current favorite. But as with any > editor, it will take the back seat at some point to my new favorite > (whatever it is going to be). >> >> I also like that Studio isn't CF centric. I use it to edit perl, php, > vbscript, bat files, cshell scripts, jsp, hts. >> >> It still isn't as good as Brief or the Turbo Pascal 5.0 editor (for >> what > they did at the time). But it is the best I have at the moment. And I > would keep it for the extended search and replace even if nothing else > worked. >> >> Just my opinion >> Jerry Johnson >> > [EMAIL PROTECTED] 08/27/03 01:51PM >>> >> You make some valid points. In fact your points support my arguments. > >> At > the end of the day, we are still left with out a "ColdFusion Centered" > IDE. We still have to make do with what's available. No doubt > Dreamweaver leverages ColdFusion MX better than every thing else on the > market but its still a 20% ColdFusion / 80% every thing else tool. We > should have to do all this jumping around. Some of use using jedit, > others you dreamweaver, some in HomeSite, and proably most still in > Studio. >> >> As far as the survey. I would like to see the survey results. I want > >> to > know how many serious CF developers have completely adopted. I want to > see bar charts and pie graphs and stuff. Are they giving us what we > asked for? >> >> Heck, they can just take the "application" panel in Dreamweaver, drop >> it > into Studio then Update the Studio interface to be consistant with > other > products in the family and tah dah.. there you have it. >> >> My point is we need a ColdFusion Centered IDE; one that MACR should be > proud of. >> >> >> >> >> >>> On Wednesday, Aug 27, 2003, at 03:03 US/Pacific, dwayne wrote: About 9 û 11 months ago I spent about 10 minutes of my time responding to a macromediaÆs ColdFusion survey and I have yet to see the results. >>> >>> I would think that Red Sky (CFMX 6.1) was the result, for the most >>> part... >>> >> >> Would you all agree, that us ColdFusion developers deserve some love too!! >>> >>> Considering Allaire (and ColdFusion) might have withered away without > >>> Macromedia's investment in the techno
(Admin) List Question
We've got two people at our company subscribed to the cf-talk list. I notice in my mail server's SMTP logs what appears to be two copies of the message being delivered from HOF's server. Both addresses here are in the same domain name. I thought there was an SMTP provision to deliver a single message to multiple recipients in a domain. Barring that, couldn't the same thing be accomplished just by specifying multiple recipients in the TO address? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL : Finding element in list of values in a query field.
it would work to do... select * from [table] where talent like '%dancing%' nothing else is necessary :) tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:40 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. Would it work to just do SELECT * FROM [table] WHERE ',' + talents + ',' LIKE '%,#aTalent#,%' Tyler Clendenin GSL Solutions -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:20 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
URL string format
I have a string in a field in an SQL table such as: American Book of Days, 4th Ed.. I pass this and other fields in this record to an update form so I can edit the record. The fields display in input text boxes. The problem I have is this particular text displays partly inside the box and partly outside. It seems to have a problem interpreting the string. What CF command can I add to #getbookid.url# to make the URL string display in the text box? Is there some string format command? Thanks. Robert O. HWW ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL : Finding element in list of values in a query field.
Would it work to just do SELECT * FROM [table] WHERE ',' + talents + ',' LIKE '%,#aTalent#,%' Tyler Clendenin GSL Solutions -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:20 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
MX timeout regardless of how long I set request time out.
I have an extremely long running not publicly accessible CF page. The problem I run into from time to time is that CFMX seems to time out OR is it Jrun that times out? CFMX seems to reset itself and for a few seconds I get "Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server." when ever I run this page. I have tried . And I still get the same error. Is there a .xlm file I need to tweak? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DWMX 2004 - Whats new for us?
I couldnt have said it better myself. CFS with some VBStudio like tools, intellisense, breakpoints, etcwould just plain rock tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:21 PM To: CF-Talk Subject: Re: DWMX 2004 - Whats new for us? I would have to disagree. For example, a language centric tool could leverage strong server debug capabilities. Wouldn't you like to be able to open a page within the IDE, go through your application, have debug output in another panel of your IDE for that page and it's include files, be able to set break points, and trace variable values to reduce debugging needs, and come across an error, click on the error within your IDE, have it open the offending .cfm page in your IDE, and highlight the error. Wouldn't that be powerful? And doesn't that sound familiar (except that it works so clunkily and problematically in CFS...)? Divorcing the language from the tool does the developer a disservice, you can write CFML in notepad, but why should you? CFS is far superior with it's help/reference system alone (language specific), not to mention the color coding (language specific), and the toolbar (language specific), and so forth. What we need is a ColdFusion centric IDE, that also strongly supports the rest of the stuff we'll be reasonably expected to work within (xml, html, css, javascript). If it can be used for other things, great. But let's take the tools to another level, I can't understand why after 4 years, CFS and DWMX is still the best we can have to support CFML development specifically. - Calvin - Original Message - From: "Jerry Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 2:01 PM Subject: Re: DWMX 2004 - Whats new for us? > I see it from exactly the opposite point of view. > > I am forever thankful Allaire (and Macromedia) have divorced the > language from the development environment. > > I'm glad I can use whatever editor I like to manipluate the source. > I've used textpad, CF Studio, Dreamweaver, Editplus, Ultradev, grep. > > I like (and use) CF Studio. It is my current favorite. But as with any editor, it will take the back seat at some point to my new favorite (whatever it is going to be). > > I also like that Studio isn't CF centric. I use it to edit perl, php, vbscript, bat files, cshell scripts, jsp, hts. > > It still isn't as good as Brief or the Turbo Pascal 5.0 editor (for > what they did at the time). But it is the best I have at the moment. And I would keep it for the extended search and replace even if nothing else worked. > > Just my opinion > Jerry Johnson > > >>> [EMAIL PROTECTED] 08/27/03 01:51PM >>> > You make some valid points. In fact your points support my arguments. > At the end of the day, we are still left with out a "ColdFusion Centered" IDE. We still have to make do with what's available. No doubt Dreamweaver leverages ColdFusion MX better than every thing else on the market but its still a 20% ColdFusion / 80% every thing else tool. We should have to do all this jumping around. Some of use using jedit, others you dreamweaver, some in HomeSite, and proably most still in Studio. > > As far as the survey. I would like to see the survey results. I want > to know how many serious CF developers have completely adopted. I want to see bar charts and pie graphs and stuff. Are they giving us what we asked for? > > Heck, they can just take the "application" panel in Dreamweaver, drop > it into Studio then Update the Studio interface to be consistant with other products in the family and tah dah.. there you have it. > > My point is we need a ColdFusion Centered IDE; one that MACR should be proud of. > > > > > > >On Wednesday, Aug 27, 2003, at 03:03 US/Pacific, dwayne wrote: > >> About 9 û 11 months ago I spent about 10 minutes of my time > >> responding to a macromediaÆs ColdFusion survey and I have yet to > >> see the results. > > > >I would think that Red Sky (CFMX 6.1) was the result, for the most > >part... > > > > > >> Would you all agree, that us ColdFusion developers deserve some > >> love too!! > > > >Considering Allaire (and ColdFusion) might have withered away without > >Macromedia's investment in the technology, I'd say that CFers got > >quite a bit of love... > > > >> Sure ColdFusion MX sports a bunch of new features that are > >> fantastic and the as for old advanced features û theyÆre tighter > >> than ever. I'm loving cffunction, I'm all over cfc's, and > >> ColdFusion's ability to integrate with FLASH is the best thing > >> since the last "best thing". > > > >Excellent! Glad you're happy with that at least (especially since > >quite a few CFers beat on Macromedia over the 'promotion' of Flash to > >CFers and the whole OO issues around CFCs). > > > >>
RE: SQL : Finding element in list of values in a query field.
You're right...I've done this before and gotten assistance with it... Arrggh...it seems so long ago I can't remember exactly what the solution was. The correct database design would involve a separate table containig the record ID and then the corresponding talents wouldn't it. Perhaps that is what I should do from the start rather than go this way. -Angel -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:20 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL : Finding element in list of values in a query field.
why would you do that? a like '%dancing%' would work regardless of the leading and trailing commas. he would be best suited for another table that had the various "talents" one for each instance of a talent for each instance of a personright? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:20 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Authorize.NET Custom Tag?
Are there any web services solutions available? I haven't looked because I'm not in need of one right now, but this thread got me thinking that it would behoove AuthorizeNet, and others, to provide a ws solution, write once, use many times. Mark -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 12:35 PM To: CF-Talk Subject: Re: Authorize.NET Custom Tag? I use the one from Oleani Technologies and it works great. http://www.oleani.com/products.cfm?pid=2 I use this with CFMX and it was the only one that I could get to work. Clint - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 11:27 AM Subject: Re: Authorize.NET Custom Tag? > Jeff, > > If you find a good one, please let me know. About 4 months ago (before > Authorize.net changed the way you communicate with their system), I tried to > use them. It was a total nightmareI talked to 8 techs and a few > managersnone gave me the same story and nobody could tell me how to > reference the stuff they send back (i.e. approval codes etc.). They said > there were no variables and their "thing" they send back was a list of > key/value pairsbut it didn't have a name!!! Yeah rightso how to I > reference it I saidthey saidyou just do!!. > > Soif ya find a tag that works. ;-) > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: "Jeff Chastain" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 27, 2003 9:14 AM > Subject: Authorize.NET Custom Tag? > > > > I am putting together a shopping cart on very short notice for another > > developer and am looking for a way to communicate with Authorize.NET for > > payment processing. I am looking at the Macromedia Exchange and there are > > several different tags available. Has anybody worked with one in > particular > > that you could recommend? > > > > Thanks > > -- Jeff > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: DWMX 2004 - Whats new for us?
I would have to disagree. For example, a language centric tool could leverage strong server debug capabilities. Wouldn't you like to be able to open a page within the IDE, go through your application, have debug output in another panel of your IDE for that page and it's include files, be able to set break points, and trace variable values to reduce debugging needs, and come across an error, click on the error within your IDE, have it open the offending .cfm page in your IDE, and highlight the error. Wouldn't that be powerful? And doesn't that sound familiar (except that it works so clunkily and problematically in CFS...)? Divorcing the language from the tool does the developer a disservice, you can write CFML in notepad, but why should you? CFS is far superior with it's help/reference system alone (language specific), not to mention the color coding (language specific), and the toolbar (language specific), and so forth. What we need is a ColdFusion centric IDE, that also strongly supports the rest of the stuff we'll be reasonably expected to work within (xml, html, css, javascript). If it can be used for other things, great. But let's take the tools to another level, I can't understand why after 4 years, CFS and DWMX is still the best we can have to support CFML development specifically. - Calvin - Original Message - From: "Jerry Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 2:01 PM Subject: Re: DWMX 2004 - Whats new for us? > I see it from exactly the opposite point of view. > > I am forever thankful Allaire (and Macromedia) have divorced the language from the development environment. > > I'm glad I can use whatever editor I like to manipluate the source. I've used textpad, CF Studio, Dreamweaver, Editplus, Ultradev, grep. > > I like (and use) CF Studio. It is my current favorite. But as with any editor, it will take the back seat at some point to my new favorite (whatever it is going to be). > > I also like that Studio isn't CF centric. I use it to edit perl, php, vbscript, bat files, cshell scripts, jsp, hts. > > It still isn't as good as Brief or the Turbo Pascal 5.0 editor (for what they did at the time). But it is the best I have at the moment. And I would keep it for the extended search and replace even if nothing else worked. > > Just my opinion > Jerry Johnson > > >>> [EMAIL PROTECTED] 08/27/03 01:51PM >>> > You make some valid points. In fact your points support my arguments. At the end of the day, we are still left with out a "ColdFusion Centered" IDE. We still have to make do with what's available. No doubt Dreamweaver leverages ColdFusion MX better than every thing else on the market but its still a 20% ColdFusion / 80% every thing else tool. We should have to do all this jumping around. Some of use using jedit, others you dreamweaver, some in HomeSite, and proably most still in Studio. > > As far as the survey. I would like to see the survey results. I want to know how many serious CF developers have completely adopted. I want to see bar charts and pie graphs and stuff. Are they giving us what we asked for? > > Heck, they can just take the "application" panel in Dreamweaver, drop it into Studio then Update the Studio interface to be consistant with other products in the family and tah dah.. there you have it. > > My point is we need a ColdFusion Centered IDE; one that MACR should be proud of. > > > > > > >On Wednesday, Aug 27, 2003, at 03:03 US/Pacific, dwayne wrote: > >> About 9 û 11 months ago I spent about 10 minutes of my time responding > >> to a macromediaÆs ColdFusion survey and I have yet to see the results. > > > >I would think that Red Sky (CFMX 6.1) was the result, for the most > >part... > > > > > >> Would you all agree, that us ColdFusion developers deserve some love > >> too!! > > > >Considering Allaire (and ColdFusion) might have withered away without > >Macromedia's investment in the technology, I'd say that CFers got quite > >a bit of love... > > > >> Sure ColdFusion MX sports a bunch of new features that are fantastic > >> and the as for old advanced features û theyÆre tighter than ever. I'm > >> loving cffunction, I'm all over cfc's, and ColdFusion's ability to > >> integrate with FLASH is the best thing since the last "best thing". > > > >Excellent! Glad you're happy with that at least (especially since quite > >a few CFers beat on Macromedia over the 'promotion' of Flash to CFers > >and the whole OO issues around CFCs). > > > >> However, despite all of these wonderful improvements in the server > >> application, I'm still not convinced that they have committed to > >> providing us with a solid "Development Environment" that supports the > >> work habits of the sophisticated ColdFusion Developer. > > > >I think part of the problem here is that your chosen IDE becomes your > >second-nature way of working and it's really hard to change. Several > >high-profile CFers have made the jump to Dreamwe
RE: SQL : Finding element in list of values in a query field.
First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ",running,dancing,cooking," 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents <> '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: SQL : Finding element in list of values in a query field.
yeah, most would say to build a table that links the two togethersearching in a long text field would be kinda kludgy when you could build a join table, that had a key that related to the other table, then that would be better db design ;) GET SOME SLEEP HOLMES tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:56 PM To: CF-Talk Subject: RE: SQL : Finding element in list of values in a query field. Yes. I started thinking of IN statements for some reason...and Sub select statements. *looks baffled* But for some reason I didn't remember using like in the past. I seem to remember someone telling me it was bad form to use checkboxes to build a list of values in a field that way...but I can't remember why. Good grief. Time to stop coding and go sleep!!! ^_^ -Angel -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] select * from blah where blah like '%dancing%' :) tw -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DWMX 2004 - Whats new for us?
Question - how is CFS 100% ColdFusion? It does RDS and debugging, but everything else is not specific to CF, is it? (And doesn't DW support RDS, or at least remote files.) It seems like the only thing you would lose is debugging... although wait - didn't DWMX support CFMX debugging? I think it did. So I'm not sure I agree with your argument. Now, that being said, I _really_ prefer CFS, but it's more a question of style then a question of functionality. In fact, DWMX has some functions I wish CFS had... not enough to make me switch, but you could almost say DWMX is more CF-centric. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: dwayne [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 11:51 AM > To: CF-Talk > Subject: Re: DWMX 2004 - Whats new for us? > > > You make some valid points. In fact your points support my > arguments. At the end of the day, we are still left with out > a "ColdFusion Centered" IDE. We still have to make do with > what's available. No doubt Dreamweaver leverages ColdFusion > MX better than every thing else on the market but its still a > 20% ColdFusion / 80% every thing else tool. We should have > to do all this jumping around. Some of use using jedit, > others you dreamweaver, some in HomeSite, and proably most > still in Studio. > > As far as the survey. I would like to see the survey > results. I want to know how many serious CF developers have > completely adopted. I want to see bar charts and pie graphs > and stuff. Are they giving us what we asked for? > > Heck, they can just take the "application" panel in > Dreamweaver, drop it into Studio then Update the Studio > interface to be consistant with other products in the family > and tah dah.. there you have it. > > My point is we need a ColdFusion Centered IDE; one that MACR > should be proud of. > > > > > > >On Wednesday, Aug 27, 2003, at 03:03 US/Pacific, dwayne wrote: > >> About 9 - 11 months ago I spent about 10 minutes of my time > >> responding > >> to a macromedia's ColdFusion survey and I have yet to see > the results. > > > >I would think that Red Sky (CFMX 6.1) was the result, for the most > >part... > > > > > >> Would you all agree, that us ColdFusion developers deserve > some love > >> too!! > > > >Considering Allaire (and ColdFusion) might have withered > away without > >Macromedia's investment in the technology, I'd say that > CFers got quite > >a bit of love... > > > >> Sure ColdFusion MX sports a bunch of new features that are > fantastic > >> and the as for old advanced features - they're tighter > than ever. I'm > >> loving cffunction, I'm all over cfc's, and ColdFusion's ability to > >> integrate with FLASH is the best thing since the last "best thing". > > > >Excellent! Glad you're happy with that at least (especially > since quite > >a few CFers beat on Macromedia over the 'promotion' of Flash > to CFers > >and the whole OO issues around CFCs). > > > >> However, despite all of these wonderful improvements in the server > >> application, I'm still not convinced that they have committed to > >> providing us with a solid "Development Environment" that > supports the > >> work habits of the sophisticated ColdFusion Developer. > > > >I think part of the problem here is that your chosen IDE > becomes your > >second-nature way of working and it's really hard to change. Several > >high-profile CFers have made the jump to Dreamweaver and are > very happy > >- and some aren't. Dreamweaver is certainly a very different tool to > >HomeSite / CF Studio. However, CF Studio used to cost $499 > and now you > >can get it (as HomeSite+) for just $399 by buying Dreamweaver. And > >there's a 5.5 version in the works so it's not like Macromedia's > >abandoned anyone here: > > > > http://www.macromedia.com/software/homesite/ > > > >Me personally, I tried CF Studio back in 2001 and just couldn't get > >along with it at all. I figured that since Macromedia bought Allaire > >and we'd be using ColdFusion, I ought to use the dedicated IDE. I > >really tried. But I kept going back to Dreamweaver for so > many things. > >And it wasn't really anything specific that I could put my finger on > >and say "You know, if CFS just did 'X' (or didn't do 'Y' > every time I > >try 'Z') then I'd be happy..." No, it was just a general usability > >issue for me - CF Studio just didn't suit me. > > > >So I switched back to Dreamweaver (well, UltraDev 4, actually). Then > >Dreamweaver MX came out and swallowed (the higher-priced) > UltraDev and > >I was still a happy camper! The CFC and
Re: DWMX 2004 - Whats new for us?
I see it from exactly the opposite point of view. I am forever thankful Allaire (and Macromedia) have divorced the language from the development environment. I'm glad I can use whatever editor I like to manipluate the source. I've used textpad, CF Studio, Dreamweaver, Editplus, Ultradev, grep. I like (and use) CF Studio. It is my current favorite. But as with any editor, it will take the back seat at some point to my new favorite (whatever it is going to be). I also like that Studio isn't CF centric. I use it to edit perl, php, vbscript, bat files, cshell scripts, jsp, hts. It still isn't as good as Brief or the Turbo Pascal 5.0 editor (for what they did at the time). But it is the best I have at the moment. And I would keep it for the extended search and replace even if nothing else worked. Just my opinion Jerry Johnson >>> [EMAIL PROTECTED] 08/27/03 01:51PM >>> You make some valid points. In fact your points support my arguments. At the end of the day, we are still left with out a "ColdFusion Centered" IDE. We still have to make do with what's available. No doubt Dreamweaver leverages ColdFusion MX better than every thing else on the market but its still a 20% ColdFusion / 80% every thing else tool. We should have to do all this jumping around. Some of use using jedit, others you dreamweaver, some in HomeSite, and proably most still in Studio. As far as the survey. I would like to see the survey results. I want to know how many serious CF developers have completely adopted. I want to see bar charts and pie graphs and stuff. Are they giving us what we asked for? Heck, they can just take the "application" panel in Dreamweaver, drop it into Studio then Update the Studio interface to be consistant with other products in the family and tah dah.. there you have it. My point is we need a ColdFusion Centered IDE; one that MACR should be proud of. >On Wednesday, Aug 27, 2003, at 03:03 US/Pacific, dwayne wrote: >> About 9 û 11 months ago I spent about 10 minutes of my time responding >> to a macromediaÆs ColdFusion survey and I have yet to see the results. > >I would think that Red Sky (CFMX 6.1) was the result, for the most >part... > >> Would you all agree, that us ColdFusion developers deserve some love >> too!! > >Considering Allaire (and ColdFusion) might have withered away without >Macromedia's investment in the technology, I'd say that CFers got quite >a bit of love... > >> Sure ColdFusion MX sports a bunch of new features that are fantastic >> and the as for old advanced features û theyÆre tighter than ever. I'm >> loving cffunction, I'm all over cfc's, and ColdFusion's ability to >> integrate with FLASH is the best thing since the last "best thing". > >Excellent! Glad you're happy with that at least (especially since quite >a few CFers beat on Macromedia over the 'promotion' of Flash to CFers >and the whole OO issues around CFCs). > >> However, despite all of these wonderful improvements in the server >> application, I'm still not convinced that they have committed to >> providing us with a solid "Development Environment" that supports the >> work habits of the sophisticated ColdFusion Developer. > >I think part of the problem here is that your chosen IDE becomes your >second-nature way of working and it's really hard to change. Several >high-profile CFers have made the jump to Dreamweaver and are very happy >- and some aren't. Dreamweaver is certainly a very different tool to >HomeSite / CF Studio. However, CF Studio used to cost $499 and now you >can get it (as HomeSite+) for just $399 by buying Dreamweaver. And >there's a 5.5 version in the works so it's not like Macromedia's >abandoned anyone here: > > http://www.macromedia.com/software/homesite/ > >Me personally, I tried CF Studio back in 2001 and just couldn't get >along with it at all. I figured that since Macromedia bought Allaire >and we'd be using ColdFusion, I ought to use the dedicated IDE. I >really tried. But I kept going back to Dreamweaver for so many things. >And it wasn't really anything specific that I could put my finger on >and say "You know, if CFS just did 'X' (or didn't do 'Y' every time I >try 'Z') then I'd be happy..." No, it was just a general usability >issue for me - CF Studio just didn't suit me. > >So I switched back to Dreamweaver (well, UltraDev 4, actually). Then >Dreamweaver MX came out and swallowed (the higher-priced) UltraDev and >I was still a happy camper! The CFC and Web Service browsers are very >useful (I showed how to use the latter to quickly build CF applications >that consume Web Services in a BACFUG presentation a while back). > >Then I switched to a Mac. Dreamweaver MX (6.0) was not as good on the >Mac as on Windows so I struggled for a while and switched to jEdit. It >wasn't ideal for me... I found it clunky and ugly and the CF support >wasn't great but it was faster and more stable than DWMX 6.0 on the >Mac. Then the
RE: SQL : Finding element in list of values in a query field.
Yes. I started thinking of IN statements for some reason...and Sub select statements. *looks baffled* But for some reason I didn't remember using like in the past. I seem to remember someone telling me it was bad form to use checkboxes to build a list of values in a field that way...but I can't remember why. Good grief. Time to stop coding and go sleep!!! ^_^ -Angel -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] select * from blah where blah like '%dancing%' :) tw -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: DWMX 2004 - Whats new for us?
You make some valid points. In fact your points support my arguments. At the end of the day, we are still left with out a "ColdFusion Centered" IDE. We still have to make do with what's available. No doubt Dreamweaver leverages ColdFusion MX better than every thing else on the market but its still a 20% ColdFusion / 80% every thing else tool. We should have to do all this jumping around. Some of use using jedit, others you dreamweaver, some in HomeSite, and proably most still in Studio. As far as the survey. I would like to see the survey results. I want to know how many serious CF developers have completely adopted. I want to see bar charts and pie graphs and stuff. Are they giving us what we asked for? Heck, they can just take the "application" panel in Dreamweaver, drop it into Studio then Update the Studio interface to be consistant with other products in the family and tah dah.. there you have it. My point is we need a ColdFusion Centered IDE; one that MACR should be proud of. >On Wednesday, Aug 27, 2003, at 03:03 US/Pacific, dwayne wrote: >> About 9 11 months ago I spent about 10 minutes of my time responding >> to a macromedias ColdFusion survey and I have yet to see the results. > >I would think that Red Sky (CFMX 6.1) was the result, for the most >part... > >> Would you all agree, that us ColdFusion developers deserve some love >> too!! > >Considering Allaire (and ColdFusion) might have withered away without >Macromedia's investment in the technology, I'd say that CFers got quite >a bit of love... > >> Sure ColdFusion MX sports a bunch of new features that are fantastic >> and the as for old advanced features theyre tighter than ever. I'm >> loving cffunction, I'm all over cfc's, and ColdFusion's ability to >> integrate with FLASH is the best thing since the last "best thing". > >Excellent! Glad you're happy with that at least (especially since quite >a few CFers beat on Macromedia over the 'promotion' of Flash to CFers >and the whole OO issues around CFCs). > >> However, despite all of these wonderful improvements in the server >> application, I'm still not convinced that they have committed to >> providing us with a solid "Development Environment" that supports the >> work habits of the sophisticated ColdFusion Developer. > >I think part of the problem here is that your chosen IDE becomes your >second-nature way of working and it's really hard to change. Several >high-profile CFers have made the jump to Dreamweaver and are very happy >- and some aren't. Dreamweaver is certainly a very different tool to >HomeSite / CF Studio. However, CF Studio used to cost $499 and now you >can get it (as HomeSite+) for just $399 by buying Dreamweaver. And >there's a 5.5 version in the works so it's not like Macromedia's >abandoned anyone here: > > http://www.macromedia.com/software/homesite/ > >Me personally, I tried CF Studio back in 2001 and just couldn't get >along with it at all. I figured that since Macromedia bought Allaire >and we'd be using ColdFusion, I ought to use the dedicated IDE. I >really tried. But I kept going back to Dreamweaver for so many things. >And it wasn't really anything specific that I could put my finger on >and say "You know, if CFS just did 'X' (or didn't do 'Y' every time I >try 'Z') then I'd be happy..." No, it was just a general usability >issue for me - CF Studio just didn't suit me. > >So I switched back to Dreamweaver (well, UltraDev 4, actually). Then >Dreamweaver MX came out and swallowed (the higher-priced) UltraDev and >I was still a happy camper! The CFC and Web Service browsers are very >useful (I showed how to use the latter to quickly build CF applications >that consume Web Services in a BACFUG presentation a while back). > >Then I switched to a Mac. Dreamweaver MX (6.0) was not as good on the >Mac as on Windows so I struggled for a while and switched to jEdit. It >wasn't ideal for me... I found it clunky and ugly and the CF support >wasn't great but it was faster and more stable than DWMX 6.0 on the >Mac. Then the 6.1 updater came out and totally solidified the Mac >version: it was much faster and rock solid. So I switched, gratefully, >back to DWMX as my primary CF IDE. > >I can't talk about Dreamweaver MX 2004 much (for obvious reasons!) but >I'm using a recent (internal) build and I'm very happy with it. >Site-less editing has probably been the biggest help in my workflow as >well as the new Start Page with its list of recently edited files and >various common operations. > >> Dreamweaver still seems to be an overkill designers solutions. > >Hmm, I think depends on your perspective. I'm certainly not a designer >- I'm a hardcore developer - but Dreamweaver fits my workflow just >fine. I don't use all of its features but I use enough to make it >worthwhile (e.g., I live and die in "sites" even tho' I find the new >site-less editing mode very useful). > >> and as for Contribut
Re:Re:RE: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree
No similar operation in SQL unfortunately. Wish there was though... Good Luck. Chris -- Original Message From: "Richard Heiser"<[EMAIL PROTECTED]> Subject: Re:RE: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree Date: Wed, 27 Aug 2003 10:32:02 -0700 (PDT) >Um, I appreciate the response! But this is way over >my head. Does SQL Server really not have a >counterpart to Oracle's functions "START WITH" and >"CONNECT BY PRIOR"??? > >Seemed like such a simply query in Oracle: > >>> DATASOURCE="MyDatasource"> >> >SELECT iEntityID, iSubEntityOf, sName >> >FROM Mytable >> >WHERE NOT iEntityID >> >START WITH iEntityID=1 >> >CONNECT BY PRIOR iEntityID=iSubEntityOf >> > > >Thanks! > >-Richard > > >--- Chris <[EMAIL PROTECTED]> wrote: >> Here is a stored procedure I used for an old forum >> app. Should work for >> your situation. >> >> --DROP TABLE #stack >> --DROP TABLE #x >> --DROP TABLE #y >> --CREATE PROCEDURE expand (@current int) as >> DECLARE @current int >> DECLARE @level int, @line char(20) >> DECLARE @Pos int >> DECLARE @PrevReplyTo int >> CREATE TABLE #stack (item int, Thislevel int) >> CREATE TABLE #x (ID int, Name varchar(256), >> DateCreated datetime, InReplyTo >> int, Topic int, TotalReply int, Creator int, IsTop >> bit, Root int, TopDate >> datetime, _USER_ID int, MessageFrom >> varchar(256),ThisLevel int, Position >> int) >> CREATE TABLE #y (ID int, InReplyTo int, Root int) >> SET @current = 94 >> SET @Pos = 0 >> SET @PrevReplyTo = @current >> INSERT #y >> SELECT ID,InReplyTo, Root >> FROM Threads >> WHERE Root = @current >> ORDER BY DateCreated DESC >> >> INSERT #x >> SELECT Threads.ID AS "ID", >> Threads.Name AS "Name", >> Threads.DateCreated AS "DateCreated", >> Threads.InReplyTo AS "InReplyTo", >> Threads.Topic AS "Topic", >> Threads.TotalReply AS "TotalReply", >> Threads.Creator AS "Creator", >> Threads.IsTop AS "IsTop", >> Threads.Root AS "Root", >> Threads.TopDate AS "TopDate", >> Users.ID AS "_USER_ID", >> Users.Userid AS "MessageFrom", >> 0, >> 0 >> FROM Threads,Users >> WHERE Threads.Root = @current AND Threads.Creator = >> Users.ID >> >> SET NOCOUNT ON >> INSERT INTO #stack VALUES (@current, 1) >> SELECT @level = 1 >> >> WHILE @level > 0 >> BEGIN >> IF EXISTS (SELECT * FROM #stack WHERE Thislevel = >> @level) >> BEGIN >> -- If an item on the stack exists at this level, >> grab it >> SELECT @current = item FROM #stack WHERE Thislevel >> = @level >> >> -- Increment the position >> SET @Pos = @Pos + 1 >> -- Update the table with the new position >> UPDATE #x SET Position = @Pos, ThisLevel = @level >> - 1 WHERE ID = @current >> -- Delete this entry from the temp table (#y) >> DELETE FROM #y WHERE ID = @current >> >> -- Delete this entry from the stack >> DELETE FROM #stack WHERE Thislevel = @level AND >> item = @current >> -- Insert into the stack any IDs that are replies >> to the CURRENT ID >> INSERT #stack SELECT ID, @level + 1 FROM #y WHERE >> InReplyTo = @current >> -- If any were found, increment the level >> >> IF @@ROWCOUNT > 0 >> SELECT @level = @level + 1 >> END >> ELSE >> SELECT @level = @level - 1 >> >> >> IF ((SELECT COUNT(*) FROM #y) > 0 AND (SELECT >> COUNT(*) FROM #stack) = 0) >> BEGIN >> IF @level = 0 >> SELECT @level = @level + 1 >> >> INSERT #stack >> SELECT ID, @level + 1 FROM #y >> SELECT * FROM #stack >> END >> >> END -- WHILE >> >> DROP TABLE #stack >> SELECT ID,Name,ThisLevel,Position FROM #x ORDER BY >> Position,DateCreated >> >> >> DROP TABLE #x >> DROP TABLE #y >> >> >> >> >> >> -- >> Original Message >> From: "Hagan, Ryan Mr (Contractor >> ACI)"<[EMAIL PROTECTED]> >> Subject: RE: SQL syntax for Supertypes-Subtypes AKA >> Circular Reference AKA >> Entity Tree >> Date: Wed, 27 Aug 2003 11:21:52 -0400 >> >> >I asked a very similar question a few weeks ago. >> One solution was posted >> by >> >Jochem van Dieten: >> > >> >Use a nested set model, or use a 2 table model >> where one table holds >> >complete trees in an XMLData field (which you only >> need to edit when a >> >new element is inserted) and one holds individual >> messages but with an >> >FK to the table that holds the complete trees in >> XML. >> >I usually prefer the first solution, but in some >> cases the latter
Authorize.NET Custom Tag?
The guys at www.cartease.com/ have integrated the new Authorize.NET If I'm not mistaken, one of their techs works for Authorize.NET. Try contacting: Joe - [EMAIL PROTECTED] Daniel Garcia - [EMAIL PROTECTED] Stan >I am putting together a shopping cart on very short notice for another >developer and am looking for a way to communicate with Authorize.NET for >payment processing. I am looking at the Macromedia Exchange and there are >several different tags available. Has anybody worked with one in particular >that you could recommend? > >Thanks >-- Jeff > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL : Finding element in list of values in a query field.
select * from blah where blah like '%dancing%' :) tw tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:34 PM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
SQL : Finding element in list of values in a query field.
Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re:RE: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree
Um, I appreciate the response! But this is way over my head. Does SQL Server really not have a counterpart to Oracle's functions "START WITH" and "CONNECT BY PRIOR"??? Seemed like such a simply query in Oracle: > DATASOURCE="MyDatasource"> > > SELECT iEntityID, iSubEntityOf, sName > > FROM Mytable > > WHERE NOT iEntityID > > START WITH iEntityID=1 > > CONNECT BY PRIOR iEntityID=iSubEntityOf > > Thanks! -Richard --- Chris <[EMAIL PROTECTED]> wrote: > Here is a stored procedure I used for an old forum > app. Should work for > your situation. > > --DROP TABLE #stack > --DROP TABLE #x > --DROP TABLE #y > --CREATE PROCEDURE expand (@current int) as > DECLARE @current int > DECLARE @level int, @line char(20) > DECLARE @Pos int > DECLARE @PrevReplyTo int > CREATE TABLE #stack (item int, Thislevel int) > CREATE TABLE #x (ID int, Name varchar(256), > DateCreated datetime, InReplyTo > int, Topic int, TotalReply int, Creator int, IsTop > bit, Root int, TopDate > datetime, _USER_ID int, MessageFrom > varchar(256),ThisLevel int, Position > int) > CREATE TABLE #y (ID int, InReplyTo int, Root int) > SET @current = 94 > SET @Pos = 0 > SET @PrevReplyTo = @current > INSERT #y > SELECT ID,InReplyTo, Root > FROM Threads > WHERE Root = @current > ORDER BY DateCreated DESC > > INSERT #x > SELECT Threads.ID AS "ID", > Threads.Name AS "Name", > Threads.DateCreated AS "DateCreated", > Threads.InReplyTo AS "InReplyTo", > Threads.Topic AS "Topic", > Threads.TotalReply AS "TotalReply", > Threads.Creator AS "Creator", > Threads.IsTop AS "IsTop", > Threads.Root AS "Root", > Threads.TopDate AS "TopDate", > Users.ID AS "_USER_ID", > Users.Userid AS "MessageFrom", > 0, > 0 > FROM Threads,Users > WHERE Threads.Root = @current AND Threads.Creator = > Users.ID > > SET NOCOUNT ON > INSERT INTO #stack VALUES (@current, 1) > SELECT @level = 1 > > WHILE @level > 0 > BEGIN > IF EXISTS (SELECT * FROM #stack WHERE Thislevel = > @level) > BEGIN > -- If an item on the stack exists at this level, > grab it > SELECT @current = item FROM #stack WHERE Thislevel > = @level > > -- Increment the position > SET @Pos = @Pos + 1 > -- Update the table with the new position > UPDATE #x SET Position = @Pos, ThisLevel = @level > - 1 WHERE ID = @current > -- Delete this entry from the temp table (#y) > DELETE FROM #y WHERE ID = @current > > -- Delete this entry from the stack > DELETE FROM #stack WHERE Thislevel = @level AND > item = @current > -- Insert into the stack any IDs that are replies > to the CURRENT ID > INSERT #stack SELECT ID, @level + 1 FROM #y WHERE > InReplyTo = @current > -- If any were found, increment the level > > IF @@ROWCOUNT > 0 > SELECT @level = @level + 1 > END > ELSE > SELECT @level = @level - 1 > > > IF ((SELECT COUNT(*) FROM #y) > 0 AND (SELECT > COUNT(*) FROM #stack) = 0) > BEGIN > IF @level = 0 > SELECT @level = @level + 1 > > INSERT #stack > SELECT ID, @level + 1 FROM #y > SELECT * FROM #stack > END > > END -- WHILE > > DROP TABLE #stack > SELECT ID,Name,ThisLevel,Position FROM #x ORDER BY > Position,DateCreated > > > DROP TABLE #x > DROP TABLE #y > > > > > > -- > Original Message > From: "Hagan, Ryan Mr (Contractor > ACI)"<[EMAIL PROTECTED]> > Subject: RE: SQL syntax for Supertypes-Subtypes AKA > Circular Reference AKA > Entity Tree > Date: Wed, 27 Aug 2003 11:21:52 -0400 > > >I asked a very similar question a few weeks ago. > One solution was posted > by > >Jochem van Dieten: > > > >Use a nested set model, or use a 2 table model > where one table holds > >complete trees in an XMLData field (which you only > need to edit when a > >new element is inserted) and one holds individual > messages but with an > >FK to the table that holds the complete trees in > XML. > >I usually prefer the first solution, but in some > cases the latter > >solution allows you to offload the whole thing to > the client and let the > >client figure it out using XSLT. Something like: > >http://spike.oli.tudelft.nl/jochemd/test/tree/test.xml > > > > > >If you want more info, check out the archives. The > thread was: > > > >Re: recursion in cold fusion ( was RE: Creating a > list with infinite > >groupings and indents ) > > > > > >-Original Message- > >From: Blum, Jason
RE: Javascript Date Validation? Anyone know how to approach this?
function jm_checkDate(formObj){
if(/^(\d{2})\/\d{2}\/\d{4}$/.test(thisObj.value)){
var ProposedDate = new Date(formObj.value);
var Now = new Date();
if (ProposedDate > Now){
alert("The date you have entered is in the
future.");
formObj.focus();
return false;
}else{
return true;
}
}else{
alert("Incorrect Date Format.\nDate format should be
mm/dd/");
formObj.focus();
return false;
}
}
You could use either the ONSUBMIT or the ONBLUR depending on when you
want the check to take place.
This function is part of a larger library I wrote that scans all
formfields onsubmit, but in the rare case that I need it to be a
"stand-alone" function it works that way as well.
Thanks, hope this helps.
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-0801 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 12:28 PM
To: CF-Talk
Subject: Re: Javascript Date Validation? Anyone know how to approach
this?
on 8/27/03 12:15 PM, Craig Dudley at [EMAIL PROTECTED] wrote:
> For creating your date object from the 3 drop downs, try this
>
> New Date(year, month, day, hours, minutes, seconds, ms)
>
> Use the drop down values for year/month/day and zeros for the others,
> should give you a date object for your users selection.
>
> Simply calling 'New Date()' should create another date object with the
> current date and time.
>
> Date() objects are in ms since epoch (Jan 1 1970 ?) I believe, so make
> sure the 1st date object is one week of milliseconds greater than the
> current date.
>
> Any help??
Yikes...you know...I'm not even *sure* if that helps...lol...lemme
re-read it a couple times and get back to you.
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
ot - random sql select
SQL DECODED: Newid is just an internal MS SQL Server variable for the row; note that this code will work in v7, as well as 2000. "select top 10" means what it reads: Get only the first ten results of the query. This is a a useful clause for returning a query when you only want the top X results (for example, some weird join that will have massive dupes, but you only want the one record for the code's use blah blah). You can replace "10" with any positive integer >Not too sure to be honest... > >I found it from a site after I was using a stored procedure and a loop (not >the best code in the world) > >But basically (AFAIK) it says, get me the top 10 items from table foo and >order these by a random number. Thus if you call it again then the number >you are ordering is different, hence the random rows returned. > > >HTH > > > >-Original Message- >From: admin [mailto:[EMAIL PROTECTED] >Sent: Wednesday, August 27, 2003 10:02 >To: CF-Talk >Subject: Re: ot - random sql select > > >Thanks mike I'll give that a try - but out of interest what does that code >really mean ? - ok - so I'm an idiot in sql ! > >Cheers > >Richard > >- Original Message - >From: "Mike Townend" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, August 27, 2003 1:28 AM >Subject: RE: ot - random sql select > > >> If you are using SQLServer 2K (not sure if it works in 7) you could >> use >> >> SELECT TOP 10 * >> FROM Foo >> ORDER BY NewID() >> >> >> HTH >> >> >> >> -Original Message- >> From: admin [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, August 27, 2003 07:11 >> To: CF-Talk >> Subject: ot - random sql select >> >> >> is there an easy way to select say 10 records at random from an sql >> table >? >> >> > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: clustered processing?
> > Ask a vague question, get a vague answer. > > Several developers have been able to capture the essence of > my posting. Nevertheless, you'll be better served if you can more accurately formulate your questions. > I know a bit about "federated servers", but that's not > applicable here. Why do you say it's not applicable here? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: DWMX 2004 - Whats new for us?
On Wednesday, Aug 27, 2003, at 03:03 US/Pacific, dwayne wrote: > About 9 11 months ago I spent about 10 minutes of my time responding > to a macromedias ColdFusion survey and I have yet to see the results. I would think that Red Sky (CFMX 6.1) was the result, for the most part... > Would you all agree, that us ColdFusion developers deserve some love > too!! Considering Allaire (and ColdFusion) might have withered away without Macromedia's investment in the technology, I'd say that CFers got quite a bit of love... > Sure ColdFusion MX sports a bunch of new features that are fantastic > and the as for old advanced features theyre tighter than ever. I'm > loving cffunction, I'm all over cfc's, and ColdFusion's ability to > integrate with FLASH is the best thing since the last "best thing". Excellent! Glad you're happy with that at least (especially since quite a few CFers beat on Macromedia over the 'promotion' of Flash to CFers and the whole OO issues around CFCs). > However, despite all of these wonderful improvements in the server > application, I'm still not convinced that they have committed to > providing us with a solid "Development Environment" that supports the > work habits of the sophisticated ColdFusion Developer. I think part of the problem here is that your chosen IDE becomes your second-nature way of working and it's really hard to change. Several high-profile CFers have made the jump to Dreamweaver and are very happy - and some aren't. Dreamweaver is certainly a very different tool to HomeSite / CF Studio. However, CF Studio used to cost $499 and now you can get it (as HomeSite+) for just $399 by buying Dreamweaver. And there's a 5.5 version in the works so it's not like Macromedia's abandoned anyone here: http://www.macromedia.com/software/homesite/ Me personally, I tried CF Studio back in 2001 and just couldn't get along with it at all. I figured that since Macromedia bought Allaire and we'd be using ColdFusion, I ought to use the dedicated IDE. I really tried. But I kept going back to Dreamweaver for so many things. And it wasn't really anything specific that I could put my finger on and say "You know, if CFS just did 'X' (or didn't do 'Y' every time I try 'Z') then I'd be happy..." No, it was just a general usability issue for me - CF Studio just didn't suit me. So I switched back to Dreamweaver (well, UltraDev 4, actually). Then Dreamweaver MX came out and swallowed (the higher-priced) UltraDev and I was still a happy camper! The CFC and Web Service browsers are very useful (I showed how to use the latter to quickly build CF applications that consume Web Services in a BACFUG presentation a while back). Then I switched to a Mac. Dreamweaver MX (6.0) was not as good on the Mac as on Windows so I struggled for a while and switched to jEdit. It wasn't ideal for me... I found it clunky and ugly and the CF support wasn't great but it was faster and more stable than DWMX 6.0 on the Mac. Then the 6.1 updater came out and totally solidified the Mac version: it was much faster and rock solid. So I switched, gratefully, back to DWMX as my primary CF IDE. I can't talk about Dreamweaver MX 2004 much (for obvious reasons!) but I'm using a recent (internal) build and I'm very happy with it. Site-less editing has probably been the biggest help in my workflow as well as the new Start Page with its list of recently edited files and various common operations. > Dreamweaver still seems to be an overkill designers solutions. Hmm, I think depends on your perspective. I'm certainly not a designer - I'm a hardcore developer - but Dreamweaver fits my workflow just fine. I don't use all of its features but I use enough to make it worthwhile (e.g., I live and die in "sites" even tho' I find the new site-less editing mode very useful). > and as for Contribute, it must have been the boses, daughter's > boyfriend cousin's idea. I'm a huge advocate of Contribute for quick updates to static sites (and there's a lot of those). I use Contribute all the time to maintain project intranet sites as well as parts of my personal website. My wife uses Contribute to manage her website (which I set up in Dreamweaver) - my wife is fairly typical of the sort of users Contribute is aimed at. You might also be interested to know that sections of macromedia.com are managed using Contribute - end-user content contribution for HTML sites is its forte. Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Authorize.NET Custom Tag?
I use the one from Oleani Technologies and it works great. http://www.oleani.com/products.cfm?pid=2 I use this with CFMX and it was the only one that I could get to work. Clint - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 11:27 AM Subject: Re: Authorize.NET Custom Tag? > Jeff, > > If you find a good one, please let me know. About 4 months ago (before > Authorize.net changed the way you communicate with their system), I tried to > use them. It was a total nightmareI talked to 8 techs and a few > managersnone gave me the same story and nobody could tell me how to > reference the stuff they send back (i.e. approval codes etc.). They said > there were no variables and their "thing" they send back was a list of > key/value pairsbut it didn't have a name!!! Yeah rightso how to I > reference it I saidthey saidyou just do!!. > > Soif ya find a tag that works. ;-) > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: "Jeff Chastain" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 27, 2003 9:14 AM > Subject: Authorize.NET Custom Tag? > > > > I am putting together a shopping cart on very short notice for another > > developer and am looking for a way to communicate with Authorize.NET for > > payment processing. I am looking at the Macromedia Exchange and there are > > several different tags available. Has anybody worked with one in > particular > > that you could recommend? > > > > Thanks > > -- Jeff > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re:RE: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree
Here is a stored procedure I used for an old forum app. Should work for your situation. --DROP TABLE #stack --DROP TABLE #x --DROP TABLE #y --CREATE PROCEDURE expand (@current int) as DECLARE @current int DECLARE @level int, @line char(20) DECLARE @Pos int DECLARE @PrevReplyTo int CREATE TABLE #stack (item int, Thislevel int) CREATE TABLE #x (ID int, Name varchar(256), DateCreated datetime, InReplyTo int, Topic int, TotalReply int, Creator int, IsTop bit, Root int, TopDate datetime, _USER_ID int, MessageFrom varchar(256),ThisLevel int, Position int) CREATE TABLE #y (ID int, InReplyTo int, Root int) SET @current = 94 SET @Pos = 0 SET @PrevReplyTo = @current INSERT #y SELECT ID,InReplyTo, Root FROM Threads WHERE Root = @current ORDER BY DateCreated DESC INSERT #x SELECT Threads.ID AS "ID", Threads.Name AS "Name", Threads.DateCreated AS "DateCreated", Threads.InReplyTo AS "InReplyTo", Threads.Topic AS "Topic", Threads.TotalReply AS "TotalReply", Threads.Creator AS "Creator", Threads.IsTop AS "IsTop", Threads.Root AS "Root", Threads.TopDate AS "TopDate", Users.ID AS "_USER_ID", Users.Userid AS "MessageFrom", 0, 0 FROM Threads,Users WHERE Threads.Root = @current AND Threads.Creator = Users.ID SET NOCOUNT ON INSERT INTO #stack VALUES (@current, 1) SELECT @level = 1 WHILE @level > 0 BEGIN IF EXISTS (SELECT * FROM #stack WHERE Thislevel = @level) BEGIN -- If an item on the stack exists at this level, grab it SELECT @current = item FROM #stack WHERE Thislevel = @level -- Increment the position SET @Pos = @Pos + 1 -- Update the table with the new position UPDATE #x SET Position = @Pos, ThisLevel = @level - 1 WHERE ID = @current -- Delete this entry from the temp table (#y) DELETE FROM #y WHERE ID = @current -- Delete this entry from the stack DELETE FROM #stack WHERE Thislevel = @level AND item = @current -- Insert into the stack any IDs that are replies to the CURRENT ID INSERT #stack SELECT ID, @level + 1 FROM #y WHERE InReplyTo = @current -- If any were found, increment the level IF @@ROWCOUNT > 0 SELECT @level = @level + 1 END ELSE SELECT @level = @level - 1 IF ((SELECT COUNT(*) FROM #y) > 0 AND (SELECT COUNT(*) FROM #stack) = 0) BEGIN IF @level = 0 SELECT @level = @level + 1 INSERT #stack SELECT ID, @level + 1 FROM #y SELECT * FROM #stack END END -- WHILE DROP TABLE #stack SELECT ID,Name,ThisLevel,Position FROM #x ORDER BY Position,DateCreated DROP TABLE #x DROP TABLE #y -- Original Message From: "Hagan, Ryan Mr (Contractor ACI)"<[EMAIL PROTECTED]> Subject: RE: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree Date: Wed, 27 Aug 2003 11:21:52 -0400 >I asked a very similar question a few weeks ago. One solution was posted by >Jochem van Dieten: > >Use a nested set model, or use a 2 table model where one table holds >complete trees in an XMLData field (which you only need to edit when a >new element is inserted) and one holds individual messages but with an >FK to the table that holds the complete trees in XML. >I usually prefer the first solution, but in some cases the latter >solution allows you to offload the whole thing to the client and let the >client figure it out using XSLT. Something like: >http://spike.oli.tudelft.nl/jochemd/test/tree/test.xml > > >If you want more info, check out the archives. The thread was: > >Re: recursion in cold fusion ( was RE: Creating a list with infinite >groupings and indents ) > > >-Original Message- >From: Blum, Jason (SAA) [mailto:[EMAIL PROTECTED] >Sent: Wednesday, August 27, 2003 11:13 AM >To: CF-Talk >Subject: SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA >Entity Tree > > >Hello, > >Here's a puzzle for all you 'Joe Celko' types: > >Am trying to figure out how to do on SQL Server something I can do in >Oracle. I think this problem is variously known as Subtypes-Supertypes, >Circular Reference, Entity Tree, etc... > >Given this data: > >Columns: iEntityID, iSubEntityOf, sName >1 1 Mary >2 2 1 Fritz >3 3 1 John >4 4 2 Abu >5 5 2 Ludwig >6 6 3 Abigail >7 7 3 Josef >8 8 6 Mark >9 9 6 Ben >10 10 6 Habib >11 11 9 Paul >12 12 11 Mahatma > >I want to graphically re
Re: ot - random sql select
Try this: SELECT TOP 10 * FROM TABLE ORDER BY NEWID() -Novak - Original Message - From: "admin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, August 26, 2003 11:10 PM Subject: ot - random sql select > is there an easy way to select say 10 records at random from an sql table ? > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Javascript Date Validation? Anyone know how to approach this?
on 8/27/03 12:15 PM, Craig Dudley at [EMAIL PROTECTED] wrote: > For creating your date object from the 3 drop downs, try this > > New Date(year, month, day, hours, minutes, seconds, ms) > > Use the drop down values for year/month/day and zeros for the others, > should give you a date object for your users selection. > > Simply calling 'New Date()' should create another date object with the > current date and time. > > Date() objects are in ms since epoch (Jan 1 1970 ?) I believe, so make > sure the 1st date object is one week of milliseconds greater than the > current date. > > Any help?? Yikes...you know...I'm not even *sure* if that helps...lol...lemme re-read it a couple times and get back to you. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Authorize.NET Custom Tag?
Jeff, If you find a good one, please let me know. About 4 months ago (before Authorize.net changed the way you communicate with their system), I tried to use them. It was a total nightmareI talked to 8 techs and a few managersnone gave me the same story and nobody could tell me how to reference the stuff they send back (i.e. approval codes etc.). They said there were no variables and their "thing" they send back was a list of key/value pairsbut it didn't have a name!!! Yeah rightso how to I reference it I saidthey saidyou just do!!. Soif ya find a tag that works. ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Jeff Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 9:14 AM Subject: Authorize.NET Custom Tag? > I am putting together a shopping cart on very short notice for another > developer and am looking for a way to communicate with Authorize.NET for > payment processing. I am looking at the Macromedia Exchange and there are > several different tags available. Has anybody worked with one in particular > that you could recommend? > > Thanks > -- Jeff > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: RE: CF in XSL, passing variables
That is not always my opinion. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 12:16 PM To: CF-Talk Subject: Re: RE: CF in XSL, passing variables Shh, it's open source and written in Java, therefore it must be good :) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: clustered processing?
Absolutely! ...although I'm still an advocate of the multi-thread as well. I've come across a number of instances where it would have been handy. Mostly relating to reporting off multiple datasources. Stace -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 11:39 AM To: CF-Talk Subject: Re: clustered processing? I thought about this and I don't think CFers really need or want the ability to do full-blown multi-threading. However, I do think many CFers would benefit from a tag that delays the processing of a block of CFML until after the request is complete. For example the following... Would anyone be interested in a tag like the above? -Matt On Wednesday, August 27, 2003, at 11:24 AM, Stacy Young wrote: > I had made an enhancement request along these lines for next CF > release...It could very well be a bad idea, I don't know. Essentially a > tag to spawn multiple threads from single request; > > > > <-- do stuff --> > > > <-- do stuff --> > > > <-- do stuff --> > > > > In the CF admin have the ability to set overall limit on threads as > well > as a maximum for a single request. > > Would this have merit? > > Stace > > > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 26, 2003 11:19 PM > To: CF-Talk > Subject: Re: clustered processing? > > What you are interested in would probably fit better with a > multi-threaded model than distributed computing. Do you example with > multi-threading would be as follows: > > 1. Create a process to manage the threads > 2. Split up the work into chunks and assign individual threads to work > on each chunk > 3. Gather up the results of the thread > > Could you do this with CF? It would be a serious hack, but yeah, it > could be done. Although, it would be fire easier to do this with Java. > Possibly, a mixture of CF and Java would work best in your case. > > -Matt > > On Tuesday, August 26, 2003, at 10:30 PM, Chunshen (Don) Li wrote: > >> "In CF? Could be done at a certain level." >> I would appreciate it if you could elaborate it a bit further. To >> validate your point. >> >> The goal of [EMAIL PROTECTED] is totally different from what I'd like to >> achieve with the subject matter. You were talking about sort of >> similar method. Distributed computing, parallel computing is way ahead > >> of 'clustered processing'. >> >> DL >> >>> It's called distributed computing. A popular layman's example would >>> be [EMAIL PROTECTED] Do a google search. >>> >>> In CF? Could be done at a certain level. >>> > > > AVIS IMPORTANT: > --- > Les informations contenues dans le present document et ses pieces > jointes sont strictement confidentielles et reservees a l'usage de la > (des) personne(s) a qui il est adresse. Si vous n'etes pas le > destinataire, soyez avise que toute divulgation, distribution, copie, > ou autre utilisation de ces informations est strictement prohibee. Si > vous avez recu ce document par erreur, veuillez s'il vous plait > communiquer immediatement avec l'expediteur et detruire ce document > sans en faire de copie sous quelque forme. > > WARNING: > --- > The information contained in this document and attachments is > confidential and intended only for the person(s) named above. If you > are not the intended recipient you are hereby notified that any > disclosure, copying, distribution, or any other use of the information > is strictly prohibited. If you have received this document by mistake, > please notify the sender immediately and destroy this document and > attachments without making any copy of any kind. > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: RE: CF in XSL, passing variables
Shh, it's open source and written in Java, therefore it must be good :) - Original Message - From: "Bryan F. Hogan" <[EMAIL PROTECTED]> Date: Wednesday, August 27, 2003 9:26 am Subject: RE: CF in XSL, passing variables > Yep, :) > > -Original Message- > From: Matt Liotta [EMAIL PROTECTED] > Sent: Tuesday, August 26, 2003 11:28 PM > To: CF-Talk > Subject: Re: CF in XSL, passing variables > > > The true irony here is that Apache Xalan has significantly more > proprietary extensions to the XSLT specification than MSXML does. > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.MontaraSoftware.com > (888) 408-0900 x901 > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Javascript Date Validation? Anyone know how to approach this?
For creating your date object from the 3 drop downs, try this New Date(year, month, day, hours, minutes, seconds, ms) Use the drop down values for year/month/day and zeros for the others, should give you a date object for your users selection. Simply calling 'New Date()' should create another date object with the current date and time. Date() objects are in ms since epoch (Jan 1 1970 ?) I believe, so make sure the 1st date object is one week of milliseconds greater than the current date. Any help?? -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: 27 August 2003 17:06 To: CF-Talk Subject: OT: Javascript Date Validation? Anyone know how to approach this? Okay, I know I know, this is off topic, but I've been banging my head about this one, and I'm SURE it's probably stupid simple, but I'm just not good with dates (insert nerd joke here). Here's a simple form. Three select dropdowns. There's other validation going on, and other stuff happening, but I just snipped it all and kept the relevant portion to focus on. Now, here's what I need it to do. When a user selects a date, I just need to check (onChange, for each select) to make sure that the date they selected is AT LEAST 7 days in advance. So let's say I choose tomorrow and submit...I want an alert that says, "you need to choose a date that's at least 7 days in advance". I think the problem I'm running into is somehow how to concatenate the three date selects into a "date" object, then compare it to "now", but for some reason I'm just totally brain farting how to accomplish this. Once again, I'm sorry for the off-topic-ness of this post, but I don't really have any good javascript recources that have as good a feedback as this one... Here's the snippet of form: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 2003 2004 2005 2006 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Authorize.NET Custom Tag?
I am putting together a shopping cart on very short notice for another developer and am looking for a way to communicate with Authorize.NET for payment processing. I am looking at the Macromedia Exchange and there are several different tags available. Has anybody worked with one in particular that you could recommend? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: clustered processing?
cfflush does not do the same thing at all as it just flushes the response buffer, but doesn't actual complete the request. Therefore, the request will not finish processing until after all the code has executed. Semantically you could argue that to the end user there is no difference. However, I believe if this tag were implemented request threads would receive priority and thus performance differences would emerge with the right amount of load. -Matt On Wednesday, August 27, 2003, at 11:59 AM, webguy wrote: > If you add a cfflush after your code, will that do the same thing? I've > never checked it out in cfmx... > > > > > > > WG > > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED] > Sent: 27 August 2003 16:39 > To: CF-Talk > Subject: Re: clustered processing? > > > I thought about this and I don't think CFers really need or want the > ability to do full-blown multi-threading. However, I do think many > CFers would benefit from a tag that delays the processing of a block of > CFML until after the request is complete. For example the following... > > > > > > > > Would anyone be interested in a tag like the above? > > -Matt > > On Wednesday, August 27, 2003, at 11:24 AM, Stacy Young wrote: > >> I had made an enhancement request along these lines for next CF >> release...It could very well be a bad idea, I don't know. Essentially >> a >> tag to spawn multiple threads from single request; >> >> >> >> <-- do stuff --> >> >> >> <-- do stuff --> >> >> >> <-- do stuff --> >> >> >> >> In the CF admin have the ability to set overall limit on threads as >> well >> as a maximum for a single request. >> >> Would this have merit? >> >> Stace >> >> >> -Original Message- >> From: Matt Liotta [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, August 26, 2003 11:19 PM >> To: CF-Talk >> Subject: Re: clustered processing? >> >> What you are interested in would probably fit better with a >> multi-threaded model than distributed computing. Do you example with >> multi-threading would be as follows: >> >> 1. Create a process to manage the threads >> 2. Split up the work into chunks and assign individual threads to work >> on each chunk >> 3. Gather up the results of the thread >> >> Could you do this with CF? It would be a serious hack, but yeah, it >> could be done. Although, it would be fire easier to do this with Java. >> Possibly, a mixture of CF and Java would work best in your case. >> >> -Matt >> >> On Tuesday, August 26, 2003, at 10:30 PM, Chunshen (Don) Li wrote: >> >>> "In CF? Could be done at a certain level." >>> I would appreciate it if you could elaborate it a bit further. To >>> validate your point. >>> >>> The goal of [EMAIL PROTECTED] is totally different from what I'd like to >>> achieve with the subject matter. You were talking about sort of >>> similar method. Distributed computing, parallel computing is way >>> ahead >> >>> of 'clustered processing'. >>> >>> DL >>> It's called distributed computing. A popular layman's example would be [EMAIL PROTECTED] Do a google search. In CF? Could be done at a certain level. >> >> >> AVIS IMPORTANT: >> --- >> Les informations contenues dans le present document et ses pieces >> jointes sont strictement confidentielles et reservees a l'usage de la >> (des) personne(s) a qui il est adresse. Si vous n'etes pas le >> destinataire, soyez avise que toute divulgation, distribution, copie, >> ou autre utilisation de ces informations est strictement prohibee. Si >> vous avez recu ce document par erreur, veuillez s'il vous plait >> communiquer immediatement avec l'expediteur et detruire ce document >> sans en faire de copie sous quelque forme. >> >> WARNING: >> --- >> The information contained in this document and attachments is >> confidential and intended only for the person(s) named above. If you >> are not the intended recipient you are hereby notified that any >> disclosure, copying, distribution, or any other use of the information >> is strictly prohibited. If you have received this document by mistake, >> please notify the sender immediately and destroy this document and >> attachments without making any copy of any kind. >> >> > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
No more data available to read.
Since the list is working well today, thought I'd bring this question back up. I get the below message periodically emailed to me from the log files. There is no event log information. Also when I check the page the supposedly has the error, the problem is not re-creatable. Anyone have any ideas. [Macromedia][SQLServer JDBC Driver]No more data available to read. I know that this was a problem pre updater 3 with the Oracle driver with blobs, but this is not my case. I'm running CFMX 6.1 SQL 2000 Updater 2, IIS 5, Windows 2000 Server. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: clustered processing?
The tag I suggested will not allow you to do that since it the code contained in it would be executed after request is served. -Matt On Wednesday, August 27, 2003, at 11:58 AM, Tyler Clendenin wrote: > Would I ever. That tag would make my life so much easier. I cannot > tell > you the number of times I have wanted to run two loops at the same time > setting variables but set a wait point afterwards to allow either to > catch > up before processing. > > Tyler Clendenin > GSL Solutions > > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 10:39 AM > To: CF-Talk > Subject: Re: clustered processing? > > I thought about this and I don't think CFers really need or want the > ability > to do full-blown multi-threading. However, I do think many CFers would > benefit from a tag that delays the processing of a block of CFML until > after > the request is complete. For example the following... > > > > > > > > Would anyone be interested in a tag like the above? > > -Matt > > On Wednesday, August 27, 2003, at 11:24 AM, Stacy Young wrote: > >> I had made an enhancement request along these lines for next CF >> release...It could very well be a bad idea, I don't know. Essentially >> a tag to spawn multiple threads from single request; >> >> >> >> <-- do stuff --> >> >> >> <-- do stuff --> >> >> >> <-- do stuff --> >> >> >> >> In the CF admin have the ability to set overall limit on threads as >> well as a maximum for a single request. >> >> Would this have merit? >> >> Stace >> >> >> -Original Message- >> From: Matt Liotta [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, August 26, 2003 11:19 PM >> To: CF-Talk >> Subject: Re: clustered processing? >> >> What you are interested in would probably fit better with a >> multi-threaded model than distributed computing. Do you example with >> multi-threading would be as follows: >> >> 1. Create a process to manage the threads 2. Split up the work into >> chunks and assign individual threads to work on each chunk 3. Gather >> up the results of the thread >> >> Could you do this with CF? It would be a serious hack, but yeah, it >> could be done. Although, it would be fire easier to do this with Java. >> Possibly, a mixture of CF and Java would work best in your case. >> >> -Matt >> >> On Tuesday, August 26, 2003, at 10:30 PM, Chunshen (Don) Li wrote: >> >>> "In CF? Could be done at a certain level." >>> I would appreciate it if you could elaborate it a bit further. To >>> validate your point. >>> >>> The goal of [EMAIL PROTECTED] is totally different from what I'd like to >>> achieve with the subject matter. You were talking about sort of >>> similar method. Distributed computing, parallel computing is way >>> ahead >> >>> of 'clustered processing'. >>> >>> DL >>> It's called distributed computing. A popular layman's example would be [EMAIL PROTECTED] Do a google search. In CF? Could be done at a certain level. >> >> >> AVIS IMPORTANT: >> --- >> Les informations contenues dans le present document et ses pieces >> jointes sont strictement confidentielles et reservees a l'usage de la >> (des) personne(s) a qui il est adresse. Si vous n'etes pas le >> destinataire, soyez avise que toute divulgation, distribution, copie, >> ou autre utilisation de ces informations est strictement prohibee. Si >> vous avez recu ce document par erreur, veuillez s'il vous plait >> communiquer immediatement avec l'expediteur et detruire ce document >> sans en faire de copie sous quelque forme. >> >> WARNING: >> --- >> The information contained in this document and attachments is >> confidential and intended only for the person(s) named above. If you >> are not the intended recipient you are hereby notified that any >> disclosure, copying, distribution, or any other use of the information >> is strictly prohibited. If you have received this document by mistake, >> please notify the sender immediately and destroy this document and >> attachments without making any copy of any kind. >> >> > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
OT: Javascript Date Validation? Anyone know how to approach this?
Okay, I know I know, this is off topic, but I've been banging my head about this one, and I'm SURE it's probably stupid simple, but I'm just not good with dates (insert nerd joke here). Here's a simple form. Three select dropdowns. There's other validation going on, and other stuff happening, but I just snipped it all and kept the relevant portion to focus on. Now, here's what I need it to do. When a user selects a date, I just need to check (onChange, for each select) to make sure that the date they selected is AT LEAST 7 days in advance. So let's say I choose tomorrow and submit...I want an alert that says, "you need to choose a date that's at least 7 days in advance". I think the problem I'm running into is somehow how to concatenate the three date selects into a "date" object, then compare it to "now", but for some reason I'm just totally brain farting how to accomplish this. Once again, I'm sorry for the off-topic-ness of this post, but I don't really have any good javascript recources that have as good a feedback as this one... Here's the snippet of form: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 2003 2004 2005 2006 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: clustered processing?
If you add a cfflush after your code, will that do the same thing? I've never checked it out in cfmx... WG -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 27 August 2003 16:39 To: CF-Talk Subject: Re: clustered processing? I thought about this and I don't think CFers really need or want the ability to do full-blown multi-threading. However, I do think many CFers would benefit from a tag that delays the processing of a block of CFML until after the request is complete. For example the following... Would anyone be interested in a tag like the above? -Matt On Wednesday, August 27, 2003, at 11:24 AM, Stacy Young wrote: > I had made an enhancement request along these lines for next CF > release...It could very well be a bad idea, I don't know. Essentially a > tag to spawn multiple threads from single request; > > > > <-- do stuff --> > > > <-- do stuff --> > > > <-- do stuff --> > > > > In the CF admin have the ability to set overall limit on threads as > well > as a maximum for a single request. > > Would this have merit? > > Stace > > > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 26, 2003 11:19 PM > To: CF-Talk > Subject: Re: clustered processing? > > What you are interested in would probably fit better with a > multi-threaded model than distributed computing. Do you example with > multi-threading would be as follows: > > 1. Create a process to manage the threads > 2. Split up the work into chunks and assign individual threads to work > on each chunk > 3. Gather up the results of the thread > > Could you do this with CF? It would be a serious hack, but yeah, it > could be done. Although, it would be fire easier to do this with Java. > Possibly, a mixture of CF and Java would work best in your case. > > -Matt > > On Tuesday, August 26, 2003, at 10:30 PM, Chunshen (Don) Li wrote: > >> "In CF? Could be done at a certain level." >> I would appreciate it if you could elaborate it a bit further. To >> validate your point. >> >> The goal of [EMAIL PROTECTED] is totally different from what I'd like to >> achieve with the subject matter. You were talking about sort of >> similar method. Distributed computing, parallel computing is way ahead > >> of 'clustered processing'. >> >> DL >> >>> It's called distributed computing. A popular layman's example would >>> be [EMAIL PROTECTED] Do a google search. >>> >>> In CF? Could be done at a certain level. >>> > > > AVIS IMPORTANT: > --- > Les informations contenues dans le present document et ses pieces > jointes sont strictement confidentielles et reservees a l'usage de la > (des) personne(s) a qui il est adresse. Si vous n'etes pas le > destinataire, soyez avise que toute divulgation, distribution, copie, > ou autre utilisation de ces informations est strictement prohibee. Si > vous avez recu ce document par erreur, veuillez s'il vous plait > communiquer immediatement avec l'expediteur et detruire ce document > sans en faire de copie sous quelque forme. > > WARNING: > --- > The information contained in this document and attachments is > confidential and intended only for the person(s) named above. If you > are not the intended recipient you are hereby notified that any > disclosure, copying, distribution, or any other use of the information > is strictly prohibited. If you have received this document by mistake, > please notify the sender immediately and destroy this document and > attachments without making any copy of any kind. > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Query to List
There are two ways you can do this. There is a function names ValueList() I am not sure what the syntax is. Or you can do what I do and just access the query as an array. You do not need to set and array bwecause the query already acts as one. Ex. Your query is named MyQuery and you want to show all of the MyColumn in each row seperated by columns. #ArrayToList(MyQuery["MyColumn"], ", ")# Simple as that, as far as I know the ValueList function is a shortcut for that but I don't think it allows you to specify the delimeter and I like that sort of control. Tyler Clendenin GSL Solutions -Original Message- From: G-matcomkc [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:41 AM To: CF-Talk Subject: Query to List In the CF docs, I saw some code that converted a query result into a list. They did it by looping over the query, appending the values to an array, and then applying the "ArrayToList" function to the resulting array. Is this the accepted, most efficient process for doing this type of conversion? Or am I missing an obvious short cut? TIA, Brian ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Query to List
Did you check out valuelist(query.column) - Original Message - From: "G-matcomkc" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 5:41 PM Subject: Query to List > In the CF docs, I saw some code that converted a query result into a list. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: clustered processing?
Would I ever. That tag would make my life so much easier. I cannot tell you the number of times I have wanted to run two loops at the same time setting variables but set a wait point afterwards to allow either to catch up before processing. Tyler Clendenin GSL Solutions -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:39 AM To: CF-Talk Subject: Re: clustered processing? I thought about this and I don't think CFers really need or want the ability to do full-blown multi-threading. However, I do think many CFers would benefit from a tag that delays the processing of a block of CFML until after the request is complete. For example the following... Would anyone be interested in a tag like the above? -Matt On Wednesday, August 27, 2003, at 11:24 AM, Stacy Young wrote: > I had made an enhancement request along these lines for next CF > release...It could very well be a bad idea, I don't know. Essentially > a tag to spawn multiple threads from single request; > > > > <-- do stuff --> > > > <-- do stuff --> > > > <-- do stuff --> > > > > In the CF admin have the ability to set overall limit on threads as > well as a maximum for a single request. > > Would this have merit? > > Stace > > > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 26, 2003 11:19 PM > To: CF-Talk > Subject: Re: clustered processing? > > What you are interested in would probably fit better with a > multi-threaded model than distributed computing. Do you example with > multi-threading would be as follows: > > 1. Create a process to manage the threads 2. Split up the work into > chunks and assign individual threads to work on each chunk 3. Gather > up the results of the thread > > Could you do this with CF? It would be a serious hack, but yeah, it > could be done. Although, it would be fire easier to do this with Java. > Possibly, a mixture of CF and Java would work best in your case. > > -Matt > > On Tuesday, August 26, 2003, at 10:30 PM, Chunshen (Don) Li wrote: > >> "In CF? Could be done at a certain level." >> I would appreciate it if you could elaborate it a bit further. To >> validate your point. >> >> The goal of [EMAIL PROTECTED] is totally different from what I'd like to >> achieve with the subject matter. You were talking about sort of >> similar method. Distributed computing, parallel computing is way >> ahead > >> of 'clustered processing'. >> >> DL >> >>> It's called distributed computing. A popular layman's example would >>> be [EMAIL PROTECTED] Do a google search. >>> >>> In CF? Could be done at a certain level. >>> > > > AVIS IMPORTANT: > --- > Les informations contenues dans le present document et ses pieces > jointes sont strictement confidentielles et reservees a l'usage de la > (des) personne(s) a qui il est adresse. Si vous n'etes pas le > destinataire, soyez avise que toute divulgation, distribution, copie, > ou autre utilisation de ces informations est strictement prohibee. Si > vous avez recu ce document par erreur, veuillez s'il vous plait > communiquer immediatement avec l'expediteur et detruire ce document > sans en faire de copie sous quelque forme. > > WARNING: > --- > The information contained in this document and attachments is > confidential and intended only for the person(s) named above. If you > are not the intended recipient you are hereby notified that any > disclosure, copying, distribution, or any other use of the information > is strictly prohibited. If you have received this document by mistake, > please notify the sender immediately and destroy this document and > attachments without making any copy of any kind. > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Query to List
> Is this the accepted, most efficient process for doing this > type of conversion? Or am I missing an obvious short cut? Check out the valuelist() function. Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
