Results 1 to 2 of 2

SYNTEX SQL PROBLEMS HELP!

This is a discussion on SYNTEX SQL PROBLEMS HELP! within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; Trying to install Min Order Qty Per Product and the sql file doesn't work and I ready don't know much ...

      
  1. #1
    Member
    Join Date
    Sep 2004
    Location
    Langhorne, PA
    Posts
    31
    Rep Power
    0


    Default SYNTEX SQL PROBLEMS HELP!

    Trying to install Min Order Qty Per Product and the sql file doesn't work and I ready don't know much about it any help would be appricated!!! javascript:emoticon('')
    Sad


    Code:
    ALTER TABLE 'products' ADD 'INT' ( 64 ) DEFAULT '1' NOT NULL ;
    INSERT INTO configuration ( configuration_id , configuration_title , configuration_key , configuration_value , configuration_description , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function )
    VALUES (
    '', 'Display Product Min Order Qty', 'PRODUCT_LIST_MIN_ORDER_QTY', '49', 'Do you want to display the Product Min. Order Quantity?', '8', '10', NULL , NULL , NULL , NULL );
    INSERT INTO configuration ( configuration_id , configuration_title , configuration_key , configuration_value , configuration_description , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function )
    VALUES (
    '', 'Mark product under minimum order quantity', 'MARK_PRODUCT_UNDER_MIN_ORDER_QTY', '*', 'Display something on screen so customer can see which product has insufficient order quantity', '9', 6 , NULL , NOW( ) , NULL , NULL
    );

  2. #2
    Active Member
    Join Date
    May 2003
    Posts
    148
    Rep Power
    0


    Default RE: SYNTEX SQL PROBLEMS HELP!

    can u post the sql error that you are getting?

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •