Hi I'm getting this error Incorrect syntax near '='. TID
aspx.v
Dim con As New SqlConnection("Data Source=db;Initial Catalog=admin;User ID=admin;Password=pswd")
Dim pubDate As String = Request.QueryString("pubDate")
Dim TID As String = Request.QueryString("TID")
Dim queryString As String = "SELECT * FROM NewsroomTestimony where PubDate='" + pubDate & "'" + "&TID='" + TID & "'"
Dim fileName As String = ""
Try
Dim cmd As New SqlCommand()
cmd.Connection = Nothing
cmd.CommandText = queryString
cmd.Connection = con
Dim dr As SqlDataReader
con.Open()
dr = cmd.ExecuteReader()
Dim settings As New XmlWriterSettings()
settings.Indent = True
Dim writer As XmlWriter = XmlWriter.Create(Server.MapPath("TestimonyDetail.xml"), settings)
...
Go to the complete details ...