Where is the cftalk listserv?

[Eric Fickes]

Does anybody know where the listserv for CFTALK is physically located?  Just
trying to figure out my email header mystery

E

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: SQL7 count query

[Kay Smoljak]

On Thu, 9 Nov 2000 13:30:49 +0700, [EMAIL PROTECTED] (Paul Hastings) wrote:

>sure you can:
>
>SELECT 
>(SELECT COUNT(artist_id) FROM artists) AS artists,
>(SELECT COUNT(artworks.artwork_id) FROM artworks) AS artworks,
>(SELECT COUNT(news.article_id) FROM news) AS news
>
>as long as you don't care wether there's any relationship among these
>tables...

Thanks Paul and Nick... works great!

K.
__
Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!
 
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: SQL7 count query

[Paul Hastings]

> :))  You've got result like count(artists)*count(artworks)*count(news)? It
> is right. You cannot get result you want in one query. You must run 3
> different queries.

sure you can:

SELECT 
(SELECT COUNT(artist_id) FROM artists) AS artists,
(SELECT COUNT(artworks.artwork_id) FROM artworks) AS artworks,
(SELECT COUNT(news.article_id) FROM news) AS news

as long as you don't care wether there's any relationship among these
tables...


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: fusebox

[Bill Killillay]

Lee,

Thanks, I was getting ready to do the same thing.  I wish
people would try Fusebox before they just bash it.  There is
a GREAT network of some of the BEST CF developers in the
world that are on the Fusebox email list.  If you have
questions, concerns, or what ever join that list and learn
about it.  I think that most people, not all, but most
people that go bashing it, one don't really understand CF,
and two, don't understand Fusebox at all.  In short, join
the list, read the book, download the tags and samples and
take an hour and learn it.  It's really not all that hard to
figure out.

Just my .02
Bill



-Original Message-
From: BORKMAN Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:49 PM
To: CF-Talk
Subject: RE: fusebox


Thanks for the detail, Karl.

I must disagree with your basic point, though.  You say that
"it is a
mistake to put the cart before the horse and apply a single
design
methodology to every application one builds".  If the
alternative is to
develop a new strategy tailored to each individual project,
then that sounds
like bad news.

I'm the first to admit that FuseBox is not a perfect
methodology for every
occasion, but I would always prefer to adapt a single
methodology, ANY
single methodlogy, always provided that it is 'sufficiently
flexible' and
not too cumbersome.  FuseBox is the only candidate that I
have yet seen for
a CF methodology/architecture that satisifies my minimal
requirements of
usability and flexibility, so I am very happy to use it.

In short, I disagree with your list of priorities:
1: application performance
2: maintainability
3: cost of development

I ALWAYS put ease of development and maintainability BEFORE
application
performance, and my clients would be horrified if I did
otherwise.

Performance issues are usually most economically addressed
by enhancing your
infrastructure (CPU power, RAM, bandwidth), not by squeezing
millisecond
gains from CF file accesses.  Developer time might cost
between $100 and
$300 per hour.  For one hour of developer time, then, I can
double the RAM
on my production server, and achieve substantial performance
gains.

To summarize, I PREFER to squeeze everything into one
architecture/methodology, even though that methodology is
not perfect.  This
makes our applications maintainable, enhancable, robust,
understandable, and
inexpensive.  On the odd occasion that performance criteria
are so rigorous
that our standard methodology can't handle it, then AND ONLY
THEN do we
modify it.  Re-inventing the wheel each and every time is
bad for everyone,
devlopers and clients included.

As for your detailed criticisms.  Breaking your code into
pieces BEFORE you
know you are going to re-use the pieces is one of the GREAT
benefits of
FuseBox.  It's incredible how much you can end up re-using,
when the pieces
are already there.  If you wait until an opportunity to
re-use becomes
obvious before breaking up the code, then developers are
discouraged from
re-using and they might decide it's easier to cut and paste.

I really don't mind much if people want to use
application.cfm instead of
app_globals.cfm.  I use application.cfm just to check that
all requests are
going through index.cfm.  This also prevents the server from
searching
endlessly up the tree.

So, I don't think FuseBox is the "methodology du jour".  In
fact, the only
credible alternative architecture/methodology I've seen is
CFOBJECTS, which
is even MORE heavy on file accesses, and has a much steeper
learning curve.

Anyway everybody, if you haven't tried FuseBox, give it a
go, and don't be
put off.  It's true that some people don't like it.  For the
life of me,
though, I can't see why.

Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Win ME & CF Studio

[Parker, Kevin]

Mine works fine but I actually did a compete re-install after a format as my
PC was getting a bit sick (argh! typical M$). I suspect your problem might
be the upgrade if CF already existed. In my case I installed it after the
upgrade.



Kevin Parker
Service and Communication
WorkCover Corporation

[EMAIL PROTECTED]

ph:  +61 8 82332548
fax: +61 8 82332000



-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 9 November 2000 1:35:PM
To: CF-Talk
Subject: Win ME & CF Studio


Has anyone else had their CF Studio 4.5.1 melt down after upgrading to
Windows ME?  I wanted to check it out, but it has done damage.  argh!
typical M$

Thanks for any feedback.

Eric J Hoffman, MAIP
Small Dog Design



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]




This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: SQL7 count query

[Nick Slay]

Hi Kay, 

Try getting the counts as sub queries, for example

SELECT COUNT(*) AS Artists,
(SELECT COUNT(*) FROM Artworks) AS Artworks,
(SELECT COUNT(*) FROM News) AS News
FROM Artists


Hope this helps a little!

N\

> From: "Kay Smoljak" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 9 Nov 2000 09:31:02 +0800
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: SQL7 count query
> 
> I want to list the total number of items in several tables. I was hoping to
> do it in one query, because potentially there could be 10 or more totals and
> running that many queries on one page seems silly. Here's the code I tried:
> 
> 
> select  count(artists.artist_id) as artists,
> count(artworks.artwork_id) as artworks,
> count(news.article_id) as news
> from artists, artworks, news
> 
> 
> 
> #count.artists# artists listed
> #count.artworks# artworks listed
> #count.news# news articles
> 
> 
> But this gives me the total value of all the tables combined for each
> variable. What am I doing wrong?
> 
> Thanks,
> K.
> __
> Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
> Internet Solutions for your business!
> 
> Level 9/105 St George's Tc - Perth - Western Australia
> Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
> Visit Perth online! : www.perthweb.com.au
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
> message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: SQL7 count query

[Gena]

> select count(artists.artist_id) as artists,
> count(artworks.artwork_id) as artworks,
> count(news.article_id) as news
> from artists, artworks, news
>
> But this gives me the total value of all the tables combined for each
> variable. What am I doing wrong?

:))  You've got result like count(artists)*count(artworks)*count(news)? It
is right. You cannot get result you want in one query. You must run 3
different queries.

Gennadi


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Installing CF4.5 SP 1

[Rahul]

Service pack is meant for overwriting the orginal files with the upgraded
one. U can go ahead we have already done it & working fine.

Rahul

- Original Message -
From: Jacob Ezzell <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 3:16 AM
Subject: Installing CF4.5 SP 1


> Has anyone installed SP1 on their server?  We were all ready to, but it
> looks like it will completly over-write the installation instead of
> upgrading it.  Any input?
>
> Jacob Ezzell
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Very Off The Topic How to Insert a page break for printing purpose

[Scott Wood]

Throw everything you want to print in a pop up window, then print that
window.. 

Just an idea, not sure if this would help.

G. Scott Wood
Developer
HMWeb.com
520-742-2611 Ext.135


-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 6:09 PM
To: CF-Talk
Subject: Very Off The Topic How to Insert a page break for printing
purpose


Yes  I this is very much off the topic and this is my first and my last OT
posting in this forum.


I am trying to figure out how to design a page so that only the bottom
portion of the page that contains the print this page button is printed. I
need to insert a page break into my code to indicate where I want the top of
my print page to start does anyone know how this is done.


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
  Website: www.AustralianAccommodation.com
  Website: www.AccommodationNewZealand.com




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: It doesn't look like it is the machine...

[Nick McClure]

What about the software?

What OS version? What Service Pack?

What CF Version? What Service Pack?

What about the Database, what are you using there?

At 04:47 PM 11/8/2000 -0800, you wrote:
>Hi All,
>There is a problem with our web site.
>
>I have to restart the CF Server twice and somtimes
>more than that daily because the web site becomes
>"non-responsive".
>
>Sometimes I get Dr' Watson's error when I try to stop
>the service. The "% of cpu usage" is in the 6-8% range
>with spikes to 30%+ every so often. Memory usage is
>below what is physically installed so I don't think
>the machine itself is having a problem.
>
>Could this be a problem with settings in cfadmin? or
>is it something else.
>
>Help!!
>
>Thanks
>
>
>
>__
>Do You Yahoo!?
>Thousands of Stores.  Millions of Products.  All in one Place.
>http://shopping.yahoo.com/
>--- 
>-
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send 
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: It doesn't look like it is the machine...

[Peter Alexandrou]

Let us know what server platform you are running CF Server upon as well as
the CF version you're running.

> -Original Message-
> From: jonathan hamner [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 9 November 2000 11:47
> To: CF-Talk
> Subject: It doesn't look like it is the machine...
>
>
> Hi All,
> There is a problem with our web site.
>
> I have to restart the CF Server twice and somtimes
> more than that daily because the web site becomes
> "non-responsive".
>
> Sometimes I get Dr' Watson's error when I try to stop
> the service. The "% of cpu usage" is in the 6-8% range
> with spikes to 30%+ every so often. Memory usage is
> below what is physically installed so I don't think
> the machine itself is having a problem.
>
> Could this be a problem with settings in cfadmin? or
> is it something else.
>
> Help!!
>
> Thanks
>
>
>
> __
> Do You Yahoo!?
> Thousands of Stores.  Millions of Products.  All in one Place.
> http://shopping.yahoo.com/
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: GRABBING, JAVASCRIPT, VARIABLES, IN, CF

[Gena]

EVEN BETTER:


> How do I set a variable in CF from a javascript?
>
> Ex:
>
> 


 document.write("You're using: #navigator.appName#
#navigator.appVersion#");


> 



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: GRABBING, JAVASCRIPT, VARIABLES, IN, CF

[Gena]

- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 10:19 AM
Subject: GRABBING, JAVASCRIPT, VARIABLES, IN, CF


> How do I set a variable in CF from a javascript?
>
> Ex:
>
> 


 document.write("You're using: "+#navigator.appName#+"
 "+#navigator.appVersion#+"");



> 
>
> I would like to set this as a session variable. I cannot do this because I
> tried:
>
> 
>
> Thanks
>
> Sal
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: GRABBING, JAVASCRIPT, VARIABLES, IN, CF

[Rob Keniger]

on 11/9/00 9:19 AM, S R at [EMAIL PROTECTED] wrote:

> How do I set a variable in CF from a javascript?

You can't. CF executes server-side, JS client-side. You could pass the
result as a form value to another CF page which stores it as a session var
though.

Although, for this you'd be better off using the cgi environment variable
#cgi.http_user_agent# in CF.

-- 

Rob Keniger

big bang solutions





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Win ME & CF Studio

[Eric J Hoffman]

Has anyone else had their CF Studio 4.5.1 melt down after upgrading to
Windows ME?  I wanted to check it out, but it has done damage.  argh!
typical M$

Thanks for any feedback.

Eric J Hoffman, MAIP
Small Dog Design


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Room Reservation tool

[Vaughan Evans]

I seem to remember someone on this list presented a hotel booking app for
demonstration a while back...maybe this will do the job? Can't remember who
it was tho.

vaughan

-Original Message-
From: S R <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Thursday, November 09, 2000 1:22 PM
Subject: Room Reservation tool


>Hi,
>
>Does anyone know of a Room Reservation tool that is out there, preferably
>built in CF or integrates with CF, or maybe it does not have to integrate.
I
>can build one, but if there is something out there already that is already
>built I can tweak it to my specifications. We have some conference rooms
>here at my company that people can reserve through a web interface, but it
>also needs to be able to show day by day, probably through a day by day
>calendar or list by date, which rooms are being used and for how long. It
>looks like I'll probably have to build it but like I said, if there is
>something our there that comes close to this, I'd rather do that.
>
>Thanks
>
>Sal
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>---
-
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: fusebox

[BORKMAN Lee]

Thanks for the detail, Karl.

I must disagree with your basic point, though.  You say that "it is a
mistake to put the cart before the horse and apply a single design
methodology to every application one builds".  If the alternative is to
develop a new strategy tailored to each individual project, then that sounds
like bad news.

I'm the first to admit that FuseBox is not a perfect methodology for every
occasion, but I would always prefer to adapt a single methodology, ANY
single methodlogy, always provided that it is 'sufficiently flexible' and
not too cumbersome.  FuseBox is the only candidate that I have yet seen for
a CF methodology/architecture that satisifies my minimal requirements of
usability and flexibility, so I am very happy to use it.

In short, I disagree with your list of priorities:
1: application performance
2: maintainability
3: cost of development

I ALWAYS put ease of development and maintainability BEFORE application
performance, and my clients would be horrified if I did otherwise.

Performance issues are usually most economically addressed by enhancing your
infrastructure (CPU power, RAM, bandwidth), not by squeezing millisecond
gains from CF file accesses.  Developer time might cost between $100 and
$300 per hour.  For one hour of developer time, then, I can double the RAM
on my production server, and achieve substantial performance gains.

To summarize, I PREFER to squeeze everything into one
architecture/methodology, even though that methodology is not perfect.  This
makes our applications maintainable, enhancable, robust, understandable, and
inexpensive.  On the odd occasion that performance criteria are so rigorous
that our standard methodology can't handle it, then AND ONLY THEN do we
modify it.  Re-inventing the wheel each and every time is bad for everyone,
devlopers and clients included.

As for your detailed criticisms.  Breaking your code into pieces BEFORE you
know you are going to re-use the pieces is one of the GREAT benefits of
FuseBox.  It's incredible how much you can end up re-using, when the pieces
are already there.  If you wait until an opportunity to re-use becomes
obvious before breaking up the code, then developers are discouraged from
re-using and they might decide it's easier to cut and paste.

I really don't mind much if people want to use application.cfm instead of
app_globals.cfm.  I use application.cfm just to check that all requests are
going through index.cfm.  This also prevents the server from searching
endlessly up the tree.

So, I don't think FuseBox is the "methodology du jour".  In fact, the only
credible alternative architecture/methodology I've seen is CFOBJECTS, which
is even MORE heavy on file accesses, and has a much steeper learning curve.

Anyway everybody, if you haven't tried FuseBox, give it a go, and don't be
put off.  It's true that some people don't like it.  For the life of me,
though, I can't see why.

Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
 

-Original Message-
From: Karl Simanonok [mailto:[EMAIL PROTECTED]]

Your questions deserve a much more thorough analysis and response than I
have time available for, but I'll try to hit some of the high points.
...


IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.  

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Is Cold Fusion a Typed Language?

[Christopher Olive, CIO]

dunno about that.  try ada.  10 different types of strings. :)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 6:02 AM
To: CF-Talk
Subject: RE: Is Cold Fusion a Typed Language?


Try modula 2 for a strongly typed language.
It must be the most strongly type system I've ever run into.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: 07 November 2000 22:17
To: CF-Talk
Subject: RE: Is Cold Fusion a Typed Language?


A strongly typed language requires you to declare the data type of all
variables ahead of time. All functions return values that are of a specific
type. All operators act on values of specific data types.

For example, assume you have a function nth( list, n) that returns the nth
value of a list where a list is a string with comma separated values. nth
might be declared as follows:
  string nth( string list, integer n)

It would be an error to pass anything but a string as the first argument. It
would be an error to pass anything but an integer as the second argument. It
would be an error to assign the results to anything but a string variable.

string list = "10,20,30,40";
string val;
integer n=2;
integer m;

val = nth( list, n);( val = the string "20")
m = nth( list, n);(ERROR because nth returns a STRING not an integer)
val = nth( list, "3")  (ERROR because "3" is a string)
val = nth( list, 3)(val = the string "30")

If you need to get around these restrictions you need to explicitly convert
the datatypes:

m = convert( nth( list, 3), "integer")
or
m - (int) convert( nth( list, 3))   (this is how 'C' does it)


The advantages of a strongly typed language are the compiler/run-time system
can catch subtle errors because you are so explicit about what data types
are being passed around.
The disadvantage is it's a pain to have to declare everything ahead of time
and to convert values all over the place.

Most "typed languages" are not quite this strict and will do many automatic
conversions for you.


At 08:21 AM 11/7/00 -0800, Warrick, Mark wrote:
>For the sake of us non-programmers could you explain what "typed language"
means?
>
>---mark
>
>--
>Mark Warrick
>Phone: (714) 547-5386
>Efax.com Fax: (801) 730-7289
>Personal Email: [EMAIL PROTECTED]
>Personal URL: http://www.warrick.net
>Business Email: [EMAIL PROTECTED]
>Business URL: http://www.fusioneers.com
>ICQ: 346566
>--
>
>
>> -Original Message-
>> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, November 07, 2000 5:40 AM
>> To: CF-Talk
>> Subject: Is Cold Fusion a Typed Language?
>>
>>
>>
>>   I've heard in quite a few places that ColdFusion is a typed language?
>> However, it acts as an untyped language.  Can anyone verify for me which
>> one is actually true?
>>
>>   You don't declare variables a type when you create them, and you
>> can typically change a variable from a string to an integer without
>> a second thought.  I was told that ColdFusion handles all data
>> conversion internally to take the burden off the user, but for
>> efficiency's sake, it's best not to switch the type of a variable if
>> you can avoid it.
>>
>>   And if Cold Fusion is a typed language, what are the simple types?
>> The standard string, integer, float, and boolean?
>>
>> --
>> Jeff Houser
>> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
>> --
>> DotComIt, LLC
>> Computer Consultant specializing in database driven web data
>> Lotus Notes/Domino, Cold Fusion
>> --
>> Half of the Alternative Folk Acoustic Duo called Far Cry Fly
>> http://www.farcryfly.com
>> http://www.mp3.com/FarCryFly
>> --
>> Does Everyone Think I'm a Cynical?
>> --
>> --
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>> or send a message with 'unsubscribe' in the body to
>> [EMAIL PROTECTED]
>
>---
-
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarsts or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A

Losing Network Connection

[Rosa, Issac]

I have a strange problem and wondering if anyone has encountered this
before.  When running ColdFusion 4.5 RDS and CF Server, I lose all browser
functionality after 8 minutes of use and get dnserror - page cannot be
displayed in IE 5.1 and no dns server entry in Netscape 4.08.  I also lose
connection to my network drives and my mail server.  It's like I lose my
entire network connection.  I am running Win 98 and CF Studio 4.5, single
version server on a Dell Laptop 300MHz with 192MB Ram.

Here's what I've done to troubleshoot.  
I have started RDS without starting Server - No issues.
I have started Server without RDS - Error.
Both RDS and Server - Error. 
Shut down Server after running and getting error and Browser works
again.
I have uninstalled CF Server and reinstalled, but this did not resolve the
issue.

Any help or thoughts would be greatly appreciated.  I am dead without CF on
this machine.

If you have any questions or concerns, please feel free to call me at
407-514-5021.

Thank you,

> Issac Rosa
> 
> IT - National Sales & Marketing
> OLAP Specialist Team Leader
> Ofc: 407-514-5021
> Cell: 407-342-0644
> Fax: 407-514-5988
> [EMAIL PROTECTED]
> 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

SQL7 count query

[Kay Smoljak]

I want to list the total number of items in several tables. I was hoping to
do it in one query, because potentially there could be 10 or more totals and
running that many queries on one page seems silly. Here's the code I tried:


select  count(artists.artist_id) as artists,
count(artworks.artwork_id) as artworks,
count(news.article_id) as news
from artists, artworks, news



#count.artists# artists listed
#count.artworks# artworks listed
#count.news# news articles


But this gives me the total value of all the tables combined for each
variable. What am I doing wrong?

Thanks,
K.
__
Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Drop down List (Solved)

[James Taavon]

This is a multi-part message in MIME format.
--49B842EC9410C3D199900F0E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

No, I have not used the Three Selects Related, but it should work on the
same principle as Two Selects Related.

monika kon wrote:
> 
> Thank you very much,
> i am really very sorry for bothering you.
> It was my fault not putting the  tag..
> I have got it right.
> Thanks a lot for your patience.
> Please tell me if you have used
> "CF_Threeselectsrelated".
> I was trying this and I wanted all the 3 to be
> dropdown list.The example there on the site
> "http://nateweiss.com/taggallery/" is of Radio buttons
> and 2 dropdown list .As I said I want all the 3 to be
> drop down list.
> Can you please help me.
> Thanks a lot.
> Shally
> ++
> --- James Taavon <[EMAIL PROTECTED]> wrote:
> > This is a multi-part message in MIME format.
> > --4A576A0EB0C5055670C186FA
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > um, i dont see the opening form tag? can you cut and
> > paste the entire
> > file as you have it please?
> >
> > monika kon wrote:
> > >
> > > I am sending the code again,
> > > CODE:
> > > 
> > > 
> > > Untitled Document
> > >  > content="text/html;
> > > charset=iso-8859-1">
> > > 
> > >
> > >  > >  datasource="Catalog"
> > >  dbtype="ODBC">
> > > SELECT  Distinct MnGrp, MnGrp_Desc,
> > ProductType,
> > > ProductType_Desc
> > > FROM globalkeys_FLAT
> > >
> > > 
> > >
> > > 
> > >
> > > > > QUERY="getresult"
> > > NAME1="select1"
> > > NAME2="Select2"
> > > DISPLAY1="Mngrp_desc"
> > > DISPLAY2="Producttype_Desc"
> > > value1="mngrp"
> > > value2="producttype"
> > > FORCEWIDTH1="70"
> > > FORCEWIDTH2="70"
> > > SIZE1="1"
> > > SIZE2="1"
> > > HTMLBETWEEN=""
> > > AUTOSELECTFIRST="Yes"
> > > EMPTYTEXT1="(choose a category)"
> > > EMPTYTEXT2="(now choose a subcategory)"
> > > ONCHANGE="Submit!"
> > > FORMNAME="MyOtherForm">
> > > 
> > > 
> > > 
> > > I AM UNABLE TO UNDERSTAND WHICH CFFORM YOU ARE
> > TALKING
> > > ABOUT ,THANKS FOR YOUR REPLY AND PATIENCE
> > >
> >
> +++
> > > --- James Taavon <[EMAIL PROTECTED]> wrote:
> > > > This is a multi-part message in MIME format.
> > > > --7E483AE1B1188D700B230AAD
> > > > Content-Type: text/plain; charset=us-ascii
> > > > Content-Transfer-Encoding: 7bit
> > > >
> > > > what does your CFFORM tag look like?
> > > >
> > > > monika kon wrote:
> > > > >
> > > > > Hi James,
> > > > >
> > > > > I am able to see only the First dropdown list
> > with
> > > > > unique MnGrp_Desc.The second dropdown list is
> > > > showing
> > > > > up nothing even if I select any thing from the
> > > > first
> > > > > drop down list.
> > > > > Did you see the database I have sen in the
> > > > previous
> > > > > mail?
> > > > > Shally
> > > > > --- James Taavon <[EMAIL PROTECTED]>
> > wrote:
> > > > > > This is a multi-part message in MIME format.
> > > > > > --79EE260D231C723574DB0849
> > > > > > Content-Type: text/plain; charset=us-ascii
> > > > > > Content-Transfer-Encoding: 7bit
> > > > > >
> > > > > > What exactly are youe seeing? How is the
> > list
> > > > > > different from your
> > > > > > database?
> > > > > >
> > > > > > monika kon wrote:
> > > > > > >
> > > > > > > --0-2049339050-973275290=:67150
> > > > > > > Content-Type: text/plain; charset=us-ascii
> > > > > > > Content-Disposition: inline
> > > > > > >
> > > > > > > Hi James and Vaughan Evans!
> > > > > > > Thanks a lot for ur reply.
> > > > > > > I am now stuck in the query.Please help
> > me.I
> > > > am
> > > > > > > sending the code as well as the database
> > in
> > > > excel
> > > > > > as
> > > > > > > an attachment.I have placed
> > > > TwoSelectsRelated.cfm
> > > > > > in
> > > > > > > the folder CFUSION.But my query is not
> > giving
> > > > me
> > > > > > the
> > > > > > > proper values.
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> ++
> > > > > > >  > datasource="global">
> > > > > > > select MnGrp,
> > > > > > > MnGrp_Desc,ProductType,ProductType_Desc,
> > > > > > > from Global
> > > > > > > where MnGrp=Left([ProductType],1)
> > > > > > > 
> > > > > > >
> > > > > > >
> > > > > > >  Calling Cusstom Tag below (I have mine in
> > a
> > > > > > table)
> > > > > > >  
> > > > > > >  > > > > > >
> > size="2">Name:Email:
> > > > > > > 
> > > > > > >  > > > > > > query="GetResult"
> > > > > > > name1="Select1"
> > > > > > > name2="selet2"
> > > > > > > display1="MnGrp_Desc"
> > > > > > > display2="ProductType_Desc"
> > > > > > > size1="1"
> > > > > > > s

RE: FW: Login and Clustering

[Sandra Clark]

Perfect!  After seeing your message, I was able to find a Custom Tag
cf_ClientTimeout which does exactly that.  That takes care of my problem.

So long as I can check to see if a Client variable is older than 20 minutes,
I can definitely make this work.

Thanks!

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 10:28 AM
To: CF-Talk
Subject: Re: FW: Login and Clustering


Perhaps a client structure, containing something like loginid and
timestamp.  Check to see if the loginid has timed out (Your own custom
value here, nothing ColdFusion specific)

--
Billy Cravens
[EMAIL PROTECTED]

Sandra Clark wrote:
>
> -Original Message-
> From: Sandra Clark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 1:53 PM
> To: [EMAIL PROTECTED]
> Subject: Login and Clustering
>
> I am working on the architecture for my next site, which HAS to work in a
> Clustering (non sticky-sessioned) environment.
>
> I have figured out how to save complex data types (arrays, structures,
> queries) using WDDX and Client variables.
>
> However, the problem I am stuck on is how the heck to I know whether or
not
> a user is currently logged in across a cluster?
>
> I have been using a Sesson variable so that even if a user doesn't logout
it
> times itself out in 20 minutes. Obviously I can't do that with a Client
> variable. So how do I determine across a cluster whether a user has
> currently logged in ? While still maintaining the integrity of the
> application?
>
> Has anyone done anything like this? Any clues, directions you can point me
> to?
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

What happens after a timeout?

[Leong Yew]

This is a multi-part message in MIME format.

--=_NextPart_000_0007_01C04A42.B43EDED0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi there,

A number of CF tags like CFHTTP and CFPOP that connect to remote servers =
allow you to specify a connection timeout. Does anyone know what happens =
after it times out?

Basically I'd like to create a custom error page that tells my visitor =
that the timeout is due to an incorrect http or pop server entry or that =
the server isn't responding. Does anyone know how this could be done?

Thanks.=20

--=_NextPart_000_0007_01C04A42.B43EDED0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi there,
 
A number of CF tags like CFHTTP and CFPOP that =
connect to=20
remote servers allow you to specify a connection timeout. Does anyone =
know what=20
happens after it times out?
 
Basically I'd like to create a custom error page =
that tells my=20
visitor that the timeout is due to an incorrect http or pop =
server=20
entry or that the server isn't responding. Does anyone know =
how this could=20
be done?
 
Thanks. 

--=_NextPart_000_0007_01C04A42.B43EDED0--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Very Off The Topic How to Insert a page break for printing purpose

[AustralianAccommodation.com Pty. Ltd.]

Yes  I this is very much off the topic and this is my first and my last OT
posting in this forum.


I am trying to figure out how to design a page so that only the bottom
portion of the page that contains the print this page button is printed. I
need to insert a page break into my code to indicate where I want the top of
my print page to start does anyone know how this is done.


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
  Website: www.AustralianAccommodation.com
  Website: www.AccommodationNewZealand.com



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Remote DB Alteration

[Billy Cravens]

Why can you not upload your Access file?  If it is giving you a "file
locked" error, you can kill the lock by throwing a query at it that
causes an error, then upload the file.

-- 
Billy Cravens
[EMAIL PROTECTED]


"Guy J. McDowell" wrote:
> 
> Hello CF'ers
> 
> Situation:
> Database and sites hosted externally, site created internally.
> Currently if any changes to the datasource's structure are made they
> are made locally and then uploaded to the host, who has to shut off
> the CFServer and restart it. This requires scheduling a time and is
> unacceptable. Also, the uploaded datasource may corrupt/overwrite the
> data as it is not up to date. Employer will not spring for extra
> datasources to be hosted. ( multiple applications and domains, one
> datasource, yay! ;) )
> 
> Goal:
> To be able to add tables to the datasource without scheduling a
> shutdown and uploading entire datasource.
> 
> Resources:
> MS Access 97
> CF 4.5
> CuteFTP
> Budget =$0
> 
> Is this possible? Please direct me to resources that will show me how.
> 
> Also, anyone know what the 20 or so CFML tags supported by CFExpress
> are?
> 
> Yours In Conservation,
> 
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
> 
> P.S. You may want to check out the fresh new look of www.OFAH.org
> Launched 1st November 2000.
> Don't forget our other great sites:
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net -  Where to find out and learn about the Ontario Hunter
> Education Program.
> 
> 
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Default Error page look...

[Peter Alexandrou]

Use your own JavaScript code rather than CF's in-built.

> -Original Message-
> From: Bill Killillay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 9 November 2000 07:08
> To: CF-Talk
> Subject: Default Error page look...
> 
> 
> When using the method of formfield_required in a hidden form
> field and then passing that on if that form field is not
> filled in it gives a default error page saying these
> required fields are not filled in please hit back, etc, etc.
> Anybody know of a way to change the look of that page.  This
> is just a detail thing, most people if they have JavaScript
> enabled will never even see this if they don't fill in a
> required field, but in the case that they do, I would like
> to control the look of this page too.  Anybody know what it
> is, where it is so that we can make it look like the rest of
> the site?  Thanks.
> 
> Bill
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: 
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send 
> a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: COM objects

[Eric Fickes]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C049E6.BDE63900
Content-Type: text/plain;
charset="iso-8859-1"

Checkout http://www.microsoft.com/com/

E

-Original Message-
From: Robert M. Saxon, Jr. [mailto:[EMAIL PROTECTED]]

I have some experience writing programs in C++ and VB, but I don't have
experience writing COM objects.  I am looking for any recommendations of
books or other resources (web sites, etc.) that would help me learn how to
design COM objects, especially in a way that could augment web apps (using
CF) and databases (like SQL Server).

Thanks,

Rob



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

--_=_NextPart_001_01C049E6.BDE63900
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: COM objects



Checkout http://www.microsoft.com/com/" =
TARGET=3D"_blank">http://www.microsoft.com/com/


E


-Original Message-
From: Robert M. Saxon, Jr. [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]


I have some experience writing programs in C++ and =
VB, but I don't have
experience writing COM objects.  I am looking =
for any recommendations of
books or other resources (web sites, etc.) that =
would help me learn how to
design COM objects, especially in a way that could =
augment web apps (using
CF) and databases (like SQL Server).


Thanks,


Rob


---=
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
 or send a message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]



--_=_NextPart_001_01C049E6.BDE63900--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Client Settings???

[Auction Hard Drive]

I'm all set up now.
thanks for all of the help,
Rich

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 6:03 PM
To: CF-Talk
Subject: Re: Client Settings???


Have you tried StructDelete()?

- Original Message -
From: "Auction Hard Drive" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 8:57 AM
Subject: Client Settings???


> How do I clear the Client Management settings??  I don't want to set them
to
> blank, I want to completely remove them so a user can login by setting
them
> and log out by deleting them.
>
> Thanks,
> Rich
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

It doesn't look like it is the machine...

[jonathan hamner]

Hi All,
There is a problem with our web site.

I have to restart the CF Server twice and somtimes
more than that daily because the web site becomes
"non-responsive". 

Sometimes I get Dr' Watson's error when I try to stop
the service. The "% of cpu usage" is in the 6-8% range
with spikes to 30%+ every so often. Memory usage is
below what is physically installed so I don't think
the machine itself is having a problem.

Could this be a problem with settings in cfadmin? or
is it something else.

Help!!

Thanks



__
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: (SQL) What is the proper way to do this?

[Steve Bernard]

What do your tables look like?

Steve

-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 2:43 PM
To: CF-Talk
Subject: (SQL) What is the proper way to do this?


A Sports Standings query.

Just using access for now. but basically I am using 4 access queries to 
accomplish my standings calculation

1.) Calculate TeamName W L Pts GF GA for home games
2.) Calculate TeamName W L Pts GF GA for visitors
3.) Union the two tables
4.) Summarize and sort.

I am guessing that this could be easily done with 1 query doing it all.

What are other people doing?

http://www.rivercityhockey.net

Eric

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: OFF TOPIC - HEALTH INSURANCE

[Stephen M. Aylor]

Dan, 

Thanks for backin my action man. :-)

We talked off line already - its all cool.

Steve

- Original Message - 
From: "Dan O'Keefe" <[EMAIL PROTECTED]>

> He apologized immediately after that as a mistake. Lighten up.
> 
> Dan
> 




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: ASP and ColdFusion

[Walker, Matthew]

> Can this all flow with security/ session management?  Would I 
> have to manage
> within ASP?  or could I use CF for security?

If you used a cookie for security (rather than ASP/CF Session variables),
presumably it would work in both the ASP pages and the CF pages?

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: fusebox

[Gregory Harris]

My 2 cents on Fusebox here, in 6 months of using this I've discovered:

1) Development takes slightly longer, but any expert developer won't feel a
difference
2) New functions later on become so much easier to build (just a new fuse)
3) Modifications to existing stuff is easier (usually just building a new
fuse or swapping an include)
4) Graphics people that are CF Illiterate find it easier to build around
Cold Fusion (they even claim they can understand the code in a display
page...whooaaa)
5) Speed of an application is barely slower...usually the extra CFINCLUDE's
take some extra processing time, but nothing significant, and good servers
are cheap
6) Apps seem to turn out smaller, granted it's easier to recycle more code
and sharing variables globally is much easier

Anybody dare try and contest this?


Gregory Harris
Web Developer
Stirling Bridge Group LLC

- Original Message -
From: "Craig Bowes" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 10:44 AM
Subject: Re: fusebox


> funny, I found that it DECREASES development time, once I learned it
pretty
> well.
>
> - Original Message -
> From: "Karl Simanonok" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, November 07, 2000 12:21 PM
> Subject: Re: fusebox
>
>
> > Like I said: we've used Fusebox (you found proof), and having done so,
> > discovered that any benefits it may have are marginal at best.  That
> > doesn't mean we're going to rewrite everything we've done in it!  I've
> > still got old Perl code running from before CF was born (and somebody
> > might even ask me to write some more someday), but it doesn't mean I'm a
> > Perl fan of any kind.
> >
> > I forgot to acknowledge another Fusebox 'benefit' yesterday: since it
> > increases development time, you get to pad your clients' bills by using
> > it.  ;)
> >
> > Regards,
> >
> > Karl S.
> >
> > Original Message:
> > 
> > Date: Mon, 6 Nov 2000 18:54:12 -0800
> > From: "Stephen M Aylor" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Subject: Re: fusebox / Cross Posted for annoyance
> > Message-ID: <01d201c04866$0317a840$0e01a8c0@iindev>
> >
> > huhm ... kinda weird that your site is fusebox - dontcha think?
> >
> > Steve
> >
>
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

GRABBING, JAVASCRIPT, VARIABLES, IN, CF

[S R]

How do I set a variable in CF from a javascript?

Ex:



document.write("You're using: "+navigator.appName+" 
"+navigator.appVersion+"");



I would like to set this as a session variable. I cannot do this because I 
tried:



Thanks

Sal
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Submitting form with Javascript

[Jann VanOver]

One Caveat that kept catching me -- when you use the "submit()" method to
submit a form, the "onSubmit" will NOT be executed.  I had to learn to
explicitly call any javascript that I wanted to be executed before the form
was submitted.

-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 9:39 PM
To: CF-Talk
Subject: Re: Submitting form with Javascript


Click to
submit
-David

On Thu, 2 Nov 2000 23:07:54 +0902 "Joseph J. Sanger, M.D."
<[EMAIL PROTECTED]> writes:
> This is simple, but I am not a javascript maven  I wish to submit 
> 
> a form by clicking in a link, rather than pressing the submit 
> button. 
> Isn't this possible with some javascript function in the URL of the 
> anchor?  Could someone remind me what this should look like? 

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Installing CF4.5 SP 1

[Jacob Ezzell]

Has anyone installed SP1 on their server?  We were all ready to, but it
looks like it will completly over-write the installation instead of
upgrading it.  Any input?

Jacob Ezzell


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: HTML Question - "Back" button

[Auction Hard Drive]

This works too:




Rich

-Original Message-
From: Eric Fickes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 1:05 PM
To: CF-Talk
Subject: RE: HTML Question - "Back" button


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C049AE.7A8EC790
Content-Type: text/plain;
charset="iso-8859-1"

See if adding this link will help.

Back

E

-Original Message-
From: Jamie Symonds [mailto:[EMAIL PROTECTED]]

I'm not sure how to go about solving this - I follow a link from the
page, and click the browser's "back" button to return to my page, and it
lands me dead in the middle, nowhere near the link that I had followed,
and my place is lost.  I could place 's in the HTML, but most
of the links are to others' pages.  As a last resort, I could chop the
page into several smaller pages.

http://www.stfx.ca/campus/service/academic_funding_and_research/

Any ideas would be great.  Thanks!
-Jamie




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

--_=_NextPart_001_01C049AE.7A8EC790
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: HTML Question - "Back" button



See if adding this link will help.


Back


E


-Original Message-
From: Jamie Symonds [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]


I'm not sure how to go about solving this - I follow =
a link from the
page, and click the browser's "back" =
button to return to my page, and it
lands me dead in the middle, nowhere near the link =
that I had followed,
and my place is lost.  I could place 's in the HTML, but most
of the links are to others' pages.  As a last =
resort, I could chop the
page into several smaller pages.


http://www.stfx.ca/campus/service/academic_funding_and_research/=
" =
TARGET=3D"_blank">http://www.stfx.ca/campus/service/academic_funding_and=
_research/


Any ideas would be great.  Thanks!
-Jamie



---=
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
 or send a message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]



--_=_NextPart_001_01C049AE.7A8EC790--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Fannie-packs? (RE: fusebox)

[Parker, Kevin]

Same over these parts (excuse the pun)



Kevin Parker
Service and Communication
WorkCover Corporation

[EMAIL PROTECTED]

ph:  +61 8 82332548
fax: +61 8 82332000



-Original Message-
From: Len Conrad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 8 November 2000 5:32:PM
To: CF-Talk
Subject: RE: Fannie-packs? (RE: fusebox)



>Round these parts a "fanny" is slang for a woman's frontal privates :-)

.au =  upside down AND backwards   :-)))

Len


http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5 & 8.2.3 T6B for NT4 & W2K
http://IMGate.MEIway.com:  Build free, hi-perf, anti-spam mail gateways



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]




This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: RDS and NT holding a lock on a file

[Steve Bernard]

It is the behaviour of IIS, not the OS. It retains a hold on files for 60
sec. to optimize performance. I remember seeing the topic come up before
but, I don't remember if there is a registry/metabase hack for it or not.

They use a lot of NT over at Figleaf ... Dave?

Steve

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 12:32 PM
To: CF-Talk
Subject: RE: RDS and NT holding a lock on a file


I wonder if it has to do with CF being set up as a script engine? I don't
see this problem (though I have seen it with straight HTML files) on my
servers where CF is configured as a script engine.

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 11:22 AM
To: CF-Talk
Cc: Paul Edwards
Subject: RDS and NT holding a lock on a file


There was a thread a while ago about NT (I think) holding a lock on a file
for 60 seconds. I'm finding if request a .cfm file in a browser and then try
and open the same file via RDS in Studio, Studio throws this error:

   Error attempting to read data from file F:/pathtofile/file.cfm  Error
= There was a sharing violation.

If you click OK, after about a minute you can open the file and edit away.

We're not having this problem with other servers and our network admin has
just turned off "Keep Alives" on the server in question but no dice.

Any suggestions? This is driving me mad (you want a file? wait a minute,
then you can have it  ;-).


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

OT: Database replication

[David Cummins]

Hi people,

I've been asked to provide a client with a report on two-way data replication
methods, and the pros and cons of them.

I'm a little in the dark, because we normally just do the odd XML feed, etc.
Could anybody tell me about the options they know of, and their experiences
with  them? For example, I've been asked to look at datamirror.com, but that's
not going to give me any idea of how difficult it was to implement their
solution, and any downside to it.

David Cummins

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Room Reservation tool

[S R]

Hi,

Does anyone know of a Room Reservation tool that is out there, preferably 
built in CF or integrates with CF, or maybe it does not have to integrate. I 
can build one, but if there is something out there already that is already 
built I can tweak it to my specifications. We have some conference rooms 
here at my company that people can reserve through a web interface, but it 
also needs to be able to show day by day, probably through a day by day 
calendar or list by date, which rooms are being used and for how long. It 
looks like I'll probably have to build it but like I said, if there is 
something our there that comes close to this, I'd rather do that.

Thanks

Sal
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Null Values

[Gena]

> > 
> > here is some stuff if whatever is null
> > 

What about



Gennadi


- Original Message -
From: "Jaime Garza" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 4:29 AM
Subject: RE: Null Values


> It is also an ODBC function
>
> {fn ISNULL(a, b)}
>
> if a is null take the value of 'b' otherwise use 'a' itself.
>
> 
>
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 08, 2000 7:33 AM
> > To: CF-Talk
> > Subject: RE: Null Values
> >
> >
> > IsNull() does not exist in Cold Fusion. It is a vbscript function.
> >
> > What I always do is:
> >
> > 
> > here is some stuff if whatever is null
> > 
> >
> >
> >
> > chris.alvarado
> > cold.fusion - developer
> > [phone] 512.794.6563
> > [email] [EMAIL PROTECTED]
> > [web] http://www.tmanage.com
> >
> >
> > Privileged/Confidential Information may be contained in this
> > message. It is
> > not for use or disclosure outside TManage without a written proprietary
> > agreement.  If you are not the addressee indicated in this
> > message, or agent
> > responsible for delivery, you may not copy or deliver this message to
> > anyone.  Please notify the sender as soon as possible and immediately
> > destroy this message and its attachments entirely.
> >
> >
> >
> > -Original Message-
> > From: Corina S. Moore [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 08, 2000 9:19 AM
> > To: CF-Talk
> > Subject: Null Values
> >
> >
> > One quick question,
> >
> > I thought that there was a function called IsNull() however whenever
I
> > try to use it
> >  gives me an error of "There is no ColdFusion function named IsNull".
> > I am running 4.0 but have looked in both 4.0 and 4.5 documentation
and
> > have found anything one
> > it. Can someone Clear this up for me?
> >
> > Thank You
> >
> > Cori
> >
> >
> >
> > --
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > or send a
> > message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > or send a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> >
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Remote DB Alteration

[Edward Peloke]

Guy,

Hello, how are you?  Can't you just make your changes to the database
through queries(such as create table, drop table, insert, update, etc) that
you pass through cold fusion?  Why would you need to restart the cfserver?
Maybe I don't understand the question.

Eddie

-Original Message-
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 11:15 AM
To: CF-Talk
Subject: Remote DB Alteration


Hello CF'ers

Situation:
Database and sites hosted externally, site created internally.
Currently if any changes to the datasource's structure are made they
are made locally and then uploaded to the host, who has to shut off
the CFServer and restart it. This requires scheduling a time and is
unacceptable. Also, the uploaded datasource may corrupt/overwrite the
data as it is not up to date. Employer will not spring for extra
datasources to be hosted. ( multiple applications and domains, one
datasource, yay! ;) )

Goal:
To be able to add tables to the datasource without scheduling a
shutdown and uploading entire datasource.

Resources:
MS Access 97
CF 4.5
CuteFTP
Budget =$0

Is this possible? Please direct me to resources that will show me how.

Also, anyone know what the 20 or so CFML tags supported by CFExpress
are?

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out the fresh new look of www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: ranking a download count.

[Christopher Olive, CIO]

the last sentence doesn't really make sense.  you'd like to display the
files by download count, but without ordering by download count?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 11:31 AM
To: CF-Talk
Subject: ranking a download count.


Im not sure how to go about this.  I'm writing a download count to a
database so i can keep track of how many times each file is downloaded.
However, i'd like to display the the files ranking in a top 100 sort of list
only not in order from 1-100.  How would i output their rank according to
the amount of times the file has been downloaded without listing the items
in a desc order by download count?


Thanks,
   Emmet


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Remote DB Alteration

[Eron Cohen]

(repost due to missing subject line--sorry)


Hi Guy,

You can do table alteration via SQL.

I refer you to the following resource which describes
"Jet SQL" and amoung other things how to create/alter
tables via SQL:

http://www.citilink.com/~jgarrick/vbasic/database/jetsql.html#ddl

I do have a few other suggestions for you.

1) Get them to use SQL Server (you can access a SQL
Server database remotely, and make changes to it, and
it will not even take down the site while you're
making changes).  This is going to be difficult with
your $0 budget though.

2) Sometimes you can "break the lock" that's on the
SQL database by doing a query with a non-existant
field name in it.  This will cause ColdFusion/ODBC to
throw an error and for some reason break the lock on
the database.  This would let you upload a new
database (but you still have the synchronization
problems to contend with)

3) Move to a hosting provider like EDGEWEBHOSTING.COM
that gives you utilities to start and stop coldFusion
yourself AND to add Datasources yourself (I don't
think this company charges for that at all and they
have very competitive rates)

Hope something here helps you out.

Eron Cohen

-Original Message-
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 11:15 AM
To: CF-Talk
Subject: Remote DB Alteration 


Hello CF'ers

Situation:
Database and sites hosted externally, site created
internally.
Currently if any changes to the datasource's structure
are made they
are made locally and then uploaded to the host, who
has to shut off
the CFServer and restart it. This requires scheduling
a time and is
unacceptable. Also, the uploaded datasource may
corrupt/overwrite the
data as it is not up to date. Employer will not spring
for extra
datasources to be hosted. ( multiple applications and
domains, one
datasource, yay! ;) )

Goal:
To be able to add tables to the datasource without
scheduling a
shutdown and uploading entire datasource.

Resources:
MS Access 97
CF 4.5
CuteFTP
Budget =$0

Is this possible? Please direct me to resources that
will show me how.

Also, anyone know what the 20 or so CFML tags
supported by CFExpress
are?

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out the fresh new look of
www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your
bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades
1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog
Heritage.
www.AHTV.com - Your online companion to the Angler and
Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the
Ontario Hunter
Education Program.




Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists
or send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

__
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in
one Place.
http://shopping.yahoo.com/

Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists
or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]

__
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

My emails - sorry

[Eric Fickes]

Hello all,

I have to apologize to the list for my messages.  It appears that when I
send new mail to the cftalk list they appear just fine, but if I reply to
messages, they always start with:

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C049A7.7788A830
Content-Type: text/plain;
charset="iso-8859-1"

I don't know what the deal is.  I can't tell you how much I hate it when
people send their email in  to lists like this.  I'm using OL2000.
Under Tools/Options the Mail Format is Plain Text (like it always has been).
Under the cftalk properties in my address book, plain text is selected.
Like I said before, I don't have this problem with any other list, or
person.  I'm going to continue to troubleshoot this, but I wanted to let
everyone know that I'm aware of my emails being formatted this way.

E

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Mixing ASP and CF on a server

[Jacob Ezzell]

Unfortunatly, its not quite so small of an application that conversion is an
option, and no-one in our shop has _any_ ASP Experience.  The Bosses want to
run the server ASP/Cf, and have us set up the application and not mess with
it.  I think we have a contract that only allows us to install it, not to
change the code.

Jacob Ezzell

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 6:40 PM
To: CF-Talk
Subject: RE: Mixing ASP and CF on a server


If it's so small why not just convert it to CF. I have done this many times
to get around having to call pages with CFHTTP. It takes a little time up
front but it's worth it, especially since you say it's a small application.

Bob Everland

-Original Message-
From: Jacob Ezzell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 2:21 PM
To: CF-Talk
Subject: Mixing ASP and CF on a server


Our company just purchased a small application that they want integrated
into our exisiting CF driven site.  The software runs on ASP and SQL.
Obviously to do this properly, we would have to have ASP and CF running on
the same server, (we only have one...) and either have a page with some CF
for our headers and then the rest ASP, or we would have to have a page that
is ASP and static headers/footers.  Either way, CF and ASP would have to be
active on the server at the same time.  Ive heard rumors that this is a
"Really Bad Idea."  Has anyone had experience trying to set somthing like
this up?

Thanks,

Jacob Ezzell
Web Developer
Healthwell.com



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

date comparisons

[Willy Ray]

One of the fields in my table is a datestamp.  I need to be able to pull only those 
records whose datestamps are between certain dates.  I would like to limit my query to 
only pull the records I need based on their dates, but frankly this app will be 
getting low enough usage that if I could pull all records and then evaluate whether or 
not to print them, that would be fine, too.  

Second question:  Is there a good simple sql book that I could get that would keep me 
from having to bug the smart people everytime I can't figure out some stupid syntax 
problem?

Willy


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

Can I get a subtotal

[Kathy Bergman]

I have been struggling with this for days so I am going to try to be very clear in 
relating my problem.

On the first page I have select boxes with option choices ranging from 1-10 that are 
generated dynamically, from database fields.  Currently the code below generates 34 
select boxes for 34 different products.  This page works correctly.



#prod_desc#
 

1
2
3
4 
etc...






On the next page, I am able to loop through the field names and output how many of 
which product were selected:



Select Price, Prod_desc, prodcode,
>From Prodcodes
Where prodcode = '#listelement#'












 #getproducts.prod_desc#
#NumberFormat(Getproducts.Price,'$9(.99)')#
#thisvalue#
#NumberFormat(itemsubtotal,'$9(.99)')#



 

This is where I become perplexed.  What I need to do next, is output subtotal amounts 
showing quantity of all products picked and a sum of their prices.

I have tried everything I can think of to no avail.  Here, is the mumbo jumbo I'm 
trying to do:




 



Subtotal
 nbsp;
 #itemsordered#
 #NumberFormat(OrderSubTotal,'$9(.99)')#


Sales Tax
 
  
 #NumberFormat(SalesTax,'$9(.99)')# 
 
   
Shipping 
 
 
#NumberFormat(Shipping,'$9(.99)')#

  
  TOTAL
 
   #TotalQty#
 #NumberFormat(OrderTotal,'$9(.99)')# 
  

 

Any help would be GREATLY appreciated.  I have considered another list, an array and 
using sum in the query.  Nothing gives me the right outputs.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

Default Error page look...

[Bill Killillay]

When using the method of formfield_required in a hidden form
field and then passing that on if that form field is not
filled in it gives a default error page saying these
required fields are not filled in please hit back, etc, etc.
Anybody know of a way to change the look of that page.  This
is just a detail thing, most people if they have JavaScript
enabled will never even see this if they don't fill in a
required field, but in the case that they do, I would like
to control the look of this page too.  Anybody know what it
is, where it is so that we can make it look like the rest of
the site?  Thanks.

Bill


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Client Settings???

[Dylan Bromby]

Have you tried StructDelete()?

- Original Message -
From: "Auction Hard Drive" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 8:57 AM
Subject: Client Settings???


> How do I clear the Client Management settings??  I don't want to set them
to
> blank, I want to completely remove them so a user can login by setting
them
> and log out by deleting them.
>
> Thanks,
> Rich
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

OT: COM objects

[Robert M. Saxon, Jr.]

I have some experience writing programs in C++ and VB, but I don't have
experience writing COM objects.  I am looking for any recommendations of
books or other resources (web sites, etc.) that would help me learn how to
design COM objects, especially in a way that could augment web apps (using
CF) and databases (like SQL Server).

Thanks,

Rob


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

(SQL) What is the proper way to do this?

[Eric Dawson]

A Sports Standings query.

Just using access for now. but basically I am using 4 access queries to 
accomplish my standings calculation

1.) Calculate TeamName W L Pts GF GA for home games
2.) Calculate TeamName W L Pts GF GA for visitors
3.) Union the two tables
4.) Summarize and sort.

I am guessing that this could be easily done with 1 query doing it all.

What are other people doing?

http://www.rivercityhockey.net

Eric
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Client Settings???

[Bud]

On 11/8/00, Auction Hard Drive penned:
>How do I clear the Client Management settings??  I don't want to set them to
>blank, I want to completely remove them so a user can login by setting them
>and log out by deleting them.





-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: FW: Login and Clustering

[Billy Cravens]

Perhaps a client structure, containing something like loginid and
timestamp.  Check to see if the loginid has timed out (Your own custom
value here, nothing ColdFusion specific)

-- 
Billy Cravens
[EMAIL PROTECTED]

Sandra Clark wrote:
> 
> -Original Message-
> From: Sandra Clark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 1:53 PM
> To: [EMAIL PROTECTED]
> Subject: Login and Clustering
> 
> I am working on the architecture for my next site, which HAS to work in a
> Clustering (non sticky-sessioned) environment.
> 
> I have figured out how to save complex data types (arrays, structures,
> queries) using WDDX and Client variables.
> 
> However, the problem I am stuck on is how the heck to I know whether or not
> a user is currently logged in across a cluster?
> 
> I have been using a Sesson variable so that even if a user doesn't logout it
> times itself out in 20 minutes. Obviously I can't do that with a Client
> variable. So how do I determine across a cluster whether a user has
> currently logged in ? While still maintaining the integrity of the
> application?
> 
> Has anyone done anything like this? Any clues, directions you can point me
> to?
> 
> 
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Client Settings???

[Bill Killillay]

Rich,

> How do I clear the Client Management settings??  I don't
want to set them to
> blank, I want to completely remove them so a user can
login by setting them
> and log out by deleting them.

this is what I use to kill them all in a logoff action.





Hope this helps,

Bill





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

ASP and ColdFusion

[Stu Williams]

Help!

