quote:

---

Originally posted by Mondeo

I have a datetime field in my database, but this statement doesn't work

SELECT * FROM vwAllMatrixVehicles
WHERE created > 1/1/2008

It returns all records even though nothing has a created date in 2008

Have I got the syntax wrong?

Thanks

---

sqlSel = "SELECT * FROM vwAllMatrixVehicles WHERE created >= '2007/8/9'"

Dim db As New SQLDatabase
Response.Write(SQL)
Try
db.openDB()
dsResults = db.GetDataSet(sqlSel).Tables(0)
Catch ex As Exception
Response.Write(ex.Message)
Finally
db.closeDB()
End Try

My database class

Public Class SQLDatabase

    Public Enum DatabaseType
        MatrixDatabase
        CapDatabase
        CapCommercialDatabase
        MembershipDatabase
        MatrixTESTSERVERDATABASE
    End Enum

    Private conn As SqlConnection
    Public Sub New(Optional ByVal type As DatabaseType = DatabaseType.MatrixDatabase)
        Select Case type
            Case DatabaseType.MatrixDatabase
                conn = New SqlConnection(myConnStr)
            Case DatabaseType.CapDatabase
                conn = New SqlConnection(myConnStr)
            Case DatabaseType.CapCommercialDatabase
                conn = New SqlConnection(myConnStr)
            Case DatabaseType.MembershipDatabase
                conn = New SqlConnection(myConnStr)
            Case DatabaseType.MatrixTESTSERVERDATABASE
                conn = New SqlConnection(myConnStr)

        End Select
    End Sub

    Public Sub openDB()
        If conn.State = ConnectionState.Closed Then
            conn.Open()
        End If
    End Sub

    Public Sub closeDB()
        If Not (conn.State = ConnectionState.Closed) Then
            conn.Close()
        End If
    End Sub

    Public Function GetDataSet(ByVal sql As String) As DataSet




        Try
            Dim myCmd As SqlCommand = New SqlCommand(sql, conn)
            Dim DA As SqlDataAdapter = New SqlDataAdapter
            DA.MissingSchemaAction = MissingSchemaAction.AddWithKey
            DA.SelectCommand = myCmd
            Dim ds As DataSet = New DataSet
            DA.Fill(ds, "table")
            Return ds
        Catch ex As Exception
            Throw New Exception(ex.Message)
        End Try
    End Function
End class