RE: why is cf_builder so expensive?

2011-01-26 Thread Andrew Scott
First I would like to say that I am the type of person that relies on a good product to do my work with, CFBuilder is not a great product and it has huge potential. Would I say it is worth the price tag, no I would not and others might find that the tool is giving them the productivity that they

RE: Session variables security

2011-01-26 Thread Andrew Scott
No I haven't used it, and I am in a closed environment where I don't need to worry about these things to much. However, I brought it up because some people find that it would cost them more to try to match the features, than to actually buy it. Regards, Andrew Scott http://www.andyscott.id.au/

Re: favorite coldfusion host

2011-01-26 Thread Mike Chabot
The hosting provider question seems to come up every few weeks, even though there are hundreds, possibly thousands, of answers to this question in the House of Fusion mailing list archives. If I had to make a guess at the three most popular topics on this mailing list I would say: 1.

Re: why is cf_builder so expensive?

2011-01-26 Thread Mike Chabot
I am surprised that nobody has really tried to say why cf builder is so good likes it features. in other words, nobody has really provided a good reason as to why should I invest in it. I think this is because this topic has been discussed to death on mailing lists, forums, blogs, conferences,

RE: Clustering ColdFusion - some black holes

2011-01-26 Thread Helge Hetland
Thanks Dave, Good to know for sure that the way we've done it is the correct way. With that uncertainty out of the mind I can focus on the LB unit and see if there's problems there. Thanks again Regard, Helge -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent:

Re: favorite coldfusion host

2011-01-26 Thread Russ Michaels
When looking for a host here are a few tips. DO NOT use host review sites, nearly all are scams. http://hosting-reviews-exposed.com Here are a couple of sites with host reviews which are trustworthy and contain real reviews. http://www.forta.com/cf/isp/ www.brownbook.net If a host has

Re: favorite coldfusion host

2011-01-26 Thread Michael Firth
Thought I was being filtered there russ. I think I am going to go with hostek but thanks for all the input everybody save for the few negatives. On Jan 26, 2011 6:02 AM, Russ Michaels r...@michaels.me.uk wrote: When looking for a host here are a few tips. DO NOT use host review sites,

Re: why is cf_builder so expensive?

2011-01-26 Thread Raymond Camden
I'll also add that you will not hear from people when a product works. You _will_ hear when it doesn't work. On Tue, Jan 25, 2011 at 9:13 PM, Sean Corfield seancorfi...@gmail.com wrote: On Tue, Jan 25, 2011 at 7:05 PM, Michael Firth mfsqlser...@gmail.com wrote: Based on the feedback I am

Re: why is cf_builder so expensive?

2011-01-26 Thread Raymond Camden
On Wed, Jan 26, 2011 at 2:21 AM, Andrew Scott andr...@andyscott.id.au wrote: Personally I find that the features that would make me more productive, have the most bugs that well let's say are not fixed and look like might not being fixed in the next release, I am not holding my breath, because

Re: why is cf_builder so expensive?

2011-01-26 Thread Stephane Vantroyen
My 50 cents : I've been working with CFBuilder for about 6 months now (coming from homesite++, hard to let this one go...) and I will honestly say that it is a very good product, with some lacks or some problems (from time to time), but with great functionalities as well. It helps me to work

Re: favorite coldfusion host

2011-01-26 Thread Greg Morphis
You forgot Is Coldfusion dying/is dead? On Wed, Jan 26, 2011 at 3:20 AM, Mike Chabot mcha...@gmail.com wrote: The hosting provider question seems to come up every few weeks, even though there are hundreds, possibly thousands, of answers to this question in the House of Fusion mailing list

Re: favorite coldfusion host

2011-01-26 Thread Will Tomlinson
Curious to see what everybody's favorite coldfusion host is also? Hostek? CrystalTech? DailyRazor? + 1 Viviotech. I feel much better knowing those guys have my back. I have two VPS's with them. One for my Railo, one for my Database. No, it isn't discount-cheap-fast food hosting. You

Re: why is cf_builder so expensive?

2011-01-26 Thread Casey Dougall
On Wed, Jan 26, 2011 at 7:01 AM, Raymond Camden rcam...@gmail.com wrote: While I've not heard any firm dates, nor do I expect to, I'd like to know where you get this 'CFX is 3 years away' statement. Did Adam say this? Did anyone at Adobe say this? If I buy CFBuilder today and a new one

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
I just finished downloading the trial and getting ready to dive in! I will save my first impressions, but I am VERY IMPRESSED that Adobe offers a 60 day trial, which is more than enough time to get to know my new buddy. I am going to be very interested to see how it builds on Eclipse and

Re: why is cf_builder so expensive?

2011-01-26 Thread Russ Michaels
It would be nice if CFBuilder came bundled with Creative Suite as homesite was. It is a good product, but I don't do enough dev work these days to warrant spending $300, DW does the job for me. On Wed, Jan 26, 2011 at 1:36 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Wed, Jan

Re: favorite coldfusion host

2011-01-26 Thread Jason Fisher
I've been happy with CrystalTech or NewTek ... whatever they're called now. Definitely agree on HMS / Hosting.com ... did *not* have good experiences with them. From: Sean Corfield seancorfi...@gmail.com Sent: Tuesday, January 25, 2011 9:53 PM To:

RE: why is cf_builder so expensive?

2011-01-26 Thread DURETTE, STEVEN J (ATTASIAIT)
One note on the student edition of CFBuilder, it is the only one that *requires* that you will be taking a course in ColdFusion at the college to get the free version. I applied for it a couple of times before I noticed that. Steve -Original Message- From: Dave Watts

Re: favorite coldfusion host

2011-01-26 Thread Gerald Guido
+ 1 Viviotech. +1 godzillion. I feel much better knowing those guys have my back. The *do* have your back. Good to know that others feel the same way. No, it isn't discount-cheap-fast food hosting. You get what you pay for though. Absolutely. And worth every penny and them some. G! On

Re: why is cf_builder so expensive?

2011-01-26 Thread Raymond Camden
Be sure to check out the Extensions library at RIAForge: http://www.riaforge.org/index.cfm?event=page.categoryid=14 49 free and open source tools like var scoping and query param scanning. On Wed, Jan 26, 2011 at 7:41 AM, Michael Firth mfsqlser...@gmail.com wrote: I just finished

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
Thanks for the information Steve and for providing the correct information contrary to the info provided by the CTO below. I am happy that they give you 60 days to try it out though. I was thinking the trial would only be 30 days. On Jan 26, 2011, at 9:12 AM, DURETTE, STEVEN J (ATTASIAIT)

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
Kool. Feel like a kid in a candy store with all these goodies. The Application CFC generator and CFC Hint Checker especially look yummy. On Jan 26, 2011, at 9:25 AM, Raymond Camden wrote: Be sure to check out the Extensions library at RIAForge:

RE: why is cf_builder so expensive?

2011-01-26 Thread Eric Roberts
I think we need to move where you guys live...if you can be so flippant about $300, pay must be pretty awesome there... What I wish they would do is offer a version without flash for less. I don't ever do flash, so bundling it isn't much of a perk to me. Eric -Original Message- From:

RE: why is cf_builder so expensive?

2011-01-26 Thread DURETTE, STEVEN J (ATTASIAIT)
Please don't take my response as being anything against Dave. I was just making a statement about what I found out through trial and error. I have a lot of respect for Dave. He takes the time to help out many people here on the list. His varied experience with ColdFusion has made him one of the

Re: why is cf_builder so expensive?

2011-01-26 Thread Raymond Camden
Who is being flippant? It's a fact of life that some developer tools cost money. That isn't unusual, it is a fact of life. I was going to say just us developers, but I'm sure in most industries there are tools you end up having to pay for to help you get your job done. On Wed, Jan 26, 2011 at

Re: why is cf_builder so expensive?

2011-01-26 Thread Jeffrey Battershall
Having used CFEclipse extensively not to mention CF Studio/Homesite and some DW, I have to say that CF Builder is well worth the investment, so much so that it's not even close. Having FB Standard bundled is nice but not essential to making Builder worth the money. Now that I'm acclimated to

Re: favorite coldfusion host

2011-01-26 Thread Kelly
If you're going to host on Hostek's shared servers be aware they do have issues with slowness and downtime. At least they did when I was there. But at $5 a month ( actually $25 but that gets you 5 sites - that's the plan I was on ) you get what you pay for, if you're willing to pay for the

Re: favorite coldfusion host

2011-01-26 Thread Kelly
Agreed! They ROCK! I think their prices are great considering the support and quality. I've paid more elsewhere for crappy service in one way or another. On 1/26/2011 8:27 AM, Will Tomlinson wrote: Curious to see what everybody's favorite coldfusion host is also? Hostek? CrystalTech?

Re: why is cf_builder so expensive?

2011-01-26 Thread Kelly
I'm sure there are plenty self employed graphic designers that wish Photoshop and Illustrator would be free too. LOL Regarding CFBuilder, all it really takes is scoring a very small website on the side and it's paid for w/ cash left over. :) I know easier said than done for some. On 1/26/2011

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
No it isn't anything against Dave, but to be honest I found his comments directed at me bothersome. I was just merely stating your information was the correct one thats all. I myself have nothing against Mr. Watts. On Jan 26, 2011, at 9:38 AM, DURETTE, STEVEN J (ATTASIAIT) wrote:

Re: favorite coldfusion host

2011-01-26 Thread Michael Firth
Actually I chose the 7.95 because SQL Server is part of my skill set. I do hope there isn't any downtime, but at least I only signed up for the monthly just in case. Never know until one tries though. On Jan 26, 2011, at 9:45 AM, Kelly wrote: If you're going to host on Hostek's shared

Re: why is cf_builder so expensive?

2011-01-26 Thread Gerald Guido
Who is being flippant? It's a fact of life that some developer tools cost money. Going out on a limb here It is all relative. Good tools cost do cost good money. But For some here, $300 is chump change. For others, even the gainfully employed, that could mean making a car or mortgage

Re: why is cf_builder so expensive?

2011-01-26 Thread Debbie Morris
Agreed. Pretty much everything else is included in the Master Collection (I wasn't even aware I had Flash Builder after my CS5 upgrade!), so why not CFBuilder as well? Deb It would be nice if CFBuilder came bundled with Creative Suite as homesite was. It is a good product, but I don't do

Re: why is cf_builder so expensive?

2011-01-26 Thread Eric Cobb
about as nimble as a mastodon in a tar pit That cracked me up! Good one! Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com On 1/26/2011 9:02 AM, Gerald Guido wrote: Who is being flippant? It's a fact of life that some developer tools cost money.

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Grant
You forgot Nadel. Also I +1 the Watts comment. He's a juggernaught of cf help goodness. On Wed, Jan 26, 2011 at 9:38 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Please don't take my response as being anything against Dave. I was just making a statement about what I found out

RE: why is cf_builder so expensive?

2011-01-26 Thread DURETTE, STEVEN J (ATTASIAIT)
Yeah I forgot Nadel, Camden and others. I was just trying to do it quickly. -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, January 26, 2011 10:19 AM To: cf-talk Subject: Re: why is cf_builder so expensive? You forgot Nadel. Also I +1 the Watts

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
Sounds like Dave is a standup guy. Yet, somehow his messages directed at me still bother me. I am sure he's professional blah blah etc etc, but he did come off somewhat arrogant and did not really leave a good first impression. I am sure I am in the minority though given that he has somewhow

Re: why is cf_builder so expensive?

2011-01-26 Thread Dave Watts
I think we need to move where you guys live...if you can be so flippant about $300, pay must be pretty awesome there... It's not a matter of being flippant. If you want to do .NET development, you'll probably end up buying Visual Studio. If you want to do any sort of development, you'll end up

Re: why is cf_builder so expensive?

2011-01-26 Thread Dave Watts
Sounds like Dave is a standup guy.  Yet, somehow his messages directed at me still bother me. I am sure he's professional blah blah etc etc, but he did come off somewhat arrogant and did not really leave a good first impression.  I am sure I am in the minority though given that he has

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
One can see both sides, but one has to remember cost of living varies by location and if your unemployed and you have to choose between feeding your family and buying cfbuilder that choice is simple. Sometimes a one fit all argument is not always the case and no not everybody has an Xbox

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
Dave, The list is called ColdFusion. As to the other stuff its not even worth responding to because while you may be honest its not realistic either. Mike On Jan 26, 2011, at 10:33 AM, Dave Watts wrote: Sounds like Dave is a standup guy. Yet, somehow his messages directed at me still

Re: why is cf_builder so expensive?

2011-01-26 Thread Scott Stroz
On Wed, Jan 26, 2011 at 10:40 AM, Michael Firth mfsqlser...@gmail.com wrote: Dave, The list is called ColdFusion.  As to the other stuff its not even worth responding to because while you may be honest its not realistic either. Was Dave's response unrealistic, or was it just not what you

Re: why is cf_builder so expensive?

2011-01-26 Thread Casey Dougall
On Wed, Jan 26, 2011 at 9:09 AM, Eric Roberts ow...@threeravensconsulting.com wrote: I think we need to move where you guys live...if you can be so flippant about $300, pay must be pretty awesome there... What I wish they would do is offer a version without flash for less. I don't ever

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
Its unrealistic because he's trying to see things in black and white, which is not always the case. I just think that sometimes you need to take a second, take a look around and see what is really like for others in the world. It happens to the best of us. Mike On Jan 26, 2011, at 10:45

Re: why is cf_builder so expensive?

2011-01-26 Thread Wil Genovese
about as nimble as a mastodon in a tar pit ColdFusion Builder without the Update resembled that remark that's for sure. My blog post about CFB the day it was released was less that glowing. However, since the update CFB is much better and that prompted me to buy CFB on faith that I would

Re: why is cf_builder so expensive?

2011-01-26 Thread Dave Watts
One can see both sides, but one has to remember cost of living varies by location and if your unemployed and you have to choose between feeding your family and buying cfbuilder that choice is simple.  Sometimes a one fit all argument is not always the case and no not everybody has an Xbox

Re: CF9 Service Randomly Restarting

2011-01-26 Thread Jared Conti
Hey Dave, We had this problem on CF8. CF had been restarting on an almost daily basis. After much more research, we added the -Xint option to the JVM settings. This forces the JVM to run in interpreter mode and disables the Hotspot compiler. This hotspot compiler was causing the JVM to crash

Re: why is cf_builder so expensive?

2011-01-26 Thread Wil Genovese
If you're a plumber/carpenter/mechanic/handyman, you can spend a LOT on tools. That's just the way things are. A friend of mine is a diesel mechanic. You do not want to know what he had to pay for tool just to get hired! Plus he has to drive a big truck that is capable of hauling those

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
Another one for the pro and yes he has a job lol On Jan 26, 2011 10:53 AM, Wil Genovese jugg...@trunkful.com wrote: about as nimble as a mastodon in a tar pit ColdFusion Builder without the Update resembled that remark that's for sure. My blog post about CFB the day it was released was less

RE: Custom Tags, cf_location

2011-01-26 Thread Mark A. Kruger
Dave... don't encourage him!!! He had already moved on to something else (doh!). -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, January 25, 2011 8:26 PM To: cf-talk Subject: Re: Custom Tags, cf_location That fails to address OP's question.  Instead,

RE: favorite coldfusion host

2011-01-26 Thread Mark A. Kruger
+1 ! Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: Tuesday, January 25, 2011 8:48 PM To: cf-talk Subject: Re: favorite

RE: why is cf_builder so expensive?

2011-01-26 Thread Mark A. Kruger
Kelly yeah - I'll get you a license (sigh) -Original Message- From: Kelly Matthews [mailto:ke...@webdiva.org] Sent: Tuesday, January 25, 2011 10:04 PM To: cf-talk Subject: Re: why is cf_builder so expensive? I'd agree. I mean if my employer is willing to pay for my copy once my

Re: Custom Tags, cf_location

2011-01-26 Thread Michael Firth
Wow. Looks like even Homer Simpson joined this conversation. Seriously, do you think you can manage to be somewhat professional lol? If somehow I manage to upset you, I don't think that everybody has to hear about it, do they? On Jan 26, 2011, at 11:01 AM, Mark A. Kruger wrote: Dave...

RE: why is cf_builder so expensive?

2011-01-26 Thread Mark A. Kruger
I use homesite for quick checking, code reviews, commenting etc I spend a lot of time popping in and out of various code for maybe 10, 12 sites or projects a day. An eclipse based product might make that a tad challenging. But for serious coding I use cfeclipse and save my cfbuilder licenses

Re: why is cf_builder so expensive?

2011-01-26 Thread Casey Dougall
On Wed, Jan 26, 2011 at 11:09 AM, Mark A. Kruger mkru...@cfwebtools.comwrote: Kelly yeah - I'll get you a license (sigh) reseller? got a link ;-) ~| Order the Adobe Coldfusion Anthology now!

Re: why is cf_builder so expensive?

2011-01-26 Thread Roger Austin
Die thread, die, die, die, ... -- LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Blog: http://rogerthegeek.wordpress.com/ http://www.misshunt.com/ Home of the Clean/Dirty Magnet

Re: why is cf_builder so expensive?

2011-01-26 Thread K-Sea - dvsDJTV.com
On Wed, Jan 26, 2011 at 11:15 AM, Roger Austin raust...@nc.rr.com wrote: Die thread, die, die, die, ... -- LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Blog: http://rogerthegeek.wordpress.com/ http://www.misshunt.com/ Home of the

Re: why is cf_builder so expensive?

2011-01-26 Thread Kelly
Yay! :) On 1/26/2011 11:09 AM, Mark A. Kruger wrote: Kelly yeah - I'll get you a license (sigh) -Original Message- From: Kelly Matthews [mailto:ke...@webdiva.org] Sent: Tuesday, January 25, 2011 10:04 PM To: cf-talk Subject: Re: why is cf_builder so expensive? I'd agree.

