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

  1. Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/else/database/create-read-only-database-user-in-sql-server.html

    Select Properties. Select User Mapping. Map the login to the database they will have access to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  2. Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive/zoho-workdrive-getting-team-folder-id.html

    { v_WorkdriveFolderID = r_WorkdriveFolder.get("id"); // // ====================== // share folder to members woh can access it (read-only) // // list of recipients l_WorkdriveRecipients = {"me@mycompany.com","payroll@mycompany.com"}; // for each...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Workdrive
    • Language: *
  3. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    saying, but you are not permitted to hack the board. Guessing someone else's password and succeeding counts as hacking. Members who hack will instantly be permanently banned without any warnings. No Discrimination, - You may not insult members based on...

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

    on their services, or re-evaluate their fees, hint hint ). By the way, it's hard for me to tell which of my members are humans and which are just for fun, so don't share any of your details with other members (in fact do the opposite of a social network...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes) Prevent an employee for applying for leave if over 80% of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  6. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

    Unlimited RokTools 224 €* ($300) Support Thu 22:00 April 2010 Established YooTheme Forum Video Tutorials Twitter ? guests 6 members online January 2007 Gavick Pro Forum Twitter 456 guests 49 members online May 2007 RocketTheme Forum Twitter 8282 guests...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Terms & Conditionshttps://www.joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    to help other registered users to distinguish between official Joel Lipman .Com website administrators and other registered members. WEBSITE USAGE Welcome to our website. If you continue to browse and use this website you are agreeing to comply with and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  8. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    is based on breach of contract, breach of warranty, negligence, strict liability, or other tort. Privacy Policy What other members know about you: • If shared, your public name (not unique and only the first name) • Your selected aircraft (by public...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zohoanalytics-pivot-campaigns-vs-contacts.html

    vs Campaigns Pivot": SELECT * FROM ( SELECT "Contact Id", "Contact Name", "Campaign Name", "Member Status" FROM "Campaign Members - Contacts" ) t1 PIVOT ( MAX(t1."Member Status") FOR t1."Campaign Name" IN ( "Campaign 1","Campaign 2","Campaign 3" ) ) t2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  10. Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    the payment side and the complicated tasks of invoicing, but Community Builder provides more options for your website members. If Joomlapolis ever complete the CB Subscription component then there is no need for AEC anymore. For this we're basically...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    respective articles and users. Most of the users as per -- previous steps will match up, anonymous users (non-registered members) -- will be migrated without association (retain UserID=0). The article IDs -- should also match up. --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  12. Report Builder 2.0 - Hide Series1https://www.joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest...

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

    and links on the WWW are no longer valid, I've uploaded their zip just in case to my own site available for non-registered members at http://www.joellipman.com/features/downloads.html?func=fileinfo&id=12. Install IE7 from Microsoft's website. Reboot if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. MySQL last year week month day trend periodshttps://www.joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    find the Spanish character 'ñ' as well as 'n'. To use this operator, specify [=character=], to find all characters that are members of the same character equivalence class as the specified character. For example, the following regular expression could...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  16. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    for thumbnails. - Parameter: Specify Weblink Category - Parameter: Use access levels (so if restricted to "Registered" only members will see the link) - Parameter: Use cache mode - Parameter: Debug Mode - Parameter: Powered By - Parameter: Thumbnail...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  17. 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

    require a face to face interview. Other work from home offers can be pyramid schemes which require you to recruit other members to get paid. For example, an ad might say that you can make £100 an hour by stuffing envelopes. But to make that money, you...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  18. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 1 - 18 of 18