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

  1. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    = ZDK.Client.showConfirmation('Changing Invoice Type to '+v_InvoiceType+' will re-write the line item(s).\n\nAre you sure you want to proceed?', 'Proceed', 'Cancel'); // if "Proceed" was clicked if (b_Proceed) { // start Loader...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

    global configuration... The only problem is that your landing page becomes "HOME - SITENAME.COM" which is ridiculous and I'm sure Joomla will release a new version addressing this. In the meantime however: Go to "Global Configuration" and set the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    1.6 to 2.5 included in their basic install (vanilla/out-of-the-box). Will not work with Joomla 1.5 or less - Not 100% sure about this but I tried the example in the Official Joomla Documentation and I couldn't get it to work. They even add a note to say...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation: Backup your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    Run the Python Script to Transcribe python3 transcribe_vosk.py I left the script running overnight so I'm not sure whether it simply played it for 5.5 hours and transcribed it or whether it did it in a shorter amount of time; but the next morning I had...

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

    - Adobe Flash Output' > Next ExpressShow (complete optional settings) > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on 'FINISH' This will produce a HTML, SWF, XML...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  7. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the computer, ie via the Settings >...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  8. 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

    trailing space ValueToConvert = ValueToConvert.Trim(); // Use a method to set the value of each String type property // Make sure the length of the new value doesn't exceed the column size p.SetValue(Row, ValueToConvert, null); } } catch (Exception e) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row -...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  10. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure). Shared...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    caused by any Windows 7 desktop gadgets. Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Windows Live Messenger: Error 80048820https://www.joellipman.com/component/content/article/windows-live-messenger-error-80048820.html?catid=80&Itemid=165

    accurate or close to real Internet time: Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  13. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    name box. (This file is a system-hidden file, so it won't show up in the file selection window. You have to type it in. Be sure not to select ntuser.dat.log by accident.) Click ok, then enter a name for the key. We'll call it Foo. Go to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Reorder Columns in a Tablehttps://www.joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    NOT NULL, PRIMARY KEY (`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. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    the top of the [Order] column (grey square -like excel- to select the column). Select "delete columns". Still deleting: Make sure you select "delete columns and associated groups": Overview: So the following screenshot is how your report should look...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  16. Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    If run by a service account, ask a DBA to emulate the user for testing. the Items column may vary from 1 and 10+. Not sure on why this is but it doesn't seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  17. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    Rectified part of the stored procedure: The solution in the end was to null the first query and make sure it didn't return the errors "no data found" and send this to the second query: -- the same query but which doesn't fail the procedure :) SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  18. 301 Redirect using htaccess filehttps://www.joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    domain. Why? I warned that a 301 site gets removed from the Google directory and true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  19. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    fjs.parentNode.insertBefore(js,fjs); } }(document,"script","twitter-wjs"); Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  20. Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    in width fixed the problem. I'm guessing this was because 990 divided by 33 leaves a remainder of zero but I'm not 100% sure this fixes the issue throughout other systems. IMO: Somewhere in the Javascript (based on jquery), the script is using the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
Results 41 - 60 of 73