SQL COLUMN_DEF Question

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

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


  Hello!

    I have a question about the COLUMN_DEF types that can be used.  When I
use column def in:

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.  :)

  I'm having probs in the results page of a one click search.  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'.

  So I figure I'm doing something wrong in my COLUMN_DEFs.  Does anyone
have any idea what I might be doing wrong/what I can do to correct this?

  Thanks for your time,
   -Nick

-- 
   The wise man can pick up a grain of sand and envision a
whole Universe.  But the stupid man will just lay down on
some seaweed and roll around until he's completely draped in
it.  Then he'll stand up and go, "Hey, I'm Vine Man."
		-- Jack Handey


-
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