Re: help on dynamic position of fields in cfoutput for postal code

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

Re: How to architect question: custom fields

I can tell you what we have done when faced with a similar problem, maybe it will help you out. We create a table that holds the question, client id, and field type (select, numeric, text, etc.). There is another table that will store the values if a field is select type, we call this the lookup