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

  1. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    for Start In..., I leave this blank but you could specify a working directory. OK the dialogs and close the Task Scheduler Right-click on an empty space on the desktop and select New > Shortcut Type in the task with the format schtasks /run /tn...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  2. 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

    this value, navigate back up to HKEY_USERS, select the Foo key you loaded, and then click File > Unload Hive > Yes (prompt). Close the registry editor, then restart the computer. Notes: Guest account will not see the drive in Windows Explorer but can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  3. Search a database with SOUNDEXhttps://joellipman.com/articles/else/database/search-a-database-with-soundex.html

    ELSE PRINT ' union all ' + @SqlToExecute; SET @myCounter = @myCounter + 1; FETCH NEXT FROM Cursor1 INTO @SqlToExecute END CLOSE Cursor1; DEALLOCATE Cursor1; PRINT ' ) AS t1 GROUP BY column_value ORDER BY MIN(column_source)'; END Step 2 of 2 You now have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  4. Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    ' + @p_Column + ''; INSERT #CountRecordsPerTablePerCol EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  5. Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    Single. If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes. Restoring in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  6. Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    ' + @p_UseCollation; INSERT #ListDistinctValuesAndCounts EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @ColToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SET @SqlToExecute = ' SELECT DISTINCT myValue COLLATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  7. DataTumble - Randomize Data Rowshttps://joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    ,@UpdateData SELECT @NumberLeft = SUM(1) FROM #Scramble WHERE Chosen IS NULL FETCH NEXT FROM @UpdateCursor INTO @Data END CLOSE @UpdateCursor DEALLOCATE @UpdateCursor COMMIT TRANSACTION A --print 'committed' END TRY BEGIN CATCH ROLLBACK TRANSACTION A...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  8. Basic Oracle Function Structurehttps://joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR-...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  9. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  10. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    Data tab > From Other Sources > From Microsoft Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  11. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    to a plug later. Hmm... maybe I should have painted my Phantom in chrome. My DJI Phantom FC40 repainted and gimballed. Very close to the ground so will have to watch those landings and thats with thicker than stock pads Done. Here's a video and I will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  12. What can MAGA’s do to stop Biden from cheating again?https://joellipman.com/component/content/article/what-can-maga’s-do-to-stop-biden-from-cheating-again.html?catid=122&Itemid=165

    and John Deere tractors. The guy comes back a third night and this time when asked says, "About 50." The robot leans in real close and says, "Isn't it terrible the way Biden stole the election?" Source:

    • Type: Article
    • Author: Joel Lipman
    • Category: Jokes
    • Language: *
  13. Making a CD copy with only one drivehttps://joellipman.com/component/content/article/making-a-cd-copy-with-only-one-drive.html?catid=80&Itemid=165

    the drive With the disc in the drive, click on RETRY In the Record CD Process dialog box, click on OK Eject your disc and close the Easy CD Creator software

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Add "Command prompt from here" to right-click context menuhttps://joellipman.com/component/content/article/add-command-prompt-from-here-to-right-click-context-menu.html?catid=80&Itemid=165

    c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program) Click on OK > OK > Close Notes: Added by default since Microsoft Windows 7

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. MySQL Transactions in PHPhttps://joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    $mysqli->commit(); } else //Something went wrong. Roll back to before begin_transaction() $mysqli->rollback(); } $mysqli->close(); mysqli->begin_transaction() requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like:...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
  16. First and Last Entry on a Page using Modulus Remainderhttps://joellipman.com/articles/cms/website-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

    to start writing a DIV layer in the code at the start of the loop (and at every first entry of a page). I want the script to close the DIV layer at the last entry of each page. So I have a loop Rather crude but it's a FOR loop for those old CMS's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 41 - 56 of 56