Posted by Pasquale on 03/29/07 19:30

peter wrote:
>> I have created a database with a table of questions and a table of
>> sections. Certain questions belong under certain sections. There are about
>> 240 questions for 2 programs where people analyze the responses and give
>> suggestions on improvements to processes.
>>
>> The questions are identical for both programs except for about 6 different
>> sets of words. One example question would be:
>>
>> Program A: Does your Agency have a computer firewall?
>> Program B: Does your Brokerage have a computer firewall?
>>
>> These word replacements would only be necessary for maybe a dozen
>> questions.
>>
>> I was wondering what the best approach would be?
>>
>> I didn't think it would be very efficient to check every question and
>> replace the word if necessary as they are printed to the page.
>
> 1 possibility would be to have a flag with thw question denoting wether a
> replacement is needed in the question. Use an if stateme nt to check if the
> flag is set, if it is then do the replace if not just use it as normal.
>

This may be a simple question, but would an index be an option to flag
or would another column with say 0 or 1 as a flag be better?

Thanks,
Pasquale

[Back to original message]