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

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

    joomla database. Note that your database user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  2. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

    is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Basic Oracle Function Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

    student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  4. Prefix Line Numbers in a Text Filehttps://joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

    the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt"...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  5. Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check for any dodgy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

    when using Outlook 2007 instead of the SharePoint 2007 web interface... Other Searches Import Outlook 2007 calendar into Sharepoint 2007 Sync Sharepoint 2007 calendar with shared Outlook 2007 calendar

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  7. Adding a selectable background to a Yootheme templatehttps://joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    matching the path in the previous step: \templates\\images\background\ambientturquoise\ambientturquoise.jpg Test by logging into the Joomla Admin Panel > Extensions > Template Manager > Styles > "Select the Background" > Save/Apply Done! Additional Note...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    Friendly (SEF) website addresses as a lot of web-based file managers cannot see hidden files! » Compress your LIVE files into a ZIP and extract to TEST to copy over any hidden files. You only have to do this on the first refresh. For further refreshes,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Set up Desktop SlideShow in Windows 7https://joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

    this is the one on the homedrive and preferably not C:\ drive). I’ve called mine “Win7_ScrSvr”. Copy a few background images into the folder. Right-click on one of the images and select “Set as Background” Right-click on the desktop and select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  10. Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

    tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such...

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

    script. The Download Should contain the following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  12. AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

    (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract all data into a Comma Seperated Values (CSV) list of all data from an Advanced Web Statistics [AwStats] v7.0 (build 1.971) report. The data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

    #3: Standard Function with Loop -- input parameters: -- -- Folder=folder/file pattern. -- -- Subfolders=1 or 0 (recurse into subfolders or not) SC_Load(Folder, Subfolders){ global SC_Size,SC_Ext,SC_FullPath,SC_Name,SC_TotalFiles SC_Size := Object()...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  14. Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

    (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; Make sure you have the INSERT INTO commands if this includes website data!!! Drop the table Reload the script you just modified.

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  15. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    General > Software > Update option) Right-click on your iTunes shortcut and select "Run as Administrator". Plug both phones into the computer. In iTunes, right-click on the old phone and select "Transfer Purchases". (you will need to know your Apple ID...

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

    at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into the morning and afternoon slots. All days and time slots must be listed irrespective of whether any time has been associated...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  17. Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings : Database Tables Prefix It should...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  18. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

    to the user experience. For one thing, the accidental search for "Jane" and pressing the Enter key, no longer goes off into the interminable loop that is "loading".

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    Toolbox Items > SSIS Control Flow Items > Tick the "For Each Loop Container") Add the Data-Flow to the container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
Results 121 - 140 of 213

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.