Assuming submitted is required, the following 33 results were found.
-
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
-
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: *
-
article with all the answers of one development but this one may be referred to separately. I want a Zoho Survey when submitted to be parsed by a Zoho CRM REST API function. How? First, I'll go through the steps of setting up the Zoho CRM function,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 Deluge
- Language: en-GB
-
"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 Books
- Language: *
-
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 CRM
- Language: *
-
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 Creator
- Language: *
-
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: *
-
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
-
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: *
-
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
-
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: *
-
- Type: Article
- Category: Static Items
- Language: *
-
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
-
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: *
-
"Partners Quote". Within your function you can use the following as a reference. In theory, you could loop through each submitted quote but I do a call at the beginning of each iteration of the loop to retrieve all the data in each record r_QuoteDetails...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to look like a button; then add a workflow on click of this field. Set the form to reload the existing record when it is submitted (either on "Successful form submission", or on properties "On Successful Submission" > "Direct To", or my favorite, Deluge...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Tue, 7 Jan 1975 Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function if the .get is an out-of-bounds and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew a HTML entity would be submitted. So it doesn't decode every HTML in existence, only the ones I know will happen. Here's the Zoho Deluge code I use (note...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the 2nd; this equals the RGB value. Given #00FF00 // // given value v_HexGiven = "#00FF00"; // // transform or format the submitted value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *