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

  1. Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

    TBN_DROPDOWN = ((0-700)-10) Const TBN_HOTITEMCHANGE = ((0 - 700) - 13) ;#End Region ;#Region Reflected Messages Const OCM__BASE = (WM_USER+$1c00) Const OCM_COMMAND = (OCM__BASE + WM_COMMAND) Const OCM_CTLCOLORBTN = (OCM__BASE + WM_CTLCOLORBTN) Const...

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

    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
  3. Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

    ---------------------- Beijing Capital International Airport 40°4′20″N 116°35′51″E Beijing Shahezhen Air Base 40°8′57″N 116°19′17″E Beijing Tongxian Air Base 39°48′40″N 116°42′30″E Note that I tend to copy the coordinates off a website which has strange...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

    to cascade across my servers (average wait is 1 hour). JoelLipman.Com will develop the startup site using an Agile framework based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  6. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    Mon, 18th Jul 2011 1.6.4- Added Joomla! Admin Option: Module Content Caching - Added Joomla! Admin Option: Include content based on User Level - Added Joomla! Admin Option: Include Category IDs - Added Joomla! Admin Option: Exclude Category IDs - Added...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  7. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    knowing any code and without needing to use your creator knowledge. I haven't been using this because I edit the content based on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

    can be poured into the hot pan in one go. As soon as the batter hits the hot pan, tip it around from side to side to get the base evenly coated with batter. It should take only half a minute or so to cook; you can lift the edge with a palette knife to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  9. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

    SP2 Internet Explorer 7 As you can tell, not the most up-to-date but unfortunately I need to stay near to my customer base and match their setups as closely as possible. Objective My aim is to have IE 8 installed as my Windows browser (I wanted IE7 and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. Change the login link in MediaWikihttps://www.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

    don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are restricted to staff and different localgroups. When...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  11. SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

    SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University Knowledge Base. The skin itself is the index page loaded for any page in the Wiki system. It logs the IP address (VisitorIP), the URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  12. Newbies guide to be the local computer guyhttps://www.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

    their window or on their cash wrap. Initially, charge a nominal fee…maybe something like $30/hour just to build up a client base and get some referalls. Put up a Web site describing your services. It makes you look more legit when you print it on your...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  13. List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content, Category SELECT p.page_id AS PageID, CONVERT(p.page_title USING...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  14. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

    1234567 jsmith2012 08-MAY-12 sac180786.txt Permissions CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad TO a_more_casual_user; Yay for me So this is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  15. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: As...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    "link_Docs": 0 } ], The most logical thinkers would say that you simply need the download_Url value and prepend the CRM base URL such as https://crm.zoho.com + v_download_Url... But that is incorrect, apparently you have to treat the field of type "File...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    to Shopify in 3024x3024 resolution (or the size that the client wants: iPhone res). I then found that Shopify does accept a Base64Encoded version of the image and the below is how I achieved this. How? First-off, let me list the various formats that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    "Joel Lipman is a technical consultant working with Ascent Business Solutions, the top Zoho Reseller based in the United Kingdom."); l_Messages.add(m_MessageTraining1); // // this message m_ThisMessage = Map(); m_ThisMessage.put("role", "user");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Increase Recent Documents Number in Windows XPhttps://www.joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

    Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  20. Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

    PG = Plan guide PK = PRIMARY KEY constraint R = Rule (old-style, stand-alone) RF = Replication-filter-procedure S = System base table SN = Synonym SQ = Service queue TA = Assembly (CLR) DML trigger TF = SQL table-valued-function TR = SQL DML trigger TT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 1 - 20 of 21

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.