CODEWITHSUNDEEP
asp.netvb.netsql-server-2005
Mr. Goo
Mr. Goo

Reputation: 1

What was the problem in this query?

  Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT [counts] FROM [a1_holds] WHERE (dates ='" & TextBox1.Text & "' BETWEEN from_date AND to_date) AND service ='" & lab5.Text & "' ORDER BY [id] ASC", SQLData)

ERROR :incorrect syntax near BETWEEN

Upvotes: 0

Views: 157

Answers (2)

Stephen Chung
Stephen Chung

Reputation: 14605

WHERE (dates = '...' BETWEEN ... AND ...)

is a syntax error. Either: ('...' BETWEEN ... AND ...) or (dates = '...')

Upvotes: 1

amit_g
amit_g

Reputation: 31250

Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT [counts] FROM [a1_holds] WHERE ('" & TextBox1.Text & "' BETWEEN from_date AND to_date) AND service ='" & lab5.Text & "' ORDER BY [id] ASC", SQLData)

Upvotes: 2

Related Questions