Re: Custom Tags, cf_location

2011-01-26 Thread John M Bliss
Huh? I don't think I was a bad actor in this thread, was I? On Wed, Jan 26, 2011 at 10:01 AM, Mark A. Kruger mkru...@cfwebtools.comwrote: Dave... don't encourage him!!! He had already moved on to something else (doh!). -Original Message- From: Dave Watts

RE: why is cf_builder so expensive?

2011-01-26 Thread Mark A. Kruger
Tut tut my boy... you are the standard to which we all aspire... have a cigar! -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, January 26, 2011 9:34 AM To: cf-talk Subject: Re: why is cf_builder so expensive? I don't know about all this godlike status

Re: Custom Tags, cf_location

2011-01-26 Thread WebSite CFTalk
I absolutely agree with you on that. Now I really hope that you're in the everybody group... Bye Helge Den 26. jan. 2011 kl. 17:14 skrev Michael Firth mfsqlser...@gmail.com: Wow. Looks like even Homer Simpson joined this conversation. Seriously, do you think you can manage to be

Re: why is cf_builder so expensive?

2011-01-26 Thread Michael Firth
Maybe this will help in that I am withdrawing from any future discussion because it would seem some are getting rather upset lmao. So in the spirit of professional courtesy let the builder die a glorious death! There can only be one.

RE: Custom Tags, cf_location

2011-01-26 Thread Mark A. Kruger
Not you john no... .sorry... I'm catching up.. it was for he-who-must-not-be-named -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, January 26, 2011 10:11 AM To: cf-talk Subject: Re: Custom Tags, cf_location Huh? I don't think I was a bad actor

Re: favorite coldfusion host

2011-01-26 Thread Cameron Childress
On Wed, Jan 26, 2011 at 12:05 AM, Mike Kear afpwebwo...@gmail.com wrote: What sorts of questions do you expect a hosting company to be knowledgeable about and willing to help you with (aside from specific hosting questions of course)? A few things I have seen hosting companies have trouble

