[mv] *** MiniVend SQL Concept ? - LIKE problem ***

[Marc Aubert <maubert@swisscenter.ch>]

Title: *** MiniVend SQL Concept ? - LIKE problem ***

Hello all,

Thank you Mike for your amazingly fast answer.

Is it possible use standard SQL parameters (*** such as LIKE ! ***) in the context of search.html (we are using your standard Interchange 4.6 final demo on RH 7.0) ?

<FORM ACTION="[area search]">

<INPUT TYPE=hidden NAME=mv_coordinate VALUE=1>

<INPUT TYPE=hidden NAME=mv_searchtype VALUE=db>

<INPUT TYPE=hidden NAME=mv_matchlimit VALUE=20>

<INPUT TYPE=hidden NAME=mv_sort_field VALUE=category>

<INPUT TYPE=hidden NAME=mv_search_field VALUE=inactive>

<INPUT TYPE=hidden NAME=mv_search_field VALUE=numarticle>

<INPUT TYPE=hidden NAME=mv_search_field VALUE=stock>

<INPUT TYPE=hidden NAME=mv_column_op VALUE=ne>

<INPUT TYPE=hidden NAME=mv_column_op VALUE=eq>

<INPUT TYPE=hidden NAME=mv_column_op VALUE=eq>

<INPUT TYPE=hidden NAME=mv_searchspec VALUE=1>

<INPUT MAXLENGTH=20 NAME=mv_searchspec type=text size=15>

<INPUT TYPE="radio" NAME="mv_searchspec" VALUE=1>

When we use the above lines, the SQL request is ok Š

Here what is produced on the pgSQL log file (only if we keep the mv_column_op to eq Š) :

SELECT * FROM products WHERE numarticle = 'somevalue' & stock = '1';

If we change the mv_column_op to whatever else, the SQL request (generated by Minivend to PGSQL) gets like Š 'SELECT * FROM products' Š which is awful for us as it slows down everything !!

How can we have Minivend transmit SQL queries to pgSQL with 'LIKE' for instance and not having them transformed by Minivend ?

MANY THANKS.

PM