Re: Null Values check 2
This is a multi-part message in MIME format.
--=_NextPart_000_0253_01C0015C.C78A9120
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
RE: Null Values check 2Or,
it is null
it is not null
it ain't defined
You don't need all this code, depending on the need to determine the =
existence of the variable first.
the IIF() function is very slow, especially when throwing in the DE() =
function.
DC
- Original Message -=20
From: Chapman, Katrina=20
To: [EMAIL PROTECTED]=20
Sent: Tuesday, August 08, 2000 17:11
Subject: RE: Null Values check 2
This will check for the existence and if it is null.=20
=20
It's Null=20
=20
Or you could use=20
=20
It's Not Null=20
=20
--K=20
-Original Message-=20
From: Dempsey, Timothy F. [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 6:30 AM=20
To: '[EMAIL PROTECTED]'=20
Subject: RE: Null Values check 2=20
Aslam,=20
I think what you want is:=20
=20
I don't believe there is the equivalent of SQL's NULL in CF.=20
The above will determine if there is such an entity called tempValue=20
and if there is, there is stioll a possibility that it could be "" or =
0.=20
-- Tim Dempsey=20
-Original Message-=20
From: aslam bajaria [mailto:[EMAIL PROTECTED]]=20
Sent: Monday, August 07, 2000 6:06 PM=20
To: [EMAIL PROTECTED]=20
Subject: Null Values check 2=20
When I used the statement :=20
=20
...=20
=20
I got the following error. Is there a different way of=20
checking for NULL?!=20
Error Occurred While Processing Request=20
Error Diagnostic Information=20
Error resolving parameter NULL=20
ColdFusion was unable to determine the value of the=20
parameter. This problem is very likely due to the fact=20
that either:=20
You have misspelled the parameter name, or=20
You have not specified a QUERY attribute for a=20
CFOUTPUT, CFMAIL, or CFTABLE tag.=20
--- Marcus <[EMAIL PROTECTED]> wrote:=20
> > Hi All,=20
> >=20
> > I am getting an error when I write a code like:=20
> >=20
> > =20
> >=20
> > ...=20
> >=20
> > =20
> >=20
> > If I write=20
> >=20
> > =20
> > ...=20
> > =20
>=20
> Null values can't use EQ or =3D, you need to ask=20
>=20
> =20
>=20
=
-=
---=20
--=20
> Archives:=20
>=20
http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
> To Unsubscribe visit=20
>=20
=
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk=20
> or send a message to=20
> [EMAIL PROTECTED] with 'unsubscribe'=20
> in the body.=20
__=20
Do You Yahoo!?=20
Kick off your party with Yahoo! Invites.=20
http://invites.yahoo.com/=20
=
-=
---=20
--=20
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
To Unsubscribe visit=20
=
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or=20
send a message to [EMAIL PROTECTED] with 'unsubscribe' =
in=20
the body.=20
=
-=
---=20
--=20
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
To Unsubscribe visit=20
=
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or=20
send a message to [EMAIL PROTECTED] with 'unsubscribe' =
in=20
the body.=20
=
-=
-=20
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.
--=_NextPart_000_0253_01C0015C.C78A9120
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
RE: Null Values check 2
Or,
<cfif isdefined("tempvalue") and not =
len(trim(tempvalue))>
it is null
<cfelseif isdefined("tempvalue") and =
len(trim(tempvalue))>
it is not null
<cfelse>
it ain't defined
</cfif>
You don't need all this code, depending =
on the need=20
to determine the existence of the variable first.
the IIF() function is very slow, =
especially when=20
throwing in the DE() function.
DC
- Original Message -
From:=20
mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]>Chapman,=20
Katrina
To: mailto:[EMAIL PROTECTED]&
RE: Null Values check 2
This will check for the existence and if it is null. It's Null Or you could use It's Not Null --K -Original Message- From: Dempsey, Timothy F. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 6:30 AM To: '[EMAIL PROTECTED]' Subject: RE: Null Values check 2 Aslam, I think what you want is: I don't believe there is the equivalent of SQL's NULL in CF. The above will determine if there is such an entity called tempValue and if there is, there is stioll a possibility that it could be "" or 0. -- Tim Dempsey -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 6:06 PM To: [EMAIL PROTECTED] Subject: Null Values check 2 When I used the statement : ... I got the following error. Is there a different way of checking for NULL?! Error Occurred While Processing Request Error Diagnostic Information Error resolving parameter NULL ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. --- Marcus <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I am getting an error when I write a code like: > > > > > > > > ... > > > > > > > > If I write > > > > > > ... > > > > Null values can't use EQ or =, you need to ask > > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Null Values check 2
Aslam, I think what you want is: I don't believe there is the equivalent of SQL's NULL in CF. The above will determine if there is such an entity called tempValue and if there is, there is stioll a possibility that it could be "" or 0. -- Tim Dempsey -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 6:06 PM To: [EMAIL PROTECTED] Subject: Null Values check 2 When I used the statement : ... I got the following error. Is there a different way of checking for NULL?! Error Occurred While Processing Request Error Diagnostic Information Error resolving parameter NULL ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. --- Marcus <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I am getting an error when I write a code like: > > > > > > > > ... > > > > > > > > If I write > > > > > > ... > > > > Null values can't use EQ or =, you need to ask > > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Null Values check 2
OR --K Thank you, Katrina Chapman ColdFusion Web Developer Systems Development -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:06 PM To: [EMAIL PROTECTED] Subject: Null Values check 2 When I used the statement : ... I got the following error. Is there a different way of checking for NULL?! Error Occurred While Processing Request Error Diagnostic Information Error resolving parameter NULL ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. --- Marcus <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I am getting an error when I write a code like: > > > > > > > > ... > > > > > > > > If I write > > > > > > ... > > > > Null values can't use EQ or =, you need to ask > > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Null Values check 2
When I used the statement : ... I got the following error. Is there a different way of checking for NULL?! Error Occurred While Processing Request Error Diagnostic Information Error resolving parameter NULL ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. --- Marcus <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > I am getting an error when I write a code like: > > > > > > > > ... > > > > > > > > If I write > > > > > > ... > > > > Null values can't use EQ or =, you need to ask > > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
