Welcome, Guest
Username: Password: Remember me

TOPIC: SQL Condition

SQL Condition 3 years 6 months ago #59794

Hi.

It's possible to define SQL conditions for questions?

I have other tables on database, imported from another system, and I have to restrict some questions using my data.

It's possible? How?

Thanks.
The administrator has disabled public write access.

Re: SQL Condition 3 years 6 months ago #59796

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 810
  • Thank you received: 115
  • Karma: 93
Sorry, not possible.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.
The following user(s) said Thank You: armandotaffarel

Re: SQL Condition 3 years 6 months ago #59797

Well, I need this... then.... I will make ;)

I'm thinking to use the "constant condition", putting my SQL in that field with a prefix like "::SQL::".

After, edit the index.php and manage that condition with that prefix, executing the SQL.

Is this a good way?

Thanks.
The administrator has disabled public write access.

Re: SQL Condition 3 years 6 months ago #59807

  • DenisChenu
  • DenisChenu's Avatar
  • NOW ONLINE
  • Moderator Lime
  • Posts: 6469
  • Thank you received: 853
  • Karma: 254
I think it's best to use some jquery/ajax function.

remysharp.com/2007/01/20/auto-populating...s-using-jquery-ajax/

And again with jquery: add a select box: fill a text short question with this select box.
The administrator has disabled public write access.
The following user(s) said Thank You: armandotaffarel

Re: SQL Condition 3 years 6 months ago #59827

I'll try. Thanks.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.112 seconds
Donation Image