From: Jerry B. A. <jb...@gm...> - 2008-08-18 19:26:54
|
Hi, I've seen an interesting bug, and I'm not sure if it is just me (i.e. pilot error) or if it's something systemic, and if maybe there's a bugfix I've missed. We're using phpESP 2.0.2. We've got a number of surveys that are multi-page that allow you to go back and forth from page to page. When we go to examine the data and associated with this survey, only the last page of survey data is available. I've tracked this down to the following: each page gets entered with its own 'id' in the response table, but only the last page's ID has the 'complete' column set to 'Y'. So we'll see things like: mysql> select * from response where username='dking123'; +-----+-----------+---------------------+----------+----------+--------------+ | id | survey_id | submitted | complete | username | ip | +-----+-----------+---------------------+----------+----------+--------------+ | 185 | 25 | 2008-08-18 14:57:10 | N | x| z| | 186 | 25 | 2008-08-18 14:57:35 | N | x| z| | 187 | 25 | 2008-08-18 14:57:40 | N | x| z| | 188 | 25 | 2008-08-18 14:58:04 | Y | x| z| +-----+-----------+---------------------+----------+----------+--------------+ 4 rows in set (0.00 sec) (I've done just the tiniest bit of sterilization on my data here.) Has anyone else seen this behavior? Is there a fix already, or should I go out and write it and submit it back in? Thanks 1.e6! //jbaltz -- jerry b. altzman jb...@gm... www.jbaltz.com foo mane padme hum |