Format Database results

[Mick]

I am using an Access database with a table field type selected as a Yes/No.
When the results using DIW are brought out to an asp the Yes/No shows as
"True" or "False". Can I make the asp show as "Yes" "No" Thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

http://groups.google.com/group/micr...q=format+yes+no&rnum=5&hl=en#97add9b2ecc0b450

or

http://www.outfront.net/spooky/advanced.htm#custom

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Mick]

Hi Kathleen, still struggling with this one Im afraid. This is the existing
SQL statement in the asp
SELECT * FROM hiremodels WHERE (adults >= ::adults:: AND children >=
::children:: AND suitcases >= ::suitcases:: AND golfer <= ::golfer:: AND
Auto <= ::Auto:: AND aircon <= ::aircon: ORDER BY pricestandardeuros ASC
So far so good except the aircon field shows "True" (same applies to the
fields "golfer" & "Auto")

Ive tried adding to the statement so if the car has aircon it shows "yes"
but I think my syntax is wrong.

SELECT * FROM hiremodels WHERE (adults >= ::adults:: AND children >=
::children:: AND suitcases >= ::suitcases:: AND golfer <= ::golfer:: AND
Auto <= ::Auto:: AND aircon <= ::aircon: iif(aircon = true, 'yes',
'no'),ORDER BY pricestandardeuros ASC

Can you help a little more please
Thanks Mick

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Mick:
Try this:

SELECT *,iif(aircon = true, 'yes', 'no') AS newaircon FROM hiremodels WHERE
(adults >= ::adults:: AND children >= ::children:: AND suitcases >=
::suitcases:: AND golfer <= ::golfer:: AND Auto <= ::Auto:: AND aircon <=
::aircon: ORDER BY pricestandardeuros ASC


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

 

[Mick]

Hi Kathleen, absolutely spot on first time, thank you so much for your time
and help. Kind regards Mick

 

[Kathleen Anderson]

Thanks for the feedback!

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others