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

  1. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    Generate/Populate list of files and their proposed new names GenerateList: SB_SetText("Generating...") LV_Delete() v_RowCount := 0 GuiControlGet, SelectedDir v_FilesPath := SelectedDir "\*" Loop, Files, %v_FilesPath% { ; skip if file ext is not media if...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  2. The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

    code; if multiple errors occur, only the first error is recorded ByteCountbigintNOT NULLSize of rendered reports in bytes. RowCountbigintNOT NULLNumber of rows returned from queries. Conversions Needed: I want to convert a start and end date to a single...

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

    string inputValue; string debugString; string outputValue; string[] exceptionArray_this; string[] exceptionArray_that; int rowCount=0; // C# alternative for VB.Net StrConv uses cultureinfo and threading // See: http://support.microsoft.com/kb/312890/...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM student_accounts...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
Results 1 - 4 of 4

Please publish modules in offcanvas position.