phpesp-general

[phpesp-general] Delete answers

[Heidi A. <he...@im...>]

Hi,
I have for one question (countries) more then 250 possible answers in a drop
down list.

No we see, that it takes a lot time to load it everytime and we want to
delete the most of them and leave 20 or 30 countries left.

I have this question now in nearly 80 diffrent surveys. And that means I
need to delete it on every of them.

Any idea, how to do it in the best and fastest way ?

Should I do it one by one survey ?
Or any idea for a sql comand to delete it straight from the database ? Do i
need to take care of something ?

Thanks in advance for your help

Kind reagrds
Heidi

Re: [phpesp-general] Delete answers

[James E. F. <jf...@ac...>]

It should not cause any problems to delete them directly
from the database as long as the surveys are not active
(they should be in Edit mode). The table you would need to
edit is "question_choice".

-James

On Wed, 24 Apr 2002, Heidi Anselstetter wrote:

> Hi,
> I have for one question (countries) more then 250 possible answers in a drop
> down list.
>
> No we see, that it takes a lot time to load it everytime and we want to
> delete the most of them and leave 20 or 30 countries left.
>
> I have this question now in nearly 80 diffrent surveys. And that means I
> need to delete it on every of them.
>
> Any idea, how to do it in the best and fastest way ?
>
> Should I do it one by one survey ?
> Or any idea for a sql comand to delete it straight from the database ? Do i
> need to take care of something ?
>
> Thanks in advance for your help
>
> Kind reagrds
> Heidi
>
>
>
>
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>