Bizarre Reocurrence of Time data in Table

pikachew

Registered User.
Local time
Tomorrow, 03:48
Joined
Jan 26, 2005
Messages
34
Hi all,
Been having this problem for a long time.
Everytime my function is being called, a new tuple gets inserted into Table "Stats" containing the below mentioned data.

sSQL = "SELECT * FROM Stats WHERE UserID = '"&sUserID&"'"
rs.Open sSQL,,,adCmdTable
'Save the data
rs.AddNew
rs("JaID") = lIdJa
rs("JsID") = lIdJs
rs("LanID") = lIdLan
rs("ResID") = lIdRes
rs("WsID") = lIdWs
rs("Date") = Date
rs("Time") = Time
rs("IP") = sIP
rs("UserID") = sUserID
rs.Update

Some of the weird data i got from Table "Stats"
1/25/2005 12:45:59 aaaa bbbb cccc dddd ..... row1
1/25/2005 12:46:24 aaaa bbbb cccc dddd ..... row2
1/25/2005 12:46:29 aaaa bbbb cccc dddd ..... row3
1/25/2005 12:46:35 aaaa bbbb cccc dddd ..... row4
1/25/2005 12:46:40 aaaa bbbb cccc dddd ..... row5
1/25/2005 12:46:40 aaaa bbbb cccc dddd ..... row6
1/25/2005 12:46:40 aaaa bbbb cccc dddd ..... row7
1/25/2005 12:52:51 aaaa bbbb cccc dddd ..... row8


Each time a person click on my site, one tuple will be inserted into the Table "Stats".
Time which is one of the column of the Table "Stats" is inserted into the table each time the function is called
The puzzling thing is how is it possible for the time to be the same for row 5,6 & 7.
This happens very often and i have totally no explantion for it. I tried changing the time format, date format, however i always get this.
Please advise.
Thanks a lot
 
You seem to be using Date and Time as field names. These are reserved words and will cause all sorts of problems, perhaps including the ones you're having now. Try changing your field names.
 
Ok will try to change them and see how it goes from here.
Thanks for the advise..will update the results soon.
:)
 

Users who are viewing this thread

Back
Top Bottom