[ic] SQL with like

["Sergey Sheykin" <sheich@mosinfo.ru>]

Hi, List!

I have problems with SQL -searches, using "like" method.
For example, i use :

<FORM ACTION="[area search]">
Type: <INPUT TYPE=text NAME=mv_searchtype VALUE=sql>
      <INPUT TYPE=hidden NAME=mv_matchlimit VALUE=50>

Authors: <INPUT NAME="authors">
Title:   <INPUT NAME="title">
<input type=text NAME="mv_sql_query"
 VALUE="SELECT * FROM products WHERE authors like authors
                                 AND title like title" size=40>
<input type=submit value=search></form>

- This request is executed very longly, and sometimes generally is
interrupted!
But the same SQL through BDE is executed much fastly.

And, if I use "=" instead of "like" - all works fine.

I use DBI-1.14, DBD Oracle -1.06, Interchange 4.6.1, Perl 5.00503 and Oracle
8i.

Help, please!


_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users