Assuming field is required, the following 152 results were found.
-
record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the quick answer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
// get the full name of this contact (not sure why this returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var v_ContactEmail = ZDK.Page.getField('Email').getValue(); // get the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any query and any field. It doesn't matter which one here, as long as I can get to the 3rd tab of the widget (it becomes enabled once you've...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Cross your fingers and use your DB management tool to run the SQL file (or copy the contents of the SQL file into the input field) Re-build/Auto-correct some Joomla inconsistencies Login to your Joomla Admin Panel using a System Administrator account...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
= $db->query(); for Joomla 1.5.x Basic Query - 1 result $db = JFactory::getDBO(); $query = " SELECT ".$db->nameQuote('field_name')." FROM ".$db->nameQuote('#__my_table')." WHERE ".$db->nameQuote('some_name')." = ".$db->quote($some_value);...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
3. and replace with: // Replace YOUR_KEY with your public key return ' window.onload = function() { Recaptcha.focus_response_field(); } '; } Additional This applies to a case where the code WAS working and without any changes to the server (no updates),...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
curl_setopt($ch1, CURLOPT_BINARYTRANSFER, 1); curl_setopt($ch1, CURLOPT_POST, 1); curl_setopt($ch1, CURLOPT_POSTFIELDS, file_get_contents($file)); curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch1,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example here is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Series1 is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data fields) Invidividual the incident(s) are assigned to (Labels -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Customize the Toolbar (Advanced) To enter custom code for a report, view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse button next to it to edit. Visit...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
there. Adding Events Again I've put two rooms as examples in the above script. The "Events" table needs as a minimum the 4 fields "Room", "EventStart", "EventFinish", and "Status" ("Tooltip" was for me so that when the user hovers the mouse over the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Values – Specify values" to =IIF(LTrim(Parameters!StudentADAccount.Value)="", Parameters!StudentReference.Value, First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because "fields cannot be used in report parameter...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
with our stored procedure is Oracle 10g. The Stored Procedure Rather than a returned dataset, our Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Report passes parameter to dataset which gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level parameter check Add IIF in SSRS...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
WHERE ID = @ChosenID SELECT @UpdateData = Data FROM #Scramble WHERE ID = @ChosenId -- To dynamically update the Data in the field being scrambled SET @UpdateSqlStatement = ' UPDATE ' + @TableName + ' SET ' + @ColumnName + ' = @UpdateDataIn WHERE CURRENT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
string together; then remembers it's a Microsoft by-product and realises it can't. Solved by checking the datatypes for each field in the concatenation string: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
attribute "financialyear" of CURRENT_EMPLOYEE (eg. "2014") In a WHERE clause To select records matching a value for the XML field: SELECT * FROM [dbo].[XML_EVENTS] WHERE CAST(Event_XML AS XML).value('(/STAFF/GENDER="MALE")[1]','VARCHAR(10)')='TRUE' AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB