P
Paul King
Hi there.
I want to construct a SQL ASPX page and wish to fetch all information back.
At the moment I have the following script:
Dim strSqlProducts As String = "SELECT convert(char(10),VenueDate,103) as
Date, Venue, County, Comments " & _ "FROM WeddingFayres ORDER By VenueDate"
I would like to add a WHERE statement so that the VenueDate >= Current
System Date
Could anyone help?
Thanks
Paul.
I want to construct a SQL ASPX page and wish to fetch all information back.
At the moment I have the following script:
Dim strSqlProducts As String = "SELECT convert(char(10),VenueDate,103) as
Date, Venue, County, Comments " & _ "FROM WeddingFayres ORDER By VenueDate"
I would like to add a WHERE statement so that the VenueDate >= Current
System Date
Could anyone help?
Thanks
Paul.