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/component/content/article/win32-constants.html?catid=48&Itemid=165

    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/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
  3. Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/component/content/article/excel-convert-degrees-minutes-seconds-to-decimal.html?catid=110&Itemid=165

    ---------------------- 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. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    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: *
  5. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/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 Creator
    • Language: *
  6. 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
  7. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    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: *
  8. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator/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 Creator
    • Language: *
  9. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/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 Creator
    • Language: *
  10. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/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 CRM
    • Language: *
  11. 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
  12. 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
  13. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    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
  14. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    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: *
  15. Drop If Object Existshttps://www.joellipman.com/articles/else/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: *
  16. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-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
  17. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/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: *
  18. Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165

    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: *
  19. Newbies guide to be the local computer guyhttps://www.joellipman.com/component/content/article/newbies-guide-to-be-the-local-computer-guy.html?catid=116&Itemid=165

    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: *
  20. Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

    CMD Forces the value to be alphanumeric plus the following three special characters _ (underscore) . (dot) - (dash) BASE64 Forces the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 1 - 20 of 21