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

  1. Returned a data type that is not validhttps://joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

    been told that data types are a nightmare in SQL Server Reporting Services and that all data types should be kept in their original state and then queried in the same state.

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  2. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

    long have you been a developer? And this is new?). Can the developer be contacted? Yes! Questions to ask the developer The original client's brief for the project? (project mandate/charter/initiation document - the spec) Details on the Development...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  3. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    did my 153 (has done a few times over quite quickly due to testing). Options/Features Source Browser Size: Sets what the original picture dimensions are. Output Thumbnail Size: Only several presets but there are free image editors out there that will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  4. Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    COM Tutorial for Webpages I would recommend tank's iWeb Functions, which are designed to make web automation more simple. (original is AHK Basic only, but here is an AutoHotkey_L Version by sinkfaze) Basic Webpage Controls COM Object Reference Last...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  5. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    the JComments comments to be associated to articles from your Joomla 2.5 site (no changes to article IDs but backup your original database (J1.5) anyway before running the following): UPDATE my_joomla_1_5_db.my_1_5_db_prefix_content j1a, -- Joomla 1.5.x...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy a given table into a temporary table...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  7. DataTumble - Randomize Data Rowshttps://joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

    process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA', 'ColumnNameA'; ** ** ** ** EXEC...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  8. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer returned when executed: My columns were being pushed out of...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  10. SSIS Multiple Lookups in onehttps://joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

    and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a proof of concept, I...

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

    changes (this also lets you change the name of the aircraft & configuration) Uninstall and re-install app to restore with original data (My DJI Phantom FC40) Currently you can only have 1 aircraft; but the next version of this app is expected to hold a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    the first two entries from a RSS feed produced by a bunch of java files collectively known as "SimpleRssReader. Why? The original file reads of a feed from PCWorld.com. I adapted this to read a google news rss feed and the first two entries are " -...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  13. Sort an associative array by values in Javascripthttps://joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

    how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an excuse. I also found that examples across the web were only partial and thought I'd...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  14. Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

    { for each r_Field in r_Fields.get("fields") { l_FieldApiNames.add(r_Field.get("api_name")); } } // get details of original invoice r_Invoice = zoho.crm.getRecordById("Invoices", p_InvoiceID); // start map m_Clone = Map(); // loop through field names...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Deluge: Sort a Map by a specific fieldhttps://joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

    for each v_SortKey in l_SortedKeysDesc { m_ThisRecord = m_UnsortedRecords.get(v_SortKey); info m_ThisRecord; } Recap The original sample data l_MyListUnsorted looks something like this in a JSON parser: [ { "name": "Joel", "id": 46498, "date":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    "entity_Id": 345678901234567890, "mode": "pdfViewPlugin", "original_Size_Byte": "13264", "preview_Url":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

    all CSS references need to be changed as well to the new name and follow the syntax .zc-NewName-group{}]. What I have (Original) I want to run some deluge (snippets below) every time the form loads, so I Go to Workflows > Form Workflows > Select your...

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

    of getting an MS Word document to behave?). Best thing to do if you mess it up, is just start again with a clone of the original erroring template. Conclusion Just clutching at straws here with wild guesses but thinking that making the change makes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    name (optional) To check on filename changes, I run this bit of code to get the internal and current file name: // // get original document file (optional) - you need your own record ID here v_ZC_DocumentRecordID = 1234567890123456789;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    a_NewSuformRows = []; // if final balance, then include the line items from the quote / if deposit, then don't include the original line items if (v_InvoiceType == "Final Balance") { // now loop through the quoted items / line items for (i = 0; i...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • 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.