Re: Custom Tags, cf_location

2011-01-26 Thread Michael Firth
Me thinks someone needs to step away from the cubicle. Too funny. On Jan 26, 2011, at 11:19 AM, Mark A. Kruger wrote: Not you john no... .sorry... I'm catching up.. it was for he-who-must-not-be-named -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com]

Re: Custom Tags, cf_location

2011-01-26 Thread Kelly
Cubicle? I'm doubting that. lol On 1/26/2011 11:30 AM, Michael Firth wrote: Me thinks someone needs to step away from the cubicle. Too funny. On Jan 26, 2011, at 11:19 AM, Mark A. Kruger wrote: Not you john no... .sorry... I'm catching up.. it was for he-who-must-not-be-named

Return boolean from a CFC query

2011-01-26 Thread Adam Bourg
Here's what I'm trying to do. I'm building a module that only our Professional Staff can access, I am trying to identify where the person logged in is a pro staff member or a student staffer. When they log into our CMS, there is a session variable that returns their profile id. it is:

Anyone working with websites and RETS 2 data system for Real Estate?

2011-01-26 Thread Rick Faircloth
One of the vendors from whom I've been getting a regular FTP feed for the last 3 years has just notified me that they are switching to RETS at the end of February. I've done some reading on RETS (especially 2.0) and have some basic understanding, but I'm trying to figure out *exactly* where I,

Re: Return boolean from a CFC query

2011-01-26 Thread Michael Firth
Switch the following line in your query profileID = #Session.Profile.profileID# Also, you may want to consider transferring the session into a local variable to be more flexible with your function call Mike On Jan 26, 2011, at 12:47 PM, Adam Bourg wrote: Here's what I'm trying to do. I'm

Re: Return boolean from a CFC query

2011-01-26 Thread Kelly
So the query comes back with no results if it's a student? Why not do something like? cfif isStudentEmployee.recordcount eq 0 cfreturn true cfelse cfreturn false /cfif On 1/26/2011 12:47 PM, Adam Bourg wrote: Here's what I'm trying to do. I'm building a module that

Re: Return boolean from a CFC query

2011-01-26 Thread Michael Firth
I also want to add when you run a cfc page with a query sometimes when you get an error a blank page will occur without any error information. On Jan 26, 2011, at 12:47 PM, Adam Bourg wrote: Here's what I'm trying to do. I'm building a module that only our Professional Staff can access,

Re: Return boolean from a CFC query

2011-01-26 Thread Kelly
Yep this is true - a cftry/cfcatch helps or just run the query outside of the cfc to see if it's throwing an error. On 1/26/2011 1:03 PM, Michael Firth wrote: I also want to add when you run a cfc page with a query sometimes when you get an error a blank page will occur without any error

Re: Return boolean from a CFC query

2011-01-26 Thread Michael Firth
Kelly is right with the cftry and cfcatch. If you change your query like this it should correct your bug I am thinking because when you write a query the database field has to be on the left. TSQL doesnt know what a session variable is. cfquery datasource=#DSN# name=isStudentEmployee

RE: Return boolean from a CFC query

2011-01-26 Thread Russ Michaels
Sorry if I am repeating what anyone else has said, I didn't read the rest of the thread. If you catch errors inside the CFC using try/catch you can then return then in your return struct to inform your calling page that there was an error. e.g. cfset Foo = MyCFC.method(vars) cfif

Re: Return boolean from a CFC query

2011-01-26 Thread Charlie Griefer
Got a few questions about your CFC method... 1) where is the variable DSN coming from? 2) Should your WHERE be: WHERE profileID = #session.profile.profileID# ? (essentially the reverse of what you have) 3) consider using cfqueryparam in your SQL when using dynamic values (yeah, I know... that's

Re: why is cf_builder so expensive?

