Assuming time is required, the following 233 results were found.
-
or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with data that is expected to be in the rows (ZohoAnalytics may have issues loading a file...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
= ifnull(r_PastEvents.get("events"),List()); for each m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
more are loaded. This still gets buggy on certain mobile devices as some images are over 1Mb. So I needed a tool that every time a new product is added, a thumbnail gets generated and stored in the same application. Trawling through the first few pages...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
" + m_ThisGoal.get(v_Field); } m_OutputAll.put(v_GoalKey, m_OutputRecord); } } // // for testing I'm doing 3 records at a time if(v_CountTotal > 3) { break; } } info m_OutputAll; return ""; This should give you all the fields that will be pulled from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
a different issue), let us synchronize Zoho Surveys into Zoho Analytics. I found I need to edit the setup of the sync every time a new survey is added... but at least it lets me synchronize every hour. Then I'll write the SQL queries to get the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
a working Joomla website set up. Go to the phpBB website (www.phpbb.com) and download their latest stable release. At the time of this article, this was version 3.0.5, but RocketTheme are fully aware of this and seem to be committed to keeping their...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
category. The issue is that suppose a menuitem links to a category of weblinks, the default sort order (as in the first time you view the page) is the order in the admin panel (not even by most recent). I'm going to show you how to do this by title in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
as my previous database. New db user and password added to the new database. Downloaded and uploaded the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production folder I created earlier Pointed a...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns the local variable ID (@StudentReference) everytime. So after an hour or so I came across "Cascading...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
ms-settings:powersleep Sound ms-settings:sound Storage ms-settings:storagesense Storage Sense ms-settings:storagepolicies Time & Language Date & Time ms-settings:dateandtime Japan IME settings ms-settings:regionlanguage-jpnime Region...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
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
-
'VARCHAR') random_other, -- testing string (any char) UFN_DATASCRAMBLE(TO_DATE('01:00:00','HH:MI:SS'), 'DATE') random_time, -- testing time UFN_DATASCRAMBLE(TO_DATE('12/31/2012','mm/dd/yyyy'), 'DATE') random_date, -- testing date...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
is remote as well as the MySQL database. BIDS is on the client machine. Download and install the MySQL ODBC driver (at time of print v5.1) Visit http://dev.mysql.com/downloads/connector/ Click on "Connector ODBC" Download a version suitable to your...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
AND wikimedia_text.old_text'' AND wikimedia_page.page_is_redirect=0 -- yields: let's call it MyTable1: Query time: 0.187s. 880 rows returned. PageID PageTitle PageContent ---------------- ------------------ --------------------- 1144 7911_and_7912_t......
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
DATE(registerDate)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)); -- TREND: count yesterdays from midnight (00:00) up to the same time today SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)) AND TIME(registerDate)
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
it and then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB