Re: Database changes by Dec 24

From: Andrei Adamchik (aadamchi..obox.com)
Date: Fri Dec 21 2001 - 16:19:04 EST

  • Next message: Andrei Adamchik: "Re: Small portable database"

    Andriy, you are sending our Jamfo stuff to cayenne. Looks like you typed
    the wrong address by mistake. But thanks for the info anyways

    At 04:11 PM 12/21/2001 -0500, Andriy Shapochka wrote:
    >/*By Rich*/
    >UPDATE WB_ITEM_CLASS
    >SET CATEGORY_ID = NULL
    >WHERE CATEGORY_ID IN(SELECT CATEGORY_ID FROM WB_CATEGORY WHERE CATEGORY_NAME
    >= 'Other'
    >)
    >
    >DELETE WB_CATEGORY WHERE CATEGORY_NAME = 'Other'
    >/*By Dmitry*/
    >update WB_COMP_TYPE set OPEN_FOLDER_ICON =
    >'Images/icons/item_mediafolder_o.gif' where COMP_TYPE_ID = 9
    >
    >
    >Andriy.

    Andrei



    This archive was generated by hypermail 2.0.0 : Fri Dec 21 2001 - 16:18:47 EST