Assuming value is required, the following 197 results were found.
-
; determine markers (character positions) Needle1a := " My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole content Needle1b := " " ; Needle1b is a marker for a value located after Needle1a Needle2a := " " ; Needle2a is the...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
a 15 second timeout curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); // TRUE to return the transfer as a string of the return value of curl_exec() instead of outputting it out directly. // store the response $ch_result = curl_exec($ch); // close...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
to populate the field. Why? At the moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE STRING option2 can be: U (for Uppercase) L (for Lowercase) A (for AlphaNumeric) X (for Alphanumeric with upper case alphabets)...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
(or "JSM"). Other Areas: One of the parameters is entitled "Search Area". This is the component to search so other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
"Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This will output a picklist which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Happens if you don't convert the field-value pair dataset to a string: m_RecordData = Map(); m_RecordData.put("Field_To_Update", "Value_To_Put"); m_Data = Map(); m_Data.put("data",m_RecordData.toJSONList()); r_RecordUpdate = invokeUrl [ url :v_EndPoint...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
Type: set this to "Header" Grant Type: set this to "Authorization Code" Client ID: Copy & paste from the previous step this value into this field. Client Secret: Copy & paste from the previous step this value into this field. Authorize URL: Enter the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
ZC_SUBFORM_250 expression found COLLECTION expression Another error you may get when using the deluge script is: LIST value cannot be assigned to 'mySubform' -- or -- COLLECTION value cannot be assigned to 'mySubform' or expecting ZC_SUBFORM_70...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
in r_Response.get("fields") { if(r_Field.get("api_name") == "Customer_s_Timezone") { // loop through all the picklist values of this dropdown for each r_TimeZone in r_Field.get("pick_list_values") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
]; info "Marked as Delivered:"; info r_Delivered; } } } } Error(s) Encountered {"code": 4,"message": "Invalid value passed for salesorder_id"}: Not sure about what ended up fixing this one. I think I converted the sales order to an invoice and created a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
+ v_RequestId; r_RequestDetails = invokeurl [ url :v_Url type :GET headers:m_Header ]; // // retrieve the value of field "Deal_Ref" from the ZohoSign Document Request v_DealRef = ""; if(!isnull(r_RequestDetails.get("requests"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
key is mandatory when you include Who_id and What_Id. FREQ (String): Defines the frequency of the reminder. The possible values are DAILY, WEEKLY, MONTHLY, YEARLY, NONE. If you specify, NONE, the system sets a one-time reminder and TRIGGER becomes...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
update CRM API v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 // m_RecordData should have value from last iteration m_UpdateQuote.put("Subject",m_RecordData.get("Subject"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
each v_Field in m_ThisGoal.keys() { m_OutputRecord.put(v_Field, m_ThisGoal.get(v_Field)); //info "Field: " + v_Field + " || Value: " + m_ThisGoal.get(v_Field); } m_OutputAll.put(v_GoalKey, m_OutputRecord); } } // // for testing I'm doing 3 records at a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *