[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