Custom code After Save

Custom code After Save

Postby sultan87 » Mon Nov 07, 2016 8:28 pm

hello,
the code in after-save is not performed
Code: Select all
nuDebug("Après Sauvegarde Séjours Locataires");

// Recherche id_locataire dans table suivi

nuDebug("Recherche Numéro Locataires");

$s = "

SELECT s_id_locataire
FROM suivi
WHERE id_suivi = '1'

";

$t = nuRunQuery($s);
$r = db_fetch_row($t);
$p = $r[0];

// MAJ id_locataire dans table sejours

$s = "

UPDATE sejours
SET id_locataire_sejour =  '$p'
WHERE id_sejours = '#RECORD_ID#'

";

why ?
Best regards
pierre
sultan87
 
Posts: 23
Joined: Thu Jun 11, 2015 5:58 am

Re: Custom code After Save

Postby admin » Mon Nov 14, 2016 7:01 am

sultan87,

I don't understand your question.

Steven
admin
Site Admin
 
Posts: 3081
Joined: Mon Jun 15, 2009 9:53 am

Re: Custom code After Save

Postby mobilemcclintic » Thu Nov 17, 2016 2:37 pm

I think you need to tell nubuilder what to do.

Just reading the last bit,you set $s, but don't do anything with it.
Add nuRunQuery($s); to the end. If everything else is right, it should perform your update.
mobilemcclintic
 
Posts: 54
Joined: Fri Oct 23, 2015 8:04 am


Return to Custom Code



cron