Welcome, Guest
Username: Password: Remember me

TOPIC: scid / srid

scid / srid 1 year 4 months ago #94548

  • mimi
  • mimi's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 32
  • Karma: 0
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.
The administrator has disabled public write access.

scid / srid 1 year 4 months ago #94585

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6272
  • Thank you received: 800
  • Karma: 240
srid : lime_survey_XXXX.id
scid : UNIQUE KEY for lime_saved_control
The administrator has disabled public write access.

scid / srid 1 year 4 months ago #94684

  • mimi
  • mimi's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 32
  • Karma: 0
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..
The administrator has disabled public write access.

scid / srid 1 year 4 months ago #94685

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6272
  • Thank you received: 800
  • Karma: 240
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
The administrator has disabled public write access.

scid / srid 1 year 4 months ago #94689

  • mimi
  • mimi's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 32
  • Karma: 0
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...
The administrator has disabled public write access.

scid / srid 1 year 4 months ago #94694

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6272
  • Thank you received: 800
  • Karma: 240
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
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.105 seconds
Donation Image