Won't accept SQL LIKE

[Stegmite]

I'm trying to filter a datagrid on the fly using this:

On Page Load...
Dim mySort As String
If Session("Sort") = "" Then
  mySort = "SELECT * FROM Import"
  OleDbDataAdapter1.SelectCommand = New OleDb.OleDbCommand(mySort, OleDbConnection1)
  OleDbDataAdapter1.Fill(dsInv)
  dgInv.DataBind()
Else
  mySort = Session("Sort")
  OleDbDataAdapter1.SelectCommand = New OleDb.OleDbCommand(mySort, OleDbConnection1)
  OleDbDataAdapter1.Fill(dsInv)
  dgInv.DataBind()
End If

and

On cmdSearch.Click...
Dim vCrit As String = txtCriteria.Text
If cmbCols.SelectedValue = "Description" Then
   If vCrit = "" Then
      Session("Sort") = "SELECT * FROM Import ORDER BY Description"
   Else
      Session("Sort") = "SELECT * FROM Import WHERE Description LIKE '" & vCrit & "' ORDER BY Description"
   End If
End If
Session("Crit") = vCrit
Response.Redirect("inventory.aspx")

However, the LIKE command won't work like it should. Is there anything I can do to make this work?

 

[pzmgmb]

Because your LIKE statement should look more like this:

WHERE (Description LIKE N'%" & vcrit & "%')

 

[ThatRickGuy]

I think that 'N' might be a type-o? should be just "LIKE '%" & vcrit & "%'"

-Rick

----------------------

http://www.ringdev.com

 

[bassguy]

The N is MSSQL NChar or NText modifier in your code you should not need it

bassguy

 

[ThatRickGuy]

woh, learnt sumpin new!

-Rick

----------------------

http://www.ringdev.com

 

[chiph]

Yup. Use the N prefix only when the columns you're comparing against are NCHAR, NVARCHAR, or NTEXT.

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first