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:

WebCat2 Append problem (B14Macacgi) (1997) Summing a field full of numbers ... (1997) using showpage and showcart commands (1996) SendNews (1999) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) How can I Add several Items into the cart at once? (1997) WebCat editing, SiteGuard & SiteEdit (1997) Automatic installation of WebDNA by hosting clients? (2005) [SearchString] problem with [search] context (1997) Notepad problems (1998) [OT] .htaccess & SSL (2004) Combining search criteria (2000) Deleting Orders (1997) Listserver problem (1997) WebCat 5 Intranet Question (2003) Newbie question (1998) Banner Ad solution (2001) Help! WebCat2 bug (Ben's input) (1997) Mac: [ListFiles] bug alert (1997) Running _every_ page through WebCat ? (1997)