| Issue 39: | Null value retrieval causes erroneous "Unknown column" error? | |
| 1 person starred this issue and may be notified of changes. | Back to list |
SQL: SELECT a.id, a.date_closed FROM dropship_item AS a,dropship_product AS c,items AS b WHERE (c.vendor_sku = 'headphones' AND c.vendor_id = 1088) AND a.dropship_product_id = c.id AND b.order_id = 2083060 AND a.order_item_id = b.item_id AND a.status IN (252,253,249,255,15); Results from MySQL command line: +----+-------------+ | id | date_closed | +----+-------------+ | 21 | NULL | +----+-------------+ Results from DBR: DBD::mysql::db do failed: Unknown column 'a.date_closed' in 'field list' at /usr/lib/perl5/site_perl/5.8.8/DBR/Misc/Connection.pm line 32.
Apr 15, 2010
#1
daniel.d...@gmail.com
Status:
NeedRT
Jun 17, 2010
(No comment was entered for this change.)
Labels:
-Priority-High Priority-Medium
Oct 12, 2010
*poke* Any update on this issue ollie? |