<OPTION VALUE="#PubCode#">#Right(pubcode,3)#</OPTION>
-----Original Message----- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 7: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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
