Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Delete problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Delete problem

 Post Reply Post Reply
Author
twooly View Drop Down
Groupie
Groupie


Joined: 24 September 2003
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote twooly Quote  Post ReplyReply Direct Link To This Post Topic: Delete problem
    Posted: 03 January 2004 at 7:10pm

I am trying to create a script that will show users online without using global.asa.  I almost have it working besides one thing.  I want my sql to delete entries in a table once an entry reaches a certain point.  So here is what I have.  My problem is it deletes everything in the table.
Suggesstions.

Here is the code:

strTimeout = 5
StrOnlineTimedout = dateadd("n",-strtimeout*60,onlinedate)

StrSql = "DELETE FROM active_users WHERE Last_Seen < '" & StrOnlineTimedout & "'"
adoCon.execute (StrSql)

I am using an access db and the column Last_Seen has a type "memo" and the form that the date entered into the column is 1/3/2004 2:40:17 PM using the now() function.

Thanks

Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post Posted: 03 January 2004 at 7:35pm
Change the last_seen data type to datetime
Back to Top
twooly View Drop Down
Groupie
Groupie


Joined: 24 September 2003
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote twooly Quote  Post ReplyReply Direct Link To This Post Posted: 03 January 2004 at 7:49pm

I tried that when I do that I get this.

 

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Back to Top
twooly View Drop Down
Groupie
Groupie


Joined: 24 September 2003
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote twooly Quote  Post ReplyReply Direct Link To This Post Posted: 03 January 2004 at 8:15pm

When I change the sql to this I then get the following error

StrSql = "DELETE FROM active_users WHERE Last_Seen < " & StrOnlineTimedout

 

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Last_Seen < 1/3/2004 2:16:39 PM'.

 

 

Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post Posted: 03 January 2004 at 9:06pm
Access dates need to be surrounded by number signs (#)
StrSql = "DELETE FROM active_users WHERE Last_Seen < #" & StrOnlineTimedout &"#"
Back to Top
twooly View Drop Down
Groupie
Groupie


Joined: 24 September 2003
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote twooly Quote  Post ReplyReply Direct Link To This Post Posted: 03 January 2004 at 9:10pm

That did it

 

Thanks

 

 

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.