[ezRETS-users] boolean fields

Daniel Young dan at prowebassociates.com
Thu May 10 08:40:39 CDT 2007


 Is there a way to handle boolean fields? In the return I get from flexmls
I get the boolean fields listed as columns with a 1 or null (true or false).
Is there a way to query as to not get them as columns? The main reason
is because there are 335 of them. 
Example of how it is coming to me through ezrets.

Columns:
HEAT_Gas HEAT_Electric HEAT_Wood HEAT_Coal

Values
1 0 0 0 

Zeros represent null values.

I wish to query these and get the column name/s which are true "1"...
I'm putting these in mysql and I guess it will handle that # of columns
but I'm hoping there is a better way.

Thanks,

Dan Y

-- 
www.ProWebAssociates.com
Phone: 717 207 7125 ext 101





More information about the ezRETS-users mailing list