Fcstefoy

Forum Replies Created

Viewing 6 replies - 16 through 21 (of 21 total)
  • Author
    Replies
  • in reply to: Ajax Success return data #125644
    Fcstefoy
    Participant

    Hello,

    <span id=”result_box” lang=”en”>This is the same result with the parameter  : async:  false,</span>

    <span id=”result_box” lang=”en”>An other idea</span> ?

    Best regards

    Christian Novent

    in reply to: Ajax Success return data #125638
    Fcstefoy
    Participant

    Oh sorry,

    You must read Undefined and not indefinite

     

    in reply to: Subgrid #125605
    Fcstefoy
    Participant

    <span id=”result_box” class=”short_text” lang=”en”>Hello,</span>

    <span id=”result_box” class=”short_text” lang=”en”>Thank you for your reply.</span>

    <span id=”result_box” class=”short_text” lang=”en”>I simply changed the syntax of the query :</span>
    <span style=”font-family: Thread-00001c70-Id-00000022;”>$sql=$conn->query(“SELECT top_verse, attestation FROM paiement WHERE clef_p = $rowid”);</span>
    <span id=”result_box” class=”short_text” lang=”en”>replaced by</span>
    $sql=$conn->query(“SELECT top_verse, attestation FROM paiement WHERE clef_p = ‘$rowid'”);
    And now it’s OK.
    Best regards
    in reply to: Subgrid #125599
    Fcstefoy
    Participant
    <form id=”gt-form” action=”/” enctype=”application/x-www-form-urlencoded” method=”post” name=”text_form”>

    <span id=”result_box” class=”short_text” lang=”en” tabindex=”-1″>With debug true :
    </span>
    With SQL sequence
    Executed 2 query(s) – 2016-10-18 09:50:19
    Array
    (
    [0] => Array
    (
    [time] => 2016-10-18 09:50:19
    [query] => SELECT COUNT(*) AS COUNTR  FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef
    [data] => Array
    (
    [0] => 14377
    )
    [types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )
    [1] => Array
    (
    [time] => 2016-10-18 09:50:19
    [query] => SELECT t1.cout_licence, t1.montant_demande, t1.montant_verse, t1.top_mra, t1.date_mra, t1.top_remise, t1.attestation, t1.cout_pass, t1.cout_ancv, t1.cout_autre, t1.versement_1, t1.versement_2, t1.versement_3, t1.versement_4, t1.versement_5, t1.mois_1, t1.mois_2, t1.mois_3, t1.mois_4, t1.mois_5, t1.cheque_1, t1.cheque_2, t1.cheque_3, t1.cheque_4, t1.cheque_5, t1.code_banque, t1.clef_p, t2.clef, t1.annee, t2.codejoueur AS code_licencie, t1.top_verse, t1.forf_mra, t1.forf_pass, t1.forf_ancv, t1.cout_remise, t1.montant_ligue FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef  LIMIT 0, 20
    [data] => Array
    (
    [0] => 14377
    )[types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )
    )
    Executed 2 query(s) – 2016-10-18 09:50:28
    Array
    (
    [0] => Array
    (
    [time] => 2016-10-18 09:50:28
    [query] => SELECT COUNT(*) AS COUNTR  FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef
    [data] => Array
    (
    [0] => 14377
    )
    [types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )
    [1] => Array
    (
    [time] => 2016-10-18 09:50:28
    [query] => SELECT t1.cout_licence, t1.montant_demande, t1.montant_verse, t1.top_mra, t1.date_mra, t1.top_remise, t1.attestation, t1.cout_pass, t1.cout_ancv, t1.cout_autre, t1.versement_1, t1.versement_2, t1.versement_3, t1.versement_4, t1.versement_5, t1.mois_1, t1.mois_2, t1.mois_3, t1.mois_4, t1.mois_5, t1.cheque_1, t1.cheque_2, t1.cheque_3, t1.cheque_4, t1.cheque_5, t1.code_banque, t1.clef_p, t2.clef, t1.annee, t2.codejoueur AS code_licencie, t1.top_verse, t1.forf_mra, t1.forf_pass, t1.forf_ancv, t1.cout_remise, t1.montant_ligue FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef  LIMIT 0, 20
    [data] => Array
    (
    [0] => 14377
    )
    [types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )
    )
    Without SQL sequence
    Executed 2 query(s) – 2016-10-18 09:54:26
    Array
    (
    [0] => Array
    (
    [time] => 2016-10-18 09:54:26
    [query] => SELECT COUNT(*) AS COUNTR  FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef
    [data] => Array
    (
    [0] => 14377
    )[types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )

    [1] => Array
    (
    [time] => 2016-10-18 09:54:26
    [query] => SELECT t1.cout_licence, t1.montant_demande, t1.montant_verse, t1.top_mra, t1.date_mra, t1.top_remise, t1.attestation, t1.cout_pass, t1.cout_ancv, t1.cout_autre, t1.versement_1, t1.versement_2, t1.versement_3, t1.versement_4, t1.versement_5, t1.mois_1, t1.mois_2, t1.mois_3, t1.mois_4, t1.mois_5, t1.cheque_1, t1.cheque_2, t1.cheque_3, t1.cheque_4, t1.cheque_5, t1.code_banque, t1.clef_p, t2.clef, t1.annee, t2.codejoueur AS code_licencie, t1.top_verse, t1.forf_mra, t1.forf_pass, t1.forf_ancv, t1.cout_remise, t1.montant_ligue FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef  LIMIT 0, 20
    [data] => Array
    (
    [0] => 14377
    )

    [types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )

    )
    Executed 1 query(s) – 2016-10-18 09:54:39
    Array
    (
    [0] => Array
    (
    [time] => 2016-10-18 09:54:39
    [query] => SELECT * FROM paiement WHERE 1=2
    [data] =>
    [types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )

    )
    Executed 2 query(s) – 2016-10-18 09:54:39
    Array
    (
    [0] => Array
    (
    [time] => 2016-10-18 09:54:39
    [query] => SELECT * FROM paiement WHERE 1=2
    [data] =>
    [types] =>
    [fields] =>
    [primary] =>
    [input] =>
    )

    [1] => Array
    (
    [time] => 2016-10-18 09:54:39
    [query] => UPDATE paiement SET annee = ?, top_remise = ?, cout_remise = ?, cout_pass = ?, forf_pass = ?, cout_ancv = ?, forf_ancv = ?, cout_autre = ?, top_mra = ?, date_mra = ?, forf_mra = ?, code_banque = ?, versement_1 = ?, versement_2 = ?, versement_3 = ?, versement_4 = ?, versement_5 = ?, cheque_1 = ?, cheque_2 = ?, cheque_3 = ?, cheque_4 = ?, cheque_5 = ?, mois_1 = ?, mois_2 = ?, mois_3 = ?, mois_4 = ?, mois_5 = ?, top_verse = ?, montant_verse = ?, montant_demande = ?, cout_licence = ?, montant_ligue = ?, attestation = ? WHERE clef_p = ?
    [data] => Array
    (
    [0] => 2016
    [1] => 0
    [2] => 0
    [3] => 60
    …………..

    </form>

    in reply to: Tinymce #123876
    Fcstefoy
    Participant

    Hello,

    Thank you very much for this example.

    This is pefect for me.

    Best regards

    Christian Novent

    in reply to: Tinymce #123856
    Fcstefoy
    Participant

    Is it possible to integrate into JQFORM form (not in JQGRID) ?

    Have you an example or reference ?

Viewing 6 replies - 16 through 21 (of 21 total)

Stay connected with us in your favorite flavor!