Re: Design Structure and cfinclude
> 5. Lastly, OnRequestEnd.cfm has template="includes/design/footer.cfm"> which tests for url.print and > delivers an appropriate footer based on this. The advantage is that I don't > have to include a footer on each individual page; the disadvantage is that I > can't use cflocation (since it doesn't call OnRequestEnd.cfm). I highly recommend using a css print stylesheet. I've just started using them, and I find that they significantly reduce complexity for our sites. It moves the display code away from the application code which means less application testing. Once it's there you can forget it because it doesn't have anything to do with your application. In fact, we've added it retroactively to CF sites without altering any applicatoin code. And for us, where we have lots of completely static html pages, it incorporates those as well with no additional work. -Kevin ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137803 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMX ODBC Services
BINGO Thanks Ben! -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 4:05 PM To: CF-Talk Subject: RE: CFMX ODBC Services I just posted this blog entry, I think it may be what you want: http://www.forta.com/blog/index.cfm?mode=e&entry=927 --- Ben -Original Message- From: Demarco, Alex [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 1:59 PM To: CF-Talk Subject: CFMX ODBC Services Does anyone know how to manual uninstall and reinstall them? We have a problem in that over a period of time the CFMX ODBC services locks other apps out of the SOFTWARE hive(w2k). When I stop the CFMX ODBC services the problem goes away.. - Alex ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137802 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Design Structure and cfinclude
> -Original Message- > From: Shannon Rhodes [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 20, 2003 9:54 AM > To: CF-Talk > Subject: Design Structure and cfinclude > > The only part I'm still hesitant about is the navigation. I really do > wonder if I'm making it more complicated than it needs to be. My stock answer to this is to make things as complicated as your architecture needs them to be as long as your only making them complicated in one place. In other words your every-day use of (your interface to) the navigation should be simple - but the navigation component (module, tag, template, whatever) you're using can be as complex as you need. Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137801 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Yet another OO/CFC question
> -Original Message- > From: Hal Helms [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 20, 2003 2:30 AM > To: CF-Talk > Subject: RE: Yet another OO/CFC question > > Null is actually what you're requesting with the Undefined() function. > It means exactly that. It also fulfills the type for any object, which > makes it safe to send and/or return: you won't get runtime errors. And > this isn't really just for fringe cases. Imagine the case where you have > an attribute that needs to be returned by a getter. What happens if > someone calls the getX() before setX()? You have a runtime error. If > CFCs had constructors, you could create a constructor such that one > would have to pass in X when creating the object, but as things stand, > there's no good way of eliminating the possibility of runtime errors. Oh - I know that null is what we want - I was trying to come up with an "easy" way to obtain the concept in CF without destroying backwards compatibility. If, for example, CF suddenly made "null" a keyword and gave it null meaning there's probably lots of code that would need to be regressed/break. Even in "Discovering CFCs" (which I have in front of me during this project, thanks!) you use the string "null" to represent the concept. I'm not sure of that code would break is true null was introduced but it would be confusing. However if a new function was created that generated an "internal null" it could be assigned to variables and used in tests without risk to older code. Perhaps to be more clear the function could be just called "null()". I may be wrong-headed in this (it was just brainstorming) but that was idea (I actually "get" null). Of course I suppose that the "real" null could be added to CF and a special attribute issued to control whether it's used or not. ;^) Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137800 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: dates nightmare II
>>isNumericDate() - Evaluates the "real value" of a date/time object. I know this phrase comes from the docs, but it just does not make sense, which "date/time object" are we talking about? IsNumericDate(number) expects a number and returns a boolean, there is no date object involved here. The rest of the docs makes a little more clear: "Returns TRUE if the number represents "real value" of the date/time object; otherwise, FALSE. " should actually read: "Returns TRUE if the number represents *a valid* "real value" *for a* date/time object; otherwise, FALSE. " My point is that if CF is to automatically convert (ie. cast) parameters to the type expected by a function, it should do it in a coherent way. If isNumericDate expects a number, in isnumericDate("05/25/2003"), CF should first try to convert "05/25/2003" to a number, not a date. But according to inumeric("05/25/2003") = "NO", this string cannot be converted to a number, then isnumericDate("05/25/2003") should return "NO", not "YES". Another incohence? Everybody knows that Now() returns today's date, and Now()+1 calculates tomorrow's date... BUT isnumeric(now()) = NO isnumeric(now()+1) = YES So today is not numeric, but there is hope: tomorrow will be! ;-))) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137799 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: dates nightmare again!
>>In CF4.5 In CF 5, CFMX too. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137798 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Set metadata of query created with QueryNew
Hello! I am creating queries on runtime using QueryNew() and performing some query of queries on them. Sometimes I (respectivly the users) receive errors like "Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison.". Also NULL errors occur (maybe because I have not set a value to a cell of a new query). Is there a way to explicitly set the column data type of a query created on runtime? Where does coldfusion get the type from (the first row)? Best regards, Peter ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137797 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Design Structure and cfinclude
I want to thank everyone for your interesting perspectives on this. Definitely I was planning on using external js and css files for the standard stuff, but I was also looking for the flexibility to throw in an individual function or style on a page when they are not likely to be needed elsewhere, so as not to bloat those external files needlessly. Sounds to me like the solution is to dictate such things by section rather than by page. So, here is what I have done, for anyone who is interested: 1. In Application.cfm I test for the existence of my dsn variable and if it is not defined I include my globals.cfm file which initializes all of my universal variables. Then I test to see what section of the site I'm in. I'm using which I hope works in the long run (I only care about the top level directory), then I loop through a 2-dim array in which the first element is the section title and the second element is a list of the directories that I want to be considered part of that section. When thisDirectory is found in that list, I set Request.SubNav equal to the value of the first element, i.e. the navigational section in which this page belongs. I use cfswitch to include a different file for each section of the site, in which cfparam is used to set a default Request.PageTitle, Request.METADescription, and request.METAKeywords, and a section-specific css and js file name is defined. 2. Each page will carry (optional; I'm not using Verity because, for whatever reason, the collections are constantly going down and the host's response is just to restart every time I complain) (required; would prefer to use mappings rather than a relative link, but when I tried on the test site it brought down CF on my live site!) 3. header.cfm tests to see whether url.print is defined; if so, a print-friendly header is included, otherwise defaultheader.cfm is included (yeah, I guess I could also use a custom tag, I'm thinking about whether it offers a significant advantage) 4. defaultheader.cfm uses #Request.PageTitle# in the title area, plus #Request.METAKeywords# and #Request.METADescription# where appropriate, and includes the css and js files for this section. nav.cfm is included, in which I loop over my navigation based on the value of Request.SubNav (I have a 2-dim array containing url and link title for each sub-section's navigation, as well as one for main level nav. This allows me to pull up the sub-nav for the section I'm in, and pull this section's nav to the top; admittedly, this might be overcomplicating matters a bit when a static nav at this point would probably be just as easy to update). Finally, the image containing the name of the sub-section as the heading for content is called. 5. Lastly, OnRequestEnd.cfm has which tests for url.print and delivers an appropriate footer based on this. The advantage is that I don't have to include a footer on each individual page; the disadvantage is that I can't use cflocation (since it doesn't call OnRequestEnd.cfm). [Naturally, other code snippets are also available for include, such as which will put a formatted "back to top" link at the bottom of long pages; too bad there's no way to programmatically figure the length of a page and include it automatically!] The only part I'm still hesitant about is the navigation. I really do wonder if I'm making it more complicated than it needs to be. Thanks everyone! This was my first post and I'm impressed by the friendliness and helpfulness of each of you. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137796 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: dates nightmare II
I don't really see the problem here. isNumeric() - Determines whether a string can be converted to a numeric value. Supports numbers in U.S. number format. isNumericDate() - Evaluates the "real value" of a date/time object. With that in mind... "05/25/2003" is NOT a number. "05/25/2003" IS a valid date. It's a numeric date. "May 25th, 2003" is a valid date, but not a valid NUMERIC date. -Novak - Original Message - From: "Claude Schneegans" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 19, 2003 9:44 PM Subject: Re: dates nightmare II > You want even more stupid? > > Here it is: > > "isNumeric (string) Returns TRUE if string can be converted to a number; otherwise, FALSE. " > > Then for instance isnumeric("05/25/2003") returns "NO", of course, since "05/25/2003" is not a number, > it is a string and it cannot be converted to a number. > > Fine,... But then how come isnumericDate("05/25/2003") returns "YES" ? > How come "05/25/2003" can be a numeric date if is is not numeric??? > > OK. I suppose CF tried again to guess and converted "05/25/2003" to a date first? > But according to the docs, the function IsNumericDate(number) expects a number, not a date, > so why didn't CF try to convert the parameter to a number instead of a date? > If it had done so, it would have find that "05/25/2003" cannot be converted to a number, > therefore isnumeric("05/25/2003") should be "NO". > > You want more? > here is more: > > isnumericDate(now()) = YES > isnumeric(now()) = NO > > So a date is a numeric date value, but it is not numeric ??? > > Now PLEASE Macromedia, could you pay your programers some kind of "date 101" > elementary course and correct all these kind of gross errors? > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137795 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm