Professional Web Applications Themes

database query to move to next page - Coldfusion Database Access

Hi I am building an online questionnaire. Each users name etc. is held in an Access database. Each user has several respondents answering questions about them. There are 12 section pages of questions. Each user needs different section pages answered about them. So when a respondent logs in idealy they will move from one section to another only seeing the relevant sections. Is it possible to insert a database query as a form post destination? So that when the form is submitted the database is checked to see what that persons next section is and the form is posted there. ...

  1. #1

    Default database query to move to next page

    Hi

    I am building an online questionnaire. Each users name etc. is held in an
    Access database. Each user has several respondents answering questions about
    them. There are 12 section pages of questions. Each user needs different
    section pages answered about them. So when a respondent logs in idealy they
    will move from one section to another only seeing the relevant sections.

    Is it possible to insert a database query as a form post destination? So that
    when the form is submitted the database is checked to see what that persons
    next section is and the form is posted there. I realise I will need to have the
    insert data info for all the sections at the top of each section page.

    Or is there another way? Please help I have been struggling with this for
    weeks.

    Many thanks

    Trolldude

    trolldude Guest

  2. #2

    Default Re: database query to move to next page

    Another way is to use some sort of session variable to strore the answers in
    RAM until all the questions are complete. Then process your session variable
    and insert the bits into your db.

    A structure would be the best choice for your session variable.

    Dan Bracuk Guest

Similar Threads

  1. CS1: Slug does not move with page?
    By John_Gendreau@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 0
    Last Post: August 24th, 10:42 PM
  2. Replies: 1
    Last Post: March 15th, 12:22 PM
  3. Can you move a page to a different folder in Contribute3
    By tiffglaze.net in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: June 20th, 04:35 AM
  4. How to move text from one page to a form on another page
    By dmantt webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 24th, 03:31 PM
  5. Replies: 2
    Last Post: July 14th, 05:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139