Databases
StackOverflow2013
Postsdbo
POHow can I keep form values without using session?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I keep form values without using session?
    primarykey
    data
    text
    <p>I have one form page with pagination. I want to keep the form values as the user goes to the previous or next page, using pagination. I know that it can be done using the session scope. However, here I don't want to use session scope. Does anyone have any ideas on how to do this without using session? Please let me know.</p> <p>Here is my form page:</p> <pre><code>&lt;cfoutput&gt; &lt;form action="#buildUrl(action='survey.save_surveyresults',querystring='surveyId=#rc.surveyid#')#" method="post"&gt; &lt;input type="hidden" name="id" value="0"&gt; &lt;input type="hidden" name="surveyid" value="#rc.surveyId#"&gt; &lt;div class="container-fluid"&gt; &lt;div class="row"&gt; &lt;div class="control-group"&gt; &lt;label class="label-control" for="name"&gt;Name&lt;/label&gt; &lt;div class="controls"&gt; &lt;input type="text" name="name" id="name" required="true" placeholder="enter your name" value="#rc.name#"&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class="control-group"&gt; &lt;label class="label-control" for="email"&gt;Email&lt;/label&gt; &lt;div class="controls"&gt; &lt;input type="text" name="email" id="email" required="true" placeholder="enter your Email" value="#rc.email#"&gt; &lt;/div&gt; &lt;/div&gt; &lt;cfloop query="rc.questions" startrow="#startrow#" maxrows="#perpage#"&gt; &lt;!--- because we have all questions and answers in query we can use switch instead calling template or view for each question, so its simplify directory structures, questions directory is not necessary now ---&gt; &lt;h3&gt;#CurrentRow#&lt;cfif rc.questions.isrequired&gt;&lt;strong&gt;*&lt;/strong&gt;&lt;/cfif&gt;. #rc.questions.question#&lt;h3&gt; &lt;cfswitch expression="#rc.questions.template#"&gt; &lt;fieldset&gt; &lt;cfcase value="textbox"&gt; &lt;input type="text" class="input-xlarge" name="#template#_#questionid#" id="question_#questionid#"&gt; &lt;/cfcase&gt; &lt;cfcase value="multiplechoice"&gt; &lt;cfloop list="#answer#" delimiters="," index="i"&gt; &lt;div class="controls"&gt; &lt;label&gt; &lt;input type="radio" name="#template#_#questionid#" id="question_#questionid#" value="#answerID#" &gt; &lt;span class="lbl"&gt;#i#&lt;/span&gt; &lt;/label&gt; &lt;/div&gt; &lt;/cfloop&gt; &lt;/cfcase&gt; &lt;cfcase value="multiplechoiceother"&gt; &lt;cfloop list="#answer#" delimiters="," index="i"&gt; &lt;div class="controls"&gt; &lt;label&gt; &lt;input type="radio" name="#template#_#questionid#" id="question_#questionid#" value="#answerID#" &gt; &lt;span class="lbl"&gt;#i#&lt;/span&gt; &lt;/label&gt; &lt;/div&gt; &lt;/cfloop&gt; &lt;div class="control-group"&gt; &lt;label class="label-control" for="other"&gt;Other&lt;/label&gt; &lt;div class="controls"&gt; &lt;input type="text" class="input-xlarge" name="#template#_#questionid#" id="question_#questionid#"&gt; &lt;/div&gt; &lt;/div&gt; &lt;/cfcase&gt; &lt;/fieldset&gt; &lt;/cfswitch&gt; &lt;/cfloop&gt; &lt;p&gt;&lt;/p&gt;&lt;br /&gt; &lt;cfif startrow GT 1&gt; &lt;a href="#buildUrl(action='survey.survey_question',querystring='surveyid=#rc.surveyid#&amp;startrow=#startrow-perpage#')#" class="btn"&gt;Previous&lt;/a&gt; &lt;/cfif&gt; &lt;cfif (startrow + perpage - 1) lt rc.questions.recordcount&gt; &lt;a href="#buildUrl(action='survey.survey_question',querystring='surveyid=#rc.surveyid#&amp;startrow=#startrow + perpage#')#" class="btn"&gt;Next&lt;/a&gt; &lt;cfelse&gt; &lt;button type="submit" name="submit" class="btn btn-success"&gt;Finish&lt;/button&gt; &lt;/cfif&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;/form&gt; &lt;/cfoutput&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLeigh
    1. USSuleman khan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhen the form is initially submitted, you save all the variables in a new form with hidden fields and a submit button.
      singulars
      1. POHow can I keep form values without using session?
      1. USDan Bracuk
    2. COCurious why you are hesitant to use session scope for this?
      singulars
      1. POHow can I keep form values without using session?
      1. USScott Stroz
    3. COWith modern browswers the liklihood of unexpected changes to session variables is much greater than it used to be. We've been burned by this at work and I now store a lot less information in the session scope than I used to.
      singulars
      1. POHow can I keep form values without using session?
      1. USDan Bracuk
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload