RE: [KCFusion] cfmail validation in MX

2003-10-13 Thread Matt Jones 
Title: Message



your 
best choice would be to validate the emails without trying to send them out, but 
if you must go that route, you could try something like
cftry!--- cfmail stuff goes here 
---

cfcatch type="Application"cfif not 
cfcatch.name is "to"!--- do whatever failure stuff 
you wanted to do 
---/cfif/cfcatch/cftry

  -Original Message-From: Chris Holdman 
  [mailto:[EMAIL PROTECTED]Sent: Monday, October 13, 2003 1:28 
  PMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] cfmail 
  validation in MX
  I have a 
  database full of emails, unfortunately some of them are bad emails (ex: [EMAIL PROTECTED] no.com).
  I have a script 
  that is mailling out to the entire database, when I was using CF4.0 it would 
  just throw the bad emails into the undeliverable folder. However when I 
  run the script now with MX it gives me a cfmail error because it appears that 
  CFMX is doing email validation and gives an error for bad emails...is there a 
  way to force CF to just throw those bad emails in the undeliverable forlder so 
  I can loop through me entire db?
  
  Christopher V. 
  Holdman
  Webmaster - City of 
  Olathe
  work: 913.971.6286
  cell: 913.238.4681

RE: [KCFusion] Client variables

2003-10-09 Thread Matt Jones 
yes, it is a SCOPE!

what version of cf did you upgrade from?

-Original Message-
From: Chris Holdman [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Client variables


Well I am not sure if this is a problem or not but one of my field names is
'request'and everything works weel on most of the pages of the
application except for when I am querying the 'request' field.  Is 'request'
and reserved word in SQL or ColdFusion?

Christopher V. Holdman
Webmaster - City of Olathe
work: 913.971.6286
cell: 913.238.4681


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 09, 2003 11:04 AM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Client variables



The requested scope CLIENT has not been enabled. Before CLIENT 
variables can be used, the CLIENT state management system must be 
enabled using the CFAPPLICATION tag. Do I need to adjust my script 
because of MX...I am not using any cfapplication tags.

Yes, you will need to change/use the cfapplication tag in your
application.cfm file.  By default session and client management is supported
and turned on in the CF Administrator.  However, I am pretty sure that you
must still turn on the session management in your application file (and
hence every CF page that runs).  Take a look at the cfapplication tag in
your documentation, you will probably need to have clientmanagement=yes and
sessionmanagement or something similar set to yes, all in 1 tag.

It is pretty easy to setup.  If you just upgraded to MX/6.1 from an older
version, nothing should have changed and I don't know why you are getting an
error now and not before.  Are you sure there wasn't an Application.cfm page
already running?  By design, CF looks in the directory of the file being
run, and if it doesn't find the application.cfm file it moves up the
directory tree.  It continues moving up as far as it can towards the root
until it either finds the file or hits the highest level of the
directory/web server accessible path.  If your application was nested inside
of someone else's directory path before, you may have been running the file
without knowing it and it may have had client/session variables and
management turned on.

Good luck
Ryan















 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc. List
Archives http://www.mail-archive.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]

RE: [KCFusion]

2003-07-30 Thread Matt Jones 



cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR" 
null="Yes"

  -Original Message-From: Adaryl Wakefield 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:40 
  AMTo: [EMAIL PROTECTED]Subject: [KCFusion] 
  
  I have need to update a table and set a value to 
  NULL like
  
  UPDATE blah
  SET thisAttribute = nullValueHere
  WHERE someStuff = someOtherStuff
  
  so far I've tried 
  cfset var = ""
  and
  cfset var = "NULL"
  
  and some other things but so far nothing. Anybody 
  know right off the bat where I'm going wrong?
  A.

RE: [KCFusion] CF5 online docs

2003-07-07 Thread Matt Jones 
http://livedocs.macromedia.com/cf50docs/

-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 1:02 AM
To: KCFusion
Subject: [KCFusion] CF5 online docs


If someone has CF5 installed on a dev machine would you be so kind as to
pull up the docs and tell me what the url to the live docs on MM's website
is. I have to present a comparison of CF5 charting features versus a third
party tool and I currently have MX installed.

Thanks for your help.

Bryan LaPlante

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]

RE: [KCFusion] OT: CSS problem with A HREF

2003-06-18 Thread Matt Jones 
2000 also

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Keith Purtell
Sent: Wednesday, June 18, 2003 5:15 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] OT: CSS problem with A HREF


What version of Windows are you on? I'm using W2000.

Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email:  [EMAIL PROTECTED]

CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole 
use of the intended recipient(s) and may contain confidential and privileged 
information. Any unauthorized review, use, disclosure or distribution is prohibited. 
If you are not the intended recipient, please contact the sender by reply email and 
destroy all copies of the original message.


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf Of Matt Jones
 Sent: Wednesday, June 18, 2003 5:07 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [KCFusion] OT: CSS problem with A HREF
 
 
 that is the same version I have, and they both looked and 
 acted the same
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf Of Keith Purtell
 Sent: Wednesday, June 18, 2003 5:04 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [KCFusion] OT: CSS problem with A HREF
 
 
 In my version of IE6 (6.0.2800.1106), the one on the left 
 starts out as a plain hyperlink (wrong) and only changes to 
 white text inside a colored box during mouse over.
 
 Keith Purtell, Web/Network Administrator
 VantageMed Operations (Kansas City)
 Email:  [EMAIL PROTECTED]
 
 CONFIDENTIALITY NOTICE: This email message, including any 
 attachments, is for the sole use of the intended recipient(s) 
 and may contain confidential and privileged information. Any 
 unauthorized review, use, disclosure or distribution is 
 prohibited. If you are not the intended recipient, please 
 contact the sender by reply email and destroy all copies of 
 the original message.
 
 
  -Original Message-
  From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]
  Behalf Of Luke Templin
  Sent: Wednesday, June 18, 2003 4:52 PM
  To: [EMAIL PROTECTED]
  Subject: RE: [KCFusion] OT: CSS problem with A HREF
  
  
  In my version of IE6 they look fine. Both are words on a gray 
  background that turns to dark red when hovering. What should 
  they be doing?
  
  Luke Templin
  Computer Access
  
  -Original Message-
  From: Keith Purtell [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, June 18, 2003 4:44 PM
  To: [EMAIL PROTECTED]
  Subject: RE: [KCFusion] OT: CSS problem with A HREF
  
  
  In my real version it includes visited. I just wanted to 
  trim the sample for your viewing. Chad,
  thanks for checking it in other browsers. I very much 
  appreciate that. I will create a workaround,
  since I have many users on IE6. Possibly use JavaScript to 
  redirect. Thanks again!
  
  Keith Purtell, Web/Network Administrator
  VantageMed Operations (Kansas City)
  Email:  [EMAIL PROTECTED]
  
  CONFIDENTIALITY NOTICE: This email message, including any 
  attachments, is for the sole use of the
  intended recipient(s) and may contain confidential and 
  privileged information. Any unauthorized
  review, use, disclosure or distribution is prohibited. If you 
  are not the intended recipient, please
  contact the sender by reply email and destroy all copies of 
  the original message.
  
  
   -Original Message-
   From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]
   Behalf Of Bryan LaPlante
   Sent: Wednesday, June 18, 2003 4:36 PM
   To: [EMAIL PROTECTED]
   Subject: Re: [KCFusion] OT: CSS problem with A HREF
  
  
   you did link and hover but you forgot visited
  
   A.row6:VISITED
 - Original Message -
 From: Keith Purtell
 To: KCFusion (E-mail)
 Sent: Wednesday, June 18, 2003 4:23 PM
 Subject: [KCFusion] OT: CSS problem with A HREF
  
  
 I've encountered an odd CSS bug that doesn't show up in
   online CSS bug references. In the attached
 file, when I view with IE6, the right hand link is fine.
   But the left hand link doesn't look normal
 (inside a colored box) until I mouse over. I can correct
   this if I change the value of HREF to be
 something other than a link to a Web site. Very 
 strange. Any tips?
  
 Keith Purtell, Web/Network Administrator
 VantageMed Operations (Kansas City)
 Email:  [EMAIL PROTECTED]
  
 CONFIDENTIALITY NOTICE: This email message, including any
   attachments, is for the sole use of the
 intended recipient(s) and may contain confidential and
   privileged information. Any unauthorized
 review, use, disclosure or distribution is prohibited. If
   you are not the intended recipient, please
 contact the sender by reply email and destroy all copies of
   the original message.
  
  


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives

