<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>A question about LIKE</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">I have a need of obtaining results from a query similar to this:</FONT>
<BR><FONT SIZE=2 FACE="Arial"> select * from Tickets where Subject like '%car%' or Subject like '%color%'</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">When I browse through the routines ProcessSearchQuery in Web.pm and</FONT>
<BR><FONT SIZE=2 FACE="Arial">_ProcessRestrictions in Tickets.pm, I assume that to get the desired results,</FONT>
<BR><FONT SIZE=2 FACE="Arial">it is as simple as changing ENTRYAGGREGATOR from AND to OR when </FONT>
<BR><FONT SIZE=2 FACE="Arial">the restriction OPERATOR equals 'LIKE'. That did not happen.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Did anyone have experience coping with issue?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">By the way, I found some possible code issues as follows:</FONT>
<BR><FONT SIZE=2 FACE="Arial">(1) in Tickets.pm, the definition of the associate array %TYPES,</FONT>
<BR><FONT SIZE=2 FACE="Arial"> 'Type' should not appear twice</FONT>
<BR><FONT SIZE=2 FACE="Arial">(2) in the same declaration, it seems 'Status' should be 'STRING' instead</FONT>
<BR><FONT SIZE=2 FACE="Arial"> of 'ENUM'</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks.</FONT>
</P>
<P><B><FONT COLOR="#000080" SIZE=2 FACE="MS Sans Serif">Chunyen Liu</FONT></B>
<BR><B><FONT COLOR="#000080" SIZE=2 FACE="MS Sans Serif">chunyen.liu@garmin.com</FONT></B>
<BR><B><FONT COLOR="#000080" SIZE=2 FACE="MS Sans Serif">(913) 3978448 ext 1594</FONT></B>
</P>
<P><FONT COLOR="#000080" SIZE=2 FACE="Terminal">______________________________________________________</FONT>
<BR><FONT COLOR="#000000" SIZE=1 FACE="MS Sans Serif">CONFIDENTIALITY NOTE</FONT>
<BR><FONT COLOR="#000000" SIZE=1 FACE="MS Sans Serif">This email and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies</FONT><FONT COLOR="#FF0000" SIZE=1 FACE="MS Sans Serif">.</FONT> <FONT COLOR="#000000" SIZE=1 FACE="MS Sans Serif">Thank you for your cooperation</FONT></P>
<BR>
</BODY>
</HTML>