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

  1. Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

    to respect the freedom of others. For example, if you distribute copies of such a program, whether gratis or for a fee, you must pass on to the recipients the same freedoms that you received. You must make sure that they, too, receive or can get the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  2. XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

    the XML document with attributes not specified by the schema appinfo Specifies information to be used by the application (must go inside annotation) attribute Defines an attribute attributeGroup Defines an attribute group to be used in complex type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  3. Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    111 Can't open SMTP stream. One common problem people have is an incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues: How to setup the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

    deletion of their personal data and closure of their eBay account. This article explains the process third-party developers must follow to subscribe to, receive, respond to, and validate these notifications. Why? As quoted from the page:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar]...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    file of a folder called "Attachments" (uppercase A and the word Attachments - no other option). The Attachments folder must contain no subfolders and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

    "Best CRM" or "Latest CRM" in their Campaign_Name fields. When you use parentheses or comma in the value for a criteria, you must escape them using a backslash. Further, you must encode the value. Example: Consider the search term:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    on the net were either incomplete, did not work for me or simply did not match the requirements (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

    information about your problem (the fact that you really really want it fixed does not count as additional information). You must post this in the same thread, and you are not allowed to create more than one thread per topic. No Posting Personal Info -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  10. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    string: abcDEFghi The expression does not return a match for the following string: abcdefghi Note that the character class must occur within a character list, so the character class is always nested within the brackets for the character list in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  11. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

    slow lines. /SL :: copy symbolic links versus the target. /MT[:n] :: Do multi-threaded copies with n threads (default 8). n must be at least 1 and not greater than 128. This option is incompatible with the /IPG and /EFSRAW options. Redirect output using...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  12. MySQL Transactions in PHPhttps://joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

    'Fred'"); What if one of the queries fails? To mitigate the chances of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data. This where...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
  13. SSRS Report Builder 2.0 - Error during processinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

    Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Frontpage Item Orderinghttps://joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

    > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take effect. To set them, do this in your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

    must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Set default parameter dates to start and end of monthhttps://joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

    The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  17. F_ck You. Pay Me.https://joellipman.com/articles/web-development/fck-you-pay-me.html

    To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  18. Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

    URL (for Demo) --- Like/Share in Facebook --- Download count (total of all versions) --- Permanent URL for this page (must ignore SEF, eg. "?option=com_joesbugtracker&id=") --- Display/Access based on User level --- Free-Text Changelog or Auto-generate...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Before and After, Highs and Lowshttps://joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

    Report 001 5 2 Report 002 11 47 Report 003 7 61 Multiple Datasets? Again NO that's what I have at the moment. There must be a way. Or is time always on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  20. Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    value FROM my_table WHERE my_id IN ('1, 2, 3') SELECT value FROM my_table WHERE my_id IN ('1', '2', '3') The Solution I must confess that the bulk of this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 1 - 20 of 37

Please publish modules in offcanvas position.