Differences

This shows you the differences between two versions of the page.

--- v5:reference:loadbalancer:getconnection [2017/05/11 00:49] – [Usage] mnewnham
+++ v5:reference:loadbalancer:getconnection [2017/05/11 00:51] (current) – [Usage] mnewnham
@@ Line 68: / Line 68: @@
 /*
-* Now construct a stored procedure and execute it against $db
+* Now construct a stored procedure and execute it against $db,
+* because it is pinned, it will execute against the 'write' node
 */
+$stmt = $db->PrepareSP('kmnProc');
+$val1 = 'ADMIN';
+$par1 = 'users';
+$db->InParameter($stmt,$val1,$par1);
+$db->OutParameter($stmt,$ret,'RETVAL');
 </code>