Can I do this?

[thachp]

Can I do this? If not got altenate idea? I have a table with two columns. ftr_sampler is set as varchar(255). I want the script to search for similar keyword in the ftr_sampler.

sample table:
id ftr_sampler
- -----------
1 I like to eat apple.

<% if RS3("ftr_sampler") = "%apple%" Then %>
Id 1 like to eat apple.
<% else %>
Id 1 does not like to eat apple.
<% end if %>

[ark2]

str = "Id 1 does not like to eat apple."
if instr(RS3("ftr_sampler"),"%apple%") > 0 Then str = "Id 1 like to eat apple."
response.write str

[ark2]

probably more efficient would be


if instr(RS3("ftr_sampler"),"%apple%") > 0 Then response.write "Id 1 like to eat apple." else response.write "Id 1 does not like to eat apple."

[kajakske]

I believe you should drop the "%" signs when doing an instr() function.

the % is used directly in your Query with a LIKE clause ...

[teddarling]

Why not choose the ID's that like to eat apples and all others don't

set conn = CreateObject("ADODB.Connection")
conn.open "connection string"
set RS3 = conn.Execute("SELECT id FROM table_name WHERE ftr_sampler LIKE '%apple%'")
 
do while RS3.EOF
    "Id " & RS3("id") & "likes to eat apples" & vbcrlf
loop

This is certainly a better way to get what you want from the DB. Otherwise use instr as otherwise noted.

[Thing]

I believe you should drop the "%" signs when doing an instr() function.

the % is used directly in your Query with a LIKE clause ...

That's correct.