I am wondering how (in a general sense) if at all you could have a
ColdFusion website which uses application.cfm. in conjunction with ASP
pages.  In this site I am using VBScript to populate forms (I cannot change
this), and I believe I will have several ASP pages (like ones which give an
html form, and submit that form to adobe pdf's.  What I would like to do, is
to use ColdFusion to pull the data from the website and put it into a
database.  The data is very sensitive so I would like to have some session
management/security.  Can I do this in a mixed environment (ASP/ColdFusion),
and are there any tricks, hints I would need to know?  I will have to use
several ASP pages, so I cannot redesign the site in CF, and it will have to
be a secure website.

For example,

CFlogin.cfm -->index.cfm ---> (choose your form) ---> form.asp --->
(dynamically) populateform.asp ---> (submitform) --->

Dataprocessing.cfm ---> index.cfm


Can this all flow with security/ session management?  Would I have to manage
within ASP?  or could I use CF for security?

Thank you in advance!
Stuart Williams
[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: OFF TOPIC - HEALTH INSURANCE

[Dan O'Keefe]

He apologized immediately after that as a mistake. Lighten up.

Dan

-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 10:27 AM
To: CF-Talk
Subject: Re: OFF TOPIC - HEALTH INSURANCE


Why is this wasting space in MY mailbox?
Take it off list please.

At 09:26 PM 11/7/00 -0800, Stephen M. Aylor wrote:

>John,
>
>I rec'd the quote(s) back from the broker this afternoon via snail.  Im
>reviewing them.  Couple things come to mind.
>
>1. Did you guys want me to come over and vist to discuss??  I figure you've
>been thru the Health insurance Dawg and Pony a couple times ..
>
>2. What are some of the things you liked about HealthNet?  Price?
>
>3. Do we have any physicians that are a must?
>
>4. Whats more important - lower out of pocket costs to employees or choice
>of Dr.'s?
>
>5. What % of the employee premium is "EmployER" paid?  Dependent premium?
>
>6. Out of State Employees?
>
>All the best,
>
>Stephen M. Aylor
>Aylor Insurance Agency, Inc.
>"Specialized insurance for Technology Risks"
>[EMAIL PROTECTED]
>949.581.2333 voice
>949.581.2814 fax
>
>
>---
-
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

[RE: Fusebox] CFObjects VS Fusebox

[Craig Bowes]

This is a multi-part message in MIME format.

--=_NextPart_000_0085_01C04983.40B74570
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

All,   =20

Now that we've all argued fusebox and self-righteously flamed its =
detractors, has anyone used CFObjects very much?  How does it compare to =
fusebox in making a more understanable application closer to the =
client's needs?  Is it just for Java/C++ developers who want something =
OO familiar or does it have more universal benefits?  Does it cure =
baldness like Fusebox?  Who will be the next president? =20

-Craig Bowes
Coldfusion Programmer
[EMAIL PROTECTED]
972.243.1171

--=_NextPart_000_0085_01C04983.40B74570
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








All,    
 
Now that we've all argued fusebox and=20
self-righteously flamed its detractors, has anyone used CFObjects very=20
much?  How does it compare to fusebox in making a more =
understanable=20
application closer to the client's needs?  Is it just for Java/C++=20
developers who want something OO familiar or does it have more universal =

benefits?  Does it cure baldness like Fusebox?  Who will be =
the next=20
president?  
-Craig BowesColdfusion =
Programmermailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]972.243.1171

--=_NextPart_000_0085_01C04983.40B74570--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

cfmail headers

[Sean Daniels]

I know that with CF 4.5 you can send custom headers in an email using
cfmailparam, but is there any way to do this with CF 4.01? I need to send a
content-type header for a special email that gets parsed by the GoldMine
contact manager database.

Also, I have limited ability to use custom tags, so IMS is out. I can only
use coldfusion custom tags that can be called with cfmodule.

TIA.


- Sean


  Sean Daniels
  Manager, Engineering
  Marketplace Technologies
  (t) 207.439.6030
  (c) 207.332.6340


http://www.dealforce.com
http://www.dealstream.com
http://www.mergernetwork.com


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Remote DB Alteration

[John Allred]

   
   
"Guy J.
   
McDowell"  To: CF-Talk <[EMAIL PROTECTED]> 
   
 Subject: Remote DB Alteration   
   
   
   
11/08/2000 
   
10:14 AM   
   
Please respond 
   
to cf-talk 
   
   
   
   
   








Also, anyone know what the 20 or so CFML tags supported by CFExpress
are?

===
CFABORT, CFAPPLICATION, CFBREAK, CFCOOKIE, CFIF/CFELSIF/CFELSE, CFINCLUDE,
CFINSERT, CFLOCATION, CFLOOP, CFOUTPUT, CFPARAM, CFQUERY, CFSET, CFSETTING,
CFSWITCH/CFCASE/CFDEFAULTCASE, CFUPDATE





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: fusebox

[Craig Bowes]

funny, I found that it DECREASES development time, once I learned it pretty
well.

- Original Message -
From: "Karl Simanonok" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 07, 2000 12:21 PM
Subject: Re: fusebox


> Like I said: we've used Fusebox (you found proof), and having done so,
> discovered that any benefits it may have are marginal at best.  That
> doesn't mean we're going to rewrite everything we've done in it!  I've
> still got old Perl code running from before CF was born (and somebody
> might even ask me to write some more someday), but it doesn't mean I'm a
> Perl fan of any kind.
>
> I forgot to acknowledge another Fusebox 'benefit' yesterday: since it
> increases development time, you get to pad your clients' bills by using
> it.  ;)
>
> Regards,
>
> Karl S.
>
> Original Message:
> 
> Date: Mon, 6 Nov 2000 18:54:12 -0800
> From: "Stephen M Aylor" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Subject: Re: fusebox / Cross Posted for annoyance
> Message-ID: <01d201c04866$0317a840$0e01a8c0@iindev>
>
> huhm ... kinda weird that your site is fusebox - dontcha think?
>
> Steve
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: fusebox

[Craig Bowes]

Just out of curiousity, do you use any kind of methodology for you CF
applications?  Most people that have really used fusebox seemed to like it
and CFObjects sounds interesting also.  How do you get away from having a
million cfincludes w/in cfincludes or knowing which files do what?  What is
wrong with the naming conventions?  VB has the same thing, really.

I do have concerns about the increased processing time but I've never seen a
huge increase in my applications.  I try to break down each part of the app
in separate folders so its index file isn't really that monolithic.  Most of
the apps I do are fairly complex so having things fit a system seems to work
for me.

-Craig Bowes
Coldfusion Programmer
[EMAIL PROTECTED]
972.243.1171



- Original Message -
From: "Karl Simanonok" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 06, 2000 3:47 PM
Subject: Re: fusebox


> I have used the Fusebox development methodology for several projects, as
> have most of the developers I work with.  We all dislike it.  It
> slightly increases development time, obfuscates CF debugging, and
> necessitates superfluous code and processing time by routing every page
> call through an index.cfm.  We now only use it when clients insist that
> they want their applications built around it (usually they've heard a
> little about Fusebox and think it's cutting-edge so they want it without
> really understanding it).
>
> A well-designed and well-written application does not need to be redone
> in Fusebox to make it better.  However, a poorly-designed or
> poorly-written application may benefit from Fusebox because then it will
> be somewhat easier for later programmers to come in and fix it.  I would
> only recommend that a new application be written Fusebox-style if it is
> going to be very large and complex, there will be a lot of developers
> working on the application, and if many of those developers are
> ColdFusion beginners (and then only if you ignore the terrible
> filenaming conventions).  That's because Fusebox does have some value in
> making the page-flow logic easier to follow for people who are not
> familiar with all of the application, or who are CF beginners.  That's
> its only significant advantage. Otherwise you can avoid some unnecessary
> development time (and later CPU overhead) and focus on programming the
> application's logic flow according to your business needs rather than
> shoehorning it into the somewhat arbitrary Fusebox development
> methodology.
>
> If you're really having trouble deciding whether to use Fusebox or not,
> it may be helpful if you ask yourself what's more important in your
> situation: adopting the latest fads in CF development methodologies, or
> optimizing your application?
>
> Regards,
>
> Karl Simanonok, staff consultant
> Advanta Solutions, Inc.
>
> Original message:
> ===
> Date: Fri, 3 Nov 2000 17:35:26 -0600
> From: "Craig Bowes" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Subject: Re: fusebox
> Message-ID: <005801c045ee$becf3f00$[EMAIL PROTECTED]>
>
> Yes!  Fusebox rocks.  It has made my code smaller, more manageable, more
>
> reuseable and easier to understand while being loose enough to let me do
>
> whatever I need to get the job done.  I HIGHLY recommend fusebox to any
> CFDeveloper.  It is based on Object Oriented Concepts that standard
> desktop
> programming environments have had for years but which web development
> hasn't
> been really able to take advantage of.
>
>   The new job I am at has adopted it as company policy because of me and
> so
> did my last job.  Also, fUseML is pretty useful although I am still
> learning
> it.  They have a book published on Fusebox and fuseml that looks pretty
> good.  The print version hasn't been shipped yet but if you buy it you
> get
> the .PDF version pretty quick and then the print later.
>
> go to http://www.fusebox.org
>
> -Craig Bowes
> Coldfusion Programmer
> [EMAIL PROTECTED]
> 972.243.1171
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, November 03, 2000 2:53 PM
> Subject: fusebox
>
>
> > Is anyone out there using the fusebox methodology?
> >
> > I have recently started this position here and I am the Cold Fusion
> lead
> and
> > I was toying with the idea of recommending that we use the Fusebox
> method
> > for the complete REdeployment of our corporate Intranet.
> >
> >
> > any feedback is well appreciated.
> >
> > chris.alvarado
> > cold.fusion - developer
> > [phone] 512.794.6563
> > [email] [EMAIL PROTECTED]
> > [web] http://www.tmanage.com
> >
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

-

Re: Potential problems with CF Express Server

[Jim McAtee]

> > Yes. This is exactly what I'm talking about. They want to be 
> > cheap and use 
> > CF Express, and I of course don't want that.
> > 
> > I need to convince these folks that CF Express is NOT the way 
> > to go for 
> > hosting a large ecommerce site.
> > 
> > What good (realistic) reasons can I give them to go to the Pro
> > server?  
> 
> Just out of curiosity...  How much are these folks paying you, and
> will you be paid up front or are you actually going to have to bill
> these tight wads & hope to get your money out of them?...
> 
> My advice would be drop them before it's too late and you have hours
> of code written & nothing to show for it...



Amen to that.  Of course, he's going to tell us he works for them.  If so:

G-e-t  a-n-o-t-h-e-r  j-o-b.




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFLDAP

[Eric Fickes]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C049B2.0C50
Content-Type: text/plain;
charset="iso-8859-1"

Yeah, I've seen all of this, but for some reason I feel as if I'm still
missing something.  If this is setup and enabled, does this automatically
connect to the main exchange db?  I was under the impression that I still
had to set up a directory for the LDAP to connect to.

E

-Original Message-
From: Jaime Garza [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 6:14 PM
To: CF-Talk
Subject: RE: CFLDAP


In Exchange 5.5, go to site/configuration/protocols and click properties on
LDAP.  It will tell you how to connect, ports, etc.  Of course it will let
you specify your login mechanisms.  Exchange will also let you override in a
per-server basis if that server supports LDAP and how.  Use
Site/configuration/servers/servername/protocols and there is LDAP waiting
for you.

You can select from clear text, clear text with SSL, NT Challenge/Response,
NT Challenge/Response with SSL and others.  If you have only test data in
your server, try setting clear text for your development phase.  I'll make
your life wy simpler.

Something I overlooked is that I have my Exchange in my Win2K Active
Directory primary server.  They both provided LDAP and it all came to work
when I moved the Exchange port different of 389.  I was in fact dealing with
Active Directory instead of Exchange!



> -Original Message-
> From: Eric Fickes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 8:55 AM
> To: CF-Talk
> Subject: RE: CFLDAP
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> --_=_NextPart_001_01C048DB.80F64CA0
> Content-Type: text/plain;
>   charset="iso-8859-1"
>
> I'm pretty sure the answer is no, but since I don't know for certain I may
> be wrong.  I haven't seen anything mentioned about SSL or NTLM at
> all in any
> documentation.  In the Exchange Admin I can set what type of
> authentication
> I want, so that's not an issue.  Unfortunately I can't find any good
> documentation.  I'm sure it's something small that I'm overlooking, I just
> can't figure out what it is.
>
> E
>
> -Original Message-
> From: Steve Bernard [mailto:[EMAIL PROTECTED]]
>
> I know nothing about Exchange but, are you sure that MS' LDAP interface
> doesnt' either require SSL or use NTLM credentials? Have you tried
> monitoring network traffic between the two to see what's going
> on? What does
> the documentation say? And post the error if possible.
>
> Steve



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

--_=_NextPart_001_01C049B2.0C50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: CFLDAP



Yeah, I've seen all of this, but for some reason I =
feel as if I'm still missing something.  If this is setup and =
enabled, does this automatically connect to the main exchange db?  =
I was under the impression that I still had to set up a directory for =
the LDAP to connect to.

E


-Original Message-
From: Jaime Garza [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]=

Sent: Tuesday, November 07, 2000 6:14 PM
To: CF-Talk
Subject: RE: CFLDAP



In Exchange 5.5, go to site/configuration/protocols =
and click properties on
LDAP.  It will tell you how to connect, ports, =
etc.  Of course it will let
you specify your login mechanisms.  Exchange =
will also let you override in a
per-server basis if that server supports LDAP and =
how.  Use
Site/configuration/servers/servername/protocols and =
there is LDAP waiting
for you.


You can select from clear text, clear text with SSL, =
NT Challenge/Response,
NT Challenge/Response with SSL and others.  If =
you have only test data in
your server, try setting clear text for your =
development phase.  I'll make
your life wy simpler.


Something I overlooked is that I have my Exchange in =
my Win2K Active
Directory primary server.  They both provided =
LDAP and it all came to work
when I moved the Exchange port different of =
389.  I was in fact dealing with
Active Directory instead of Exchange!





> -Original Message-
> From: Eric Fickes [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 8:55 AM
> To: CF-Talk
> Subject: RE: CFLDAP
>
>
> This message is in MIME format. Since your mail =
reader does not understand
> this format, some or all of this message may =
not be legible.
>
> =
--_=3D_NextPart_001_01C048DB.80F64CA0
> Content-Type: text/plain;
>

RE: Remote DB Alteration

[Jeff Beer]

Assuming you are using MSAccess:

Create an empty DB and create linked tables that point to the tables in your
real DB.  The ODBC connection can remain open, and you can upload a new DB
at any time by overwriting the real DB.  This works as long as you don't add
any tables - you'll still have to modify the DB with the linked tables.

The other route is to talk the host into turning off "Maintain database
connections" in the CF Administrator for your ODBC source.  That's the dealy
that's locking your file.

Good luck!

Jeff


> -Original Message-
> From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 11:15 AM
> To: CF-Talk
> Subject: Remote DB Alteration
>
>
> Hello CF'ers
>
> Situation:
> Database and sites hosted externally, site created internally.
> Currently if any changes to the datasource's structure are made they
> are made locally and then uploaded to the host, who has to shut off
> the CFServer and restart it. This requires scheduling a time and is
> unacceptable. Also, the uploaded datasource may corrupt/overwrite the
> data as it is not up to date. Employer will not spring for extra
> datasources to be hosted. ( multiple applications and domains, one
> datasource, yay! ;) )
>
> Goal:
> To be able to add tables to the datasource without scheduling a
> shutdown and uploading entire datasource.
>
> Resources:
> MS Access 97
> CF 4.5
> CuteFTP
> Budget =$0
>
> Is this possible? Please direct me to resources that will show me how.
>
> Also, anyone know what the 20 or so CFML tags supported by CFExpress
> are?
>
> Yours In Conservation,
>
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
>
> P.S. You may want to check out the fresh new look of www.OFAH.org
> Launched 1st November 2000.
> Don't forget our other great sites:
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net -  Where to find out and learn about the Ontario Hunter
> Education Program.
>
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Remote DB Alteration

[Bud]

On 11/8/00, Guy J. McDowell penned:
>Situation:
>Database and sites hosted externally, site created internally.
>Currently if any changes to the datasource's structure are made they
>are made locally and then uploaded to the host, who has to shut off
>the CFServer and restart it.

Why? They shouldn't have to restart CF just to overwrite a datasource.

If it's because of the database lock placed by Access, you have 2 
options. Have the host turn off "Maintain database connections" to 
the datasource in cf administration. You should do this with Access 
anyway.

Or, you can write a bad query.


SELECT nota
FROM nothing


This will return an error and break the lock on the database and you 
can upload right over it.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: HTML Question - "Back" button

[Eric Fickes]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C049AE.7A8EC790
Content-Type: text/plain;
charset="iso-8859-1"

See if adding this link will help.

Back

E

-Original Message-
From: Jamie Symonds [mailto:[EMAIL PROTECTED]]

I'm not sure how to go about solving this - I follow a link from the
page, and click the browser's "back" button to return to my page, and it
lands me dead in the middle, nowhere near the link that I had followed,
and my place is lost.  I could place 's in the HTML, but most
of the links are to others' pages.  As a last resort, I could chop the
page into several smaller pages.

http://www.stfx.ca/campus/service/academic_funding_and_research/

Any ideas would be great.  Thanks!
-Jamie




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

--_=_NextPart_001_01C049AE.7A8EC790
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: HTML Question - "Back" button



See if adding this link will help.


Back


E


-Original Message-
From: Jamie Symonds [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]


I'm not sure how to go about solving this - I follow =
a link from the
page, and click the browser's "back" =
button to return to my page, and it
lands me dead in the middle, nowhere near the link =
that I had followed,
and my place is lost.  I could place 's in the HTML, but most
of the links are to others' pages.  As a last =
resort, I could chop the
page into several smaller pages.


http://www.stfx.ca/campus/service/academic_funding_and_research/=
" =
TARGET=3D"_blank">http://www.stfx.ca/campus/service/academic_funding_and=
_research/


Any ideas would be great.  Thanks!
-Jamie



---=
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
 or send a message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]



--_=_NextPart_001_01C049AE.7A8EC790--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[Jacob]

Boolean expressions are faster.

At 09:51 AM 11/8/00 -0600, you wrote:
>and why is that?
>
>chris.alvarado
>cold.fusion - developer
>[phone] 512.794.6563
>[email] [EMAIL PROTECTED]
>[web] http://www.tmanage.com
>
>
>Privileged/Confidential Information may be contained in this message. It is
>not for use or disclosure outside TManage without a written proprietary
>agreement.  If you are not the addressee indicated in this message, or agent
>responsible for delivery, you may not copy or deliver this message to
>anyone.  Please notify the sender as soon as possible and immediately
>destroy this message and its attachments entirely.
>
>
>
>-Original Message-
>From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, November 08, 2000 9:31 AM
>To: CF-Talk
>Subject: RE: Null Values
>
>
>Much Better to do
>
>
>
>
>
>Justin MacCarthy
>
>
> >IsNull() does not exist in Cold Fusion. It is a vbscript function.
> >
> > What I always do is:
> >
> > 
> >   here is some stuff if whatever is null
> > 
> >
>
> >
>
>
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to [EMAIL PROTECTED]
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send 
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFID-CFTOKEN Confusion (newbie)

[Aidan Whitehall]

> is it possible that two (or more) users have the same cfid&cftoken ?
> 
> Wich is the best way to identify a (unique) user session ?

No. It's safe to assume that every user is assigned (and subsequently
returns) a unique CFID and CFTOKEN combination.

