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

  1. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install. How? Source: Joomla! • View topic - Cannot get recaptcha to display on registration form... There are two solutions I have found that fix the problem:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    the end of all of this and to execute the functions but before any outputs (HTML or JS): $credentials = authenticate(); To view these or output to screen: print_r($credentials); Worthwhile Note(s) Allowing the scope to access the user profile also sends...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  4. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    reference to the uploaded movie. */ class FlvPlayer { /* Generate final code */ function render() { $this->url = $this->getViewPath($this->file); $this->code = ' The Camtasia Studio video content presented here requires JavaScript to be enabled and the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  5. List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    access levels table), I have a separate table containing the wiki categories associated with local wiki groups (required to view the category): Page ID, Title, Content, Category, Groups SELECT p.page_id AS PageID, CONVERT(p.page_title USING latin1) AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  6. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    and then I have 38 columns ("A" to "AL"): In the data flow, click on the Excel datasource component so that it's selected. View the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you...

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

    to this project containing sensitive data): Script Component Task: Select Type Script Component Task: Transformation: Data Viewers Script Transformation Editor: Input Columns Additional "Features" I have noted that letters immediately following a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    to the name and folder of your report. To hide all except the report (default is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Toolbar=False To hide just the parameters (default is True)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    redirect to the details report for that student automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report with all selectable reports as subreports - toggle visibilty based on parameter. Method...

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

    does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel EXECUTE...

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

    running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When previewing the report in BIDS, the photo appears fine. If we deploy the report to our Reporting Server and attempt to view it using a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  12. 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

    of the first report (the one with all the main details), as well as a job reference (for audit purposes) and click "View Report". The report will refresh with a link to a confirmation report which the user clicks and confirms that this is the student to...

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

    the database level, and then get the report to complete the check: The Plan User enters value in parameters and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database Report retrieves (select) formatted parameter...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    (in black) is the same image used in the top center of the dataset (the black background). And here's the rendered/published view on the Reporting Server: Conclusion The whole report was appearing over any scrolled content as if it were a header that...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    have all the Aero effects enabled. Now what are these Aero effects? Aero Peek: Aero Peek What this is it gives you a preview of windows in a thumbnail without actually opening them by simply hovering over the icon in the taskbar. Click on one of them...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  16. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  17. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    ** - For performance, restrict this by schema otherwise occurrences in tables where the column is ** ** the referred to in a view, will appear twice: ** ** Change: ** ** WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') ** **...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  18. Error 1065: Query was Emptyhttps://www.joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

    In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  19. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    so we weren't there in person and could only see the users screen. Three Webdevelopers phone in to say their computers can't view a website properly "Can someone have a look at our computers because we recently received the new corporate template for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  20. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    different headers appeared on the exported report when we followed that suggestion. Consider the following report in design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 61 - 80 of 87