Re[2]: Date Time Oddness

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24435
interpreted = N
texte = I am using a ShoppingCart...with the ShowCart command. It is for groceries. The person selects their items, then when the order is confirmed, those items are written to a new database, purchased.db. Then...daily and weekly reports need to be generated from the purchased.dbIf a person orders today before 9:30, then delivery is possible today. If a person orders today after 9:30, then delivery must be after today. Either way, they select their delivery date.In order to show them only their valid delivery date options, I want to use this:[showif [myTime]>0930] [showif [myDate]=Monday] [/showif] [/showif][showif [myTime]<0930] [showif [Date %A]=Monday] [/showif] [/showif]But because the ShoppingCart file already has a [Date] and [Time]...I can't.This is also important for running the daily and weekly totals (for the grocery store)...because I can't use only the day of the week....there will be duplicates from the second, third, fourth week...etc. I can't use only times, because of the same reason. This is the only solution I have thought of....is there an easier way? I'm trying the myDate and myTime right now.At 12:07 PM 11/15/99, you wrote: >Are you using a ShoppingCart or OrderFile on that second page? Then you have >those fields already. You are pulling the [Date] and [Time] out of your >ShoppingCart or Orderfile. See the File Format for Orderfile in the docs. > >What are you actually trying to do with Date and Time? You may have to get >funky with [Math] and/or [Format] to get what you want. It may even be easier >to pass myDate and myTime from the previous page. > >The behavior you describe has been mentioned before; check the archives (you may >get lucky). I believe this behavior could be described as an inconsistency in >the parse engine, if not an out right bug, since it is not looking for the >terminal bracket before deciding you mean the database variable [Date] instead >of the system call [Date].*************************************************************************** What you are speaks so loud that I cannot hear what you say. - Ralph Waldo Emerson (1803-1882) - Philosopher and Writer - ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re[2]: Date Time Oddness (Kim 1999)
  2. Re[2]: Date Time Oddness ( 1999)
I am using a ShoppingCart...with the ShowCart command. It is for groceries. The person selects their items, then when the order is confirmed, those items are written to a new database, purchased.db. Then...daily and weekly reports need to be generated from the purchased.dbIf a person orders today before 9:30, then delivery is possible today. If a person orders today after 9:30, then delivery must be after today. Either way, they select their delivery date.In order to show them only their valid delivery date options, I want to use this:[showif [myTime]>0930] [showif [myDate]=Monday] [/showif] [/showif][showif [myTime]<0930] [showif [Date %A]=Monday] [/showif] [/showif]But because the ShoppingCart file already has a [date] and [time]...I can't.This is also important for running the daily and weekly totals (for the grocery store)...because I can't use only the day of the week....there will be duplicates from the second, third, fourth week...etc. I can't use only times, because of the same reason. This is the only solution I have thought of....is there an easier way? I'm trying the myDate and myTime right now.At 12:07 PM 11/15/99, you wrote: >Are you using a ShoppingCart or OrderFile on that second page? Then you have >those fields already. You are pulling the [date] and [time] out of your >ShoppingCart or Orderfile. See the File Format for Orderfile in the docs. > >What are you actually trying to do with Date and Time? You may have to get >funky with [math] and/or [format] to get what you want. It may even be easier >to pass myDate and myTime from the previous page. > >The behavior you describe has been mentioned before; check the archives (you may >get lucky). I believe this behavior could be described as an inconsistency in >the parse engine, if not an out right bug, since it is not looking for the >terminal bracket before deciding you mean the database variable [date] instead >of the system call [date].*************************************************************************** What you are speaks so loud that I cannot hear what you say. - Ralph Waldo Emerson (1803-1882) - Philosopher and Writer - ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Kim

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:

Digest Version (2000) Our Webcat site launched (1997) [subtotal] and others (1997) PSC recommends what date format yr 2000??? (1997) problem with [Format Days_To_Date] (2000) security problem (1997) Mondo amounts of Mail [long] (1999) Progress !! WAS: Trouble with formula.db (1997) WC 2.0 frames feature (1997) [WC 2.1.30] Stack overflow. (2000) Web*SSL and WebCatalog (1997) Emailer Error 550 (Was Strange Crash) (1998) WebCatalog Upgrade Pricing? (1997) Getting Started (2003) Shopping Cart w/Multiple Databases (1998) Listserver problem (1997) shipcost (1997) Talk List Archive Down? (2004) [WebDNA] I need a newbie installation primer (2011) Remove from list server (1997)