Re: [mv] Sql results page

["Nick Pleis" <npleis@cei.net>]

Scratch that, turned out to be a problem with the database, a bit of a
internal miscommunication here:)

Nick


----- Original Message -----
From: "Nick Pleis" <npleis@cei.net>
To: <minivend-users@minivend.com>
Sent: Thursday, December 02, 1999 10:30 AM
Subject: [mv] Sql results page


> ******    message to minivend-users from "Nick Pleis" <npleis@cei.net>
******
>
> 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
>
> -
> 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
>