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]
