I want to see this WAS - JSP 10X faster than CFM?
This is a great article. I'm still waiting for the article that compares .Net framework/asp.net, Java J2EE/jsp, and CFMX. I have gotten deep into .net yet, but all of the good stuff I hear about it reminds me a whole lot of java and cf. CFMX is sounding a whole lot like java as well. I'd love to read some sort of comparison article between these three technologies. What sorts of features they share, and what sorts of features are unique. If anybody has already seen one of these, I'd love to read it. Eric - Original Message - From: Rich Z [EMAIL PROTECTED] FYI, here it is: http://www.halhelms.com/index.cfm?fuseaction=writings.displayOnScreenwriting=TenReasonsCompaniesLikeJava.htm ~| 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: CF Flash (crazy idea?)
This most likely won't work because of the client's security settings. Sometimes, in outlook express I'll send web pages to coworkers for proofs. The pages that contain any sort of flash content doesn't work because of security. If somebody could get around that, then it'd probably work just fine. This idea is a great idea, but not a new one. It sounds a lot like designing forms in the Remedy admin tool, or forms in access. E - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] If you're sending it via e-mail can't you just send the HTML that embeds the SWFthat way the user can fill the form out in Flash?? ~| 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: Is there a way to test to see if a data source exists?
Couldn't you do something like this? (not exact code) cftry cfquery datasource=#DoesThisExist# select * from table where 1 = 2 /cfquery cfcatch type=Database Something broker /cfcatch /cftry Just an idea. E - Original Message - From: Stan Winchester [EMAIL PROTECTED] Is there a way to test to see if a data source exists? I am creating a setup routine where the user will enter the data source name, and I would like to check to see if it exists before using it. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a way to test to see if a data source exists?
I'm sure you would have come up with it. If this is cf 4x, you could use BenForta's connection tag that does a reg query and find the currently created dsns. I wish I knew what that was called. - Original Message - From: Stan Winchester [EMAIL PROTECTED] CF Dude, I should have thought of that; for some reason my thinking was down another path. ~| 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: Is there a way to test to see if a data source exists?
I consider the right query as an obvious, but now I do have another question. What would happen if, in this scenario, you just used an empty cfquery tag? EG : cftry cfquery datasource=#doesThisExist# /cfquery cfcatch type=database What would happen if no query was specified? /cfcatch /cftry I'd like to assume that cfServer still tries to make a physical connection before running the query. Or does it check for the existence of a query first, and then connect? Eric - Original Message - From: Jim Davis [EMAIL PROTECTED] The right query to use may different with database and connection type. For example in ODBC the message data source not found us returned and you can search for it, but this message may not come back for other drivers (such as OLE DB or JDBC). ~| 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: Is there a way to test to see if a data source exists?
That makes sense. - Original Message - From: Jim Davis [EMAIL PROTECTED] You get a no SQL specificied error - CF won't try to make a connection for no reason. 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 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: Is there a way to test to see if a data source exists?
I'm not sure why it would be an obvious - are you talking about a specific database with known tables, or just an unknown datasource? Yes. I really can't imagine anybody building a web app that will give a user the option of connecting to some random unknown datasource. Know what I mean? I would imagine that there is some sort of idea which datasources will be given as options, and appropriate actions can be taken. E ~| 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
What calendar features do people want WAS - Calendar App
I've got a calendar question. What sort of functionality do most people want in a web based calendar app? Whenever somebody brings up calendars that they've built, there is always at least a handful of people who want the code. I've built several calendar apps in different languages, but I'm trying to compile a list of features that are pretty common / requested. Any suggestions? Eric ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFSCRIPT
Have you tried using MOD instead of %? - Original Message - From: Gabriel Robichaud [EMAIL PROTECTED] and i want to use the modulus operator (or modulo, dont know what to call it in english) so i can get the remainder. I dont know what the operator is for cfscript. obvious answer is % but that doesnt work. ~| 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: What calendar features do people want WAS - Calendar App
Webguy, This is great feedback. I will take note of this. I'd love for any other feedback that may be lingering. E - Original Message - From: webguy [EMAIL PROTECTED] A good basis of a calendar design is iCal, this is what my current calendar is based on. There is a fairly easy string representations for expressing recurring patterns and recurring exceptions, timezone info. In iCal you can represent rules like ... ~| 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: Macromedia needs your feedback
What about those of us in Canada? What are we, chopped liver? :) I guess it depends who you ask, heh? ~| 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/SQL Programmer - Atlanta
Michael, Just wanted to touch base and let you know I just finished my last contract and I'm ready to work if you're still in need of a cold fusion programmer. Eric ~| 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: CF/SQL Programmer - Atlanta
sorry, wrong address ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is Flash really THAT good?
Ok, first off, that article was written years ago. Although there are probably more flash animations online than back then, Flash has still made leaps and bounds of progress. Secondly, how much DHTML have you done? Now, how much cross browser DHTML have you done? How much database driven DHTML have you done? Although it's not apples to apples, you can deliver cross browser / stand alone apps, in flash that are practically impossible in DHTML. Thirdly, if we didn't have flash, it'd be some other replacement for the animated gifs that people would be complaining about. Fourthly, I understand where you are coming from since I have heard other people say the same thing about flash. However, with a thread like this, it makes me think that you are like the others who bitch about flash yet haven't seen any flash movies worth while. Here are a few flash sites that I consider to be worth your viewing. http://www.2advanced.com/flashindex.htm http://www.egomedia.com http://www.estudio.com just about any flash site on http://www.cwd.dk http://www.homestarrunner.com/sbemail.html (had to throw this is for the humor) Just to name a few. E - Original Message - From: Jon Block [EMAIL PROTECTED] This is a bit off topic but I wanted to ask this question specifically to this audience. There seems to be a sence that Flash is this awesome platform for rich internet applications that thats where everything is going. All you hear about is how fast it is, how good looking it is, and so on. Maybe I'm the only one but Flash drives me crazy. Even though it has database connectivity, I still see it as a frustrating way to create needless animations. Maybe I'm wrong. I admit I have only got into Flash a little bit but every time I do, I end up asking myself why I am wasting my time with this tool. As application developers, do you take Flash seriously? Do you think it does or will ever make since to use it for your full blown applications? I just read over the message thread at: http://www.dack.com/web/flash_evil.html and I found it very interesting and I sort of agree with the author. He's also got an interesting usability test posted at: http://www.dack.com/web/flashVhtml/ I'm interested as to what you guys think. Thanks, 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 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: Is Flash really THAT good?
Well, call me old school, but I find these sites annoying and difficult to use. It is my firm opinion that the vast majority of web users do not care for this stuff. It is meant to impress developers, techies and managers but it is hopelessly unfriendly to the majority of users who simply want to accomplish a task on a site. Yeah, but this list is made up of developers and techies, not [EMAIL PROTECTED] Who wants aggravated customers? F*( the customer. We're not talking about customers. This is going to be hotly denounced by those who love the bleeding edge, but plain HTML (black text, white BG, blue links, no fancy DHTML) is almost always the best choice to let the user get what they want fast. Yes. Flash is like so many other technologies, it has it's place. Unfortunately, too many people see simple uses for flash, and not the good uses. At the same time, the vast majority of web users probably don't even know what flash is. They don't like popups, but they don't know that it's flash. E ~| 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: Is Flash really THAT good?
Really? Name just one UI component/paradigm that is possible in Flash that isn't possible in DHTML. The point I was making was that you can't take the EXACT same code from a DHTML app and run it in all of the browsers that support flash. With flash you can. E ~| 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: Is Flash really THAT good?
The subject was UI though. I thought the topic was Is flash really that good and Flash is evil, not flash doesn't look good. ~| 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: Is Flash really THAT good?
I could write a script that onKeyUp change the contents of an html widget fairly Hmm. I tried the following code in IE6, MOZ1.1, and Opera6 and it didn't work in Opera6 input type=Text name=test onkeyup=alert('yo'); Flash will work in all 3 browsers. DHTML - 0 FLASH - 1 E ~| 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: Is Flash really THAT good?
But - everyone just started tossing around cool and pretty sites - 2advanced etc, estudio, ego - I think these are typical of the 2000 to 2002 era.. certainly graphically inspiring - but an odd url to post for if flash is that good - the demos don't show flash being used other than pretty animations. I don't know - the insides may be powerful database driven ria's - which I wouldn't be surprised.. but on surfing that site -it's all pretty. Yes I agree completely. I was not prepared for the 'flash is bad' convo and therefore there were the only sites I could think of off the top of my head Except the ones that force full screen.. i will close the browser and refuse to visit any site that does that.. on triple monitors it is amazingly frustrating. Don't even get me started. E ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is Flash really THAT good?
Safari I wish I had a MAC to test this, but I don't. Opera + new Macromedia website??? On a pc, I went and only had a problem because I had JS turned off. File / enable Javascript got me going. I thought we were talking about flash E ~| 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: Is Flash really THAT good?
Search the archives for the complaints. The site has been changed after that and some progress has been made on making Flash work all the way on Opera and Safari, but when the Macromedia site was launched it was pretty much IE and Mozilla/Netscape only. I was not aware of that. I still think Flash has the upper hand on DHTML in most scenarios. ~| 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: Is Flash really THAT good?
F*( the customer. We're not talking about customers. Yikes! Do you develop business-related web apps? If so, double yikes! I'll stand by what I said, but only in this context only. Unfortunately, too many people see simple uses for flash, and not the good uses. Again, yikes! Simple vs. good? These are rarely opposites. They are almost always synonymous. Yes. That was poor choice of wording (just like above) on my part because I was trying to describe the constant pop-ups/downs or over web site ads that seem to be the rage right now. The never mind the customer and fancy/complicated = good mindset leads to user-unfriendly designs and--even worse from a business standpoint--lost customers. It's OK among techies, but it's horrible in the business world. Yes, the sites I submitted fall into this category, and despite my earlier customer comment, I like lists like this because I consider it mostly if not only techies. ~| 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: Is Flash really THAT good?
FMX also supports a limited amount HTML text in the movies. E - Original Message - From: Mike Chambers [EMAIL PROTECTED] I just want to make sure that everyone understands: You can have blue links in Flash. mike chambers ~| 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: Is Flash really THAT good?
How do you miss a feature that was never there? I agree though. I wish you could have custom context menus as well. E - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] That is fine and all, but what I really miss in flash is the ability to right click -- open in new window... ~| 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: Is Flash really THAT good?
People are really, really confused about what Flash can do if you have to say this. You are correct. However, this is a CF forum, and not a flash forum. E FLASH RULES ~| 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: Is Flash really THAT good?
You can control your right click behavior in DHTML, you are forced to see those menus in Flash. Custom Context Menu - DHTML - 1 FLASH - 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 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: Is Flash really THAT good?
Yeah, but so much of what Flash can do is tied into CF it is appropriate to comment on it here. Well, maybe Flash Remoting / FMX and CFMX. I would disagree that what Flash can do and CF can do are tied together. Just differing technologies. I think most people are used to seeing flash cartoons, and not flash apps. RIAs are so new that most people don't recognize them when they see them. E ~| 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: Cold Fusion Cookies
I am realtively new to Cold Fusion, but I know in ASP you can do something with a session variable. I hate to break it to you, but the session object in ASP uses cookies also. E ~| 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: SQL float format
I'm not sure what you're looking to do, but have you tried setting the precision at all? float and real Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can be precisely represented. Syntax float [ ( n ) ] Is a floating point number data from - 1.79E + 308 through 1.79E + 308. n is the number of bits used to store the mantissa of the float number in scientific notation and thus dictates the precision and storage size. n must be a value from 1 through 53. n is Precision Storage size 1-24 7 digits 4 bytes 25-53 15 digits 8 bytes The Microsoft® SQL ServerT float[(n)] data type conforms to the SQL-92 standard for all values of n from 1 to 53. The synonym for double precision is float(53). - Original Message - From: Hugo Ahlenius [EMAIL PROTECTED] Hi, I have values stored as float in an MSSQL2k table. If i store 55.5 as a value in this column, I sometimes get back 55.5000 (a lot of decimals). And sometimes 55 returns 55.0. (returns = cfquery) Any hints tips, references for some RTFM? ~| 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: Web-based telnet client?
Back in the 4.5 days I thought about using CFFILE to run telnet commands. Is this still a possibility? E - Original Message - From: Jim McAtee [EMAIL PROTECTED] Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. Thanks, Jim ~| 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: MS AD
I haven't queries the AD, but I have queried MSExch before. Hopefully the article, or links on this page will shed some light. http://www.cfcomet.com/exchange_server/ E - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| 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
OT
Does anybody have any web based bug tracking suggestions? E - Original Message - From: Charlie Griefer [EMAIL PROTECTED] check out iTeamwork.com. Fairly basic (not overly complex)...and free :) 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: conversion of Access datatypes in the query
This is from the tSql BOL, so I don't know if this will work w/Access or not. CAST ( expression AS data_type ) E - Original Message - From: Matthew Small [EMAIL PROTECTED] Hi everyone - I need to be able to convert both a datetime field and an integer field to strings in a query (for concatenation with a string field) but I can't remember how to do it. Select datetimefield + stringfield + integerfield as stringtype from table Any help? Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| 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: SQL Question - Could CF make this easier?
You could create a SPROC to do it like this. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE getDescriptions() AS SET NOCOUNT ON SELECT DISTINCT description FROM vct WHERE description NOT IN ( 'ANISE', 'APPLES', 'ASPARAGUS', 'BEETS', 'BROCCOLI' ) ORDER BY description END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO - Original Message - From: Bryan Love [EMAIL PROTECTED] sure, the IN and NOT IN clauses are much faster than using multiple ANDs, but don't transfer the load to CF - allow the DB to do what it's best at... cfquery name=qCrop datasource=common_as SELECT DISTINCT Description FROM VCT WHERE description NOT IN ('ANISE','APPLES','ASPARAGUS','BEETS','BROCCOLI') ORDER BY Description /cfquery +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:37 AM To: CF-Talk Subject: SOT: SQL Question - Could CF make this easier? I am creating a drop-down list of items, but I want to keep several items from appearing in the drop-down. Is there a more efficient way to accomplish this (there will be several more exclusions): cfquery name=qCrop datasource=common_as SELECT DISTINCT Description FROM VCT ORDER BY Description WHERE description != 'ANISE' AND description != 'APPLES' AND description != 'ASPARAGUS' AND description != 'BEETS' AND description != 'BROCCOLI' /cfquery -- 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
CFMX and JSP connections
I've got a question about CFMX and connections to datasources. It seems that CF5 was able to connect even more than previous versions. Now I'm starting to get the feeling that CFMX can only connect to datasources that Java can connect to. Can anybody clear this up for me? I was all excited about DSN-less connections in CF5, but now I'm wondering if that only works for sources that a JDBC provider exists for. Eric ~| 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 and JSP connections
DSN-less connections aren't directly supported in CFMX; apparently, either they aren't supported in JDBC at all I know for a fact that DSN-less connections are in fact supported by JSP, but I really can't comment on CFMX yet. I've noticed a lot of posts about people having connection issues when moving from CF5 to MX. I had to ask. or they aren't supported by the DataDirect JDBC drivers provided by Macromedia Didn't MM state that this was one of the new features/enhancements to RedSky? E ~| 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: SQLXML
msSql2k does have built in XML capabilities. Just search from XML in the BOL. Eric - Original Message - From: Shawn Regan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:59 PM Subject: RE: SQLXML As far as I know you don't even need Soap, At least with MS SQL2000. I believe it has a built in function that returns XML Shawn Regan -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 11:35 AM To: CF-Talk Subject: Re: SQLXML Shouldn't matter, the stuff I was reading was based off 2.0, but I installed 3.0 and it worked fine. -- jon mailto:[EMAIL PROTECTED] Monday, June 9, 2003, 2:06:27 PM, you wrote: CA John, cool stuff indeed. Do you have the SOAP toolkit 2.0 or 3.0 installed CA on the server? Does it matter? CA Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 7:38 PM To: CF-Talk Subject: SQLXML Just a quick note for anyone who hasn't gotten a chance to play with MSSQL SQLXML yet, here is snippet showing how to get SQL Server to return XML to CF. The MS SOAP Toolkit and SQLXML both need to be installed on the server before this will work. cfquery datasource=northwind name=xml SELECT Customers.CustomerID, Orders.OrderID, Customers.ContactName FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID FOR XML AUTO /cfquery cfset column = xml.columnList cfset xmlStr = '' cfloop from=1 to=#xml.recordCount# index=i cfset xmlStr = xmlStr xml[column][i] /cfloop root cfoutput#xmlStr#/cfoutput /root That's it...piece of cake. The only weird things are the name of the column that is returned by default is a bit odd, so I had to work around that, and multiple records are returned representing one xml document so they need to be concatenated. If anyone has any info on how to change that or why that is, I'm all ears. -- mailto:[EMAIL PROTECTED] CA ~| 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
switch in CFSCRIPT
Is there a way to do multiple values per case statement when doing a switch inside of a cfscript tag? cfscript switch (iAnsType){ case 6 : sAnswer = Replace(sAnswer, ,, |, ALL); case 7 : sAnswer = Replace(sAnswer, ,, |, ALL); } /cfscript EG, I was hoping to do this cfscript switch (iAnsType){ case 6, 7 : sAnswer = Replace(sAnswer, ,, |, ALL); } /cfscript Eric ~| 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: switch in CFSCRIPT
Thanks. - Original Message - From: Philip Arnold [EMAIL PROTECTED] Also, don't forget to put a break; after your code in the case So, it should be; cfscript switch (iAnsType){ case 6 : case 7 : {sAnswer = Replace(sAnswer, ,, |, ALL); break; } } /cfscript Is there a way to do multiple values per case statement when doing a switch inside of a cfscript tag? cfscript switch (iAnsType){ case 6 : sAnswer = Replace(sAnswer, ,, |, ALL); case 7 : sAnswer = Replace(sAnswer, ,, |, ALL); } /cfscript EG, I was hoping to do this cfscript switch (iAnsType){ case 6, 7 : sAnswer = Replace(sAnswer, ,, |, ALL); } /cfscript ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: csv files
Here's how I've done it before !--- Insert your query code --- cfsavecontent variable=csvText !--- Insert your loop code to generate your text --- /cfsavecontent cftry cffile action=WRITE file=#csvPath# output=#csvText# addnewline=No a href=csv/#csvName# title=Download your csv fileDownload #csvName#/a cfcatch type=Any There was a problem writing #csvText#br to a file /cfcatch /cftry -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:47 AM To: CF-Talk Subject: RE: csv files Here. Convert query and filename as you like: cfquery datasource=#application.ds# name=test select branchid, branchname from tblbranches /cfquery cfoutput query=test cfset myvar = cfloop list=#test.columnlist# index=mycol cfset myvar = myvar , evaluate(test. mycol) /cfloop cfset myvar = right(myvar, len(myvar) - 1) cffile action=APPEND file=\\yvrworptest\worp\test.csv output=#myvar# /cfoutput ~| 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: Writing Excel files
Have you checked out http://www.cfcomet.com/ yet? E - Original Message - From: Cassidy Symons [EMAIL PROTECTED] I'm looking for suggestions on the most efficient to write an XLS file via ColdFusion. I've tried COM objects (not stable enough for regular use), HTML tables being read in Excel (too slow for the quantities of data in question), and using an Excel datasource (a pain in the ass since this is based upon a dynamic query statement that could be coming from a number of different tables, with any number of columns). Is there some obvious trick I'm missing, or am I going to be pulling my hair out looking for something stable and reasonably fast. Thanks Cassidy ~| 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: SQL concat
That should work assuming your datatypes work together. HEre's another example 'The price is ' + CAST(price AS varchar(12)) You may need to break out CONVERT() instead of CAST() E - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] What's the operator for string concatenation in SQL server - I'm trying: SET txtColumnName1 = txtColumnName1 + '#form.txtFormField1#' And that's throwing me an Invalid operator for data type error. Anyone help me out right quick? Adam. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFC = .Net control
So I haven't done a lot of work w/MX yet, and only a little w/.Net. Are CFMX CFCs the equivalent of .Net's controls? E ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic connection to an excel file.
I connect to .xls files from asp from time to time, and here is the connect string that I use DBQ=c:\dir\file.xls;DRIVER={Microsoft Excel Driver (*.xls)}; As far as the ISAM driver error, I'd just double check that you're running the latest MDAC (if that applies here) E - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] Folks, On a CF 5 server I'd like to make a dynamic connection to an excel file using the dynamic query option. I have 2 issues. First, I can't seem to get the connection string right. This one seems to access the file: Driver={Microsoft Excel Driver (*.xls)}; DBQ=d:\test.xls; FIL=MSExcel; MaxBufferSize=2048; PageTimeout=5 The call to the driver is returning an error FROM the odbc excel driver that says installable ISAM could not be found. Does anyone have the proper syntax for this? Secondly, once I connect successfully - what do I use to query with? Is it sheet1 or workbook1.sheet1 or ... what? Any clues are helpful. Thanks! -Mark ~| 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: Dynamic connection to an excel file.
I forgot about this question Secondly, once I connect successfully - what do I use to query with? Is it sheet1 or workbook1.sheet1 or ... what? Any clues are helpful. Thanks! When I'm connecting from ASP I just run queries like it's a sql table. where table = Excel Named range Eric ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic connection to an excel file.
1.Select your range 2.Insert / Name / Define 3.Type the name your want 4.Click Add 5.Ok out and save your .xls I seem to remember the named ranges being a little tricky so you may need to play around with it. Eric - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 4:52 PM Subject: RE: Dynamic connection to an excel file. Dude, How do I define a named excel range? -mk -Original Message- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:10 PM To: CF-Talk Subject: Re: Dynamic connection to an excel file. I forgot about this question Secondly, once I connect successfully - what do I use to query with? Is it sheet1 or workbook1.sheet1 or ... what? Any clues are helpful. Thanks! When I'm connecting from ASP I just run queries like it's a sql table. where table = Excel Named range Eric ~| 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: xml?
Store the info in a db. If you want to do this in XML you'll most likely need to get into XSL or XSLT to transform your xml into html. I haven't done anything w/xForms yet so that may be a possibility. Eric - Original Message - From: Michael Tangorre [EMAIL PROTECTED] I have an area of an application in which users can build forms themselves, specifying a number of attributes such as table size, font color, font style, font size, form elements, etc... This gets pretty involved in that they can choose all kinds of form elements and add values and options and all that good stuff. I am currently storing all this information in a db, is this the best way to go about it? XML keeps popping into my head but I do not know enough about it to really know where and when it works... Thoughts or ideas? ~| 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: CFLOOP, through list, delimiters help
I wrote a simple email parser a while back and instead of the CHR(13) or CHR(10), I used space as my delimiter. Then what I did was look for the @ in each line. If the @ existed, I put it into my list, if it didn't, I ignored that line. Just a suggestion Eric - Original Message - From: [EMAIL PROTECTED] Help, I'm trying to extract the e-mail addresses from a text file. Here a sample of the text file and the code I have. Each line is separate by a carriage return. I forget what the symbol for the carraige return is which I need for the delimiter. Any help would be great. Ingar Bae Swnary [EMAIL PROTECTED] Ral Diaz Argentina [EMAIL PROTECTED] Cris Grass Uk [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 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: CFLOOP, almost there
Here's how I did this in the past, but it was in other web langs 1.Set block of emails into sText var 2.Split sText into array using ' ' space as delimiter 3.Loop through array 4.Check each key in array for existence of @ 5.Append each key w/@ in it to newEmailArray or newEmailList 6.Loop through (list or array) and clean up. Step 6 can be tricky because sometimes emails were surrounded with special characters, and whatnot. As far as stripping out text, I'd suggest using the MID() function Eric - Original Message - From: [EMAIL PROTECTED] Hi, I I need is some code that will strip out the e-mail address. ~| 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: CFLOOP, almost there
Aren't there any string functions that would take a string and parse out an e-mail address? I'm not aware of any parseEmail() functions that are built in, but this is just a standard text parsing task. I don't know how to deal with arrays! Sounds like you need to get your learn on! E$ ~| 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: Back Buttons
a href=javascript:history.go(-2);go back 2/a - Original Message - From: Kris Pilles [EMAIL PROTECTED] Is there away to make the back button do history -2 instead of -1 on certain pages... I am trying to bypass a form post page to return my users to where they origiannlly came from... Any ideas... Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/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: Index 55, size 33
This wouldn't happen to have anything to do with the breakpoints or selected text indexes set in cfStudio does it? Eric - Original Message - From: Richard Crawford [EMAIL PROTECTED] I received this error when browsing to a .cfm page that had previously worked (I had made one slight change to the page). Now I receive the Index 55, Size 33 error when I browse to that page. ~| 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 clarification
What is cold fusion exactly? MM's site can give you a better definition, but I always tell people that Cold Fusion is another server side web language just like ASP, PHP, JSP, etc. Granted, if you get granular it's not 'just like' the others, but IMO it was created to solve the same web problems that all of the other languages try to solve. Why use it if you already have an XSLT processor and say Tomcat running on apache? If you already know JSP, there's no need since Tomcat is the JSP container. What is it's advantages over just running Java or PHP on apache? Cold Fusion is cake to learn, but you can solve all the same problems with CF that you can with other popular languages. E ~| 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: IF File Exist
Haven't tested, but how about this? cftry cffile action=READ file=x:\your\path\yourFile.ext variable=sFile !--- I could read your file --- cfcatch type=Any OOPS, I couldn't read your file /cfcatch /cftry - Original Message - From: Paige Chandler [EMAIL PROTECTED] Hello All, How can I determine if a file exist? ~| 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: Calendar recommendations?
Designing a calendar can be tricky. Then displaying records based on a date column in a calendar can be at least twice as tricky depending on how you want to display them. Here's one that I've built in the past in ASP that connected to a db http://www.cronometric.com/arCalendar/default.asp?act=v1 I don't know how much that helps, but the screenshots may spark some ideas for you. Eric - Original Message - From: Austin Govella [EMAIL PROTECTED] My only brainstorm would be to query the db for each date on the calendar. But that'd be up to 31 queries, and that doesn't seem right. Is this the best way to populate a calendar? It seems really intensive. ~| 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: Saving CF output to Excel and comma delimited text
George, I have done two things relating to Excel and CF/ASP. 1.Write results to .csv file and then import into XL. This one is pretty simple. A.Run query B.Use CFSAVECONTENT to store the contents of your csv file C.Use CFFILE to write the contents to a .csv file 2.Use the XL ActiveX spreadsheet control in IE. This one is totally sweet, but you are restricted to IE5.5+. Basically you drop the ActiveX control into your .cfm page using the OBJECT tag and you can send the results of a query inot the spreadsheet control itself. Then, for users who have Excel installed on their computer, they can click the green XL button in the toolbar (of the control) and export it directly to excel. Option two is really cool for this specific scenario. If you'd like, I can send you a copy of the .cfm file I used way back when. Eric - Original Message - From: Earl, George [EMAIL PROTECTED] We are using CF 5.0 to generate some pretty complex report output from answer sets we return from DB2 and Oracle. One of our requirements is to allow users to save the final formatted report output to Excel and to text files on their workstations (either directly in place of sending output to the browser or after having received it in the browser). We are an inTRAnet MS shop that has standardized on MSIE 6.0 and Office XP, though we are in transition from MSIE 5.01/5.5 and Office 97 . . . I've seen and I've played with the usual cfcontent examples for dumping query results to Excel and text files and they work fine for that purpose, however we manipulate the answer sets before generating the reports and for our final formatted report output these examples fall short. I've also seen the examples (Ben Forta's WACK) for using Microsoft's Excel-HTML that Excel can import as a .xls file. I need to look at this more, but I'm concerned about the additional overhead considering the large number of reports we have. Is anyone using this MS Excel-HTML approach? What other approaches are people using to dump their HTML reports into Excel and text files? (XML is not an option for us right now . . .) Thanks! George [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: Finding parts to a string
#TRIM(sText)# should do the trick Or cfset newText = TRIM(sText) E - Original Message - From: [EMAIL PROTECTED] Hi, thanks for both your replies. Matthew, I've not tried yours yet but will do later, esp as you're a kiwi :) CF Dude, yours nearly works - except there *will* always be text after the country name. But we know there'll be a space and 3 stops, i.e. ... So how can I tell it to stop when grabbing the country name (i.e. exclude ... and anything after that point. Thanks Will This works. cfset sText = Green Acres USA cfset sNewText = Replace(sText, , |) cfset vText = ListToArray(sNewText , |) #ArrayLen(vText)#br #vText[1]#br #vText[2]#br - Original Message - From: Matthew Walker [EMAIL PROTECTED] ListToArray(sText , ) would make , n, b, s, p, and ; all delimiters. ~| 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: Learn ASP?
Oliver, I am currently doing the ASP thing as well and I highly suggest you do not pass go without first going here http://www.microsoft.com/downloads/details.aspx?FamilyId=01592C48-207D-4BE1-8A76-1C4099D7BBB9displaylang=en and downloading scrdoc56en.exe. The documentation it will install is invaluable since it contains all of the latest VBScript, JScript, etc, that you will find yourself using in ASP. Also, ASP doesn't suck, it's just a PITA. It's good that you're not CF only. While you'll find your ASP project to be a royal pain, in the end you will find yourself with more skills and most likely a better understanding of scripting in general As far as best practices, here are a few suggestions that I try to live by. 1.Use Option Explicit. Although you may find this time consuming, I can not tell you how important this is to do. 2.Use DSN-less connections with your OLEDB provider. 3.If possible, use SELECT CASE instead of multiple If Then's. SELECT CASE is the ASP equivalent of CFSWITCH 4.When debugging variables, wrapping a variable in TypeName(variable) can be so helpful. It's one of the few things I wish CF had. Even though ASP is a typeless enviornment, the data stored in a variable will still have a data type. 5.When querying a database using ADO, use the .GetRows() method of the ADODB.Recordset object. This is the fastest way to retrieve a results back from a query. In a nutshell, you will connect to your db, run the query, return the results into an ADODB.Recordset object, and then rs.GetRows() will copy the contents of your recordset into a 2d array object. Then all you have to do is deal with an array. If you are not already familiar with 2D arrays, learn them. I could probably squeeze a few more out, but I'll wait until you get into the project. If you need any further ASP assistance feel free to email me offlist. Eric - Original Message - From: Oliver Cookson [EMAIL PROTECTED] Hi, Sorry for the off-topic post but I have been thrown in the deep end and need to learn ASP for a project which will soon be landing on my desk, so I was hoping someone could recommend a book which teaches me the syntax and best practises in ASP. I can\have wrote code in CF, JSP PHP so I am not looking for a book which includes general web programming skills just specific to ASP. ~| 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 Datasource connection string
It's been a while since my JSP days, but I know for a fact that you can do DSN-less connections from JSP. I'm having a hard time finding my code but this page may offer some assistance http://forum.java.sun.com/thread.jsp?forum=48thread=137157message=369435 E - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Hey Markthere's a totally different way of doing this in MXhere's a reply to my request for the same info months ago...reply from Samual R. Neff: --- Bryan, As earlier posters stated, DSN-less connections are no longer directly supported in CFMX because they are not supported in JDBC. However, there is an easy work around. Jet (MS Access database engine) supports a special use of the IN keyword in the FROM clause of a query to specify another source database. The secondary source can be a Jet (Access) database or any Jet accessible source (Excel, DBase, Text, etc.) or any ODBC connection (dynamic connect string). To set this up create an empty Access database and then create a datasource for this database named PassThroughMDB. Then you can run queries like: cfquery name=getFromDynamicConnection datasource=PassThroughMDB SELECT * FROM some_table_in_another_db IN 'c:\wherever\other_database.mdb' /cfquery You can experiment with paths to an MDB, XLS, etc. or you can use an ODBC connect string. To use ODBC I believe you have prepend it with ODBC; as in FROM wherever IN 'ODBC; [dynamic odbc connect string]' See MS Access help for more information. You can also view some examples in MSDN Library. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm l/acsqlINX.asp Another option is to create linked tables in the Access database. I know you can do this with DAO, and you may be able to do it with some combination of ADOX/JRO or even with DDL through CFQUERY. If using MSSQL or Oracle (and if so why would you need a dynamic connect string?) you can use linked databases (perhaps they use a different term, but the concept exists in both). Good luck! Sam Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 11:35 AM Subject: CFMX Datasource connection string I just recently converted a shared site at an ISP from CF5 to CFMX. With CF5 I used a DSN-less connection string to connect to a SQL2000 shared db. Now, as I know, CFMX won't accept DSN-less strings. Problem is, I don't know how to plug in the parameters into a CFQUERY. Specifically, where do I put the network connection string that the ISP supplies? I notice that since its left off in my CFMX query statements, performance in doing a query is extremely slow (because the query is looking all over the network for my db). The DSN string supplied to me to use is as follows: dsn=abcd;uid=myUserID;pwd=myPassword;network=dbmssql Here's my cfquery statement: cfquery name=qProduct datasource=abcd username=myUserID password=myPassword This works, albeit slow. So what setting do I use to point to the network? There's so many Cfquery parameters that are deprecated in CFMX I'm at a loss of what to do. Thanks, Mark ~| 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: Finding parts to a string
If I'm reading this correctly, you've got sText and you want to get sPart1 and sPart2 where your delimiter will always be nbsp; If you will always have that same delimiter, you can split sText into an array using ListToArray(list [, delimiter ]) EX : cfset sText = Green Acres nbsp; USA cfset vStuff = ListToArray(sText , nbsp;) Then you've got yourself an array you can use. cfset sPart1 = vStuff[1] cfset sPart1 = vStuff[2] (Forgive me if my cf array syntax is wrong, I'm deep in ASP hell right now) Hope this helps! Eric PS to everyone : I consider RegEx to be like a super power. However, I also find great joy in simple suggestions like this that do cause my brain to melt when writing RegEx. - Original Message - From: W Luke [EMAIL PROTECTED] I'm inserting into a DB a block of text such will always have ,nbsp; appended after it. What I'd like to do is take out Green Apples (or whatever it might be), and the country name (again, wherever it is), and dump them into a var. What function should I be looking at? ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Finding parts to a string
Sun of beach!! There's got to be a way to split it up using nbsp; as a literal. E - Original Message - From: Matthew Walker [EMAIL PROTECTED] ListToArray(sText , nbsp;) would make , n, b, s, p, and ; all delimiters. ~| 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: Finding parts to a string
This works. cfset sText = Green Acres nbsp; USA cfset sNewText = Replace(sText, nbsp;, |) cfset vText = ListToArray(sNewText , |) #ArrayLen(vText)#br #vText[1]#br #vText[2]#br - Original Message - From: Matthew Walker [EMAIL PROTECTED] ListToArray(sText , nbsp;) would make , n, b, s, p, and ; all delimiters. ~| 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: CF Array to stored procedure
Does ORA sprocs even support arrays? I know msSql server doesn't. E - Original Message - From: BOUDOT, Christian [EMAIL PROTECTED] Hi, Does anyone know how to pass a Cold Fusion Array (2 dimension) to an Oracle stored procedure? Many 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
Why XHTML in cftags WAS - XHTML syntax (self-closing tags)
I don't understand why you would decide to XHTML-ize your cftags when cftags are server side. EG : br / is client side and is xhtml cfset foo = bar = cfset foo = bar / with the exception being you are typing more than you need to. Did I misunderstand the original post? Eric Oh yeah, instead of cfdump var=#session# /, why don't you do this ? cfdump var=session - Original Message - From: Charlie Griefer [EMAIL PROTECTED] OK...i like to keep consistent, so I've started doing things likse cfset foo = bar / etc. Certain tags tho, will display twice (eg cfdump var=#session# /). So here's an exception to the rule (the consistency that I was striving to maintain begins to break down). Furthermore, it has me wondering if cfset foo = bar / actually sets the variable twice. Obviously, not an issue as far as the value of the variable, but certainly not terribly efficient. Is anybody actively/currently using this syntax? Any definitive answer on whether or not cfset / executes twice? ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why XHTML in cftags WAS - XHTML syntax (self-closing tags)
I certainly agree with that, but I still find it to be un-needed. Especially if you are able to seperate most of your CF code from your xHtml code. Just my two cents E - Original Message - From: Sean A Corfield [EMAIL PROTECTED] So that the mix of HTML and CFML in your source file is consistent (and attempts to be XHTML styled). If you get into the habit and closing all tags, you're less likely to write HTML that isn't XHTML, IMO. ~| 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