Check out the LimeSurvey source code on GitHub!

scid / srid

More
3 years 9 months ago #94548 by mimi
Hi...

May i know what is 'srid' and 'scid' code in the database?
It is the name of column in tr_saved_control table.
Where is that code refer to?

TQ.

Please Log in to join the conversation.

More
3 years 9 months ago #94585 by DenisChenu
srid : lime_survey_XXXX.id
scid : UNIQUE KEY for lime_saved_control

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
3 years 9 months ago #94684 by mimi
I am sorry denisChenu..
i didnt mean to cross the topic.
for this topic, when i post, i didnt see my post, so then im trying to post at the other topic.
thats why...

Anyway.. thank u so much for answering.

But may i know,, the unique key for lime _saved_control are auto generated?
or can we generate it manually?
same thing for srid.

Thank u..

Please Log in to join the conversation.

More
3 years 9 months ago #94685 by DenisChenu
Hello,

No not really, and it's a bad idea. The 2 id is in "AUTO_INCREMENT" then whe n you don't force, you're sure it will be unique.

You can do your own php script to set srid or scid, but need some php competence to do a good script.
And what for ? Maybe there are some best way to have another identification number.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
3 years 9 months ago #94689 by mimi
can i just put any number into it?

bcause i have a big problem here where my system not go to the page where it should go.

the system is about updating. when student want to update their status, they will proceed to the page where it should b. and i have find out that the student data not save to the tr_saved_control table. that's why they cant proceed to the page where it should b.

so i were thinking that i can make the srid and scid code by myself...

Please Log in to join the conversation.

More
3 years 9 months ago #94694 by DenisChenu
Think best is to use "token" with "Allow editing responses after completion?" to Yes.

The student need to only know is token, he can update his answers when needed.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form