Re: [TIME] not working

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68768
interpreted = N
texte = Hi Matthew, Thanks for the hint on naming my variables. I actually knew that once, but never got into a good habit. I've changed my variable names based on your advice. I've also 'exposed' my code as you suggested. The [TIME] was displayed properly in the code, yet the variable is still not being written to the .db I'm still stumped here, but at least I have better coding habits. Thanks, sfb On Apr 7, 2007, at 4:00 PM, Matthew A Perosi wrote: > I don't see any error jumping out at me right now. > Try exposing your code in the browser and wee what's actually being > produced. > Example: > append db=login.db]SKULOG=[url][SKUvar][/url]&USERNAMEa=[url] > [USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa][/url]&LEVEL=[url] > [LEVEL][/url]&DATE_ENTERED=[DATE]&ENTERED_TIME=[TIME]&ADMIN_USER= > [url][ADMIN_USER][/url]/append
> [append db=login.db]SKULOG=[url][SKUvar][/url]&USERNAMEa=[url] > [USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa][/url]&LEVEL=[url] > [LEVEL][/url]&DATE_ENTERED=[DATE]&ENTERED_TIME=[TIME]&ADMIN_USER= > [url][ADMIN_USER][/url][/append] > > You see in the 2 lines above, the first line I have removed the > brackets from the append at the beginning and end. This will show > me what's being added to the database. It might be something else > causing your append time to break. > > Additionally, my college professor told me (a very long time ago) > never to use real words as variables, or at the beginning of > variable names, or as part of a variable name if after a special > character. His reasoning was because you never really know if the > database interpreter will accidentally mis identify your > variables. I have taken his philosophy to heart and it has saved > me many many times. (IMO) In your example above I would have had > variable USRNAMEA, PASSWD, ENTERED_DT, ENTERED_TM and ADM_USR > > Matthew Perosi > > > sbraun wrote: > >> Hi Folks, >> >> I'm having a slight problem. >> When I execute an [append] tag, [TIME] does not work. >> When I execute a [replace] tag, [TIME] will work. >> In the line 'The real time is: [TIME]', [TIME] will work. >> >> Here is my code, Does anyone see what I'm doing wrong? >> >> Thanks much, >> sfb >> >> >> >> >> >> in file #1: ( &ENTERED_TIME=[TIME] is not working) >> >> >> The real time is: [TIME] >> [append db=login.db]SKULOG=[url][SKUvar][/url]&USERNAMEa=[url] >> [USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa][/url]&LEVEL=[url] >> [LEVEL] [/url]&DATE_ENTERED=[DATE]&ENTERED_TIME=[TIME]&ADMIN_USER= >> [url] [ADMIN_USER][/url][/append] >> >> >> >> >> >> in file #2: ( &ENTERED_TIME=[TIME] is working) >> >> [replace db=login.db&eqSKULOGdatarq=[SKULOG]]SKULOG=[url][SKULOG] >> [/ url]&USERNAMEa=[url][USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa] >> [/url] &LEVEL=[url][LEVEL][/url]&ADMIN_USER=[url][ADMIN_USER][/url] >> &MOD_DATE= [DATE]&MOD_TIME=[TIME][/replace] >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> >> > > -- > Matthew A Perosi > Psi Prime, Inc. > http://www.psiprime.com > 323 Union Blvd. > Totowa, NJ 07512 > P: 973.225.9870 > F: 973.413.8217 > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [authenticate] was Re: [TIME] not working ( Terry Wilson 2007)
  2. Re: [authenticate] was Re: [TIME] not working ( Stuart Tremain 2007)
  3. Re: [authenticate] was Re: [TIME] not working ( Donovan Brooke 2007)
  4. Re: [authenticate] was Re: [TIME] not working ( Donovan Brooke 2007)
  5. [authenticate] was Re: [TIME] not working ( sbraun 2007)
  6. Re: [TIME] not working ( Stuart Tremain 2007)
  7. Re: [TIME] not working ( Donovan Brooke 2007)
  8. Re: [TIME] not working ( Matthew A Perosi 2007)
  9. Re: [TIME] not working ( sbraun 2007)
  10. Re: [TIME] not working ( Matthew A Perosi 2007)
  11. [TIME] not working ( sbraun 2007)
Hi Matthew, Thanks for the hint on naming my variables. I actually knew that once, but never got into a good habit. I've changed my variable names based on your advice. I've also 'exposed' my code as you suggested. The [time] was displayed properly in the code, yet the variable is still not being written to the .db I'm still stumped here, but at least I have better coding habits. Thanks, sfb On Apr 7, 2007, at 4:00 PM, Matthew A Perosi wrote: > I don't see any error jumping out at me right now. > Try exposing your code in the browser and wee what's actually being > produced. > Example: > append db=login.db]SKULOG=[url][SKUvar][/url]&USERNAMEa=[url] > [USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa][/url]&LEVEL=[url] > [LEVEL][/url]&DATE_ENTERED=[date]&ENTERED_TIME=[time]&ADMIN_USER= > [url][ADMIN_USER][/url]/append
> [append db=login.db]SKULOG=[url][SKUvar][/url]&USERNAMEa=[url] > [USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa][/url]&LEVEL=[url] > [LEVEL][/url]&DATE_ENTERED=[date]&ENTERED_TIME=[time]&ADMIN_USER= > [url][ADMIN_USER][/url][/append] > > You see in the 2 lines above, the first line I have removed the > brackets from the append at the beginning and end. This will show > me what's being added to the database. It might be something else > causing your append time to break. > > Additionally, my college professor told me (a very long time ago) > never to use real words as variables, or at the beginning of > variable names, or as part of a variable name if after a special > character. His reasoning was because you never really know if the > database interpreter will accidentally mis identify your > variables. I have taken his philosophy to heart and it has saved > me many many times. (IMO) In your example above I would have had > variable USRNAMEA, PASSWD, ENTERED_DT, ENTERED_TM and ADM_USR > > Matthew Perosi > > > sbraun wrote: > >> Hi Folks, >> >> I'm having a slight problem. >> When I execute an [append] tag, [time] does not work. >> When I execute a [replace] tag, [time] will work. >> In the line 'The real time is: [time]', [time] will work. >> >> Here is my code, Does anyone see what I'm doing wrong? >> >> Thanks much, >> sfb >> >> >> >> >> >> in file #1: ( &ENTERED_TIME=[time] is not working) >> >> >> The real time is: [time] >> [append db=login.db]SKULOG=[url][SKUvar][/url]&USERNAMEa=[url] >> [USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa][/url]&LEVEL=[url] >> [LEVEL] [/url]&DATE_ENTERED=[date]&ENTERED_TIME=[time]&ADMIN_USER= >> [url] [ADMIN_USER][/url][/append] >> >> >> >> >> >> in file #2: ( &ENTERED_TIME=[time] is working) >> >> [replace db=login.db&eqSKULOGdatarq=[SKULOG]]SKULOG=[url][SKULOG] >> [/ url]&USERNAMEa=[url][USERNAMEa][/url]&PASSWORDa=[url][PASSWORDa] >> [/url] &LEVEL=[url][LEVEL][/url]&ADMIN_USER=[url][ADMIN_USER][/url] >> &MOD_DATE= [date]&MOD_TIME=[time][/replace] >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> >> > > -- > Matthew A Perosi > Psi Prime, Inc. > http://www.psiprime.com > 323 Union Blvd. > Totowa, NJ 07512 > P: 973.225.9870 > F: 973.413.8217 > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ sbraun

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

b12 cannot limit records returned and more. (1997) Showif, Hideif reverse logic ? (1997) RE: [BULK] RE: [WebDNA] RE: Error. WebDNA (version 5.1g or later) is not running. (2012) WebCatalog for Postcards ? (1997) The Best Shopping Cart Solution I Have Come Upon (2003) Questions! (2000) ShowIf inside formulas (1997) beta 6 on OSX wierdness (2000) RAM variables (1997) [WebDNA] SETCOOKIE (2009) Claris HomePage messes up the code (1997) pop up menu's (1998) Summing fields (1997) Cart questions (1997) Add to Cart & List of Products (1997) WebCat2b12 forgets serial # (1997) Reload adding to cart (2001) how to do multiple prices/item? (1998) How to get shownext to just shownext once (1997) POST (1997)