Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming name is required, the following 277 results were found.

  1. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    mechanism so you would have to refer to the output without this column before modifying the query to include the page names of your survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  2. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    I'm rewriting their instructions here so that I can I do this on other websites: Important Note: On Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

    Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` // from www.myexample.com to dev1.myexample.com where `option_name`='home' change...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  4. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on 'FINISH' This will produce a HTML, SWF, XML and JS file in the output directory. We only want the SWF and JS file....

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  5. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID (request reference) number. The Report We start off with our detailed report...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    the Reporting Server ExecutionLog? Using the ReportServer Execution Logs, we can determine if this is correct SELECT TOP 1 c.Name, e.TimeStart, e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  8. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    Select HKEY_USERS Go to the menu File and select Load Hive Navigate to that user's profile folder, usually C:\users\username in this case Users > Guest Enter NTUSER.DAT in the File name box. (This file is a system-hidden file, so it won't show up in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. Reorder Columns in a Tablehttps://www.joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  10. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID Name EmpType CodeType 1 Joe Manager 0011 2 John Tape-Monkey 8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  11. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    to return a single value, which is all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  12. JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

    what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJComments has a deprecated constructor in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  13. Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/component/content/article/autohotkey-chrome-profiles-in-alphabetical-order.html?catid=48&Itemid=165

    to open the profile. As an overview: Setup a standard AutoHotkey GUI Loop through Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and extract value. Hide the first column in the list view...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  14. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    There are several types of punishments: Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong or whether a warning is necessary to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  15. Prefix Line Numbers in a Text Filehttps://www.joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

    - change this to the number of lines or greater in your file) original_file.txt is your original file (obviously change the name to your file) temp.txt is just a dummy file which should be empty for clarity results_file.txt is the resulting file, it...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  16. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    straightforward, Login to ZohoCRM as Administrator > Setup > Developer Space > Connections > Add Connection > Give it a name and then select Scopes > and get ERROR_invalid_operation_type Solution: Remove some scopes and test. The likely ones you want...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    check your URL is correct. The format for API v2 is: https://www.zohoapis.{eu or com}/crm/v2/settings/fields?module={module-name} You can then use the following snippet to get all the fields for the module. In our case, for "Invoices": /* Function:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    on an embedded form on the popup would need to apply specifically to the contents in the popup. Find the modal or popup name to isolate these from other CSS tags sharing the same name. Alternative Solution Some of you may be asking why not use openUrl...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-deluge-to-submit-custom-fields.html

    Let's assume that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  20. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    from the third-party API, let's go through the CRM picklist options to find the relevant one if(!isnull(r_Timezone.get("zoneName"))) { v_TimeZone = r_Timezone.get("zoneName"); // // get all the fields on the Lead module v_Endpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 141 - 160 of 277