Search results

Thanks a lot...It Seems to be working... :)

Hi all, I have a table, "S" with the following columns Columns are : Sid UserId Date (Date/Time DataType) Time (Date/Time DataType) Amount I need a query that returns the last 100 visitors to my site. How can i do that? Please advise Many Thanks

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") =...

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...

Thanks a lot JT Problem has been solved. As advised by FoFa previously in another thread, i do not really have to use the LIKE condition. But will keep in mind of your suggestion if i need to use it in the future. Thanks again.

Sorry will restrict to General from now onwards

Sorry will restrict to General from now onwards :)

Thanks a million FoFa Your reply has solved my problem... Posted the question in several forums as i'm new to this forum and didnt know where i would get a reply from. Would restrict my questions to this forum from now onwards...Thanks a lot

Hi can anyone help me with this query? 'SQLTable "Resolutions Per Year", "SELECT ResName, COUNT(ResName) AS Total FROM Stats LEFT JOIN Resolutions ON (Stats.UserID = Resolutions.UserID AND Stats.ResID=Resolutions.ResID) WHERE Stats.UserId = '"&login&"' AND Date LIKE '%sYear%' GROUP BY...

Hi can anyone help me with this query? 'SQLTable "Resolutions Per Year", "SELECT ResName, COUNT(ResName) AS Total FROM Stats LEFT JOIN Resolutions ON (Stats.UserID = Resolutions.UserID AND Stats.ResID=Resolutions.ResID) WHERE Stats.UserId = '"&login&"' AND Date LIKE '%sYear%' GROUP BY...

Thanks for the advise Col Unfortunately its still not updating properly... After 8 hits to my site, Table 1 ("Total") = 8 Table 2 ("Total") = 8 Table 3 ("Total") = 8 Table 4 ("Total") = 8 Table 5 ("Total") = 7 Table 6 ("Total") = 8 There is a lost of 1 count :(

Need help and advice desperately, I am trying to update about 10 tables each time a visitor visits my site.. however there are often missing counts, meaning the total data in each table are not the same frequently They are supposed to be since all the tables get updated each time. Im using MS...

Hi can anyone help me with this query? 'SQLTable "Resolutions Per Year", "SELECT ResName, COUNT(ResName) AS Total FROM Stats LEFT JOIN Resolutions ON (Stats.UserID = Resolutions.UserID AND Stats.ResID=Resolutions.ResID) WHERE Stats.UserId = '"&login&"' AND Date LIKE '%sYear%' GROUP BY...

Need help and advice desperately, I am trying to update about 10 tables each time a visitor visits my site.. however there are often missing counts, meaning the total data in each table are not the same frequently They are supposed to be since all the tables get updated each time. Im using MS...