I need a little help here: I have an Access database hosted on GoDaddy shared account. I can access the database with no problem. I am able to delete certain things from the database no problem, so I know this is got to be a coding issue:
I am trying to delete records from a table where a date is older than 180 days; this is what I have tried: sql= "DELETE * FROM Applicants WHERE datediff(day,'date',datenow()) >180;" as well as this one: sql=" Delete 8 From Applicants where 'date' < date() -180; The problem is, it delete one time now it will not delete any more records....so I have to be missing something; what am I missing. Thank you all in advance for any help you can give. Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Microsoft DOTNET ASP, C++, SQL SERVER" group. ------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------- For stunning photoshop tutorials, visit: www.psd-help.blogspot.com ------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
