Assuming between is required, the following 70 results were found.
-
This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
`mysql_reserved_word`=my_alias $string_formatted = preg_replace ( '/`([^`]+)`/', '$0', $string_original ); Replace contents between two tags ( ) Convert: my outside string is now inside » my outside string is now inside $string_formatted =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
A quick article to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution that will distance following roads and the such but.. the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
from the weekstructure table based on the given date SET @setId = (SELECT TOP 1 SetId FROM WEEKSTRUCTURE WHERE StartDate BETWEEN DATEADD(day, -6, @specifiedDate) AND DATEADD(day, 6, @specifiedDate)) SET @weekNumber = (SELECT TOP 1 WeekNumber FROM...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Why? This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
windows, much like the start menu/task bar (only this program is beneath the task bar). It's currently set to 15 seconds between each photo and it happily did my 153 (has done a few times over quite quickly due to testing). Options/Features Source...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
to either put the value or your empty row. Here's an example of the query for a timetabling solution with spacing rows between days. This worked ok but pay special attention to Stage #3 afterwards otherwise if you stop in Stage #2 you'll be missing...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
A quick article on how to setup an automation that checks if a datasource synchronization between Zoho People and Zoho Analytics failed. This can be adapted to any data source for Zoho Analytics. Why? We're assisting a client implement Zoho People as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
SELECT CONCAT(MONTHNAME(a.DateTimeStamp), ' ', YEAR(a.DateTimeStamp)) Month, SUM(IF((HOUR(a.DateTimeStamp) BETWEEN 8 AND 18), 1, 0)) 'Worktime', SUM(IF((HOUR(a.DateTimeStamp) BETWEEN 8 AND 18), 0, 1)) 'Out-of-Hours', COUNT(VisitorIP) 'Total Hits' FROM...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
-- rather than running this entire script in one go but do try to run the -- whole script as it maintains associations between users and content. -- Reminder: backticks have been used on reserved words so that this SQL -- script runs on systems that do...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName WHERE ItemDate BETWEEN '01/01/2010' AND '08/01/2011' GROUP BY DATEPART(dayofyear, ItemDate), DATEPART(year, ItemYear), ItemName // yields something...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
it by pressing the windows key () and tab () at the same time. It will give you a 3D effect that will allow you to “Flip” between the different windows. Keep holding the Microsoft Logo key and pressing the Tab key to rotate between the different...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html
to a time value with milliseconds showing. Now why don't these match? Using in an aggregate, how do I get the milliseconds between start and end times instead of summing the remaining columns? Correction, sum will only give me the total time but what if...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
this works. IMPORTANT! Make sure you have prefixed the parameter name with an at sign and surrounded the input parameter between square parameters, example: [@StudentReference]. Fixing this resolved all 3 issues below!!! Encountered Issues ORA-01403 no...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
high relevance to articles where the search term is found in the title. \plugins\search\content\content.php: Insert this between the if ($sContent && $limit > 0){ and before the from part of the query $query->from('#__content AS a'); // Add "Relevance"...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
expression: a{3,} This expression matches all of the following: aaa aaaaa The expression does not match: aa Interval — Between Count You use the between-count interval operator to search for a number of occurrences within a specified range. For...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
cursor where you want the carriage return and press Return/Enter. This has to be a label to the name of the column enclosed between square brackets or double-quotes: Before: SELECT calendar.WeekNumber AS [Academic Week], calendar.Monday,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *