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

  1. MessageBox or AlertDialog in Android Javahttps://joellipman.com/articles/else/app-dev/android-os/messagebox-or-alertdialog-in-android-java.html

    { @Override public void onClick(DialogInterface dialog, int which) { dialog.cancel(); } }); // create and show the alertDialog b.create().show(); } The key mistake I was doing was trying to recalculate which view the main activity item was in.

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  2. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    > standalone > ie6eolas_nt.zip Download the ZIP file Scan for threats Decompress/Extract to a folder (by default it will create one separate to the default C:\Program Files\Internet Explorer). Scan for threats Run "C:\Program Files\Internet...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  4. Print Directory Contents to a Filehttps://joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    7: Open the system registry (Start > Run... > Type "REGEDIT" > OK) Navigate to My Computer\HKEY_CLASSES_ROOT\Folder\shell Create a new key with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure...

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

    right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  6. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    - Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  7. Search a database with SOUNDEXhttps://joellipman.com/articles/else/database/search-a-database-with-soundex.html

    run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max), @p_TableSchema VARCHAR(max) ) AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. Reorder Columns in a Tablehttps://joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    file as a SQL file (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `Column2` varchar(100)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  9. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    > Preferences > Database > Third Party JDBC Drivers and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  11. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    in a landscape orientation with an aspect ratio of 16:9 (a bit like an A4 paper on it's side) /prefer option set This will create custom parameters/argument suffixes you can add which represent a whole string of words that you may use often but don't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  12. Zoho CRM: Client Script: Swap Quote Account with Deal Lookuphttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-swap-quote-account-with-deal-lookup.html

    a description. I said "Maps the distributor/reseller from the opportunity into the account.". Category is Module, Page is Create Page (Standard) (change this depending on if you're using a canvas or not) Module is Quotes Type is Page Event Event is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  14. Migrate MediaWiki to another serverhttps://joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

    mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  15. Strip HTML in MySQLhttps://joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    crashed in the running of the query. The function that did work errored persistently complaining about the delimiter, create the function by running the following: SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF EXISTS fnStripTags;...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. SITS: XET format for Export not availablehttps://joellipman.com/articles/cms/website-development/xml/sits-xet-format-for-export-not-available.html

    Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  17. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    l_Messages.add(m_Message); m_Params.put("messages",l_Messages); // // https://platform.openai.com/docs/api-reference/chat/create m_Params.put("temperature",0.8); m_Params.put("n",1); m_Params.put("max_tokens",256); m_Params.put("presence_penalty",0);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  18. Write a Calendar in Autohotkeyhttps://joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the following code is an excerpt from my program which checks an online...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  19. Win32 Constantshttps://joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000 Const WM_CREATE = $0001 Const WM_DESTROY = $0002 Const WM_MOVE = $0003 Const WM_SIZE = $0005 Const WM_ACTIVATE = $0006 Const WM_SETFOCUS = $0007...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  20. Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/component/content/article/autohotkey-count-number-of-files-folders-in-a-directory.html?catid=48&Itemid=165

    counting the files then the actual processing (or whatever your script is trying to do). Method #2: FileSystemObject ComObjCreate UserFolder:="C:" -- to return file count in a folder ItemCount :=...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
Results 101 - 120 of 221