MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

Sql results page



Hey, i'm having a bit of a problem after conducting sql searches.

I'm using the following setup to do a simple search:

<form method=post action="[process-search]">
<input type=hidden name=mv_searchtype value="sql">
<input type=hidden name=mv_substring_match value="yes">
<input type=hidden name=mv_matchlimit value="10">
<input type=hidden name=mv_search_field value="cat">
Search
<input name=mv_searchspec value="">
<input type=submit value="Search">
</form>


When I enter a value and submit is pressed, everything works as expected.
The results page comes up, and reports that it has a match. (Assuming it
found something, otherwise it takes me to the not found page).

The problem is, I can't access any field data. I've tried a bunch of
variations on

[item-field cat]  to get the category string, and have tried just about
every field in the database with no luck.

What could I possibly be doing wrong?  Is the [item-field *] syntax legal on
the results of a sql search?

Nick



Search for: Match: Format: Sort by: