I found a bug ...

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12086
interpreted = N
texte = I am running WebCat2 StarNine release 2.0 on a PPC Mac, and I found a bug. Here's the details ...I'm using the standard [date] and [time] tags - without any formatting - to enter those values into the messageDate and messageTime fields of the messages.db whenever someone posts a new message.At the same time, I'm also using a sendmail context on the same template to email the text of each new message to myself. The [date] and [time] tags are used in the text portion of the sendmail context so I can see when the message was posted.Here's what happened - only twice - but it shouldn't have happened at all:When a particular user posted a message, the slashes that *SHOULD HAVE* been placed in the [date] field were replaced by the uppercase letter V ... and the colons that *SHOULD HAVE* been placed in the [time] field were replaced by the lowercase letter a.In other words, 06/16/1997 was entered into the database as 06V16V1997 ... and 14:24:30 was entered as 14a24a30. This screws up the sorting by date and time, because a message like this always appears as if it were the last message entered ...Please note, this error did NOT happen in the [sendmail] context. I checked that mail and the formatting of these values appears the way it should in the email - so the problem appears to be only in the portion of the WebCat2 code that enters these values into the database.This is a bizarre problem because it actually happened twice in a row - but there was a substantial time lag between the posting of these two messages.The first message with this problem was posted at 09:44:23 and the next message was posted at 10:11:11. There were no other messages posted in between these two ... but the same person posted both of these messages, presumeably from the same IP address since they were posted within a half-hour of each other.Here's the thing:If I didn't already know that the dates and times entered into the messages.db are done so completely independently of the both the browser and the users's IP address, I would obviously jump to the conclusion that this error occured because of a problem on the user's end.However, since the dates and times entered into the messages.db are entered directly by WebCatalog 2.0 via an [append] context in my results form, I feel almost certain that this problem could *not* have been caused by either the user's browser or any problems at that person's IP address.The problem happened twice within a half-hour, and it has not happened since. I have no idea what this means. If it had happened only once, I would be able to chalk it up to a one-time glitch. Unfortunately, it happened twice, and the occurrences were almost a half-hour apart, which to me seems to rule out the 'one-time glitch' theory.HELP!!! :) Sincerely, Ken Grome WebDNA Solutions Associated Messages, from the most recent to the oldest:

    
  1. I found a bug ... (Kenneth Grome 1997)
I am running WebCat2 StarNine release 2.0 on a PPC Mac, and I found a bug. Here's the details ...I'm using the standard [date] and [time] tags - without any formatting - to enter those values into the messageDate and messageTime fields of the messages.db whenever someone posts a new message.At the same time, I'm also using a sendmail context on the same template to email the text of each new message to myself. The [date] and [time] tags are used in the text portion of the sendmail context so I can see when the message was posted.Here's what happened - only twice - but it shouldn't have happened at all:When a particular user posted a message, the slashes that *SHOULD HAVE* been placed in the [date] field were replaced by the uppercase letter V ... and the colons that *SHOULD HAVE* been placed in the [time] field were replaced by the lowercase letter a.In other words, 06/16/1997 was entered into the database as 06V16V1997 ... and 14:24:30 was entered as 14a24a30. This screws up the sorting by date and time, because a message like this always appears as if it were the last message entered ...Please note, this error did NOT happen in the [sendmail] context. I checked that mail and the formatting of these values appears the way it should in the email - so the problem appears to be only in the portion of the WebCat2 code that enters these values into the database.This is a bizarre problem because it actually happened twice in a row - but there was a substantial time lag between the posting of these two messages.The first message with this problem was posted at 09:44:23 and the next message was posted at 10:11:11. There were no other messages posted in between these two ... but the same person posted both of these messages, presumeably from the same IP address since they were posted within a half-hour of each other.Here's the thing:If I didn't already know that the dates and times entered into the messages.db are done so completely independently of the both the browser and the users's IP address, I would obviously jump to the conclusion that this error occured because of a problem on the user's end.However, since the dates and times entered into the messages.db are entered directly by WebCatalog 2.0 via an [append] context in my results form, I feel almost certain that this problem could *not* have been caused by either the user's browser or any problems at that person's IP address.The problem happened twice within a half-hour, and it has not happened since. I have no idea what this means. If it had happened only once, I would be able to chalk it up to a one-time glitch. Unfortunately, it happened twice, and the occurrences were almost a half-hour apart, which to me seems to rule out the 'one-time glitch' theory.HELP!!! :) Sincerely, Ken Grome WebDNA Solutions Kenneth Grome

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:

Shorthand for command args (1998) Mac -Shareware Listserver (1998) Netscape 3.01 can't see db in form (1997) Re[2]: Using [Include] Context (1999) Search in 2 or more catalogs (1997) includes and cart numbers (1997) WebCat2b15MacPlugin - showing [math] (1997) multi-paragraph fields (1997) RE: extended ASCII with middle command (1999) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) Math (1997) webcat restarting script on Linux? (1999) Hard Questions ? (1997) Supressing Error Messages (1998) Associative lookup style? + bit more (1997) The Mysterious '<' (1998) [WebDNA] Email syntax checking code? (2015) Search question with a lookup (3 dbs) (2004) bug in wn searching NT version? (1997) Multiple catalog databases and showcart (1997)