Displaying and translating codes

[James_PT]

Here is an easy question for someone. I am storing code values ("Y", "N"), in a Mysql database column and when I display the field in Dreamweaver, I would like to have it appear as "Yes", or "No", not just the letter, as the case warrants. The only way I see doing this is with a menu or list but that builds a select drop down list box and I want display only, no entry. Surely there is an easy way to do this that is simply eluding me.

Any thoughts??

[Newsgroup_User]

<?php echo (fieldvalue) == 'Y'?'Yes":"No"; ?>

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"DreamerJim" <webforumsuser@macromedia.com> wrote in message
news:fsopk9$knv$1@forums.macromedia.com...
> Here is an easy question for someone. I am storing code values ("Y",
> "N"), in
> a Mysql database column and when I display the field in Dreamweaver, I
> would
> like to have it appear as "Yes", or "No", not just the letter, as the case
> warrants. The only way I see doing this is with a menu or list but that
> builds
> a select drop down list box and I want display only, no entry. Surely
> there is
> an easy way to do this that is simply eluding me.
>
> Any thoughts??
>

[Newsgroup_User · Accepted solution]

Murray *ACE* wrote:
> <?php echo (fieldvalue) == 'Y'?'Yes":"No"; ?>

You've got your quotes badly mixed up.

<?php echo (fieldvalue) == 'Y'?'Yes':'No'; ?>

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

Thanks. Not so bad - only one was improperly noted. Out of the 6 in that
snippet, that's only a 16% deduction. Nevermind that it breaks everything.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"David Powers" <david@example.com> wrote in message
news:fsp09r$rj6$1@forums.macromedia.com...
> Murray *ACE* wrote:
>> <?php echo (fieldvalue) == 'Y'?'Yes":"No"; ?>
>
> You've got your quotes badly mixed up.
>
> <?php echo (fieldvalue) == 'Y'?'Yes':'No'; ?>
>
> --
> David Powers, Adobe Community Expert
> Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
> Author, "PHP Solutions" (friends of ED)
> http://foundationphp.com/

[Newsgroup_User]

.oO(DreamerJim)

>Here is an easy question for someone. I am storing code values ("Y", "N"), in
>a Mysql database column and when I display the field in Dreamweaver, I would
>like to have it appear as "Yes", or "No", not just the letter, as the case
>warrants. The only way I see doing this is with a menu or list but that builds
>a select drop down list box and I want display only, no entry. Surely there is
>an easy way to do this that is simply eluding me.

Besides the given PHP solution, you could also let the database do it:

SELECT
CASE yourField = 'Y'
THEN 'Yes'
ELSE 'No'
END AS choice,
...
FROM yourTable
WHERE ...

Micha

[Newsgroup_User]

Micha:

That is an interesting alternative.

> SELECT
> CASE yourField = 'Y'
> THEN 'Yes'
> ELSE 'No'
> END AS choice,

is 'choice' the returned variable that would contain the values of "Yes" or
"No"?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Michael Fesser" <netizen@gmx.de> wrote in message
news:gji1v3hpequ4i525osthr4ek0ua2klq10h@4ax.com...
> .oO(DreamerJim)
>
>>Here is an easy question for someone. I am storing code values ("Y",
>>"N"), in
>>a Mysql database column and when I display the field in Dreamweaver, I
>>would
>>like to have it appear as "Yes", or "No", not just the letter, as the case
>>warrants. The only way I see doing this is with a menu or list but that
>>builds
>>a select drop down list box and I want display only, no entry. Surely
>>there is
>>an easy way to do this that is simply eluding me.
>
> Besides the given PHP solution, you could also let the database do it:
>
> SELECT
> CASE yourField = 'Y'
> THEN 'Yes'
> ELSE 'No'
> END AS choice,
> ...
> FROM yourTable
> WHERE ...
>
> Micha

[Newsgroup_User]

.oO(Murray *ACE*)

>That is an interesting alternative.
>
>> SELECT
>> CASE yourField = 'Y'
>> THEN 'Yes'
>> ELSE 'No'
>> END AS choice,
>
>is 'choice' the returned variable that would contain the values of "Yes" or
>"No"?

Yes, it's an alias name. If you use such statements in the SELECT you
should always give them an alias name (AS ...), otherwise the entire
statement would become the name of that field in the result set.

The CASE statement is a very powerful construct, not only in SELECTs.
It can also be used in an ORDER BY clause for example to create very
sophisticated sorting rules.

Micha

[Newsgroup_User]

Thanks, Micha. I am looking into the use of this....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Michael Fesser" <netizen@gmx.de> wrote in message
news:h7q1v3lcb9i0qh7qirb523kd90uds7mrk9@4ax.com...
> .oO(Murray *ACE*)
>
>>That is an interesting alternative.
>>
>>> SELECT
>>> CASE yourField = 'Y'
>>> THEN 'Yes'
>>> ELSE 'No'
>>> END AS choice,
>>
>>is 'choice' the returned variable that would contain the values of "Yes"
>>or
>>"No"?
>
> Yes, it's an alias name. If you use such statements in the SELECT you
> should always give them an alias name (AS ...), otherwise the entire
> statement would become the name of that field in the result set.
>
> The CASE statement is a very powerful construct, not only in SELECTs.
> It can also be used in an ORDER BY clause for example to create very
> sophisticated sorting rules.
>
> Micha

[Newsgroup_User]

.oO(Michael Fesser)

>SELECT
> CASE yourField = 'Y'
> THEN 'Yes'
> ELSE 'No'
> END AS choice,
> ...

Little syntax error - it should be

SELECT
CASE WHEN yourField = 'Y'
THEN 'Yes'
ELSE 'No'
END AS choice,
...

Micha

[James_PT]

Where would this be placed within the standard SELECT clause? e.g.,
SELECT * from custtable
WHERE custid=varname;

[Newsgroup_User]

Murray *ACE* wrote:
> Thanks, Micha. I am looking into the use of this....
>

Its well worth it Murray, I now use them all the time, its really powerful.

[Newsgroup_User]

Seems that way - especially with Micha's correction! 8)

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Dooza" <doozadooza@gmail.com> wrote in message
news:fsqrq1$38s$1@forums.macromedia.com...
> Murray *ACE* wrote:
>> Thanks, Micha. I am looking into the use of this....
>>
>
> Its well worth it Murray, I now use them all the time, its really
> powerful.