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

  1. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    earliest someone starts work that day. EndTime will be the latest someone works that day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button simply...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  3. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    of your datacenter: MM-dd-yyyy) - bill_status (either "Billable" or "Non Billable") - hours (eg. "01:00") - notes (the actual work notes: eg. "Twiddled thumbs and spun on chair") // fields required if submitting time lot with a start date/time - date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  4. ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

    your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will stop when it's reached the end of the list as per eBay and not what you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had...

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

    local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing (or whatever your script is trying to do). Method #2: FileSystemObject ComObjCreate UserFolder:="C:" -- to...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  7. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    use of that class of product, regardless of the status of the particular user or of the way in which the particular user actually uses, or expects or is expected to use, the product. A product is a consumer product regardless of whether the product has...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  8. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    what you're about to do. Save and Close the notepad file Return to the command prompt and type rename.bat (This does the actual renaming of the files). Type the following DELETE rename.bat (removes it from the users computer) Exit the command prompt and...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  9. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    Quality: allows you to specify smaller/bigger files (haven't noticed much difference in how they display, only in the actual size the image uses of disk space). Output Thumbnail File Type: can be BMP, GIF, JPG, PNG or TIF Time between page load and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. 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

    it with "l_" (for list) and the plural of what kind of records I am sending as parameters (in this case "Quotes"). As the actual parameter value, select the form which is the singular of the records that you are sending (in my example here I have a form...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-manage-a-subform-using-client-script.html

    compare to the rows already present in the subform // first column to add in this row is start date (retrieved from field "Actual Start Date" on this record) var v_StartDateValue = ZDK.Page.getField('Actual_Start_Date').getValue(); var v_LocalStartDate...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" which is the file name as it is to be displayed in ZohoCRM). For example...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    orders you think you have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    = invokeurl [ url :v_ImageSrc type :GET connection:"zdesk" ]; f_DownloadFile.setParamName("file"); // // add into subform (actual form "Document"). Uses row.ID as the identifier to prevent duplicates. c_CheckDoc = Document[Subform_Row_ID ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    " + v_TotalCategories + " categories across " + v_Page + " page(s)."; Additional: Total product count may differ from the actual product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-nested-catch-statements.html

    Note that before anyone says I'm only try catching a doomed conversion from string to integer; I've applied this to an actual invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [ url: v_EndpointServer1 type: POST...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

    Change Page Title in Website Here are some instructions on changing the page title in Joomla! CMS to display both the actual page title and other stuff. As I like doing this for this particular website (my personal one) in every version of Joomla it's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

    systems... Do not uninstall/install other modules/components as I believe this is some issue with overloading or with the actual code and you can get to this file manager to work without changing your Joomla! setup. Watch this space for when I find a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    just a piece of paper and proof you're good at theory IMO, no credit for being the tape monkey that does all the actual work.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    For each row in the pipeline buffer it loops through each of the input columns passed into the component // It locates the actual column value (including checking for null) using the index array created in the Pre-Execute public override void...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
Results 1 - 20 of 28