RE: IIS Domain Naming Question
Does anyone have information to point me in the right direction figuring out how to create a domain name similar to: foo.bar.domain.com in IIS? I can't seem to find this anywhere. Does this require some special setup for DNS as well? This is purely a DNS issue. Your DNS administrator would need to create a subdomain, bar.domain.com, and then would need to create a host record (A or CNAME) for foo within the subdomain. Once that's done, you can just configure an IIS virtual server to listen on the IP address specified in the host record, and if you want to require host headers, you'd just specify the string foo.bar.domain.com in the IIS management console. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Fusebox 4 / Mach-II conference
On Wednesday, Jul 30, 2003, at 19:10 US/Pacific, Sandy Clark wrote: Stan is coming to the Fusebox conference! Michael let me sneak a look at the signup list and his name was on there. I'm halfway to signing up... I've negotiated time away from home with my wife and I've asked my boss for budget to fly / stay / attend! 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/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Content Management Systems - a short list...
Wish I could say that I'm not a sales person... :) Well that's not true -- I say that all the time, just not in this context. :) I am however a developer. DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases (This is not how the existing system works). Tapestry does work this way. It allows dynamic content when desirable or necessary, i.e. rotating banners, etc. but it writes the rest of the content to file which eliminates all that overhead of grautitous runtime page assembly (GRUPA - not my term)... I'm working on versioning currently as well as Oracle support -- hopefully it will work on both SQL Server and Oracle with largely the same codebase soon (excepting stored procedures of course)... Permissions and worlfklow have been written. The workflow component needs updating to be compatible with the new version I'm releasing hopefully soon, the big upgrade that broke it being managing multiple content languages. Easy to use for the users is something you'd have to judge for yourself -- the interface is designed specifically for the purpose of being customized, so how easy it is for the users probably has a lot to do with what kind of forms you give them to enter their content. It does use the soEditor wysiwyg html editing tool by default. Works on CF5... As to db maintenance available outside of system are you talking about backing up the db or editing records in the tables? ... backing up isn't an issue (outside of the fact that it writes a lot of stuff to file, so if you restore a backup you may have to do a bit of work to synch up those files). Editing records outside of the system is another story -- I wouldn't recommend it. Installs in about 5 minutes without a single line of programming, though relatively easy to get up and running will of course depend on what kind of content you need to manage -- you have to build the forms for your users to manage that content. It's OO which helps make it a little easier if you know how to write good methods. And I'd like to think it's easy to customize -- especially thanks to the add/remove components wizard... Anyway... I hope that answers most of your questions without seeming like an overt sales pitch. :) Let me know if you'd like to see a demo. s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi team macromedia volunteer http://www.macromedia.com/go/team certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 I would be interested in hearing opinions on some good CF-based CMSs. I need to develop a short list so that I can evaluate a few systems. If you could pick one... which one? And why? Any experience with one system or another? We have a CMS here, which is the biggest piece of... well, let's just say that I may finally win the battle that this system needs a replacement. I would upgrade the existing system, but I think that will take too many man hours to fix the flaws in the system and... right now, I am a one-man development team. Here are my requirements: Permissions Workflow Images and documents stored in Database, but are published to website. Static pages that can be stored in Database - allow versioning. DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases (This is not how the existing system works). Oracle 8i/9i - DB maintenance available OUTSIDE of system (Isn't this an issue with NQCONTENT?) CF5 preferred; CFMX Enterprise possible (we'd have to upgrade; there may be COM object issues if we do) EASY TO USE for the USERS!!! (CMS users have to be able to use the admin, not fight with it every time they want to do something.) Uses stylesheets I should be able to make CMS and site interface changes, if needed. Simple URLs! - e.g. http://www.easynavigate.com/section/page.cfm (our current CMS does not do this and that is the single biggest complaint from the executives) RELATIVELY EASY TO GET UP AND RUNNING Relatively easy to customize, if necessary I can elaborate more if needed. Here are a list of CF-based systems that I know of... Ektron - CMS 100/200/300 eMPower (I am not sure what the differences are between CMS 300 and eMPower - I didn't find that very clear from their website) PaperThin - Common Spot Server NetQuest - NQContent Systems Alliance - Site Executive FarCry - Open Source - inspired by Spectra (CFMX based - more of a framework than a finished system?) Spectra - Allaire/Macromedia, now Open Source (framework) Oasis - RemoteSite Technologies (I couldn't get to their site) SparkPlug - 13amp.com There may be others I don't know of... Are there any open source CMSs that are CF-based that are ready to go, out of the box? For something like FarCry, how quickly can it be configured so that
Re: OT: IIS Domain Naming Question
Hi Joshua, Setting up fully-qualified domain names and subdomains is a function of DNS exclusively, not IIS. Are you running your own DNS server? If not, and you need more help, what is the actual domain name? Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com Joshua Miller wrote: Totally off-topic, I apologize. Does anyone have information to point me in the right direction figuring out how to create a domain name similar to: foo.bar.domain.com in IIS ? I can't seem to find this anywhere. Does this require some special setup for DNS as well? Thanks, sorry for the OT post. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RE: re: Mach-II
Sheesh... what's next? Probably some guy somewhere saying something silly like cooking is a lot like programming. U... nevermind. -Novak ;-) - Original Message - From: Hal Helms [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:35 PM Subject: RE: RE: re: Mach-II Yeah, yeah, I've heard of this Fusebox framework. I've even used it once or twice. I just don't get what the big deal is, though. Sure it helps you separate logic and presentation, it helps teams work together, it provides encapsulation, etc, etc. But is that really sufficient grounds for liking something - that it helps people? What's next? Shall we adopt something simply because it works? Where would great corporations like Microsoft or Oracle be if they adopted that attitude? You sound too much like that guy in CFDJ who sounds like freakin' Oprah with his talk about empowering people and supporting developers. Give me something manlier than that! And as for documentation, which you note as a strength of Fusebox, well, all I can do is quote a greater man than I who said: It was hard to write. It should be hard to understand. Hal Helms Java for CF Programmers class in Las Vegas, August 18-22 www.halhelms.com -Original Message- From: Angus McFee [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 5:09 PM To: CF-Talk Subject: RE: RE: re: Mach-II Matt - Good to hear from a fellow fuseboxer! No, this isn't a joke, this guy clearly has a problem with what fusebox has become and has made this other framework that clearly doesn't do most of what Fusebox is capable of. I don' t think him having helped make fusebox or having been in a few books makes a huge difference. My dog has been in a few books, that doesn't mean he don't hate cats. But this really sounds like he is dissing fusebox. Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. These things aren't new and they don't do something you can't do with fusebox already. Fusebox already works in ColdFusion, PHP, ASP, JSP and Perl, and I have even seen a TCL port for the framework. In PHP, you can do all the object oriented programming you want, so I don't see why there would be a need for this mach-ii except to take away from fusebox. This guy is just one of the ones who is never going to get what it is all about. Angus McFee -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:37 PM To: CF-Talk Subject: Re: Mach-II This is a joke right? -Matt On Wednesday, July 30, 2003, at 04:08 PM, Angus McFee wrote: Hal - I've heard from plenty of people looking for a way to beat up on Fusebox, but usually they have nothing to say when it comes to building a better framework. This is the first time in a long time anyone has suggested an alternative approach, and I really don't see how any of this benefits developers. This mach-ii stuff looks like just another petty attack on Fusebox. It's pretty clear we see things differently when it comes to building Web applications. I don't know you, but I can tell you are a pretty intelligent person, so you probably have some good reasons for why you don't like or hate fusebox. What I have to ask you is: do you use fusebox? Becuase there are plenty of people who are ready to attack it anytime and don't even know ColdFusion, much less what a framework is. You will probably never be convinced about the benefits of fusebox, all I can do is disagree with you, and point out all the great things fusebox does for developers: * it separates business logic from presentation logic, making for more organized, efficent code * it gives developers a common set of rules and methods to work from, so that everyone can understand what the other people are doing on a project regardless of the size of a team * it modularizes and encapsulates code, making it easier to reuse and thus to maintain * it is self-documenting, containing a complete, inline XML standard for documenting your applications * most importantly, there are thousands and thousands of fusebox developers out there, and more and more shops are choosing to use it every day. it is close to becoming a de-facto standard, which I doubt your mach-ii 'framework' will ever be able to match Angus McFee -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:16 PM To: CF-Talk Subject: RE: RE: re: Mach-II You're right, Dave. We're not looking to be able to incorporate Fusebox 3 (or 4) with Mach-II. We think that Fusebox is a great framework for procedural programmers. (Please, God, don't let this degenerate into yet another
Auto generate form fields problem...
Hi, I am trying to auto generate form fields and can't seem to get the last part right. I want to set the value of the input box as the variable but can't figure out how to do it... Obviously what happens is the value is set to call_letters_1 instead what I want which is #call_letters_1# I have tried a bunch of different things none of which work and just throw errors. Any ideas??? Thanks! cfset i = 1 cfloop index=param from=1 to=100 cfparam name=call_letters_#i# default= cfset i = i + 1 /cfloop table border=0 cellspacing=0 cellpadding=0 cfoutput cfset i = 1 cfloop index=call from=1 to=30 tr tdstrong#i#./strong/td tdinput type=text name=call_letters_#i# value=call_letters_#i# size=15/td /tr cfset i = i +1 /cfloop /cfoutput /table -- Bruce H. Beinert p.808-637-0727m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Auto generate form fields problem...
I believe this may work, as I do somethink simular with parsing through dynamic Form variables. tdinput type=text name=call_letters_#i# value=#evaluate(call_letters_ i)# size=15/td Jason Lees Development Team Leader National Express. -Original Message- From: Bruce H. Beinert [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 08:52 To: CF-Talk Subject: Auto generate form fields problem... Hi, I am trying to auto generate form fields and can't seem to get the last part right. I want to set the value of the input box as the variable but can't figure out how to do it... Obviously what happens is the value is set to call_letters_1 instead what I want which is #call_letters_1# I have tried a bunch of different things none of which work and just throw errors. Any ideas??? Thanks! cfset i = 1 cfloop index=param from=1 to=100 cfparam name=call_letters_#i# default= cfset i = i + 1 /cfloop table border=0 cellspacing=0 cellpadding=0 cfoutput cfset i = 1 cfloop index=call from=1 to=30 tr tdstrong#i#./strong/td tdinput type=text name=call_letters_#i# value=call_letters_#i# size=15/td /tr cfset i = i +1 /cfloop /cfoutput /table -- Bruce H. Beinert p.808-637-0727m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Auto generate form fields problem...
That works, too easy... I could swear when I tried it earlier tonite it through an error although I think I put # signs around the i Thanks!!! -- Bruce H. Beinert p.808-637-0727m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:07 PM To: CF-Talk Subject: RE: Auto generate form fields problem... I believe this may work, as I do somethink simular with parsing through dynamic Form variables. tdinput type=text name=call_letters_#i# value=#evaluate(call_letters_ i)# size=15/td Jason Lees Development Team Leader National Express. -Original Message- From: Bruce H. Beinert [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 08:52 To: CF-Talk Subject: Auto generate form fields problem... Hi, I am trying to auto generate form fields and can't seem to get the last part right. I want to set the value of the input box as the variable but can't figure out how to do it... Obviously what happens is the value is set to call_letters_1 instead what I want which is #call_letters_1# I have tried a bunch of different things none of which work and just throw errors. Any ideas??? Thanks! cfset i = 1 cfloop index=param from=1 to=100 cfparam name=call_letters_#i# default= cfset i = i + 1 /cfloop table border=0 cellspacing=0 cellpadding=0 cfoutput cfset i = 1 cfloop index=call from=1 to=30 tr tdstrong#i#./strong/td tdinput type=text name=call_letters_#i# value=call_letters_#i# size=15/td /tr cfset i = i +1 /cfloop /cfoutput /table -- Bruce H. Beinert p.808-637-0727m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Exception in jrunx.resource.ResourceURLClassLoader
Cheers Sean, you came to the same conclusion as I did. Though what I also had to do was restart CF. Thankfully it's a development machine so all was not lost. -- Oliver Tupman Key Systems Geotechnical ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Message board / forums
-Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:20 PM To: CF-Talk Subject: RE: Message board / forums What would be the best way to structure a db for the discussion topics and responses... Assuming I am using sql server? It kind of depends on what you want to end up with. To me the main question is whether or not you want threaded replies (my preference) or flat topic replies (as it seems most every forum is lately). The latter is by far easier. You would have, perhaps, a table of forums (topic groups), a table of topics and then a table of messages. Each message would be linked to a topic and each topic to a forum. Displaying messages would be as easy as selecting all messages keyed to the topic and displaying them in reverse chronological order. You can get more complex than that of course, but that's it in a nutshell. Basically each discussion is just a stack of messages. To do threaded discussion you have several options. I think that the most common way to do this is for each message to remember the ID of it's parent (if it's a reply) - this is the parent/child model. Then you can recursively (probably using Queries of Queries is easiest/fastest here) display the messages. Another option is nested set based design where you defining the groupings (nestings) of your messages. This is confusing to a lot of people but has the advantage of maintaining order better than parent child and can be done with faster, simpler SQL once you get your mind around the model. However it's not as simple to maintain (add messages to the middle, delete messages, etc). Both of these are tree models and you'll get a lot of action if you search Google for SQL Trees. Determining how you'd like to walk you trees is probably the more fundamental core of your design. Another thing to keep in mind is how you want to identify your messages. For example using an Identity (autonumber) is probably easiest but could make it hard to copy/syndicate your messages to other installations of the same software. A GUID takes up a LOT more room in the database but can allow you to mix topics from multiple databases much easier. There's still a lot more... it's a REALLY big topic. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF - XML Questions
Dave Watts wrote: I have tried to resolve this page using cfhttp as in: cfhttp url=http://client.something.com/TESTOpenShipments /OpenShipments.dll/OpenShipments method=POST resolveurl= false proxyserver=192.168.36.999 proxyport=80 cfhttpparam type=formfield name=CarrierID value=15 cfhttpparam type=formfield name=CarrierPassword value=password cfhttpparam type=formfield name=LastServerTime value= /cfhttp cfoutput file content: br #cfhttp.filecontent# /cfoutput But I keep getting the following error: file content: Connection Failure I dont know if this is because of proxy server settings. Well, you are getting a connection failure. It looks like you're doing everything right, basically, but your CFHTTP request isn't getting a response. Where did you get the values for PROXYSERVER and PROXYPORT? It's odd to see a proxy server running on port 80. What happens if you omit both of those attributes? Also like to point out that the IP address: proxyserver=192.168.36.999 proxyport=80 is invalid. IP numbers are 0 - 255. That could be your reason, unless you've changed it for security reasons for your post. -- Oliver Tupman Key Systems Geotechnical ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Missing form fields - anyone experienced this error ?
Also What browser are they using? Some older versions of browsers have been known to drop form fields. Kola -Original Message- From: Robert Kogan [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 09:01 To: CF-Talk Subject: Missing form fields - anyone experienced this error ? Let me describe the problem I'm experiencing -- there's a form on our site that is very long and contains many inputs (of type hidden, text, select, etc.). When the submit button is pressed, it submits to a second page. This all worked perfectly for many months, but this week we upgraded to ColdFusion MX from 5.0. Now the page still works for me, but about 10 times a day from other users I get an error email saying that on the second page, the form fields are undefined. The error occurs on the very first form field that the page tries to access, which is a select box. From reading others' suggestions, I've moved the form and /form tags to outside the table, and I've fixed all ill-formed HTML. I've also run the ColdFusion updater to make sure that we have the latest version and patches. The problem is still occurring. I see in this forum that several people have experienced this problem and no solution was ever posted. If anyone has any info on this problem, please let me know. Thanks so much, Rob Kogan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: re: Mach-II
I'm not falling for this - will the real 'Angus Mcfee III' step forward. (Thanks for the laughs!) Michael Traher -Original Message- From: Angus McFee [mailto:[EMAIL PROTECTED] Sent: 30 July 2003 21:09 To: CF-Talk Subject: RE: RE: re: Mach-II Hal - I've heard from plenty of people looking for a way to beat up on Fusebox, but usually they have nothing to say when it comes to building a better framework. This is the first time in a long time anyone has suggested an alternative approach, and I really don't see how any of this benefits developers. This mach-ii stuff looks like just another petty attack on Fusebox. It's pretty clear we see things differently when it comes to building Web applications. I don't know you, but I can tell you are a pretty intelligent person, so you probably have some good reasons for why you don't like or hate fusebox. What I have to ask you is: do you use fusebox? Becuase there are plenty of people who are ready to attack it anytime and don't even know ColdFusion, much less what a framework is. You will probably never be convinced about the benefits of fusebox, all I can do is disagree with you, and point out all the great things fusebox does for developers: * it separates business logic from presentation logic, making for more organized, efficent code * it gives developers a common set of rules and methods to work from, so that everyone can understand what the other people are doing on a project regardless of the size of a team * it modularizes and encapsulates code, making it easier to reuse and thus to maintain * it is self-documenting, containing a complete, inline XML standard for documenting your applications * most importantly, there are thousands and thousands of fusebox developers out there, and more and more shops are choosing to use it every day. it is close to becoming a de-facto standard, which I doubt your mach-ii 'framework' will ever be able to match Angus McFee -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:16 PM To: CF-Talk Subject: RE: RE: re: Mach-II You're right, Dave. We're not looking to be able to incorporate Fusebox 3 (or 4) with Mach-II. We think that Fusebox is a great framework for procedural programmers. (Please, God, don't let this degenerate into yet another pro/con Fusebox debate...) Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. Hal Helms Java for CF Programmers class in Las Vegas, August 18-22 www.halhelms.com - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Auto generate form fields problem...
Scope! cfparam name=form.call_letters_#i# default= input type=text name=call_letters_#i# value=#form['call_letters_#i#']# size=15 Evaluate is an incredibly slow tag, try to avoid it if you can I am trying to auto generate form fields and can't seem to get the last part right. I want to set the value of the input box as the variable but can't figure out how to do it... Obviously what happens is the value is set to call_letters_1 instead what I want which is #call_letters_1# I have tried a bunch of different things none of which work and just throw errors. Any ideas??? Thanks! cfset i = 1 cfloop index=param from=1 to=100 cfparam name=call_letters_#i# default= cfset i = i + 1 /cfloop table border=0 cellspacing=0 cellpadding=0 cfoutput cfset i = 1 cfloop index=call from=1 to=30 tr tdstrong#i#./strong/td tdinput type=text name=call_letters_#i# value=call_letters_#i# size=15/td /tr cfset i = i +1 /cfloop /cfoutput /table -- Bruce H. Beinert p.808-637-0727m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfschedules....
Hi there, We have a problem with cfschedule that is proving very annoying now. We created a task to be run on the 1st of every month called newsmail. We noticed that the task was being run at odd times so decided to do further investigation - the task was deleted and then yesterday morning we noticed that the newsmail had been run again. We checked the logs and found the following: Information,jrpp-599,07/30/03,11:25:37,,[NewsMail] Activating2 on Wed Jul 30 11:25:37 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 Information,jrpp-599,07/30/03,11:26:57,,[NewsMail] Activating2 on Wed Jul 30 11:26:57 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 This task was deleted and is now activating itself and setting it to run on 'Tue Aug 26 07:00:00 BST 2003'. Anyone had any similar fun with cfschedules or any sensible suggestions for getting round it? Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Caching until updated
This (below) won't refresh the query. It'll merely take the data from the cache. To update the query do the following. Flushing Cached Queries You can immediately refresh the queries that use the cachedwithin or cachedafter attribute by inserting all zero values in the CreateTimeSpan( ) function, as shown here: cfquery name=qGetCountry datasource=devnet cachedwithin=#CreateTimeSpan(0,0,0,0)# SELECT CountryID, CountryName FROMCountry ORDER BYCountryName /cfquery Here's a good article on caching: http://www.macromedia.com/devnet/mx/coldfusion/articles/cfcaching.html -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 30 July 2003 10:33 PM To: CF-Talk Subject: RE: Caching until updated I think you can reset a query that is using cachedwithin (or cachedafter) by just running the exact same query without the parameter. This should resets it. For example on most of your processing pages you may have something like this silly example. cfquery name=Days datasrouce=dsn cachedwithin(createTimeSpan(7,0,0,0)) SELECT DAYS FROM WEEKS WHERE LANGUAGE = ENGLISH /cfquery If you wanted to refresh this, for whatever reason in your update process after inserting, updating or deleting information in the table run the query without the cached param. cfquery name=Days datasrouce=dsn SELECT DAYS FROM WEEKS WHERE LANGUAGE = ENGLISH /cfquery -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:13 AM To: CF-Talk Subject: RE: Caching until updated I have -never- used cachedafter simply because I have not had a need for it. I either use cachedWIthin to get 'cache for N time' or I cache in the application (or some other) scope. === 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: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:56 AM To: CF-Talk Subject: Caching until updated Raymond, On a side note, would it be better to use cfquery's cachedwithin or cachedafter instead of having to take care of the cache myself? If so, how would I do that? Cedric I'd watch out using local variable name w/ the same name as the method. You should probably use another name and var scope it. Also, in general, I wouldn't directly access the application scope from within the CFC. What if you want to use the server scope instead? It would make more sense to just use: cfset application.myEntries = theCFC.getEntries(...) Or at least use another CFC to abstract where the caching is done. = == = === 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: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:41 AM To: CF-Talk Subject: RE: Caching until updated cffunction name=getEntries returntype=query cfargument name=updateCache required=true default=1 cfif not IsDefined('Application.myEntries') or Arguments.updateCache cfquery name=getEntries SELECT * FROMEntriesTable /cfquery cfset Application.myEntries=getEntries /cfif cfreturn Application.myEntries /cffunction On your update entry page just do mycfc.getEntries(1|0) -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 12:46 PM To: CF-Talk Subject: Caching until updated I'm sure there is a way to do this, I just can't seem to think through it. Basically, I have a table which isn't going to change much. Instead of pulling this information from the database, I'd like to cache the query in the Application scope. But when a record IS added to that table, I would like to reset the cached version to include the change. Basically, how can I cache something until I know the records it contains changes? If it helps, I'm using CFC's and can easily do this in the INSERT function, just can't figure it out. Any help? Cedric ~| Archives:
SOT: Dedicated Linux Server (cheap)
Hi, I was wondering if anyone can recommend a dedicated Linux server for hire? It doesn't need to be a huge load (just for development) so a mini-server would be fine. Any ideas would be great. Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Access to MySQL Migration
Jim McAtee wrote: How exactly does cfqueryparam fix this? I just modified a tiny application I wrote which now uses a MySQL table to track query history. Using cfqueryparam did indeed fix the problem, but I can't really tell what it's doing. My cfquery, which looks like cfquery datasource=Whois INSERT INTO history (searchdatetime, employeeid, searchstring, serverid) VALUES (#CreateODBCDateTime(Now())#, #employeeid#, cfqueryparam value=#form.domain# cfsqltype=cf_sql_varchar, #form.serverid#) /cfquery is transformed into INSERT INTO history (searchdatetime, employeeid, searchstring, serverid) VALUES ({ts '2003-07-30 17:47:22'}, 9, ?, 1) Query Parameter Value(s) - Parameter #1 = the search\ and the string the search\ gets inserted into the table. I understand how the prepared statement works, but is cfqueryparam doing some type of auto-escape (that isn't visible in the debug output or does it somehow affect the query behavior? cfqueryparam uses bind variables which in effect tells the database driver escape this variable (amongst other things). Since what exactly needs to be escaped and how it needs to be escaped depends on which database you are using, this is a feature of the database driver, not of CF MX. For some Java code that gives a peek behind the scenes see http://www.houseoffusion.com/lists.cfm?link=m:4:16005:82617 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfschedules....
I;ve also experienced this (on CFMX), where monthly scheduled tasks end up running at 'odd' times. I didn;t find out the cause of the problem, but what I did in the end was to amend to the script template so that it checked for the current day/date first...eg... cfif dateformat(now(),'d') eq 1 !--- code to run task --- cfelse !--- do nothing --- /cfif and I then amended the scheduled task so that it ran daily HTH Alex -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: cfschedules Hi there, We have a problem with cfschedule that is proving very annoying now. We created a task to be run on the 1st of every month called newsmail. We noticed that the task was being run at odd times so decided to do further investigation - the task was deleted and then yesterday morning we noticed that the newsmail had been run again. We checked the logs and found the following: Information,jrpp-599,07/30/03,11:25:37,,[NewsMail] Activating2 on Wed Jul 30 11:25:37 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 Information,jrpp-599,07/30/03,11:26:57,,[NewsMail] Activating2 on Wed Jul 30 11:26:57 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 This task was deleted and is now activating itself and setting it to run on 'Tue Aug 26 07:00:00 BST 2003'. Anyone had any similar fun with cfschedules or any sensible suggestions for getting round it? Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfschedules....
If your using CFMX then yes there is a bug with the scheduler.. When you create a schedule in CFMX it is added to neo-cron.xml configuration file, if you update the schedule, the file is not updated and the schedule runs as previously set. Delete the schedule, restart CFMX and set it up again. For daily schedules, the first time it runs, it runs at the specified time, but after that it runs at midnight, the updater 3 fixes this bug. -Original Message- From: A.Little [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:08 To: CF-Talk Subject: RE: cfschedules I;ve also experienced this (on CFMX), where monthly scheduled tasks end up running at 'odd' times. I didn;t find out the cause of the problem, but what I did in the end was to amend to the script template so that it checked for the current day/date first...eg... cfif dateformat(now(),'d') eq 1 !--- code to run task --- cfelse !--- do nothing --- /cfif and I then amended the scheduled task so that it ran daily HTH Alex -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: cfschedules Hi there, We have a problem with cfschedule that is proving very annoying now. We created a task to be run on the 1st of every month called newsmail. We noticed that the task was being run at odd times so decided to do further investigation - the task was deleted and then yesterday morning we noticed that the newsmail had been run again. We checked the logs and found the following: Information,jrpp-599,07/30/03,11:25:37,,[NewsMail] Activating2 on Wed Jul 30 11:25:37 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 Information,jrpp-599,07/30/03,11:26:57,,[NewsMail] Activating2 on Wed Jul 30 11:26:57 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 This task was deleted and is now activating itself and setting it to run on 'Tue Aug 26 07:00:00 BST 2003'. Anyone had any similar fun with cfschedules or any sensible suggestions for getting round it? Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Message board / forums
Does anyone have a favorite message board app or forums app they can recommend.. That is free? :-) Define free. Free for non-commercial use, free with no strings attached, or what? -- Roger Benningfield http://journurl.com/ blog: http://admin.support.journurl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Message board / forums
Free as in the following... the forum will be on a site that is a non for profit.. its a club website. Basically the forum is the site. In addition i would like to add features and mods to it... Im working on one myself now but its my first one so it will take awhile. I thought maybe I could avoid building one if a scalable one was available for free. Mike - Original Message - From: Roger B. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 31, 2003 6:45 AM Subject: RE: Message board / forums Does anyone have a favorite message board app or forums app they can recommend.. That is free? :-) Define free. Free for non-commercial use, free with no strings attached, or what? -- Roger Benningfield http://journurl.com/ blog: http://admin.support.journurl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cleanup of FileExists - better options?
Hello list. I was wondering if anyone had any suggestions on the following problem - FileExists - Actually - it may not be a problem but here is my question. Are there better options to FileExists? Are they worth it - ie. does a file exist slow a page by alot? etc etc. I find that for my clients, the more I can following a naming convention to pull product graphics - the better success I have had than storing image info in a database. Problem is - I must look for a gif then a jpg etc. Any suggestions on cutting down this code below? Or should I leave well enough alone. I check to see if there is a pdf associated, then a gif or jpg pic... snip cfif FileExists(d:\webs\printersource.com\documents\specsheets\#TRIM(lcase(replace(make, , , ALL)))#_#TRIM(lcase(replace(Model, , , All)))#.pdf) cfset PDFSpecAvailable = Yes cfset PDFSpecLink = /documents/specsheets/#TRIM(lcase(replace(make, , , ALL)))#_#TRIM(lcase(replace(Model, , , All)))#.pdf cfelse cfset PDFSpecAvailable = No /cfif !-- look for jpg -- cfif FileExists(d:\webs\printersource.com\img\printers\#TRIM(lcase(replace(make, , , ALL)))#_#TRIM(lcase(replace(Model, , , All)))#_mini.jpg) cfset ImageThumbFile = #TRIM(lcase(replace(make, , , ALL)))#_#TRIM(lcase(replace(Model, , , All)))#_mini.jpg img src=/img/printers/#ImageThumbFile# cfset LookForGif = Yes br /cfif !-- look for .gif-- cfif LookForGif EQ Yes AND FileExists(d:\webs\printersource.com\img\printers\#TRIM(lcase(make))#_#TRIM(lcase(replace(Model, , , All)))#_mini.gif) cfset ImageThumbFile = #TRIM(lcase(replace(GetHardware.make, , , ALL)))#_#TRIM(lcase(replace(Model, , , All)))#_mini.gif img src=/img/printers/#ImageThumbFile# height=66 border=0br /cfif output is starts out something like this - but above is relevant to my question. span class=ModelHdr#Make# #Model#/spanbr#mSpeed#cfif cSpeed IS NOT /#cSpeed#/cfif #mSpeedBy#br cfif PDFSpecAvailable EQ Yesa href=http://64.234.202.48/#PDFSpecLink#; target=_newimg src=/img/icon_PDFAvailable1.gif border=0/acfelseCall 800-774-9174/cfif Thanks in advance!!! jay miller ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dedicated Linux Server (cheap)
Hi Oliver, We are just switching all our data servers from SCO UNIX to RED HAT LINUX. We have found that Linux is much faster and requires much less hardware spec to do the same job. So our development data servers are now just standard INTEL or AMD PC's costing about £400 (GBP). We have not properly tried running as web servers or CF servers so I can not comment on that.actually I'm still going to! I guess the same Linux efficiency of use of hardware will apply. Prove this to yourself by loading Linux on some old PC discarded in a corner (if you have one) and be amazed at how fast it runs! I can't imagine hiring would be cost effective. Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Oliver Cookson [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:57 To: CF-Talk Subject: SOT: Dedicated Linux Server (cheap) Hi, I was wondering if anyone can recommend a dedicated Linux server for hire? It doesn't need to be a huge load (just for development) so a mini-server would be fine. Any ideas would be great. Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: anyone from florida
I'm located in Cape Canaveral. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:02 PM To: CF-Talk Subject: Re: anyone from florida Originaly yes : ) - Original Message - From: Kevin Langevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 9:08 AM Subject: RE: anyone from florida Hi Michael- Just saw your post. I'm from South Florida. What's up? -Kev -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 11:22 PM To: CF-Talk Subject: OT: anyone from florida Anyone here from Florida? If so, email me off list.. [EMAIL PROTECTED] Sincerely, Michael Tangorre ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help with a pesky UDF...
Hello all, Having problems with the following UDF and need a little bit of help if possible running CF5 btw on IIS 5 Everything runs fine as the code is below, but as soon as I move the debug comments inside the second 'for' loop but before the 'if' statement, the page just hangs and kills the thread it just doesn't seem to want loop over the count of the query... I can't see a reason why it shouldn't work Code as follows with test query... cfscript theQuery = QueryNew(STATUS,COUNT); QueryAddRow(theQuery, 1); QuerySetCell(theQuery, STATUS, A, 1); QuerySetCell(theQuery, COUNT, 3, 1); QueryAddRow(theQuery, 2); QuerySetCell(theQuery, STATUS, C, 2); QuerySetCell(theQuery, COUNT, 2, 2); QueryAddRow(theQuery, 3); QuerySetCell(theQuery, STATUS, O, 3); QuerySetCell(theQuery, COUNT, 7, 3); /cfscript cfdump var=#theQuery# cfscript function udfMakeStatus(q) { var i = 1; var j = 1; var count = 0; var text = ; var code = ; var lStatus = O,Offered,R,Rejected,A,Accepted,C,Confirmed,F,Finished; var rHTML = emOFFER STATUS/emnbsp;|; for (i=1; i LTE ListLen(lStatus); i=i+2) { count = 0; text = ListGetAt(lStatus, i+1); code = ListGetAt(lStatus, i); if (IsQuery(q) AND q.RecordCount GT 0) { writeoutput(text= text - code= code - rc= q.RecordCount br /); /* for (j=1; j LTE q.RecordCount; j+1) { writeoutput(text= text - code= code - j= j br /); if (q.STATUS[j] EQ code) { count = q.COUNT[j]; } } */ } rHTML = rHTML nbsp; text - count nbsp;|; } rHTML = rHTML ; return rHTML; } writeoutput(udfMakeStatus(theQuery)); /cfscript I'm expecting an output (without the writeoutput's) of 'OFFER STATUS | Offered - 7 | Rejected - 0 | Accepted - 3 | Confirmed - 2 | Finished - 0 |' I've been tearing my hair out with it and I want it to work... or at least know why it doesn't work :-) Cheers in advance DC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query output stops after 114 records
Ok Folks, here is a good one. I have a query : cfquery datasource=cab name=getlabels select * from labels order by label_code /cfquery this shows that my getlabels.recordcount is 118 BUT when i do cfoutput query=getLabels cfset counter = counter + 1 trtd#counter#/td td#label_code#/td TD#lang_id#/TD td#label#/td /tr /cfoutput it only displays 114 records. And the content of #label# on the last record is truncated! i checked in the db, there is 118 records, and the there is nothing wrong with label 114. it looks like the processing stops for some reason. becaue there is no more html code after this record in the page source and the fotter is not displayed, even though my footer is called by an include tag in the OnRequestEnd.cfm template. Any ideas as to why this happens? TIA! Gabriel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help with a pesky UDF...
So is the code below the code that cuases the error, or the code that works ok? === 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: David Collie (itndac) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:23 AM To: CF-Talk Subject: Help with a pesky UDF... Hello all, Having problems with the following UDF and need a little bit of help if possible running CF5 btw on IIS 5 Everything runs fine as the code is below, but as soon as I move the debug comments inside the second 'for' loop but before the 'if' statement, the page just hangs and kills the thread it just doesn't seem to want loop over the count of the query... I can't see a reason why it shouldn't work Code as follows with test query... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help with a pesky UDF...
Oh, I think I see it. In the for loop, you have j+1 as the third item. It should be j=j+1. === 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: David Collie (itndac) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:23 AM To: CF-Talk Subject: Help with a pesky UDF... Hello all, Having problems with the following UDF and need a little bit of help if possible running CF5 btw on IIS 5 Everything runs fine as the code is below, but as soon as I move the debug comments inside the second 'for' loop but before the 'if' statement, the page just hangs and kills the thread it just doesn't seem to want loop over the count of the query... I can't see a reason why it shouldn't work Code as follows with test query... cfscript theQuery = QueryNew(STATUS,COUNT); QueryAddRow(theQuery, 1); QuerySetCell(theQuery, STATUS, A, 1); QuerySetCell(theQuery, COUNT, 3, 1); QueryAddRow(theQuery, 2); QuerySetCell(theQuery, STATUS, C, 2); QuerySetCell(theQuery, COUNT, 2, 2); QueryAddRow(theQuery, 3); QuerySetCell(theQuery, STATUS, O, 3); QuerySetCell(theQuery, COUNT, 7, 3); /cfscript cfdump var=#theQuery# cfscript function udfMakeStatus(q) { var i = 1; var j = 1; var count = 0; var text = ; var code = ; var lStatus = O,Offered,R,Rejected,A,Accepted,C,Confirmed,F,Finished; var rHTML = emOFFER STATUS/emnbsp;|; for (i=1; i LTE ListLen(lStatus); i=i+2) { count = 0; text = ListGetAt(lStatus, i+1); code = ListGetAt(lStatus, i); if (IsQuery(q) AND q.RecordCount GT 0) { writeoutput(text= text - code= code - rc= q.RecordCount br /); /* for (j=1; j LTE q.RecordCount; j+1) { writeoutput(text= text - code= code - j= j br /); if (q.STATUS[j] EQ code) { count = q.COUNT[j]; } } */ } rHTML = rHTML nbsp; text - count nbsp;|; } rHTML = rHTML ; return rHTML; } writeoutput(udfMakeStatus(theQuery)); /cfscript I'm expecting an output (without the writeoutput's) of 'OFFER STATUS | Offered - 7 | Rejected - 0 | Accepted - 3 | Confirmed - 2 | Finished - 0 |' I've been tearing my hair out with it and I want it to work... or at least know why it doesn't work :-) Cheers in advance DC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help with a pesky UDF...
The code below works and outputs but if you move the debug comments inside the second for loop, as shown below, it hangs . . for (j=1; j LTE q.RecordCount; j+1) { writeoutput(text= text - code= code - j= j br /); /* if (q.STATUS[j] EQ code) { count = q.COUNT[j]; } */ } . . Thanks, DC -Original Message- From: Raymond Camden Sent: 31 July 2003 12:51 To: CF-Talk Subject: RE: Help with a pesky UDF... So is the code below the code that cuases the error, or the code that works ok? -Original Message- From: David Collie (itndac) Sent: Thursday, July 31, 2003 5:23 AM To: CF-Talk Subject: Help with a pesky UDF... Hello all, Having problems with the following UDF and need a little bit of help if possible running CF5 btw on IIS 5 Everything runs fine as the code is below, but as soon as I move the debug comments inside the second 'for' loop but before the 'if' statement, the page just hangs and kills the thread it just doesn't seem to want loop over the count of the query... I can't see a reason why it shouldn't work Code as follows with test query... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help with a pesky UDF...
yes yes yes!!! I just couldn't see that at all! Feeling a bit stupid now :-) Cheers Raymond... was starting to question my sanity over it!!! -Original Message- From: Raymond Camden Sent: 31 July 2003 12:55 To: CF-Talk Subject: RE: Help with a pesky UDF... Oh, I think I see it. In the for loop, you have j+1 as the third item. It should be j=j+1. === -Original Message- From: David Collie (itndac) Sent: Thursday, July 31, 2003 5:23 AM To: CF-Talk Subject: Help with a pesky UDF... Hello all, Having problems with the following UDF and need a little bit of help if possible running CF5 btw on IIS 5 Everything runs fine as the code is below, but as soon as I move the debug comments inside the second 'for' loop but before the 'if' statement, the page just hangs and kills the thread it just doesn't seem to want loop over the count of the query... I can't see a reason why it shouldn't work Code as follows with test query... cfscript theQuery = QueryNew(STATUS,COUNT); QueryAddRow(theQuery, 1); QuerySetCell(theQuery, STATUS, A, 1); QuerySetCell(theQuery, COUNT, 3, 1); QueryAddRow(theQuery, 2); QuerySetCell(theQuery, STATUS, C, 2); QuerySetCell(theQuery, COUNT, 2, 2); QueryAddRow(theQuery, 3); QuerySetCell(theQuery, STATUS, O, 3); QuerySetCell(theQuery, COUNT, 7, 3); /cfscript cfdump var=#theQuery# cfscript function udfMakeStatus(q) { var i = 1; var j = 1; var count = 0; var text = ; var code = ; var lStatus = O,Offered,R,Rejected,A,Accepted,C,Confirmed,F,Finished; var rHTML = emOFFER STATUS/emnbsp;|; for (i=1; i LTE ListLen(lStatus); i=i+2) { count = 0; text = ListGetAt(lStatus, i+1); code = ListGetAt(lStatus, i); if (IsQuery(q) AND q.RecordCount GT 0) { writeoutput(text= text - code= code - rc= q.RecordCount br /); /* for (j=1; j LTE q.RecordCount; j+1) { writeoutput(text= text - code= code - j= j br /); if (q.STATUS[j] EQ code) { count = q.COUNT[j]; } } */ } rHTML = rHTML nbsp; text - count nbsp;|; } rHTML = rHTML ; return rHTML; } writeoutput(udfMakeStatus(theQuery)); /cfscript I'm expecting an output (without the writeoutput's) of 'OFFER STATUS | Offered - 7 | Rejected - 0 | Accepted - 3 | Confirmed - 2 | Finished - 0 |' I've been tearing my hair out with it and I want it to work... or at least know why it doesn't work :-) Cheers in advance DC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
on-line banking
I have a bank client who now wants to jump into on-line banking I am looking for any suggestions/comments/references I know there are many canned packages out there, but I'm looking for those that may be CF based and proven. Developing this from scratch could be quite a chore. Feel free to contact me off list as well TIA Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help with a pesky UDF...
Oops misunderstood the docs on QueryAddRow... was a bit late last night when I did it :-) thought the number was what number of row you were adding to as opposed to the number of rows that you wanted to add! Again, cheers -Original Message- From: Raymond Camden Sent: 31 July 2003 12:59 To: CF-Talk Subject: RE: Help with a pesky UDF... By the way, when you do your queryAddRow, why do you use 2 and 3? I think you meant to only add one row at a time. === -Original Message- From: David Collie (itndac) Sent: Thursday, July 31, 2003 5:23 AM To: CF-Talk Subject: Help with a pesky UDF... Hello all, Having problems with the following UDF and need a little bit of help if possible running CF5 btw on IIS 5 Everything runs fine as the code is below, but as soon as I move the debug comments inside the second 'for' loop but before the 'if' statement, the page just hangs and kills the thread it just doesn't seem to want loop over the count of the query... I can't see a reason why it shouldn't work Code as follows with test query... cfscript theQuery = QueryNew(STATUS,COUNT); QueryAddRow(theQuery, 1); QuerySetCell(theQuery, STATUS, A, 1); QuerySetCell(theQuery, COUNT, 3, 1); QueryAddRow(theQuery, 2); QuerySetCell(theQuery, STATUS, C, 2); QuerySetCell(theQuery, COUNT, 2, 2); QueryAddRow(theQuery, 3); QuerySetCell(theQuery, STATUS, O, 3); QuerySetCell(theQuery, COUNT, 7, 3); /cfscript cfdump var=#theQuery# ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX cfquery error msg?
I have several sites that generate this error message on a regular basis but no problems seems to occur on the sites. What may be causing this? I've searched everywhere and cannot find an answer. Running CFMX/MSSQL2000. [Macromedia][SQLServer JDBC Driver]End of stream was detected on a read. All the queries/stored procedures are wrapped in cftry/cfcatch statements. Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Can you view the output before passing it to the custom tag? If not can you replicate the code in the custom tag which creates the table and view the html generated? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:39 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: re: Mach-II
nono it's like building a house silly. Timothy Heald Information Systems Specialist Overseas Security Advisory Council U.S. Department of State 571.345.2235 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 3:07 AM To: CF-Talk Subject: Re: RE: re: Mach-II Sheesh... what's next? Probably some guy somewhere saying something silly like cooking is a lot like programming. U... nevermind. -Novak ;-) - Original Message - From: Hal Helms [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:35 PM Subject: RE: RE: re: Mach-II Yeah, yeah, I've heard of this Fusebox framework. I've even used it once or twice. I just don't get what the big deal is, though. Sure it helps you separate logic and presentation, it helps teams work together, it provides encapsulation, etc, etc. But is that really sufficient grounds for liking something - that it helps people? What's next? Shall we adopt something simply because it works? Where would great corporations like Microsoft or Oracle be if they adopted that attitude? You sound too much like that guy in CFDJ who sounds like freakin' Oprah with his talk about empowering people and supporting developers. Give me something manlier than that! And as for documentation, which you note as a strength of Fusebox, well, all I can do is quote a greater man than I who said: It was hard to write. It should be hard to understand. Hal Helms Java for CF Programmers class in Las Vegas, August 18-22 www.halhelms.com -Original Message- From: Angus McFee [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 5:09 PM To: CF-Talk Subject: RE: RE: re: Mach-II Matt - Good to hear from a fellow fuseboxer! No, this isn't a joke, this guy clearly has a problem with what fusebox has become and has made this other framework that clearly doesn't do most of what Fusebox is capable of. I don' t think him having helped make fusebox or having been in a few books makes a huge difference. My dog has been in a few books, that doesn't mean he don't hate cats. But this really sounds like he is dissing fusebox. Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. These things aren't new and they don't do something you can't do with fusebox already. Fusebox already works in ColdFusion, PHP, ASP, JSP and Perl, and I have even seen a TCL port for the framework. In PHP, you can do all the object oriented programming you want, so I don't see why there would be a need for this mach-ii except to take away from fusebox. This guy is just one of the ones who is never going to get what it is all about. Angus McFee -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:37 PM To: CF-Talk Subject: Re: Mach-II This is a joke right? -Matt On Wednesday, July 30, 2003, at 04:08 PM, Angus McFee wrote: Hal - I've heard from plenty of people looking for a way to beat up on Fusebox, but usually they have nothing to say when it comes to building a better framework. This is the first time in a long time anyone has suggested an alternative approach, and I really don't see how any of this benefits developers. This mach-ii stuff looks like just another petty attack on Fusebox. It's pretty clear we see things differently when it comes to building Web applications. I don't know you, but I can tell you are a pretty intelligent person, so you probably have some good reasons for why you don't like or hate fusebox. What I have to ask you is: do you use fusebox? Becuase there are plenty of people who are ready to attack it anytime and don't even know ColdFusion, much less what a framework is. You will probably never be convinced about the benefits of fusebox, all I can do is disagree with you, and point out all the great things fusebox does for developers: * it separates business logic from presentation logic, making for more organized, efficent code * it gives developers a common set of rules and methods to work from, so that everyone can understand what the other people are doing on a project regardless of the size of a team * it modularizes and encapsulates code, making it easier to reuse and thus to maintain * it is self-documenting, containing a complete, inline XML standard for documenting your applications * most importantly, there are thousands and thousands of fusebox developers out there, and more and more shops are choosing to use it every day. it is close to becoming a de-facto standard, which I doubt your mach-ii 'framework' will ever be able to match Angus McFee -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]
Stripping out MS Word Characters
We have an issue, and I am hoping someone has dealt with this before. We are importing over a thousand articles from a MS SQL database into a MySQL database. The actual article content has been saved to the MS SQL Database with Ektron's EWebEditPro in which the editors used MS Word to write their content and then copy and pasted it into the article editor that was then saved into MS SQL server. The problem is all kinds of characters from single quotes to double quotes and a slew of other characters are converting over to look like chinese characters. I need to replace all of those MS Word characters for single quotes and spaces to raw text. Anyone have any suggestions? Thanks in advance Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: anyone from florida
I live in Tallahassee Prof. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing. The Fifth Discipline - Peter Senge -- Original Message -- From: Dowdell, Jason G [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 31 Jul 2003 07:20:07 -0400 I'm located in Cape Canaveral. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:02 PM To: CF-Talk Subject: Re: anyone from florida Originaly yes : ) - Original Message - From: Kevin Langevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 9:08 AM Subject: RE: anyone from florida Hi Michael- Just saw your post. I'm from South Florida. What's up? -Kev -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 11:22 PM To: CF-Talk Subject: OT: anyone from florida Anyone here from Florida? If so, email me off list.. [EMAIL PROTECTED] Sincerely, Michael Tangorre ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query output stops after 114 records
Hello Have you tried using cfloop instead of cfoutput? -Original Message- From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:48 AM To: CF-Talk Subject: query output stops after 114 records Ok Folks, here is a good one. I have a query : cfquery datasource=cab name=getlabels select * from labels order by label_code /cfquery this shows that my getlabels.recordcount is 118 BUT when i do cfoutput query=getLabels cfset counter = counter + 1 trtd#counter#/td td#label_code#/td TD#lang_id#/TD td#label#/td /tr /cfoutput it only displays 114 records. And the content of #label# on the last record is truncated! i checked in the db, there is 118 records, and the there is nothing wrong with label 114. it looks like the processing stops for some reason. becaue there is no more html code after this record in the page source and the fotter is not displayed, even though my footer is called by an include tag in the OnRequestEnd.cfm template. Any ideas as to why this happens? TIA! Gabriel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfchart problem
I am hoping that this is something simple and straightforward the I am missing but... I am on CFMX Updater 3/Apache 1.3.27 and whenever I use cfchart, the page processes fine(well, it doesn't throw an error anyway) but does not produce a graph and no code to specify a graph is produced in the HTML page displayed. Any ideas on what I need to do to fix this? I haven't needed CFGRAPH in well over a year so it is all a little hazy to me. Is there a setting or something I need to change? I seem to remember something relative to updater 3 but have been unable to find anything anywhere. TIA. Andrew I just want chart Golden ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query output stops after 114 records
At 08:55 AM 07/31/03 -0400, Qasim Rasheed wrote: BUT when i do cfoutput query=getLabels cfset counter = counter + 1 trtd#counter#/td td#label_code#/td TD#lang_id#/TD td#label#/td /tr /cfoutput it only displays 114 records. And the content of #label# on the last record is truncated! I had this happen because I had characters CF didn't like in one of my displayed fields. I'm guessing the label field has something in it that CF is treating a programming code. T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query output stops after 114 records
Also, this doesn't help much, but you don't need counter. When you loop over a query you can use #currentRow# as a built-in variable. === 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: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:10 AM To: CF-Talk Subject: RE: query output stops after 114 records At 08:55 AM 07/31/03 -0400, Qasim Rasheed wrote: BUT when i do cfoutput query=getLabels cfset counter = counter + 1 trtd#counter#/td td#label_code#/td TD#lang_id#/TD td#label#/td /tr /cfoutput it only displays 114 records. And the content of #label# on the last record is truncated! I had this happen because I had characters CF didn't like in one of my displayed fields. I'm guessing the label field has something in it that CF is treating a programming code. T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Content Management Systems - a short list...
I know you specified CF-based CMSs, but you might also be interested in what my company, Montara Software offers in our Alchemy EX product. Alchemy EX is a J2EE-based CMS that integrates with CF seamlessly allowing CFML developers to take full advantage of our rich API and robust Java infrastructure. Check out our web site for more information, http://www.montarasoftware.com. Below are a few points of interest. * Alchemy EX includes a basic digital asset management system (DAM), so everything is stored in a DB * Alchemy EX includes a DB eliminating the need for an expense RDBMS that was designed for content storage in the first place * Alchemy EX is the ONLY CMS to make all of its APIs available through Flash Remoting making it the ONLY CMS that allows for content management of RIAs built with Flash * The performance of Alchemy EX is orders of magnitude better than competing systems -Matt On Wednesday, July 30, 2003, at 09:59 PM, BRIAN MELOCHE wrote: I would be interested in hearing opinions on some good CF-based CMSs. I need to develop a short list so that I can evaluate a few systems. If you could pick one... which one? And why? Any experience with one system or another? We have a CMS here, which is the biggest piece of... well, let's just say that I may finally win the battle that this system needs a replacement. I would upgrade the existing system, but I think that will take too many man hours to fix the flaws in the system and... right now, I am a one-man development team. Here are my requirements: Permissions Workflow Images and documents stored in Database, but are published to website. Static pages that can be stored in Database - allow versioning. DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases (This is not how the existing system works). Oracle 8i/9i - DB maintenance available OUTSIDE of system (Isn't this an issue with NQCONTENT?) CF5 preferred; CFMX Enterprise possible (we'd have to upgrade; there may be COM object issues if we do) EASY TO USE for the USERS!!! (CMS users have to be able to use the admin, not fight with it every time they want to do something.) Uses stylesheets I should be able to make CMS and site interface changes, if needed. Simple URLs! - e.g. http://www.easynavigate.com/section/page.cfm (our current CMS does not do this and that is the single biggest complaint from the executives) RELATIVELY EASY TO GET UP AND RUNNING Relatively easy to customize, if necessary I can elaborate more if needed. Here are a list of CF-based systems that I know of... Ektron - CMS 100/200/300 eMPower (I am not sure what the differences are between CMS 300 and eMPower - I didn't find that very clear from their website) PaperThin - Common Spot Server NetQuest - NQContent Systems Alliance - Site Executive FarCry - Open Source - inspired by Spectra (CFMX based - more of a framework than a finished system?) Spectra - Allaire/Macromedia, now Open Source (framework) Oasis - RemoteSite Technologies (I couldn't get to their site) SparkPlug - 13amp.com There may be others I don't know of... Are there any open source CMSs that are CF-based that are ready to go, out of the box? For something like FarCry, how quickly can it be configured so that an existing CMS can be converted, users, permissions, workflow and content? I am not really interested right now in hearing from sales people... I want to hear from developers that have tried out systems and have an opinion. Looking forward to the responses! Sincerely, Brian Meloche, 4th Floor, ITO - 414 CSS (304) 759-0585 x448 Macromedia Certified Advanced ColdFusion 5.0 Developer 130 pounds lost and counting! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query output stops after 114 records
Try displaying the records in the inverse order. This will tell you if ColdFusion encounters some strange characters in the query. Also you can try getting the length of the label field from SQL and comparing it with what ColdFusion has to say. mack / - Original Message - From: Gabriel Robichaud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 31, 2003 2:48 PM Subject: query output stops after 114 records Ok Folks, here is a good one. I have a query : cfquery datasource=cab name=getlabels select * from labels order by label_code /cfquery this shows that my getlabels.recordcount is 118 BUT when i do cfoutput query=getLabels cfset counter = counter + 1 trtd#counter#/td td#label_code#/td TD#lang_id#/TD td#label#/td /tr /cfoutput it only displays 114 records. And the content of #label# on the last record is truncated! i checked in the db, there is 118 records, and the there is nothing wrong with label 114. it looks like the processing stops for some reason. becaue there is no more html code after this record in the page source and the fotter is not displayed, even though my footer is called by an include tag in the OnRequestEnd.cfm template. Any ideas as to why this happens? TIA! Gabriel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stripping out MS Word Characters
There are a couple of UDF's over the cflib.org that are designed to strip the markup out of the MS content. HTH -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:50 AM To: CF-Talk Subject: Stripping out MS Word Characters We have an issue, and I am hoping someone has dealt with this before. We are importing over a thousand articles from a MS SQL database into a MySQL database. The actual article content has been saved to the MS SQL Database with Ektron's EWebEditPro in which the editors used MS Word to write their content and then copy and pasted it into the article editor that was then saved into MS SQL server. The problem is all kinds of characters from single quotes to double quotes and a slew of other characters are converting over to look like chinese characters. I need to replace all of those MS Word characters for single quotes and spaces to raw text. Anyone have any suggestions? Thanks in advance Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: IIS Domain Naming Question
Yes, we're running our own DNS server. I still have to setup a domain in IIS though to match that URL ... Is it just treated like an ordinary host header? Any insight you can provide would be MOST appreciated. If no one else is interested we can take it off-list if you like. Thanks, 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: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 1:55 AM To: CF-Talk Subject: Re: OT: IIS Domain Naming Question Hi Joshua, Setting up fully-qualified domain names and subdomains is a function of DNS exclusively, not IIS. Are you running your own DNS server? If not, and you need more help, what is the actual domain name? Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com Joshua Miller wrote: Totally off-topic, I apologize. Does anyone have information to point me in the right direction figuring out how to create a domain name similar to: foo.bar.domain.com in IIS ? I can't seem to find this anywhere. Does this require some special setup for DNS as well? Thanks, sorry for the OT post. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ** ** * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Non blocking custom tag?
I understand that cfexecute can run this way if you omit a timeout value (I think). You could execute a batch file which runs wget to call a cf template, bit of a cludge, but should work. -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 14:59 To: CF-Talk Subject: Non blocking custom tag? Say I have a custom tag called CF_doSomething. The tag takes 3 seconds to run. Is there some way to tell ColdFusion to run it in a nonblocking mode so the user doesn't have to wait for the 3 seconds? I don't want to use CFHTTP to create another page. It would be nice to say something like CF_doSomething timeout=0 and have it just work. -Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Posting on CFJobs
Hi, I just posted a position on CFJOBs. It really is not a CF job but a Junior Level DBA person (Oracle, SQL) working with our CF developers. I posted it there because I thought maybe someone might know of someone interested. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help!
I read the article but I dont think I understand it. This is my first time working with such and I'm not sure how everything connects. If I use something other than Access to access the GAL, what can I do with that information once I have it? Will I then be able to implement it into a query? Can I still use Access at all? Will I need some special coding to incorporate the LDAP into an Access query? Sorry for so many questions, but I obviously need the help. Thanks in advance!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Can view the output before passing it to the custom tag. The query which generates the data is an include file as below.When I view the include file the data is all correct. But when I view the output using the tag it only returns every second row. cf_html2Excel sheetname=report Directory=#thedirectory#\exceltemp\ CFSET EXCEL=1 -- cfinclude template=high_grade_excel.cfm /CF_HTML2Excel CFHEADER NAME=Content-Disposition VALUE=inline;filename=customsearch.xls CFCONTENT TYPE=application/unknown FILE=#ExcelFile# DELETEFILE=Yes -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 01:12 PM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Can you view the output before passing it to the custom tag? If not can you replicate the code in the custom tag which creates the table and view the html generated? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:39 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query output stops after 114 records
I tried all that, doesnt change anything when i reverse the other, it stops at the 114 th record, even thouth its a different record. I then implemented page navigatino.. ie display 25 records, then the next 25 then the next 25... well it trucates at the 24th record. SO, i decided, on hunch, to change the cffom to form and my problem was solved!! argh but now that leaves me with a new problem, i cant used CFFORM Does anyone have any idea why this could happen? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Declan try it with another query and see if you get the same result. Also can you look at the source of the html generated and see if its formatted correctly (i.e. no missing tr tags etc.) . Finally is there any styling applied to the table? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 15:10 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Can view the output before passing it to the custom tag. The query which generates the data is an include file as below.When I view the include file the data is all correct. But when I view the output using the tag it only returns every second row. cf_html2Excel sheetname=report Directory=#thedirectory#\exceltemp\ CFSET EXCEL=1 -- cfinclude template=high_grade_excel.cfm /CF_HTML2Excel CFHEADER NAME=Content-Disposition VALUE=inline;filename=customsearch.xls CFCONTENT TYPE=application/unknown FILE=#ExcelFile# DELETEFILE=Yes -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 01:12 PM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Can you view the output before passing it to the custom tag? If not can you replicate the code in the custom tag which creates the table and view the html generated? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:39 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query String and Norton Internet Security
I have a user who is encountering an error when clicking on a certain link in our application when Norton Internet Security is enabled. If he shuts it off, it works fine. The link he is clicking on passes a fuseaction and 2 variables via the url. The error info sent to me via cferror has no http_referrer (which I have read is common with Nortons) but the query string variable only comes through as the CFID CFTOKEN string. Other parts of the app work fine, it seems isolated to a few places. Any ideas what is happening to the query string? Pt. 2 (maybe related?): I have seen phantom errors in the past, mainly from Mac users where I will get error diagnostics mailed to me but the end user never actually sees the error template i.e. the app. works as expected, but they trip an error to be mailed to me. The common error always seems to be a variable is undefined, but in the referrer itself mailed with the info the variable is present in the url scope. The common thing we have noticed with these is the Query String variable in the diagnostics is always blank. Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query output stops after 114 records
but now that leaves me with a new problem, i cant used CFFORM Pesonally I wouldn't see that as a problem, more a blessing in disguise... ;) 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/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query output stops after 114 records
hahah, i knew someone was going to say that!! LOL but now that leaves me with a new problem, i cant used CFFORM Pesonally I wouldn't see that as a problem, more a blessing in disguise... ;) 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/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stripping out MS Word Characters
Anyone have any suggestions? Try this: http://www.tazmedia.co.uk/software/tags/try_CleanMSText.cfm http://www.tazmedia.co.uk/software/tags/CleanMSText.zip HTH, 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/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Exam Buster - For Cert Prep
Has anybody purchased Centrasoft's CFMX Exam Buster? Did you find it to be helpful for preparing to take the certification exam? -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query String and Norton Internet Security
I seem to have found the cause of Pt.1, as the page called was using a cflocation with a http_referrer value as the page can be accessed from various templates. Pt. 2 is still a mystery to me. -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 9:30 AM To: CF-Talk Subject: Query String and Norton Internet Security I have a user who is encountering an error when clicking on a certain link in our application when Norton Internet Security is enabled. If he shuts it off, it works fine. The link he is clicking on passes a fuseaction and 2 variables via the url. The error info sent to me via cferror has no http_referrer (which I have read is common with Nortons) but the query string variable only comes through as the CFID CFTOKEN string. Other parts of the app work fine, it seems isolated to a few places. Any ideas what is happening to the query string? Pt. 2 (maybe related?): I have seen phantom errors in the past, mainly from Mac users where I will get error diagnostics mailed to me but the end user never actually sees the error template i.e. the app. works as expected, but they trip an error to be mailed to me. The common error always seems to be a variable is undefined, but in the referrer itself mailed with the info the variable is present in the url scope. The common thing we have noticed with these is the Query String variable in the diagnostics is always blank. Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Content Management Systems - a short list...
Just for a reference Ektron Empower is cf based. CMS 100/200/300 is asp based. It allows you to use cf to do layout and some other functionality but the core is asp. Dirk - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:01 PM Subject: RE: Content Management Systems - a short list... I would be interested in hearing opinions on some good CF-based CMSs. I need to develop a short list so that I can evaluate a few systems. If you could pick one... which one? And why? Any experience with one system or another? Well, as a CommonSpot vendor, I'm biased, but I think it's a good product for many CMS deployments. We've been looking at Site Executive too, and that seems pretty good. That said, there are a lot of differences between CMSs, and something that might work well for one deployment might not be suitable for another. Here are my requirements: Permissions Workflow Many CMSs have workflow, but there can be quite a bit of difference between how complex workflow can be between products. You'll need to ensure that the workflow functionality supports your needs. Images and documents stored in Database, but are published to website. Most CMSs don't actually store the images themselves in the database, but rather just where the images are stored on the filesystem. DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases (This is not how the existing system works). I'm not sure what you mean by this. Oracle 8i/9i - DB maintenance available OUTSIDE of system (Isn't this an issue with NQCONTENT?) I'm not exactly sure what you mean by this, either. CF5 preferred; CFMX Enterprise possible (we'd have to upgrade; there may be COM object issues if we do) EASY TO USE for the USERS!!! (CMS users have to be able to use the admin, not fight with it every time they want to do something.) Uses stylesheets I should be able to make CMS and site interface changes, if needed. Simple URLs! - e.g. http://www.easynavigate.com/section/page.cfm (our current CMS does not do this and that is the single biggest complaint from the executives) CommonSpot meets all these requirements, and I think Site Executive does too. CommonSpot uses a pretty simple browser-based interface for managing content, but you need to run Windows/IE to get the most out of this, I think. RELATIVELY EASY TO GET UP AND RUNNING Relatively easy to customize, if necessary CommonSpot is pretty easy to get up and running. However, I think that these two goals are opposed, to a certain degree. In general, it seems to me that the easier it is to get started, the harder it is to customize. Systems like Spectra (and FarCry also, I assume) are very customizable, since they're really more like toolsets than applications. Ektron - CMS 100/200/300 eMPower (I am not sure what the differences are between CMS 300 and eMPower - I didn't find that very clear from their website) I have a hard time remembering the differences between their products, too. Steve Drucker wrote a review of some (or all, I'm not sure) of these in a recent CFDJ; you might want to check that out. PaperThin - Common Spot Server NetQuest - NQContent Systems Alliance - Site Executive FarCry - Open Source - inspired by Spectra (CFMX based - more of a framework than a finished system?) Spectra - Allaire/Macromedia, now Open Source (framework) Oasis - RemoteSite Technologies (I couldn't get to their site) SparkPlug - 13amp.com For more information about some or all of these products, you might find it useful to check out www.cms-list.org. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Exam Buster - For Cert Prep
I used it for my CF5 exam last year, and it helps with getting used to the style in which the test is presented. A much better resource in general, however, is Ben Forta's exam prep book, though. It comes with a 15% off coupon against the test cost, and doubles as a great quick reference when you've passed your certification. The only downside is I've heard earlier CF cert recipients got things like gym bags and the like, and I only got a cheapo lapel pin (\me shakes fist at lousy economy). Oh well, at least the cert helped land a great job, so I can get my own gym bags. - Jim Jillian Carroll wrote: Has anybody purchased Centrasoft's CFMX Exam Buster? Did you find it to be helpful for preparing to take the certification exam? -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: re: Mach-II
Anyone knowledgeable with Mach-II that can offer a comparison with http://www.cfobjects.com ? Dan === Previous Message Below === -Original Message- From: Angus McFee [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 5:09 PM To: CF-Talk Subject: RE: RE: re: Mach-II Matt - Good to hear from a fellow fuseboxer! No, this isn't a joke, this guy clearly has a problem with what fusebox has become and has made this other framework that clearly doesn't do most of what Fusebox is capable of. I don' t think him having helped make fusebox or having been in a few books makes a huge difference. My dog has been in a few books, that doesn't mean he don't hate cats. But this really sounds like he is dissing fusebox. Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. These things aren't new and they don't do something you can't do with fusebox already. Fusebox already works in ColdFusion, PHP, ASP, JSP and Perl, and I have even seen a TCL port for the framework. In PHP, you can do all the object oriented programming you want, so I don't see why there would be a need for this mach-ii except to take away from fusebox. This guy is just one of the ones who is never going to get what it is all about. Angus McFee -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:37 PM To: CF-Talk Subject: Re: Mach-II This is a joke right? -Matt On Wednesday, July 30, 2003, at 04:08 PM, Angus McFee wrote: Hal - I've heard from plenty of people looking for a way to beat up on Fusebox, but usually they have nothing to say when it comes to building a better framework. This is the first time in a long time anyone has suggested an alternative approach, and I really don't see how any of this benefits developers. This mach-ii stuff looks like just another petty attack on Fusebox. It's pretty clear we see things differently when it comes to building Web applications. I don't know you, but I can tell you are a pretty intelligent person, so you probably have some good reasons for why you don't like or hate fusebox. What I have to ask you is: do you use fusebox? Becuase there are plenty of people who are ready to attack it anytime and don't even know ColdFusion, much less what a framework is. You will probably never be convinced about the benefits of fusebox, all I can do is disagree with you, and point out all the great things fusebox does for developers: * it separates business logic from presentation logic, making for more organized, efficent code * it gives developers a common set of rules and methods to work from, so that everyone can understand what the other people are doing on a project regardless of the size of a team * it modularizes and encapsulates code, making it easier to reuse and thus to maintain * it is self-documenting, containing a complete, inline XML standard for documenting your applications * most importantly, there are thousands and thousands of fusebox developers out there, and more and more shops are choosing to use it every day. it is close to becoming a de-facto standard, which I doubt your mach-ii 'framework' will ever be able to match Angus McFee -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:16 PM To: CF-Talk Subject: RE: RE: re: Mach-II You're right, Dave. We're not looking to be able to incorporate Fusebox 3 (or 4) with Mach-II. We think that Fusebox is a great framework for procedural programmers. (Please, God, don't let this degenerate into yet another pro/con Fusebox debate...) Mach-II, though, is meant to be a pure OO framework. Fusebox and Mach-II have in common some good software engineering principles, but are very different things. I'm really referring to (a) backwards compatibility and (b) cross-language compatibility. Hal Helms Java for CF Programmers class in Las Vegas, August 18-22 www.halhelms.com - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Preserve collection order
Hi folks, Does anyone know of a way to preserve the order of keys in a structure so that it matches the order in which it was created? i.e. I created a structure that looks like so: instance structNew(); instance[id] = structNew(); instance[id].heading = Id; instance[id].size = 50; instance[manufacturer_name] = structNew(); instance[manufacturer_name].heading = MFG; instance[manufacturer_name].size = 200; instance[name] = structNew(); instance[name].heading = Name; instance[name].size = 100; instance[parttype_name] = structNew(); instance[parttype_name].heading = Part Type; instance[parttype_name].size = 100; instance[status_name] = structNew(); instance[status_name].heading = Status; instance[status_name].size = 100; When I cfloop through it ( i.e. for ( field in instance ) {} ), I would expect it to find the id field first, then manufacturer_name, and so on and so fourth in the order in which the structure was created. Instead it loops through in this order: name,id,parttype_name,manufacturer_name,status_name I figured I'd try to trick it by doing a structKeyList() then cflooping through that, but it returns the same thing: name,id,parttype_name,manufacturer_name,status_name Does anyone know of a way to cfloop through this structure in the order in which it was created: id,manufacturer_name,name,parttype_name,status_name ? TIA! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Exam Buster - For Cert Prep
I like it. I had the 5.0 version and got upgraded to the MX. I bought it after I took my 5.0 test but was very impressed with it. The MX version seems very complete and covers everything I can think of. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:48 AM To: CF-Talk Subject: CFMX Exam Buster - For Cert Prep Has anybody purchased Centrasoft's CFMX Exam Buster? Did you find it to be helpful for preparing to take the certification exam? -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Exam Buster - For Cert Prep
I bought it... have been using it for a few months off and on as time permits... it is awesome. I have friends who used it as well, and they said it was an awesome study aid for the exam. Im taking the exam Monday my practice scores are averaging in the mid 90s. Id recommend it. Mike - Original Message - From: Jillian Carroll [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:48 AM Subject: CFMX Exam Buster - For Cert Prep Has anybody purchased Centrasoft's CFMX Exam Buster? Did you find it to be helpful for preparing to take the certification exam? -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: on-line banking
I'm going to go out on a limb and say that there's no CF-based product that does online banking. I work at the largest credit union in Arizona, specifically on our online banking system, so I've done a lot of homework on this subject. Prior to moving to ASP, we were a strictly CF house so I had a big interest in staying in the CF orbit. Developing an online banking product is a daunting task because there are tons of different core processing systems that banks and credit unions can use and each one has a different request/response method. What's more, these must generally have outstanding uptime and process high volumes of transactions. The online banking product we use is Corillian's Voyager (http://www.corillian.com/). It is ASP or ASP.NET for the front end and a huge apparatus for the back end. Since it uses a COM object to link the two sides, I suppose that a front end could be written in CF5 that would probably perform admirably. Another one that looks pretty interesting is QBT's MultiPoint. It's a Java-based middleware server that interacts with the core processor and exposes methods for a front end of any persuasion to use in generating transactions. Mind you, it's still a daunting task, but at least you wouldn't have to worry about the back end as much. Bill Brown http://www.bbrown.info/ : -Original Message- : From: Tim Laureska : Sent: 7/31/03 5:07 AM : Subject: on-line banking : : I have a bank client who now wants to jump into on-line : banking I am looking for any : suggestions/comments/references I know there are many : canned packages out there, but I'm looking for those that may : be CF based and proven. : : Developing this from scratch could be quite a chore. Feel : free to contact me off list as well : : TIA : : Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Preserve collection order
Sure, use an array. Seriously though - struct keys are not meant to be ordered. If you want it ordered, just use an array of structs. === 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: Suyer, Ed [PRD Non-JJ] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 8:55 AM To: CF-Talk Subject: Preserve collection order Hi folks, Does anyone know of a way to preserve the order of keys in a structure so that it matches the order in which it was created? i.e. I created a structure that looks like so: instance structNew(); instance[id] = structNew(); instance[id].heading = Id; instance[id].size = 50; instance[manufacturer_name] = structNew(); instance[manufacturer_name].heading = MFG; instance[manufacturer_name].size = 200; instance[name] = structNew(); instance[name].heading = Name; instance[name].size = 100; instance[parttype_name] = structNew(); instance[parttype_name].heading = Part Type; instance[parttype_name].size = 100; instance[status_name] = structNew(); instance[status_name].heading = Status; instance[status_name].size = 100; When I cfloop through it ( i.e. for ( field in instance ) {} ), I would expect it to find the id field first, then manufacturer_name, and so on and so fourth in the order in which the structure was created. Instead it loops through in this order: name,id,parttype_name,manufacturer_name,status_name I figured I'd try to trick it by doing a structKeyList() then cflooping through that, but it returns the same thing: name,id,parttype_name,manufacturer_name,status_name Does anyone know of a way to cfloop through this structure in the order in which it was created: id,manufacturer_name,name,parttype_name,status_name ? TIA! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Exam Buster - For Cert Prep
if it makes you feel better my gym bag broke in about 3 weeks time :) J -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:58 AM To: CF-Talk Subject: Re: CFMX Exam Buster - For Cert Prep I used it for my CF5 exam last year, and it helps with getting used to the style in which the test is presented. A much better resource in general, however, is Ben Forta's exam prep book, though. It comes with a 15% off coupon against the test cost, and doubles as a great quick reference when you've passed your certification. The only downside is I've heard earlier CF cert recipients got things like gym bags and the like, and I only got a cheapo lapel pin (\me shakes fist at lousy economy). Oh well, at least the cert helped land a great job, so I can get my own gym bags. - Jim Jillian Carroll wrote: Has anybody purchased Centrasoft's CFMX Exam Buster? Did you find it to be helpful for preparing to take the certification exam? -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
T-SQL division drops the decimal?
How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query output stops after 114 records
- Original Message - From: Tim Blair [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:36 AM Subject: RE: query output stops after 114 records but now that leaves me with a new problem, i cant used CFFORM Pesonally I wouldn't see that as a problem, more a blessing in disguise... ;) Tim. dammit. i wanted to say that :) charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Exam Buster - For Cert Prep
I used it for CF5 and I thought it was very helpful. One of the best thing about it are the questions are phrased in a similar fashion as the ones on the test I took (caveat, I used it for the CF5 exam). There were a lot of trick questions that required careful reading, ie, it would say something that I assumed I knew and the answer I gave was incorrect, this enabled me to realize I had to slow down during the actual test and really read the question. Probably upped my score by about 5%. Sandy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
It's the datatype of the column your holding your information in. Check the Docs for the correct datatype. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:15 AM To: CF-Talk Subject: T-SQL division drops the decimal? How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
Silly question, but what datatype is the column which holds your result? Not forgotten about it and left it as an int have you? Even if not, I'd play with the datatypes a bit, it may be your issue. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 16:15 To: CF-Talk Subject: T-SQL division drops the decimal? How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
I think it depends on the datatypes you're using as inputs to the division calculation, if they are integers then it does have problems, you could try using: (CAST(myfield AS float))/(CAST(myfield2 AS float)) if myfield1 and myfield2 are integers Alex -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 16:15 To: CF-Talk Subject: T-SQL division drops the decimal? How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ** ** * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Exam Buster - For Cert Prep
i sold my gym bag on ebay :-) wait... i never had a gym bag. - Original Message - From: John Wilker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:22 AM Subject: RE: CFMX Exam Buster - For Cert Prep if it makes you feel better my gym bag broke in about 3 weeks time :) J -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:58 AM To: CF-Talk Subject: Re: CFMX Exam Buster - For Cert Prep I used it for my CF5 exam last year, and it helps with getting used to the style in which the test is presented. A much better resource in general, however, is Ben Forta's exam prep book, though. It comes with a 15% off coupon against the test cost, and doubles as a great quick reference when you've passed your certification. The only downside is I've heard earlier CF cert recipients got things like gym bags and the like, and I only got a cheapo lapel pin (\me shakes fist at lousy economy). Oh well, at least the cert helped land a great job, so I can get my own gym bags. - Jim Jillian Carroll wrote: Has anybody purchased Centrasoft's CFMX Exam Buster? Did you find it to be helpful for preparing to take the certification exam? -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
Would it be because it's an integer? You may need to use CAST() or CONVERT(). Ade -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 16:15 To: CF-Talk Subject: T-SQL division drops the decimal? How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Preserve collection order
Hard code the list of struct keys... putting it into the structure itself might help you remember to update the list when you add a key to the struct. cfset instance[orderedKeyList] = id,manufacturer_name,name,parttype_name,status_name cfoutput cfloop list=#instance.orderedKeyList# index=i #instance[i].heading# - #instance[i].size# br / /cfloop /cfoutput -Brad -Original Message- From: Suyer, Ed [PRD Non-JJ] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:55 AM To: CF-Talk Subject: Preserve collection order Hi folks, Does anyone know of a way to preserve the order of keys in a structure so that it matches the order in which it was created? i.e. I created a structure that looks like so: instance structNew(); instance[id] = structNew(); instance[id].heading = Id; instance[id].size = 50; instance[manufacturer_name] = structNew(); instance[manufacturer_name].heading = MFG; instance[manufacturer_name].size = 200; instance[name] = structNew(); instance[name].heading = Name; instance[name].size = 100; instance[parttype_name] = structNew(); instance[parttype_name].heading = Part Type; instance[parttype_name].size = 100; instance[status_name] = structNew(); instance[status_name].heading = Status; instance[status_name].size = 100; When I cfloop through it ( i.e. for ( field in instance ) {} ), I would expect it to find the id field first, then manufacturer_name, and so on and so fourth in the order in which the structure was created. Instead it loops through in this order: name,id,parttype_name,manufacturer_name,status_name I figured I'd try to trick it by doing a structKeyList() then cflooping through that, but it returns the same thing: name,id,parttype_name,manufacturer_name,status_name Does anyone know of a way to cfloop through this structure in the order in which it was created: id,manufacturer_name,name,parttype_name,status_name ? TIA! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
Joshua, MS SQL automatically returns the type you use. Looks to me like you are dividing 2 integers. You need to cast or convert at least one of the numbers to float to get a float returned. This got to be such a pain for me that I wrote a function to do the division (MSSQL 2000). It converts both numbers to float and then checks for nulls and zero. If there is a null or zero I just return a 0.0 (due to the bus requirements here). If you want the functions, let me know. Steve -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:15 AM To: CF-Talk Subject: T-SQL division drops the decimal? How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: T-SQL division drops the decimal?
I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. you're telling sql server to divide 2 int, it returns what you asked of it, an int. i always either cast or more often simply: 1/2.0 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
on-line banking
Tim, Bill is on the money on his comments. On-line banking requires heavy iron, heavy security, lot of customization and must be fast and easy to use at the same time. There will be folks on the list that say ETradeBank uses CF -- however they use CF to connect directly to java servlets. Bill is also right when he's pointing you to more java (and .net) based solutions (Keep in mind, I'm not saying CF could not do the job-- just that security concerns will demand this product to be more robust and complex than most web applications out there-- and requiring a more customized solution!). Even on the finantial solution products I have been involved in -- there has been heavy customization, even on the off-the-shelf products. If you want to discuss this off the list please feel free to contact me using the information below. Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE I have a bank client who now wants to jump into on-line banking I am looking for any suggestions/comments/references I know there are many canned packages out there, but I'm looking for those that may be CF based and proven. Developing this from scratch could be quite a chore. Feel free to contact me off list as well TIA Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
The division operator returns an INT according to the T-SQL reference. It also says that the division operator drops the remainder. The data comes from a NUMERIC field and I'm storing the value into a VARCHAR(10) field so that's not the problem, it just drops the remainder by default. I tried one using: newcolumn = '' +mycolumn/2+ '.' +mycolumn%2+ '' This gave me an error that VARCHAR data . cannot be converted to INT, however the field that it's being inserted into is a VARCHAR(10) field. I'll try some of the CAST() CONVERT() options, thanks. 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: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:21 AM To: CF-Talk Subject: RE: T-SQL division drops the decimal? Silly question, but what datatype is the column which holds your result? Not forgotten about it and left it as an int have you? Even if not, I'd play with the datatypes a bit, it may be your issue. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 16:15 To: CF-Talk Subject: T-SQL division drops the decimal? How do others on the list deal with this? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. Any idea how to overcome this? That seems really odd if I WANTED to round I could use FLOOR() or CEILING() to round, why make it the default in T-SQL Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://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 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preserve collection order
You will need to use a different data structure. One idea is to make use of java.util.SortedMap (http://java.sun.com/j2se/1.4.1/docs/api/java/util/SortedMap.html), which is very similar to a struct except that the keys are kept in order based on a Comparator passed to the constructor. -Matt On Thursday, July 31, 2003, at 10:55 AM, Suyer, Ed [PRD Non-JJ] wrote: Hi folks, Does anyone know of a way to preserve the order of keys in a structure so that it matches the order in which it was created? i.e. I created a structure that looks like so: instance structNew(); instance[id] = structNew(); instance[id].heading = Id; instance[id].size = 50; instance[manufacturer_name] = structNew(); instance[manufacturer_name].heading = MFG; instance[manufacturer_name].size = 200; instance[name] = structNew(); instance[name].heading = Name; instance[name].size = 100; instance[parttype_name] = structNew(); instance[parttype_name].heading = Part Type; instance[parttype_name].size = 100; instance[status_name] = structNew(); instance[status_name].heading = Status; instance[status_name].size = 100; When I cfloop through it ( i.e. for ( field in instance ) {} ), I would expect it to find the id field first, then manufacturer_name, and so on and so fourth in the order in which the structure was created. Instead it loops through in this order: name,id,parttype_name,manufacturer_name,status_name I figured I'd try to trick it by doing a structKeyList() then cflooping through that, but it returns the same thing: name,id,parttype_name,manufacturer_name,status_name Does anyone know of a way to cfloop through this structure in the order in which it was created: id,manufacturer_name,name,parttype_name,status_name ? TIA! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
Thanks all for the help, this is what ended up working: icode=(CAST(tblDomReportData.rpoints AS float))/2 Very odd in my opinion, I would think that the math functions in T-SQL would be a bit more elegant than that. I suppose if T-SQL gets the value 4 irregardless of what datatype it is it always changes to INT when doing division. Bizarre. Thanks for the assistance! 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: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:53 AM To: CF-Talk Subject: Re: T-SQL division drops the decimal? I have a query that takes a value from the database and divides by 2 and inserts that value into another table, however SQL Server (T-SQL) drops the decimal place, so 1/2 of 1 is 0 according to T-SQL. you're telling sql server to divide 2 int, it returns what you asked of it, an int. i always either cast or more often simply: 1/2.0 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Preserve collection order
Ha... wish I had though of that a couple of weeks ago and would have saved myself a rewrite of existing code! Good tip! -Original Message- From: Brad Roberts Sent: 31 July 2003 16:27 To: CF-Talk Subject: RE: Preserve collection order Hard code the list of struct keys... putting it into the structure itself might help you remember to update the list when you add a key to the struct. cfset instance[orderedKeyList] = id,manufacturer_name,name,parttype_name,status_name cfoutput cfloop list=#instance.orderedKeyList# index=i #instance[i].heading# - #instance[i].size# br / /cfloop /cfoutput -Brad -Original Message- From: Suyer, Ed [PRD Non-JJ] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:55 AM To: CF-Talk Subject: Preserve collection order Hi folks, Does anyone know of a way to preserve the order of keys in a structure so that it matches the order in which it was created? i.e. I created a structure that looks like so: instance structNew(); instance[id] = structNew(); instance[id].heading = Id; instance[id].size = 50; instance[manufacturer_name] = structNew(); instance[manufacturer_name].heading = MFG; instance[manufacturer_name].size = 200; instance[name] = structNew(); instance[name].heading = Name; instance[name].size = 100; instance[parttype_name] = structNew(); instance[parttype_name].heading = Part Type; instance[parttype_name].size = 100; instance[status_name] = structNew(); instance[status_name].heading = Status; instance[status_name].size = 100; When I cfloop through it ( i.e. for ( field in instance ) {} ), I would expect it to find the id field first, then manufacturer_name, and so on and so fourth in the order in which the structure was created. Instead it loops through in this order: name,id,parttype_name,manufacturer_name,status_name I figured I'd try to trick it by doing a structKeyList() then cflooping through that, but it returns the same thing: name,id,parttype_name,manufacturer_name,status_name Does anyone know of a way to cfloop through this structure in the order in which it was created: id,manufacturer_name,name,parttype_name,status_name ? TIA! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: on-line banking
Can only speak as an user. But I happen to be a customer, and I noticed that US Bank, (www.usbank.com) Was at least at one time, was CFM based. May not be anymore. But if you could find a contact there that would talk to you, they could be quite a resource. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:07 AM To: CF-Talk Subject: on-line banking I have a bank client who now wants to jump into on-line banking I am looking for any suggestions/comments/references I know there are many canned packages out there, but I'm looking for those that may be CF based and proven. Developing this from scratch could be quite a chore. Feel free to contact me off list as well TIA Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Preserve collection order
Thanks for the feedback all! Matt, you wouldn't happen to have a snippet of CFML code you can send me for this as I've never done this, or used any kind of Java code w/in CF before. If not, no big thing. TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Querying a Text File vs An MS Access Table
I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: on-line banking
I have two accounts with local banks and they both use a mix of JSP and CGI. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:16 PM To: CF-Talk Subject: RE: on-line banking Can only speak as an user. But I happen to be a customer, and I noticed that US Bank, (www.usbank.com) Was at least at one time, was CFM based. May not be anymore. But if you could find a contact there that would talk to you, they could be quite a resource. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:07 AM To: CF-Talk Subject: on-line banking I have a bank client who now wants to jump into on-line banking I am looking for any suggestions/comments/references I know there are many canned packages out there, but I'm looking for those that may be CF based and proven. Developing this from scratch could be quite a chore. Feel free to contact me off list as well TIA Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Querying a Text File vs An MS Access Table
Here's a CFX tag that imports any type of delimited files and converts them to a CF query. It's mighty fast.. http://www.insapi.com/products/development_tools.cfm#cfx_textimport Perhaps it is something that would be useful? -Ryan -Original Message- From: B G [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:19 PM To: CF-Talk Subject: Querying a Text File vs An MS Access Table I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: on-line banking
I might also add that a site that provides on-line banking has a variety of needs and functions There are information only pages, some of which change often. There are forms, both secure and nonsecure There are worksheets/interactive apps/training. There are flashy ads and offers There are pages that display secure banking information There are pages that interact and change secure banking information There are pages that combine data from multiple incompatible back-end systems. There are user customization and preference settings Not all of these need to be handled using the same server technologies. Jerry Johnson [EMAIL PROTECTED] 07/31/03 11:50AM Tim, Bill is on the money on his comments. On-line banking requires heavy iron, heavy security, lot of customization and must be fast and easy to use at the same time. There will be folks on the list that say ETradeBank uses CF -- however they use CF to connect directly to java servlets. Bill is also right when he's pointing you to more java (and .net) based solutions (Keep in mind, I'm not saying CF could not do the job-- just that security concerns will demand this product to be more robust and complex than most web applications out there-- and requiring a more customized solution!). Even on the finantial solution products I have been involved in -- there has been heavy customization, even on the off-the-shelf products. If you want to discuss this off the list please feel free to contact me using the information below. Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE I have a bank client who now wants to jump into on-line banking I am looking for any suggestions/comments/references I know there are many canned packages out there, but I'm looking for those that may be CF based and proven. Developing this from scratch could be quite a chore. Feel free to contact me off list as well TIA Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preserve collection order
The below is a basic example. cfscript sortedMap = CreateObject(java, java.util.TreeMap); sortedMap.put(someKey, someValue); sortedMap.put(anotherKey, anotherValue); /cfscript However, you would still need to create a Comparator in Java as well as use the appropriate methods to get the keys back out in order. If you aren't comfortable with Java than this is probably not your best option. -Matt On Thursday, July 31, 2003, at 12:17 PM, Suyer, Ed [PRD Non-JJ] wrote: Thanks for the feedback all! Matt, you wouldn't happen to have a snippet of CFML code you can send me for this as I've never done this, or used any kind of Java code w/in CF before. If not, no big thing. TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: on-line banking
I can understand why a bank wouldn't want to trust their middle-tier to CF, but that doesn't mean CF is a bad option for their presentation-tier. A correctly put together Java middle-tier can be easily accessible from CF allow for a very robust, yet rapidly deployable application. -Matt On Thursday, July 31, 2003, at 10:53 AM, Bill Brown wrote: I'm going to go out on a limb and say that there's no CF-based product that does online banking. I work at the largest credit union in Arizona, specifically on our online banking system, so I've done a lot of homework on this subject. Prior to moving to ASP, we were a strictly CF house so I had a big interest in staying in the CF orbit. Developing an online banking product is a daunting task because there are tons of different core processing systems that banks and credit unions can use and each one has a different request/response method. What's more, these must generally have outstanding uptime and process high volumes of transactions. The online banking product we use is Corillian's Voyager (http://www.corillian.com/). It is ASP or ASP.NET for the front end and a huge apparatus for the back end. Since it uses a COM object to link the two sides, I suppose that a front end could be written in CF5 that would probably perform admirably. Another one that looks pretty interesting is QBT's MultiPoint. It's a Java-based middleware server that interacts with the core processor and exposes methods for a front end of any persuasion to use in generating transactions. Mind you, it's still a daunting task, but at least you wouldn't have to worry about the back end as much. Bill Brown http://www.bbrown.info/ : -Original Message- : From: Tim Laureska : Sent: 7/31/03 5:07 AM : Subject: on-line banking : : I have a bank client who now wants to jump into on-line : banking I am looking for any : suggestions/comments/references I know there are many : canned packages out there, but I'm looking for those that may : be CF based and proven. : : Developing this from scratch could be quite a chore. Feel : free to contact me off list as well : : TIA : : Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The Ongoing Saga of the Dead Session Variable
To recap: When users to our site (running CFMX (with Updater 3 applied) on top of JRun 4 (sp 1a applied) on top of Apache 2.44 with a SQL Server 2000 backend -- ew) happen to clear their cache and cookies while logged into our site, they can never log in again. I must point out that this is a newly discovered behavior, and our site has been working fine for years. Originally I thought that this error was limited to clients running IE, but I now know that clients running Netscape or any of its derivatives (Mozilla, Firebird) will have the same problem. I haven't tried Opera yet. The error is client specific, meaning that only certain users are getting the error; for other users, everything works out just fine. And again, this is new behavior. These users were getting to our site just fine. I've received some pretty good suggestions from the other members of this list, so thanks to all! Unfortunately, not much has changed, except that I've got our custom error page spitting out more info. The specific error that I've got now is this: * Parameter 1 of function IsDefined, which is now session.spanish1202d2ad76445536e6d-AFD6A182-F39D-EBCE-9A2A2E3A0ED188C5, must be a syntactically valid variable name In the actual page (which is Application.cfm), this is what the code looks like: cfif isDefined(session.spanish1#cfid##cftoken#) I don't know what could have happened to all of a sudden make this variable name syntactically invalid. I should point out that we have this same code in dozens of other places, working just fine. The only thing that has changed since when this worked properly for everyone was that our database was modified; the data from our production server was copied down to this server. But as far as I can tell, nothing else in the database has changed. We've tried clearing out the cache and cookies for the affected computers, restart their browser, restarting their computer. We have tried restarting JRun. We have tried clearing out the Java classes for the pages that JRun builds while running. We've even tried rebooting the server. None of these has helped. Any thoughts at all would be greatly appreciated. Thanks! Richard Crawford Systems Administrator UC Davis Distance Learning Group ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Querying a Text File vs An MS Access Table
Interesting, but my real question is the performance issue. With large files and simultaneous users, will using CFFILE to read the file and importing to a table choke a machine even with a good amount of RAM? BG From: Ryan Emerle [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Querying a Text File vs An MS Access Table Date: Thu, 31 Jul 2003 12:23:58 -0400 Here's a CFX tag that imports any type of delimited files and converts them to a CF query. It's mighty fast.. http://www.insapi.com/products/development_tools.cfm#cfx_textimport Perhaps it is something that would be useful? -Ryan -Original Message- From: B G [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:19 PM To: CF-Talk Subject: Querying a Text File vs An MS Access Table I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: Querying a Text File vs An MS Access Table
Also... Once the information in the file is in memory whether it's in the form of a query as produced by this cfx or in the form of a cffile action=read variable it takes up the same amount of memory on the server. Whether or not this will be an issue depends on a large number of variables. How how frequently pages are requested (number of users won't tell you this in any meaningful way), how long each page takes to process, how much physical RAM the server has and how large its swap-file is. Ideally you don't want the server using a swap file, but it happens. If you're cacheing all the data in a persistent scope, that will increase memory useage overall, although processing the data on each request will increase execution time for repeated requests, so there's some tradeoff there and you may find that one or the other works well enough to be useable at least, but not both. If it turns out that this cfx tag is fast enough to produce usable request times under load on a shared server, then as long as you can find a host who'll install it for you, you've got your answer. :) hth Isaac Original Message --- Here's a CFX tag that imports any type of delimited files and converts them to a CF query. It's mighty fast.. http://www.insapi.com/products/development_tools.cfm#cfx_textimport Perhaps it is something that would be useful? -Ryan -Original Message- From: B G [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:19 PM To: CF-Talk Subject: Querying a Text File vs An MS Access Table I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Content Management Systems - a short list...
Thanks, Matt. I will take a look at your website. It sounds like your solution would require an upgrade to CFMX, which I am not opposed to, but it would have to be coordinated with another department, as some of their apps may break. Still, it is something that I want to happen sooner or later. We do have one CFMX for J2EE license, so it's possible we could test your system out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The Ongoing Saga of the Dead Session Variable
Your cfid/cftoken pair there includes a UUID -- there's a setting in the CFMX Administrator that will enable or disable ... I believe it'd cfid as a UUID. UUID's aren't syntactically valid in something like isdefined(session.blah#createuuid()#) You have two options as I see it to fix this problem in particular. The first is to disable the UUID's as cfid's in the CFMX Administrator. The second is to replace the isdefined with this: structkeyexists(session,spahish1#cfid##cftoken#) Or you could do both... Even if you don't turn off the UUID's, I would definitely use the structkeyexists() instead of the isdefined(). I don't know if this will resolve your whole issue but I hoep it helps. :) Isaac Original Message --- To recap: When users to our site (running CFMX (with Updater 3 applied) on top of JRun 4 (sp 1a applied) on top of Apache 2.44 with a SQL Server 2000 backend -- ew) happen to clear their cache and cookies while logged into our site, they can never log in again. I must point out that this is a newly discovered behavior, and our site has been working fine for years. Originally I thought that this error was limited to clients running IE, but I now know that clients running Netscape or any of its derivatives (Mozilla, Firebird) will have the same problem. I haven't tried Opera yet. The error is client specific, meaning that only certain users are getting the error; for other users, everything works out just fine. And again, this is new behavior. These users were getting to our site just fine. I've received some pretty good suggestions from the other members of this list, so thanks to all! Unfortunately, not much has changed, except that I've got our custom error page spitting out more info. The specific error that I've got now is this: * Parameter 1 of function IsDefined, which is now session.spanish1202d2ad76445536e6d-AFD6A182-F39D-EBCE-9A2A2E3A0ED188C5, must be a syntactically valid variable name In the actual page (which is Application.cfm), this is what the code looks like: cfif isDefined(session.spanish1#cfid##cftoken#) I don't know what could have happened to all of a sudden make this variable name syntactically invalid. I should point out that we have this same code in dozens of other places, working just fine. The only thing that has changed since when this worked properly for everyone was that our database was modified; the data from our production server was copied down to this server. But as far as I can tell, nothing else in the database has changed. We've tried clearing out the cache and cookies for the affected computers, restart their browser, restarting their computer. We have tried restarting JRun. We have tried clearing out the Java classes for the pages that JRun builds while running. We've even tried rebooting the server. None of these has helped. Any thoughts at all would be greatly appreciated. Thanks! Richard Crawford Systems Administrator UC Davis Distance Learning Group ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Content Management Systems - a short list...
Our product does require CFMX for J2EE if you want ColdFusion support. If there is anything else we can specifically help you with please contact us offlist. -Matt On Thursday, July 31, 2003, at 12:25 PM, Brian Meloche wrote: Thanks, Matt. I will take a look at your website. It sounds like your solution would require an upgrade to CFMX, which I am not opposed to, but it would have to be coordinated with another department, as some of their apps may break. Still, it is something that I want to happen sooner or later. We do have one CFMX for J2EE license, so it's possible we could test your system out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4