Summing and Enums -- another solution?

This is a discussion on Summing and Enums -- another solution? within the MySQL Database forums, part of the Database Forums category; On May 22, 10:13 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote: > > That is correct. > &...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #21 (permalink)  
Old 05-23-2008
lawpoop@gmail.com
 
Posts: n/a
Default Re: Summing and Enums -- another solution?

On May 22, 10:13 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:

>
> That is correct.
>
>
> Then you need to educate them. Changing questions in mid-stream
> invalidates the survey.


Well, that's not necessarily mid-stream. After 90 days of the same
survey, and reports run on all that, if they decide that they want to
run a new survey, then they're cutting the stream and starting a new
one.

In other words, a 'steam' only lasts for a period of time. We're not
going to come up at the outset with the One True Survey to last until
the end of time.

>
> The bottom line is - YOU DON'T CHANGE QUESTIONS IN THE MIDDLE OF A
> SURVEY! If you want new questions, you create a new survey. You may
> reuse questions from the previous survey - but you don't change the old one.


I think we're talking about the same thing here. By definition, when
the Powers that Be decide to change questions, the current survey has
ended, and we are starting a new survey.

All I'm trying to do is make sure that, when we do decide to go ahead
and end the old survey and start a new one, a user doesn't actually
get a hybrid survey. They should either get one or the other.
Reply With Quote
  #22 (permalink)  
Old 05-23-2008
Jerry Stuckle
 
Posts: n/a
Default Re: Summing and Enums -- another solution?

lawpoop@gmail.com wrote:
> On May 22, 10:13 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>
>> That is correct.
>>
>>
>> Then you need to educate them. Changing questions in mid-stream
>> invalidates the survey.

>
> Well, that's not necessarily mid-stream. After 90 days of the same
> survey, and reports run on all that, if they decide that they want to
> run a new survey, then they're cutting the stream and starting a new
> one.
>
> In other words, a 'steam' only lasts for a period of time. We're not
> going to come up at the outset with the One True Survey to last until
> the end of time.
>
>> The bottom line is - YOU DON'T CHANGE QUESTIONS IN THE MIDDLE OF A
>> SURVEY! If you want new questions, you create a new survey. You may
>> reuse questions from the previous survey - but you don't change the old one.

>
> I think we're talking about the same thing here. By definition, when
> the Powers that Be decide to change questions, the current survey has
> ended, and we are starting a new survey.
>
> All I'm trying to do is make sure that, when we do decide to go ahead
> and end the old survey and start a new one, a user doesn't actually
> get a hybrid survey. They should either get one or the other.


That's fine then. You only need one set of questions. Each survey
would have a separate ID (and you can have multiple surveys going at the
same time, if you wish). So if the survey ends while someone is only
partway through, when they come back you have a choice - either let them
complete the survey (and possibly not count the answers because you've
already run your reports), or give them a message indicating the survey
has ended - and only count the results they entered up to that point.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:10 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0