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

  1. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a field with a dropdown list. Add a button to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    Why? When checking audit logs, I sometimes see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla websites in general and prevents the administrator URL showing up at all in the stats (unless you were...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    file had some empty rows amongst the data. The easy fix is by dealing with any empty rows. The best way I've seen that has worked in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of greater than 1:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    European Given a Campus as a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that will be submitted (GivenDate and GivenCampus). Consider the following script: --...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  5. SSRS / MDX Date Querieshttps://joellipman.com/component/content/article/ssrs-mdx-date-queries.html?catid=75&Itemid=165

    in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    everyone had a different setup to us and their solutions were complex coding solutions and ultimately the wrong route as we worked out our own solution. ssrs run oracle stored procedure execute call oracle stored procedure in ssrs ssrs oracle stored...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. SSRS External Images don't displayhttps://joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    Intranet computers or user accounts (eg. try Local Admin Account on Computername as domain). The first two of the above worked for us, which indicated an issue with the credentials we were using to access the the photos, so: Ensure the "Unattended User...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  8. SSRS Dropdown parameter cannot be blank!https://joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    for including a dummy row. Also note that because I don't have any options matching the ID above ("000000-0000-..."), this worked perfectly for me as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    Intro I know there are a lot of articles on the WWW detailing this process but none of them really worked for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    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 personal site :c) My own with Typos Note...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  11. T-SQL Record Separatorhttps://joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    the value or your empty row. Here's an example of the query for a timetabling solution with spacing rows between days. This worked ok but pay special attention to Stage #3 afterwards otherwise if you stop in Stage #2 you'll be missing data: --Create CTE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  12. CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/cms/website-development/css/css-background-without-causing-scrollbars.html

    of CSS overflow auto hidden etc. all to no avail. What I didn't want when I resize the web browser, a scrollbar! What worked for me: Specify the DIV layer width to be 100 percent of the page. Position the module with absolute on your webpage with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  13. CSS keeping the footer at the bottomhttps://joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

    enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine....

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  14. UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    ); $rows = $db->loadObjectList(); foreach( $rows as $row ) { $id = $row->id; $title = $row->title; } This fix has so far worked for Arabic, Chinese, Hebrew, Russian, and Slovak. Fingers crossed this should work for all characters that Joomla! can handle...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. Accessing Apimo WebService APIhttps://joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    I couldn't get the configuration right. After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments to make which I'm documenting here. Basic Example Here's a complete PHP script of a basic...

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

    to as an AI enthusiast and whose videos are really helpful in this space. Here's some prompts from his videos that worked for me: portrait: clear facial features, Cinematic, 35mm lens, f/1.8, accent lighting, global illumination --uplight --v 4 nature:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  17. Checklist for the local computer repairshttps://joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

    and emergencies, added 20/hour Add 20 for restore disk Questions for customers: What do you need to do? Last time it worked? Emails received since? Programs installed since? Alternative documents/programs to do this? Same errors on another computer?...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  18. Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/component/content/article/amazon-kindle-send-pdfs-to-your-kindle.html?catid=121&Itemid=165

    which I wanted to take note of as it is a process that worked at time of print (6 June 2022) and I wanted to make sure it didn't just disappear or be difficult to find in future. How? The process of sending a PDF file to your Kindle device is also quite...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  19. How to run a .RUN filehttps://joellipman.com/component/content/article/how-to-run-a-run-file.html?catid=63&Itemid=165

    Select 'Properties' Select the 'Permissions' tab Tick the 'Execute' checkbox Conclusion The solution using the terminal worked for me but the second one using Gnome didn't.

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  20. Set default parameter dates to start and end of monthhttps://joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    spend 30 minutes googling and reading up on is asking for an article on my own site. Besides this is how I did it and what worked for me... Set the default values for your from and to date respectively: -- From Date (european format - dd/mm/yyyy)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
Results 21 - 40 of 42