Assuming update is required, the following 118 results were found.
-
SYS.schemas SCh ON ST.schema_id = SCh.schema_id WHERE ST.name 'SearchTMP' GROUP BY ST.object_id, SCh.name + '.' + ST.NAME ; UPDATE @SQLTbl SET SQLStatement = 'SELECT * INTO SearchTMP FROM ' + Tablename + ' WHERE ' +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
for cURL functions enabled on server. - Fixed Bug: cURL_Init uses encoded weblink URL in case of spaces. - Fixed Bug: Auto-Update via Joomla Extension Update Manager corrected. - Date Uploaded: Wed, 4th Jun 2014 3.0.1 ThomasM- Fixed Bug: Strict...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
and the third is a 'nice-to-have' upload to the specified folder. Method #1: two requests 1. Send the media file 2. Update the name of the file you just uploaded $GAPIS = 'https://www.googleapis.com/'; function uploadFile($access_token, $file,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update 2019 This script requires a user to authenticate the google account. I have a newer article called Google Drive API v3 -...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
you can run it anyway. Additional Note(s): The trigger only runs if inserting a record. If your script is trying to modify/update a record with a value that already exists in the table, you will get an error in which case you could probably add another...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
(" v_Increment ")." A_LoopFileExt } else { break } } ; add to the list view LV_Add("", A_LoopFileName, v_NewNameWithExt ) ; update for the status bar v_RowCount++ SB_SetText("Generating entry #" v_RowCount ".") } ; auto fit columns LV_Modifycol(1,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
ms-settings:regionlanguage-chsime-pinyin Speech ms-settings:speech Wubi IME settings ms-settings:regionlanguage-chsime-wubi Update & Security Activation ms-settings:activation Backup ms-settings:backup Delivery Optimization...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
I have an integration field, if someone changes it, I want to save the value to the record immediately. Why? If you try to update an integration field via deluge with another integration field or even the same integration field, it will return an error...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the created date and time parts as well as the timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to Zoho Inventory:"; info r_UploadPhoto; You should get a response similar to the following: {"code":0,"message":"We've updated the item image. Nice one, by the way!"} Update 2024: Following Books Domain Upgrade // // ZohoBooks Organization ID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer and the problem happened...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // specify the client's own Job Opening Ref m_Create.put("Vacancy Ref",r_Data.get("Job_Opening_ID")); // // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"my_connection");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
physical reader Date Modified: 2024-05-21 (Joel Lipman) - Revamp of code as per best practices - Correct error: Check and update the code in line 74 as there is a Exception : Value is empty and 'get' function cannot be applied More Information: Navigate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
tried to make a subform equal the collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to update a time field with a string is a no go. Set it to an atom time or nice...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
auto-suggester dropdown; one of those fancy ones that includes photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE utf8_general_ci LIKE b.`CountryName` COLLATE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
published. Step Three: To finish and make it all work requires editing of a single file in the Joomla installation. If you update or reinstall Joomla you will possibly lose this modification and have to apply it again. The file that you will be editing...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF