[ic] Construct to use options mechanism

Andreas, Scott interchange-users@interchange.redhat.com
Tue Oct 30 17:11:01 2001


what is needed to enable the construct demo to use the options mechanism.

I've created the options table with the required tables. 

under catalog.cfg I've added

CommonAdjust   pricing:price_group,q5,q10: ;:wholesale ;$, ==:options

the error output is...

>/cgi-bin/catalog/admin/item_option.html bad field o_modular in record
update, value=o_modular
>/cgi-bin/catalog/admin/item_option.html bad field o_master in record
update, value=o_master
>/cgi-bin/catalog/admin/item_option.html bad field o_enable in record
update, value=o_enable
>/cgi-bin/catalog/admin/item_option.html bad field o_matrix in record
update, value=o_matrix
>/cgi-bin/catalog/admin/item_option.html Safe: There is no column named
'o_modular' at >/usr/local/interchange/lib/Vend/Table/Common.pm line 232.
> 
> 
>         $id = $CGI->{item_id};
> 
>         my $db = $Db{$CGI->{mv_data_table}}
>                 or die "No options db?";
>         
>         $CGI->{ui_data_fields} = 'code products:description o_enable
o_matrix o_modular';
>         if($db->record_exists($id) and $db->field($id, 'o_modular')) {
>                 $CGI->{ui_data_fields} .= ' sku o_master';
>                 $CGI->{ui_options_modular} = 1;
>         }
>         return;
> 
> 
the foundataion demo works perfectly

& I've double checked the db all the colomn are there.


J. Scott Andreas :)
IS/Programmer/WebDevelopement
Learning Services, Inc.
e-mail: sandreas@learningservicesinc.com
phone: 1-800-877-9378 ext. 146
fax: (541) 744-2056

     |
     |__earning
       __
      (__	
       __)ervices

         |
         |ncorporated
       ---    __o
     ---   _-\<,_
      --- (_)/ (_)