ODBiC Discussion Board

Not sure how to ask- Multiple SELECT

by John Kincaid, November 5, 2007 20:33

I have a database of properties that has about 20 columns of features such as Fireplace, CaTV, Washer/Dryer that I want to output only those features that equal 1 or yes depending on if that property has that amenity.

For instance, I am SELECTing a row such as:

SELECT FP,WD,CATV or *)FROM Features WHERE pid=$pid$ not sure what else to use here

The results I want are to output "only" those column names that are equal to "1". One means the property has a fireplace, etc. If the property has "no Fireplace, then don't output

Kind of stumped here.



Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.