Assuming current is required, the following 58 results were found.
-
Extracting the attribute: Here we want to extract an attribute value SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/CURRENT_EMPLOYEE/@financialyear)') AS INT(4)) AS FinancialYear FROM [dbo].[XML_EVENTS] -- Returns attribute "financialyear" of...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
In this case, I want to display the current month with today highlighted. As I was trying to get my head round writing this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code....
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
// get number of network card interfaces DllCall("iphlpapi\GetNumberOfInterfaces", "UintP", nIf) MsgBox % nIf... // get current process ID ProcessID := DllCall("GetCurrentProcessId")
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
for performance and compatibility with future AutoHotkey releases. #SingleInstance Force ; Skips the prompt that a current instance is running and overwrites this one with a fresh instance of this program SendMode Input ; Recommended for new scripts due...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
is just a dummy file which should be empty for clarity results_file.txt is the resulting file, it will be created in the current working directory. Above and Beyond: Add to your Context Menu My absolute laziness drives me to write the instructions on...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
{ English_Ordinal = Ordinal_Map.get(My_Date_Field.toString("d")); } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
} l_UpdateLineItems.add(m_LineItem); } // // now update the current invoice with the sales order details m_UpdateInvoice = Map(); m_UpdateInvoice.put("line_items",l_UpdateLineItems); m_UpdateInvoice.put("reference_number",v_NewRefNum);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in the row . = ; . = ; // insert the row into the collection .insert( ); // insert the collection into the subform on the current form input..insert( ); // or insert the row(s) into the subform through the record variable r_LeadDetails = Leads[ID ==...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
It will then initialize some NPM dependencies and it will ask you to type the following commands; to change current directory to the app directory and then to run the toolkit cd joels_awesome_app zet run The terminal response will advise that it is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as well as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
> 0) { //info "Access Token Expires at: " + r_Api.Access_Token_Expiry; v_Output = r_Api.Access_Token; // // zoho.currentttime can be server time as this function will check expiry against the server time anyway if(zoho.currenttime >=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
p_Page, int p_PerPage) { /* Function: fn_eBayQuery_GetActiveProducts() Purpose: Fetches current listings / active products Date Created: 2021-10-13 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
America/St_Barthelemy America/St_Johns America/St_Kitts America/St_Lucia America/St_Thomas America/St_Vincent America/Swift_Current America/Tegucigalpa America/Thule America/Thunder_Bay America/Tijuana America/Toronto America/Tortola America/Vancouver...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the source of truth and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than 100 products are modified in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // set first and last name v_FirstName = "BILLIE-JO"; v_LastName =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= ZDK.Page.getField('Weight_kg').getValue(); // count if more than 2 decimals, then round it to 2 decimals else use the current value var v_ProductWeightFormatted = fn_CountDecimals(v_ProductWeight) > 2 ? parseFloat(v_ProductWeight).toFixed(2) :...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
on every page. The key point is the HTML attribute zcpage-footerhtml; but note the 3 other CSS classes zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
timestamp indicating when eBay user made the data deletion request notification.publishDate timestamp indicating when current notification was sent notification.publishAttemptCount integer indicating how many times the notification has been sent to this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the data m_UpsertCrmInvoice.put("Xero_Ref_ID",m_ThisInvoice.get("InvoiceID")); m_UpsertCrmInvoice.put("Xero_Updated",zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss",v_ZohoTimeZone));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *