thank you so much that helped me a log >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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
