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

  1. Running Internet Explorer 6, 7, 8 as standaloneshttp://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

    to have IE 8 installed as my Windows browser (I wanted IE7 and the other 2 as standalones but apparently not possible) and then have IE6 and IE7 as separate browsers. If I was at home I'd just use Virtual PC with Windows7 but my customers are on XP and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  2. K2 Items disappearhttp://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

    be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab Type the following query: REPAIR TABLE jos_k2_items Note that I say "jos_k2_items" because by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Is it a scam? Gumtree.com's warning signshttp://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

    prospective tenant or even an employer will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay for shipping’. The cheque will clear into...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  4. List all cron jobs for all usershttp://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

    { while read line ; do match=$(echo "${line}" | egrep -o 'run-parts (-{1,2}\S+ )*\S+') if [[ -z "${match}" ]] ; then echo "${line}" else cron_fields=$(echo "${line}" | cut -f1-6 -d' ') cron_job_dir=$(echo "${match}" | awk '{print $NF}') if [[ -d...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  5. Basic Webpage Controls with JavaScript / COMhttp://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    This will be helpful because in my opinion, the simplest way to start using COM is to learn some basic JavaScript, and then "translate" that code to use with COM in AHK. COM - (Component Object Model) All you really need to know about COM for this...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. SSRS Querying on either of 2 Parametershttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    "Student Reference" but not necessarily a student AD account (enquired/applied only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report is executed. So my...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. The ReportServer Databasehttp://www.joellipman.com/articles/database/the-reportserver-database.html

    unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) NULL Windows authenticated username and domain of the person running the report (eg. MYDOMAIN\myusername) RequestType bit NOT NULL User or System....

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. Importing Joomla articles to WordPress postshttp://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    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= otherwise use ?page_id=. Articles: ------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  9. SSRS Parameters in Oracle Stored Procedurehttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

    page) / With 2 parameters provided in the main report (note: main report runs with incident number as NULL, the user can then add an incident number afterwards or when the initial report was run). The confirmation page just checks with the end-user that...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. Stop Excel Row Height Self-Adjust on Refreshhttp://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

    hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of selecting all cells and then right-clicking and selecting "row height" is beyond us. We have since simplified this so that only the person who knows how to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  11. Migrate Joomla Users to WordPresshttp://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    transfer users This is a free solution to at least get your user accounts all migrated. How you deal with the passwords 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...

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

    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 database account with read-only privileges to list all the details....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. SSRS AlphaNumeric Parameter Validationhttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

    check the parameters submitted with 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Joes DNS Correction (JDC)http://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

    loses connection or simply forgets what intranet site you were trying to access and your usual solution is a reboot, then this tool may be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Basic Oracle Function Structurehttp://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

    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 raise_application_error(-20001,'An error was encountered -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  16. No rows returned in Oracle causes SP to failhttp://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    and without any warnings. So What? The problem is that if the student does not have a username but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  17. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2)) END AS thread_id, path, level, object_id, object_group,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. DataJumble - Shuffling characters in a data valuehttp://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

    IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; -- DETERMINE IF THIS FIELD CONTAINS A TIME VALUE SET @TimeMatch = CASE WHEN CAST(CAST(@OrigVal AS time) AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  19. Copy a table with structure and data into a temporary tablehttp://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    suggests the following (or at least the idea of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  20. Slideshow div layer through a windowhttp://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

    the slides in from right to left with a transition. Push existing slide out to the left; as soon as this is out of sight then hide it behind the displayed slide. Replace contents of the hidden slide with contents of the displayed slide. Hide currently...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
Results 121 - 140 of 347

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.