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:

nslookup (2000) Replacing the db file (2000) HELP WITH DATES (1997) Multiple security dbs (1997) Electronic Delivery (1997) RE: Can a database get stomped by simultaneous access? (1997) Weird [blank] interpretation (1999) problems with 2 tags shakur (1997) [ot] Still Interested In Acquiring Hosting Companies (2006) More news on 5.0 (2003) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Pithy questions on webcommerce & siteedit (1997) [delete] problem (1997) [WebDNA] Search/sort/summ problem (2010) [append] vs. [appendfile] delta + question? (1997) WebDNA 6 (2004) [WebDNA] Authnet temporarily down? (2009) Robert Minor duplicate mail (1997) Q: how long for answers to the WebDNA-Talk list? (1997) PCS Frames (1997)