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

  1. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    procedure compiles without warnings in SQL Developer (or SQL*Plus, etc.) Hardcode your parameters in the SSRS report with actual values that would have been submitted. Create the most basic report you can with the data you're working with just so you...

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

    = 'Event 6' As you can see, these events were hard-coded into the script. I was asked to replace these with events from an actual database. So I just need a table returned with the "EventDate" and the "Note" variables from the other database. If I use...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  3. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    parenthesis of each preceding subexpression. The backreference lets you search for a repeated string without knowing the actual string ahead of time. For example, the regular expression: ^(.*)\1$ matches a line consisting of two adjacent appearances of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. Display Feeds to major Social Networkshttps://joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the feed would be done on the respective social network's site. How: This simply displays the feed... (no write...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    has completed. Do the following step to keep the file in a specified folder. 5. Form processing works so now test the actual file upload Add the following code after the above code sample in step #4: if (file_exists(""....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  6. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    to Excel and on extra blank columns will appear in the worksheet. NOTE: Fields formatted so they are much wider than the actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest data value....

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  7. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. Eye-Level Shot puts a massive eye on the picture???) Cinematic Still Shot Full-Body shot...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  8. Display a thumbnail of a Google Drive videohttps://joellipman.com/component/content/article/display-a-thumbnail-of-a-google-drive-video.html?catid=61&Itemid=165

    Drive File ID (which you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google Drive: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // where is the file id The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
Results 21 - 28 of 28