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

  1. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    that sometimes the captcha wouldn't even match what you typed and what it displayed!!! I have written this article to be another one of those programmer's tweaks. This is quite a simple fix and I will hopefully be able to keep it simple for...

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

  2. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

    working as it should. It's templates are ok but it's its extensions for which I signed up for. As well as helping another subscriber. There were issues with some modules but the forum is frequently administered and the response was quick. Though the...

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

  3. RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

    don't want to share this solution unless we continue to pay for the subscription. Understandable to some extent, greedy in another. So far the solution has been to open this with Internet Explorer with a cleared-cache. A little annoying in view how much...

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

  4. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...

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

  5. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    this issue: Download from the Play Store: The google maps api will apparently NOT work if you downloaded the APK from another location. This wasn't the issue, once I had the right SHA1 registered in the Google APIs console other users could download the...

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

  6. Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/else/app-dev/android-os/android-function-to-let-user-take-photo-or-choose-existing.html

    this displays an AlertDialog designed by an XML layout file ("res/layout/dialog_edititem_photo"). The ImageView exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main...

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

  7. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8). Why? It took me a long time to figure this and it was only by trawling through columns that someone...

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

  8. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

  9. Report Builder 2.0 - Hide Series1https://www.joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1" Took me a while to figure this out but modify the above statement along the...

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

  10. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  11. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    Procedure I already wrote an article on this so please refer to SSRS Parameters in Oracle Stored Procedure. Oracle: Grant another user permissions /* on the table: ssrs_audit_table */ CREATE OR REPLACE PUBLIC SYNONYM ssrs_audit_table FOR...

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

  12. SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    -- where :UserSpecifiedID is one of the report parameters (Oracle local variable) -- where :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use...

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

  13. 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

    the prompt your Outlook instance generates as a result. You now have a new calendar under Other Calendars, you can open another calendar alongside and now copy events over by dragging and dropping (TIP: I right-click and hold and drag and this then...

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

  14. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    Third party firewalls will often block the time servers, causing the sync to not work properly. If you are using McAfee or another firewall, you’ll need to use the configuration utility to unlock NPT access on UDP port 123. Resync your Time using the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  15. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    Get browser dimensions and plug-in details (http://whatsmy.browsersize.com/ - Only in here cose it's clean) Another one (http://my-browser.net/ - shame about the popups)

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  16. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    using the system registry (see "How: for Windows 7" below). -- yield a_subfolder_in_this_folder a_file_in_this_folder.txt another_file_in_this_folder.doc How? For Windows XP: Open an instance of Windows Explorer and click on "Tools" Select "Folder...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  17. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and lose the decimal...

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

  18. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  19. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    ID Name EmpType CodeType 1 Joe Manager 0011 2 John Tape-Monkey 8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey 8475 6 Joe Tape-Monkey 8475 Table: DMExtractReferenceTable ------------------------------ ID MapIn MapOut 1 0011 71 2 8475...

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

  20. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    OR ( t1.TABLE_CATALOG IS NULL OR t2.TABLE_CATALOG IS NULL ) -- NOTE: This does not list if a column has been moved to another table Method #4 And a final enhancement to epitomize my laziness (replace [myDB1] with name of database 1 and [myDB2] with name...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 101 - 120 of 153