[Zope-dev] ZSQL Methods

25 May 2000

      Using ZSQLMethods against an ORACLE 8.0.6 Database.

I have two tables, each with a NUMBER(6) key field.

If I create a method which selects against each of the tables
then method returns an integer (e.g. 5040), as expected.

select index_number
from names
where name = 'name'

or 

select index_number
from aliases 
where alias = 'name'

If I attempt to get the combined list

select index_number
from names
where name = 'name'
union 
select index_number
from aliases 
where alias = 'name'

I get a float back (e.g. 5040.0).

Is this expected/correct? If so how do I force it to return the integer. 

David Cooper
dcooper@nosc.mil