Assuming from is required, the following 413 results were found.
-
kCaptcha used by the jComments extension is easily automated and no longer blocks spam comments. How? So the main bulk came from the JoomlaTune website but as it was a forum post that may get moved/deleted, I've copied most of it and put it here with my...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
C/O Dad's (Jimmy) SampleText SampleText lowercase.text lowercase.text Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
• " ThisManyWorkingDaysMessage "`n • " ThisManyWorkingHoursMessage "`n • " ThisManyWorkingMinutesMessage Message3:="Comments from the employee performance evaluation:" If ThisMessageIndex = 0 TrayTip, ByeBU, %Message0%,10,1 If ThisMessageIndex = 1...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
prompt and type rename.bat (This does the actual renaming of the files). Type the following DELETE rename.bat (removes it from the users computer) Exit the command prompt and we are Done Other Links: DOS - String Manipulation DosTips.com - Forums...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment....
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
'&agency='.$company_id_1_agency_id. '&company='.$company_id_1. '&brand='.$company_id_1_brand_id ); // remove XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output =...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string(). The...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
the owner). In other words, ticking the owner settings under the advanced sharing settings programmatically: Prevent editors from changing access and adding new people :: Set by "writersCanShare" = false Disable options to download, print and copy for...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
the drive and display the size of all the files/folders contained within. How? So I'll be putting this program for download from the download section of this website but I don't expect anyone to trust an executable EXE so here's the code of what it's...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
to several sheets within the same workbook. Inserts a blank row at the top of each of the created sheets. Copies the header from the first sheet into the top row of each created sheet. Splits each sheet to a separate XLS file. ' Purpose: In the Excel...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
varchar(255); declare url_counter int; set original_url = new.url_alias; set url_counter = 1; while exists (select true from my_table_name where url_alias = new.url_alias) do set new.url_alias = concat(original_url, '_', url_counter); set url_counter =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
albeit as-the-crow flies. This makes use of an undocumented function in Zoho which is acos or inverse cosine. Just lifted from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for a code or use the below to generate one. Code Here you will need your own client ID and client secret generated from the developer console in the following snippet: v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234"; v_ClientSecret =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
and type: shell:appsfolder This will open your applications in explorer (much like MacOS). You can then create shortcuts from these and more importantly see the command to open them. Note that the MS Windows 10 Mail shortcut will be something like...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
first day of the month and then loop until we find a Monday. Same for the last Tuesday except that we will count backwards from the end of the month: if(input.Switch_Over_Day=="First Monday of Month") { v_NextMonthDate = zoho.currentdate.addMonth(1);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of an access token used in OAuth2.0 for an API. How? All with deluge but we will split the date and time value obtained from a CRM field and compare it to the current time combined with a timezone. In this particular case, we will switch the current...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for each r_UserDetails in l_MatchingUsers { info r_UserDetails.get("id"); } List CRM Users (ActiveUsers) from Creator or other Zoho App Note the use of .toMap() required for other apps to read this JSON string response: l_Users= List(); m_UserType =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF