[ic] Replacing product group

[Barry Treahy, Jr.]

Philip S. Hempel wrote:

> I have about 500 items that need the prod_group changed, I know I
> could replace each by hand but I was wondering if anyone
> has created a script that could replace prod_group = "old_group" to
> prod_group = "new_group" or knows of someway that would be faster
> than doing each item one at a time.

Perhaps this is just a too simple suggestion, but with that few items in 
the products table, could one presume you are still using the GDBM 
database?  If so, why not just export it, vi the file and reimport it? 
 If there are only a couple edits, it would be rather fast...

Barry

-- 

Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO 

E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028