SQL Date Query

Results 1 to 4 of 4

Thread: SQL Date Query

  1. #1
    Join Date
    Dec 1969

    Default SQL Date Query

    Does anyone know how to write an SQL statement that will take a Date field and order the rows by most recent date to most past date? The Acending and Decending order does not work.. I&#039;d like a query that takes dates from today, followed by yesterday, and so on in that order.. Any ideas?<BR><BR>Thanks,<BR>NEWBIE

  2. #2
    Join Date
    Dec 1969

    Default It should...Are you sure..

    ...your database field is defined as a date or datetime data type?

  3. #3
    Join Date
    Dec 1969

    Default Your Right,, my bad.... field was not defined corr


  4. #4
    New ASP Guest

    Default HELP!!

    I want to block the IP Address who post Dirty Words in my Forum.<BR><BR>The problem is:<BR>If this IP is a gateway, then all user behind the fire wall will NOT be able to post messages in my forum.<BR><BR>I am trying to find his MAC number in order to make sure just block his PC. <BR><BR>Could you please tell me what is the easy way to do this?<BR><BR>Can NOT use COM(DLL) because I use the FREE ASP HOST in the Internet. I don&#039;t have money to have one. :(<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts