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

  1. Submit form as a server and not the client with cURLhttps://www.joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    accepts requests from a static and permitted IP address. If the end-user were to make the request, then their own IP address would be the one checked against, and it just wouldn't be manageable to add every new user's IP address to their service. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  2. Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  3. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    exported report when we followed that suggestion. Consider the following report in design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same height and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report to the server, configure the web application to use the newly uploaded report, export to a Crystal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  5. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want it sorted in descending order, I would recommend you return it in SQL date format (yyyy-mm-dd) and then do "Sort Z to A". You may find that the field needs to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  7. Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    Additional Others around the web have suggested the following but I don't have these options to grant and would have to grant them via a terminal/command line to MySQL. GRANT SELECT, LOCK TABLES, RELOAD, PROCESS, TRIGGER, SUPER, REPLICATION CLIENT, SHOW...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  8. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    (if already installed it just lets you click on "Ok"). Initially I got a support agent from GoDaddy to do this who said it would take about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working....

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  9. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/articles/else/graphic-design/joel-s-guide-to-midjourney-prompts.html

    suffix Type Type the parameters you want as default Press /settings Settings will default some settings although, again, I wouldn't recommend these if you're just starting off. Leaving these on default as you experiment and become more familiar with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  10. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket for the amount on the cheque and the amount you passed on as the difference. Fake escrow sites. A...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  11. Zoho Books: Attach a document to a bill using Deluge / REST APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-attach-a-document-to-a-bill-using-deluge-rest-api.html

    and then attach the received invoice to the Bill). How? The key part that I was missing was step 2 in the below. Otherwise I would always get the error {"code":2,"message":"The request passed is not valid."} Note this is on the EU domain and with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. COVID-19: Working from Homehttps://www.joellipman.com/component/content/article/covid-19-work-from-home.html?catid=45&Itemid=165

    I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  13. On Gui Resize Eventhttps://www.joellipman.com/component/content/article/on-gui-resize-event.html?catid=48&Itemid=165

    GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the image repeating... so use moveDraw which...

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

    respond to the ENTER key after you typed something (this is for a search feature) in addition to having a button if the user would rather click then press the ENTER key. Then create the mouseover and mouseout effects afterwards. Add the image for your...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  15. AutoHotkey Ternary Operatorhttps://www.joellipman.com/component/content/article/autohotkey-ternary-operator.html?catid=48&Itemid=165

    languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there are a whole bunch of methods using the Ternary Operator in...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  16. Mouseover Links in AutoHotkeyhttps://www.joellipman.com/component/content/article/mouseover-links-in-autohotkey.html?catid=48&Itemid=165

    as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a more stable solution. I would however recommend cwebpage.dll at as a minimum for internal HTML pages for use in an AutoHotkey GUI.

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  17. Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

    and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard would be: v_CrmTime = "2021-01-01T01:23:45+01:00"; v_CreatorTime = v_CrmTime.getPrefix("T") + " " + v_CrmTime.getPrefix("+").getSuffix("T"); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

    course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote: This cannot be done by joomla administration but can be done by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. After installing rokstories, get invalid argument 106https://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

    After I installed the rokstories module from www.rockettheme.com, if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

    enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - SEF URL http://www.joellipman.com/support/documentation/449-module-joes-word-cloud-jwc.html - Direct Link...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 181 - 200 of 213