RE: What the heck
It should be cfif isDefined(session.userid) isdefined requires what you are looking for to be in quotes unless the variable name you are looking for is stored in session.userid. Steve -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, August 22, 2011 1:51 PM To: cf-talk Subject: What the heck What am I missing here Element USERID is undefined in SESSION. The error occurred in C:\inetpub\wwwroot\vaughn_college_portal\_main_securecheck.cfm: line 3 1 : !--- if the cookie is here, procees to dashboard --- 2 : cfset validated_id=0 3 : cfif isDefined(session.userid) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) MS SSIS (BIDS) 2008 options
Hi all, Sorry for the OT, but my Google foo has failed me! When trying to save a SSIS package to a server one of the options is Protection Level and it defaults to Encrypt data with User Key. The policy in our shop is to use Rely on server storage and roles for access control. It is a major annoyance to always have to change it and when people forget we have to delete the package and start over again. Does anyone know if there is an xml file or something we can edit to change the default? Thanks, Steve __ Steven Durette SR Specialist - Application Developer ATT Network - Construction Engineering 2020 Bancroft St, Server Room (8) Port Huron, MI 48060 P: 810.984.6684 F: 810.984.9649 M: 810.841.4829 steven.j.dure...@att.com att.com [att_rp_hz_email_signature.jpg] ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: excel sheets poiutility.cfc
I don't know about poiutility.cfc, but cfhssf on riaforge can be used to do everything in memory. No files saved at all. I helped out with it a couple of years ago and that was one of the things I had to do for my own use. I actually may have made a more updated version that checks your version of poi and can do more with newer versions, but I never gave it to Ed to post up. Steve -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Tuesday, August 16, 2011 9:50 PM To: cf-talk Subject: excel sheets poiutility.cfc Hi All - This is a third version of generating to excel options that I am trying. I was going through the examples. If I am using apache poi, should I always write to excel, then read it and display it to the user? Is it possible to just read it directly from the query and display it to the user? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: coldfusion spreadsheet leading zeroes issue
Shouldn't that be cfset col1 = '#query1.col1# The ' has to be outside of the # signs. -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: Wednesday, August 17, 2011 11:26 AM To: cf-talk Subject: Re: coldfusion spreadsheet leading zeroes issue I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing cfset col1 = #'query1.col1# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: quick excel question
Using the POI is awesome. It can do so much more than the cf9 spreadsheet option. You just have to get used to it. There is a cf poi cfc on riaforge. I helped with some of the extra features! To use even more features you can also upgrade the poi that cf uses. Steve -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Thursday, August 11, 2011 11:59 AM To: cf-talk Subject: quick excel question Hi All - I am trying to generate excel using xml. I have a scenario where only 7 columns will be static and other columns are dynamic and may range from 1 to as many as 300 columns. And number of rows would be around 1000. What is the best approach for this situation. I tried new cf9 spreadhsheet but it failed just for few columns. XML workbook works fine where cf9 spreadsheet failed. I am just wondering will using apache poi directly will be of any use since I think cf9 spreadhseet also uses poi Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Stupid Question
Why avoid isDefined()? -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Thursday, June 30, 2011 2:12 PM To: cf-talk Subject: RE: Stupid Question Actually without getting into a flame war with Dave and others, it should be better to use cfif structKeyExists(capability_detail, 'capability_id') /cfif And you should avoid using isDefined(). Regards, Andrew Scott http://www.andyscott.id.au/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Stupid Question
But if you include the scope in the call then you would be fine right? I SCOPE EVERYTHING!!! -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, June 30, 2011 2:18 PM To: cf-talk Subject: Re: Stupid Question and the reason being that IsDefined() will check EVERY single variable scope for the existence of that variable. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem with pound signs
Dohh. Didn't think of that... -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, June 24, 2011 12:23 PM To: cf-talk Subject: Re: Problem with pound signs Here is a crazy idea - wouldn't what you are looking for be a runtime error? If so - can't you use the Code Analyzer in the CF Admin to scan the folder and find them all at once? On Fri, Jun 24, 2011 at 10:41 AM, Steven Durette st...@durette.org wrote: All these responses are really helping! Ok so here is what I'm going to do so far... I have a CF Application that can search through the code base and find stuff inside of tags or between opening and closing tags, but I have to tell it what tag and give it regex to do the search. I'm breaking this down into two steps first I'm going to search for the color codes in between cfoutputs that have a single #. From what I've been reading so far I think this regex should work: [^#]#[a-fA-F0-9]{3,6} If I'm correct it would pick up #FF3366 but not ##FF3366. What do you think about that regex? I'll deal with the missing # signs later after I get the color codes fixed. Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: application.cfm
I believe you are correct that the answer is no and that process seems perfectly logical and correct. Here is how I see the process running... By the way this is not actual knowledge of the process, but how I've always assumed that the process occurred. 1) Request is received by web server and is passed to cf. 2) CF sees which page it needs and checks to see if there is a compiled version of the template in memory or a class file on disk. 3) If there is, happily run the compiled byte code in the appropriate order. cfabort! 4) If not, compile the template. If that template references any other templates check each of those for compiled versions, if not then compile those as well. 5) Process the now compiled files in the appropriate order. The compiler and the executor are two different processes in CF. My guess is that the compiler takes lots of extra time and resources, so it does all its work before getting into the execution process. However like I said before I don't know any of this for sure, it's just how I understand the process. All that being said, unless there is a real need to futz with extensions, all extensions should match their filetype. PDF should be .pdf, Excel should be .xls, etc. In general it makes life a lot easier. Steve snip My question was is it possible to have CF compile a template requested in the url only if it is executed, so far the answer is no. /snip ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: application.cfm
This is because you are actually saving a pdf file as a .cfm. Maybe you should save it under a different extension, then have a page that serves it up using cfcontent. -Original Message- From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneegans@interneti=71?=.=?ISO-8859-1?Q?ue.com=3E?=] Sent: Wednesday, June 22, 2011 11:41 AM To: cf-talk Subject: Re: application.cfm But I am at a loss to explain how a PDF is going to throw a CF Exception error, when using cfcontent to deliver the file it should not be trying to compile that content. The error is not thrown using cfcontent, but simply when CF compiles the file when the HTTP request is received, before even executing application.cfm In my mind, application.cfm was called first, then the template compiled and run. Apparently, both application.cfm and the template are compiled first, then executed. This means that if application.cfm does not let the template to be executed, it is compiled for nothing. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Timing out a webpage
You may want to use multiple ways to do it... If you just use javascript then your timeout would be bypassed by just turning off javascript in the browser. Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, June 22, 2011 3:02 PM To: cf-talk Subject: Re: Timing out a webpage well you have 2 options. set your session timeout to 15 minutes, this will then mean they cannot sit on a page doing nothing for more than 15 minutes. If you want to time them for 15 minutes regardless of how many pages they load or refresh then you could create a Javascript timer, Google will garnish you with one of these. Russ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: dbvarname mssql cf8?
Do all JDBC drivers ignore @dbvarname? If not (and if CF actually passes it) then maybe you can get the MS (or another company's) JDBC drivers and use them instead. Steve -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Tuesday, June 21, 2011 11:53 AM To: cf-talk Subject: Re: dbvarname mssql cf8? Ah, I see. That makes sense, though it's not a CF issue, it is a JDBC issue. Another option would be for your dba to create an additional sp which calls the original sp and contains just the params that you need. Just a thought. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SOT - adding password forgot function to Mura CMS
Current security practices believe this is a bad idea. If you could do that then as the person running the site you would be able to get access to all of your users passwords. The password reset feature is safer. The user pick the password and the system hashes it, that is all that is saved and it is one way (you can't get the original password). Then when they try to log in again the password they enter is hashed the same way and compared to the hash that is saved. If they match they get in, if not well they can always reset. Steve -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Friday, May 27, 2011 12:28 PM To: cf-talk Subject: SOT - adding password forgot function to Mura CMS First, sorry for the SOT The current version of MURA does not have a 'forgot password' feature. It only gives the user a 'reset' All the emails/passwords are encrypted in the database Does anyone have a suggestion on how to add a traditional 'forgot password' feature that will query the db and return the info to the user's email address? Thank you for your consideration ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Shameful
Double tap to the chest and one to the head ensures a bullet-proof vest doesn't come back to haunt you. :P (That's my video game experience talking!) -Original Message- From: Mark Drew [mailto:mark.d...@gmail.com] Sent: Thursday, May 26, 2011 12:52 PM To: cf-talk Subject: Re: (ot) Shameful I meant for close quarters assassination, like the Mafia. Of course, this could be my TV knowledge speaking... because everything on TV is true. MD ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: scoping
Always scope your variables! We used to have a cf programmer around here that used to put the variable level in the application scope. Then he occasionally put it in session scope, occasionally in request scope, sometimes in the variables scope, and even sometimes he would pull a query with level as a column name. Troubleshooting his application was a nightmare because in the output code he would just put #level#. We never knew which scope was actually supposed to be displaying, or which one was without doing extra leg work. Scope everything, be safe, make troubleshooting easier on yourself, and maybe even eliminate some errors by doing it! Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Shameful
Please take this offline or to another more appropriate list. -Original Message- From: Irvin Gomez [mailto:ir...@pixel69.com] Sent: Tuesday, May 17, 2011 3:33 PM To: cf-talk Subject: Re: (ot) Shameful Really? You come in here with the intention to insult and raise ire and act like you were innocently conveying a message. Geek please. Keep blindly defending the unwarranted attack. I posted facts and all the groupies ganged up on me. Childish and pathetic. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd issue with DB pausing
Do you have any indexes on this table. Improper indexes can really hamper the database while doing inserts. Steve -Original Message- From: Scott Weikert [mailto:li...@alphageek.cc] Sent: Monday, May 16, 2011 12:27 PM To: cf-talk Subject: Re: Odd issue with DB pausing Ok just happened again... one thing to note is that when these hangs occur, all DB activity is affected. Even firing up query analyzer (SQL toolset), doing a simple query that would normally come back very quickly, it just spins. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SSL Cert problem.
Hi Everyone, I'm trying to connect with SSL, and I have imported the CER into the java keystore, but when I try to do the connection I get the following error: Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization. The server name is [REDACTED], the name in the certificate is #14[REDACTED]. It looks like the second name is a hash. It is approximately 70 characters long (71 but I might have miscounted) and looks like it is in HEX. Anyone have any ideas as to what might be the cause? Oh, This is a DSN through MS JDBC Drivers that works without encryption; I have restarted the CF instance as well. Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: MS XML Parse
Are you sure that someone didn't screw up the XML in the file? -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Tuesday, May 03, 2011 12:15 PM To: cf-talk Subject: MS XML Parse Hello all. I am trying to parse thru an XML feed using the method that I always use and it's not working: Here is my code: cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' cfhttp url=#getJobs# method=GET timeout=1/cfhttp !--- Read the file and convert it to an XML document object--- cfset msJobs = XmlParse(cfhttp.filecontent) cfdump var=#msJobs# The dump doesn't show up. I just get a blank screen. Any suggestions? TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Output the value of dymanic session vars
Try #session.institutionRegister[HUMANRESEARCH_SB_MODULE moduleID _GROUP groups.GroupID]# Steve -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Friday, March 25, 2011 10:21 AM To: cf-talk Subject: Output the value of dymanic session vars I dynamically created a series session vars EXAMPLE: HUMANRESEARCH_SB_MODULE10_GROUP1 Now I need to output the value along with the sesssion variable name: EX: cfoutputHUMANRESEARCH_SB_MODULE#moduleID#_GROUP#groups.GroupID# = #session.institutionRegister.HUMANRESEARCH_SB_MODULE#moduleID#_groups.Gr oupID#/cfoutput I get an error on the above. How do I accomplish this? TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Output the value of dymanic session vars
Ugh EVALUATE. Why can't that just die? :P -Original Message- From: Brian Cain [mailto:bcc9...@gmail.com] Sent: Friday, March 25, 2011 10:34 AM To: cf-talk Subject: Re: Output the value of dymanic session vars Try using cfset var=evaluate(HUMANRESEARCH_SB_MODULE#moduleID#_GROUP#groups.GroupID# = #session.institutionRegister.HUMANRESEARCH_SB_MODULE#moduleID#_groups.Gr oupID#) cfoutput#var#/cfoutput ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion License and Builder
Hi All, I have a short turn around on this so hopefully someone can help. I have searched the Adobe website, but I didn't find the appropriate documents. As I understand it if you purchase ColdFusion Enterprise edition, you get to use it on 2 machines (Production, Development/Hot Spare), and that you get one or more builder licenses with the purchase. We are trying to do our budget for software right now and I need to have the documents that state this. Does anyone have the URLs for the documents that state this? Or, can you tell me if I misunderstood the above? Thanks, Steve Durette ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion License and Builder
I swear that I saw somewhere (I thought on this list but couldn't find it) that the licensing for CF9 was a change for what I had said before about the dev/hot spare, and it didn't have the ip restrictions. I thought that Adam had put both of the items out on this list, but I was looking for the actual in writing info. Thanks, Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, March 10, 2011 9:42 AM To: cf-talk Subject: Re: ColdFusion License and Builder Steve, there was a special promotion to get a cfbuilder and flash builder with each purchase, I do not know if that promotion is still active, if you cannot find it on the Adobe site then I guess not. All editions of CF can be used for development completely FREE, they simply have an IP address connection limit. I believe the hot spare option is true, although if you are using Virtual Machines on the same server, then you can install it as many times as you like on the same physical server, and if in the Cloud (unknown which server you are using for each virtual machine), you get 10 installations. Russ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion License and Builder
I found the EULA for ColdFusion. Here are the appropriate sections: 3.1.3 If Licensee purchases one or more Production Software licenses, then Adobe also grants Licensee the right to install and use the Software as Development Software for internal development, testing and staging. 3.2 Development Software License. This Section 3.2 applies only if Licensee has obtained either a valid developer edition of the Software or one or more separate Production Software licenses (see Section 3.1.3). Adobe grants Licensee a license to install and use the Software as Development Software on one Server. Licensee must separately obtain the right to install or use the Software as Developer Software on more than one Server. In addition to the other terms contained herein, Licensee's license to the Development Software is limited to use in Licensee's technical environment strictly for testing and development purposes and not for production purposes. Licensee may (a) install the Development Software on Servers connected to Licensee's Internal Network provided that the total number of Computers used to operate the Development Software does not exceed the licensed number of Servers, and (b) permit Authorized Users to use the Development Software in accordance with this Agreement. Licensee shall not (i) use the Development Software for any application deployment in a live or stand-by production environment, in each case, including, without limitation, in any environment accessed by application end-users including but not limited to servers, workstations, kiosks, and mobile computers, (ii) access the Development Software from more than a single IP address at any given time, or (c) use the Development Software to deploy applications that are accessed by end users. NOTWITHSTANDING ANYTHING TO THE CONTRARY, THE DEVELOPMENT SOFTWARE IS PROVIDED TO LICENSEE BY ADOBE ON AN AS IS BASIS, AND ADOBE DISCLAIMS ANY WARRANTY OR LIABILITY OBLIGATIONS TO LICENSEE OF ANY KIND. Now if I could only find the stuff about free builder licenses with the purchase of CF. Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, March 10, 2011 9:42 AM To: cf-talk Subject: Re: ColdFusion License and Builder Steve, there was a special promotion to get a cfbuilder and flash builder with each purchase, I do not know if that promotion is still active, if you cannot find it on the Adobe site then I guess not. All editions of CF can be used for development completely FREE, they simply have an IP address connection limit. I believe the hot spare option is true, although if you are using Virtual Machines on the same server, then you can install it as many times as you like on the same physical server, and if in the Cloud (unknown which server you are using for each virtual machine), you get 10 installations. Russ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion License and Builder
I found what I needed for the development server info in the EULA. Thanks though. I also found the info about CF Builder with ColdFusion. You had to purchase before Jan 1, 2011. If we had we would have gotten 3 complimentary copies with every purchase of CF 9 Enterprise. http://forta.com/blog/index.cfm/2010/10/7/Buy-ColdFusion-9-Get-Free-Copi es-Of-ColdFusion-Builder Thanks, Steve -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, March 10, 2011 9:57 AM To: cf-talk Subject: Re: ColdFusion License and Builder On 3/10/2011 6:47 AM, DURETTE, STEVEN J (ATTASIAIT) wrote: I swear that I saw somewhere (I thought on this list but couldn't find it) that the licensing for CF9 was a change for what I had said before about the dev/hot spare, and it didn't have the ip restrictions. Yes, the EULA for CF9 has language that allows one to use the same license for a production server on a staging/cold backup/development environments. I don't know about the web site, but you should be able to find it in the EULA, and an internet search should turn up a couple of blogs that highlight the changes in the EULA. The free developer license (aka no license) that has long existed has a two IP restriction. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion License and Builder
Eric, You are correct on that. I posted the relevant parts of the EULA in a previous email. Steve -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Thursday, March 10, 2011 12:39 PM To: cf-talk Subject: RE: ColdFusion License and Builder I also remember that starting with 9 (or it could have been 8) that you can use your server license on development and testing servers. Please correct me if I am wrong on that. It may have been a special deal as well). Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: I think I'm confused...
When I'm working on my local development I just add local. So: 127.0.0.1 local.www.durette.org That way I keep the url close to the original for code purposes, but I can get to the real site just by not putting in local. Steve -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Thursday, February 24, 2011 9:20 AM To: cf-talk Subject: Re: I think I'm confused... You can make up whatever entries you want in your hosts file, and it will work on your local machine. 127.0.0.1test1.loc 127.0.0.1test2.loc 127.0.0.1test3.loc 127.0.0.1yo.mama 127.0.0.1my.mama 127.0.0.1free.beer Whatever you want. I would recommend NOT adding host entries for actual sites that you want to really pull up in the browser (your dev server, production sites, etc...) as it really just becomes a pain having to switch back and forth/. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com On 2/24/2011 7:00 AM, Rick Faircloth wrote: I could easily see that working for single sites, but if I'm developing a multiple sites, one codebase application that depends on reading specific domain names for setting sites variables, that means I have to have those dev.mydomain domains in the local hosts file, as well. I could just use the mydomain part of the url for identification, but as someone pointed out earlier in the MSOC discussion, that wouldn't account for subdomains, if they're used, such as blog.mydomain, etc. Any thoughts on this concern? Rick -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Thursday, February 24, 2011 6:04 AM To: cf-talk Subject: Re: I think I'm confused... I use different domain names. I have www.mydomain.com for the live server site, and dev.mydomain for my local development sites Then in my hosts file, i have the line: 127.0.0.1 dev.mydomain for each client site i have. With apache, the local dev versions and remote server versions behave in an identical manner Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Feb 24, 2011 at 9:21 PM, Rick Faircloth r...@whitestonemedia.com wrote: Ok... thanks Mark and Eric We need a better solution available to developers to be able to switch between local and server DNS. Perhaps, a switch of some kind that could be inserted into a URL to tell a browser to use a local hosts file if that switch is present. http://local/www.xyz.com or http://l:www.xyz.com That would certainly be a *lot* easier than constantly editing that hosts file. But it's good to know that I can use a local DNS file that way! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Feedback on this approach to many sites, one codebase (MSOC)
Probably a stupid question, but if the data was used across applications wouldn't it make sense to push it into the server scope? That would allow you to have one copy of the needed items, but still let you keep the applications separate. I know that a lot of the time having a different application name for each application while troubleshooting can be extremely helpful. I don't have a situation like this and I hardly ever look at the server scope, so I'm just asking because it will help further my knowledge. :) Steve -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Friday, February 18, 2011 9:15 AM To: cf-talk Subject: Re: Feedback on this approach to many sites, one codebase (MSOC) One thing you may want to take into consideration, if you plan on having many sites run through this codebase, is NOT giving each site a unique application name. (as in cfset this.name = #cgi.server_name#). I once worked on a MSOC system that ran somewhere around 2700 websites, and each site had its own application name. So, every time we cached a CFC in the application scope, we had 2700 separate instances of it, even though they were all identical. We had 2700 application.dsn variables stored in memory, even though they were all identical. We had multiple CF servers each trying to store and manage the same 2700 separate applications, all of which were completely identical. And the worst part was, there was no passing ?reinit=1 if we made code changes and needed to reset the application scope, we had to restart each CF server and take all 2700 sites offline in order to reset all of the applications. To me, this always seemed inefficient, and a gross waste of CF processes and memory. Just some thoughts I wanted to throw out there. Definitely something to think about if you're planning on having a large number of sites on your system. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Invalid Precision Value from SQL Server CF9
No it doesn't. Here is an example on SQL 2005: declare @test table ( testVal bit ) insert into @test (testval) values (0); insert into @test (testval) values ('Yes'); -- Results in error Conversion failed when converting the varchar value 'Yes' to data type bit. insert into @test (testval) values ('True'); -- Results in error Conversion failed when converting the varchar value 'True' to data type bit. insert into @test (testval) values ('No'); -- Results in error Conversion failed when converting the varchar value 'No' to data type bit. insert into @test (testval) values ('False'); -- Results in error Conversion failed when converting the varchar value 'False' to data type bit. select * from @test Sql expects data types that match. ColdFusion isn't strongly typed so false and no are equivalent to 0. Steve -Original Message- From: Nicki Tabb [mailto:vnt...@alaska.edu] Sent: Friday, February 18, 2011 1:17 PM To: cf-talk Subject: Re: Invalid Precision Value from SQL Server CF9 SQL will read a NO or FALSE or 0 as the same ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SELECT - Option selected
I read that you got this fixed, but for future reference I remember reading somewhere (I think on cf-talk) that the option value=/option Needs to have a space between the to make it work properly. Steve -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Thursday, February 17, 2011 5:04 AM To: cf-talk Subject: Re: SELECT - Option selected I have a simple one: cfselect name=endampm required=yes message=Please select an AM/PM for the end time id=endampm option value=/option option value=AM cfif schedule.endampm EQ AMselected=selected /cfifAM/option option value=PM cfif schedule.endampm EQ PMselected=selected /cfifPM/option /cfselect ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342380 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: decimals and variables
You need to do this: cfset tax = subtot * (tx / 100) / This actually converts the tx to a decimal. Also you don't need the #s in the cfset. :) Steve -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Thursday, February 10, 2011 9:14 AM To: cf-talk Subject: decimals and variables Hey all, I'm pulling up an integer from the database which is 15. This is a tax rate, so I need to get the tax on the subtotal. Say the #subtot# is 100 and #tx# is 15. cfset tax = #subtot# * .#tx# This should bring back the number 15. However, cf is throwing an error because of the decimal in front of the #tx#. cfset tax = #subtot# * .15 This works. However I need to pull from the database in case the tax rate changes. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Form Validation Issue using cfinput AND jquery
Is your JQuery validation returning false? Here is how I see it (I'm assuming here so don't shoot me)... CFValidation = false JQuery = true One result is true so it processes. CFValidation = true JQuery = false Same One result is true so it processes. CFValidation = false JQuery = false Both are false processing ends. CFValidation = true JQuery = true Both are true so it processes. You either need to change your cfvalidation to be jquery, or build a wrapper function for both validation that checks to make sure that both validate before moving on. Just a simple function that is, if CF or JQuery is false return false, if both true return true. Steve -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, February 01, 2011 12:16 PM To: cf-talk Subject: Re: Form Validation Issue using cfinput AND jquery I generally try to roll my own validation and just use form instead. You can much nicer validation. However with that being said I believe whatever you define in onSubmit=return bla will only fire if the cf validation passes. Ray explains it here: http://www.coldfusionjedi.com/index.cfm/2008/1/11/Ask-a-Jedi-Mixing-cffo rm-validation-and-ajaxbased-functions On Tue, Feb 1, 2011 at 12:02 PM, Kelly Matthews webd...@gmail.com wrote: Sorry if this ends up being a dupe post. I'm working on a client site that already had a CF Form in place using cfinput and validation via required=yes We added some select boxes that are required and as most of you know CF forms don't really validate those. So, I am using jquery to validate the select boxes when the form is submitted. The problem I am running into is this: The jquery portion works AND the CF validation errors are thrown as well. But if I fill in all the selects that are validated via jquery and do not to fill in the fields that are being required via cfinput required=yes, the error is thrown but the form still submits. Is this because of the jquery on submit validation? Has anyone run into this before, is there an easy fix, outside of moving the cfinput validation into the jquery validation? Kelly Matthews Web Developer http://www.cfwebtools.com blog: http://kellymatthews.wordpress.com Twitter: @webdiva ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Insert without checking existance
If you are just doing an insert, why don't you do it like this Insert into table(keyword) Select @keyword -- Variable containing the keyword Where not exists(select keyword from table where keyword=@keyword); Keeps it all in one block/transaction. -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Friday, January 28, 2011 11:13 AM To: cf-talk Subject: Re: Insert without checking existance I was doing the @@rowcount version to check then insert but I was unhappy with the performance. I was looking for some something a little better. Still not happy. I've got a keywords table with 2 columns - an ID (int) and a keyword (varchar). With an index on keyword, it should be very quick to do the check/insert operation. On Fri, Jan 28, 2011 at 11:02 AM, Che Vilnonis ch...@asitv.com wrote: Michael, I found this using Google... UPDATE Table1 SET (...) WHERE Column1='SomeValue' IF @@ROWCOUNT=0 INSERT INTO Table1 VALUES (...) Might be better? Che -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Friday, January 28, 2011 10:58 AM To: cf-talk Subject: Re: Insert without checking existance Yes. if exists(statement) something else something else The question I have to look up is if the whole operation is one 'unit' or does it have to have transaction control. Is there a 'gap' between the exists() check and the actual sql operation? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Insert without checking existance
So just out of curiosity, is this on a SQL 2008 box? If so then you can use merge and give different options for insert or update (even delete if you want) Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Subtracting two dates
Depends... If you are looking at less than 31 days difference then you can do it in the db. (only tried this in SQL Server). Select cprAdultExp, getDate() as [now], day(getDate() - cprAdultExp) - 1 as dayDiff From table You can get days, hours, minutes, seconds from this. Day is the only one you have to -1 from. In sql server they will all come back 1900-01-DD HH:MI:SS.xxx Steve -Original Message- From: Adam Bourg [mailto:adam.bo...@gmail.com] Sent: Friday, January 28, 2011 1:45 PM To: cf-talk Subject: Subtracting two dates I'm trying to figure out how to subtract two dates and return the number of days between then. My dates are cprAdultExp, which is a database column, I typically write it as: #dateformat(cprAdultExp,mm/dd/)# The other is Now() Which I also format as: #dateformat(Now(),mm/dd/)# What's the easy way to do this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion Hosting
That's funny, http://hostingatoz.com/ returns FORBIDDEN You don't have permission to access/ on this server! Steve -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Friday, January 28, 2011 2:03 PM To: cf-talk Subject: Re: Coldfusion Hosting Well, if you believe in the old adage of you get what you pay for... then decent and cheap are mutually exclusive :) That being said... since decent is a subjective term (altho I guess cheap is as well), a while back I hosted my blog at http://hostingatoz.com/. Their most expensive package (which includes ColdFusion 8) is $75 a year. When I was with them, it was... decent. There were downtimes, but I sort of expected that going into a $75/yr host. I will say the downtimes weren't nearly as frequent as I expected, and the support was very good, at least in terms of responsiveness. I know others who used them (some at my recommendation back then), who didn't have as good of an experience. At $75/yr, you takes your chances :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion Hosting
Strange it came up for me in Firefox, but my Corporate version of IE8 gets the following error: Forbidden You don't have permission to access / on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Friday, January 28, 2011 2:10 PM To: cf-talk Subject: Re: Coldfusion Hosting Weird. Comes up for me. Came up for me a few minutes ago (I brought the site up to check the price). Hmm... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Insert without checking existance
We have SQL2005 and SQL2008 servers. When we went to 2005 I thought This is great, with 2008 I think How did I do this before! The MERGE function is really nice. It's also nice to be able to declare a variable and set its value all in one statement. Example: 2005 (and before): declare @today datetime; select @today = getDate(); 2008: Declare @today datetime = getDate(); I keep coming across new stuff that I like as well. Just don't have time to read through all the changes and play with them until I need them. Steve -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Friday, January 28, 2011 2:13 PM To: cf-talk Subject: Re: Insert without checking existance MSSQL 2000. While this is for a client, a lot of what I'm doing here is going to applied to my own stuff. The client will be moving to MSSQL 2008 soon but I'm assessing if I can stay on MSSQL 2000, can move to MSSQL 2008, or should just move over to MySQL for my own stuff. The licensing on MSSQL 2008 is kind of high, but it ranks high on my personal priority scale. As a total aside, I rank CFBuilder low on the scale as it doesn't give me more than I have with Homesite/CFEclipse. I'll reassess when the next release comes out. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: why is cf_builder so expensive?
Ok... It was there. I applied for it in September, then again in December. Both times on the final screen it stated that It may take up to two weeks to process your request. You will be notified by email of your qualification status. I was never notified either time about my qualification status. When I did it in December it also stated ColdFusion Builder will only be approved for students who are taking courses in ColdFusion. I don't see that notice there anymore. I also think that it is funny that the confirmation page is https://freeriatools.adobe.com/cfbuilder/thankyou.php;. PHP for stuff dealing with ColdFusion?!?!? REALLY?!?!?!?! Steve -Original Message- From: Scott Brady [mailto:dsbr...@gmail.com] Sent: Thursday, January 27, 2011 8:07 AM To: cf-talk Subject: Re: why is cf_builder so expensive? Where are you finding this info? The FAQ ( http://www.adobe.com/products/coldfusion/cfbuilder/faq/ ) only says you need to be a current student (and that you aren't allowed to use it for production purposes, which does limit its usefulness for people on this list). Scott On Wed, Jan 26, 2011 at 7:12 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: 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 -- - Scott Brady http://www.scottbrady.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: why is cf_builder so expensive?
Sorry my failed attempt at humor. I just thought it was funny. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Thursday, January 27, 2011 10:41 AM To: cf-talk Subject: Re: why is cf_builder so expensive? There are multiple places on Adobe.com that use PHP. While I'd rather it be 100% CF, there are times where code is already written or the available resources only knows PHP. Shoot - would you want Adobe.com to be 100% Flash? I wouldn't. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: why is cf_builder so expensive?
Guys... This was just something funny I noticed... It happens all of the time when you have to get a project out and the only developer available doesn't know your preferred language. Maybe it was a new guy, maybe it was a designer who just used graphical tools (Dreamweaver) to do the site and they picked the wrong server technology. It doesn't really matter, it was just a funny aside. Let's not argue about stuff that really doesn't matter. :) Can't we all just be friends and colleagues again? Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: why is cf_builder so expensive?
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 [mailto:dwa...@figleaf.com] Sent: Tuesday, January 25, 2011 10:04 PM To: cf-talk Subject: Re: why is cf_builder so expensive? snip And if your a developer the educational use is of no real benefit because if I remember that was only for college students. And anyone can go to their local community college and register for a part-time course, and then you're a college student. I suggest philosophy or symbolic logic, if you choose this path. /snip Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: why is cf_builder so expensive?
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 most knowledgeable people that I have seen on this list. Watts, Corefield, Forta, Arehart (and more) are all giants when it comes to CFML. I have only ever gotten to meet Mr. Forta in person, though I do hope to meet the others in the future. I just like to give back when I can by providing the little tid-bits that I come across. Steve -Original Message- From: Michael Firth [mailto:mfsqlser...@gmail.com] Sent: Wednesday, January 26, 2011 9:29 AM To: cf-talk Subject: Re: why is cf_builder so expensive? 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. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: why is cf_builder so expensive?
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 comment. He's a juggernaught of cf help goodness. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Custom Tags, cf_location
You know one of the things that I have always loved about this list is that anyone could ask a question no matter how NOOBISH and no one would treat them with any ill will. The people would always gently move them to the proper way of doing things and everyone would learn. I apologize that this is not the case today. I hope the list will return to being a safe-haven for those looking for advice and help. Steve (Note: the previous was my personal opinion and may not be the opinion of my friends, others on the list, my employer, or the general public) -Original Message- From: Michael Firth [mailto:mfsqlser...@gmail.com] Sent: Tuesday, January 25, 2011 6:49 PM To: cf-talk Subject: Re: Custom Tags, cf_location Its amazing how fast the experts forget they were beginners at one time. It has everything with being a so called expert. You could have just answered his question in a more professional manner. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need a little sql help...
Hi all, My SQL mojo seems to have left me. Here is the situation, I have 1 table. In this table there are some times two rows that should have actually been one. Here is an example to explain. Table: Name, Age, address one, address two Row 1: Steve,40,123 Anystreet,NULL Row 2: Steve,40,NULL,456 Anystreet What should have been passed to me would have been: Steve,40,123 Anystreet,456 Anystreet The actual tables have a lot more columns and there are a few that this can happen with. The columns are either (null and not null values) or match exactly across rows. Any ideas what the SQL would look like to return a single row for each with all of the fields merged? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need a little sql help...
That was just example data... The Name is actually a distinct number letter combination. When the data is passed over to me they are supposed to pre-merge the rows into one, but they don't so I have been tasked to deal with it when the data suppliers don't. Another issue is that there are MANY more columns, so I could actually have 20 rows with this situation. They all merge into one though. Sorry for the confusion, I just redact true data whenever possible. -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Monday, January 24, 2011 2:00 PM To: cf-talk Subject: Re: Need a little sql help... How do you know the 2 Steve's are the same Steve? What if there was another Steve who was also 40 but lived elsewhere? Can you provide some more realistic data? And how you'd know they were the same Steve? or whomever? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341148 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Anyone know anything about this new ColdFusion conference?
SO... All of this is interesting conversation, but the initial question was is there any more information on this new conference? I've been trying to find a list of the 2011 conferences so I can plan to attend one. I have to schedule my vacation so I can attend my first conference. The only conference I saw any detail on was cfopen in Texas and I didn't find out about that until too late. Does anyone have a list of the CF Conferences this year? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Anyone know anything about this new ColdFusion conference?
Too late for me to schedule my travel plans, vacation, etc. Someone one my team already has that time off and one of us has to be available for emergencies. :( -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: Friday, January 21, 2011 1:44 PM To: cf-talk Subject: Re: Anyone know anything about this new ColdFusion conference? On Fri, Jan 21, 2011 at 9:34 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: The only conference I saw any detail on was cfopen in Texas and I didn't find out about that until too late. Since it hasn't happened yet, how is it too late? Does anyone have a list of the CF Conferences this year? OpenCF Summit - http://opencfsummit.org Scotch on the Rocks - http://sotr.eu or http://scotch-on-the-rocks.co.uk cf.Objective() - http://cfobjective.com D2WC - http://d2wc.com/ Adobe MAX (Unconference etc) - http://max.adobe.com/ I expect NCDevCon, BFusion, RIA Unleashed and cf.Objective(ANZ) will all happen again this year, just like last year. Basically, every conference that happened last year (and the year before and...) with the exception of CFUnited... and it sounds like Adam / Adobe knows about / is planning a DC-based event in August as well. See Charlie Arehart's awesome list as well: http://www.carehart.org/cf411/#cfconf -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Anyone know anything about this new ColdFusion conference?
New ColdFusion conference in DC in august?!?!?! Do tell! I'm trying to plan to attend my first CF Conference this year and it's been really hard trying to find out when they are going to happen. I found out about cf open summit, but I don't think I have enough time to plan for that. Thanks, Steve -Original Message- From: Adrocknaphobia [mailto:adrocknapho...@gmail.com] Sent: Tuesday, January 18, 2011 8:48 PM To: cf-talk Subject: Re: Anyone know anything about this new ColdFusion conference? FWIW. ColdFusion has been growing rapidly in the public sector the past few quarters. While I won't disagree that some organizations may be shifting to open source technologies, I would argue that it's far from the majority. For CF specifically, I think the expanding ColdFusion job market in Washington, DC is a strong indicator of that. Donna, did you ever attend CFUnited (the flagship ColdFusion conference located in the DC area)? You might also be happy to know that there will likely be a new ColdFusion conference in the DC area this August. -Adam Ex-government contractor Long-time DC metro resident Product Manager for ColdFusion at Adobe On Tue, Jan 18, 2011 at 7:56 PM, Donna Bing bingdo...@ymail.com wrote: Thanks for all the responses. AJ thanks for the cfhour link - I actually didn't even know about that podcast. Thanks Roger, I'll look at NCDevCon Derek - yeah you are totally correct: one CIO and management in all the agencies we contract with are talking more and more about slashing it budgets. I think we're probably a little ahead of the curve though: we moved to http://OpenBlueDragon.org/ a year ago and I think our only licensing costs are now for sql server, which we'll probably be dumping soon. Most of our agencies are also moving rapidly to cloud computing, for which I understand bluedragon is particularly well suited. Anyway I agree we need a conference like this in the d.c. area. thanks -Donna Bing From: Roger Austin raust...@nc.rr.com To: cf-talk@houseoffusion.com Cc: Donna Bing bingdo...@ymail.com Sent: Tue, January 18, 2011 8:38:17 AM Subject: Re: Anyone know anything about this new ColdFusion conference? Donna Bing bingdo...@ymail.com wrote: Ever since CFUnited closed up shop, I've been looking around for an affordable substitute. I'm local in the Northern Virginia area, so I saved on lodging and travel. That conference looks like it would be fun, but I have limited funds for those sorts of things so I won't be there. That conference is oriented to open source CFML which is an interesting idea. I tend to look first for things in my area of North Carolina (Research Triangle Park) which is rich in meetups and different local conferences. You may want to look into NCDevCon which has been free in the past and is located within driving distance from NoVa. It has been a two day conference that had nationally known presenters, many who used it as a test for their CFUnited talks. We had a number of visitors from up there so you could always plan to carpool with other NoVa folks. Talk with attendees from CFinNC in 2009 and NCDevCon in 2010 to get the lowdown on it. I can not be an unbiased source as a member of the host organization TACFUG. No date has been set for NCDevCon 2011 assuming it is held. There will be plenty of publicity including messages here if and when something happens. -- 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 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Strange errors when running CF from command line and running Flash Forms.
Hi all, Recently I started running ColdFusion from the command line so I can see any errors/exceptions/etc live. While I was running a page that has a flash form in it, the following errors came up on the screen: 01/06 11:55:04 [jrpp-0] ERROR internal error: expected to get a state from key [//http://*REDACTED*/181282.mxml.cfswf] 01/06 11:55:08 [jrpp-0] ERROR internal error: expected to get a state from key [//http://*REDACTED*/CFIDE/scripts/cfform.swc.cfswf] 01/06 12:22:03 [jrpp-4] ERROR internal error: expected to get a state from key [//http://*REDACTED*/385919644.mxml.cfswf] 01/06 12:26:32 [jrpp-4] ERROR internal error: expected to get a state from key [//http://*REDACTED*/580813472.mxml.cfswf] I hit the same page three times (which accounts for the different numbers before .mxml.cfswf). The pages don't error at all. I just really don't like ERROR messages in my logs/on my screen, so I'm interested in what these might mean. I have googled the errors using [jrpp-0] ERROR internal error: expected to get a state from key and [jrpp-4] ERROR internal error: expected to get a state from key, but have found nothing that relates. Any one seen this before and know how to fix it? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Strange errors when running CF from command line and running Flash Forms.
Thank you. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, January 06, 2011 1:18 PM To: cf-talk Subject: Re: Strange errors when running CF from command line and running Flash Forms. The [jrpp-0] bit isn't relevant for your search, as it just designates the specific JRun thread. The error itself is an artifact of how CF caches output internally, and can be safely disregarded. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Another 8.01 Gotcha (CFDOCUMENT)
Brook, No, Installing the latest hot fix may not include everything. Charlie Arehart just blogged on this. Try these links: http://bit.ly/fWhBU4 and http://bit.ly/fT6yip Steve -Original Message- From: Brook Davies [mailto:br...@logiforms.com] Sent: Wednesday, December 15, 2010 3:58 PM To: cf-talk Subject: Another 8.01 Gotcha (CFDOCUMENT) Another day, another bug found in the 8.01 release... This time I'm getting this error from CFDOCUMENT when generating a PDF: java.io.IOException: Parsing problem occured during the rendering process of this document. This error only starts popping up after a while (yeah, another one of those..). Works fine on the development server (exact same config) and works in production until it just all of a sudden starts throwing this error. A service restart resolves the issue. Other people have mentioned it: http://forums.adobe.com/message/3342861#3342861 http://www.mximize.com/java-io-ioexception-parsing-problem Some people say its related to having two BRBR characters right next to each other, but that doesn't seem to be my issue here - unless, once there error is thrown, that solution does not work. I guess I will add some code to replace all BRBR's with something else... gr.. -- I have another question, If I install 8.01 Cumulative Hotfix 4 , it includes all of the fixes from 1,2,3 right? Hence cumulative?. I just want to confirm J Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: checking for active links/pages (OT)
You could write something that parses out cfm files looking for the cflocation, cfinclude and a href tags and grab the filenames. Then you could filter that to be a distinct list. Then as everyone else suggested, search the logs to see if they have been hit recently. Steve -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Wednesday, December 08, 2010 11:12 AM To: cf-talk Subject: checking for active links/pages (OT) I'm working on a website where they've done some development work on the production server and I'm trying to clean it up. Does anyone have any ideas on how they would accomplish this aside from opening up each and every file and checking for cfinclude cflocation and a href tags? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Azure and Coldfusion 9
So use isDefined(Variables.queryname) first. -Original Message- From: Sean Henderson [mailto:shender...@followup.net] Sent: Tuesday, November 30, 2010 4:14 PM To: cf-talk Subject: Re: SQL Azure and Coldfusion 9 This is actually incredibly easy to deal with this scenario, you just have to check for the existence of the query variable first. You would normally check the recordcount 0 anyway so you don't output nothing, so it really isn't any more work. That would be true except when recordcount isn't populated, the query itself may not be populated and, depending on why, will error out. Since isQuery() will error out if the var is unset after CFQUERY, that is not very useful either. CFQUERY name=myQry ... declare @tmp table (col1 int) -- step 1 insert into @tmp (col1) select sub.* from (select 1 as col1 where 1=2) sub -- step 2 select * from @tmp where 1=2 -- step 3 /CFQUERY CFIF isQuery(myQry) CFDUMP var=#myQry# CFDUMP var=#myQry.recordCount# CFDUMP var=#myQry.columnlist# /CFIF This will (still) bomb using MS JDBC 2.0/3.0 drivers against SQL Azure or SQL Server 2008 (SQL2K8). Not so using MS SQL Server (which is actually a MM JDBC driver in CF) against SQL2K8. Sean ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Choosing between ColdFusion Builder and IntelliJ
Aptana? Really? I tried adding the Aptana plugin with cfeclipse once. It slowed Eclipse down massively and in general just got in my way. Maybe I'm using it wrong though. Anyone have quick tips for using Aptana for CF development? I may try it again if I can get some value out of it. Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, November 18, 2010 2:49 PM To: cf-talk Subject: Re: Choosing between ColdFusion Builder and IntelliJ I think IntelliJ is probably a better choice for pure Java development, although I still use Eclipse for that. Otherwise, though, I think Eclipse/CFBuilder is a much better fit for CF development, if only because of Aptana. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfheader/cfheader not working as expected
I don't remember if you posted any code, but I get by this with the following: cfset Variables.contVal = inline;filename=#Variables.myFileName# / cfheader value=#Variables.contVal# name=content-disposition cfcontent type=#Variables.myType# reset=Yes variable=#Variables.mySpreadsheetVar# Before All that I build the spreadsheet and put it into Variables.mySpreadsheetVar. What version of CF are you on? Are you using HTML, CFSpreadsheet, or some other method to generate the spreadsheet? I had an issue similar to what you had before, but I started building the spreadsheets using POI then when they get pushed to the browser they are in true spreadsheet format instead of html pretending to be xls (or xlsx). Sometimes the browser would see the xls extension but would then check the content and see html and act weirdly. By using the poi I not only get rid of those problems but it also got rid of the Excel Not in the same format popup. If you can consider this option let me know and I may be able to help a little. Also, do you have access to the server itself? I upgraded the POI that comes with ColdFusion to the latest version and I can do a lot more extra stuff. Steve -Original Message- From: Robert Gallagher [mailto:robert.gallag...@honeywell.com] Sent: Tuesday, November 09, 2010 5:35 PM To: cf-talk Subject: Re: cfheader/cfheader not working as expected I truly understand what you're saying but how these things work it not consistent which is frustrating. What's really crazy is we have dozens of Excel download links in our various apps like this example and some work perfectly with value=inline but most have the undesirable behavior (code name and read-only) which actually still works. Why inline provides the dialog box option of remembering the download decision but using attachment does not give that option (at least in IE) is very inconsistent but not surprising. Since this is not earth shattering I will chalk this up to browser inconsistency and move on. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Blog software
Hi all, So I haven't blogged in about a year because of different issues with my website provider... Any how I'm looking to get my blog going again, but I don't know how I should proceed. I used to use blogcfc, but my provider restricts a bunch of tags (below). Can anyone suggest which blog software might be good to use under these restrictions or if there are any work around tutorials for the latest versions of blogging code? I'd prefer to stick with something CF based. The restrictions I have are as follows: CF Tags not allowed: CFCOLLECTION CFCONTENT CFDUMP CFEXECUTE CFLOG CFOBJECT CFOBJECTCACHE CFREGISTRY CF Functions not allowed: SetProfileString CreateObject(COM) CreateObject(CORBA) CreateObject(JAVA) Thanks for your insights. Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Blog software
Kind of wish I could, but I get my package for $119 a year, the site doesn't make any money it is just for personal use, and I can't afford much more for what I get. For that price I can host 5 domains, unlimited email addresses for each domain, I don't remember how much bandwidth or drive space, but I get 2 mysql dbs and 1 mssql plus CF7. It works out to 9.95 a month and I can't afford more than that. Steve -Original Message- From: Ben Forta [mailto:b...@forta.com] Sent: Tuesday, November 09, 2010 11:37 AM To: cf-talk Subject: Re: CF Blog software Change hosting companies. Really. --- Ben (Sent from my Flash enabled Android device) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Blog software
Thanks, I will look at them (I have no experience with Railo), but I am pre-paid for a few months, so... Any ideas on cf blogging software I can use? Any tutorials on dumbing down the current options to make them work? I found a tutorial for blogcfc but it was so many versions back, some of the changes that the tutorial suggested weren't even there anymore. Steve -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: Tuesday, November 09, 2010 1:19 PM To: cf-talk Subject: Re: CF Blog software Take a look at Alurium. They offer shared hosting for about $3 / month with Railo - and you get full Web Administrator control for each account (because of the way Railo is sandboxed by default). -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood On Tue, Nov 9, 2010 at 10:08 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Kind of wish I could, but I get my package for $119 a year, the site doesn't make any money it is just for personal use, and I can't afford much more for what I get. For that price I can host 5 domains, unlimited email addresses for each domain, I don't remember how much bandwidth or drive space, but I get 2 mysql dbs and 1 mssql plus CF7. It works out to 9.95 a month and I can't afford more than that. Steve -Original Message- From: Ben Forta [mailto:b...@forta.com] Sent: Tuesday, November 09, 2010 11:37 AM To: cf-talk Subject: Re: CF Blog software Change hosting companies. Really. --- Ben (Sent from my Flash enabled Android device) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Blog software
Yes, but you are assuming commercial hosting. I host my own website (non-commercial) and the website for a club at the local community college. Neither generates money so cost is the issue here. I work at a corporation doing CF during the day, the stuff I'm talking about is my free-time donation type of stuff. So it's all out of pocket for me which is why I go for the bare minimum. Steve -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: Tuesday, November 09, 2010 3:53 PM To: cf-talk Subject: Re: CF Blog software On Tue, Nov 9, 2010 at 5:35 PM, DURETTE, STEVEN J (ATTASIAIT) wrote: my provider restricts a bunch of tags (below) Most of the restrictions are reasonable for a shared host that wants to provide a modicum of security. In a properly configured Sandbox cfcontent, cflog and setProfileStrng could be enabled but the rest is just the way ColdFusion works. Pick two: - shared hosting - security - functionality With the prices I see on some of the VPS / cloud offerings I can't imagine a scenario where shared hosting is the best solution for any commercial site, and we are fast approaching the same for any personal site as well. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Blog software
I worded that wrong... It's been a long day. I have two sites, neither of which generate money. One for my own personal use and one for a club at the local community college. So 9.95 a month or lower is better for me. What I'm not totally understanding is I could (if I knew how) use Java Server Pages on this same account. If I can use Java there why shouldn't I be able to use Java in ColdFusion. Any how the point is moot at the moment, I'm stuck for the next few months. I wanted something I could use now and look at new hosting in the future. Steve -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Tuesday, November 09, 2010 4:07 PM To: cf-talk Subject: RE: CF Blog software Yes, but you are assuming commercial hosting. I host my own website (non-commercial) and the website for a club at the local community college. Neither generates money so cost is the issue here. I work at a corporation doing CF during the day, the stuff I'm talking about is my free-time donation type of stuff. So it's all out of pocket for me which is why I go for the bare minimum. Steve -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: Tuesday, November 09, 2010 3:53 PM To: cf-talk Subject: Re: CF Blog software On Tue, Nov 9, 2010 at 5:35 PM, DURETTE, STEVEN J (ATTASIAIT) wrote: my provider restricts a bunch of tags (below) Most of the restrictions are reasonable for a shared host that wants to provide a modicum of security. In a properly configured Sandbox cfcontent, cflog and setProfileStrng could be enabled but the rest is just the way ColdFusion works. Pick two: - shared hosting - security - functionality With the prices I see on some of the VPS / cloud offerings I can't imagine a scenario where shared hosting is the best solution for any commercial site, and we are fast approaching the same for any personal site as well. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: I think I'm just making this way too hard...
Remove the # signs. You are telling cf to pass dateOfTotal to the server as a variable value. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, November 05, 2010 4:21 PM To: cf-talk Subject: RE: I think I'm just making this way too hard... Well, I switched the DB and CF functions around in the statement, changed the CF function in the first half of the comparison to a DB (MySQL 5) function, and changed the column name throwing the error to dateOfTotal to be certain using datetime as a column name was not the problem. But I still get an error, and I can't figure out why. I even renamed the table, in case using a number at the start of the table name was problematic. select totalNew from a_dailyNumberNewHMLSProperties where date_add(now(), -1 days) = '#dateAdd('d', -1, dateOfTotal)#' Variable dateOfTotal is undefined. How can that column name be undefined? Why is it not being understood in the SQL? A! ??? -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Friday, November 05, 2010 3:49 PM To: cf-talk Subject: Re: I think I'm just making this way too hard... On 11/5/2010 12:14 PM, Rick Faircloth wrote: What am I doing wrong? (Besides mostly likely making this way harder than it should be... just fog on the brain today) Rick On 11/5/2010 12:25 PM, Ian Skinner wrote: You need to be using a database function around the database column, which for date functions varies from DBMS to DBMS. P.S. And while there would be nothing wrong with continuing to use a ColdFusion function to create the date time value to be compared to the results of the database function us choose to use around the database column. It might just be simpler to use database function through out, as all DBMS have perfectly fine functions to get the current time from the system. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Group BY
Your group by has to match your select in most cases... Also, you are using reserved words in your query so that can mess stuff up. Try this instead... Select count(intMemberID) as [NewMembers], dateName(mm, [dteAdded]) + '-' + dateName(, [dteAdded]) as MTH From table Group by dateName(mm, [dteAdded]) + '-' + dateName(, [dteAdded]) Steve -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Wednesday, November 03, 2010 2:23 PM To: cf-talk Subject: Group BY How can I get this query to group by month? select count(intMemberID)as NewMembers, DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) AS Month FROM TABLE GROUP BY Month(dteAdded) When I ask on google everyone says to add: *GROUP BY Year(SomeDate), Month(SomeDate) * but that doesn't work. thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What difference does the parenthesis make?
That depends on the DB server. MSSQL doesn't have any problem with getting rid of the () that I know of. -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Monday, October 18, 2010 3:17 PM To: cf-talk Subject: What difference does the parenthesis make? What's the difference between 1. -- SELECT nl_id FROM vw_newsletters WHERE (paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer /) AND (nl_status = 'published' OR nl_status = 'archived') 2. -- SELECT nl_id FROM vw_newsletters WHERE paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer / AND (nl_status = 'published' OR nl_status = 'archived') #1 returns the correct records #2 returns nothing Not sure what difference the first set of parenthesis makes in #1 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 32-bit / 64-bit COM object issues in ColdFusion 9
I believe they just did do some kind of update to COM. I was just reading something that mentioned it. You may have to roll back the update to make it work the way you expect. That's a security/stability decision for Eric though. Steve -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Tuesday, October 12, 2010 4:25 PM To: cf-talk Subject: Re: 32-bit / 64-bit COM object issues in ColdFusion 9 Total shot in the dark, but isn't the second Tuesday of every month Microsoft's designated update time? Did your server auto update itself overnight? You might not have changed anything but the dark unseen forces of Microsoft may have... -Cameron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ListFunction Question
Assuming that the file is delimited by chr(13): Variables.myFile is the entire file cfoutput cfloop from=1 to=#listLen(Variables.myFile, chr(13))# index=Variables.outerLoop #Variables.outerLoop#:#listLen(listGetAt(Variables.myFile, Variables.outerLoop, chr(13)), ,)#br / /cfloop /cfoutput This should output each row number and how many comma delimited items are in that row. Can't see I've ever seen a variable row length csv though. Also, didn't test this so I could be wrong. Steve -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Friday, October 08, 2010 12:02 PM To: cf-talk Subject: ListFunction Question I have a CSV File of unknown length with an unknown number of columns. I loop through the file and use #listgetAt('#index#',1,',')# to get the elements of the file, but I don't know how many elements (columns) there are. I'm trying to say only get an element if it exists, something like: cfif IsDefined(#listgetAt('#index#',23,',')#)#listgetAt('#index#',23,',')#/cfif But I'm not using the right isDefined argument. What should I be using? Or is there some way I can tell how many elements are in this list? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5515 (20101008) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ListFunction Question
Oh wait I get it now. CF ignores things like ,, and you want to know if it has a value. Try this, cfset myArray = arrayNew(1) / cfset myArray = listToArray(Variables.myList, ,, true) / cfif len(myArray[Variables.itemToTest]) ... Code to process if this item actually exists ... /cfif -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Friday, October 08, 2010 12:08 PM To: cf-talk Subject: RE: ListFunction Question Tried that - listlen() is showing me the total number of elements in the entire list, including all rows. I need to tell how many columns are in the list or just tell if a column exists. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Friday, October 08, 2010 12:04 PM To: cf-talk Subject: Re: ListFunction Question listlen() __ Information from ESET Smart Security, version of virus signature database 5515 (20101008) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9.01 with JRocket JRE
The error you gave said something about missing java.config right? Then try attrib /s java.config from C:\ It will tell you every place that file exists on the C drive (change drives as appropriate) Steve -Original Message- From: Mary Jo Sminkey [mailto:mary...@cfwebstore.com] Sent: Friday, October 08, 2010 1:18 PM To: cf-talk Subject: Re: CF 9.01 with JRocket JRE I usually have to try a couple different directories before I find the right one... and make sure your slashes are pointed the right direction :) Just to verify I have the right install, for CF9 on a Win 7 64-bit, I *would* use the 64-bit for Java 6, right? Seemed obvious, but just in case I'm missing something --- Mary Jo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9.01 with JRocket JRE
Opps that was missing or corrupt jvm.config so attrib /s jvm.config -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Friday, October 08, 2010 1:29 PM To: cf-talk Subject: RE: CF 9.01 with JRocket JRE The error you gave said something about missing java.config right? Then try attrib /s java.config from C:\ It will tell you every place that file exists on the C drive (change drives as appropriate) Steve -Original Message- From: Mary Jo Sminkey [mailto:mary...@cfwebstore.com] Sent: Friday, October 08, 2010 1:18 PM To: cf-talk Subject: Re: CF 9.01 with JRocket JRE I usually have to try a couple different directories before I find the right one... and make sure your slashes are pointed the right direction :) Just to verify I have the right install, for CF9 on a Win 7 64-bit, I *would* use the 64-bit for Java 6, right? Seemed obvious, but just in case I'm missing something --- Mary Jo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 Paused Scheduled Tasks Still Running
I'm not totally sure, but I do notice that when I restart my CF server, there is an entry for the scheduled task in the log stating that it is paused. Could it be that that date updates every time the CF Server tries to run (on its scheduled time) but doesn't actually run it. Or maybe instead of trying to run it, every time it checks the jobs to see if they are runnable it updates. Again, I have no idea, just some possible suggestions. Steve -Original Message- From: Christopher Watson [mailto:skyg...@gmail.com] Sent: Tuesday, October 05, 2010 12:44 PM To: cf-talk Subject: CF9 Paused Scheduled Tasks Still Running I've got about 20 scheduled tasks set up in a CF9 installation, and I have every single one of them PAUSED. Yes, the second icon from the left in the Actions column of the Scheduled Tasks page in CF Admin shows as a green light document, with the title (tool tip) of Resume Scheduled Task for every task. These tasks are definitely PAUSED. Yet the Last Run is continually updating with a new date/time at every interval specified by the task settings. Now, I have most of these tasks set up to save output to a file, and those files are not being created, so that leads me to believe that these tasks are indeed NOT running, contrary to what the date/times in the Last Run column is telling me. Is this a known bug? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
WOT: W3C Validator install on Windows problem
Hi all, I'm trying to install the W3C Validator on a windows machine. It uses Perl to do the validations, and I have tried both ActivePerl and Strawberry Perl. I've tried installing one of the needed perl Modules (SGML:Parser:OpenSP) and I can't seem to get it to work. I installed OpenSP (part of the sourceforge OpenJade project) so that I could get this to work, but I still can't get it to install and run properly. Any perl experts out there with an idea? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: WOT: W3C Validator install on Windows problem
Oh yes! The problem isn't specifically with perl, it is with installing the required Perl Module SGML:Parser:OpenSP. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, October 04, 2010 3:23 PM To: cf-talk Subject: Re: WOT: W3C Validator install on Windows problem I'm definitely not a Perl expert. And I don't want to be one either. But have you added Perl to your path? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Restricting CFM file access
Do it in code, cfif cgi.remote_addr neq 127.0.0.1cfabort/cfif Of course you may want to add a couple others then you could use listFind instead of a simple string compare. Steve -Original Message- From: Asaf Peleg [mailto:a...@locusenergy.com] Sent: Friday, October 01, 2010 2:14 PM To: cf-talk Subject: Restricting CFM file access Hi, I have a ColdFusion server running over IIS on a Win2k3 machine and I wanted to know how to restrict someone from running a CFM file unless it is executed locally or within my firewall. For instance, imagine someone executes http://mywebsite.com/test.cfm in their browser. Is there anyway to restrict access to test.cfm either through CF Admin or is this an IIS issue? Thanks, Asaf ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Website validation... need suggestions
Thanks for the info! -Original Message- From: Ketan Jetty [mailto:kje...@yahoo.com] Sent: Tuesday, September 28, 2010 3:13 PM To: cf-talk Subject: Re: Website validation... need suggestions Hi Steven, You can use JMeter (free toll) to stress test your application. Also you can use Charles Proxy. Charles is similar to Fiddler but has additional functionality like throttle and stress test. For local google bot like application, you can use my web crawler code @ http://ketanjetty.com/coldfusion/useful-code/web-crawler/ Thanks, Ketan Jetty http://KetanJetty.com Note: I tried twice to post this, but the system erroed out. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337630 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Website validation... need suggestions
Hi all, I recently got tasked with doing some compatibility testing. While doing that testing I found that there were other things that were wrong with the website(s). This is a bunch of sites that are developed by multiple programmers, so I expect a little slop here and there, but I found many places where there were missing background pictures, bad links, etc. and I want to figure out the problems and compile a list for the developers to fix. Generally right now I'm looking at the HTML errors. I've just recently discovered Fiddler, and it was very helpful, but would be even more so if there were some way for me to kick something off that would test all the pages. Sort of like the google bot that is used for searches. Also, does anyone have any tools that they use for web testing that they would suggest? Free is always best, but I would look at programs that cost money as well. Also, I forgot to say that this is on an intranet, so I have to be able to install the items locally for testing. I would be reviewing any suggestions on my own computer/website and if I find any that really work I would put in requests for them to be company standard software (may not happen but worth a try). Also, I can't do stuff like pass the code to the W3C validator, unless I don't want to work here anymore! :P Steve __ Steven Durette SR Specialist - Application Developer ATT Network - Construction Engineering 2020 Bancroft St, Server Room (8) Port Huron, MI 48060 P: 810.984.6684 F: 810.984.9649 M: 810.841.4829 steven.j.dure...@att.com att.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Website validation... need suggestions
Russ, Thanks for the Google Links, but again this is on an intranet so I can't submit something outside the firewall. I am looking at the W3 Validator for download again along with the link checker and W3C Log checker. My main reason for asking was also more on the idea of something that crawls my sites and then I can get the report. It would be very tedious for me to have to manually go to every single page. Also, I know that Google searches can turn up a lot of options, I was looking to find out what people on this list like and use. I really value the opinions on this list! Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Monday, September 27, 2010 9:47 AM To: cf-talk Subject: RE: Website validation... need suggestions Here are the most common tools for validating and fixing your site. Google Webmaster Tools https://www.google.com/webmasters/tools w3c validator http://validator.w3.org/ w3c link checker http://validator.w3.org/checklink/ If you google website validator you will got plenty more results. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IIS 7 401.2 Error for cftree (long post with error info)
All, I have a website that has to use NTLM authentication. A little Info first: IIS7, Windows 2008 Server, CF Version: 8,0,1,198765, Non-standard port: 81. URL looks like http://admin.mywebsite.com:81/index.cfm No issues at all accessing the CFAdmin. I have set the /CFIDE/scripts and /CFIDE/classes to anonymous authentication in IIS7 even though everything above is NTLM. The page that is giving the problem is http://admin.mywebsite.com:81/webs/index.cfm The site works fine except for when using CFTree. Whenever I use CFTree, I get a box with a Box with and Exclaimation point and the error message: Error. Click for details When I click for details I get this: load: class coldfusion.applets.CFTreeApplet.class not found. java.lang.ClassNotFoundException: coldfusion.applets.CFTreeApplet.class at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source) at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.io.IOException: Authentication failure at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at java.net.HttpURLConnection.getResponseCode(Unknown Source) at sun.plugin2.applet.Applet2ClassLoader.getBytes(Unknown Source) at sun.plugin2.applet.Applet2ClassLoader.access$000(Unknown Source) at sun.plugin2.applet.Applet2ClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) ... 7 more Exception: java.lang.ClassNotFoundException: coldfusion.applets.CFTreeApplet.class load: class coldfusion.applets.CFTreeApplet.class not found. java.lang.ClassNotFoundException: coldfusion.applets.CFTreeApplet.class at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source) at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.io.IOException: Authentication failure at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at java.net.HttpURLConnection.getResponseCode(Unknown Source) at sun.plugin2.applet.Applet2ClassLoader.getBytes(Unknown Source) at sun.plugin2.applet.Applet2ClassLoader.access$000(Unknown Source) at sun.plugin2.applet.Applet2ClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) ... 7 more Exception: java.lang.ClassNotFoundException: coldfusion.applets.CFTreeApplet.class load: class coldfusion.applets.CFTreeApplet.class not found. java.lang.ClassNotFoundException: coldfusion.applets.CFTreeApplet.class at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source) at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.net.SocketException: Unknown proxy type : HTTP at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at sun.net.NetworkClient.doConnect(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.http.HttpClient.init(Unknown Source) at sun.net.www.http.HttpClient.New(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at
RE: IIS 7 401.2 Error for cftree (long post with error info)
I have /CFIDE/Scripts and /CFIDE/classes changed to Anonymous and that cleared up the errors fiddler reported for them, but I still get the error notification and the calls to /webs/coldfusion/applets/CFTreeApplet.class and /webs/coldfusion/applets/CFTreeApplet/class.class don't make any sense. There is no /webs/coldfusion/applets/ I will try what you said though and change CFIDE then lock down Administrator and adminapi. Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, September 24, 2010 12:18 PM To: cf-talk Subject: RE: IIS 7 401.2 Error for cftree (long post with error info) CFTREE and any other tags that use Javascript, flash etc all need to load files form the CFIDE. If you have disabled anonymous access then they wont be able to load the files. You should only lock down the ADMINISTRATOR, not the CFIDE Russ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS 7 401.2 Error for cftree (long post with error info)
Do you mean I have to turn on both NTLM and Anonymous for these items? For testing purposes I've also granted EVERYONE read/execute to all of these folders. I set All of CFIDE to anony and locked down Administrator and adminapi. Still no love. :( -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, September 24, 2010 12:25 PM To: cf-talk Subject: Re: IIS 7 401.2 Error for cftree (long post with error info) In addition to allowing anonymous access, you will also have to allow non-anonymous access using whatever credentials are being used to access the other non-anonymous content. The path /webs/coldfusion/applets probably refers to the classes within the JAR file containing CFTREE. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IIS 7 401.2 Error for cftree (long post with error info)
Thanks Dave! That seems to have done it. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, September 24, 2010 12:38 PM To: cf-talk Subject: Re: IIS 7 401.2 Error for cftree (long post with error info) Do you mean I have to turn on both NTLM and Anonymous for these items? Yes. If the user is accessing other parts of the site with NTLM, they'll automatically send their NTLM credentials for all requests. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 3 layers of validation?
First off, NEVER NEVER NEVER (should I say it again) assume that the data hitting the server or the database is coming from your form page. It is extremely easy for someone to do a view source and find out where the form data posts to. Then they can send all sorts of crap at the server just to see what happens (script kiddies anyone?). Because of that you have to do server side validation. Client side validation is more for the (wait for it) Client, It's much nicer to have the page say sorry you put in bad data please fix it then make them wait for a new page that says please go back and fix your data. Lastly, NEVER assume that your server application (CF, PHP, ASPX) is the only thing that will hit your database. Say someone finds your database and calls a procedure. You would really hate it if they passed in username = 'dummy';drop usertable;-- and your code didn't account for it. Suddenly your usertable is gone. Always check in each place. Think of it like a secure military base. You have to get thorough security at the gate, then you have to go through security at the building, then you have to go through security to get in the room (if what is inside is important enough to protect). At each level the guards are there to make sure that their specific area is protected. You can jump the fence, but it's harder to get in the building. If you find a way into the building, then it's almost impossible to get in the room. If you get in the room, no problem, we will shoot you when you come out! :) No one level of security can assume that the other has done its job. Steve -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: Thursday, September 23, 2010 8:01 AM To: cf-talk Subject: Re: 3 layers of validation? thanks for the replies. just so i understand: lets say the client (extjs) passes over a string to be stored in the database. Extjs has checked that it is a string and a length of 50, and that it doesnt have any speech marks. the server then tries to insert it into the database which has a cfqueryparam that checks it is a string and a max length of 50. do you think this is enough validation, or would you do any further checks? do you think the server should also check there are no speech marks in the text as well? thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 3 layers of validation?
And then of course there is always this: http://xkcd.com/327/ I showed that comic to an intern, years ago, who didn't validate his database inputs and accidentally deleted a whole database because he put code in the wrong place. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 3 layers of validation?
True, but if they have only gotten access to a login that can only run stored procedures and your stored procedures do the checks you are a little bit better off. The programmer can't assume that the DBA is doing his job with security and the DBA can't assume that the programmer is doing his job with security. If both do their jobs then security should be pretty strong, if not then at least you (programmer or DBA) have done everything they can to cover your own butt. -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: Thursday, September 23, 2010 10:01 AM To: cf-talk Subject: Re: 3 layers of validation? On Thu, Sep 23, 2010 at 9:48 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Lastly, NEVER assume that your server application (CF, PHP, ASPX) is the only thing that will hit your database. Say someone finds your database and calls a procedure. You would really hate it if they passed in username = 'dummy';drop usertable;-- and your code didn't account for it. Suddenly your usertable is gone. Always check in each place. If someone finds your database and executes a stored procedure, you've got *WAY* bigger problems than application coding. Ri ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion and Internet Explorer Compatibility testing tool
I have to do testing for a migration project using the Internet Explorer Compatibility Testing Tool, IE8 and Windows 7. Before we get into an IE/Firefox/Chrome war, this is a corporate requirement! During testing the following issues have come up: 1) I've found that any time a ColdFusion page is hit I get Issue Type: Mime Handling. From everything I've read, this is because IE8 matches the file extension to the mime type. In this case .cfm and text/html, but IE doesn't see that as valid. Anyone else come across this? The pages still render correctly, it just makes the error in the testing log. 2) Also, anytime a page is hit that has Flash in it (Flash Form, Flex, Flash), the Issue Type of ActiveX Blocking occurs. The Flash still runs, I believe the error is occurring because it does a test to see if flash exists. Any ideas about what I can do to correct these issues? __ Steven Durette SR Specialist - Application Developer ATT Network - Construction Engineering 2020 Bancroft St, Server Room (8) Port Huron, MI 48060 P: 810.984.6684 F: 810.984.9649 M: 810.841.4829 steven.j.dure...@att.com att.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
With SQL Server, DEFINITELY go with left(str, 4) = 'string' It has much less processing overhead. -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, September 08, 2010 1:20 PM To: cf-talk Subject: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%' Any advantage to one over the other? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
Well, I have to apologize! I am going through some training right now that is telling me exactly that. I was always told before that using like was bad, but apparently it is better. Steve -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Wednesday, September 08, 2010 3:10 PM To: cf-talk Subject: Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%' In SQL Server go with like str%. The reason is that like str% is sargable and functions are not. Functions also have overhead that native set-based SQL does not. I would assume the same is true with mySQL. Native SQL is usually faster than functions as a general rule, unless the equivalent SQL is wildly complex relative to what the function is doing for you. -Mike Chabot On Wed, Sep 8, 2010 at 1:27 PM, Michael Grant mgr...@modus.bz wrote: What about mySQL? Do you know if this is documented and easy to find? On Wed, Sep 8, 2010 at 1:23 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: With SQL Server, DEFINITELY go with left(str, 4) = 'string' It has much less processing overhead. -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, September 08, 2010 1:20 PM To: cf-talk Subject: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%' Any advantage to one over the other? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFParam vs. IsDefined
Using your way ensures that any variables that you are using already exist. I was always taught that I should define my variables before I use them in code (my ancient programming college courses). So, I tend to follow your method. Also, from a security stand, you should already know what should be coming into your page. If it isn't there then something went wrong. And if you didn't define it and it is there you should be ignoring it. Steve -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, September 01, 2010 11:36 AM To: cf-talk Subject: CFParam vs. IsDefined I prefer to CFParam my vars with a default value of a zero len string or a 0 for numeric values. Then I skip the isdefined and just test against the value. Well recently someone I know said that it's better to test if it's defined. Is there a pro or con to doing it my way vs. IsDefined ? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: manipulating Excel files
Yes that would be interesting to know since I also believe that POI is what ColdFusion uses for its internal tags to do manipulation. I mean if it doesn't use POI, then why are the POI jars included in CF? :) -Original Message- From: Steve Bryant [mailto:st...@bryantwebconsulting.com] Sent: Monday, August 30, 2010 4:16 PM To: cf-talk Subject: Re: manipulating Excel files Marc, In this case it might be helpful to understand why POI isn't an option so that people can suggest approaches that might be useful but fit within your constraints. Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Suppressing whitespace from CFCs
cfsilentYour non-output code here!/cfsilent -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Thursday, August 05, 2010 10:14 AM To: cf-talk Subject: Suppressing whitespace from CFCs I've moved output function into CFC's; thus I'm using output=true. Only problem is the CFC is outputting whitespace where all the logic is now. How can I suppress the white space in an output CFC? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5343 (20100805) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Suppressing whitespace from CFCs
Robert, I just tested it out (CF9) and cfsilent worked fine in a cffunction in a cfc with output=true. Maybe something in your code between the cf silents is breaking the tag matching. Or maybe your cfsilents are in bad positions. I know that this bit me before (not my code, but took me a while to figure out the problem): cfoutput There was stuff here... cfsilent There were a couple hundred lines here. /cfoutput /cfsilent It caused all sorts of problems. Steve -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Thursday, August 05, 2010 11:24 AM To: cf-talk Subject: Re: Suppressing whitespace from CFCs Robert, The best idea is NOT to use output=true if the whitespace is an issue. It's as simple as that. Create your content, save it to a var and pass back the var. You seem to getting upset that your cfc is doing what it's told to do. On Thu, Aug 5, 2010 at 11:20 AM, Robert Harrison rob...@austin-williams.com wrote: I'm running out of ideas. My output is in a CFFUNCTION in a CFC. Anything I wrap around CFINVOKE on the page does not affect what's inside the CFC and it's still gives whitespace. Anytime I try to put CFSILENT or CFSETTING inside the CFFUNCTION is chokes and can't find the end of the /cffuntion. This is annoying. I doubt I am the only one doing output from a CFC? There has got to be a way to kill the whitespace in a CFC when there is HTML output... although it appears that CFSETTING, CFPROCESSINGDIRECTIVE, and CFSILENT are NOT doing the job. Any other ideas? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5343 (20100805) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Server Data Archival - my solution
Pete, This is awesome! I'm going to consider using it for certain tables that we have problems with. I might suggest that you add in the user name and/or ip that made the change. That can help if you need to find out who made specific changes! Thanks, Steve -Original Message- From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] Sent: Friday, July 30, 2010 10:20 AM To: cf-talk Subject: SOT: SQL Server Data Archival - my solution I know a lot of time people (including myself) come here with questions, and don't have many opportunities to offer solutions to share. I had a need to store a record of changes to records in database tables for a content management system. I wanted to keep things simple, without requiring a bunch of additional code to my CF codebase, and I didn't want to make SQL Server management more complicated than it needed to be by adding a ton of tables. Anyway, in a nutshell, I've got an archive table that stores changed records as an XML object in a field. An insert, update, delete trigger grabs values from the inserted or deleted tables, packs that info up, and saves it to the archive table. The beauty of this is its relative simplicity -- the archive table can store data from any table in the database. Here's the write-up. I'm sure it's not perfect -- I'm far from an SQL Server expert - but it's going to work very well for my needs. Process - single archive table storing XML The archive table would look something like this: *tblArchive* uid uniqueidentifier DEFAULT NEWID(), timestamp datetime DEFAULT GETDATE(), sourceTable varchar(100), sourceID int, action varchar(10), xData xml * UID would be a unique identifier for this archive table. * Timestamp would set the time of archive and would allow to sort revisions based upon when they happened. * sourceTable would be the name of the table that the data is coming from. * sourceID would be the record identifier (presumably the primary key) of that record from the original table. * Action would be whatever SQL action was performed on that record, i.e. insert, update, delete * xData would be the XML object that stores the record that is being changed. Assuming a fictitious (and rather simple) table named tblUsers with the following structure: *tblUsers* id (int, PK, ident, autoincrement), fname (varchar(20)), lname (varchar(30)), employeeid (int), extension (int) Archive Trigger for Inserts, Updates and Deletes For each table that is to have archived data, run the following trigger, modifying table names where necessary: CREATE TRIGGER[tgrArchiveRecord] ON[tblUsers] FOR INSERT, UPDATE, DELETE AS IF@@rowcount = 0 RETURN DECLARE @table varchar(100); DECLARE @sourceid int; DECLARE @action varchar(10); SET @table = 'tblUsers'; IF EXISTS (SELECT * FROM DELETED) BEGIN IFEXISTS (SELECT * FROM DELETED) AND EXISTS (SELECT * FROM INSERTED) BEGIN SET @sourceid = (SELECT id FROM inserted); SET @action = 'update'; INSERT INTO tblArchive(sourceTable, sourceid, action, xData) SELECT @table, id, @action, (SELECT * FROM deleted AS record WHERE deleted.id = record.id FOR XML AUTO) FROM deleted; RETURN END SET @sourceid = (SELECT id FROM deleted); SET @action = 'delete'; INSERT INTO tblArchive (sourceTable, sourceid, action, xData) SELECT @table, id, @action, (SELECT * FROM deleted AS record WHERE deleted.id = record.id FOR XML AUTO) FROM deleted; END ELSE BEGIN SET @sourceid = (SELECT id FROM inserted); SET @action = 'insert'; INSERT INTO tblArchive (sourceTable, sourceid, action, xData) SELECT @table, id, @action, (SELECT * FROM inserted AS record WHERE inserted.id = record.id FOR XML AUTO) FROM inserted; END GO Retrieving Data From Archive The likely scenario for retrieving data from the archive table is to either display a history of a record, or to present previous changes so that a user can roll back changes to a previous version. Retrieving data from the Archive table's XML column is fairly straightforward: SELECT NULL as uid, u.id AS id, u.fname, u.lname, u.employeeid, u.extension, getdate() AS [timestamp] FROMtblUsers u UNION SELECT A.uid, A.sourceID AS id, A.xData.value('(/*/@fname)[1]', 'varchar(20)') AS fname, A.xData.value('(/*/@lname)[1]', 'varchar(30)') AS lname,
RE: CF8 on 2008 R2 and batch files
Sorry to say, I write and use custom tags all the time. Plus, you don't want to break any current functionality so you kinda need to make the tags work, unless you have the power, time, money, etc to make them re-write all the code that uses the custom tags. Steve -Original Message- From: douglas cohn [mailto:douglas.c...@gmail.com] Sent: Tuesday, July 27, 2010 2:02 PM To: cf-talk Subject: CF8 on 2008 R2 and batch files I support several developers and I recently installed a 2008 R2 server with CF8 on it. I realize my question is very vague and barely a question. I am picking at threads. CFSERVER service is running under admin since they require access to data across network. No question the user has more rights than it should have but that is not the issue presently. The issue is that processes that they ran previously under Windows 2003 R2 are not running under 2008 R2. These are processes that include batch files for the most part. The batch files work just fine outside of CF. I only want to know if it is possible to run Batch files within CF8 when running on W2k8 R2. If it is what changes if any must be made to get them to work. Additionally they are having issues with Custom Tags (CFX Tags C++). Of course this is so generic since they did not even tell me which tags are causing the problems. Are custom tags very popular in CF 8 and Cf 9? I recall when checking out Railo that they do not even support custom tags because so few people require them. Is this a fact and if so what would be used in their place? Any basic advice on how to handle CF 8.01 under 2008 R2 when there are batch files being run is appreciated. This is purely a maintenance site used internally at the office. The batch files are run and CF does all the database work and sets up the scripts. It is a very nice and fully automated system when working. Any IDEAS are appreciated. As you can likely tell I am not a CF programmer. Thanks Doug ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) changing the default for loading actionscript files in cfeclipse/eclipse
Hi all, Sorry for the off topic, but when I'm working on a project in CFEclipse that has actionscript files, if I double click on the file it starts up Flash to open the file. I don't want that, I want the .as file to open in CFEclipse. I know I can right click the file and choose Open With - Text editor, but that slows me down. After all, the IDE is supposed to conform to me not me to it. J Any insight will be appreciated. Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) changing the default for loading actionscript files in cfeclipse/eclipse
Ok... But why should I have to do that? The default OS Application for .cfm files is Dreamweaver, but when I open CFE and double click a .cfm file it opens in CFE. Besides, in some companies, changing defaults like that are locked down. Thanks for the idea though, I might do that as a last resort. (where is my admin's phone number) Steve -Original Message- From: Won Lee [mailto:won...@gmail.com] Sent: Monday, July 19, 2010 12:39 PM To: cf-talk Subject: Re: (ot) changing the default for loading actionscript files in cfeclipse/eclipse Not sure about CFEclipse because my CFBuilder is on a VM that is down but I would think you can change the file type association at the OS level so it opens it in CFEclips ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) changing the default for loading actionscript files in cfeclipse/eclipse
Thank you VERY much! -Original Message- From: denstar [mailto:valliants...@gmail.com] Sent: Monday, July 19, 2010 2:17 PM To: cf-talk Subject: Re: (ot) changing the default for loading actionscript files in cfeclipse/eclipse Eclipse has file associations: Prefs | General Editors File Associations :den -- In the beginning the Universe was created. This has made a lot of people very angry and has been widely regarded as a bad move. Douglas Adams On Mon, Jul 19, 2010 at 10:45 AM, Won Lee wrote: On Mon, Jul 19, 2010 at 12:42 PM, DURETTE, STEVEN J (ATTASIAIT) wrote: Ok... But why should I have to do that? The default OS Application for .cfm files is Dreamweaver, but when I open CFE and double click a .cfm file it opens in CFE. Besides, in some companies, changing defaults like that are locked down. Thanks for the idea though, I might do that as a last resort. (where is my admin's phone number) I agree with you; I don't think one should be forced to change file association at the OS level. It was the only thing I could think of while my CFBuilder was down. W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGrid and actionscript
Hi all, I have a small dilemma and would like some suggestions. I have an app that has been working for a long time. It is a Flash Form using a cfgrid. ActionScript and Flash Remoting is used to deal with updating and saving changes, etc. If there is only a row or two in the grid everything is fine, but if there are more than that, the updates to the database take so long that the flash form times out and locks up. Right now the code re-saves every row if it was changed or not. I want to switch to only change items that were actually changed to make things run faster. Using a CFGrid in a non Flash Form sends not only the grid data, but also what changed and what the original value was. Does anyone know how to see this same information in ActionScript? As I see it my options are as follows: 1) Learn how to see that extra information and use it to limit what is updated. 2) Make a copy of the original grid before they make changes, pass both grids to the cfc and have it determine what is changed and update. I'm afraid this might add a bit of over head as well. I don't have time to re-write this app and I can't share the url because it is a internal company website. Any ideas or info on extra data in cfgrids would be appreciated. Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Best conference?
So... Did anyone else get the email stating that this year would be the LAST CFUnited conference? Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: struct lookup vs. query of queries
Correct me if I'm wrong (please) but isn't a query already a Struct of Arrays? I mean the following is totally valid: Table user_list (user_fname, user_lname) {shown in comma delimited format} Cameron, Childress Michael, Dinowitz Steve, Durette cfquery name=myUserList (blah blah) Select user_id, user_name From user_list; /cfquery cfoutput #Variables.myUserList[user_fname][2] # /cfoutput Would output: Michael So after the query is loaded, you can just use the data. No copying no extra query, just direct access. Steve -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 14, 2010 10:27 AM To: cf-talk Subject: Re: struct lookup vs. query of queries On Tue, Jul 13, 2010 at 12:19 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: I've got a loop which will need to look up a piece of data on each iteration. The data is standardized so there is really just one call to the database (outside the loop). I can either do a query of queries on each iteration or I can turn the query into a structure and do a structure lookup (structkeyexists, etc) on each iteration. I'm assuming that the struct lookup will be faster/more efficient even after having to turn the query into a structure. Anyone have an opinion on this? I virtually always choose to use a struct in these cases. There are very few cases where I have seen an argument to use QoQ for virtually anything. QoQ is typically much slower than structs, assuming you are using alot of values from the query. Sometimes it can even be faster to go back to the DB each time rather than QoQ. Seriously. Depending on the use case, I like to convert the Query to a struct and then cache that struct either in a shared scope, or using CF9's EHCache caching mechanisms. You can wrap that whole thing up in a nice little CFC and it become really quite reusable. -Cameron -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: camer...@gmail. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfqueryparam question (null attribute)
Why not define form.myDate in the first place. cfparam name=form.myDate default= / Then... cfqueryparam value=#form.myDate# null=#not len(trim(form.myDate))# / Steve -Original Message- From: Matthew Lowrey [mailto:rid...@gmail.com] Sent: Tuesday, July 06, 2010 11:57 AM To: cf-talk Subject: Re: cfqueryparam question (null attribute) Hello Everyone (again): Another form of cfqueryparam has come up and I was curious how your outcomes might pan out. The following cfqueryparam passes, BUT when NULL it passes the default date in SQL Server (01/01/1900) Also, I had to take out the cfsqltype, it would error out if I did. cfqueryparam value=#isDefined('form.myDate')?form.myDate:''# null=#!isDefined('form.myDate')# / So, if I leave the date field blank it enters in this date (01/01/1900) into the db, if I put in a date then its fine. This code works (and I'm currently using): cfif isDefined(form.myDate) AND #form.myDate# NEQ cfqueryparam value=#form.myDate# cfsqltype=cf_sql_timestamp cfelse cfqueryparam null=yes /cfif I can keep it this way of course, but I really do like this new format and would like to see if it's possible to use this. Here's my theory, a space is inserted when the field is left blank when I should be passing a NULL value for dates... It's another shot in the dark, so I tried this format: cfqueryparam value=#isDefined('form.myDate')?form.myDate:'NULL'# null=#!isDefined('form.myDate')# / Simply added in NULL for the else, but that was a no go. Again, it passed through the submitting of the form, but the date still showed up as the default 01/01/1900 date. So far I've been able to figure out integers and vars but here's a new challenge of the date/time. Thanks everyone in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm