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

  1. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

    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 ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  2. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

    // declare the new row and JSON argument var json_Row = new Array(); var json_Arg = new Object(); // get some values beforehand which allows us to compare to the rows already present in the subform // first column to add in this row is start date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url :v_ImageToDownload type :GET ]; // // upload file to workdrive r_WorkdriveUpload =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    this source in case it disappears in the future: Subject (String): Subject of the task. This key is mandatory. Who_Id (JSON Object or Int): ID of the contact or lead the task is related to. What_Id (JSON Object or Int): ID of the account the contact is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Embed an FLV file into a web pagehttps://www.joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

    for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both instances of the text "http://my.video.com/myVideo.flv" with the full url of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
  6. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

    with no name. Show hour in top column only on the hour =IIF(MINUTE(Fields!Time.Value)=30, "", Fields!Time.Value) Make the object in the cell a block (which I made big and then didn't allow cell to increase/decrease height). This way when it's printed...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  7. SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    work or didn't apply for me. I had to insert a rectangle that separates the textboxes (so fills up the empty space with an object)... The visibility expressions for both hiding and displaying either the textbox or the tablix has to be applied to both...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

    Connections ncpa.cpl Network Setup Wizard netsetup.cpl Notepad notepad Nview Desktop Manager (if installed) nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (if installed)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  9. Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

    of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you right-click on an object). The following is a method of adding this as a single command similar to how we add the "Command prompt from here" option...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

    to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataJumble ; GO -- Create user defined function CREATE FUNCTION...

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

    outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored Procedure CREATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  12. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    $_GET['id']); if ($result = mysqli_query($db_connect, $query, MYSQLI_USE_RESULT)) { while($obj = $result->fetch_object()){ $content_count = $obj->ArticleCount; } } } echo $content_count; mysqli_free_result( $db_connect ); Clear as mud? Feel free to use...

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

    and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  14. SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    row disposition on "output column "DC_This_Date" (3833)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  15. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    error row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  16. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    of Row: foreach (PropertyInfo p in Row.GetType().GetProperties()) { try { // Check type for all string properties if (object.ReferenceEquals(p.PropertyType, typeof(string))) { // declare two arrays string[] exceptionArray_this; string[]...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  17. SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

    the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the ReportServer....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    // convert the response to xml $xml_result = simplexml_load_string($ch_result) or die("Error: Cannot create object"); // convert the xml to json $json_result = json_encode($xml_result); // print the json echo $json_result; // [OPTIONAL] convert it to an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  19. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    is now obsolete. - Date Uploaded: Mon, 25th Oct 2010 1.2.1- Removed some word OTT extraction functions (eg. applet, map, object, etc). - Date Uploaded: Mon, 25th Oct 2010 1.2.0- Fixed compatibility with UTF8 (International) languages. But broke...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  20. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

    Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes // split by closing curly brace...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
Results 21 - 40 of 48

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.