More On the Strange Problem

[Victor Subervi]

On Wed, Dec 23, 2009 at 2:21 PM, Victor Subervi <victorsubervi at gmail.com>wrote:

> I've isolated the problem in the print-out at the bottom of this post. It
> occurs when these values are passed:
>
> ['LastDatePrice', 'date', '10', 'yyyy/mm/dd', None],
>
> Since this is the first datetime that is passed, it would appear to be
> associated with such values, which are processed thus:
>
>     elif typeName == 'datetime':
>       print "<input type='text' width='%s' maxlength='%s' name='%s'
> value='%s' /> " \
>         "<i>This field takes a datetime up to %s alphanumeric characters
> inclusive.</i>" \
>         % (shortNum, str(typeNum), colName, theVal, str(typeNum))
>
> colName == 'LastDatePrice'
> typeNum = 10
>
>       elif 10 < int(typeNum) < 20:
>         shortNum = '10'
>
> Therefore...
> shortNum = '10'
>
>     if whatDo == 'insert':
>       theVal = defaultVal
>       val = defaultVal
>
> Since whatDo == 'insert'...
> and
> val = 'yyyy/mm/dd'
> therefore
> theVal = None
>
> Now, this value of None doesn't cause any problems with the other values
> printed out. This is the code:
>
>   print 'printTheForm: ', descrProds, '<br />'
>   for value in descrProds:
>     print 'value: ', value, '<br />'
>
> that produces this print-out:
>
> printTheForm: [['ID', 'tinyint', '5', '0', None], ['SKU', 'varchar', '40',
> '', None], ['Category', 'varchar', '40', '', None], ['Name', 'varchar',
> '50', '', None], ['Title', 'varchar', '100', '', None], ['Description',
> 'mediumtext', '100', '', None], ['Price', 'float', '8', '0.0', None],
> ['SortFactor', 'int', '4', '0', None], ['Availability', 'tinyint', '1', '0',
> '1'], ['OutOfStock', 'tinyint', '1', '0', '0'], ['ShipFlatFee', 'float',
> '5', '0.0', '0.00'], ['ShipPercentPrice', 'tinyint', '2', '0', '0'],
> ['ShipPercentWeight', 'tinyint', '2', '0', '0'], ['Associations', 'varchar',
> '40', '', None], ['TempPrice', 'tinyint', '1', '0', None], ['LastDatePrice',
> 'date', '10', 'yyyy/mm/dd', None], ['Weight', 'float', '7', '0.0', None],
> ['Metal', 'enum', ['14k gold', '18k gold', 'white gold', 'silver',
> 'tungsten', 'titanium'], '', None], ['PercentMetal', 'tinyint', '2', '0',
> None], ['colorsShadesNumbersShort', 'set', [''], '', None]]
> value: ['ID', 'tinyint', '5', '0', None]
> value: ['SKU', 'varchar', '40', '', None]
> value: ['Category', 'varchar', '40', '', None]
> value: ['Name', 'varchar', '50', '', None]
> value: ['Title', 'varchar', '100', '', None]
> value: ['Description', 'mediumtext', '100', '', None]
> value: ['Price', 'float', '8', '0.0', None]
> value: ['SortFactor', 'int', '4', '0', None]
> value: ['Availability', 'tinyint', '1', '0', '1']
> value: ['OutOfStock', 'tinyint', '1', '0', '0']
> value: ['ShipFlatFee', 'float', '5', '0.0', '0.00']
> value: ['ShipPercentPrice', 'tinyint', '2', '0', '0']
> value: ['ShipPercentWeight', 'tinyint', '2', '0', '0']
> value: ['Associations', 'varchar', '40', '', None]
> value: ['TempPrice', 'tinyint', '1', '0', None]
> value: ['LastDatePrice', 'date', '10', 'yyyy/mm/dd', None]
>
> If in fact the problem has to do with the None value, how can I easily
> substitute a different value? I tried:
>
> if theVal == None:
>   theVal = ''
>
> but that didn't capture it.
>

Update:
It's a date value (not datetime). I updated the database to default to the
value "2000-01-01" but that didn't help (gave the same print-out as above).


> TIA,
> beno
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20091223/31d43fab/attachment.html>