ZEXPK((U OFS.FolderqUFolderqtqNt.}q(Ustandard_html_headerq(Uq(UOFS.DTMLMethodqU DTMLMethodqttQUDecrq (Uq (hU DTMLMethodq ttQU__ac_local_roles__q }q U superuserq]qUOwnerqasUCloseq(Uq(hU DTMLMethodqttQUsurvey_create_insertq(Uq(UProducts.ZSQLMethods.SQLqUSQLqttQUIncrq(Uq(hU DTMLMethodqttQU acl_usersq(Uq(UAccessControl.UserqU UserFolderqttQUanswers_deleteq(Uq (hUSQLq!ttQUCompleteSurveyq"(Uq#(hU DTMLMethodq$ttQU Surveys_MySQLq%(Uq&(UProducts.ZMySQLDA.DAq'U Connectionq(ttQU index_htmlq)(Uq*(UOFS.DTMLDocumentq+U DTMLDocumentq,ttQU erase_imgq-(Uq.(U OFS.Imageq/UImageq0ttQU unlock_imgq1(Uq2(h/UImageq3ttQUback_imgq4(Uq5(h/UImageq6ttQU GetAnswersq7(Uq8(hUSQLq9ttQU newpage_imgq:(Uq;(h/UImageq(hUSQLq?ttQU review_imgq@(UqA(h/UImageqBttQUDeleteqC(UqD(hU DTMLMethodqEttQULoginqF(UqG(hU DTMLMethodqHttQU AddQuestionqI(UqJ(hU DTMLMethodqKttQU Survey_CreateqL(UqM(hU DTMLMethodqNttQU GetSurveysqO(UqP(hUSQLqQttQU GetQuestionsqR(UqS(hUSQLqTttQUSurveys_PostgresqU(UqV(UProducts.ZPyGreSQLDA.DAqWU ConnectionqXttQUAdminqY(UqZ(h+U DTMLDocumentq[ttQU LastQuestionq\(Uq](hUSQLq^ttQU survey_deleteq_(Uq`(hUSQLqattQU noedit_imgqb(Uqc(h/UImageqdttQUqup_imgqe(Uqf(h/UImageqgttQUsurvey_close_updateqh(Uqi(hUSQLqjttQUDeleteQuestionqk(Uql(hU DTMLMethodqmttQUsurvey_complete_updateqn(Uqo(hUSQLqpttQU_objectsqq(}qr(U meta_typeqsU User FolderqtUidquhu}qv(hsU DTML Documentqwhuh)u}qx(U meta_typeqyU Z SQL MethodqzUidq{hu}q|(hyU DTML Methodq}h{hLu}q~(U meta_typeqU SQL SessionqUidqUSessionqu}q(hU DTML MethodqhUstandard_html_headerqu}q(hU DTML DocumentqhhYu}q(hhhhFu}q(U meta_typeqU Z SQL MethodqUidqUGetUsersqu}q(hhhhOu}q(hU DTML MethodqhU AddSurveyqu}q(hhhUEditqu}q(hhhhRu}q(hhhhIu}q(hhhh=u}q(U meta_typeqU DTML MethodqUidqU LoadSurveyqu}q(hhhh"u}q(U meta_typeqU Z SQL MethodqUidqUanswer_add_insertqu}q(U meta_typeqU DTML MethodqUidqUReviewqu}q(hU Z SQL Methodqhh7u}q(hhhUsurvey_open_updatequ}q(hhhhnu}q(hhhUOpenqu}q(U meta_typeqU DTML MethodqUidqhu}q(hU Z SQL MethodqhUsurvey_close_updatequ}q(hhhhu}q(hhhh_u}q(hhhUquestions_deletequ}q(hhhUDeletequ}q(hhhUEmptyqu}q(U meta_typeqUZ PyGreSQL Database ConnectionqUidqUSurveys_Postgresqu}q(hU Z SQL MethodqhU allow_editqu}q(U meta_typeqUImageqUidqUedit_imgqu}q(hhhh1u}q(hhhUlock_imgqu}q(U meta_typeqUImageqUidqhbu}q(U meta_typeqUImageqUidqh@u}q(hhhU trash_imgqu}q(hhhh-u}q(hhhh4u}q(U meta_typeqU DTML MethodqUidqUAddPagequ}q(U meta_typeqU Z SQL MethodqUidqh\u}q(U meta_typeqU DTML MethodqUidqh u}q(U meta_typeqU Z SQL MethodqUidqUDecrPagequ}q(hhhUSwapPagequ}q(U meta_typeqU Z SQL MethodqUidqUIncrPagequ}q(hU DTML Methodqhhu}q(hhhU PageBreakqu}q(hhhU AddPageBreakqu}q(hhhhku}q(hhhUsqlDeleteQuestionqu}q(U meta_typeqUImageqUidqheu}q(hhhU qdown_imgru}r(hhhh:u}r(hhhUsmalltrash_imgru}r(U meta_typerUImagerUidrUfill_imgru}r (U meta_typer UZ MySQL Database Connectionr Uidr h%utU AddSurveyr (Ur(hU DTMLMethodrttQh(Ur(hUSQLrttQUsqlDeleteQuestionr(Ur(hUSQLrttQU__allow_groups__r(h(hU UserFolderrttQh(Ur(hU DTMLMethodrttQh(Ur(hU DTMLMethodrttQh(Ur(hU DTMLMethodrttQUtitlerU Survey Saysrh(Ur(h/UImager ttQh(Ur!(hUSQLr"ttQU AddPageBreakr#(Ur$(hUSQLr%ttQh(Ur&(h/UImager'ttQh(Ur((hU DTMLMethodr)ttQUEmptyr*(Ur+(hU DTMLMethodr,ttQhuUSurveySays_0.3.1r-h(Ur.(hUSQLr/ttQh(Ur0(h/UImager1ttQUEditr2(Ur3(hU DTMLMethodr4ttQh(Ur5(hUSQLr6ttQh(Ur7(hUSQLr8ttQh(Ur9(hUSQLr:ttQj(Ur;(h/UImager<ttQh(Ur=(hUSQLr>ttQh(Ur?(hU DTMLMethodr@ttQj(UrA(h/UImagerBttQh(UrC(UProducts.SQLSession.SQLSessionrDU SQLSessionrEttQj(UrF(h/UImagerGttQU allow_editrH(UrI(hUSQLrJttQu.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUStandard Html HeaderqU__name__qUstandard_html_headerqU__ac_local_roles__q }q U superuserq ]q UOwnerq asUglobalsq}qUrawqU* qU_varsq}qu.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqT You asked to Decr Question # of Survey
We want to move your question to
Question # is on page
Question # is on page
if page #'s are different decrement page number if page #'s are same swap src_qorder and tgt_qorder qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qUCloseqU_varsq}qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsurvey_create_insertqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqTINSERT INTO surveys (survey_name, status, creating, anonymous, owner, unlockword) VALUES ( , 'f', 't', , , )qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqU&owner unlockword anonymous survey_nameqU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$(Uownerq%U unlockwordq&U anonymousq'U survey_nameq(eU_dataq)}q*(h'}q+h&}q,h(}q-h%}q.uubu.Z((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqT You asked to Incr Question # of Survey
We want to move your question to
Lets see if we have a tgt_qorder. We do Question # is on page
Question # is on page
if page #'s are different decrement page number if page #'s are same swap src_qorder and tgt_qorder We don't we need to increment the page then.
Your Entry was stamped with the following time:

Thank you for completing this Survey.
qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qUCompleteSurveyqU_varsq}qu.((UProducts.ZMySQLDA.DAqU ConnectionqtqNt.}q(UtitleqUZ MySQL Database ConnectionqUidqU Surveys_MySQLqU__ac_local_roles__q }q U superuserq ]q UOwnerq asUconnection_stringqUsurveys nobody nobodyqu.*((UOFS.DTMLDocumentqU DTMLDocumentqtqNt.}q(UtitleqU Survey SaysqUrawqT

Survey Says


Welcome to Survey Says. An online survey tool for creating, administering, and reviewing the results of surveys. To participate in a survey, click on a survey link below. Answer the questions, and submit the survey. It's that easy. (At this time, all surveys are anonymous.) That's right, there is no way for anyone to find out who you are, unless you put your name in an attached text box. (If one is available.) To create a survey, click on Survey Administrators below, and create a login account. Once inside, you can follow the prompts for creating and maintaining multiple surveys.

>


Survey Administrators qUglobalsq }q U__name__q U index_htmlq U_varsq }qu.((U OFS.ImageqUImageqtqNt.}q(UsizeqKUdataqUGIF87a))8` P,))0I8`(N96٤*+R۫ϦB H+&@n'aihBpd)2)j bkm}}yz)E{vfS} bM9K>l9s3LRS#R ;qUwidthqU41q U__name__q U erase_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((U OFS.ImageqUImageqtqNt.}q(UsizeqMUdataqTGIF87a))xxx,))0I7h;` x HJN,DpkmT(~B󼐻ے ktZFKDu^GPx1wťdn @3uRK(Y.;q6J1l(b:)A3&nJiNlű¿κ%ҴϐꐤĀAE`$;qUwidthqU41q U__name__q U unlock_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((U OFS.ImageqUImageqtqNt.}q(UsizeqKUdataqUGIF87a))xxx,))0I8ͻ`(K@NyB: ri-_kH,ql GZ'vHcp8ha^tt}j:)5:f2 ;qUwidthqU41q U__name__q Uback_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU GetAnswersqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUtSELECT * from answers WHERE survey_id = '' AND qorder = ORDER BY username ASCqU_colq]q(}q(UtypeqUiUwidthqK UnameqU survey_idqu}q(hUthKhUanswerqu}q(hUihKhUqorderqu}q(hUthKhUusernamequeUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q (U__name__q!Uq"Uglobalsq#}q$Urawq%hU_varsq&}q'ubUtitleq(UU arguments_srcq)Usurvey_id qorderq*U_argq+(cShared.DC.ZRDB.Aqueduct Args q,oq-}q.(U_keysq/]q0(U survey_idq1Uqorderq2eU_dataq3}q4(h1}q5h2}q6uubu.)((U OFS.ImageqUImageqtqNt.}q(UsizeqKGUheightqU16qUdataqUGGIF87a,&ώ33nos\Q'Bf^E;q U__name__q U newpage_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUwidthqU16qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUquestion_add_insertqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUINSERT INTO questions (survey_id, question, choices, qorder, page, qtype) VALUES ( , , , , , )qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqU-survey_id question choices qorder page qtypeqU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$(U survey_idq%Uquestionq&Uchoicesq'Uqorderq(Upageq)Uqtypeq*eU_dataq+}q,(h'}q-h)}q.h&}q/h%}q0h*}q1h(}q2uubu.((U OFS.ImageqUImageqtqNt.}q(UsizeqKUdataqUGIF87a))xxx,))ׄڀ|`)4G ꀘQk 'ܫL?h,@3L=/ dRQf 9P1_.ZPa>DCh&%c0(Hsw@C0pc&Y&@)*vbFa5 ['5ekb)T,{ML+J]J-j؇<w~}/?OP;qUwidthqU41q U__name__q U review_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqT qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qUDeleteqU_varsq}qu.G((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqT

You pointed to yourself

You are who you say you are. Redirect now... Save away user information for the time being. The Form will Reload automatically. Wrong Password!!! Save away user information for the time being. And Load the Administrator Window

Please Login:

If you are a new Survey User, an account will be created for you.

Owner
Unlock Word

qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qULoginqU_varsq}qu.)((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qU AddQuestionqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqTy q.Uglobalsq/}q0Urawq1Uselect * from surveys q2U_varsq3}q4ubUtitleq5UU arguments_srcq6UUsrcq7h2u.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU GetQuestionsqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qU survey_idqaU_dataq}qh}qsubU connection_idqUSurveysqU_colq]q(}q(UtypeqUiUwidthqKUnameqU survey_idqu}q(hUthKhUquestionq u}q!(hUthK hUchoicesq"u}q#(hUihKhUqorderq$u}q%(hUihKhUpageq&ueUtemplateq'(cShared.DC.ZRDB.DA SQL q(oq)}q*(U__name__q+Uq,Uglobalsq-}q.Urawq/UPselect * from questions where survey_id = '' order by qorderq0U_varsq1}q2ubUtitleq3UU arguments_srcq4U survey_idq5Usrcq6h0u.((UProducts.ZPyGreSQLDA.DAqU ConnectionqtqNt.}q(UtitleqU$Surveys PyGreSQL Database ConnectionqUidqUSurveys_PostgresqU__ac_local_roles__q }q U superuserq ]q UOwnerq asUconnection_stringqUsurveys nobodyqu. h((UOFS.DTMLDocumentqU DTMLDocumentqtqNt.}q(UtitleqUU__name__qUAdminqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqT

Welcome !

to SurveySays

Your Surveys


> > > > > >

Help

Continue adding questions to the survey
Currently you can only add questions. (No Delete or Edit exists yet)
Indicates an Unlocked Survey. (Open to the Public.)
If a survey is Unlocked, you can't Edit it. You must Lock the Survey
and Empty it before any additional Editing functions can be performed.
Indicates a Locked Survey. (Survey can not be taken.)
Delete survey. (Deletes all questions and answers)
Read the results of your surveys
Empty out the answers, reseting the survey

Actions

  • Add a New Survey
  • Survey Name:
    Anonymous: Yes No
    All Surveys are currently anonymous...

    I don't know you.

    qU_varsq}qu."((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU LastQuestionqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUSselect max(qorder) as maxqorder from questions where survey_id=qU_colq]q}q(UwidthqKUnameqU maxqorderqUtypeqUiuaUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq }q!ubUtitleq"UU arguments_srcq#U survey_idq$U_argq%(cShared.DC.ZRDB.Aqueduct Args q&oq'}q((U_keysq)]q*U survey_idq+aU_dataq,}q-h+}q.subu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU survey_deleteqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqU:delete from surveys where survey_id = qU_varsq}qubUsrcqhU arguments_srcqU survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#U survey_idq$aU_dataq%}q&h$}q'subu.((U OFS.ImageqUImageqtqNt.}q(UsizeqM:UdataqT:GIF87a))8` \@,)) 0J8?˵\b(hi848/7 vSA? 52 lSR!$[[&hE !Wvmyz{|i]xF"CyXE! mnp`v 9GGJ^!" z}1q2 K&Y}ߦZQjcR@TJ,Wz&XHXÀ/b\Q$;qUwidthqU41q U__name__q U noedit_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.1((U OFS.ImageqUImageqtqNt.}q(UsizeqKSUheightqU16qUdataqUSGIF87a,,k ]J>ڬ\m2x(`6IbLb;q U__name__q Uqup_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUwidthqU16qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsurvey_close_updateqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUFupdate surveys set status = 'f' where survey_id = qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqU survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$U survey_idq%aU_dataq&}q'h%}q(subu.S((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqU qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqU survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$U survey_idq%aU_dataq&}q'h%}q(subu.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqT  qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qU AddSurveyqU_varsq}qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsurvey_open_updateqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUFupdate surveys set status = 't' where survey_id = qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqU survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$U survey_idq%aU_dataq&}q'h%}q(subu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlDeleteQuestionqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqUdelete from questions where qorder = and survey_id = update questions set qorder = (qorder - 1) where survey_id = and qorder >= qU_varsq}qubUsrcqhU arguments_srcqUqorder survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#(Uqorderq$U survey_idq%eU_dataq&}q'(h%}q(h$}q)uubu.Y((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqU Add Page Break qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qUOpenqU_varsq}qu. "((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqTs


    > > The very last entry will always carry the last page no.
    ">
    ">
    ">
    ">

    qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qU LoadSurveyqU_varsq}qu.((U OFS.ImageqUImageqtqNt.}q(UsizeqMUdataqTGIF87a))xxx,))0Is` x HJNh6րMAz i;hmszZ h {&*b֦EWCxI}Whc(Rc@)eØIJƺl(Ǯևl{|@< ;qUwidthqU41q U__name__q Ulock_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUGetUsersqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqU%select owner, unlockword from surveysqU_colq]q(}q(UtypeqUtUwidthqKUnameqUownerqu}q(hUthK hU unlockwordqueUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}q Urawq!hU_varsq"}q#ubUtitleq$UU arguments_srcq%UU_argq&(cShared.DC.ZRDB.Aqueduct Args q'oq(}q)(U_keysq*]q+U_dataq,}q-ubu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU AddPageBreakqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqUmupdate questions set page = (page + 1) where survey_id = and qorder >= qU_varsq}qubUsrcqhU arguments_srcqUqorder survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#(Uqorderq$U survey_idq%eU_dataq&}q'(h%}q(h$}q)uubu.((U OFS.ImageqUImageqtqNt.}q(UsizeqMUdataqTGIF89a))8` \@!Made with GIMP,))(0I8K`(96٤*+R۫̾`6[P3!\j vP!n[@/jD !Inp~*^gwi?bmo_vsyyCSO|dq}ZD)9ófBykaǗΜKvi@[#a ;qUwidthqU41q U__name__q Uedit_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.L((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUAddPageqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqU qU_varsq}qu.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqU qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qUEmptyqU_varsq}qu.*((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUIncrPageqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUpupdate questions set page = (page + 1) where survey_id = and qorder = qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqUsurvey_id src_qorder qU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$(U survey_idq%U src_qorderq&eU_dataq'}q((h%}q)h&}q*uubu.((U OFS.ImageqUImageqtqNt.}q(UsizeqMUdataqTGIF87a))xxxȘ,))aXYIw6A`B#X4+xo'ygKj>E`W1I3NKՀ@P^vtxju)0P| I pyi"s}xp"Q~"vBO*27ƼO̰Һա{Jۭ<Ë&L_- ;qUwidthqU41q U__name__q U trash_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUheightqU41qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqT0

    Welcome !

    Survey Name:

    Your Questions are...
    Page  : Question  :  &qorder=> &qorder=> &qorder=> &qorder=>
    *** INPUT FIELD ***
    *** TEXT BOX ***

    Help!

    - Move question up in order. (If a question is the first question on a page, then it will be moved to the end of the previous page, otherwise it will move up in order.)
    - Move question down in order. (If a question is the last question on a page, then it will be moved to the first question of the next page, otherwise it will move down in order.)
    - Insert a page break at this point. All pages below will be automatically incremented.
    - Trash this question. It will not prompt you for confirmation, so be careful.

    > > Click here to add this question on the next page.
    Add Question:
    Choices: One per line. (Leave blank for a fill-in response)
    RESET qorder

    I don't know you.

    qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qUEditqU_varsq}qu.*((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUDecrPageqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUpupdate questions set page = (page - 1) where survey_id = and qorder = qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqUsurvey_id src_qorder qU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$(U survey_idq%U src_qorderq&eU_dataq'}q((h%}q)h&}q*uubu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUanswer_add_insertqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqUINSERT INTO answers (survey_id, answer, qorder, username) VALUES ( , , , )qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqU survey_id answer qorder usernameqU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$(U survey_idq%Uanswerq&Uqorderq'Uusernameq(eU_dataq)}q*(h(}q+h%}q,h'}q-h&}q.uubu.a((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUSwapPageqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqTupdate questions set qorder = 0 where survey_id = and qorder = update questions set qorder = where survey_id = and qorder = update questions set qorder = where survey_id = and qorder = 0 qU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqUsurvey_id tgt_qorder src_qorderqU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$(U survey_idq%U tgt_qorderq&U src_qorderq'eU_dataq(}q)(h%}q*h&}q+h'}q,uubu.2((U OFS.ImageqUImageqtqNt.}q(UsizeqKRUheightqU16qUdataqURGIF87a,+ Oĥ x!m"'&wJ= ;q U__name__q U qdown_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUwidthqU16qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUquestions_deleteqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqUqU_varsq}qubUsrcqhU arguments_srcqU survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#U survey_idq$aU_dataq%}q&h$}q'subu. &((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUUrawqT{

    Welcome !

    Survey Name:

    Your Questions were...
    Page  : Question  : 
     
    *** FILL IN RESPONSE ***
     

    I don't know you.

    qU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qU__name__qUReviewqU_varsq}qu.\((U OFS.ImageqUImageqtqNt.}q(UsizeqKwUheightqU16qUdataqUwGIF87aи,DcLڂXmh y&QcQ1Ϛ}[lbS@qC~LE*Mf|l8;q U__name__q Usmalltrash_imgq Utitleq UU content_typeq U image/gifqU preconditionqUUwidthqU16qU__ac_local_roles__q}qU superuserq]qUOwnerqasu.((UProducts.SQLSession.SQLSessionqU SQLSessionqtqNt.}q(Uconn_idqUSurveysqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU cookie_nameq U _ZSessionq UsqlSessionLookupq(U q(UProducts.ZSQLMethods.SQLqUSQLqttQUpathqU/SurveySays_0.3.1qU sqlGetValueq(U q(hUSQLqttQUsqlDeleteValueq(U q(hUSQLqttQUmodeqUbase64qUsqlSessionCreateq(U q(hUSQLqttQU sqlSetValueq(Uq (hUSQLq!ttQu.(((U OFS.ImageqUImageqtqNt.}q(UsizeqMEUdataqTEGIF89af3̙f3f3ffffff3f3333f333f3f3̙f3̙̙̙̙f̙3̙ffffff3f3333f333f3̙f3̙̙f3̙f3ff̙ffff3f33̙33f333̙f3ffffff3ffff̙fff3fffffff3ffffffffffff3fff3f3f3f3ff33f3ffffff3f3333f333333̙3f3333333f3333f3f3f3ff3f33f33333333f333333333f333f3̙f3f3ffffff3f3333f333f3! ," H*\ȰÇ#JHŋ3jh1 ;qU__ac_local_roles__q}q U superuserq ]q UOwnerq asU__name__q Ufill_imgqU content_typeqU image/gifqUtitleqUU preconditionqUUwidthqU20qUheightqU20qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU allow_editqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqUWupdate surveys set creating = 't', status = 'f' where survey_id = qU_varsq}qubUsrcqhU arguments_srcqU survey_idqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#U survey_idq$aU_dataq%}q&h$}q'subu. B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs. O((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlSessionLookupqU connection_idqUSurveysqUtitleq UUtemplateq (cShared.DC.ZRDB.DA SQL q oq }q (U__name__qUqUglobalsq}qUrawqU This query looks up a particular session. It should return one or more rows if the session is active. SELECT zsession as "session" FROM ZSessions WHERE qU_varsq}qubUsrcqhU arguments_srcqUsessionqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq}q(U_keysq]qUsessionqaU_dataq }q!h}q"subu. ((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlGetValueqU connection_idqUSurveysqUtitleq UUtemplateq (cShared.DC.ZRDB.DA SQL q oq }q (U__name__qUqUglobalsq}qUrawqT@ This query looks up some or all data belonging to a session. SELECT zsession as "session", zname as "name", zvalue as "value" FROM ZSession_data WHERE AND qU_varsq}qubUsrcqhU arguments_srcqUsession name=""qU_argq(cShared.DC.ZRDB.Aqueduct Args qoq}q(U_keysq]q(UsessionqUnameq eU_dataq!}q"(h}q#h }q$Udefaultq%Usuubu. q((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlDeleteValueqU connection_idqUSurveysqUtitleq UUtemplateq (cShared.DC.ZRDB.DA SQL q oq }q (U__name__qUqUglobalsq}qUrawqU This query deletes a data item for a session. DELETE FROM ZSession_data WHERE AND qU_varsq}qubUsrcqhU arguments_srcqUsession name=""qU_argq(cShared.DC.ZRDB.Aqueduct Args qoq}q(U_keysq]q(UsessionqUnameq eU_dataq!}q"(h}q#h }q$Udefaultq%Usuubu. ((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlSessionCreateqU connection_idqUSurveysqUtitleq UUtemplateq (cShared.DC.ZRDB.DA SQL q oq }q (U__name__qUqUglobalsq}qUrawqU This SQL creates a new session. INSERT INTO ZSessions ( zsession ) values ( ) qU_varsq}qubUsrcqhU arguments_srcqUsessionqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq}q(U_keysq]qUsessionqaU_dataq }q!h}q"subu.]((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlSetValueqU connection_idqUSurveysqUtitleq UUtemplateq (cShared.DC.ZRDB.DA SQL q oq }q (U__name__qUqUglobalsq}qUrawqT This query sets or updates a data item belonging to a session. Updates are bad, so we delete/insert. DELETE FROM ZSession_data WHERE AND INSERT INTO ZSession_data ( zsession, zname, zvalue ) VALUES ( , , ) qU_varsq}qubUsrcqhU arguments_srcqUsession name valueqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq}q(U_keysq]q(UsessionqUnameq Uvalueq!eU_dataq"}q#(h}q$h!}q%h }q&uubu.