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.. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4