Search found 371 matches: +nuRunQuery

Return to advanced search

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: 72

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: 72

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: 72

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: 72

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: 88

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: 88

Re: How the search field work.

... WHERE ((registro_task.id_operatore = '#USER_ID#')) GROUP BY livelli_view.livello )) OR (registro_task.id_operatore='#USER_ID#') ) "; nuRunQuery($s); And the Browse SQL: SELECT * FROM #TABLE_ID#
by kev1n
Sat Aug 24, 2019 6:45 pm
 
Forum: General
Topic: How the search field work.
Replies: 21
Views: 280

SQL error in nuRUNQuery when saving

... 1 ===SQL=========== UPDATE statistiques SET WHERE `statistiques_id` = '16'; ===BACK TRACE==== C:\wamp64\www\hebergement\nudata.php - line 348 (nuRunQuery) C:\wamp64\www\hebergement\nuapi.php - line 52 (nuUpdateDatabase) Think's for your help
by Wael
Wed Aug 14, 2019 5:26 pm
 
Forum: Custom Code
Topic: SQL error in nuRUNQuery when saving
Replies: 0
Views: 60

Re: Can not insert/add new record in forms

... INSERT INTO students (ID, `Name`) VALUES ('5d42e31315d2646', 'Gohar'); ===BACK TRACE==== C:\wamp64\www\nubuilder4-master\nudata.php - line 348 (nuRunQuery) C:\wamp64\www\nubuilder4-master\nuapi.php - line 52 (nuUpdateDatabase) Is there any good tutorial to follow to design the forms correctly. ...
by akhlaq58
Thu Aug 01, 2019 11:34 pm
 
Forum: General
Topic: Can not insert/add new record in forms
Replies: 4
Views: 120

Re: Button that Generates a File

... but as a procedure "run type" hidden. I've edited out the portion of the declaration of the file as PHP, edited the connection part to a NuRunQuery and removed the original "else Echo" portion of the script--but this doesn't seem to be generating the files. Below is the code ...
by Alohajoe5
Mon Jul 29, 2019 11:47 pm
 
Forum: General
Topic: Button that Generates a File
Replies: 14
Views: 468
Next

Return to advanced search