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

  1. View your available module positionshttps://joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

    Click on the link 'Show in New Window' Bookmark the web address of the new window The bookmark/favorite that you have just made can be refreshed when you change things on your site and should reflect exactly how your website is overlayed with the module...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    folder You need to copy any files from your rocket template folder (eg. affinity) into the folder you just made (eg. copy of prosilver) and overwriting when prompted. Rename your copy of prosilver folder to the name of your new template (eg. affinity -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    => just cos this value exists, don't know why you would order by this ordering => the setting it's on if you haven't made this modification. I don't like it and nor do u if you've been trawling the web for this solution. archived => is or not approved...

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

    script works perfectly for what I had in mind. Important! There are a few concealed features of this script that I haven't made a song and dance about but are noteworthy: The only anti-code injection facility in this example is the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

    'KCAPTCHA'); $captcha[] = JCommentsHTML::makeOption('recaptcha', 'RECAPTCHA'); STEP #4: Set in admin setting We've made the option available, now login and set it to our new captcha Login to your Joomla Administration panel Components > JComments >...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    'KCAPTCHA'); $captcha[] = JCommentsHTML::makeOption('playthru', 'PLAYTHRU'); STEP #4: Set to PlayThru in admin setting We've made the change, now login and set it to PlayThru Login to your Joomla Administration panel Components > JComments > Settings >...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

    (line 398) Replace the line KCAPTCHA With this KCAPTCHA PLAYTHRU STEP #4: Set to PlayThru in admin setting We've made the change, now login and set it to PlayThru Login to your Joomla Administration panel Components > JComments > Settings > Layout >...

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

    website with a name that is difficult to guess but easy to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code to the .htaccess file in the root of your joomla website: # Admin...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    was only by trawling through columns that someone mentioned that maybe all the data in that column is not consistent? This made sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    automate this (run as Administrator in Win7 from C:\temp): @ECHO OFF REM This program is for Joel Lipman to run after he's made a change to some REM C# code for a SSIS Custom Script Component task. REM Change the working directory to the GACUtility...

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

    ASC, tt.[FinishTime] ASC I even separated off the @GivenDate and @GivenCampus and re-assigned them mid-script which made no difference whatsoever. In case you've been stuck for ages (as I have), I found out you cannot declare the parameters used by the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    ssrs_audit_table is a table that we want to use as an audit table -- where ssrs_stored_procedure is a stored procedure we made -- where ssrs_sp_user is the user to run the stored procedure in SSRS -- where base_table_owner is your base table owner...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" ) Additional If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF statement block to the Font...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Performance Report - Background colors based on dataset valueshttps://joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    which is the better report; and when comparing to the previous runs (using a second dataset) you can tell where changes were made and how this affected the reports' performance. What? What I'm trying to do is display a set of results (comparing various...

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

    to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  16. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    which could determine the datatype automatically but as you may know, Oracle has a funny way of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  17. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    earlier should be listed) Enter credentials if necessary and click on "Test Connection" Expand the data connection you just made and expand "Tables" just to see if the connection is working properly. Create the Data Source Still within Business...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  18. MySQL last year week month day trend periodshttps://joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. Country Lookup by IP address CSVhttps://joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    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 of interest.

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  20. Generate a Timesheet in MySQL https://joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 41 - 60 of 77