[ic] how to NOT use products.txt

Dan B interchange-users@lists.akopia.com
Wed May 30 23:15:01 2001


At 09:12 PM 5/30/2001 -0400, you wrote:

[snip products.txt]

>I do have a products/products.sql...
>
>$ cat dbconf/products.mysql
># MiniVend database definition
>Database  products  products.txt __SQLDSN__
>#ifdef SQLUSER
>Database  products  USER         __SQLUSER__
>#endif
>#ifdef SQLPASS
>Database  products  PASS         __SQLPASS__
>#endif
>Database  products  KEY          sku
>Database  products  COLUMN_DEF   "sku=char(14) NOT NULL PRIMARY KEY"
>Database  products  COLUMN_DEF   "description=VARCHAR(128) NOT NULL"
>Database  products  COLUMN_DEF   "title=VARCHAR(128) DEFAULT '' NOT NULL, 
>index(title)"
>Database  products  COLUMN_DEF   "template_page=VARCHAR(64)"
>Database  products  COLUMN_DEF   "comment=TEXT"
>Database  products  COLUMN_DEF   "display=VARCHAR(128)"
>Database  products  COLUMN_DEF   "image=VARCHAR(64)"
>Database  products  COLUMN_DEF   "icon=VARCHAR(64)"
>Database  products  COLUMN_DEF   "div_icon=VARCHAR(64)"
>Database  products  COLUMN_DEF   "price=DECIMAL(12,2) NOT NULL, index(price)"
>Database  products  COLUMN_DEF   "category=VARCHAR(64) NOT NULL, 
>index(category)"
>Database  products  COLUMN_DEF   "nontaxable=CHAR(3)"
>Database  products  COLUMN_DEF   "weight=VARCHAR(12) DEFAULT '0' NOT NULL"
>Database  products  COLUMN_DEF   "size=VARCHAR(96)"
>Database  products  COLUMN_DEF   "color=VARCHAR(96)"
>Database  products  COLUMN_DEF   "related=text"
>Database  products  COLUMN_DEF   "featured=VARCHAR(32)"
>Database  products  COLUMN_DEF   "type=VARCHAR(64), index(type)"
>Database  products  NUMERIC      price
>
>mysql> desc products;
>+-------------+---------------+------+-----+---------+-------+
>| Field       | Type          | Null | Key | Default | Extra |
>+-------------+---------------+------+-----+---------+-------+
>| sku         | varchar(14)   |      | PRI |         |       |
>| description | varchar(128)  |      |     |         |       |
>| comment     | text          | YES  |     | NULL    |       |
>| display     | varchar(64)   | YES  |     | NULL    |       |
>| image       | varchar(64)   | YES  |     | NULL    |       |
>| icon        | varchar(64)   | YES  |     | NULL    |       |
>| div_icon    | varchar(64)   | YES  |     | NULL    |       |
>| price       | decimal(12,2) |      | MUL | 0.00    |       |
>| category    | varchar(64)   |      | MUL |         |       |
>| nontaxable  | char(3)       | YES  |     | NULL    |       |
>| weight      | decimal(12,4) | YES  |     | NULL    |       |
>| related     | varchar(64)   | YES  |     | NULL    |       |
>| featured    | varchar(64)   | YES  |     | NULL    |       |
>| inactive    | char(3)       | YES  |     | NULL    |       |
>| flypage     | varchar(64)   | YES  |     | NULL    |       |
>| required    | varchar(64)   | YES  |     | NULL    |       |
>| type        | varchar(64)   | YES  | MUL | NULL    |       |
>+-------------+---------------+------+-----+---------+-------+
>17 rows in set (0.00 sec)
>
>baffled,
>.cfg

Everything looks OK, AFAICS...

#diff products.mysql products.new.mysql
 > Database  products  COLUMN_DEF   "icon=VARCHAR(64)"
 > Database  products  COLUMN_DEF   "div_icon=VARCHAR(64)"
23d24
< Database  products  COLUMN_DEF   "gift_cert=VARCHAR(3)"
25a27
 > Database  products  COLUMN_DEF   "type=VARCHAR(64), index(type)"

4 changes to .mysql, all of which match up with your mysql table, hmm.

What is the output of bin/interchange -r?

And you can't access the data from within an item-list (like results.html 
or flypage.html)?

[item-list]
         [item-field icon]
[/item-list]

You're almost there...

Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com