IF Statement

dalezjc · November 5th, 2010, 09:20 AM

Okay, I'm doing something really stupid, and can't figure it out. I'm trying to write a simple IF statement in the following context:

Code:

 
  <td><font face="Verdana" size=1>
   <%
   if rsqdb("KPName") like '%cpu%' then
      response.write rsqdb("CPU")
      else
      response.write rsqdb("KPName")
      end if
      %>
  </td>

I keep getting a syntax error.

Old Pedant · November 5th, 2010, 02:35 PM

LIKE is a function ONLY available in SQL coding.

Code:

If InStr( 1, rsqdb("KPName", "cpu", vbTextCompare )  > 0 Then

But even better might be to do this in the SQL query. Would have to see the query to know.