Re: [long] DB and multipage survey

You do not need to include the DBITABLE stuff in any page but the 
last, since data is only actually saved at the final submit. In the 
meantime it is stored in a session file.

How does the last page look? Did you write a proper SEQUENCE tag?

Does it work if you do not specify a database? (ie let Mod_Survey handle 
things automatically via the AutoData save method)

   // Joel


On Mon, 4 Oct 2004, Francesco Consumi wrote:

> 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
>
Skickat av Joel Palmius <[email protected]>
till survey-discussion