[allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => mikehins [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> Jump Menu - Coldfusion - Advanced Techniques

Jump Menu - Coldfusion - Advanced Techniques

Hi all I have a Drop down box populate from my Company table and another one from my Models table.. I want to be able to make the model box change without refreshing the page. Here's what I've done so far.... Is there a way to keep that simple ?! Thank you Mike <cfparam name="FORM.Compagnie" default=""> <cfquery name="getCompagnie" datasource="golfexperts"> SELECT Comapgnie.Compagnie FROM Comapgnie </cfquery> <cfquery name="getModel" datasource="golfexperts"> SELECT Model.Model FROM Model WHERE '#FORM.Compagnie#' = Model.Compagnie </cfquery> <script type="text/JavaScript"> <!-- function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } //--> </script> <cfoutput> <form name="form1" method="post" action="#CGI.SCRIPT_NAME#"> <select name="Compagnie" onchange="MM_jumpMenu('this',this,0)"> <cfloop query="getCompagnie"> <option ...

  1. #1

    Default Jump Menu

    Hi all

    I have a Drop down box populate from my Company table and another one from my
    Models table.. I want to be able to make the model box change without
    refreshing the page. Here's what I've done so far.... Is there a way to keep
    that simple ?!

    Thank you

    Mike



    <cfparam name="FORM.Compagnie" default="">


    <cfquery name="getCompagnie" datasource="golfexperts">
    SELECT Comapgnie.Compagnie FROM Comapgnie
    </cfquery>

    <cfquery name="getModel" datasource="golfexperts">
    SELECT Model.Model FROM Model WHERE '#FORM.Compagnie#' = Model.Compagnie
    </cfquery>
    <script type="text/JavaScript">
    <!--
    function MM_jumpMenu(targ,selObj,restore){ //v3.0
    eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
    if (restore) selObj.selectedIndex=0;
    }
    //-->
    </script>



    <cfoutput>
    <form name="form1" method="post" action="#CGI.SCRIPT_NAME#">
    <select name="Compagnie" onchange="MM_jumpMenu('this',this,0)">
    <cfloop query="getCompagnie">
    <option
    value="#getCompagnie.Compagnie#">#getCompagnie.Com pagnie#</option>
    </cfloop>
    </select>

    <select name="Model">
    <cfloop query="getModel">
    <option value="#getModel.Model#">#getModel.Model#</option>
    </cfloop>
    </select>
    </form>

    </cfoutput>

    mikehins Guest

  2. #2

    Default Re: Jump Menu

    How are the two list items related? Or in other words, when you select a "Compagnie" what should determine what is selected in the "Model" list?
    mxstu Guest

  3. #3

    Default Re: Jump Menu

    When you select the company than the model box get populated with the models
    from that company

    my tables look like that :

    Company table

    Company

    Comp1
    Comp2
    Comp3

    Model Table

    Model Company

    Model1 Comp1
    Model2 Comp1
    Model3 Comp1
    Model1 Comp2
    Model2 Comp2
    Model3 Comp2
    .....



    mikehins Guest

Similar Threads

  1. jump menu not working
    By Unregistered in forum Brainstorming Area
    Replies: 0
    Last Post: May 26th, 11:01 AM
  2. jump menu help
    By mamakin in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 1
    Last Post: July 8th, 02:04 PM
  3. Help On Jump Menu's Please
    By kevryan in forum Macromedia Dynamic HTML
    Replies: 3
    Last Post: March 7th, 09:31 AM

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