Re: SOLVED! (& a suggestion) Problems using [item-field] (&SQL?)

[Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>]

******    message to minivend-users from Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>     ******


  Well, thankfully I solved my own problem.  :)  Since I wasn't using
'products' as my database, but instead 'aes_products' I had to set
ProductFiles.  Thank GOD for the list search on the minivend page!  (I
didn't see the ProductFiles tag in the initial catalog.cfg at all)

  Peace,
   -Nick "Just in case anyone has the same problem :)" Albright
  

On Mon, 5 Apr 1999, Nicholas Albright wrote:

> ******    message to minivend-users from Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>     ******
> 
> 
>   Hello!
> 
>     I'm having problems using the [item-field] in a [search-list] in the
> results.html page of a one click search.
> 
>   For my one click search I have something like:
> 
> [page scan mp=battery_profile] Batteries</A>
> 
>   With a battery profile of:
> 
> [set battery_profile]
> mv_search_field=category
> mv_searchspec=Batteries
> mv_searchtype=sql
> mv_search_page=prodtype
> mv_search_file=aes_products
> mv_sort_field=name
> mv_value=category_name=Batteries
> mv_matchlimit=4
> [/set]
> 
> -------
> 
>   On the results page I have something like:
> 
>               [search-list]
>                 [item_increment]
>                 [item-code]
>                 [item-field our_price]
>                 [item-field list_price]
>                 [item-field short_desc]
>                 [item-price]
>               [/search-list]
> 
>   [item_increment] [item-code] both work just fine.  All of the [item
> field X] tags result in nothing (ie, blank/no return), and [item-price]
> returns the wrong answer of '0.00'.
> 
>   Is this expected in an SQL one click search?  Or do I have other probs?
> I have all my COLUMN DEFS for the SQL shown below.
> 
>   Thanks for your time,
>    -Nick
> 
> 

-- 

"Anyone who can only think of one way to spell a word obviously 
lacks imagination."  

		-- Mark Twain



-
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