Re: [phpesp-general] Recovering archived survey?

[David L. <lio...@co...>]

Hi Brian,

Thank you for the instructions.

Brian Wood wrote:

> David,
>
> You can often find your answer by searching the mailing list archive 
> (linked from the phpESP homepage).
>
> http://sourceforge.net/mailarchive/message.php?msg_id=5559358

This is good, but the line below is the real goods. I was able to change 
the status successfully, to the immense relief of my student.
The status of the survey when I looked in the database was 15, and I 
changed it to 1.

I'll post the steps for reference.

Best,
Dave

>
> The SQL would be:
>
> update survey set status = 1 where id='[id]'
>
> [id] is the id number of the survey.
>
> Be really careful running update sql statements.  if you get the Where 
> clause wrong you can overwrite data.
>
> Brian Wood
> Programmer/Analyst
> UC Berkeley Human Resources
>
>
>
> David Liontooth wrote:
>
>> One of my students accidentally archived a survey, and now cannot 
>> access the results.
>> Is there a way to retrieve them -- even in comma-delimited form?
>>
>> Dave
>>
>>
>> -------------------------------------------------------
>> SF email is sponsored by - The IT Product Guide
>> Read honest & candid reviews on hundreds of IT Products from real users.
>> Discover which products truly live up to the hype. Start reading now.
>> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>> _______________________________________________
>> phpESP-general mailing list
>> php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general