Problems using [item-field] (& SQL?)

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

******    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

-- 
Common sense is the collection of prejudices acquired by age eighteen.
                -- Albert Einstein



Database	aes_products	COLUMN_DEF	internal_code=X

  What exactly can the type of 'X' be?  Is this specific to Minivend?  Or
is this the SQL implimentation def?  I'm currently using mySQL, and have
my column defs using the types of mySQL.  Example:

Database        aes_products    COLUMN_DEF      "internal_code=INT UNSIGNED"
Database        aes_products    COLUMN_DEF      short_desc=TEXT
Database        aes_products    COLUMN_DEF      "list_price=DECIMAL(12,2)"
Database        aes_products    COLUMN_DEF      our_price=DECIMAL(12,2)

  As you can tell, I'm also not certain if I need to use double quotes or
not.  :)



-
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