tSql = "SELECT DISTINCT(p.ship_status)
        FROM products AS p
        INNER JOIN  cart AS i
        ON i.product_id = p.id
        WHERE i.session_id = " & prepSQL(tConn, tSessionID);

p.ship_status is either a "1" or a "0", which is just how the database was
set up ages, ago.  I am moving these to enum() types as I go, but to change
this one, would break too much stuff.

I would like to toss in a condition to the select so it returns
"shipping_now" for "1" and "shipping_soon" for "2".  When I do this, I get
zero results returned.
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
<http://www.newgeo.com>                     Novato, CA U.S.A.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to