SQL searches

["heino" <saareh@cromwell-tools.co.uk>]

******    message to minivend-users from "heino" <saareh@cromwell-tools.co.uk>     ******

Dear all....

I'm trying again. I think I got in the way of a spam attack last time!

We've been using mvend for two years now, to allow users of our intranet to
query corporate material, phones etc. We are trying to use it now to
publish, again on our intranet, some of our publications. for this, I went
over to using an access database, using sql. After some time, I can now
return from this dbase with some measure of accuracy, using things like :

<FORM ACTION="[process-target main]" METHOD=POST>
    <INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
    <INPUT TYPE="hidden" NAME="mv_search_page" VALUE="results1.html">
    <INPUT TYPE="hidden" NAME="mv_orsearch" VALUE="or">
    <INPUT TYPE="hidden" NAME="mv_search_field"
VALUE="code,description,grade,app,steels,stainless,castirons,exotics,alum,no
nfer,op,grade">
     <INPUT TYPE="hidden" NAME="mv_unique" VALUE="true">
    <INPUT TYPE="hidden" NAME=mv_return_fields
VALUE="code,description,grade,app,steels,stainless,castirons,exotics,alum,no
nfer,op,grade">
    <INPUT TYPE="hidden" NAME="mv_column_op" VALUE="rm">
    <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
    <INPUT TYPE=text NAME="mv_searchspec" SIZE=20>
    <INPUT TYPE="submit" NAME="mv_doit" VALUE="Search">
</FORM>

gives good results, on a section of our tools handbook that deals with
cutting inserts for turning.

I get no results worth talking about with something like:

<FORM ACTION="[process-search]" METHOD=POST>
     <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
     <input TYPE=hidden NAME=mv_search_page VALUE="results1.html">
     <INPUT TYPE="hidden" NAME="mv_sql_query" VALUE="SELECT code FROM
products WHERE grade like '?' or description like '?'; ">
    <input type="text" name="mv_searchspec" size="20">
     <INPUT TYPE="submit" VALUE="SQL">
</FORM>


 though the input value does get passed through.

I reall want thogh, to be able to return results, on any part of a field:
i.e., if in my descritpion column i have the entry:

description
SGHN    1504AZN      AZN       CX90

and in my grade column i have:

grade
DX6

and in my application column i have:

application
Mill

and an engineer keys in :

mill AZN dx6

i want a return across the relevent row, or * from.

I've also tried using the mv_search_map stuff, and got the whole table or
database thrown back at me(i then found the messages in your archive - any
solutions yet?).

Using a products.asc file and a text search, i have no problems. everyones
pleased with the results. However, the fly in the ointment - we have in the
U.K. alone, 32 branches, with an even split of pc's and terminals. These
both show a marked increase in response times using an access DSN database
on our server, to the search of a huge text file in a products.asc. Does
anyone know what i'm talking about? I don't mind if you say no, least then i
can talk to someone! I won't bite, honest.

Thankyou for your patience....

heino

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list