Thanks that did the trick...
> <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.. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
