Assuming between is required, the following 72 results were found.
-
this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
extra based on the further feedback, if we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year the week is in. Weeks which overlap...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
The supported operators are equals, starts_with, in, not_equal, greater_equal, greater_than, less_equal, less_than and between. The supported data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
]; for each m_Event in r_Events { if(m_Event.get("id") != null) {... do stuff } } Source(s): Zoho Deluge: Difference between isBlank(), isNull() and isEmpty() functions
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
contacts, accounts, and products on-the-fly as well as recording payments and checks as to which record is more up to date between ZohoCRM and Xero. How? The access token is generated by a function documented in my previously mentioned article Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
that this error isn't resolved by just changing the Mailer (Joomla > Global Configuration > Mailer settings). Alternate between PHPmail and sendmail just to check this isn't the problem. If the problem is still there then check the below: Tried both...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
a search term, and press Enter. Performs a search using the search engine associated with the URL. Type the part of a URL between 'www.' and '.com', then press Ctrl+Enter. Adds www. and .com to your input and open the resulting URL. Type a URL, then...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
cat "${CRONDIR}"/* | clean_cron_lines >>"${temp}" # */ # Add each user's crontab (if it exists). Insert the user's name between the # five time fields and the command. while read user ; do crontab -l -u "${user}" 2>/dev/null | clean_cron_lines | sed...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
// send the final code to the wiki } Amend your skin files Amend your skins to include the reference to this script in between the head tags of every page, so Amend your LocalSettings.php file Add the following the the LocalSettings.php file in your...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Excel connection you cannot skip Nth rows." "It is not possible." I am shocked at how responses to this and opinions vary between "Microsoft Certified Professionals", just a piece of paper and proof you're good at theory IMO, no credit for being the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
row numbers). The first row being of all rows in the dataset and not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
= '2', Tooltip='Some more details' ) SELECT * FROM Times t LEFT OUTER JOIN Events e ON CONVERT(VARCHAR(8) , t.Time, 108) BETWEEN e.EventStart AND DATEADD(minute, -1, e.EventFinish) --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Using encryption This one activates SSL encryption for all data sent between the client and server. The server needs to have a certificate installed. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true; This option...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
day where given a set of breadcrumb hyperlinks, when I hover the mouse over the links, the text changes and the transition between the two is controlled smoothly. Why? At time of print, I couldn't find any clear example demonstrating this so here's my...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
0,'left': 0,'height': v_win_height,'width': v_win_width }); }); }); }); Known Issues If the end-user clicks too quickly between slides, the slides are not ready or not in the right position until after 1 second --> reduce transition duration? No...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
removes numeric entities? $str = preg_replace('//i', '', $str); // removes MS Office style html comments (and everything in between) $str = str_replace(array("\r\n", "\r", "\n", "\t"), ' ', $str); // remove carriage returns, line feeds, tabs and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
or htmlspecialchars PHP functions. My database stored the foreign characters as they were so the fault was somewhere between PHP reading from MySQL to displaying the characters on the webpage.
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
side will need a few seconds only - then simply slide it out of the pan onto a plate. Stack the pancakes as you make them between sheets of greaseproof paper on a plate fitted over simmering water, to keep them warm while you make the rest. To serve,...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
Step 3: Drop Drop globs of dough, by rounded tablespoons, onto an parchment paper-lined cookie sheet. Leave about 2 inches between cookies - they'll spread out when they bake. Step 4: Bake Bake your cookies about 8-10 minutes, until they're golden...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *