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:

Credit card processing options. . . (1997) Advice (2003) Nutscrape Doesn't Render Right (2002) Multiple prices (1997) Location of Webcat site in folder hierarchy (1997) Setting up shop (1997) Using Plug-In while running 1.6.1 (1997) Trouble starting WC under OSX (2001) Is there an alternative to emailer? (1999) Inventory Adjustment SOLUTION (2000) Emailer setup (1997) Warning: 50 [MATH] Variable Limit per page (1998) Setting up WebCatalog with Retail Pro data (1996) E-Mail (1998) setting username and password using a form. (2000) Shopping Cart variation... (1997) [WebDNA] Can webDNA be forced to be able to read ANY file in ANY folder in a webroot in =?UTF-8?Q?CentOS=3F?= (2018) NT Version on IIS 4.0 (1997) tab deliminated txt file (2001) Migrating to NT (1997)