You should evaluate that expression as a Boolean...
<cfif NOT GetRecord.ViewField6></cfif>
that should run faster than IS 0.
_________________________________________
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM / NETDesign Inc.
http://www.cfdev.com/
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 30, 2000 10:12 PM
To: [EMAIL PROTECTED]
Subject: RE: Why won't my <cfif> work with this??
Duh.
Works perfect. Thanks!
Jeff Fongemie
-----Original Message-----
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 30, 2000 9:58 PM
To: [EMAIL PROTECTED]
Subject: Re: Why won't my <cfif> work with this??
Try:
<cfif GetRecord.ViewField6 is 0>
Regards,
Howie Hamlin
--
inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
www.CoolFusion.com
============================================================
Please vote for iMS in the Most Innovative category here:
*** http://www.sys-con.com/ColdFusion/readerschoice2000/ ***
============================================================
Check out inFusion Mail Server - the world's most configurable email server
----- Original Message -----
From: Jeff Fongemie <[EMAIL PROTECTED]>
To: Cf-Talk <[EMAIL PROTECTED]>
Sent: Friday, June 30, 2000 9:57 PM
Subject: Why won't my <cfif> work with this??
> This looks so simple, am I missing something obvious? I can't get the
<cfif
> ViewField6 is 0> to work.
>
> <CFQUERY name="GetRecord" dataSource="847_bib" maxRows=1>
> SELECT news.headline AS ViewField1, news.news AS ViewField2,
> news.date_entered AS ViewField3, news.blurb AS ViewField4, news.photo AS
> ViewField5, news.live, news.live AS ViewField6, news.newsID AS ID_Field
> FROM news
>
> <CFIF ParameterExists(URL.RecordID) IS "no">
> ORDER BY news.newsID DESC
> </CFIF>
>
>
> <CFIF ParameterExists(URL.RecordID)>
> WHERE news.newsID = #URL.RecordID#
> </CFIF>
> </CFQUERY>
>
>
> <HTML><HEAD>
> <TITLE>newswork - View Record</TITLE>
> </HEAD><BODY bgcolor="ffffff">
> <font size="+1"><img src="../images/control_01.gif" width="600"
> height="104"></font>
> <br>
> <font size="+2"><b><font face="Arial, Helvetica, sans-serif">View News
> Records</font></b></font>
>
>
> <cfif ViewField6 is 0>
> <b><font size="2" face="Arial, Helvetica, sans-serif" color="red">THIS
> NEWS
> RECORD IS NOT LIVE</font></b>
> <cfelse>
> <font color="green"><b><font face="Arial, Helvetica, sans-serif"
> size="2">THIS
> NEWS RECORD IS LIVE</font></b></font>
> </cfif>
>
> Jeff F.
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.
