Search found 375 matches: +nuRunQuery

Return to advanced search

Re: New install - cannot save updated setup. FIXED

... INTO zzzzsys_session SET sss_access = ?, zzzzsys_session_id = ? ===BACK TRACE==== /srv/www/htdocs/nubuilder4/nuprocesslogins.php - line 107 (nuRunQuery) /srv/www/htdocs/nubuilder4/nusession.php - line 22 (nuLoginSetupGlobeadmin) /srv/www/htdocs/nubuilder4/nuapi.php - line 6 (require_once) ...
by dgoadby
Wed Nov 06, 2019 12:02 pm
 
Forum: General
Topic: New install - cannot save updated setup. No save button.
Replies: 3
Views: 46

Re: Warning when password updating

... is generated propoerly it updates passwords correctly - but with additional warning. if('#check_password#' != ''){ $pw = md5('#check_password#'); nuRunQuery("UPDATE zzzzsys_user SET sus_login_password = '$pw' WHERE zzzzsys_user_id = '#RECORD_ID#'"); }
by Janusz
Tue Oct 29, 2019 6:58 pm
 
Forum: Custom Code
Topic: Warning when password updating
Replies: 3
Views: 53

Warning when password updating

... at line 1 ===SQL=========== UPDATE zzzzsys_user SET WHERE `zzzzsys_user_id` = '5db5f850d5ba9ea'; ===BACK TRACE==== ....../nudata.php - line 348 (nuRunQuery) ...../nuapi.php - line 51 (nuUpdateDatabase)
by Janusz
Tue Oct 29, 2019 6:23 pm
 
Forum: Custom Code
Topic: Warning when password updating
Replies: 3
Views: 53

Using nubuilder php functions

Hi guys ! I add a new php file into the project for a custom code and when I use the nuDebug or nuRunQuery functions inside the file, there are not recognized :| How can I use the php functions (https://wiki.nubuilder.net/nubuilderforte/index.php/PHP) in a new php files ...
by mariri
Wed Oct 16, 2019 7:46 pm
 
Forum: Custom Code
Topic: Using nubuilder php functions
Replies: 3
Views: 115

Re: Change ID field on save

... getEmailAddress($Id) { $sql = " SELECT `ipcamclient_email` FROM `ipcamclient` WHERE `ipcamclient_id` = '$Id' "; nuDebug($sql); $result = nuRunQuery($sql); $arr = db_fetch_row($result); return $arr[0]; }
by Wesleyitguru
Thu Sep 12, 2019 12:37 am
 
Forum: General
Topic: Change ID field on save
Replies: 7
Views: 217

Re: Change ID field on save

... getEmailAddress($Id) { $sql = " SELECT `ipcamclient_email` FROM `ipcamclient` WHERE `ipcamclient_id` = '$Id' "; nuDebug($sql); $result = nuRunQuery($sql); $arr = db_fetch_row($result); return $arr[0]; }
by kev1n
Wed Sep 11, 2019 11:26 pm
 
Forum: General
Topic: Change ID field on save
Replies: 7
Views: 217

Re: Change ID field on save

... function getEmailAddress($Id) { $sql = " SELECT `ipcamclient_email` FROM `ipcamclient` WHERE `ipcamclient_id` = '$Id' "; $result = nuRunQuery($sql); $arr = db_fetch_row($result); return $arr[0]; } No Luck, something maybe missing? My coding skills are sketchy, so I've reached the ...
by Wesleyitguru
Wed Sep 11, 2019 10:55 pm
 
Forum: General
Topic: Change ID field on save
Replies: 7
Views: 217

Re: Change ID field on save

... function getEmailAddress($Id) { $sql = " SELECT `ipcamclient_email` FROM `ipcamclient` WHERE `ipcamclient_id` = '$Id' "; $result = nuRunQuery($sql); $arr = db_fetch_row($result); return $arr[0]; }
by kev1n
Fri Sep 06, 2019 10:41 pm
 
Forum: General
Topic: Change ID field on save
Replies: 7
Views: 217

Re: Execute SQL on button click

Now I have the next problem that I need to get the id of the current element and use it in the SQL. First I thought of something like this: nuRunQuery("CREATE TEMPORARY TABLE `_copy_table_temp` SELECT * FROM `dl_projects` WHERE `dl_projects_id` = '".nuLookupRecord()->dl_projects_id."';"); ...
by fpdragon
Wed Sep 04, 2019 10:36 pm
 
Forum: Custom Code
Topic: Execute SQL on button click
Replies: 6
Views: 197

Execute SQL on button click

... select a previously added SQL. But it is not possible to select any SQL from a run button. Then I tried to add a PHP Procedure and used the "nuRunQuery" function to execute every SQL line step by step. But also here I can't select the procedure from the "Run" reference selector. ...
by fpdragon
Wed Sep 04, 2019 10:13 pm
 
Forum: Custom Code
Topic: Execute SQL on button click
Replies: 6
Views: 197
Next

Return to advanced search