Assuming above is required, the following 179 results were found.
-
for the webhook in ZohoCRM: Login to ZohoCRM > Setup > Functions > and hover the mouse over the function you just created above (eg. Fn - ZohoSign - Document Completed) Hover the mouse over the ellipsis that appears and select "REST API" Then click on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} return v_OutputMessage; } Caveat(s): Tax rates have to have the same name in both CRM and Xero The code above is for EU / UK clients only (change the TLD as applicable) The code above accounts for clients not using the Items module and only the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Log into the phpBB3 Administration Control Panel. Based on the phpBB3 installation instructions above, this should be something like http://www.mysite.com/phpBB3/adm/. Click on the 'General' tab, look at the "Server Configuration" section and click the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
.', ordering':' ORDER BY title ASC'; To sort by another value on page load To do this, change the word 'title' in the above code to one of the following values: id => sort by ID catid => sort by Category ID sid => ? dunno title => by web link title...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
'' AS `otep`, 0 FROM `v25_db`.`v25_users` WHERE `id` @v25_admin_id; -- To import any new users on golive date -- -- same as above but change the last line to "WHERE `id` > ####" -- -- where #### is the last ID in the new v34 system. -- -- NB: Don't...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
commenters and viewers :: Set by "copyRequiresWriterPermission" = true To do this, set the metadata to the following in the above function: { "name": "'.$name.'", "parents": ["'.$folder.'"], "description": "'.$desc.'", "copyRequiresWriterPermission":...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
assertion in this case resulting as a combination of the header, data and signature): Using the JWT header, and claim set above, along with the private key, we'll openssl sign this with sha256. The output will be a full JWT: base64 encoded, URL-safe,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close Date & Time]...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
do with this. We could add a row with a SELECT UNION statement but I found this can be resolved by adding a counter, so the above becomes: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] ,1 Counter FROM [ROOMEQUIPMENT] re INNER...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
student always has a "Student Reference" but not necessarily a student AD account (enquired/applied only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday, calendar.Friday FROM calendar -- yields as above: -- Academic Week Monday Tuesday Wednesday Thursday Friday -- ---------------- ----------- ----------- -----------...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
A009 08:00 17:00 Separator Marker */ As I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, I now need to add an...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
LEFT JOIN DMExtractReferenceTable r1 ON e1.CodeType=r1.MapIn So simply change the "=" to a "LIKE". Scenario #2 So when the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the -- Employee Number concatenated with a 2 digit sequence -- number (padded with zeros) How? So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
lowercase.text lowercase.text Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples above because the function...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a local report within BIDS connecting to remote servers. If you want the report to be...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
(formats, defaults and vulnerability) Check ALL server-side errors EventViewer (if Windows) errors.log (if Linux) Above and beyond Product Handover (branded pack with contact details - make it simple and friendly!!!) Warranty / Grace Period (agreed...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
a prefix with a word which is fully opaque */ ul.breadcrumb a:hover span:before { opacity:1; content: 'More '; } /* Same as above but different prefix for this particular link */ ul.breadcrumb a.home:hover span:before { opacity:1; content: 'Return to ';...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *