[thesite] [BUG] The timestamp on comments ...

[jeff]

aardvark,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: aardvark
:
: as far as i know, the date is assigned by the
: server, not the client... given that, the client's
: time zone shouldn't matter at all...
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

this is correct.

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: also, if you check the comment at evolt.org, you'll
: notice the top comment is out of order, but has a
: later time-stamp than the other two...
:
: my guess is that it's an error in the sort from the
: SQL query...
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  SELECT
    replies.commentid,
    replies.messagename,
    replies.message,
    replies.userid,
    replies.grrrs,
  	to_char(replies.datemod, 'mm/dd/yyyy HH:mi:ss') datemod,
    users.who
  FROM
    replies,
    users
  WHERE
    users.userid = replies.userid
    AND contentid = #Val(url.aid)#
  ORDER BY datemod ASC

looks good to me.  seems odd.  it's obviously getting the right times and in
the right order.  for whatever reason the data is going in with different
times.

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org/
mailto:jeff at members.evolt.org