Hello again,
I can output the example just fine.
I have imported a bunch of other tables to test this on our actual data.
What I am getting is either an error message or 0's in any field type other
than varchar(x) or char(x). Field types I am trying this on include
tinyint(3) and int(11).
One example - tbl_country.countryID is auto_increment, tinyint(3), not null
Using some of the functions and here are the results
ceil(countryID) result = 1
abs(countryID) result = 0
val(countryID) result = !ERR_F
countryID with Format="'%d'" result = 0
Using MySQL 3.23
simple query of "SELECT tbl_country.* FROM tbl_country"
Any thoughts? Think I am missing something pretty fundamental here.......
Andrew
|
