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:

why is authenticate screwing with me today (2002) Cookies and domains (2006) why won't this work, please tell me??? (2001) Details of shipping - Totalqty calculations (1997) WebCatalog Hosting (1996) [WebDNA] Webdna and Static pages (2018) Generating Report Totals (1997) WebCatalog for guestbook ? (1997) Interfacing WebMerchant to www.fedex.com (1997) test (2003) Shell Script needed (2003) How to include weather (2000) Re:multiple digests, please stop (1997) How is it done? (1998) formvariables not passing (2000) ReturnRaw context (1997) need some help with tcpsend (2000) Help!!!! (1997) More on the email templates (1997) authenticating a second user (1997)