[phpesp-general] Deleting responses

[Robin G. <rg...@st...>]

We have some duplication in responses.  The guy entering the data has =
mistakenly pressed return mid-way through a survey (rather than tab) and =
has mistakenly submitted partly-completed responses.  On multiple =
occassions!

To my knowledge phpESP doesn't have the facility to delete responses.  I =
could simply export the data, de-duplicate the responses, and then analyse =
(i.e. in Excel).  I'd rather use phpESP analysis tools however.  Thus I =
need accurate data in MySQL.

My guess would be to use phpMyAdmin to delete the relevant records from =
the 'response' table.  What would be the repercussions of this?  Would the =
data in other 'response_...' tables become corrupted?  Will all the cross-=
tabbing still work?

Has anyone else experienced this problem - are some safeguards (submit: =
are you sure y/n?) or additional functions (overwrite responses) required?

cheers,

--=20
Robin Gower

0161 860 0344