Assuming execute is required, the following 40 results were found.
-
of the person running the report. This second page is called "HouseKeepForm". We have a 3rd report which will actually execute the stored procedure called "HouseKeepExec". The Problem We get the above error if we tried to execute the stored procedure...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a message. How? We use a database account with read-only privileges to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This requires using 2 data...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
array('Content-Type: '.$mime_type, 'Content-Length: ' . filesize($file), 'Authorization: Bearer ' . $access_token) ); // execute cURL request $response=curl_exec($ch1); if($response === false){ $output = 'ERROR: '.curl_error($ch1); } else{ $output =...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
INTO #Scramble SELECT NULL,' + @ColumnName + ',NULL FROM ' + @TableName + ' WHERE ' + @WhereClause INSERT INTO #Scramble EXECUTE (@SqlStatement) -- To dynamically create a cursor SET @UpdateSqlStatement = ' SET @UpdateCursor = CURSOR FOR SELECT ' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
in libraries\joomla\database\database\mysql.php on line 344 INSERT using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->insert($db->quoteName('#__my_users'))...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers when Status is "Paid" Just once or every time is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Function: fn_Shopify_Webhook_OrderUpdate Label: Shopify - Webhook - Order Update Trigger: Function executed when a webhook from Shopify is sent to ZohoCRM (Order Update) Inputs: String crmAPIRequest Outputs: String crmAPIResponse Date Created:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html
VK_HOME = $24 Const VK_LEFT = $25 Const VK_UP = $26 Const VK_RIGHT = $27 Const VK_DOWN = $28 Const VK_SELECT = $29 Const VK_EXECUTE = $2B Const VK_SNAPSHOT = $2C Const VK_HELP = $2F Const VK_0 = $30 Const VK_1 = $31 Const VK_2 = $32 Const VK_3 = $33...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and grant execute for your SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
v_CrmRestFunction = "https://www.zohoapis.com/crm/v2/functions/fn_ebay_webhook_ordernotification/actions/execute?auth_type=apikey&zapikey=1003.aaaabbbbccccddddeeeeffff11112222.33334444555566667777888899990000"; // // build header m_Headers = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Invoice Line Items...' }); // reset the subform of Invoiced Items ZDK.Page.getField('Invoiced_Items').setValue([]); // execute REST API function with parameters var o_Params = {}; var o_Headers = {}; o_Params.p_QuoteID = v_QuoteID; o_Params.auth_type =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
going to add some element IDs to the canvas view page on each of the tabs. Then we'll make an OAuth function that can be executed by the client script which returns the value of the Pipeline given a deal record ID. Finally, we'll have client script...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for the function call var m_Params = { "arguments": JSON.stringify({ "p_AccountID": v_EntityID }) }; ZOHO.CRM.FUNCTIONS.execute( v_FuncName, m_Params ) .then( function( r_SubData ){ console.log("Raw response:", r_SubData); // Check if the response...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the Journey Builder feature). If "trigger" is not mentioned, the automation actions related to the API will get executed. Enter the trigger value as [] to not execute the workflows. [1] To remove or delete a line item when using invokeURL and the PUT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and sendmail So if this happens irrespective of whether I have PHP mail or sendmail set as the Mailer. Notice Could not execute: /usr/sbin/sendmail Warning Registration failed: An error was encountered while sending the registration email. A message has...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
of a solution considering the ReportServer database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Permissions CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad TO a_more_casual_user; Yay for me So this is the basic Oracle stored procedure. Now to...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
as RandomValue; GO The Function Again you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF OBJECT_ID...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default values SET @TableName = SUBSTRING(@SchemaTableName, CHARINDEX('.',...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF