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

  1. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    upgraded website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4) Copy the below script to a text file Change the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your...

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

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

    column displaying. Thank you 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...

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

  3. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html

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

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

    to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and...

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

  5. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    FTP Accounts (just one username/password). Setup automated backup system. Create test space with same access details. Database Setup For JoelLipman.Com to do: Backup original database if exists already Assign unique database name Assign unique database...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  6. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

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

    a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User enters value in parameters and clicks on "View Report"...

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

  8. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET...

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

  9. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    20kg equipped with a camera). Regulations different to the UK and US are still being reviewed prior to being added to the database but each country's aviation authority has been added. Earthquake Feed for the past day:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  10. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    Savings Time is in effect for this timezone or not. So let's pretend we have a creator form wth the following fields: TZ Database Name (single-line) UTC Offset (single-line) UTC DST Offset (single-line) DST In Effect (boolean) With the addition of 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *

  11. Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good database administrator who is comfortable with making changes to the database Why? We have a page describing the company that we...

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

  12. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    I'm used to doing this without any third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your files Why? I keep getting complaints that my server wants to upgrade my PHP v7.x to PHP v8.x. I also get...

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

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

    We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...

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

  14. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    summarized article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  15. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    have different widths To ensure all the objects in the same column have the same width: Select all the objects (such as database fields, column header text objects, and summaries or subtotals) in the column by holding down the Shift key while clicking...

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

  16. Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://www.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

    A quick article on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password. How? This...

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

  17. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    I wrote that produces a GUI that takes an external file where column A contains the key/ID of the Contact in the 3rd-party database and column B contains the filename as downloaded from the 3rd-party database. And an internal file where column A is the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  18. K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

    on line 145 So I checked these pages and the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should...

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

  19. Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    the articles: Change database name my_joomla_db to your joomla database and my_wordpress_db to your Wordpress database Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site. If post_type is to be post then append with ?p=...

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

  20. Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    can then be up to you. To use the following script, you need to change the my_wordpress_db to the name of your wordpress database and change my_joomla_db to the name of your joomla database. Note that your database user should have access to both...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
Results 21 - 40 of 112