RE: [KCFusion] dynamic code

2003-03-07 Thread Matt Jones 

#PreserveSingleQuotes(FORM.Insert_qry)#

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:43 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] dynamic code


I'm trying to run a query that is passed from the form page with embedded CF
variables in it.  It doesn't sound that tough but for some reason I can't
get it to work.  This in under MX and must work in 5, too.  I've tried
various uses of Evaluate and can't get it to resolve the inner variable.
jeff.descr is a form variable and is a local var in the action code.  

Form page contains:
input name=insert_qry type=hidden value=INSERT INTO CUSIPGROUP (DESCR,
CHANGEUSER) VALUES ('#jeff.descr[loopcount]#', 'jabrown')

Action code contains:
cfquery name=qInsert datasource=scooby
#FORM.Insert_qry#
/cfquery


Does anyone know anything that might work?  We are trying to solve our
cfgridupdate problems quickly without rewriting everything and get some
code-reuse, too.

Thanks for the help.

Jeff Brown
State Street - Kansas City
816-871-9441
[EMAIL PROTECTED]



*
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email 
in error please notify [EMAIL PROTECTED]
*

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]

RE: [KCFusion] dynamic code

2003-03-07 Thread Matt Jones 
btw you are gonna want to be real careful about doing something like this, this is a 
bad thing, and hidden formfields can be modified by anyone

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:43 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] dynamic code


I'm trying to run a query that is passed from the form page with embedded CF
variables in it.  It doesn't sound that tough but for some reason I can't
get it to work.  This in under MX and must work in 5, too.  I've tried
various uses of Evaluate and can't get it to resolve the inner variable.
jeff.descr is a form variable and is a local var in the action code.  

Form page contains:
input name=insert_qry type=hidden value=INSERT INTO CUSIPGROUP (DESCR,
CHANGEUSER) VALUES ('#jeff.descr[loopcount]#', 'jabrown')

Action code contains:
cfquery name=qInsert datasource=scooby
#FORM.Insert_qry#
/cfquery


Does anyone know anything that might work?  We are trying to solve our
cfgridupdate problems quickly without rewriting everything and get some
code-reuse, too.

Thanks for the help.

Jeff Brown
State Street - Kansas City
816-871-9441
[EMAIL PROTECTED]



*
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email 
in error please notify [EMAIL PROTECTED]
*

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]

RE: [KCFusion] include vs custom tag

2003-03-06 Thread Matt Jones 
Title: include vs custom tag



what 
version of fusebox are you changing? 

  -Original Message-From: Dunwiddie, Bruce 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 
  11:11 AMTo: '[EMAIL PROTECTED]'Subject: RE: 
  [KCFusion] include vs custom tag
  I'll 
  leave the answer currently to simply changing the basic idea of fusebox with 
  all the action based includes, to using action based custom tag calls 
  instead.
  
-Original Message-From: Adaryl Wakefield 
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 11:02 
AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] 
include vs custom tag
Curious. If you have time, can you explain what 
you mean exactly when you say you are going to use custom tags for the 
framework? 
A.

  - Original Message - 
  From: 
  Dunwiddie, Bruce 
  To: '[EMAIL PROTECTED]' 
  Sent: Thursday, March 06, 2003 10:29 
  AM
  Subject: [KCFusion] include vs custom 
  tag
  
  We're still using cf 4.5 sp2. We're currently having a 
  disagreement about whether to define our new framework for a site based on 
  custom tags for each page basically, or the same thing using includes 
  instead. I personally think the custom tags are a complete necessity, 
  because of variable scoping, but I need to know the true benchmarking 
  difference that people have seen when using one vs the other, or just in a 
  per call difference in milliseconds per call, if anyone happens to know it 
  or can point me to somewhere with the 
  stats.

RE: [KCFusion] Brain Dead

2002-10-04 Thread Matt Jones 









Not sure what you are looking for exactly,
but datediff would probably work nicely



-Original Message-
From: Safley, Nicole
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 04, 2002
11:00 AM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Brain Dead





I need
help solving the easiest of problems. I have just gone brain dead.
Trying to get the fractional number of months from a persons birth date to the
present. Note: need mm.dd











Thanks
for your help.



Nicole L. Safley 
Database
Programmer/Analyst 
Administrative
Systems Project 
University
of Missouri-Columbia 
[EMAIL PROTECTED] 
(573)
882-6284

RE: [KCFusion] Brain Dead

2002-10-04 Thread Matt Jones 









This might work for you



cfset birthdate = 9/26/1972


cfset monthday =
createdate(year(now()),
month(birthdate), day(birthdate))



cfset decimaldiff
= datediff(m,
monthday, now()) + (datediff(d,
monthday, now()) / daysinmonth(now())
)

cfoutput#decimaldiff#/cfoutput





-Original Message-
From: Safley, Nicole
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 04, 2002 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Brain Dead





Tried datediff using
months, but it returns an integer. Is there a way to get months with days
as a fraction?





-Original Message-
From: Matt Jones
[mailto:[EMAIL PROTECTED]]
Sent: October 04, 2002 11:16 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Brain Dead

Not sure what you are
looking for exactly, but datediff would probably work nicely



-Original Message-
From: Safley, Nicole
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 04, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Brain Dead





I need
help solving the easiest of problems. I have just gone brain dead.
Trying to get the fractional number of months from a persons birth date to the
present. Note: need mm.dd











Thanks
for your help.



Nicole L. Safley 
Database
Programmer/Analyst 
Administrative
Systems Project 
University
of Missouri-Columbia 
[EMAIL PROTECTED] 
(573)
882-6284

RE: [KCFusion] Impossible Candidate

2002-10-03 Thread Matt Jones 

They could have the candidates interview themselves to determine if they
are qualified and skilled in those areas.  Then the HR department merely
has to take those candidates that deem themselves qualified and skilled,
and determine who is the most honest out of the group, and hire that
person.  

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 03, 2002 1:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Impossible Candidate

Who would be qualified to interview this candidate and determine that
they
are truly skilled in all of those areas?  

-Original Message-
From: Keith Purtell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 1:29 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Impossible Candidate


In addition to the wildly unrealistic nature of their wish list, there's
another problem. No human
being in existence could pack all those activities into a normal work
day.
Someone in their HR
department is smoking banana peelings.

Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email:  [EMAIL PROTECTED]


CONFIDENTIALITY NOTICE: This email message, including any attachments,
is
for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the
intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Misty Woodward
Sent: Thursday, October 03, 2002 1:21 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Impossible Candidate


I know last week we had the discussion about how employers were wanting
candidates with CF
experience plus maybe some C or VB. Even the skills required in that
post I
was quite surprised.
UNTIL

(Landed in my inbox today)
The candidate should have all these skills:

1. Computer Science undergraduate degree is big plus
2. Minimum of 5 years of web development experience
3. ColdFusion
4. Java
a. Classes, Servlets
b. JMS
c. JBOSS, WebLogic, TogetherJ
d. Javascripting
5. Oracle 8i and/or 9i
a. DBA
b. PL/SQL
6. XML/DTD - Using, parsing, developing in CF and Java
7. BizTalk with IWay or any similar tools / ETL tools knowledge is a
plus
8. Extremely good understanding of development cycles and needs in each
cycle
a. Development, Test, Q/A, Product
b. Unit testing
c. Scripted deployment / deployment scripting (nightly builds, etc.)
d. Bug tracking
e. Documentation
9. Visual Basic
10. Very comfortable with CF Studio, MS Visial Studio 6.x (esp. VB),
CVS,MS VSS, Rapid SQL, Adobe Web Development tools, Macromedia Web
Development
tools
11. Windows 2000 O/S knowledge
12. Unix/Linux O/S knowledge is a plus
13. Very good in tranlating business requirements into programming
14. Extremely good team player
15. EDI knowledge is a plus
16. ASP and VB scripting is a plus
17. DHTML knowledge
18. Very comfortable in O/S, application, etc. software installation
19. Very comfortable in TCP/IP Networking, esp. VPN

How much you wanna bet they only wanna pay about $50k for this
super-geek
lol

Misty




---
[This E-mail scanned for viruses by Declude Virus]

 
 
__
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]
 


*
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email 
in error please notify [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 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]
 


__
The

[KCFusion] next meeting?

2002-09-12 Thread Matt Jones 

When is the next meeting? 


__
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]