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:

off topic - dna snipets (1997) Sending mail (was forms and variables) (1998) [WebDNA] SEARCH question - SHOWIF - HIDEIF question (2011) Missing Cart Information (2003) Pass Thru Page? (1998) Meet your competition (2000) OT ImageMagick and Thumbnails (2003) RE: type 2 errors with ssl server (1997) Beta 3.0.3 fix for serial# problem (Mac) (1998) Too Much Info (1998) [ReturnRaw] and hiding FORM data (2003) searching by date range help needed (1997) Sorting by date (1997) time format (2005) Bug? (1997) Calculating multiple shipping... (1997) WebCatalog/WebMerchant 2.1 (1998) oops private message leaked into talk list (1997) test (2002) Add more fields to an existent data base (1997)