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

  1. SSRS / MDX Date Querieshttps://www.joellipman.com/component/content/article/ssrs-mdx-date-queries.html?catid=75&Itemid=165

    =Format(DateAdd("d", -1, DateSerial(YEAR(Today())+1,1,1)), "dd/MM/yyyy") // yields: 31/12/2011 I'll add to this if I use others. Apologies for the European formats but this is what I work with so I like to just copy and paste from this article.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

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

    WHERE a.student_id = p_STUDENT_REF; -- ending that second begin I had after my variable declaration END; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, TRUE); END sp_get_studentdetails_from_ad;...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  3. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  4. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the others. Once it's in your Outlook, you can copy over events. The calendar is separate to your own and to other Exchange ones. Eeek!...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *

  5. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  6. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); END...

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

  7. Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    END IF; RETURN 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')...

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

  8. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  9. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    query that will return: staffname, activity date, duration, week/year, person days, resource names, and the activity (+ any others you may want to drill-down). Setup ODBC: Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC) >...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  10. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    data using other sources and in time a region by IP for more accuracy. Feel free to feedback. It's FREE to download unlike others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the level...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  11. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    design, development and usability evaluation services." Their website has initiated a Web Definition Glossary (there are others but this one's got that "kiwi" approach) A few terms I wanted to list up: "above the fold" or "before-the-scroll" The part of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  12. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    convert xml to json php curl utf16_decode PHP Manual: curl-setopt Well this is my stop. It's being several hours that for others could have taken a several minutes if you knew where to look. My aim was to convert UTF-16 received XML to UTF-8 in order to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  13. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    rows with this would be about 3 lines of text in height. Data with 4 lines of text would adjust their row to fit but all others were left untouched. Perfect! Other Searches that I may search for again but get me nothing stop row height change on refresh...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  14. Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    my_db | gzip > /full-path-to/backups/my_db/backup_`date +"\%Y-\%m-\%d"`.sql.gz Additional Others around the web have suggested the following but I don't have these options to grant and would have to grant them via a terminal/command line to MySQL. GRANT...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *

  15. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Product Photography Real 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *

  16. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    ad might say that you can make £100 an hour by stuffing envelopes. But to make that money, you need to sell the system to others. For these reasons, we typically don't accept ads that offer work from home positions on «CompanyName». 419 scams. You get...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  17. Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-template-issue-first-page-is-blank.html

    I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others: The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution Find the CSS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *

  18. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    entries. The lookup needed to filter against various forms such as Staff Rotas, Leave Requests, Qualifications and some others. How? The aim/objective is the following: Store what was already selected in the lookups Clear the lookups list Restore what...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB

  19. Display a thumbnail of a Google Drive videohttps://www.joellipman.com/component/content/article/display-a-thumbnail-of-a-google-drive-video.html?catid=61&Itemid=165

    already on, it will display a link such as: https://drive.google.com/open?id=, where is the file ID. If not the "Share with Others" dialog will popup and the file ID will be in the link: https://drive.google.com/file/d//view?usp=sharing, where is the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB

  20. MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
Results 21 - 40 of 41