2011-01-26 Thread Jeffrey Battershall
Michael, I know what it is to be broke, supporting a family of 7 and not be able to afford software to do my job. I remember coding CF 3.1 in Notepad. I remember re-setting my PC's time so I could get more time on my 30 day trial of Front Page when I was just starting out. Until software

Re: Return boolean from a CFC query

2011-01-26 Thread Alan Rother
Kelly is right with the cftry and cfcatch. If you change your query like this it should correct your bug I am thinking because when you write a query the database field has to be on the left. TSQL doesnt know what a session variable is. MSSQL doesn't care if the field is on the left or the

checking CFAdmin mappings from CF log files

2011-01-26 Thread Don
Hi all. I have a requirement to check any and all mappings within the CFAdmin but do not have access to the CF Admin. Would anyone know how to retrieve them from the log files ( as I do have access to these ) or maybe another method?

Re: Return boolean from a CFC query

2011-01-26 Thread Michael Firth
Alan wrote: MSSQL doesn't care if the field is on the left or the right, it's just running a comparison against the statement. Gotta say thats a first and I have been doing mssql for ten years. I am telling you this is what is causing his error because tsql is not as flexible as you think

Re: checking CFAdmin mappings from CF log files

2011-01-26 Thread Kelly
Depends on the version I believe? There are xml files w/ this info - possibly neo-runtime.xml? In the lib folder, at least for CF 9. On 1/26/2011 1:18 PM, Don wrote: all mappings ~| Order the Adobe Coldfusion Anthology

Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Adam Bourg
I solved it with the first couple of posts help. New code: cffunction name=isStudentEmployee returntype=boolean hint=Method to determine if the person logged in is a student or pro staffer, will corelate to a control structure if student employee throw up access denied

Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Kelly
Awesome! :) On 1/26/2011 1:31 PM, Adam Bourg wrote: I solved it with the first couple of posts help. New code: cffunction name=isStudentEmployee returntype=boolean hint=Method to determine if the person logged in is a student or pro staffer, will corelate to a control structure if

Extracting a date from a string

2011-01-26 Thread Monique Boea
Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 - 10/27/2010* ~| Order the Adobe Coldfusion Anthology now!

Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Charlie Griefer
On Wed, Jan 26, 2011 at 11:31 AM, Adam Bourg adam.bo...@gmail.com wrote: I solved it with the first couple of posts help.      cfif isStudentEmployee.recordcount eq 0          cfreturn true      cfelse          cfreturn false      /cfif Glad you got it working. You can tighten that

Re: Extracting a date from a string

2011-01-26 Thread Kelly
which date? will both dates always be identical? Or will it sometimes be a range? Would you need to extract one or both? On 1/26/2011 1:41 PM, Monique Boea wrote: Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 -

Re: Extracting a date from a string

2011-01-26 Thread Alan Rother
How consistent is the first part of the string? *Department Summary by Employee Is it ALWAYS that exact string? On Wed, Jan 26, 2011 at 11:43 AM, Kelly webd...@gmail.com wrote: which date? will both dates always be identical? Or will it sometimes be a range? Would you need to extract

Re: Extracting a date from a string

2011-01-26 Thread Monique Boea
The first one is fine and not a range but it won't be the same all of the time. On Wed, Jan 26, 2011 at 1:43 PM, Kelly webd...@gmail.com wrote: which date? will both dates always be identical? Or will it sometimes be a range? Would you need to extract one or both? On 1/26/2011 1:41 PM,

Re: Extracting a date from a string

2011-01-26 Thread Monique Boea
Yes. On Wed, Jan 26, 2011 at 1:44 PM, Alan Rother alan.rot...@gmail.com wrote: How consistent is the first part of the string? *Department Summary by Employee Is it ALWAYS that exact string? On Wed, Jan 26, 2011 at 11:43 AM, Kelly webd...@gmail.com wrote: which date? will both

Re: why is cf_builder so expensive?

2011-01-26 Thread Russ Michaels
btw in case you didn't think of it, if any member of your family is a student and has a valid student ID, they can get the educational edition of Adobe products at a much reduced rate. Also, many may not realise but all the Creative Suite products can actually be installed twice, the license

