Assuming current is required, the following 55 results were found.
-
= l_CsvLines.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename); f_CSVFile.setParamName("file"); Get current file name (optional) To check on filename changes, I run this bit of code to get the internal and current file name: // // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- 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
- Language: *
-
GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html
JoelLipman.com does not warrant that product descriptions or other content of this site is accurate, complete, reliable, current, or error-free. If a product offered by JoelLipman.com itself is not as described, your sole remedy is to return it in...
- Type: Article
- Author: Joel Lipman
- 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
-
Based on the assumption that "Series1" displays on my chart because of values that are not matched (not assigned to a current individual) in the joining tables: Return to the Design interface (F8) Right-click on your dataset (in my case: DataSet1)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
DECLARE @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate)...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
use the queries in this script (Live and Upgrade). -- INSTRUCTIONS: -- #1 Replace "my_old_database.jos_" to the existing & current database -- including the table prefix (Joomla 1.5.x). -- #2 Replace "my_new_database" to the name of the new/upgrade...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID WeekNumber StartDate --------- ---------------- ----------------------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- 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
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
to the previous row, all I do is say display this value or display a blank value based on if this is a marked row (current row is different to previous row)... Stage #3: Use dummy separator row Thinking logically, Stage #2 overwrites data in the last...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(NOW()); -- BEFORE: count yesterdays total SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
are two options here: Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries started. IIF your result...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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: *
-
BEGIN TRY BEGIN TRANSACTION A DECLARE @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...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the Command prompt (DOS) wouldn't stick...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
those could be re-downloaded on to the new phone (not fun). The Apple documentation iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
that date occurs in. How? The example below shows how to do this when your weeks being/commence on Monday. It also uses the current date in the form of NOW() but this example has to work with any given date. First of all: Get this week's dates and days:...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
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: *
-
calling XML /* 201411041253 */ private String hangar_aircraft_name; public void editHangarAircraftName(View view) { // get current value for hint TextView currentName = (TextView) findViewById(R.id.hangar_aircraft_001_header); hangar_aircraft_name =...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Android Studio (Beta) 0.8.9 Android Google Maps v2 What? A sequel to my article "Basic Android App using Google Maps and Current Location", this article suggests how to add Map as a sub activity. Note that this article is based on a new blank project...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF