RE: [KCFusion] checking for nulls...

2002-09-12 Thread Justin Hansen

cfif trim(whatever) eq whatever is null/cfif

-Original Message-
From: Johnson, Michael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 7:46 AM
To: CF-List (E-mail)
Subject: [KCFusion] checking for nulls...


what's the syntax to check if a variable is null...


i.e.


cfif var is 'null
  cfset var = something
/cfif


Mike Johnson
Science Application International Corporation
(757) 870-9165
Emai: [EMAIL PROTECTED]


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]




Re: [KCFusion] checking for nulls...

2002-09-12 Thread Daryl Banttari

Michael,

ColdFusion has no true null primitive.  It is, therefore, impossible
through normal means to differentiate between a true null and the
zero-length string nulls are translated into.

For an example of working around this when using Java classes, see my
article, Leveraging Java Classes from ColdFusion:
http://www.macromedia.com/v1/handlers/index.cfm?id=22277method=full

--Daryl

- Original Message -
From: Johnson, Michael [EMAIL PROTECTED]
To: CF-List (E-mail) [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 7:46 AM
Subject: [KCFusion] checking for nulls...


 what's the syntax to check if a variable is null...


 i.e.


 cfif var is 'null
   cfset var = something
 /cfif


 Mike Johnson
 Science Application International Corporation
 (757) 870-9165
 Emai: [EMAIL PROTECTED]




 __
 The KCFusion.org list and website is hosted by Humankind Systems, Inc.
 List Archives http://www.mail-archive.com/cf-list@kcfusion.org
 Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
 To Subscribe mailto:[EMAIL PROTECTED]
 To Unsubscribe mailto:[EMAIL PROTECTED]



 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] checking for nulls...

2002-09-12 Thread Ryan Hartwich

You probably want to perform an IsDefined check, for instance
cfif IsDefined(var)your statement/cfif

IF you have a form submission with check boxes, boxes that are not
checked are not submitted and hence are effectively null and you can't
perform a value check on them because they don't exist.  CF does NOT
support null values.  The closest it comes is having a few methods of
checking on the existence of a variable.

Everyone else's replies about checking the length of the variable and
potentially trimming white space seems accurate...assuming the variable
exists.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Johnson, Michael
Sent: Thursday, September 12, 2002 7:46 AM
To: CF-List (E-mail)
Subject: [KCFusion] checking for nulls...


what's the syntax to check if a variable is null...


i.e.


cfif var is 'null
  cfset var = something
/cfif


Mike Johnson
Science Application International Corporation
(757) 870-9165
Emai: [EMAIL PROTECTED]


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] checking for nulls...

2002-09-12 Thread Misty Woodward

The only problem I see with this, is he says checking if a variable is NULL, which 
probably means it does exist, hes just checking the value of it.

I do this alot with datbase queries where I loop through a recordset, set some 
variables to the values that were in the database and then check if it contains data 
or is null.

I guess what might be helpful to decide which is the best route to take would be to 
know what the intention of the code is to be used for. Checking if it exists or 
checking if the value exists but is null.


Misty Woodward
Oleani Technologies
www.oleani.com

-- Original Message --
From: Ryan Hartwich [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 12 Sep 2002 09:26:51 -0500

You probably want to perform an IsDefined check, for instance
cfif IsDefined(var)your statement/cfif

IF you have a form submission with check boxes, boxes that are not
checked are not submitted and hence are effectively null and you can't
perform a value check on them because they don't exist.  CF does NOT
support null values.  The closest it comes is having a few methods of
checking on the existence of a variable.

Everyone else's replies about checking the length of the variable and
potentially trimming white space seems accurate...assuming the variable
exists.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Johnson, Michael
Sent: Thursday, September 12, 2002 7:46 AM
To: CF-List (E-mail)
Subject: [KCFusion] checking for nulls...


what's the syntax to check if a variable is null...


i.e.


cfif var is 'null
  cfset var = something
/cfif


Mike Johnson
Science Application International Corporation
(757) 870-9165
Emai: [EMAIL PROTECTED]


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] checking for nulls...

2002-09-12 Thread Roy Dean

I would do it like below:

CFIF testValue is not null
   ...do something
CFELSE
   ...catch exception
/CFIF




