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_01BFEAAC.DB4262B0
Content-Type: text/plain;
charset="iso-8859-1"
shouldn't this work?:
iif(IsDate(form.thedate), DE(#CreateODBCDate(form.thedate)#), DE(""))
--b
p.s. if you ever think you have it bad....here is an iif that took a few
hours of my time and about 15 minutes of a colleagues:
iif(query.red_flag[rowNbr], DE(caller.pqa & '/redflag.gif'),
iif(query.close_flag[rowNbr], ""DE(iif(query.won_flag[rowNbr], DE(caller.pqa
& '/thumbs_up.gif'), DE(caller.pqa & '/thumbs_down.gif')))"",
""DE(caller.pqa & '/transpix.gif')""))
Laterz.
--------------------------------------------
Bryan D. Batchelder Work: 813-935-7100
Palm/Internet Developer Home: 727-547-1322
--------------------------------------------
ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618
--------------------------------------------
-----Original Message-----
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 10, 2000 4:15 PM
To: [EMAIL PROTECTED]
Subject: IIf() and DE confusion
I know this can be done, but I'll be hanged if I can figure out the right
combination of DE() and ## and quotes and whatever else might be needed.
I'm trying to use IIf() in a SQL statement instead of the following:
thedate = <cfif
IsDate(form.thedate)>#CreateODBCDate(form.thedate)#<cfelse>NULL</cfif>
Thanks,
Jim
----------------------------------------------------------------------------
--
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.
------_=_NextPart_001_01BFEAAC.DB4262B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: IIf() and DE confusion</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>shouldn't this work?:</FONT>
</P>
<P><FONT SIZE=3D2>iif(IsDate(form.thedate), =
DE(#CreateODBCDate(form.thedate)#), DE(""))</FONT>
</P>
<P><FONT SIZE=3D2>--b</FONT>
</P>
<P><FONT SIZE=3D2>p.s. if you ever think you have it bad....here =
is an iif that took a few hours of my time and about 15 minutes of a =
colleagues:</FONT></P>
<P><FONT SIZE=3D2>iif(query.red_flag[rowNbr], DE(caller.pqa & =
'/redflag.gif'), iif(query.close_flag[rowNbr], =
""DE(iif(query.won_flag[rowNbr], DE(caller.pqa & =
'/thumbs_up.gif'), DE(caller.pqa & =
'/thumbs_down.gif')))"", ""DE(caller.pqa & =
'/transpix.gif')""))</FONT></P>
<P><FONT SIZE=3D2>Laterz.</FONT>
</P>
<P><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT SIZE=3D2>Bryan D. =
Batchelder Work: =
813-935-7100</FONT>
<BR><FONT SIZE=3D2>Palm/Internet Developer Home: =
727-547-1322</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT SIZE=3D2>ConnectWise, Inc. (www.ConnectWise.com)</FONT>
<BR><FONT SIZE=3D2>2803 West Busch Blvd, Suite 204</FONT>
<BR><FONT SIZE=3D2>Tampa, FL 33618</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Jim McAtee [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]=
</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, July 10, 2000 4:15 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: IIf() and DE confusion</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I know this can be done, but I'll be hanged if I can =
figure out the right</FONT>
<BR><FONT SIZE=3D2>combination of DE() and ## and quotes and whatever =
else might be needed.</FONT>
<BR><FONT SIZE=3D2>I'm trying to use IIf() in a SQL statement instead =
of the following:</FONT>
</P>
<P><FONT SIZE=3D2>thedate =3D <cfif</FONT>
<BR><FONT =
SIZE=3D2>IsDate(form.thedate)>#CreateODBCDate(form.thedate)#<cfels=
e>NULL</cfif></FONT>
</P>
<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Jim</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BFEAAC.DB4262B0--
------------------------------------------------------------------------------
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.