<cfoutput query="test"> <cfif position is "1"> #CITY# #CODE# <cfelse> #CODE# #CITY# </cfif> </cfoutput>
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:15 AM To: CF-Talk Subject: help on dynamic position of fields in cfoutput for postal code 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.. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:282373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4