|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
January 15th, 2004, 07:37 AM
|
|||
|
|||
|
Extracting data by date
I have a website where people can add job vacancies to our database. In the admin section I can delete these vacancies but have trouble with selecting certain dates from the database.
For example if I wanted to delete all the jobs from the database for the 18/12/2003 I would select the date then all the jobs will appear on the screen and I can delete them. But if I select a date such as 06/12/2003 or 11/12/2003 it doesnt display anything from the database when I know there are a couple of hundred in there for those dates. If anyone can shine some light of this I would be very grateful.
|
|
#2
January 15th, 2004, 09:54 AM
|
|||
|
|||
|
what database? and are you asking for an sql statement ?
Code:
delete from tblName where JobDate between '6/12/2003' AND '11/12/2003' that's the SQL statement that will do the delete.
|
|
#3
January 15th, 2004, 10:13 AM
|
|||
|
|||
|
I am using an MSAccess database and the sql statement is
Set records=conn.execute("SELECT * FROM jobs WHERE posted = #" & posted & "#")
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Extracting data by date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
