This should do it for you. <cfoutput query="test"> <cfif position EQ 1> #CITY# #CODE# <cfelse> #CODE# #CITY# </cfif> </cfoutput>
On 6/27/07, alex poyaoan <[EMAIL PROTECTED]> wrote: > > HI everybody... need help on how to position the postal code on either > left or right of the city depending on the given value.. > have this table > > CITY CODE POSITION > CITYA 00100 1 > CITYB 10000 2 > > IF POSITION IS 1 THE CODE SHOULD BE ON THE RIGHT OF THE CITY > > <cfoutput query="test"> > #CITYA# #CODE# > </cfoutput> > > IF POSITION IS 1 THE CODE SHOULD BE ON THE LEFTOF THE CITY > > <cfoutput query="test"> > #CODE# #CITYB# > </cfoutput> > > is there a way of doing this dynamically.. > > THANKS.. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4