Re: [TIME] not working

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68769
interpreted = N
texte = Then try this: [replace db=login.db&eqSKULOGdatarq=[url][skuvar][/url]&append=T]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][/replace] This is the [replace] alternative for the [append]. Matthew Perosi sbraun wrote: > 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/ > > -- 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 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)
Then try this: [replace db=login.db&eqSKULOGdatarq=[url][skuvar][/url]&append=T]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][/replace] This is the [replace] alternative for the [append]. Matthew Perosi sbraun wrote: > 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/ > > -- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Matthew A Perosi

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:

WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Practice runs ? (1997) Professional WebDNA Hosting Solutions (2005) Too Much Rootbeer Free Offer (1997) Showif, Hideif reverse logic ? (1997) Encrypted Templates Serving as Text (2000) Error Log.db --however (1997) Text data with spaces in them... (1997) Firesite and [referrer] atg broke (1997) Date problems (1997) [ConvertChars] problem (1997) Execute Applescript (1997) WebCatalog on Linux (2000) My solution... (1996) Close Databases Crash? (1998) Slow NT mail. (2000) Magic [text] shows and then no show (2000) If statement troubles (2002) Languages (1997) Up and running ... at last !! (1997)