Re: Design Structure and cfinclude

2003-09-20 Thread Kevin Graeme
> 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

2003-09-20 Thread Demarco, Alex
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

2003-09-20 Thread Jim Davis
> -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

2003-09-20 Thread Jim Davis
> -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

2003-09-20 Thread Claude Schneegans
>>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!

2003-09-20 Thread Claude Schneegans
>>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

2003-09-20 Thread Peter Mayer
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

2003-09-20 Thread Shannon Rhodes
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

2003-09-20 Thread cf-talk
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