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 cursor is required, the following 33 results were found.

  1. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

    to get the template ID used in CRM, but we did this by Login to ZohoCRM > Settings > Templates > Inventory Hover the mouse cursor over the template you want to use. Note or screenshot the url that pops up and the template ID is at the end of it.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    Estimate Notification Many ways to add a button but here's how I do it (requires some basic HTML/CSS knowledge): Place the cursor where you want the button and give it some text, I'm going to start with Accept Quote Then click on the link icon and give...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    clicking OK: If you are not prompted, you should see some of your code go red like in the following screenshot: Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  4. Include a carriage return in a column headinghttps://joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    to do this in the name of the column heading, the answer is a much simpler one, in your SQL statement, simply place your 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  5. Windows 7 Aero Featureshttps://joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    Internet Explorer which is very handy, but unfortunately it doesn’t work in Firefox or Chrome as yet You can also move your cursor to the lower right corner of your screen to get a preview of your desktop, click and you will be brought to your desktop...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  6. Windows 10: Shortcut Apps to Settingshttps://joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Closed captions ms-settings:easeofaccess-closedcaptioning Color filters ms-settings:easeofaccess-colorfilter Cursor & pointer size ms-settings:easeofaccess-cursorandpointersize Display ms-settings:easeofaccess-display Eye control...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  7. Search a database with SOUNDEXhttps://joellipman.com/articles/else/database/search-a-database-with-soundex.html

    SET @myCounter = 0; SET @minStrLen = LEN(@p_SearchString) - 1; SET @maxStrLen = LEN(@p_SearchString) + 1; -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    BEGIN -- Declare some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  9. Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM @myXml.nodes('/root/s') T(c); -- Create temporary table to...

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

    ID: CREATE OR REPLACE FUNCTION fn_get_sref_from_adname (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  11. Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  12. Vertically align an asterisk on a linehttps://joellipman.com/articles/cms/website-development/css/vertically-align-an-asterisk-on-a-line.html

    } ul.listafter li{ width:59px; height:52px; margin:0; padding:0; color: #000; background-color:red; border:1px solid #000; cursor:pointer; float:left; vertical-align:bottom; font-size:40px; font-weight:700; line-height:50px; text-align:center; }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  13. A quick run through of setting up an export process in SITShttps://joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    the field to monitor, in this example, it will be the Application Clearance and Decision Entry (ACD) screen. Put the cursor in the field and press F1, this will give you the name of the field, its entity and dictionary. My example below will use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
Results 21 - 33 of 33