Search found 402 matches: +nuRunQuery

Return to advanced search

Re: Date/Time from server

Hi marc,

Run a PHP procedure with nuRunPHPHidden() that retrieves the time from the SQL Server.

See this topic:
viewtopic.php?f=6&t=7841&p=9842&hilit=nurunquery+now+time#p9842

use nuJavascriptCallback to pass the time to the client.
by kev1n
Sun May 17, 2020 5:29 pm
 
Forum: General
Topic: Date/Time from server
Replies: 1
Views: 394

There are no bookmarks on the main form (ubuntu)

... = 'nudebug' GROUP BY syt_zzzzsys_form_id, syt_title ORDER BY syt_order ===BACK TRACE==== /var/www/report/nuform.php - line 737 (nuRunQuery) /var/www/report/nuform.php - line 86 (nuBuildTabList) /var/www/report/nuapi.php - line 42 (nuGetFormObject)
by kknm
Thu Apr 16, 2020 8:45 am
 
Forum: Custom Code
Topic: There are no bookmarks on the main form (ubuntu)
Replies: 3
Views: 356

Re: Subform with specific numbers of records

... // count how many raws has subform for specific record $s = "SELECT COUNT(*) AS qty FROM connection WHERE con_part='#parts_id#'"; $t = nuRunQuery($s); $qty = db_fetch_object($t)->qty; // set up the addable value for the subform depending on the quantity value if ($qty>10) {$s = "UPDATE ...
by Janusz
Tue Mar 31, 2020 5:09 pm
 
Forum: General
Topic: Subform with specific numbers of records
Replies: 18
Views: 1219

Re: Version Problem

... Notice: Undefined index: sessid in C:\xampp\htdocs\nubuilder4\nuindexlibs.php on line 4 Fatal error: Uncaught Error: Call to undefined function nuRunQuery() in C:\xampp\htdocs\nubuilder4\nuindexlibs.php:7 Stack trace: #0 C:\xampp\htdocs\nubuilder4\index.php(4): require_once() #1 {main} thrown ...
by GlenMcCabe
Wed Mar 11, 2020 9:00 pm
 
Forum: General
Topic: Version Problem
Replies: 6
Views: 985

Re: Sum values by date-range

... form_1 WHERE booking_date BETWEEN from_booking_date AND to_booking_date GROUP BY 1, 2 "; $sql = "CREATE TABLE #TABLE_ID# ".$sql; nuRunQuery("$sql"); Browse SQL: SELECT * FROM #TABLE_ID# Table structure I used for this demo: TABLE `form_1` `booking_date` date NOT NULL, ...
by kev1n
Thu Feb 27, 2020 12:54 am
 
Forum: Custom Code
Topic: Sum values by date-range
Replies: 8
Views: 1259

Re: How to subtract dates to calculate nights

... for the right syntax to use near 'WHERE 1' at line 2 ===SQL=========== SELECT WHERE 1 ===BACK TRACE==== /volume1/web/ISEA/nuform.php - line 350 (nuRunQuery) /volume1/web/ISEA/nuform.php - line 331 (nuBrowseTotals) /volume1/web/ISEA/nuapi.php - line 42 (nuGetFormObject) Can it have a consequence? ...
by kev1n
Tue Feb 25, 2020 5:56 am
 
Forum: General
Topic: How to subtract dates to calculate nights
Replies: 45
Views: 5560

Re: How to subtract dates to calculate nights

... for the right syntax to use near 'WHERE 1' at line 2 ===SQL=========== SELECT WHERE 1 ===BACK TRACE==== /volume1/web/ISEA/nuform.php - line 350 (nuRunQuery) /volume1/web/ISEA/nuform.php - line 331 (nuBrowseTotals) /volume1/web/ISEA/nuapi.php - line 42 (nuGetFormObject) Can it have a consequence?
by joecocs
Tue Feb 25, 2020 12:40 am
 
Forum: General
Topic: How to subtract dates to calculate nights
Replies: 45
Views: 5560

Re: Bottom height (sub)form

... function nuFormDimensions() in nuform.php with this one (taken from an older nuBuilder version). function nuFormDimensions($f){ $d = array(); $t = nuRunQuery("SELECT * FROM zzzzsys_form WHERE zzzzsys_form_id = '$f'"); $r = db_fetch_object($t); $bt = 57; //-- browse title $rh = intval($r->sfo_browse_row_height) ...
by kev1n
Sat Feb 08, 2020 2:45 am
 
Forum: General
Topic: Bottom height (sub)form
Replies: 12
Views: 2110

Re: Problem with nuProcedure in new version

... exist. I think nuProcedure() should look like this: function nuProcedure($c){ $s = "SELECT * FROM zzzzsys_php WHERE sph_code = ? "; $t = nuRunQuery($s, [$c]); if (db_num_rows($t) > 0) { // procedure exists $r = db_fetch_object($t); $php = nuReplaceHashVariables($r->sph_php); $php = "$php ...
by kev1n
Thu Feb 06, 2020 8:49 am
 
Forum: Custom Code
Topic: Problem with nuProcedure in new version
Replies: 7
Views: 1385

Re: Problem with nuProcedure in new version

... that change in nucommon.php: Replace this function function nuProcedure($c){ $s = "SELECT * FROM zzzzsys_php WHERE sph_code = ? "; $t = nuRunQuery($s, [$c]); $r = db_fetch_object($t); $php = nuReplaceHashVariables($r->sph_php); $php = "$php \n\n//--Added by nuProcedure()\n\n$"."_POST['nuProcedureEval'] ...
by kev1n
Thu Feb 06, 2020 8:35 am
 
Forum: Custom Code
Topic: Problem with nuProcedure in new version
Replies: 7
Views: 1385
Next

Return to advanced search