https://www.machform.com/forums/ MachForm Community Forums Topic: SQL Error en Tue, 26 May 2026 14:25:05 +0000 https://www.machform.com/forums/topic/sql-error-1#post-20943 Tue, 06 May 2014 21:02:54 +0000 gustavpenny 20943@https://www.machform.com/forums/ <p>Hi there,</p> <p>I am getting a SQL error, please view below:</p> <p>SQL: [515] SELECT count(B.element_title) total_row FROM( SELECT A.<code>element_64</code>, (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.<code>session_id</code> = ? and A.element_64 = 0 and A.element_64_other is not null and A.element_64_other &lt;&gt; '' ) 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'</p> <p>I am also trying to do the following but not able to.</p> <p>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 &#38; C's and once clicking "Continue" they are taken to the "Review" page. </p> <p>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. </p> <p>Please could you let me know if there is a fix for this as I believe this is a very important feature to utilize. </p>