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

[Bishop B. <ph...@id...>]

>> [snip]
>>
> If you remember the survey ID then yeah you could, but why?

I'm writing a bulk uploader, so the admin can load their many =20
thousands of surveys (per time period), and I'm considering data =20
consistency repercussions if I do something like DELETE FROM survey =20
WHERE realm =3D 'foo'.

The bulk uploader has a hard requirement to not touch response data, =20
so I wondered if I performed that delete if the data would still be =20
recoverable.  I didn't know if you needed the survey to know the =20
question structure to get the responses back.

But, it really shouldn't be an issue, because I should only delete =20
surveys that are not activated or done -- those are guaranteed to not =20
have any responses.


>> 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.

Okay, I'll dig.  My client wants all kinds of roll-up reports, so one =20
convenient function would be nice.  I've not seen a single =20
phpESP-native object, so I'm guessing that's out. :)


Thanks!
bishop

--=20
Bishop Bettini
ideacode, Inc.
(main) +1 919 341 5170 / (fax) +1 919 521 4100

Visit us on the web at:
ideacode.com          Professional software research and development
reviewmysoftware.com  Improve sales! Review your software before you release
bytejar.com           Solutions to those annoying development problems