Re: [phpesp-dev] true or false: responses can be recovered if the survey is blown away?

[Matthew G. <mat...@gm...>]

On Sun, 2008-01-20 at 20:16 -0500, Bishop Bettini wrote:
> All,
> 
> I have a question about the phpESP underlying design: if you delete a  
> survey to which a response points, can you still recover the answers  
> given in the response?  For example, say you have this:
> 
> mysql> select id,survey_id,complete from response;
> +----+-----------+----------+
> | id | survey_id | complete |
> +----+-----------+----------+
> |  7 |        18 | Y        |
> |  6 |        18 | Y        |
> |  8 |        18 | Y        |
> |  9 |        18 | Y        |
> | 10 |        18 | Y        |
> | 11 |        17 | N        |
> | 13 |        20 | N        |
> | 14 |        21 | Y        |
> +----+-----------+----------+
> 
> and then you do this:
> delete from survey where id=18
> 
If you remember the survey ID then yeah you could, but why?
> 
> Can you get the responses made for response ids 6, 7, 8, 9, and 10?   
> If so, is there a convenient function to get those responses as an  
> array/object?
> 
It's been so long, I would need to look over the code, but if a function
exists, it should be easy to find.

> Thanks!
> bishop
>