Perhaps, this?
<SELECT NAME="PJ">
<CFOUTPUT QUERY="searchp">
<OPTION VALUE="#PubCode#">#right(pubcode, 3)#</OPTION>
</CFOUTPUT>
</SELECT>
-----Original Message-----
From: alex poyaoan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 27, 2007 8:44 AM
To: CF-Talk
Subject: getting a part of a field
Hi everybody
need help on this.. i have this code
<SELECT NAME="PJ">
<CFOUTPUT QUERY="searchp">
<OPTION VALUE="#PubCode#">#pubcode#</OPTION>
</CFOUTPUT>
</SELECT>
it gets iits value on a field on a database which has this format 200603092
what i need to show to user is the last three digits is is 092 BUT THE VALUE
MUST REMAIN THE SAME.. i couldn't figure out how to do that.. any help
please
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273827
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