In fact, if you use session variables, ColdFusion makes exactly that
assumption and uses the CFID/CFTOKEN pair sent by the browser to marry up
browser requests with session variables previously set on the server.



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Fannie-packs? (RE: fusebox)

[Jaime Garza]

http://www.fanniemae.com  They claim this is the american dream...  Of
course it is!




> -Original Message-
> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 7:28 AM
> To: CF-Talk
> Subject: RE: Fannie-packs? (RE: fusebox)
>
>
> HAHA! I had no idea!
>
> That's fine, just turn the belt around, and it's still accurate :-)
>
> At 05:44 PM 11/8/00 +1100, Peter Alexandrou wrote:
> >Round these parts a "fanny" is slang for a woman's frontal privates :-)
> >
> >> -Original Message-
> >> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
> >> Sent: Wednesday, 8 November 2000 16:47
> >> To: CF-Talk
> >> Subject: Re: Fannie-packs? (RE: fusebox)
> >>
> >>
> >> In the USA it's your rear-end. So a fanny-pack is a small
> >> "backpack" or "rucksack" that you wear on a belt that hangs
> >> off your "fanny". What is a "fanny" down under?
> >>
> >> At 12:51 PM 11/8/00 +1100, BORKMAN Lee wrote:
> >> >Hi, we in Australia might be a little puzzled by
> >> "fannie-packs".  Perhaps
> >> >you are not aware that a "fanny" is something completely
> >> different in other
> >> >parts of the world.  After all, this is an international list!!!
> >> >
> >> >-Original Message-
> >> >From: William J Wheatley [mailto:[EMAIL PROTECTED]]
> >> >
> >> >... people who used to walk around with bright PINK fanny
> >> packs, now thats a
> >> >fad, ...
> >> >
> >> >
> >> >IMPORTANT NOTICE:
> >> >This e-mail and any attachment to it is intended only to be
> >> read or used by
> >> >the named addressee.  It is confidential and may contain
> >> legally privileged
> >> >information.  No confidentiality or privilege is waived or
> >> lost by any
> >> >mistaken transmission to you.  If you receive this e-mail in
> >> error, please
> >> >immediately delete it from your system and notify the
> >> sender.  You must not
> >> >disclose, copy or use any part of this e-mail if you are not
> >> the intended
> >> >recipient.  The RTA is not responsible for any unauthorised
> >> alterations to
> >> >this e-mail or attachment to it.
> >> >-
> >> ---
> >> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >> >Unsubscribe:
> >> http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> >> a message with 'unsubscribe' in the body to
> >> [EMAIL PROTECTED]
> >>
> >>
> >> --
> >> -
> >> Peter Theobald, Chief Technology Officer
> >> LiquidStreaming http://www.liquidstreaming.com
> >> [EMAIL PROTECTED]
> >> Phone 1.212.545.1232 x204 Fax 1.212.545.0938
> >>
> >> To put this contact information into your Palm device, click here:
> >> http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=9728799
> >10&type=A
> >
> >
> >-
> ---
> >
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
> >message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> >
> >-
> ---
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
>
> --
> -
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 x204 Fax 1.212.545.0938
>
> To put this contact information into your Palm device, click here:
> http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[Jaime Garza]

It is also an ODBC function

{fn ISNULL(a, b)}

if a is null take the value of 'b' otherwise use 'a' itself.





> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 7:33 AM
> To: CF-Talk
> Subject: RE: Null Values
>
>
> IsNull() does not exist in Cold Fusion. It is a vbscript function.
>
> What I always do is:
>
> 
>   here is some stuff if whatever is null
> 
>
>
>
> chris.alvarado
> cold.fusion - developer
> [phone] 512.794.6563
> [email] [EMAIL PROTECTED]
> [web] http://www.tmanage.com
>
>
> Privileged/Confidential Information may be contained in this
> message. It is
> not for use or disclosure outside TManage without a written proprietary
> agreement.  If you are not the addressee indicated in this
> message, or agent
> responsible for delivery, you may not copy or deliver this message to
> anyone.  Please notify the sender as soon as possible and immediately
> destroy this message and its attachments entirely.
>
>
>
> -Original Message-
> From: Corina S. Moore [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 9:19 AM
> To: CF-Talk
> Subject: Null Values
>
>
> One quick question,
>
> I thought that there was a function called IsNull() however whenever I
> try to use it
>  gives me an error of "There is no ColdFusion function named IsNull".
> I am running 4.0 but have looked in both 4.0 and 4.5 documentation and
> have found anything one
> it. Can someone Clear this up for me?
>
> Thank You
>
> Cori
>
>
>
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[Bill Killillay]

Think about it, if I pass a value of " " that is not a null
value.  That is a value that has a space in it.  By checking
it to see if it has length first, then trimming any leading
and trailing spaces off of it your checking to make sure
that it truly is a null value and not a blank space.  Try it
out and see.

Bill




> and why is that?

>> Much Better to do
>>
>> 
>>
>> 

>> >IsNull() does not exist in Cold Fusion. It is a vbscript
function.
>> >
>> > What I always do is:
>> >
>> > 
>> >here is some stuff if whatever is null
>> > 


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Remote DB Alteration

[Claremont, Timothy S]

Guy,

While I am still too much of a newbie to offer any real suggestion to your
dilemma, I must praise you on your ability to ask the question effectively,
and provide answers to the inevitable questions regarding your resources!

Tim


Tim Claremont
Xerox Corporation



-Original Message-
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 11:15 AM
To: CF-Talk
Subject: Remote DB Alteration


Hello CF'ers

Situation:
Database and sites hosted externally, site created internally.
Currently if any changes to the datasource's structure are made they
are made locally and then uploaded to the host, who has to shut off
the CFServer and restart it. This requires scheduling a time and is
unacceptable. Also, the uploaded datasource may corrupt/overwrite the
data as it is not up to date. Employer will not spring for extra
datasources to be hosted. ( multiple applications and domains, one
datasource, yay! ;) )

Goal:
To be able to add tables to the datasource without scheduling a
shutdown and uploading entire datasource.

Resources:
MS Access 97
CF 4.5
CuteFTP
Budget =$0

Is this possible? Please direct me to resources that will show me how.

Also, anyone know what the 20 or so CFML tags supported by CFExpress
are?

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out the fresh new look of www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: RDS and NT holding a lock on a file

[mherbene]

I wonder if it has to do with CF being set up as a script engine? I don't
see this problem (though I have seen it with straight HTML files) on my
servers where CF is configured as a script engine.

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 11:22 AM
To: CF-Talk
Cc: Paul Edwards
Subject: RDS and NT holding a lock on a file


There was a thread a while ago about NT (I think) holding a lock on a file
for 60 seconds. I'm finding if request a .cfm file in a browser and then try
and open the same file via RDS in Studio, Studio throws this error:

   Error attempting to read data from file F:/pathtofile/file.cfm  Error
= There was a sharing violation.

If you click OK, after about a minute you can open the file and edit away.

We're not having this problem with other servers and our network admin has
just turned off "Keep Alives" on the server in question but no dice.

Any suggestions? This is driving me mad (you want a file? wait a minute,
then you can have it  ;-).

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Fannie-packs? (RE: fusebox)

[Eric Fickes]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C049A7.7788A830
Content-Type: text/plain;
charset="iso-8859-1"




Keep responding

And now for something completely different


Just wanted to add my two cents.

E

-Original Message-
From: Len Conrad [mailto:[EMAIL PROTECTED]]


>Round these parts a "fanny" is slang for a woman's frontal privates :-)

.au =  upside down AND backwards   :-)))

Len


http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5 & 8.2.3 T6B for NT4 & W2K
http://IMGate.MEIway.com:  Build free, hi-perf, anti-spam mail gateways



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

--_=_NextPart_001_01C049A7.7788A830
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: Fannie-packs? (RE: fusebox)







    Keep =
responding

    And now =
for something completely different



Just wanted to add my two cents.


E


-Original Message-
From: Len Conrad [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]<=
/FONT>



>Round these parts a "fanny" is slang =
for a woman's frontal privates :-)


.au =3D  upside down AND backwards   =
:-)))


Len



http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5 & =
8.2.3 T6B for NT4 & W2K
http://IMGate.MEIway.com: ; Build free, hi-perf, =
anti-spam mail gateways


---=
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
 or send a message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]



--_=_NextPart_001_01C049A7.7788A830--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Drop down List

[monika kon]

Thank you very much,
i am really very sorry for bothering you.
It was my fault not putting the  tag..
I have got it right.
Thanks a lot for your patience.
Please tell me if you have used
"CF_Threeselectsrelated".
I was trying this and I wanted all the 3 to be
dropdown list.The example there on the site
"http://nateweiss.com/taggallery/" is of Radio buttons
and 2 dropdown list .As I said I want all the 3 to be
drop down list.
Can you please help me.
Thanks a lot.
Shally
++
--- James Taavon <[EMAIL PROTECTED]> wrote:
> This is a multi-part message in MIME format.
> --4A576A0EB0C5055670C186FA
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> 
> um, i dont see the opening form tag? can you cut and
> paste the entire
> file as you have it please?
> 
> monika kon wrote:
> > 
> > I am sending the code again,
> > CODE:
> > 
> > 
> > Untitled Document
> >  content="text/html;
> > charset=iso-8859-1">
> > 
> > 
> >  >  datasource="Catalog"
> >  dbtype="ODBC">
> > SELECT  Distinct MnGrp, MnGrp_Desc,
> ProductType,
> > ProductType_Desc
> > FROM globalkeys_FLAT
> > 
> > 
> > 
> > 
> > 
> > > QUERY="getresult"
> > NAME1="select1"
> > NAME2="Select2"
> > DISPLAY1="Mngrp_desc"
> > DISPLAY2="Producttype_Desc"
> > value1="mngrp"
> > value2="producttype"
> > FORCEWIDTH1="70"
> > FORCEWIDTH2="70"
> > SIZE1="1"
> > SIZE2="1"
> > HTMLBETWEEN=""
> > AUTOSELECTFIRST="Yes"
> > EMPTYTEXT1="(choose a category)"
> > EMPTYTEXT2="(now choose a subcategory)"
> > ONCHANGE="Submit!"
> > FORMNAME="MyOtherForm">
> > 
> > 
> > 
> > I AM UNABLE TO UNDERSTAND WHICH CFFORM YOU ARE
> TALKING
> > ABOUT ,THANKS FOR YOUR REPLY AND PATIENCE
> >
>
+++
> > --- James Taavon <[EMAIL PROTECTED]> wrote:
> > > This is a multi-part message in MIME format.
> > > --7E483AE1B1188D700B230AAD
> > > Content-Type: text/plain; charset=us-ascii
> > > Content-Transfer-Encoding: 7bit
> > >
> > > what does your CFFORM tag look like?
> > >
> > > monika kon wrote:
> > > >
> > > > Hi James,
> > > >
> > > > I am able to see only the First dropdown list
> with
> > > > unique MnGrp_Desc.The second dropdown list is
> > > showing
> > > > up nothing even if I select any thing from the
> > > first
> > > > drop down list.
> > > > Did you see the database I have sen in the
> > > previous
> > > > mail?
> > > > Shally
> > > > --- James Taavon <[EMAIL PROTECTED]>
> wrote:
> > > > > This is a multi-part message in MIME format.
> > > > > --79EE260D231C723574DB0849
> > > > > Content-Type: text/plain; charset=us-ascii
> > > > > Content-Transfer-Encoding: 7bit
> > > > >
> > > > > What exactly are youe seeing? How is the
> list
> > > > > different from your
> > > > > database?
> > > > >
> > > > > monika kon wrote:
> > > > > >
> > > > > > --0-2049339050-973275290=:67150
> > > > > > Content-Type: text/plain; charset=us-ascii
> > > > > > Content-Disposition: inline
> > > > > >
> > > > > > Hi James and Vaughan Evans!
> > > > > > Thanks a lot for ur reply.
> > > > > > I am now stuck in the query.Please help
> me.I
> > > am
> > > > > > sending the code as well as the database
> in
> > > excel
> > > > > as
> > > > > > an attachment.I have placed
> > > TwoSelectsRelated.cfm
> > > > > in
> > > > > > the folder CFUSION.But my query is not
> giving
> > > me
> > > > > the
> > > > > > proper values.
> > > > > >
> > > > >
> > > >
> > >
> >
>
++
> > > > > >  datasource="global">
> > > > > > select MnGrp,
> > > > > > MnGrp_Desc,ProductType,ProductType_Desc,
> > > > > > from Global
> > > > > > where MnGrp=Left([ProductType],1)
> > > > > > 
> > > > > >
> > > > > >
> > > > > >  Calling Cusstom Tag below (I have mine in
> a
> > > > > table)
> > > > > >  
> > > > > >  > > > > > 
> size="2">Name:Email:
> > > > > > 
> > > > > >  > > > > > query="GetResult"
> > > > > > name1="Select1"
> > > > > > name2="selet2"
> > > > > > display1="MnGrp_Desc"
> > > > > > display2="ProductType_Desc"
> > > > > > size1="1"
> > > > > > size2="1"
> > > > > > HtmlBetwwen=""
> > > > > > AutoSelectFirst="Yes"
> > > > > > EmptyText1="(choose a category)"
> > > > > > EmptyText2="(now choose a
> > > subcategory)"
> > > > > > Onchange="Submit!"
> > > > > >
> Formname="MyOtherForm">
> > > > > >
> > > > > >  
> > > > > >
> > > > >
> > > >
> > >
> >
>
+++
> > > > > > --- James Taavon
> <[EMAIL PROTECTED]>
> > > wrote:
> > > > > > > This is a multi-part message in MIME
> format.
> > > > > > > --E6147946B6907CB6F06EC99E
> > > > > > > Content-Type: 

RE: strange SQL error code

[Anthony Geoghegan]

>On that note, does anyone have a list of Microsoft SQL Error Codes?

They are listed in the online books online-reference.
If you like I'll post you a text file offlist.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Remote DB Alteration

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Here's a question:  Why use a datasource at all?  You can access MS
Access databases directly using OLE/DB, then you don't need to use a
datasource.  You'd have to change your code around, but it seems
worth it.  Here's how it would work:

In your application.cfm, do something like:


Then in your CFQuery blocks do:


Now when you need to change databases, just upload it as MyDB2.mdb,
change the application.cfm to point to the new data, and keep going. 
Very nice & easy...

Also, odds are you could use more than one database without your host
charging you for another datasource.

Best regards,
Zac Bedell


Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.

Please include original message in any replies -- I get a 
lot of email every day, and I have a REALLY bad memory... 
So I don't always remember everything that was said.  
Thanks!





> -Original Message-
> From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 11:15 AM
> To: CF-Talk
> Subject: Remote DB Alteration 
> 
> 
> Hello CF'ers
> 
> Situation:
> Database and sites hosted externally, site created internally.
> Currently if any changes to the datasource's structure are made
> they are made locally and then uploaded to the host, who has to
> shut off the CFServer and restart it. This requires scheduling a
> time and is unacceptable. Also, the uploaded datasource may
> corrupt/overwrite the data as it is not up to date. Employer will
> not spring for extra
> datasources to be hosted. ( multiple applications and domains, one
> datasource, yay! ;) )
> 
> Goal:
> To be able to add tables to the datasource without scheduling a
> shutdown and uploading entire datasource.
> 
> Resources:
> MS Access 97
> CF 4.5
> CuteFTP
> Budget =$0
> 
> Is this possible? Please direct me to resources that will show me
> how.  
> 
> Also, anyone know what the 20 or so CFML tags supported by
> CFExpress are?
> 
> Yours In Conservation,
> 
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
> 
> P.S. You may want to check out the fresh new look of www.OFAH.org
> Launched 1st November 2000.
> Don't forget our other great sites:
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net -  Where to find out and learn about the Ontario
> Hunter Education Program.
> 
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: 
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOgmJf6vhLS1aWPxeEQLwLgCgi6zwghDm0soeDBmwpRIrj8BJhl4AoPC2
b0yzMCKhohB9mi/vrNSJ56VP
=EhgJ
-END PGP SIGNATURE-

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: SQL question help

[thanh nguyen]

thanks David, it worked


>From: "Hayes, David" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: SQL question help
>Date: Tue, 7 Nov 2000 12:40:51 -0600
>
>When you are having trouble with a dynamic sql statement, output the
>statement to the page to see what is actually being sent to the db.
>
>Try replacing
>   tableB.email  NOT IN   ('#ValueList(getremovelist.email)#')
>with
>   tableB.email  NOT IN   (#QuotedValueList(getremovelist.email)#)
>
>
>Your SQL statement currently looks something like
>   NOT IN ('[EMAIL PROTECTED],[EMAIL PROTECTED],etc.')
>and you want
>   NOT IN ('[EMAIL PROTECTED]','[EMAIL PROTECTED]',etc.)
>
>
>
>
>
>-Original Message-
>From: thanh nguyen [mailto:[EMAIL PROTECTED]]
>Sent: Monday, November 06, 2000 3:56 PM
>To: CF-Talk
>Subject: SQL question help
>
>
>I want to do a filter , but somehow it does not the way i want it
>I have a table that have email field , and onther table with a field email
>who wants to  remove from the list,
>
>
>
>
>   select  email from wantoremove
>
>
>
>   SELECT DISTINCT firstname, email
>   FROM tableB
>   WHERE
>
>   tableB.email  NOT IN   ('#ValueList(getremovelist.email)#')
>
>
>Somehow when i output the GettheList query , it still showing the emails
>from the GetRemoveList query.
>
>and datatype for email fields are varchar 100
>please help
>thanks
>
>
>
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to 
>[EMAIL PROTECTED]
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a 
>message with 'unsubscribe' in the body to 
>[EMAIL PROTECTED]

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

No Subject

[Eron Cohen]

Hi Guy,

You can do table alteration via SQL.

I refer you to the following resource which describes
"Jet SQL" and amoung other things how to create/alter
tables via SQL:

http://www.citilink.com/~jgarrick/vbasic/database/jetsql.html#ddl

I do have a few other suggestions for you.

1) Get them to use SQL Server (you can access a SQL
Server database remotely, and make changes to it, and
it will not even take down the site while you're
making changes).  This is going to be difficult with
your $0 budget though.

2) Sometimes you can "break the lock" that's on the
SQL database by doing a query with a non-existant
field name in it.  This will cause ColdFusion/ODBC to
throw an error and for some reason break the lock on
the database.  This would let you upload a new
database (but you still have the synchronization
problems to contend with)

3) Move to a hosting provider like EDGEWEBHOSTING.COM
that gives you utilities to start and stop coldFusion
yourself AND to add Datasources yourself (I don't
think this company charges for that at all and they
have very competitive rates)

Hope something here helps you out.

Eron Cohen

-Original Message-
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 11:15 AM
To: CF-Talk
Subject: Remote DB Alteration 


Hello CF'ers

Situation:
Database and sites hosted externally, site created
internally.
Currently if any changes to the datasource's structure
are made they
are made locally and then uploaded to the host, who
has to shut off
the CFServer and restart it. This requires scheduling
a time and is
unacceptable. Also, the uploaded datasource may
corrupt/overwrite the
data as it is not up to date. Employer will not spring
for extra
datasources to be hosted. ( multiple applications and
domains, one
datasource, yay! ;) )

Goal:
To be able to add tables to the datasource without
scheduling a
shutdown and uploading entire datasource.

Resources:
MS Access 97
CF 4.5
CuteFTP
Budget =$0

Is this possible? Please direct me to resources that
will show me how.

Also, anyone know what the 20 or so CFML tags
supported by CFExpress
are?

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out the fresh new look of
www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your
bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades
1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog
Heritage.
www.AHTV.com - Your online companion to the Angler and
Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the
Ontario Hunter
Education Program.




Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists
or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]

__
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Remote DB Alteration

[David Livingston]

You can use SQL statements to update, create, and modify tables. Also you
can open up the Access file and modify it if you open it on the actual
server the file sits on. I don't recommend it though. Your chances of
getting corruption probably double.
Dave Livingston
General Bandwidth
[EMAIL PROTECTED]



-Original Message-
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 10:15 AM
To: CF-Talk
Subject: Remote DB Alteration 


Hello CF'ers

Situation:
Database and sites hosted externally, site created internally.
Currently if any changes to the datasource's structure are made they
are made locally and then uploaded to the host, who has to shut off
the CFServer and restart it. This requires scheduling a time and is
unacceptable. Also, the uploaded datasource may corrupt/overwrite the
data as it is not up to date. Employer will not spring for extra
datasources to be hosted. ( multiple applications and domains, one
datasource, yay! ;) )

Goal:
To be able to add tables to the datasource without scheduling a
shutdown and uploading entire datasource.

Resources:
MS Access 97
CF 4.5
CuteFTP
Budget =$0

Is this possible? Please direct me to resources that will show me how.

Also, anyone know what the 20 or so CFML tags supported by CFExpress
are?

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out the fresh new look of www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

OT--vb control puzzle

[Kathleen Ballard]

Dear List,
I apologize for the off topic post, but I know many of you also code in asp
and am hoping someone might have an answer to a puzzle.  Or, at least point
me in the direction of a resource I can try.

I am using the MonthView control.  It's in the Microsoft Common Controls ocx
file. (MSCOMCT2.ocx at least for NT)

And I have discovered that it refreshes itself every 2 minutes.  I am using
this control in a navigation frame that refreshes the report view in the
main frame.  And I am seeing the page refresh every two minutes.  Is there a
way to control the  timing of the control refresh or turn it off completely?
I have worked around this problem, but am just curious.

Kathleen


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Client Settings???

[Auction Hard Drive]

How do I clear the Client Management settings??  I don't want to set them to
blank, I want to completely remove them so a user can login by setting them
and log out by deleting them.

Thanks,
Rich


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: mailmerge witth sql server database

[Warrick, Mark]

Yes, you can use a SQL database or any ODBC compliant DB or just about any type of 
file.  This has absolutely nothing at all to do with ColdFusion whatsoever.

I'm not sure why you would wan to use ColdFusion to do this when MS Word handles it so 
well.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: thanh nguyen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 1:32 PM
> To: CF-Talk
> Subject: mailmerge witth sql server database
> 
> 
> helllo everyone,
> I would like to know if someone has done mailmerge with sql 
> server database, 
> I have mailmerge word document and would like to retrieve the 
> data from the 
> sql server database.  can i use cold fusion do the job,
> thanks
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at 
> http://profiles.msn.com.
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Fannie-packs? (RE: fusebox)

[misty . d . woodward]

--openmail-part-3484539e-0001
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
;Creation-Date="Wed, 8 Nov 2000 10:33:33 -0600"
Content-Transfer-Encoding: 8bit

Oh my!  Just need to stop this.  Before someone gets hurt.  :)

Misty

-Original Message-
From: Peter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:28 AM
To: cf-talk
Cc: Peter
Subject: RE: Fannie-packs? (RE: fusebox)


HAHA! I had no idea!

That's fine, just turn the belt around, and it's still accurate :-)

At 05:44 PM 11/8/00 +1100, Peter Alexandrou wrote:
>Round these parts a "fanny" is slang for a woman's frontal privates :-)
>
>> -Original Message-
>> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, 8 November 2000 16:47
>> To: CF-Talk
>> Subject: Re: Fannie-packs? (RE: fusebox)
>>
>>
>> In the USA it's your rear-end. So a fanny-pack is a small
>> "backpack" or "rucksack" that you wear on a belt that hangs
>> off your "fanny". What is a "fanny" down under?
>>
>> At 12:51 PM 11/8/00 +1100, BORKMAN Lee wrote:
>> >Hi, we in Australia might be a little puzzled by
>> "fannie-packs".  Perhaps
>> >you are not aware that a "fanny" is something completely
>> different in other
>> >parts of the world.  After all, this is an international list!!!
>> >
>> >-Original Message-
>> >From: William J Wheatley [mailto:[EMAIL PROTECTED]]
>> >
>> >... people who used to walk around with bright PINK fanny
>> packs, now thats a
>> >fad, ...
>> >
>> >
>> >IMPORTANT NOTICE:
>> >This e-mail and any attachment to it is intended only to be
>> read or used by
>> >the named addressee.  It is confidential and may contain
>> legally privileged
>> >information.  No confidentiality or privilege is waived or
>> lost by any
>> >mistaken transmission to you.  If you receive this e-mail in
>> error, please
>> >immediately delete it from your system and notify the
>> sender.  You must not
>> >disclose, copy or use any part of this e-mail if you are not
>> the intended
>> >recipient.  The RTA is not responsible for any unauthorised
>> alterations to
>> >this e-mail or attachment to it.
>> >-
>> ---
>> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> >Unsubscribe:
>> http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>> a message with 'unsubscribe' in the body to
>> [EMAIL PROTECTED]
>>
>>
>> --
>> -
>> Peter Theobald, Chief Technology Officer
>> LiquidStreaming http://www.liquidstreaming.com
>> [EMAIL PROTECTED]
>> Phone 1.212.545.1232 x204 Fax 1.212.545.0938
>>
>> To put this contact information into your Palm device, click here:
>> http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=9728799
>10&type=A
>
>
>---
-
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a
>message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>---
-
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED] 



