27 Replies Latest reply on Nov 28, 2008 6:36 PM by Günter Schenk

    Dependent Dropdown with POST

      Hi (Gunter Hi again if it's you that answers this) <br /> <br />I have a dependent dropdown on page with 3 selects (working fine) that needs to pass 3 parameters to a page manage_sections.php and the params are ClientID, ProjectID and SectionID respectively. <br /> <br />Here is my form:- <br /> <br />-------- <br /> <br /> <form action="manage_sections.php" method="get" name="remove" target="_parent"> <br /> <span class="textcol4">1.&#160;</span> <select name="ClientID" id="ClientID"> <option value="">select client</option><?php<br />do {  <br />?> <option value="<?php echo $row_RsClients['ClientID']?>"> <?php echo $row_RsClients['ClientName']?> </option><?php<br />} while ($row_RsClients = mysql_fetch_assoc($RsClients));<br />  $rows = mysql_num_rows($RsClients);<br />  if($rows > 0) {<br />      mysql_data_seek($RsClients, 0);<br />   $row_RsClients = mysql_fetch_assoc($RsClients);<br />  }<br />?> </select> <br /> <label> <br /> <br /> <span class="textcol4">2.&#160;</span> <select name="ProjectID" id="ProjectID" wdg:subtype="DependentDropdown" wdg:type="widget" wdg:recordset="RsProjects" wdg:displayfield="ProjectName" wdg:valuefield="ProjectID" wdg:fkey="ProjectClientID" wdg:triggerobject="ClientID" wdg:selected=""> <option value="">select project</option> </select> <br /> <br /> <br /> <label> <br /> <span class="textcol4">3.&#160;</span> <select name="SectionID" id="SectionID" wdg:subtype="DependentDropdown" wdg:type="widget" wdg:recordset="RsSections" wdg:displayfield="SectionName" wdg:valuefield="SectionID" wdg:fkey="SectionProjectID" wdg:triggerobject="ProjectID"> <option value="">select section</option> </select> <br /> </label> <br /> <a href="javascript:void(0)"> <img src="../Nitobi/Assets/style/treegrid/flex/refresh.gif" alt="refresh" width="16" height="14" hspace="4" border="0" onclick="window.location.reload()" /> </a> <br /> <label> <br /> &#160;&#160;&#160;&#160; <input type="submit" class="btn1" value="GO" /> <br /></label> <br /></label></form> <br /> <br />----------- <br />To submit the IDs I have found the only way I can figure is to use 'GET' form action and manually add the dropdown IDs to be the same as the ID I want to pass eg ' <select name="ClientID" id="ClientID"></select>
        • 1. Re: Dependent Dropdown with POST
          Level 1
          weird form code not posting - I'll try to '//' out to make missing areas show:-

          <//form action="manage_sections.php" method="get" name="remove" target="_parent">
          1. 
          • 2. Re: Dependent Dropdown with POST
            Level 1
            OK, for some reason my last two selects won't show in this post - again I have invalidated the code with a /:-

            2. <//select name="ProjectID" id="ProjectID" wdg:subtype="DependentDropdown" wdg:type="widget" wdg:recordset="RsProjects" wdg:displayfield="ProjectName" wdg:valuefield="ProjectID" wdg:fkey="ProjectClientID" wdg:triggerobject="ClientID" wdg:selected="">
            select project
            <//select>


            select section
            <//select>
            • 3. Re: Dependent Dropdown with POST
              Günter Schenk Level 4
              Hi Glennboy, <br /> <br />regretfully there´s no way to hide URL parameters from the browser´s address bar, but there are ways to protect the originally passed $_GET values -- it´s done by storing them in Session Variables and check these ones against subsequent changes. <br /> <br />Out of curiosity - and also because this is a serious issue to many folks here - I´ve just been experimenting a little, and I´d like you to try the following approach: <br /> <br />1. create a simple "parameters.php" page which just contains a link to "check.php" -- and append some static dummy values to this link, e.g. "check.php?ClientID=53&amp;ProjectID=15&amp;SectionID=25" <br /> <br />2. create the page "check.php", and in here paste the following PHP/HTML code: <br /> <br />----------- <br /><?php<br />session_start();  <br />if(isset($_SESSION['views']))<br />    $_SESSION['views'] = $_SESSION['views']+ 1;<br />else<br />    $_SESSION['views'] = 1;<br />?> <br /> <br /><?php<br />if(!empty($_GET['ClientID']) && (is_numeric($_GET['ClientID'])) && ($_SESSION['views'] == 1) ){<br />$session_ClientID = $_GET['ClientID'];<br />$_SESSION['session_ClientID'] = $session_ClientID;<br />}<br /><br />if(!empty($_GET['ProjectID']) && (is_numeric($_GET['ProjectID'])) && ($_SESSION['views'] == 1) ){<br />$session_ProjectID = $_GET['ProjectID'];<br />$_SESSION['session_ProjectID'] = $session_ProjectID;<br />}<br /><br />if(!empty($_GET['SectionID']) && (is_numeric($_GET['SectionID'])) && ($_SESSION['views'] == 1) ){<br />$session_SectionID = $_GET['SectionID'];<br />$_SESSION['session_SectionID'] = $session_SectionID;<br />}<br />?> <br /> <br /><?php<br />// 1. checking the Session Variable "session_clientID"<br />if (isset($_SESSION['session_ClientID']) && ($_SESSION['session_ClientID'] == $_GET['ClientID'] ) ) {<br />$check_ClientID = "has not been faked";<br />$valid_ClientID = 'Y';<br />}<br />else {<br />$check_ClientID = "has been faked to <b>".$_GET['ClientID']."</b>";<br />$valid_ClientID = 'N';<br />}<br /><br />// 2. checking the Session Variable "session_projectID"<br />if (isset($_SESSION['session_ProjectID']) && ($_SESSION['session_ProjectID'] == $_GET['ProjectID'] ) ) {<br />$check_ProjectID = "has not been faked";<br />$valid_ProjectID = 'Y';<br />}<br />else {<br />$check_ProjectID = "has been faked to <b>".$_GET['ProjectID']."</b>";<br />$valid_ProjectID = 'N';<br />}<br /><br />// 3. checking the Session Variable "session_sectionID"<br />if (isset($_SESSION['session_SectionID']) && ($_SESSION['session_SectionID'] == $_GET['SectionID'] ) ) {<br />$check_SectionID = "has not been faked";<br />$valid_SectionID = 'Y';<br />}<br />else {<br />$check_SectionID = "has been faked to <b>".$_GET['SectionID']."</b>";<br />$valid_SectionID = 'N';<br />}<br />?> <br /> <br />The original ClientID value is <b> <?php echo $_SESSION['session_ClientID']; ?> </b> and <?php<br />echo $check_ClientID; ?> <br /> <br /> <br /> <br />The original ProjectID value is <b> <?php echo $_SESSION['session_ProjectID']; ?> </b> and <?php<br />echo $check_ProjectID; ?> <br /> <br /> <br /> <br />The original SectionID value is <b> <?php echo $_SESSION['session_SectionID']; ?> </b> and <?php<br />echo $check_SectionID; ?> <br />----------- <br /> <br />You will see that any subsequent changes of the initially stored $_GET values will return a "has been faked to..." message for each URL variable, and I think that´s quite fine for a start ;-) <br /> <br />Cheers, <br />Günter Schenk <br />Adobe Community Expert, Dreamweaver
              • 4. Re: Dependent Dropdown with POST
                Level 1
                Hi Günter

                Thanks for your in-depth response (as usual).

                I will try this, but it turns out that I can circumvent my initial issue and I think this may make sense. Basically I needed to create a join in my recordset to ensure that VisitorClientID = ClientID - that way the recordset doesn't display anything if they don't equal.

                Make sense?

                Cheers

                Glennyboy
                • 5. Re: Dependent Dropdown with POST
                  Level 1
                  Günter<br /><br />In line with what I am trying to achieve (basically I want to be able to use the same page for admin and client display:-<br /><br />Is it possible to include a conditional element in a recordset? For example from my original recordset I want to change the method I retrieve 'colname1' from GET ClientID to session variable '$_SESSION['kt_VisitorClientID']' if the following argument was true:-<br /><br /><Session element><br />if (@$_SESSION['kt_login_level'] == "3" AND "4") {<br /><br />rather than standard:- (else I guess)<br /><br /><Get element><br />if (@$_SESSION['kt_login_level'] == "1" AND "2") {<br /><br />this is my original recordset: - <br /><br />$colname1_RsSections = "-1";<br />if (isset($_GET['ClientID'])) {<br />  $colname1_RsSections = (get_magic_quotes_gpc()) ? $_GET['ClientID'] : addslashes($_GET['ClientID']);<br />}<br />mysql_select_db($database_db, $db);<br />$query_RsSections = sprintf("SELECT projects.*, sections.*, clients.* FROM ((sections LEFT JOIN projects ON projects.ProjectID=sections.SectionProjectID) INNER JOIN clients ON clients.ClientID=projects.ProjectClientID)  WHERE ClientID=%s", GetSQLValueString($colname1_RsSections, "int"));<br />$RsSections = mysql_query($query_RsSections, $db) or die(mysql_error());<br />$row_RsSections = mysql_fetch_assoc($RsSections);<br />$totalRows_RsSections = mysql_num_rows($RsSections);<br /><br />Looking forward to your response.<br /><br />Thanks<br /><br />Glenn
                  • 6. Re: Dependent Dropdown with POST
                    Günter Schenk Level 4
                    Hi Glennboy,

                    -------
                    Is it possible to include a conditional element in a recordset?
                    -------

                    I think it should be possible using an if/else condition, although this:

                    if (@$_SESSION['kt_login_level'] == "1" AND "2")

                    ... will not work anyway, because you´ll have to define it this way:

                    if ( (@$_SESSION['kt_login_level'] == "1") AND (@$_SESSION['kt_login_level'] == "2") )

                    Question aside: are you sure that some user might really have 2 levels assigned, means 1 AND 2 ? If not, you might try with OR, because then the user may have level 1 OR level 2.

                    Back to your conditional query: what I´d try to do, is...

                    1. within the "if" part: check if the session exists AND check the two login levels

                    2. within the "else" part: encapsulate the original $_GET['ClientID']:

                    if (isset($_GET['ClientID'])) {
                    $colname1_RsSections = (get_magic_quotes_gpc()) ? $_GET['ClientID'] : addslashes($_GET['ClientID']);
                    }

                    However, it´s clear that such a manually edited recordset will no longer be editable with DW´s Recordset Builder, so I´d apply those changes when everything else in the page is working as supposed.

                    Cheers,
                    Günter Schenk
                    Adobe Community Expert, Dreamweaver
                    • 7. Re: Dependent Dropdown with POST
                      Level 1
                      Hi Günter

                      Thanks for the input and heads up on 'OR' statement (you were indeed correct).

                      As you noted I had realised after post that creating a conditional recordset would make it not editable and for this reason I'll probably create separate pages with separate recordsets... but it's good to know it would be possible :-)

                      Cheers

                      Glennyboy
                      • 8. Re: Dependent Dropdown with POST
                        Günter Schenk Level 4
                        Hi Glennboy,

                        if you still want to experiment with your conditional query, try using this code:

                        ---------
                        if ( (isset($_SESSION['kt_login_level']) AND ( (@$_SESSION['kt_login_level'] == "1") OR (@$_SESSION['kt_login_level'] == "2") ) )

                        {
                        $colname1_RsSections = (get_magic_quotes_gpc()) ? $_SESSION['kt_login_level'] : addslashes($_SESSION['kt_login_level']);
                        }

                        else if (isset($_GET['ClientID']))
                        {
                        $colname1_RsSections = (get_magic_quotes_gpc()) ? $_GET['ClientID'] : addslashes($_GET['ClientID']);
                        }
                        ---------

                        Cheers,
                        Günter Schenk
                        Adobe Community Expert, Dreamweaver
                        • 9. Re: Dependent Dropdown with POST
                          Level 1
                          Hi Günter

                          I did opt to try and apply the dependent recordset as it permits me to use the same page for multiple functions. I had to switch round your example and make a couple of syntax changes, but it did indeed work. Here's an example of my code:-

                          //NeXTenesio3 Special List Recordset
                          $colname2_RsSections = "-1";
                          if (isset($_GET['SectionID'])) {
                          $colname2_RsSections = $_GET['SectionID'];
                          }
                          // session and get variables
                          if ( ($_SESSION['kt_login_level']) AND (@$_SESSION['kt_login_level'] == "1") OR (@$_SESSION['kt_login_level'] == "2") ) {

                          $colname1_RsSections = (get_magic_quotes_gpc()) ? $_GET['ClientID'] : addslashes($_GET['ClientID']);
                          }

                          else if (isset($_SESSION['kt_VisitorClientID'])) {
                          $colname1_RsSections = (get_magic_quotes_gpc()) ? $_SESSION['kt_VisitorClientID'] : addslashes($_SESSION['kt_VisitorClientID']);
                          }

                          colname2 was universal to both.

                          As we thought the recordset does become un-editable in DW, so I have kept in the original parameters so that I can uncomment them when I need to apply a Server Behavior.

                          Cheers

                          Glennyboy
                          • 10. Re: Dependent Dropdown with POST
                            Günter Schenk Level 4
                            Hi Glennboy,

                            well done ! :-)

                            Cheers,
                            Günter Schenk
                            Adobe Community Expert, Dreamweaver
                            • 11. Re: Dependent Dropdown with POST
                              Level 1
                              Hi Günter

                              Is it possible to take this dependency further with a TNG recordset / Dynamic form?

                              For example with the same conditions as above to switch the initial ClientID in the form from the Get to session... as in:-

                              under

                              // Add Columns

                              from:-

                              $ins_files->addColumn("FileClientID", "STRING_TYPE", "POST", "FileClientID", "{GET.ClientID}");

                              to

                              $ins_files->addColumn("FileClientID", "STRING_TYPE", "POST", "FileClientID", "{SESSION.kt_login_id}");

                              Or should I really create a new page + form?

                              Thanks

                              Glenn
                              • 12. Re: Dependent Dropdown with POST
                                Günter Schenk Level 4
                                Hi Glenn,

                                I think this should work too, as $_GET['whatever'] and $_SESSION['whatever'] variables are so-called "superglobals" and available in whatever "place" you want.

                                I can recall having done this (a conditional "$ins_tablename->addColumn" based on whether a URL variable was set or not) once and with success.

                                Cheers,
                                Günter Schenk
                                Adobe Community Expert, Dreamweaver
                                • 13. Re: Dependent Dropdown with POST
                                  Level 1
                                  Hi Gunter

                                  How would this be written into the TNG columns with my condition:-

                                  // session and get variables
                                  if ( ($_SESSION['kt_login_level']) AND (@$_SESSION['kt_login_level'] == "1") OR (@$_SESSION['kt_login_level'] == "2") )

                                  when login level is 1 or 2:-

                                  $ins_files->addColumn("FileClientID", "STRING_TYPE", "POST", "FileClientID", "{GET.ClientID}");

                                  to other login levels (else)

                                  $ins_files->addColumn("FileClientID", "STRING_TYPE", "POST", "FileClientID", "{SESSION.kt_login_id}");

                                  Many Thanks

                                  Glennyboy
                                  • 14. Re: Dependent Dropdown with POST
                                    Günter Schenk Level 4
                                    Hi Glenn,

                                    please try with this condition:

                                    ---------------
                                    if ( (isset($_SESSION['kt_login_level']) AND ( (@$_SESSION['kt_login_level'] == "1") OR (@$_SESSION['kt_login_level'] == "2") ) )
                                    {
                                    $ins_files->addColumn("FileClientID", "NUMERIC_TYPE", "VALUE", "{SESSION.kt_login_id}");
                                    }

                                    else if (isset($_GET['ClientID']))
                                    {
                                    $ins_files->addColumn("FileClientID", "NUMERIC_TYPE", "VALUE", "{GET.ClientID}");
                                    }
                                    -------

                                    Please let me explain some of what I did:

                                    1. if you´re going to check the existance of a session variable (also applies to GET or POST variables), you need to use the "isset" variable handling function, e.g. "if (isset($_GET['variablename'])".

                                    Your usage of "if($_SESSION['kt_login_level'])" will not go anywhere, as it simply does nothing -- and as it does nothing, the whole condition will fail.

                                    2. unlike you I´m using NUMERIC TYPE, VALUE and {GET.ClientID} respectively {SESSION.kt_login_id} -- why ?

                                    2.1. "SESSION.kt_login_id" and "GET.ClientID" are numeric values after all, and so the column type shouldn´t be set to STRING_TYPE

                                    2.2. rather than using POST, you can set both variants to VALUE -- because if you´re using POST, you would have to "echo" these values in additional hidden fields, whereas the VALUE definition makes this dispensable.

                                    Cheers,
                                    Günter Schenk
                                    Adobe Community Expert, Dreamweaver
                                    • 15. Re: Dependent Dropdown with POST
                                      Level 1
                                      Hi Gunter

                                      I'm going to skip this as it caused DWCS3on Mac to totally bug out - in the code there was an unexpected } too.

                                      So I'll create x2 forms instead.

                                      Question though as I am moving on. In this form say I have uploaded an original image 'image_1' and I am using file upload... will/can the update transaction overwrite the original file. I recall reading somewhere that by default it does not?

                                      Thanks

                                      Glennyboy
                                      • 16. Re: Dependent Dropdown with POST
                                        Günter Schenk Level 4
                                        Hi Glenn,

                                        -------
                                        will/can the update transaction overwrite the original file. I recall reading somewhere that by default it does not?
                                        --------

                                        ADDT doesn´t have a "delete existing file prior to uploading a new one" option, but I´ve written a tutorial which explains how to first delete the original file by using a Custom Trigger: http://www.guenter-schenk.com/tutorials/tutorial.php?id=7

                                        Cheers,
                                        Günter Schenk
                                        Adobe Community Expert, Dreamweaver
                                        • 17. Re: Dependent Dropdown with POST
                                          Level 1
                                          Hi Günter

                                          Found your tutorial. Great stuff and worked a treat!

                                          I have a new question for you :-)

                                          I have a date field on my dynamic form and I have set this up MySQL DB as:-

                                          FileDate timestamp ON UPDATE CURRENT_TIMESTAMP No CURRENT_TIMESTAMP

                                          The default date value in the dynamic form for FileDate is also set as {NOW}.

                                          On file insert it takes the date fine, but I want the date to update every time there is a file update (so users can track file progress) - currently it keeps the original upload date/time. How do I set it to update timestamp every time?

                                          Cheers

                                          Glennyboy
                                          • 18. Re: Dependent Dropdown with POST
                                            Günter Schenk Level 4
                                            Hi Glenn,

                                            --------
                                            I have a new question for you
                                            --------

                                            oooh NOOOOO :-)

                                            --------
                                            On file insert it takes the date fine, but I want the date to update every time there is a file update (so users can track file progress) - currently it keeps the original upload date/time. How do I set it to update timestamp every time?
                                            --------

                                            how about using the existing timetamp column for file inserts only, and use a secondary timetamp column for updates ? "lastUpdated" would have to be set to: ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

                                            Cheers,
                                            Günter Schenk
                                            Adobe Community Expert, Dreamweaver
                                            • 19. Re: Dependent Dropdown with POST
                                              Level 1
                                              Hi Gunter

                                              Just trying to keep you on your toes :-)

                                              On insert into DB I'M getting:-

                                              MySQL said:

                                              #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

                                              Do I remove the CURRENT_TIMESTAMP from the original field? Also is there a default value of {NOW} for the new field in the Dynamic form?

                                              Also what's the rationale behind 2 fields rather than 1 for insert and update?

                                              Thanks

                                              Glennyboy
                                              • 20. Re: Dependent Dropdown with POST
                                                Günter Schenk Level 4
                                                Hi Glenn,

                                                -------
                                                Just trying to keep you on your toes
                                                -------

                                                thank you, much appreciated :-)

                                                ------
                                                #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
                                                ------

                                                wow, didn´t know that.

                                                ------
                                                Do I remove the CURRENT_TIMESTAMP from the original field? Also is there a default value of {NOW} for the new field in the Dynamic form?
                                                ------

                                                well, timestamp columns which are supposed to auto-update their values don´t even need to be included in your insert/update transaction, as they´ll be updating the value anyway.

                                                ------
                                                Also what's the rationale behind 2 fields rather than 1 for insert and update?
                                                ------

                                                I use this for having separate "file_added" and "file_updated" data.

                                                Cheers,
                                                Günter Schenk
                                                Adobe Community Expert, Dreamweaver
                                                • 21. Re: Dependent Dropdown with POST
                                                  Level 1
                                                  Hi Gunter <br /> <br />Well this time i thought I'd provide some input rather than asking you a question as this should help other people out there. <br /> <br />So I couldn't get on with doing a last modified via my database so instead I wrote some php to recursively look up and then echo the last modified date instead. Here it is:- <br /> <br /><?php<br />// gets the date of when the file was last modified<br />$filename = ("files/".$row_RsSections['FileClientID']."/".$row_RsSections['FileProjectID']."/".$row_R sSections['FileSectionID']."/".$row_RsSections['FileUrl']."");<br />if (file_exists($filename)) {<br /> echo   $lastmod = "Last modified on: <br>" . date ("D, d M Y, g:i A", filemtime($filename));<br />}<br />?> <br /> <br />I guess the only possible downside is if you want to store the value in the database, but in my instance I just needed to display the date. <br /> <br />Cheers <br /> <br />Glennyboy
                                                  • 22. Re: Dependent Dropdown with POST
                                                    Günter Schenk Level 4
                                                    Hi Glenn,

                                                    thank you very much for this inventive contribution !

                                                    ------
                                                    i thought I'd provide some input rather than asking you a question
                                                    ------

                                                    in exchange for this you´ll get 10 more answers for free :-)

                                                    Cheers,
                                                    Günter Schenk
                                                    Adobe Community Expert, Dreamweaver
                                                    • 23. Re: Dependent Dropdown with POST
                                                      Level 1
                                                      OK so her is 1 for you :-) ...

                                                      How do I set timeout on session and also redirect to login page after timeout?

                                                      Thanks

                                                      Glennyboy
                                                      • 24. Re: Dependent Dropdown with POST
                                                        Günter Schenk Level 4
                                                        Hi Glenn, <br /> <br />------------ <br />How do I set timeout on session <br />------------ <br /> <br />with ADDT there´s no way to have e.g. a form automatically timeout and/or "do something" once the session has expired, but you can at least implement a visual control: <br /> <br />1. you would have to retrieve the "session.gc_maxlifetime" value of the server´s php.ini, and here´s a code snippet which retrieves and echos this value: <br /> <br /><?php<br />$seconds = ini_get('session.gc_maxlifetime');<br />$minutes_display = intval($seconds/60);<br />$seconds_display = ($seconds%60);<br />$total = $minutes_display.":".$seconds_display;<br />echo $total;<br />?> <br /> <br />Possible implementation by leaving a note on top of the form: <br /> <br />The current session will expire in <?php echo $total; ?> <br /> <br />2. an alternate approach is to embed the $total value in a javascript based "count down" script <br /> <br />------ <br />and also redirect to login page after timeout <br />------ <br /> <br />just add ADDT´s "Restrict Access to Page" behaviour to both the form and to the "redirect after insert" page -- this will automatically redirect to the login page if the session has expired <br /> <br />Cheers, <br />Günter Schenk <br />Adobe Community Expert, Dreamweaver
                                                        • 25. Re: Dependent Dropdown with POST
                                                          Level 1
                                                          Hi Gunter

                                                          Cheers for the above....

                                                          I have question 2 for you.....

                                                          OK so I have a delete transaction (del_clients) and then x3 recursive deletes triggered before this event to remove the associated detail recordsets:-

                                                          //start del_files trigger
                                                          //remove this line if you want to edit the code by hand
                                                          function del_files(&$tNG) {
                                                          $tblDelObj = new tNG_DeleteDetailRec($tNG);
                                                          $tblDelObj->setTable("files");
                                                          $tblDelObj->setFieldName("FileClientID");
                                                          return $tblDelObj->Execute();
                                                          }
                                                          //end del_files trigger

                                                          //start del_sections trigger
                                                          //remove this line if you want to edit the code by hand
                                                          function del_sections(&$tNG) {
                                                          $tblDelObj = new tNG_DeleteDetailRec($tNG);
                                                          $tblDelObj->setTable("sections");
                                                          $tblDelObj->setFieldName("SectionClientID");
                                                          return $tblDelObj->Execute();
                                                          }
                                                          //end del_sections trigger

                                                          //start del_projects trigger
                                                          //remove this line if you want to edit the code by hand
                                                          function del_projects(&$tNG) {
                                                          $tblDelObj = new tNG_DeleteDetailRec($tNG);
                                                          $tblDelObj->setTable("projects");
                                                          $tblDelObj->setFieldName("ProjectClientID");
                                                          return $tblDelObj->Execute();
                                                          }
                                                          //end del_projects trigger

                                                          Problem is that I don't currently have 'SectionClientID' available as a database value, but it is the same as both FileClientID and ProjectClientID values. Is there a way to edit the del-sections trigger to make SectionClientID = FileClientID? WHERE SectionClientID = FileClientID....

                                                          Look forward to your response

                                                          Cheers

                                                          Glennyboy
                                                          • 26. Re: Dependent Dropdown with POST
                                                            Level 1
                                                            any ideas on the above Gunter?

                                                            Cheers

                                                            Glennyboy
                                                            • 27. Re: Dependent Dropdown with POST
                                                              Günter Schenk Level 4
                                                              -------
                                                              any ideas on the above Gunter?
                                                              -------

                                                              not yet, but this is a truly intricate request ;-)

                                                              Cheers,
                                                              Günter Schenkj
                                                              Adobe Community Expert, Dreamweaver