Hi,
I recieve an error with the following query but am not sure why:
Dim cmd As SqlCommand = conn.CreateCommand()
cmd.CommandText = "(select ID, Name, Comment from tbl_CommentsNew Where (replyTo = @ReplyTo) Order By ID)"
cmd.CommandType = CommandType.Text
cmd.Parameters.AddWithValue("@ReplyTo", replyTo)
the error is: Incorrect syntax near the keyword 'Order'.
Any idea why?
Go to the complete details ...