[Rlib-users] Formatting / datatype issues

[Andrew C. <And...@So...>]

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