---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


--openmail-part-3484539e-0001--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RDS and NT holding a lock on a file

[Aidan Whitehall]

There was a thread a while ago about NT (I think) holding a lock on a file
for 60 seconds. I'm finding if request a .cfm file in a browser and then try
and open the same file via RDS in Studio, Studio throws this error:

   Error attempting to read data from file F:/pathtofile/file.cfm  Error
= There was a sharing violation.

If you click OK, after about a minute you can open the file and edit away.

We're not having this problem with other servers and our network admin has
just turned off "Keep Alives" on the server in question but no dice.

Any suggestions? This is driving me mad (you want a file? wait a minute,
then you can have it  ;-).



Thanks in advance

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: strange SQL error code

[Hoffman, Joe (CIT)]

What version ODBC driver are you using?


http://support.microsoft.com/support/kb/articles/q234/9/87.asp

INFO: SQL Server Driver Version 3.70 May Return Fractional Truncation
Message When Processing DateTime Parameter



Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 2:12 PM
To: CF-Talk
Subject: strange SQL error code


Anyone ever seen this one?

ODBC Error Code = 01004 (Data truncated)
[Microsoft][ODBC SQL Server Driver]Fractional truncation

On that note, does anyone have a list of Microsoft SQL Error Codes?

Please copy me with your reply.

Thanks.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Remote DB Alteration

[Guy J. McDowell]

Hello CF'ers

Situation:
Database and sites hosted externally, site created internally.
Currently if any changes to the datasource's structure are made they
are made locally and then uploaded to the host, who has to shut off
the CFServer and restart it. This requires scheduling a time and is
unacceptable. Also, the uploaded datasource may corrupt/overwrite the
data as it is not up to date. Employer will not spring for extra
datasources to be hosted. ( multiple applications and domains, one
datasource, yay! ;) )

Goal:
To be able to add tables to the datasource without scheduling a
shutdown and uploading entire datasource.

Resources:
MS Access 97
CF 4.5
CuteFTP
Budget =$0

Is this possible? Please direct me to resources that will show me how.

Also, anyone know what the 20 or so CFML tags supported by CFExpress
are?

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out the fresh new look of www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: profiles.

[Steve Bernard]

A database, either relational or LDAP, is the best place to store the
information during off-line time. Upon login, the relevant bits should
probably be copied to a structure, as a session variable. If cookies aren't
an option, as in "can't be used", then you can pass the session/client id
via the URL or FORM variables.

Your bigger problem may be in convincing a client to pay more money for
something that they see as working fine. A friend of mine had a client who
refused to pay for such a conversion, flat to component based, despite the
fact that he knew keeping the old architecture would cost him more in the
long run.

Steve

-Original Message-
From: miles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 12:24 AM
To: CF-Talk
Subject: profiles.


Hi,

I have an interesting intellectual problem that I need to
solvenot immediately, but sometime in the next three
months.  I am about to roll out a new website for a client
and to be honest (the client is aware of this) that its a kluudge
at best...but it worksthey are happy...Im happy.  Everyone
is happy.

PROBLEM!

Everyone is NOT happy...me being the one that is not happy.
The problem is that the site IS a kluudge.   The reason its a
kluudge is best left to history.  However in rethinking the site,
I have come up with a solution that will not only make the
site more operable, but easier to maintain in the long run
and that much easier to develop for in the future.

What I am wanting to do is modulerize EVERYTHING...
and its not right now.  And one of those modules is a user
module...this module will keep all types of user data, it will
save different user queries (prepackaged ones of course for
external users of the site, internal users get to create their own
dynamic queries), last time they logged in, what their page is
supposed to look like, who their internal advocates are (this is
a support website so we assign them a support advocate that
works with them directly through the life of their support contract)
and who their sales reps are/wereetc. stuff like that.

My question is this...

I view this kind of data as user "profile" data stuff that will
essentially never change except for a few times after the end user
logs in.  They may change what queries they'd like to see, but
the rest of the data isn't going to change.  What I was thinking
was to store this user profile data in a tablethen when the
end user logs in...this "state" or profile data is pulled up and
then acted upon.  Is there a better way to store this data somewhere...
and cookies are NOT an option here.

Sincerely,

Miles.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[Nick Betts]

Or you can use "is null" .  You must include the space.

Nick Betts
PoulterNet.
UK.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 08 November 2000 15:33
To: CF-Talk
Subject: RE: Null Values


IsNull() does not exist in Cold Fusion. It is a vbscript function.

What I always do is:


here is some stuff if whatever is null




chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: Corina S. Moore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:19 AM
To: CF-Talk
Subject: Null Values


One quick question,

I thought that there was a function called IsNull() however whenever I
try to use it
 gives me an error of "There is no ColdFusion function named IsNull".
I am running 4.0 but have looked in both 4.0 and 4.5 documentation and
have found anything one
it. Can someone Clear this up for me?

Thank You

Cori





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Potential problems with CF Express Server

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> Yes. This is exactly what I'm talking about. They want to be 
> cheap and use 
> CF Express, and I of course don't want that.
> 
> I need to convince these folks that CF Express is NOT the way 
> to go for 
> hosting a large ecommerce site.
> 
> What good (realistic) reasons can I give them to go to the Pro
> server?  

Just out of curiosity...  How much are these folks paying you, and
will you be paid up front or are you actually going to have to bill
these tight wads & hope to get your money out of them?...

My advice would be drop them before it's too late and you have hours
of code written & nothing to show for it...

But as for a solution for them...  If they're that adamant about not
paying for a server, how about ASP, PHP, or Perl even?  CF Express
really is a useless product.  I find it hard to believe you'll be
able to code anything useful for it.

In any case, good luck!  Believe me, I feel your pain!

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOgl0EqvhLS1aWPxeEQKc2gCffBh7Fpuyw/Ld3pgM5qd/m8HN+XAAmwVj
LENXBXxG+rFlVGbyQDPhUcJ/
=89Xe
-END PGP SIGNATURE-

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[CAlvarado]

and why is that?

chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:31 AM
To: CF-Talk
Subject: RE: Null Values


Much Better to do 





Justin MacCarthy


>IsNull() does not exist in Cold Fusion. It is a vbscript function.
> 
> What I always do is:
> 
> 
>   here is some stuff if whatever is null
> 
> 

> 




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[Anthony Geoghegan]

There's also an ISNULL() SQL function.
Very useful for dealing with the human element of data entry.Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 08 November 2000 15:33
To: CF-Talk
Subject: RE: Null Values


IsNull() does not exist in Cold Fusion. It is a vbscript function.

What I always do is:


here is some stuff if whatever is null




chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: Corina S. Moore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:19 AM
To: CF-Talk
Subject: Null Values


One quick question,

I thought that there was a function called IsNull() however whenever I
try to use it
 gives me an error of "There is no ColdFusion function named IsNull".
I am running 4.0 but have looked in both 4.0 and 4.5 documentation and
have found anything one
it. Can someone Clear this up for me?

Thank You

Cori





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Fannie-packs? (RE: fusebox)

[Peter Theobald]

HAHA! I had no idea!

That's fine, just turn the belt around, and it's still accurate :-)

At 05:44 PM 11/8/00 +1100, Peter Alexandrou wrote:
>Round these parts a "fanny" is slang for a woman's frontal privates :-)
>
>> -Original Message-
>> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, 8 November 2000 16:47
>> To: CF-Talk
>> Subject: Re: Fannie-packs? (RE: fusebox)
>>
>>
>> In the USA it's your rear-end. So a fanny-pack is a small
>> "backpack" or "rucksack" that you wear on a belt that hangs
>> off your "fanny". What is a "fanny" down under?
>>
>> At 12:51 PM 11/8/00 +1100, BORKMAN Lee wrote:
>> >Hi, we in Australia might be a little puzzled by
>> "fannie-packs".  Perhaps
>> >you are not aware that a "fanny" is something completely
>> different in other
>> >parts of the world.  After all, this is an international list!!!
>> >
>> >-Original Message-
>> >From: William J Wheatley [mailto:[EMAIL PROTECTED]]
>> >
>> >... people who used to walk around with bright PINK fanny
>> packs, now thats a
>> >fad, ...
>> >
>> >
>> >IMPORTANT NOTICE:
>> >This e-mail and any attachment to it is intended only to be
>> read or used by
>> >the named addressee.  It is confidential and may contain
>> legally privileged
>> >information.  No confidentiality or privilege is waived or
>> lost by any
>> >mistaken transmission to you.  If you receive this e-mail in
>> error, please
>> >immediately delete it from your system and notify the
>> sender.  You must not
>> >disclose, copy or use any part of this e-mail if you are not
>> the intended
>> >recipient.  The RTA is not responsible for any unauthorised
>> alterations to
>> >this e-mail or attachment to it.
>> >-
>> ---
>> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> >Unsubscribe:
>> http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>> a message with 'unsubscribe' in the body to
>> [EMAIL PROTECTED]
>>
>>
>> --
>> -
>> Peter Theobald, Chief Technology Officer
>> LiquidStreaming http://www.liquidstreaming.com
>> [EMAIL PROTECTED]
>> Phone 1.212.545.1232 x204 Fax 1.212.545.0938
>>
>> To put this contact information into your Palm device, click here:
>> http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=9728799
>10&type=A
>
>
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to [EMAIL PROTECTED]
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED] 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[JustinMacCarthy]

Much Better to do 





Justin MacCarthy


>IsNull() does not exist in Cold Fusion. It is a vbscript function.
> 
> What I always do is:
> 
> 
>   here is some stuff if whatever is null
> 
> 

> 



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: OFF TOPIC - HEALTH INSURANCE

[Peter Theobald]

Why is this wasting space in MY mailbox?
Take it off list please.

At 09:26 PM 11/7/00 -0800, Stephen M. Aylor wrote:

>John,
>
>I rec'd the quote(s) back from the broker this afternoon via snail.  Im
>reviewing them.  Couple things come to mind.
>
>1. Did you guys want me to come over and vist to discuss??  I figure you've
>been thru the Health insurance Dawg and Pony a couple times ..
>
>2. What are some of the things you liked about HealthNet?  Price?
>
>3. Do we have any physicians that are a must?
>
>4. Whats more important - lower out of pocket costs to employees or choice
>of Dr.'s?
>
>5. What % of the employee premium is "EmployER" paid?  Dependent premium?
>
>6. Out of State Employees?
>
>All the best,
>
>Stephen M. Aylor
>Aylor Insurance Agency, Inc.
>"Specialized insurance for Technology Risks"
>[EMAIL PROTECTED]
>949.581.2333 voice
>949.581.2814 fax
>
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED] 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Null Values

[CAlvarado]

IsNull() does not exist in Cold Fusion. It is a vbscript function.

What I always do is:


here is some stuff if whatever is null




chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: Corina S. Moore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:19 AM
To: CF-Talk
Subject: Null Values


One quick question,

I thought that there was a function called IsNull() however whenever I
try to use it
 gives me an error of "There is no ColdFusion function named IsNull".
I am running 4.0 but have looked in both 4.0 and 4.5 documentation and
have found anything one
it. Can someone Clear this up for me?

Thank You

Cori





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Null Values

[Corina S. Moore]

One quick question,

I thought that there was a function called IsNull() however whenever I
try to use it
 gives me an error of "There is no ColdFusion function named IsNull".
I am running 4.0 but have looked in both 4.0 and 4.5 documentation and
have found anything one
it. Can someone Clear this up for me?

Thank You

Cori




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Hosting Question???

[Bud]

On 11/8/00, Kevin Langevin penned:
>Agreed.  I know a few people who have had relatively positive experiences
>with Intermedia.  They just aren't me. :)  I hosted with Intermedia for
>about 6 or 8 months, with varying # of domains throughout, and one of my
>clients had some serious issues with the fact that it took so long to log
>into the site, and kept raising questions about my coding (he was NOT a
>technical person) and if it was "the way you programmed the site" making it
>so slow.  I ended up moving the site because he was so unhappy with it.

Same experience. I even went out and bought my own server so I 
wouldn't have to keep moving my ColdFusion customer's sites from host 
to host. After going back and forth with them for months and them 
always saying there servers performed wonderfully, and that the 
problem was on my end (and I presume all of my customers ends also 
that were calling at midnight wondering why their site wouldn't 
load), they at least admitted there was a problem.

>Cold Fusion is the application that gives us the most problems. It can work
>a lot faster if advanced security services are turned off, which is probably
>the case with your new host. The drawback is that anyone can read or wipe
>out your entire site.
>
>We actually do not have more than 40-50 CF users per box. Cold Fusion
>advanced security is the biggest performance hit.
>
>In any case we appreciate your suggestions and forward them to our
>management.

My suggestion to them was to stop offering CF sites at 5.00 per month 
with unlimited traffic and unlimited datasources and limit the number 
of CF sites to 50-75 per box.

I have a hard time swallowing that there are only 40-50 CF "users" 
per box. Heck, I had 12 on a single 105.00 per month account (50.00 
for base account and 5.00 per additional domain). But, I was probably 
considered 1 user (with 12 ColdFusion domains). So at those numbers, 
that's like 600 CF sites per box. LOL

Anyway, I had the same issues with folks questioning my programming. 
Now I have about 25 CF sites and 90+ static sites on my server, with 
a meager 512 Kbps connection, and everyone is extremely pleased with 
the performance.

-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]