[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] how to NOT use products.txt
On 30 May 2001, Stefan Hornburg (Racke) wrote:
> Corey Gilmore <cfg@dln.uvm.edu> writes:
>
> > I am going crazy here. IMO, using products.txt seems like a horrible
> > idea, since I have a mysql database. Say for instance, the first line
> > of my 'products.txt' file looked like
> >
> > sku desc icon image
> >
> > And i wanted to add a field 'small_icon' between icon and image.
> >
> > How would I do this (easily)? What I want to do is ditch products.txt so
> > that I can just use mysql, and do
> > alter table products add small_icon varchar(64) after icon;
> > to add a new field.
> >
> > What I can't do, is get interchange to recognize this.
> >
> > in catalog.cfg i did
> > NoImport products
> >
> > I added the appropriate
> > Database products COLUMN_DEF "small_icon=VARCHAR(64)"
> > in products.mysql
> >
> > And I changed
> > Database products products.txt __SQLDSN__
> > to
> > Database products products.mysql __SQLDSN__
> >
> > in products.mysql
> >
> > I restarted interchange, and all seemed well. BUT, my new column was
> > still not showing up when I edit a product.
>
> This may have another cause. Can you access the column with
> [item-field small_icon] ?
>
Nope. No errors in error.log either.
