OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » onchange

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

onchange [message #600169]

Fri, 01 November 2013 14:11

nataliafoster26
Messages: 64
Registered: October 2013

Member

i working with a onchange javascript

    CURRDEF := get_criteria_rec('PROP_CURR_DEF',dml_p_oracle_user.get_rec(VUSERNAME).global_region).include_list;

       --
                    HTP.P('<td class="reqlabel1">Currency:</td>');
        HTP.P('<td class="tablelabel">');

         HTP.P(Get_currencyCode_Dd(PVNAME=>'pvCurrCd', 
         PVDEFVAL =>'function currencychange(){
                     $.ajax({
                        url:vUrl,
                    data: { pnSalesCenterID: $(this).find("#pnSalesCenterID").val(),
                  pvCurrCd:'||CURRDEF||',
                  }
              asysnc:false,
              success: function(vRetVal){
                     var jsonObj =  eval("("+vRetVal+")");;
               },
  
               });
           });'    
          , PVEVENT=>'class="reqinput1" style="width:200px"'));
       HTP.P('</td>');

what im getting is currencychange is not defined, im thinking is not reading it.
this is my first time trying something like this working with ajax so not sure why is not reading it
both of these are dropdowns so when one changes the other will change depeding on what is in the database
[code] HTP.P('<td class="reqlabel1">Sales Center:</td>');
HTP.P('<td class="tablelabel">');
HTP.P(Get_Sc_Dd(PVNAME=>'pnSalesCenterID', PVORAID=> VUSERNAME, PVDEFVAL => NSALESCENTERID, PVEVENT=>'class="reqinput1" onChange="javascript:currencychange();" style="width:260px"'));
HTP.P('</td>');[\code]
Confused