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

  1. Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

    1 second for transition 'opacity': 1,'top': 0,'left': 0,'height': v_win_height,'width': v_win_width }); }); }); }); Known Issues If the end-user clicks too quickly between slides, the slides are not ready or not in the right position until after 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  2. Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

    value: ** ** Automatic: ** ** @minStringLength and @maxStringLength are calculated based on original value. ** ** ** ** Issues : ** ** Will pick up variations with trailing spaces but this is not easily recognized from the results ** ** ** ** Only finds...

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

    CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  4. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

    of this is that you can send this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  5. SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    doesn't work) (DT_DATE)(SUBSTRING(This_Date,1,2) + "/" + SUBSTRING(This_Date,4,2) + "/" + SUBSTRING(This_Date,7,4)) Known Issues [Convert Date [4228]] Error: An error occurred while attempting to perform a type cast. [SSIS.Pipeline] Error: SSIS Error...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  6. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

    type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM [dbo].[XML_EVENTS] Issues: XQuery [value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *' This is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  7. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    first file including its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any issues) Add a Connection Manager Right-click in "Connection Managers" Select "New Flat File Connection..." Browse to the first file...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    Map: wind and weather data v??? In Development: - Map: specify weather forecasts for a day - Map: current location response issues - Map: screenshot for offline use - Map: enable news feed on HUD - Map: enable hangar on HUD - Map: nearest hazard (7 or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

    well Form attributes I have set these to the following: action = /index.php?option=com_search method = post role = search Issues Further searches do not include the same filters. This will be because the setting to display search areas has been switched...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    JWC to avoid conflicts with 3rd-party apps. - Restructured extension into an MVC model (fixes H3 and Module Class Suffix issues) - Removed Joomla! Admin Option: Content Database Length - Date Uploaded: Mon, 13th Jun 2011 1.6.3- Core script reverted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  11. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

    "newvalues": [ { "FieldToUpdate": "ValueToUpdateWith" } ], "status": "Success" } ] } ] } Encountered Issues: #2945 INVALID TICKET: Ensure you are using creator.zoho.com or creator.zoho.eu for your endpoints as appropriate. #2945...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  12. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

    I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search Records via API I won't go into detail on how to set...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    the dialog on the receiving page, you can add the following code: openUrl("#Script:dialog.close","same window"); Known Issues Popup opens in the parent window: This only happens on certain machines and I couldn't narrow down the cause. I have tested on...

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

    ahead] We tried various other options such as adding a tickbox that would be used in an approval workflow but ran into issues when trying to update the record: { "response": { "message": "Error occurred", "uri":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    the function to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues around tweaking the function and getting it to understand basic mapping and attachments. How? As per our use-case above, we are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

    dots Select "More tools" > "Developer Tools" Caveats Only make the changes necessary to how you like it. You will find issues with trying to undo some parts and tweaks as these will consume a lot of time (anyone remember the days of getting an MS Word...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    */ // // list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = {1}; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex = (v_Page - 1) * v_PerPage; v_ToIndex =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    want CRM to include this rich signature (different per user) at the bottom of the email message. How? So there are a few issues with displaying images which would have other solutions, such as hosting the images on a web-server, or converting to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    Image URL, Created Time, Modified Time Add a dummy row with data that is expected to be in the rows (ZohoAnalytics may have issues loading a file with only headers) Click on "Create" then "New Table/Import Data" > Select "Files" (the one with the Excel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. MyALN.bournemouth.ac.ukhttps://www.joellipman.com/component/content/article/myalnbournemouthacuk.html?catid=33

    is a web-project where the original developer ended their support for the site. I was called in to fix several underlying issues and integrate it into the university systems. The Additional Learning Needs team at Bournemouth University use their website...

    • Type: Article
    • Author: Joel Lipman
    • Category: Portfolio
    • Language: *
Results 21 - 40 of 43

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.