Assuming last is required, the following 98 results were found.
-
This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
+ v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
:v_CaptureIntentEndpoint type :POST parameters:m_CaptureParams headers:m_Headers ]; // // get card details (we need to store last 4 digits) v_StripeReference = ""; v_Last4Digits = ""; v_ZB_InvoiceID = 0; m_Charges =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
"_Global". At the same level, create another folder called "Profile Photos". Navigate into the "_Global" folder and note the last hash in the URL (after "/folders/") For this function, I have a connection called "zworkdrive" which has the scopes as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the health of the system. Why? The use-case here is to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
m_SurveyBody.get("Number_of_Employees")); m_CreateAccount.put("Turnover", m_SurveyBody.get("Last_Years_Turnover")); r_CreateAccount = zoho.crm.createRecord("Accounts", m_CreateAccount); info "Creating CRM Account: " + r_CreateAccount;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be done as the last step of this migration. Rename admin ID in the UPGRADE database We want to make sure that the new user ID doesn't exist in our...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run Last Week Run This Week ------------------ ----------------- ------------------- Report 001 5 2 Report 002 11 47 Report 003 7 61...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
so that all the weeks correspond to the rest of the academic data. Unfortunately the developer wrote a system he felt would last the rest of his PhD degree, it's a shame he started in his last year. He used functions to mktime and simulate the dates. A...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: --...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
m_Response = Map(); v_Message = message.trim(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime = zoho.currenttime.subMinutes(v_MinutesAgo).toLong(); v_TillTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
files older than n days/date. /MINAGE:n :: MINimum file AGE - exclude files newer than n days/date. /MAXLAD:n :: MAXimum Last Access Date - exclude files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
v_ContactFname = r_ContactDetails.get("First_Name"); v_ContactSname = r_ContactDetails.get("Last_Name"); v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= inv."Invoice ID" WHERE inv."Invoice Status" NOT IN ( 'Draft' , 'Void' ) GROUP BY invitm."Item ID", invitm."Quantity" And lastly we can group by invoices in the month and sum up the profits as well as include the customer name and other invoice...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
v_CsvRow = l_CsvFileRow.toString(); l_CsvFileRows.add(v_CsvRow); // // note the cursor so that we resume from the last cursor v_Cursor = r_Node.get("cursor"); // // output to console for debugging purposes info "Page #" + v_Page + "::" + v_CountTotal +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
m_Create.put("Owner", v_LoggedInUserID); r_Create = zoho.crm.createRecord("GPT_Chats", m_Create); // // add the last question to the messages m_Chat = Map(); m_Chat.put("role", "user"); m_Chat.put("content", v_UserMessage);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
File downloads to their workstation Here's what's happening in the background: File is generated FIle is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= Map(); // // build quote request m_QuoteRecord.put("Name.first_name",v_SellerName_Firstname); m_QuoteRecord.put("Name.last_name",v_SellerName_Lastname); m_QuoteRecord.put("Email",v_SellerEmail); // // other params m_Blank = Map(); // // send the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
check URL for mail merge template: https://writer.zoho.eu/writer/open/ 0) { v_Filename = v_Filename.subString(0,v_Filename.lastIndexOf(".")); } r_ZS_Download.setFileName(v_Filename + "_SIGNED.pdf"); // // attach file to record of module r_AttachFile =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to do this nor if writer will just allow us to embed it... but let's give it a go: The page responses query showing only the last survey attempt per respondent I'm going to modify the analytics query above to only return the latest responses that a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *