navigation  interaction  search

 other resources

Changeset 178

Show
Ignore:
Timestamp:
12/28/06 13:36:55
Author:
brieb
Message:

implements #16 - increase state field length.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/phpbms/modules/bms/clients_addedit.php

    r176 r178  
    219219                        <p class="csz"> 
    220220                                <label for="state">state/province</label><br /> 
    221                                 <input name="state" type="text" id="state" value="<?php echo htmlQuotes($therecord["state"])?>" size="2" maxlength="2" tabindex="16" /> 
     221                                <input name="state" type="text" id="state" value="<?php echo htmlQuotes($therecord["state"])?>" size="3" maxlength="5" tabindex="16" /> 
    222222                        </p> 
    223223                        <p> 
     
    247247                        <p class="csz"> 
    248248                                <label for="shiptostate">state/province</label><br /> 
    249                                 <input id="shiptostate" name="shiptostate" type="text" value="<?php echo htmlQuotes($therecord["shiptostate"])?>" size="2" maxlength="2" tabindex="22" />                              
     249                                <input id="shiptostate" name="shiptostate" type="text" value="<?php echo htmlQuotes($therecord["shiptostate"])?>" size="3" maxlength="5" tabindex="22" />                              
    250250                        </p> 
    251251                         
  • trunk/phpbms/modules/bms/install/updatev0.70.sql

    r177 r178  
    4343ALTER TABLE `clients` DROP `ccexpiration`; 
    4444ALTER TABLE `clients` FROP `displayname` 
     45ALTER TABLE `clients` ALTER COLUMN `state` `state` varchar(5) default NULL; 
     46ALTER TABLE `clients` ALTER COLUMN `shiptostate` `shiptostate` varchar(5) default NULL; 
     47ALTER TABLE `invoices` ALTER COLUMN `state` `state` varchar(5) default NULL; 
  • trunk/phpbms/modules/bms/invoices_addedit.php

    r176 r178  
    174174                        <p class="cszP"> 
    175175                                <label for="state">state/prov</label><br /> 
    176                                 <input name="state" type="text" id="state" value="<?php echo htmlQuotes($therecord["state"])?>" size="2" maxlength="2" tabindex=6 />                   
     176                                <input name="state" type="text" id="state" value="<?php echo htmlQuotes($therecord["state"])?>" size="3" maxlength="5" tabindex=6 />                   
    177177                        </p> 
    178178                        <p class="cszP"> 
Copyright © 2006-2007 Kreotek, LLC. All Rights reserved.