Re: sql/scan searches

[August Detlefsen <augustd@idiom.com>]

I've tried setting the mv_searchtype to 'db', and it works with some success, but if I search for an item that is only in the SQL and not in the .asc file, I get an error. 

Also, if I modify an item in the SQL, but not in the .asc, and then do a search for the new description, I get the proper item back, but the old description is displayed. Very weird. 

Could I be missing a setting somewhere? I have set following in catalog.cfg:
ProductFiles    stock
NoImport        stock

The search form looks like:
<FORM ACTION="[process-target main]" METHOD=POST>
<INPUT TYPE=text NAME="mv_searchspec" SIZE=20>
<INPUT TYPE="submit" VALUE="Search">
<INPUT TYPE="hidden" NAME="mv_doit"            VALUE="search">
<INPUT TYPE="hidden" NAME="mv_searchtype"      VALUE="db">
<INPUT TYPE="hidden" NAME="mv_search_file"     VALUE="stock">
<INPUT TYPE="hidden" NAME="mv_search_field"    VALUE="description">
<INPUT TYPE="hidden" NAME="mv_search_field"    VALUE="part">
<INPUT TYPE="hidden" NAME="mv_search_field"    VALUE="comment">
<INPUT TYPE="hidden" NAME="mv_search_field"    VALUE="category">
<INPUT TYPE="hidden" NAME="mv_orsearch"        VALUE="yes">
<INPUT TYPE="hidden" NAME="mv_case"            VALUE="no">
<INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
</FORM>

Any clues?
-August
--
mailto:augustd@idiom.com