That's because while the field is *empty* it is still *defined*
You want something like this:
<cfif isDefined("GetEnv.strField1") AND Len(Trim(GetEnv.strField1)) GT 0>
Or, if it's supposed to be a particular value:
<cfif isDefined("GetEnv.strField1") AND GetEnv.strField1)) EQ
"aParticularValue">
> -----Original Message-----
> From: FlashGuy [mailto:flashmx@;rogers.com]
> Sent: Wednesday, October 30, 2002 8:23 AM
> To: CF-Talk
> Subject: Run code once and only once at inital login...WTF!
>
>
> I have this line in my application.cfm file.
>
> <cfparam name="session.InitialCodeRun" default="FALSE">
>
>
> Then in my index.cfm (which can get reloaded multiple times
> during a session) reads from a database and does some stuff
> based on the session.initialCodeRun.
>
> Here is my code:
>
> <cfif SESSION.InitialCodeRun IS 0>
> <cfset SESSION.InitialCodeRun = 1>
> <cfquery name="GetEnv"
> datasource="profs" dbtype="ODBC">
> SELECT strField1
> FROM table1
> </cfquery>
>
> <cfif isDefined("GetEnv.strField1") IS "Yes">
> --- YES ---
> <cfelse>
> --- NO ---
> </cfif>
> </cfif>
>
> Even though strField1 in my database has *nothing* entered
> there the above code returns "Yes" upon initial login. Even
> if I enter in "no" in that field it still returns "yes"
>
> Whats going on?
>
>
>
> ---------------------------------------------------
> Colonel Nathan R. Jessop
> Commanding Officer
> Marine Ground Forces
> Guatanamo Bay, Cuba
> ---------------------------------------------------
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
