>>You only asked for syntax. Coding with such syntactic sugar to eliminate the redundancies will IMO still be a patch - the code is the equivalent to recurring fields in a record before normalization. So create a record/object for each index to clean up and hang those objects into a list, dict or even easier an array with index as index. So now you have some refacturing advice as well...
>>
>
>These are the columns in the table and they are repeated (6*3 columns). currentTemplate represents a table's row and all these properties are actual columns in the table.
>
Then clean up those as well and give the DBA responsible for such a wrecked design some hints to google for data normalization
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only