Assuming update is required, the following 124 results were found.
-
Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
)); $db->setQuery($query); $result = $db->query(); -- retrieve last inserted ID $last_inserted_id = $db->insertid(); UPDATE using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the screenshots are censored for confidentiality...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and programmatically....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"123456789012345678" with the product "987654321098765432" and p_InvoiceID is the ID of the invoice record: v_Index = 0; m_Update = Map(); l_ProductItems = List(); r_InvoiceDetails = Map(); r_InvoiceDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a function that generates an access token of the Trading API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates item/contact/sales...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
completes and signs the form via ZohoSign ZohoSign on completion triggers worklow from within ZohoCRM ZohoCRM webhook updates the tracking record (ZohoSign Document) and attaches the signed document to the contact record Button Code: /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses vs your CRM Invoice Statuses...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 1; b_Debug = false; // // Login to Xero > Accounting > Accounting Settings >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
INTO `#_workflow_associations` (`item_id`, `stage_id`, `extension`) SELECT `id`, 1, "com_content.article" FROM `#_content`; UPDATE `#_content` SET `checked_out`=NULL, `checked_out_time`=NULL; Viewing Users in the Administrator panel: UPDATE `#_users`...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
@NumberLeft INT DECLARE @random INT DECLARE @CurrentID INT DECLARE @ScrambledID INT DECLARE @Data VARCHAR(MAX) DECLARE @UpdateData VARCHAR(MAX) DECLARE @Chosen BIT DECLARE @ChosenID INT DECLARE @SqlStatement NVARCHAR(MAX) DECLARE @UpdateSqlStatement...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
// com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, update or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query = $db->getQuery(true);...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET 'balance' =...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
red herring ahead] For this process, we setup connections choosing to make use of the Zoho People API and we could update any of the fields EXCEPT for "ApprovalStatus" and would get the following response when attempting: { "response": { "message":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// create link r_Link = zoho.crm.createRecord("Tests_X_Contacts", m_Link); } Code to Add a value to a multi-lookup (on Update Record): v_DealID = ifnull(input.p_DealID,0); if(v_DealID != 0) { m_Link = Map(); m_Link.put("Deal", v_DealID);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
only found this an issue when using REST API v2.1 but also to show you how to configure triggers when using createRecord or updateRecord. Why? We had a Creator app updating a CRM record which in turn had a workflow to update the Stage in Creator (so a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
URL Syntax #5 [image]: Update 2023 Again this example doesn't include the publish key but can be used across apps in Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
r_Users = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_UserUpdates = List(); for each m_User in r_Users.get("users") { v_CurrentSignature = ifnull(m_User.get("signature"),""); // // criteria, only update signatures which aren't done?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF