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

  1. Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    number of 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; // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *

  2. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    J2.5.x without issue. I have managed to do whole migrations in under 2 hours (this script runs in about 20 seconds based on 1000 articles and 5000 users) and my clients are satisfied! I am so pleased I made this script; it has saved me so much time!...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  3. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    (BIDS / VS2008), the IDE would crash and close without warnings or notifications. We found that if the query only returned 1000 rows, it completed and displayed in just under 1 minute. If limited to 500 rows, it would complete in just under 40 seconds....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  4. 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

    Letter Decimal Hex A 1 1 B 2 2 C 4 4 D 8 8 E 16 10 F 32 20 G 64 40 H 128 80 I 256 100 J 512 200 K 1024 400 L 2048 800 M 4096 1000 N 8192 2000 O 16384 4000 P 32768 8000 Q 65536 10000 R 131072 20000 S 262144 40000 T 524288 80000 U 1048576 100000 V 2097152...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  5. Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/else/database/cheat-sheet-for-mysql-vs-t-sql.html

    * 60) + (DATEPART(second, getdate())) Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms, seconds * 1000, 0), 114) Add/Subtract Date DATE_ADD(date,INTERVAL number datepart) DATE_SUB(date,INTERVAL number datepart) DATEADD(datepart,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  6. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    and the number of times I refresh the page and upload files. Why they think that developers should not be able to send a 1000 queries a minute or why a developer has to refresh the page, make a change, upload, etc. well it's beyond a joke and no one...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  7. Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    specified JS then takes over and runs the time var seconds_remaining = ; var seconds_elapsed = ; setInterval('showTime()', 1000); function showTime(){ seconds_remaining--; seconds_elapsed++; if(seconds_remaining>=0){...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *

  8. Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-user-timezone-country-and-location.html

    list of free 3rd-party APIs and the below code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( v_Url );...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB

  9. DBMS Random Referencehttps://joellipman.com/articles/else/database/oracle-pl-sql/dbms-random-reference.html

    random number, eg. 68489408 select dbms_random.value from dual; -- yields values between 0 and 1 select dbms_random.value(1,1000) myAlias from dual; -- yields number between 1 and 1000 select dbms_random.string('U', 10) myAlias from dual; -- yields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
Results 21 - 29 of 29