Submit form using AJAX

[eluser]GrootBaas[/eluser]
Pramod,

Yes, Oracle does not have the LIMIT functionality, but I managed to get around that problem.

Try looking at this select ....

Code:

SELECT a.id,
       a.account_name,
       a.contract_no,
       a.reg_no,
       a.start_date,
       DECODE(a.status, 'R', 'Active', 'A', 'Active', 'C', 'Closed', 'O', 'Open') status
FROM (SELECT row_number() OVER ({ORDER_BY}) id,
             ea.account_name,
                 ea.account_code,
                 av.con_contract_no contract_no,
                 av.fms_reg_no reg_no,
                 av.con_con_id,
              av.start_date,
              av.con_contract_status status
         FROM allocation_view av,
              external_accounts ea
        WHERE av.cln_ea_c_id = ea.c_id
          AND av.cln_ea_account_type = ea.account_type
          AND av.cln_ea_account_code = ea.account_code
          AND av.fms_reg_no = NVL({REG_NO}, av.fms_reg_no)          
  ORDER BY ea.account_name) a {SEARCH_STR}

[eluser]Pramod[/eluser]
Thanks for reply.

I think it will be better if I could handle the post variable in loop so that I could use the library and js file for all cases(more than one time)

for example:
varibale after

Code:

p.state

to

Code:

p.par_value_to

name and value set by looping and send to the ajax file of the flexigrid.

Please help me.

Code:

if (p.page>p.pages) p.page = p.pages;
                var param = {page:p.newp, rp: p.rp, sortname: p.sortname, sortorder: p.sortorder, query: p.query, qtype: p.qtype,state:p.state,validityDateFrom:p.validity_dt_from,validityDateTo:p.validity_dt_to,expDateFrom:p.exp_dt_from,expDateTo:p.exp_dt_to,destri:p.p_distributor,aliasName:p.alis_name,parValueFrom:p.par_value_from,parValueTo:p.par_value_to};

Thanks in advance

Pramod