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

  1. Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

    LENGTH(p_original_value))-1; -- should yield eg. 999999 ELSE v_rand_param2 := p_original_range_2; END IF; -- Determined submitted value as 'INTEGER'; v_returnedval := TRUNC(DBMS_RANDOM.VALUE(v_rand_param1, v_rand_param2)); v_returnedval :=...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  2. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    Are you getting a lot of spam, or junk messages sent via your Joomla site? I know certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

    If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

    3 - LEN(@RandMSeconds))); SET @TimeVal = CONVERT(time, @TimeVal, 14); END -- DETERMINE WHICH DATE PARTS WERE SUBMITTED IF @TimeMatch=1 AND @DateMatch=0 SET @NewVal = @TimeVal; ELSE IF @TimeMatch=0 AND @DateMatch=1 SET @NewVal = @DateVal; ELSE IF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  5. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

    3 - LEN(@RandMSeconds))); SET @TimeVal = CONVERT(time, @TimeVal, 14); END -- DETERMINE WHICH DATE PARTS WERE SUBMITTED IF @TimeMatch=1 AND @DateMatch=0 SET @NewVal = @TimeVal; ELSE IF @TimeMatch=0 AND @DateMatch=1 SET @NewVal = @DateVal; ELSE IF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  6. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

    The code to update a form (sample data for demonstration purposes). Note that the payload here is submitted through URL parameters: v_AccessToken = "123abc456def789abc123def456abc"; v_Criteria = "ID=1234567890123456789"; v_EndPoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  7. CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

    sending it to me as I'm aware of width transitions for div layers). DEMO: See my JsFiddle jsfiddle.net/Jlipman/4kj96rL0/1 Submitted by Ike This version submitted as an update is a little smoother as it adds a font-size transition: ul li{ display:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  8. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    "attachments" parameter. As a reminder, content-type in the sendmail is not supported in Zoho Creator and nor is List when submitted as a file attachment. sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Testing an attachment"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    type :PUT headers: m_Header parameters:m_Data.toString() ]; when you should have done this (note that a list is submitted to data / could use .toJSONList()): l_Records = List(); l_Records.add(m_RecordData); m_Data = Map(); m_Data.put("data",l_Records);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    to enable bi-directional rather than via the tickbox. The below code is added to a trigger whenever the ticket form is submitted either on creation or modification. The function to rule-them-all This code was used for testing, then for correcting any...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    was generated by "http://www.notwebdesign.com/joomla-component-creator/". I don't need one because although I rely on data submitted through the forms ($_GET array), all the submitted data on the front-end of my component is controlled and not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

    dispute relating in any way to your visit to JoelLipman.com or to products you purchase through JoelLipman.com shall be submitted to confidential arbitration in England, United Kingdom, except that, to the extent you have in any manner violated or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  13. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

    . $_FILES["uploaded_file"]["name"], 0755); } } } else { if (trim($_FILES["uploaded_file"]["type"])=="") { echo "No file submitted for upload."; } else { echo "Invalid file type!!! You tried to upload a file type of ".$_FILES["uploaded_file"]["type"]; } }

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  14. Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

    the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that will be submitted (GivenDate and GivenCampus). Consider the following script: --...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

    on your ORIGINAL site. (you wont need the service as the image already exists...) Don't have a COPY of your Joomla site? (submitted by Webmaster de EDiSoPortal) Create a category for your weblinks (eg. "Helpful Links") Set the "quicklist weblinks"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

    rendering format. Mostly RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report finished running?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  17. Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

    and can be hidden from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists all the functions for a specified Dynamic Link Library (DLL) along with an inputbox for convenience:...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  18. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

    to display in milliseconds the execution time it took for a particular report (which searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other sites have this solution as well so who copied off who is not...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    in SQL Developer (or SQL*Plus, etc.) Hardcode your parameters in the SSRS report with actual values that would have been submitted. Create the most basic report you can with the data you're working with just so you can get used to how this works....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    the rewrite rule is: RewriteCond %{REQUEST_URI} ^/([\w]+).html [NC] But, er, I like that first check (myFolder) that the submitted URL matches the format of your site (and a lot more opportunity to check for malicious code).

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 1 - 20 of 30

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.