Thanks alot. That did the trick.
I appreciate all the help guys!
On Wed, 30 Oct 2002 08:26:44 -0500, Everett, Al wrote:
> 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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
