If statement in SQL Query

    Date: 11/18/05 (Web Development)    Keywords: no keywords

    I am trying to write a If query in a search statement
    so that if the values equal certian dates then it will
    ignore dates entirely in the search otherwise run the
    search query with the dates.

    If FromDt = '01/01/2005' AND ToDate = '12/12/2030' Then
    ' ignore the date part of the search
    Else
    ' do the date search after all
    End If

    I am looking for it to do something like that but just
    can't get the conditional statement working.

    Source: http://www.livejournal.com/community/webdev/271523.html

« question on online store || Javascript - Pop up boxes »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home