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

  1. Zoho Survey: Zoho CRM Webhookhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    A separate article as a follow-on from my previous article in this series Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages which may have grown a little but just wanted to record how to receive a Zoho Survey...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    fried, I'm putting the two functions I used here and I'll document further if I remember. Note that the pre-amble is to generate a Xero access token which I documented in another article - it's behind a userwall because I usually charge for my Xero...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    Change the item you created in step #2 (eg. "about_new" to "about-us"), also change the "path" value to match as this will generate your URL. Done

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

    we have created using Camtasia Studio.' ); $wgExtensionFunctions[] = "wfFlvPlayerExtension"; /* * The FlvPlayer class generates code that embeds a flash movie player * with reference to the uploaded movie. */ class FlvPlayer { /* Generate final code */...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  5. Print Directory Contents to a Filehttps://joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  6. 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

    EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  7. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    a software to deal with room bookings and said we shouldn't use Outlook for this... The DataSet The script I used to generate the dates comes from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  8. DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    3 onrUest ehAr 1968-05-05 4 otentre AhYe Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  9. Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    @ColName=( SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName AND ORDINAL_POSITION = 1 ); -- Generate Select Query to extract data from given table and populate temporary table SET @SqlToExecute='SELECT ROW_NUMBER()...

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

    EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @ColToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SET @SqlToExecute = ' SELECT DISTINCT myValue COLLATE ' + @p_UseCollation + ' AS myValue, myColumn,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  11. DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    1968-05-05 4 RJDsFMaeNcLrcMWw 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  12. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    v_returnedval; EXCEPTION WHEN no_data_found THEN RETURN ('Error in submitted value'); WHEN others THEN RETURN ('Unable to generate random value'); END UFN_DATASCRAMBLE; Usage SELECT -- UFN_DATASCRAMBLE(DATE_CREATED, 'DATE') scramble_column, -- testing...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  13. Inserting incremental weeks in MySQLhttps://joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    Ask it what date it is on 2012-07-10 and it doesn't have a clue. Anyway, enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Country Lookup by IP address CSVhttps://joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    where you uploaded this script. // should return China Any questions, suggestions? We are looking to add the ability to generate this data using other sources and in time a region by IP for more accuracy. Feel free to feedback. It's FREE to download...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. PHP & MySQL Search Enginehttps://joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    RLIKE '[[::]]')".$parts."(PageContent RLIKE '[[::]]')"; } else { $scorepartstring = implode(' + ', $scoreparts); } // Generate the SQL query for your search engine $filter_sql = " SELECT t.PageID, t.PageTitle, t.PageContent, t.Source,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  16. Xero API: Send Multiple Invoiceshttps://joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time... And Zoho was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  17. Joes Chart Generator (JCG) Downloadshttps://joellipman.com/component/content/article/joes-chart-generator-jcg-downloads.html?catid=105&Itemid=165

    Version Platform ChangeLog Options 1.0 + Group all the data by a specified column + Generate interactive flash charts - Date Uploaded: Wed, 15th Sep 2010 Download

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
Results 61 - 77 of 77