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=listsbody=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
RE: Run code once and only once at inital login...WTF!
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=listsbody=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
RE: Run code once and only once at inital login...WTF!
a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) Also, are you running MX? if not, where are your cflocks? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 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=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Run code once and only once at inital login...WTF!
On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 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=listsbody=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
RE: Run code once and only once at inital login...WTF!
Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? No, only if you're reading/writing to/from SESSION/APPLICATION/SERVER variables. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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
RE: Run code once and only once at inital login...WTF!
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=listsbody=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
RE: Run code once and only once at inital login...WTF!
only around shared scope variables such as session, application and server -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:32 To: CF-Talk Subject: RE: Run code once and only once at inital login...WTF! On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 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=listsbody=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
Re: Run code once and only once at inital login...WTF!
FlashGuy wrote: On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? No around all things that alter or readfrom the session scope ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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
RE: Run code once and only once at inital login...WTF!
You need cflocks around your session vars... -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Wednesday, October 30, 2002 7:32 AM To: CF-Talk Subject: RE: Run code once and only once at inital login...WTF! On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 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=listsbody=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
