Assuming current is required, the following 58 results were found.
-
to store the data m_UpsertCrmQuote.put("Xero_Ref_ID",m_ThisQuote.get("QuoteID")); m_UpsertCrmQuote.put("Xero_Updated",zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss",v_ZohoTimeZone)); // // -------------------------------- Quote Customer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
permissions. Sign in as the Super Admin in Zoho Books. Feed management options can be hidden for standard admins. Check the current feed. Go to Banking > Selet the active account (click into it) and click the gear icon in the top right of this page (not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
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: *
-
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: *
-
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: *
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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: *
-
them even if I have checked what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name it "MaxRecentDocs"...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
-- next Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both saturday and sunday returned week ending date as next week). If you were...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB