Re: [mv] Getting flypage to recognize item codes?

[Eric Paul <epaul@spellbook.net>]

I'm not running SQL, but I *think* from reading the docs that you want to 
kill all references to products.asc from your catalog.cfg file.  Otherwise 
you'll be using both databases and it will get REALLY confusing.

Eric

At 06:22 PM 12/16/99 , Christopher P. Lindsey wrote:
> > I'll take a quick stab because I made this mistake too :P
>
>It's good to know that I'm not alone...  :)
>
> > Are you editing the products.asc file in /home/minivend or the one in the
> > directory you installed your catalog to (usually ~/catalogs/simple)
> >
> > The correct one is the one in the installed dir (~/catalogs/simple/)  You
> > can spend all day changing the one in /home/minivend and get nowhere.  The
> > other thing to check is the ownership and permissions of your products.asc
> > file.  If  none of those are it, drop me another line and I'll see if I 
> can
> > help ya.
>
>This is something I'm confused about.  Is products.asc still needed for
>SQL-based databases?  I know that the database definition has products.asc
>specified (
>
>    Database   products   products.asc  dbi:mysql:nursery:mysql:3306
>    .. (some stuff deleted)
>    Database   products   COLUMN_DEF    code=char(10) PRIMARY KEY
>    Database   products   COLUMN_DEF    price=float, discount=float
>    Database   products   NUMERIC       price=float, discount
>
>), but why?  Or do I also have to keep a local ASCII copy of the database
>(this seems wrong to me, as the usefulness of SQL interfaces seems to
>be lost).  The database already exists from other applications, so I
>don't want products.asc to do any kind of importing.
>
>Am I way off-base?  Is products.asc needed?
>
>Confused Chris

---
Eric Paul
SpellBook Systems
http://www.spellbook.net