I've got a problem with sec_to_time(3603) --> "01:00:03". It doesn't
return in witango, even though it works from the console.
On the other hand sec_to_time(3603)+0 --> 10003 does return a result.
It looks like witango doesn't like the quotes around the result or
maybe the colons. I was hoping to let the database handle the
formatting, but it looks like I'll have to do this in witango. Dang!
I haven't found any bug reports on this for unixODBC. I'm running
# rpm -q unixODBC
unixODBC-2.2.11-3.FC4.1
*********** TEST CASE ******************
This works from the console:
mysql> SELECT id, timestamp, prefix, code, title, price, shipping,
length, length_units, sec_to_time(length) AS TRT, format, public,
buy_now_params FROM SKU WHERE id = 1;
+----+---------------------+--------+------+--------------------
+-------+----------+--------+--------------+----------+--------
+--------+----------------+
| id | timestamp | prefix | code | title |
price | shipping | length | length_units | TRT | format | public
| buy_now_params |
+----+---------------------+--------+------+--------------------
+-------+----------+--------+--------------+----------+--------
+--------+----------------+
| 1 | 0000-00-00 00:00:00 | ISBN | 123 | Why Are We Silent/ |
19.95 | 3.00 | 3603 | seconds | 01:00:03 | DVD | public
| NULL |
+----+---------------------+--------+------+--------------------
+-------+----------+--------+--------------+----------+--------
+--------+----------------+
1 row in set (0.00 sec)
But within witango 5.0.1.065, heres the debug:
[Direct DBMS Action] [229] update_form
[Query] [229] SELECT id, timestamp, prefix, code, title, price,
shipping, length, length_units, sec_to_time(length) AS TRT, format,
public, buy_now_params FROM SKU WHERE id = 1
[ActionResults] [230] 1 ISBN 123 Why Are We Silent/ 19.95 3.00 3603
seconds DVD public
Bill
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
