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

  1. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Bot (or any other AI text-2-image generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using the MidJourney Bot Signup to Discord.com Visit Midjourney.com Go...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  2. SSRS - Lost window with datasetshttps://www.joellipman.com/component/content/article/ssrs-lost-window-with-datasets.html?catid=75&Itemid=165

    Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. SSRS Display question mark when date is blankhttps://www.joellipman.com/component/content/article/ssrs-display-question-mark-when-date-is-blank.html?catid=75&Itemid=165

    IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. DBMS Random Referencehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/dbms-random-reference.html

    How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)]...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
  5. Joes Transmission Detector (JTD) Downloadshttps://www.joellipman.com/component/content/article/joes-transmission-detector-jtd-downloads.html?catid=105&Itemid=165

    Version Platform ChangeLog Options 1.0 - Read data packets without causing network traffic - Display program used to open port - Disallow program minimize - Background made transparent - Added received/sent data graph progress bars - Listview rolls...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  6. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  7. Add default to a picture buttonhttps://www.joellipman.com/component/content/article/add-default-to-a-picture-button.html?catid=48&Itemid=165

    with a hidden attribute: Gui, Add, Button, x600 y70 w90 h90 +Default +gSearch +Hide, Search The function to receive the data can be: Search: Gui, Submit, NoHide MsgBox, Searching for "%SearchTextInput%" Return

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  8. Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/component/content/article/autohotkey-chrome-profiles-in-alphabetical-order.html?catid=48&Itemid=165

    %MarginY% Gui, Add, ListView, w396 h775 gOpenProfile -Hdr +Grid, Profile|Client ProfilePath := "C:\Users\" A_UserName "\AppData\Local\Google\Chrome\User Data\Profile*" Loop, Files, %ProfilePath%, D { FullPathArray := StrSplit(A_LoopFileLongPath, "\")...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. Disclaimerhttps://www.joellipman.com/component/content/article/disclaimer.html?catid=50&Itemid=165

    without limitation, indirect or consequential loss or damage, or any loss or damage whatsoever arising from loss of data or profits arising out of, or in connection with, the use of this website. Through this website you are able to link to other...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  10. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    need to be agreed: Parallel running with legacy systems – testing and confirmation that both systems are operational, data needs to be entered in both systems. (this is only necessary if this is an upgrade or replacement of an existing system). Warranty...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  11. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    copy all encrypted files in EFS RAW mode. /COPY:copyflag[s] :: what to COPY for files (default is /COPY:DAT). (copyflags : D=Data, A=Attributes, T=Timestamps). (S=Security=NTFS ACLs, O=Owner info, U=aUditing info). /DCOPY:T :: COPY Directory Timestamps....

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  12. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    tools and instead have built a back-end Joomla! administration component that only works in MS Internet Explorer; any database hacks or FTP file uploads immediately corrupt this component. The component itself is sort of good, but file description has...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=53&Itemid=165

    simply displays a javascript-enabled client-side page. The tool analyzes any input on-the-fly without sending or receiving data to a server. The page used to be a part of a Password Security System I wrote back in 2008 and I missed the analysis...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-loop-through-list.html

    adding when the closing hour is found. The picklist field is called "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    with Connection Link: The syntax for this is response = zoho.creator.updateRecord( ownerName, appLinkName, formLinkName, id, dataMap, connectionlinkName); Where ownerName is the owner of the Creator app. appLinkName is the name of the Creator app....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  16. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    v_MyRegEx = ""; v_MyString = ""; v_FormattedString = v_MyString.replaceAll(v_MyRegEx,"$1",false); // yields my_real_textual_data Additional Since writing this article I found a Zoho page with some other pretty useful regular expressions at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    has interrupted the connection. Your information is still secure because Google Chrome stopped the connection before any data was exchanged. You cannot visit 127.0.0.1 at the moment because the website sent scrambled credentials that Google Chrome...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  18. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    first? Well when I create a workflow, it will ask me to run a function, the Creator workflow process will then read what datatype of a parameter I'm sending to the function. So in "Edit this application" > go to Workflow > Functions > New Function: give...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params I'm calling the Method Name "OnValidate" and I add the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  20. Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-and-send-a-csv-via-email.html

    to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 141 - 160 of 229