MachForm Community Forums » MachForm 4

1. gustavpenny
   Member

   Hi there,

   I am getting a SQL error, please view below:

   SQL: [515] SELECT count(B.element_title) total_row FROM( SELECT A.element_64, (select element_choice_other_label from ap_form_elements where form_id = ? and element_id = ?) element_title FROM ap_form_10455_review A WHERE A.session_id = ? and A.element_64 = 0 and A.element_64_other is not null and A.element_64_other <> '' ) B WHERE B.element_title = 'b' Params: 3 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2 Key: Position #2: paramno=2 name=[0] "" is_param=1 param_type=2 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'A.element_64_other' in 'where clause'

   I am also trying to do the following but not able to.

   I have created a drop down menu to jump to pages, this works fine. I then need once the user has made selection to click continue which will take them to the "Review" page. I created "Logic" rules for this but can only do this for one of the pages and not all. I create a checkbox requesting to accept T's & C's and once clicking "Continue" they are taken to the "Review" page.

   I noticed, once a page has been selected in "Logic" you cannot use it again for another function like directing them to the "Review" page.

   Please could you let me know if there is a fix for this as I believe this is a very important feature to utilize.

   Posted 10 years ago #

RSS feed for this topic

Reply

You must log in to post.