Re: [mv] Debugging SQL Searches

[kswisher@iolinc.net (Swisher, Karl)]

Try checking the MiniVend docs.  Also find the section "Setting SQL tables
with a form".  I don't remember  if the one I printed out was from the docs or
the mailing list archieve.   I believe you need to set up more parameters in
the form but you may not need all the ones I have below.  Here is some code that
works for me.

<INPUT TYPE=text NAME="mv_searchspec" SIZE=20>
Key search word

<INPUT TYPE="submit" VALUE="[L]Search[/L]"><BR>
The button

<INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
Tell it to do an SQL search

<INPUT TYPE="hidden" NAME="mv_search_file" VALUE="jtbmlinks_tbl"> 
Tell it the name of the database to search

<INPUT TYPE="hidden" NAME="mv_return_field" VALUE='linkno'>              
The name of the field you want to return.  I believe you can add more of these
lines for multiple returns.

<INPUT TYPE="hidden" NAME="mv_search_page" VALUE='results2.html'>
The page you want to display the results on.

<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="place">
Field to search on.  May have multiples of this line for multiple column
searches.

Thanks
Karl

On Mon, 06 Dec 1999, you wrote:
> ******    message to minivend-users from AGRE Enterprises Limited <agree@godzone.net.nz>     ******
> 
> Hi,
> 
> Im definitely a newbie with minivend and have been struggling to get
> it setup for several weeks. I have found it a pretty steep learning
> curve but recognise its potential and am hanging in there :-)
> 
> I have my products table in an postgres database and most things seem
> to be working OK so far but I can not get anything out of a keyword
> search at all.  miniVend seems to be a bit of a black box.  I can not
> work out how to get it to tell me what its doing so I can debug things.
> 
> The form is basically the one from 'simple'. I have tried various
> things but at the moment,
> 
>             <input type="hidden" NAME="mv_column_op" VALUE="like">
> 
> and
>              <input type="hidden" name="mv_searchtype" value="sql">
>  
> I get nothing back.  How can I see what the SQL query is that minivend
> constructed ?
> 
> -- 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Glen Eustace, on behalf of
> GodZone Internet Services, a division of AGRE Enterprises Limited
> P.O. Box 8020, Palmerston North, New Zealand
> Ph: +64 6 356 2562, Fax: +64 6 357 0271
> http://www.godzone.net.nz, EMail: agree@godzone.net.nz, ICQ: 10397208
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> -
> 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