Need Help for Search

[driff]

im having problem, with my searchform theres always an error,

[CODE=vb]If cmbcourse.Text = "" Or txtfind = "" Then
Adodc1.Recordse t.Filter = ""
Adodc1.Refresh
Exit Sub
End If
Adodc1.Recordse t.Filter = cmbcourse & " LIKE '*" & txtfind & "*'" this parts always bring error
End Sub[/CODE]

[creative1]

try this

Adodc1.Recordse t.Filter = cmbcourse & " LIKE '" & txtfind & "%'"

instead of this

[daniel aristidou]

try this

Adodc1.Recordse t.Filter = cmbcourse & " LIKE '" & txtfind & "%'"

instead of this

I experienced similar problems and kinda gave up......
What does % do?

[lotus18]

try this
[code=vb]
Adodc1.Recordse t.Filter = cmbcourse & " LIKE '" & txtfind & "%'"
[/code]
instead of this

Hi Daniel

% is a wildcard character in string comparison (sql). You can also try this code

[code=vb]
Adodc1.Recordse t.Filter = cmbcourse & " LIKE '%" & txtfind & "%'"
[/code]


Rey Sean

[daniel aristidou]

Hi Daniel

% is a wildcard character in string comparison (sql). You can also try this code

[code=vb]
Adodc1.Recordse t.Filter = cmbcourse & " LIKE '%" & txtfind & "%'"
[/code]


Rey Sean

My problem is that im searching the primary key. which is in the format of int32... i convert my string in the seach textbox but still get an error message invalid comparison (or something like that) System.string & system.int32

[Killer42]

So, either cmbcourse or txtfind is returning an integer, from the sound of it.

[daniel aristidou]

So, either cmbcourse or txtfind is returning an integer, from the sound of it.

Thats what i dont get...... the dat column is in the form of int32 and
im converting my textbox string in to int32 and im still getting the same result

[debasisdas]

If searching on the primary key field why to use LIKE search .

[daniel aristidou]

Well i was using like because of column searched changes with the change of selection of a combo box.......il try using = i supose...but i means putting in a case.........or if

[debasisdas]

My problem is that im searching the primary key. which is in the format of int32...

since searching on PK of int type .there is no use of LIKE at all.

[Killer42]

I think we need more detail here on cmbcourse, txtfind, the database fields being identified in cmbcourse, and basically, what the heck you are trying to put into Filter, which is a string.

[daniel aristidou]

Fixed it ............tha nks for the tips

[Killer42]

Fixed it ............tha nks for the tips

Cool. Glad you got it sorted.