WHERE (not Santa) clause question..

[Ooogaleee]

This block of code is executing perfectly without the WHERE clause inserted at the end of the dim statement; yet when it's there, the datagrid doesn't fill in and appear. Any ideas?

Thanks much....Troy




Private Sub btnGI_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnGI.Click

Select Case ddlF002.SelectedIndex()
Case 0
Dim myQuery As String = "SELECT * FROM [tbl * F002 > 4 J] WHERE MUFLID =" & Chr(39) & ddlWho.SelectedItem.Text & Chr(39)
OleDbConnection1.Open()
Dim cmd As New OleDb.OleDbCommand()
cmd.Connection = OleDbConnection1
cmd.CommandText = myQuery
Dim datareader As OleDb.OleDbDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
dgF002.DataSource = datareader
dgF002.DataBind()
Case 1
'another SQL statement w/ a WHERE clause
Case 2
'another SQL statement w/ a WHERE clause
Case 3
'another SQL statement w/ a WHERE clause
End Select

End Sub

[Cander]

Wouldnt it be assumable that the where clause is looking for a value that doesnt exist in the db?

[Ooogaleee]

Cander -

Yeah, it's possible. But is my syntax with the "Chr(39)" 's correct as far as you can see?

[sunburnt]

if you want a quotation mark (") thats Char(34) :-D

[Frans C]

Chr(39) is the single quote (').
You only need this if the MUFLID is of type text. If MUFLID is numeric, you should omit the chr(39)

BTW, you could have just typed the quotes.
"SELECT * FROM [tbl * F002 > 4 J] WHERE MUFLID = '" & ddlWho.SelectedItem.Text & "'"

Also make sure ddlWho.SelectedItem.Text doesn't contain single quotes!, if it does, you need to replace every single quote with two single quotes.