[long] DB and multipage survey
Francesco Consumi <[email protected]>
| Newsgroups | gmane.comp.apache.mod-survey.general |
|---|---|
| Message-ID | <[email protected]> |
Hi,
We're writing a multipage survey, made by 7 pages, linked to a Firebird
database.
We're noticed that only the last page values are saved in DB ?
is it a Bug ? or an our error ?
this is the beginning of every page of survey:
<SURVEY TITLE="Centro nazionale di documentazione e analisi per
l'infanzia e l'adolescenza"
DBITABLE="DEFFEM"
DBIDSN="DBI:InterBase:ntsrv3:questionari" DBIUSER="xx"
DBIPASSWD="xxxx">
...and at end:
<ROUTE CONTINUE="defFem02.survey" />
from 02 to 07.
the DBITABLE is the same for every page.
the values in table are a bit void, there are only that of last page:
INSERT INTO DEFFEM (SRVKEY, IDDF, PROVDF, DDF1, PAESI, DDF2, DDF3, DDF4,
DDF5, DDF5_1, DDF5_2, DDF6_1, DDF6_2, DDF6_3, DDF6_4, DDF7, DDF8, DDF9,
DDF1001, DDF1002, DDF1003, DDF1004, DDF1005, DDF1006, DDF1007, DDF1008,
DDF1009, DDF1010, DDF11, DDF12, DDF13, DDF14, DDF15, DDF1601, DDF1602,
DDF1603, DDF1604, DDF1605, DDF1606, DDF1607, DDF1608, DDF1609, DDF17,
D17_1, DDF18, DDF1901, DDF1902, DDF1903, DDF1904, DDF1905, DDF1906,
DDF1907, DDF1908, DDF1909, DDF1910, DDF19_1, DDF19_2, DDF20A, DDF20B,
DDF21, DDF22, DDF23, D23A, DDF24, DDF25, DDF2601, DDF2602, DDF2603,
DDF2604, DDF2605, DDF2606, DDF2607, DDF2608, DDF2609, DDF2610, DDF2611,
DDF26_1, DDF26_2, DDF26_3, DDF27, DDF28, DDF29, DDF30_1, DDF30_1A,
DDF30_2, DDF30_2A, DDF3101, DDF3102, DDF3103, DDF3104, DDF3105, DDF3106,
DDF3107, DDF3108, DDF31_1, DDF31_2, DDF3201, DDF3202, DDF3203, DDF3204,
DDF3205, DDF3206, DDF3207, DDF3208, DDF3209, DDF3210, DDF3211, DDF3212,
DDF3301, DDF3302, DDF3303, DDF3304, DDF3305, DDF3306, DDF3307, DDF3308,
DDF3309, DDF3310, DDF34, DDF35, DDF36, DDF3701, DDF3702, DDF3703,
DDF3704, DDF3705, DDF3706, DDF3707, DDF3708, DDF3709, DDF3710, DDF3711,
DDF3712, DDF3713, DDF3714, DDF3715, DDF3716, DDF3717, DDF3718, DDF3719,
DDF37_1, DDF38, DDF39, DDF40, D40_1, DDF41, DDF42, DDF43, DDF44, DDF44A,
DDF45, DDF4601, DDF4602, DDF4603, DDF4604, DDF4605, DDF4606, DDF4607,
DDF4608, DDF4609, DDF4610, DDF4611, DDF4612, DDF4613, DDF4614, DDF4701,
DDF4702, DDF4703, DDF4704, DDF4705, DDF4706, DDF4707, DDF4708, DDF4709,
DDF47_1, DDF48, DDF49, DDF49_1, DDF5001, DDF5002, DDF5003, DDF5004,
DDF5005, DDF5006, DDF5007, DDF5008, DDF5009, DDF5010, DDF5011, DDF5012,
DDF5013, DDF5014, DDF5015, DDF5016, DDF5017, DDF5018, DDF5019, DDF5020,
DDF5021, DDF50_1, DDF50_2, DDF51, DDF5201, DDF5202, DDF5203, DDF5204,
DDF5205, DDF5206, DDF5207, DDF5208, DDF5209, DDF5210, DDF5211, DDF5212,
DDF5213, DDF5214, DDF5215, DDF5216, DDF5217, DDF5218, DDF5219, DDF5220,
DDF5221, DDF52_1, DDF52_2, DDF53, DDF54, DDF55, DDF56, DDF57, DDF58,
DDF59, DDF60, DDF61, DDF62, DDF63, DDF64, DDF66, DDF67, DDF6801,
DDF6802, DDF6803, DDF6804, DDF6805, DDF6806, DDF6807, DDF6808, DDF6809,
DDF6810, DDF6811, DDF6812, DDF6813, DDF6814, DDF68_1, DDF69, DDF70,
DDF71, DDF72, DDF73, DDF74, DDF75, DDF76, DDF77A01, DDF77A02, DDF77A03,
DDF77A04, DDF77A05, DDF77A06, DDF77A07, DDF77A08, DDF77A09, DDF77B01,
DDF77B02, DDF77B03, DDF77B04, DDF77B05, DDF77B06, DDF77B07, DDF77B08,
DDF77B09, DDF77B10, DDF77B11, DDF77B12, DDF77B13, DDF77B14, DDF78,
DDF79, DDF80, DDF81, DDF82, DDF83, DDF84) VALUES
('20041004_142203_11527', NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '-1', 0, '',
0, '', 0, '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 0,
0, 0, 0, 0, 'Elenco finale di elementi.');
any help would be appreciated.
Skickat av Francesco Consumi <[email protected]>
till survey-discussion