Assuming number is required, the following 157 results were found.
-
which I had previously used for the migration of a HR system. This is intended to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is a very quick article on sending an email with Deluge which needs a dynamic number of files attached to it. Why? This came up during a call with another developer and it occurred to me that perhaps this isn't clearly documented. But there are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
value: (Last_Name:equals:K\\) After encoding the value: (Last_Name:equals:K%5C%5C) To search for Date, DateTime, Lookup, Number, Currency, Boolean fields, you need comparators other than starts_with and equals. Source(s): Zoho CRM Documentation - Record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
footer on every page. The key point is the HTML attribute zcpage-footerhtml; but note the 3 other CSS classes zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
this is also referred to as the pricelist... and vice-versa. And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the price book...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
with the sales order items based on the custom lookup field: SELECT po."Purchase Order ID" AS "PO ID", po."Purchase Order Number" AS "PO Ref", po."Purchase Order Date" AS "PO Date", po."Purchase Order Status" AS "PO Status", poi."Item Name" AS "PO...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
cog icon in the top-right for "Settings" You should be in the "Organization Settings" Your Org ID is in the URL as the last number after the slash /org-details/###### (eg. "123456789") Note this down for later use Create a connection to Zoho Analytics:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
#main-background {background: url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat;} where 1 is the number of the style of the template I am setting the background for and I add the "fixed" attribute to this id. This will yield the following:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The Issue Basically that after upgrading Joomla, my TinyMCE WYSIWYG (What-you-see-is-what-you-get) editor halved its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
MySQL Oracle equivalentshttp://mail.joellipman.com/articles/database/mysql-oracle-equivalents.html
Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of days in this month.
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
and MY_SHAREPOINT_SITE accordingly). The moon to play with /_layouts/people.aspx?MembershipGroupId=# where # is the ID number of the group (will error on invalid IDs).
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
What? So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
SELECT ps.person_id, ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference as personid, row_number() over (order by pa.last_modified_date desc) r from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' )...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
WHERE [S_SURNAME] NOT LIKE '%[a-zA-Z0-9]%' -- returns all rows where the student surname does NOT contain a letter or number -- eg. O'Brien will NOT be returned as it contains letters MySQL And my favorite. Note the circumflex as we are still excluding...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time of print), I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF