ZEXP ((U OFS.FolderqUFolderqtqNt.}q(Ustandard_html_headerq(Uq(UOFS.DTMLMethodqU DTMLMethodqttQU__ac_local_roles__q }q U superuserq ]q UOwnerq asUsurvey_complete_updateq(Uq(UProducts.ZSQLMethods.SQLqUSQLqttQUCloseq(Uq(hU DTMLMethodqttQUsurvey_create_insertq(Uq(hUSQLqttQU acl_usersq(Uq(UAccessControl.UserqU UserFolderqttQUanswers_deleteq(Uq(hUSQLqttQU AddSurveyq(Uq (hU DTMLMethodq!ttQUCompleteSurveyq"(Uq#(hU DTMLMethodq$ttQU index_htmlq%(Uq&(UOFS.DTMLDocumentq'U DTMLDocumentq(ttQUsurvey_open_updateq)(Uq*(hUSQLq+ttQUOpenq,(Uq-(hU DTMLMethodq.ttQU GetAnswersq/(Uq0(hUSQLq1ttQU survey_deleteq2(Uq3(hUSQLq4ttQUGetUsersq5(Uq6(hUSQLq7ttQUquestion_add_insertq8(Uq9(hUSQLq:ttQUtitleq;U Survey Saysq(hU DTMLMethodq?ttQUEmptyq@(UqA(hU DTMLMethodqBttQUidqCUSurveySays_0.1qDULoginqE(UqF(hU DTMLMethodqGttQUEditqH(UqI(hU DTMLMethodqJttQU AddQuestionqK(UqL(hU DTMLMethodqMttQU Survey_CreateqN(UqO(hU DTMLMethodqPttQU GetSurveysqQ(UqR(hUSQLqSttQU GetQuestionsqT(UqU(hUSQLqVttQUanswer_add_insertqW(UqX(hUSQLqYttQU_objectsqZ(}q[(U meta_typeq\U User Folderq]hChu}q^(h\U DTML Documentq_hCh%u}q`(U meta_typeqaUZ PyGreSQL Database ConnectionqbUidqcUSurveysqdu}qe(haU Z SQL Methodqfhchu}qg(haU DTML MethodqhhchNu}qi(U meta_typeqjU SQL SessionqkUidqlUSessionqmu}qn(hjU DTML MethodqohlUstandard_html_headerqpu}qq(hjU DTML DocumentqrhlUAdminqsu}qt(hjhohlhEu}qu(U meta_typeqvU Z SQL MethodqwUidqxh5u}qy(hvhwhxhQu}qz(hvU DTML Methodq{hxU AddSurveyq|u}q}(hvh{hxUEditq~u}q(hvhwhxhTu}q(hvh{hxhKu}q(hvhwhxh8u}q(U meta_typeqU DTML MethodqUidqU LoadSurveyqu}q(hhhh"u}q(U meta_typeqU Z SQL MethodqUidqhWu}q(U meta_typeqU DTML MethodqUidqUReviewqu}q(hU Z SQL Methodqhh/u}q(hhhh)u}q(hhhhu}q(hhhh,u}q(U meta_typeqU DTML MethodqUidqhu}q(hU Z SQL MethodqhUsurvey_close_updatequ}q(hhhhu}q(hhhh2u}q(hhhUquestions_deletequ}q(hhhUDeletequ}q(hhhUEmptyquth(Uq(hU DTMLMethodqttQhs(Uq(h'U DTMLDocumentqttQhm(Uq(UProducts.SQLSession.SQLSessionqU SQLSessionqttQU__allow_groups__q(h(hU UserFolderqttQh(Uq(hU DTMLMethodqttQUsurvey_close_updateq(Uq(hUSQLqttQh(Uq(hUSQLqttQhd(Uq(UProducts.ZPyGreSQLDA.DAqU ConnectionqttQu.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUStandard Html HeaderqUrawqUqU__ac_local_roles__q }q U superuserq ]q UOwnerq asUglobalsq}qU__name__qUstandard_html_headerqU_varsq}qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsurvey_complete_updateqU__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)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}q Urawq!UHupdate surveys set creating = 'f' where survey_id = q"U_varsq#}q$ubUtitleq%UU arguments_srcq&U survey_idq'Usrcq(h"u.Z((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUCloseqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqU qU_varsq}qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsurvey_create_insertqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU connection_idq USurveysq UsrcqT INSERT INTO surveys (survey_name, status, creating, anonymous, owner, unlockword) VALUES ( , FALSE, TRUE, , , )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.r((UAccessControl.UserqU UserFolderqtqNt.}qUdataq(Uq(U PersistenceqUPersistentMappingqtq tq Qs.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUanswers_deleteqU__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_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}q Urawq!U:delete from answers where survey_id = q"U_varsq#}q$ubU arguments_srcq%U survey_idq&Usrcq'h"u.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qU AddSurveyqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqT  qU_varsq}qu.'((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUCompleteSurveyqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqTt Your Entry was stamped with the following time:

 qU_varsq}qu.%((UOFS.DTMLDocumentqU DTMLDocumentqtqNt.}q(UtitleqU Survey SaysqU__name__qU index_htmlqUglobalsq }q Urawq T

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 q U_varsq }qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsurvey_open_updateqU__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)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}q Urawq!UFupdate surveys set status = 't' where survey_id = q"U_varsq#}q$ubUtitleq%UU arguments_srcq&U survey_idq'Usrcq(h"u.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUOpenqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqU qU_varsq}qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU GetAnswersqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(U survey_idqUqorderqeU_dataq}q(h}qh}quubU connection_idqUSurveysqU_colq]q(}q(UtypeqUiUwidthqK UnameqU survey_idq u}q!(hUthKhUanswerq"u}q#(hUihKhUqorderq$u}q%(hUthKhUusernameq&ueUtemplateq'(cShared.DC.ZRDB.DA SQL q(oq)}q*(U__name__q+Uq,Uglobalsq-}q.Urawq/UtSELECT * from answers WHERE survey_id = '' AND qorder = ORDER BY username ASCq0U_varsq1}q2ubUtitleq3UU arguments_srcq4Usurvey_id qorderq5Usrcq6h0u.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU survey_deleteqU__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_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}q Urawq!U:delete from surveys where survey_id = q"U_varsq#}q$ubU arguments_srcq%U survey_idq&Usrcq'h"u.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUGetUsersqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qU_dataq}qubU connection_idqUSurveysqU_colq]q(}q(UtypeqUtUwidthqKUnameqUownerqu}q(hUthK hU unlockwordqueUtemplateq(cShared.DC.ZRDB.DA SQL q oq!}q"(U__name__q#Uq$Uglobalsq%}q&Urawq'U%select owner, unlockword from surveysq(U_varsq)}q*ubUtitleq+UU arguments_srcq,UUsrcq-h(u.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUquestion_add_insertqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(U survey_idqUquestionqUchoicesqUqorderqeU_dataq}q(h}qh}qh}qh}quubU connection_idqUSurveysqU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL q oq!}q"(U__name__q#Uq$Uglobalsq%}q&Urawq'UINSERT INTO questions (survey_id, question, choices, qorder) VALUES ( , , , )q(U_varsq)}q*ubUtitleq+UU arguments_srcq,U!survey_id question choices qorderq-Usrcq.h(u.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUDeleteqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqT qU_varsq}qu.U((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUEmptyqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqU qU_varsq}qu.G((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qULoginqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqT

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_varsq}qu. -((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUEditqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqT

Welcome !

Survey Name:

Your Questions are...
 
*** FILL IN RESPONSE ***
> >
Add Question:
Choices: One per line. (Leave blank for a fill-in response)
Finished
RESET qorder

I don't know you.

 qU_varsq}qu.N((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qU AddQuestionqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqU q(Uglobalsq)}q*Urawq+hU_varsq,}q-ubUtitleq.UU arguments_srcq/UU_argq0(cShared.DC.ZRDB.Aqueduct Args q1oq2}q3(U_keysq4]q5U_dataq6}q7ubu.&((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(UtypeqUstringqUwidthqK UnameqU survey_idquaUtemplateq (cShared.DC.ZRDB.DA SQL q!oq"}q#(U__name__q$Uq%Uglobalsq&}q'Urawq(UPselect * from questions where survey_id = '' order by qorderq)U_varsq*}q+ubUtitleq,UU arguments_srcq-U survey_idq.Usrcq/h)u.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUanswer_add_insertqU__ac_local_roles__q}qU superuserq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(U survey_idqUanswerqUqorderqUusernameqeU_dataq}q(h}qh}qh}qh}quubU connection_idqUSurveysqU_colq)Utemplateq(cShared.DC.ZRDB.DA SQL q oq!}q"(U__name__q#Uq$Uglobalsq%}q&Urawq'UINSERT INTO answers (survey_id, answer, qorder, username) VALUES ( , , , )q(U_varsq)}q*ubUtitleq+UU arguments_srcq,U survey_id answer qorder usernameq-Usrcq.h(u.((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qUReviewqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqTt

Welcome !

Survey Name:

Your Questions were...
 
*** FILL IN RESPONSE ***
 
Finished

I don't know you.

 qU_varsq}qu. ((UOFS.DTMLDocumentqU DTMLDocumentqtqNt.}q(UtitleqUU__name__qUAdminqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqTS

Welcome !

Current Surveys you've created:
>Edit Edit >Open Open >Close Close >Delete >Review >Empty

EditContinue adding questions to the survey
OpenLock survey from editing and open survey for use
(Note: Can not edit after locked! EVER!)
CloseClose survey for use
DeleteDelete survey, and all it's questions and answers
ReviewRead the results of your surveys
EmptyEmpty out the answers, reseting the survey

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

    I don't know you.

    qU_varsq}qu.((UProducts.SQLSession.SQLSessionqU SQLSessionqtqNt.}q(U sqlSetValueq(Uq(UProducts.ZSQLMethods.SQLqUSQLqttQUconn_idq USurveysq U__ac_local_roles__q }q U superuserq ]qUOwnerqasU cookie_nameqU _ZSessionqUsqlSessionLookupq(Uq(hUSQLqttQUpathqU/SurveySays_0.1qU sqlGetValueq(Uq(hUSQLqttQUmodeqUbase64qUsqlSessionCreateq(Uq(hUSQLqttQUsqlDeleteValueq(Uq (hUSQLq!ttQu.=((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(UtitleqUU__name__qU LoadSurveyqU__ac_local_roles__q}q U superuserq ]q UOwnerq asUglobalsq }qUrawqT

    >
    qU_varsq}qu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsurvey_close_updateqU__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)Utemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}q Urawq!UFupdate surveys set status = 'f' where survey_id = q"U_varsq#}q$ubUtitleq%UU arguments_srcq&U survey_idq'Usrcq(h"u.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUquestions_deleteqU__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_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}q Urawq!Uq"U_varsq#}q$ubU arguments_srcq%U survey_idq&Usrcq'h"u.((UProducts.ZPyGreSQLDA.DAqU ConnectionqtqNt.}q(UtitleqU Surveys DB Connection (Postgres)qUidqUSurveysqU__ac_local_roles__q }q U superuserq ]q UOwnerq asUconnection_stringqUsurveys nobodyqu.B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.]((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlSetValueqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q (U_keysq ]q (Usessionq UnameqUvalueqeU_dataq}q(h }qh}qh}quubU connection_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawq T 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 ( , , ) q!U_varsq"}q#ubU arguments_srcq$Usession name valueq%Usrcq&h!u.O((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlSessionLookupqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q (U_keysq ]q Usessionq aU_dataq}qh }qsubU connection_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}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}qubU arguments_srcq Usessionq!Usrcq"hu.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlGetValueqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q (U_keysq ]q (Usessionq UnameqeU_dataq}q(h }qh}qUdefaultqUsuubU connection_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}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 q U_varsq!}q"ubU arguments_srcq#Usession name=""q$Usrcq%h u.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlSessionCreateqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q (U_keysq ]q Usessionq aU_dataq}qh }qsubU connection_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqU This SQL creates a new session. INSERT INTO ZSessions ( zsession ) values ( ) qU_varsq}qubU arguments_srcq Usessionq!Usrcq"hu.q((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlDeleteValueqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q (U_keysq ]q (Usessionq UnameqeU_dataq}q(h }qh}qUdefaultqUsuubU connection_idqUSurveysqUtitleqUUtemplateq(cShared.DC.ZRDB.DA SQL qoq}q(U__name__qUqUglobalsq}qUrawqU This query deletes a data item for a session. DELETE FROM ZSession_data WHERE AND q U_varsq!}q"ubU arguments_srcq#Usession name=""q$Usrcq%h u.