Re: checking CFAdmin mappings from CF log files

2011-01-26 Thread Russ Michaels
You can do this via the adminapi if they will give you access to that. But to be fair, if you have access to the xml files, you could give yourself access to both the cfadmin and the adminapi anyway, so it would be pointless for them to deny you access to one and not the other. On Wed, Jan 26,

Re: why is cf_builder so expensive?

2011-01-26 Thread Gerald Guido
Also, many may not realise but all the Creative Suite products can actually be installed twice, the license allows you to install on your primary/work PC and also on your laptop. Huh. Does CFB fall under the umbrella of being a Creative Suite product? Curious G! On Wed, Jan 26, 2011 at

RE: Extracting a date from a string

2011-01-26 Thread Ben Forta
Assuming that the dates are always in mm/dd/ format, I'd use a regular expression, something like this: cfset string=*Department Summary by Employee 10/27/2010 - 10/27/2010* cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) disclaimer Code written on the fly with no testing ;-)

Re: Return boolean from a CFC query

2011-01-26 Thread Alan Rother
I don't know what to tell you Mike, SQL Server doesn't care, it works either way SELECT * FROM PropImage WHERE 20 = PropertyID works exactly the same as PropertyID = 20 It's just common convention that we use PropertyID = 20 In the internal SQL engine it's just running a logical comparison

Re: Return boolean from a CFC query

2011-01-26 Thread Kelly
This is true. I've done it and it works. It's easy enough to test and see that Alan is correct. On 1/26/2011 1:57 PM, Alan Rother wrote: I don't know what to tell you Mike, SQL Server doesn't care, it works either way SELECT * FROM PropImage WHERE 20 = PropertyID works exactly the

Re: Extracting a date from a string

2011-01-26 Thread Monique Boea
This give me the value of 32 cfset string=Department Summary by Employee 10/27/2010 - 10/27/2010 cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) cfoutput#dates#/cfoutput On Wed, Jan 26, 2011 at 1:54 PM, Ben Forta b...@forta.com wrote: Assuming that the dates are always in

Re: why is cf_builder so expensive?

2011-01-26 Thread Russ Michaels
no, sorry I obviously missed something off that post. The individual products within CS have the same license, so it would be a fair assumption that cfbuilder would be the same. On Wed, Jan 26, 2011 at 6:53 PM, Gerald Guido gerald.gu...@gmail.comwrote: Also, many may not realise but all

RE: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Che Vilnonis
Charlie, is this true only when the return type is Boolean? Otherwise, it should return the actual recordcount, right? Thanks, Che You could also drop the comparison itself since CF does implicit boolean conversion. cfreturn isStudentEmployee.recordcount / ^That'll do the same thing.

RE: Extracting a date from a string

2011-01-26 Thread Ben Forta
Oops, meant REMatch(), not REFind(). Use REMatch() and it'll do exactly what you want. Just be sure to check the length of the returned array before using it. --- Ben -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Wednesday, January 26, 2011 2:02 PM To:

Re: Extracting a date from a string

2011-01-26 Thread Monique Boea
This worked for me :) cfset string=Department Summary by Employee 10/27/2010 - 10/27/2010 cfoutput#ListGetAt(string, 5, ' ')#/cfoutput On Wed, Jan 26, 2011 at 2:01 PM, Monique Boea moniqueb...@gmail.com wrote: This give me the value of 32 cfset string=Department Summary by Employee

Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Scott Stroz
Actually, these will not return the same value. Lets assume the query returns 0 records. cfreturn isStudentEmployee.recordcount = 0 / will return true cfreturn isStudentEmployee.recordcount / will return false On Wed, Jan 26, 2011 at 1:43 PM, Charlie Griefer charlie.grie...@gmail.com wrote:

Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Charlie Griefer
Well, it will return the actual recordcount... which is a number. But CF implicitly converts numeric values to boolean values. Any non-zero value is true, while any zero value is false. So given the following code: cfif myCFC.myMethod()do something/cfif ... assuming myMethod returns a numeric

  1   2   >