From: Cox, Billy W [PCS] [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...
Date: Thu, 12 Sep 2002 09:07:35 -0500
MIME-Version: 1.0
Received: from Falcon.HKSI.net ([209.15.194.101]) by 
mc1-f14.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12 Sep 
2002 07:09:03 -0700
Received: from kcfusion.org (unknown [209.15.194.113])by Falcon.HKSI.net 
(Postfix) with ESMTPid 933DD2524E; Thu, 12 Sep 2002 09:49:23 -0500 (CDT)
Received: from Falcon.HKSI.net [209.15.194.101] by hksi.net  (SMTPD32-7.12) 
id A02A258B00A6; Thu, 12 Sep 2002 09:09:46 -0500
Received: from smtpgw5.sprintspectrum.com (smtpgw5.sprintspectrum.com 
[207.40.188.13])by Falcon.HKSI.net (Postfix) with ESMTP id E258A25239for 
[EMAIL PROTECTED]; Thu, 12 Sep 2002 09:47:57 -0500 (CDT)
Received: from pkcex003.sprintspectrum.com (pkcex003.sprintspectrum.com 
[208.10.75.138])by smtpgw5.sprintspectrum.com (8.11.2/8.11.3) with ESMTP id 
g8CE7aE21317for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:07:37 -0500 
(CDT)
Received: by pkcex003.sprintspectrum.com with Internet Mail Service 
(5.5.2654.89)id SNL1WGQM; Thu, 12 Sep 2002 09:07:37 -0500
Message-ID: 
[EMAIL PROTECTED]
Return-Receipt-To: Cox, Billy W [PCS] [EMAIL PROTECTED]
X-Mailer: Internet Mail Service (5.5.2654.89)
X-RBL-Warning: NOABUSE: Not supporting abuse@domain
X-Note: This E-mail was scanned for spam.
Precedence: bulk
Sender: [EMAIL PROTECTED]
X-Note: This E-mail was scanned for spam.
Organization: Humankind Systems, Inc.
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 12 Sep 2002 14:09:04.0008 (UTC) 
FILETIME=[F34FB880:01C25A65]

I would code it this way:

cfif not len(trim(var))
cfset var=something
/cfif

It accomplishes the same thing, just more elegantly.


Billy Cox
Intranet/Extranet
Sprint PCS
913-534-5873
913-638-5557 pcs




-Original Message-
From: Nate Rightmire [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 8:35 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...


I always use the following:

cfif len(trim(var)) is 0
cfset var = something
/cfif

I read that this was better than just cfif var=. I dunno if it really
is, but that is what I use.

My $.02

Nate

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Johnson, Michael
Sent: Thursday, September 12, 2002 7:46 AM
To: CF-List (E-mail)
Subject: [KCFusion] checking for nulls...


what's the syntax to check if a variable is null...


i.e.


cfif var is 'null
   cfset var = something
/cfif


Mike Johnson
Science Application International Corporation
(757) 870-9165
Emai: [EMAIL PROTECTED]




__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]






__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]



__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]





Roydean


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] checking for nulls...

2002-09-12 Thread Matt Jones

Umm... 
If you are going to do that type of thing, then you should probably do
it like this

cfset null = 
CFIF trim(testValue) is not null
   ...do something
CFELSE
   ...catch exception
/CFIF

-Original Message-
From: Roy Dean [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 12, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...

I would do it like below:

CFIF testValue is not null
   ...do something
CFELSE
   ...catch exception
/CFIF




From: Cox, Billy W [PCS] [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...
Date: Thu, 12 Sep 2002 09:07:35 -0500
MIME-Version: 1.0
Received: from Falcon.HKSI.net ([209.15.194.101]) by 
mc1-f14.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12
Sep 
2002 07:09:03 -0700
Received: from kcfusion.org (unknown [209.15.194.113])by Falcon.HKSI.net

(Postfix) with ESMTPid 933DD2524E; Thu, 12 Sep 2002 09:49:23 -0500 (CDT)
Received: from Falcon.HKSI.net [209.15.194.101] by hksi.net
(SMTPD32-7.12) 
id A02A258B00A6; Thu, 12 Sep 2002 09:09:46 -0500
Received: from smtpgw5.sprintspectrum.com (smtpgw5.sprintspectrum.com 
[207.40.188.13])by Falcon.HKSI.net (Postfix) with ESMTP id E258A25239for

[EMAIL PROTECTED]; Thu, 12 Sep 2002 09:47:57 -0500 (CDT)
Received: from pkcex003.sprintspectrum.com (pkcex003.sprintspectrum.com 
[208.10.75.138])by smtpgw5.sprintspectrum.com (8.11.2/8.11.3) with ESMTP
id 
g8CE7aE21317for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:07:37 -0500 
(CDT)
Received: by pkcex003.sprintspectrum.com with Internet Mail Service 
(5.5.2654.89)id SNL1WGQM; Thu, 12 Sep 2002 09:07:37 -0500
Message-ID: 
[EMAIL PROTECTED]
Return-Receipt-To: Cox, Billy W [PCS] [EMAIL PROTECTED]
X-Mailer: Internet Mail Service (5.5.2654.89)
X-RBL-Warning: NOABUSE: Not supporting abuse@domain
X-Note: This E-mail was scanned for spam.
Precedence: bulk
Sender: [EMAIL PROTECTED]
X-Note: This E-mail was scanned for spam.
Organization: Humankind Systems, Inc.
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 12 Sep 2002 14:09:04.0008 (UTC) 
FILETIME=[F34FB880:01C25A65]

I would code it this way:

cfif not len(trim(var))
cfset var=something
/cfif

It accomplishes the same thing, just more elegantly.


Billy Cox
Intranet/Extranet
Sprint PCS
913-534-5873
913-638-5557 pcs




-Original Message-
From: Nate Rightmire [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 8:35 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...


I always use the following:

cfif len(trim(var)) is 0
cfset var = something
/cfif

I read that this was better than just cfif var=. I dunno if it
really
is, but that is what I use.

My $.02

Nate

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Johnson, Michael
Sent: Thursday, September 12, 2002 7:46 AM
To: CF-List (E-mail)
Subject: [KCFusion] checking for nulls...


what's the syntax to check if a variable is null...


i.e.


cfif var is 'null
   cfset var = something
/cfif


Mike Johnson
Science Application International Corporation
(757) 870-9165
Emai: [EMAIL PROTECTED]




__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]






__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]



__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]





Roydean


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED

RE: [KCFusion] checking for nulls...

2002-09-12 Thread Justin Hansen

The ultimate solution would be a UDF!
http://www.cflib.org/udf.cfm?ID=644 (code below)

Then all you would have to do is say

cfif isNull(whatever)
whatever is null
/cfif

cfscript
/**
 * Returns True if the value passed to it represents quot;NULLquot;.
 * 
 * @param valValue to evaluate for NULL. (Required)
 * @param NullIdentifier String that represents NULL.  Default is an empty 
string (). (Optional)
 * @return Returns a Boolean. 
 * @author Rob Brooks-Bilson ([EMAIL PROTECTED]) 
 * @version 1, May 1, 2002 
 */
function IsNull(val){
  var NullIdentifier = ;
  if (ArrayLen(Arguments) gte 2) 
NullIdentifier = Arguments[2];
  if (val is NullIdentifier) {
return True;
  }
  else {
return False;
  }
}
/cfscript


Geez, do you think this thread has gone on way to long or is it just me?



-Original Message-
From: Matt Jones 
Sent: Thursday, September 12, 2002 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...


Umm... 
If you are going to do that type of thing, then you should probably do
it like this

cfset null = 
CFIF trim(testValue) is not null
   ...do something
CFELSE
   ...catch exception
/CFIF

-Original Message-
From: Roy Dean [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 12, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...

I would do it like below:

CFIF testValue is not null
   ...do something
CFELSE
   ...catch exception
/CFIF




From: Cox, Billy W [PCS] [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...
Date: Thu, 12 Sep 2002 09:07:35 -0500
MIME-Version: 1.0
Received: from Falcon.HKSI.net ([209.15.194.101]) by 
mc1-f14.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12
Sep 
2002 07:09:03 -0700
Received: from kcfusion.org (unknown [209.15.194.113])by Falcon.HKSI.net

(Postfix) with ESMTPid 933DD2524E; Thu, 12 Sep 2002 09:49:23 -0500 (CDT)
Received: from Falcon.HKSI.net [209.15.194.101] by hksi.net
(SMTPD32-7.12) 
id A02A258B00A6; Thu, 12 Sep 2002 09:09:46 -0500
Received: from smtpgw5.sprintspectrum.com (smtpgw5.sprintspectrum.com 
[207.40.188.13])by Falcon.HKSI.net (Postfix) with ESMTP id E258A25239for

[EMAIL PROTECTED]; Thu, 12 Sep 2002 09:47:57 -0500 (CDT)
Received: from pkcex003.sprintspectrum.com (pkcex003.sprintspectrum.com 
[208.10.75.138])by smtpgw5.sprintspectrum.com (8.11.2/8.11.3) with ESMTP
id 
g8CE7aE21317for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:07:37 -0500 
(CDT)
Received: by pkcex003.sprintspectrum.com with Internet Mail Service 
(5.5.2654.89)id SNL1WGQM; Thu, 12 Sep 2002 09:07:37 -0500
Message-ID: 
[EMAIL PROTECTED]
Return-Receipt-To: Cox, Billy W [PCS] [EMAIL PROTECTED]
X-Mailer: Internet Mail Service (5.5.2654.89)
X-RBL-Warning: NOABUSE: Not supporting abuse@domain
X-Note: This E-mail was scanned for spam.
Precedence: bulk
Sender: [EMAIL PROTECTED]
X-Note: This E-mail was scanned for spam.
Organization: Humankind Systems, Inc.
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 12 Sep 2002 14:09:04.0008 (UTC) 
FILETIME=[F34FB880:01C25A65]

I would code it this way:

cfif not len(trim(var))
cfset var=something
/cfif

It accomplishes the same thing, just more elegantly.


Billy Cox
Intranet/Extranet
Sprint PCS
913-534-5873
913-638-5557 pcs




-Original Message-
From: Nate Rightmire [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 8:35 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...


I always use the following:

cfif len(trim(var)) is 0
cfset var = something
/cfif

I read that this was better than just cfif var=. I dunno if it
really
is, but that is what I use.

My $.02

Nate

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Johnson, Michael
Sent: Thursday, September 12, 2002 7:46 AM
To: CF-List (E-mail)
Subject: [KCFusion] checking for nulls...


what's the syntax to check if a variable is null...


i.e.


cfif var is 'null
   cfset var = something
/cfif


Mike Johnson
Science Application International Corporation
(757) 870-9165
Emai: [EMAIL PROTECTED]




__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]






__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED

RE: [KCFusion] checking for nulls...

2002-09-12 Thread Glenn Crocker


 Geez, do you think this thread has gone on way to long or is it just me?

Honestly, I think the original question may have been a SQL question, not a
CF question.  ;-)

-glenn


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] checking for nulls...

2002-09-12 Thread Matt Jones

Well, how's it going Misty?

-Original Message-
From: Misty Woodward [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 12, 2002 11:33 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...

LOL I think its great! Was getting a little dusty in my KCFusion inbox.

Misty

-- Original Message --
From: Glenn Crocker [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 12 Sep 2002 11:23:20 -0500


 Geez, do you think this thread has gone on way to long or is it just
me?

Honestly, I think the original question may have been a SQL question,
not a
CF question.  ;-)

-glenn


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]




RE: [KCFusion] checking for nulls...

2002-09-12 Thread Justin Hansen

cf_joking
Oh, well fine then... shall we keep the NULL conversation going?
1. Um, it was a CF question. (see original post)
2. What solution did Mike use? Come on, we all want to know.
/cf_joking

cf_for_real
3. I agree with Misty.
4. UDFs are cool.
5. Just having some fun here
/cf_for_real

Hey Misty, 
Did you know I can throw stuff at Matt for you from where I sit?
We are working together again but, Matt is still Mr. Fusebox.


-Original Message-
From: Misty Woodward [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 11:33 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...


LOL I think its great! Was getting a little dusty in my KCFusion inbox.

Misty

-- Original Message --
From: Glenn Crocker [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 12 Sep 2002 11:23:20 -0500


 Geez, do you think this thread has gone on way to long or is it just me?

Honestly, I think the original question may have been a SQL question, not a
CF question.  ;-)

-glenn


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]