setting variable in query

[Joey Martin]

I have a sql query that runs on my asp page.

select
contactname,contactnumber,contactnumber1,contactemail,address,city,state
,zip,type,sqft,0,bedrooms,baths,lotsize,acreage,garage,comments,price,0,
0,county from table1 where active='Y'

I need HASPHOTO to equal 1 if hasphoto <> 0 and HASPHOTO=0 when
hasphoto=0. Make sense? HASPHOTO usually equals a number, but in this
case, I want it to equal a 1 or 0 because I am exporting this to a CSV
file. I know how to do everything else, just not this part.

Thanks in advance.

 

[Bob Barrows [MVP]]

I have a sql query that runs on my asp page.

select
contactname,contactnumber,contactnumber1,contactemail,address,city,state
,zip,type,sqft,0,bedrooms,baths,lotsize,acreage,garage,comments,price,0,
0,county from table1 where active='Y'

I need HASPHOTO to equal 1 if hasphoto <> 0 and HASPHOTO=0 when
hasphoto=0. Make sense?

Not really. Is hasphoto a column in your table? What is its datatype?

HASPHOTO usually equals a number, but in this
case, I want it to equal a 1 or 0 because I am exporting this to a CSV
file. I know how to do everything else, just not this part.

Thanks in advance.

What database? Type and version, please.

Bob Barrows

 

[Joey Martin]

This is a SQL 2K server. HASPHOTOS is an int field. It is one of the
columns in my table.

 

[Bob Barrows [MVP]]

This is a SQL 2K server. HASPHOTOS is an int field. It is one of the
columns in my table.

SELECT ...,
CASE HASPHOTOS WHEN 0 THEN 0 ELSE 1 END [HASPHOTOS]
....

HTH,
Bob Barrows