Assuming object is required, the following 48 results were found.
-
the property in the connection string does not supercede the individual command timeout property on an individual command object. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;default command timeout=20; This option is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
to END (excluding the words BEGIN and END - avoids the need to create a stored procedure and saving it on a database): IF OBJECT_ID('usp_CountRecordsPerTablePerColumn', 'P') IS NOT NULL DROP PROCEDURE [usp_CountRecordsPerTablePerColumn]; GO CREATE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Max length 4294967295 characters (4GB of text) Length of string + 4 bytes String Enum ('value','value2',...) String object that can have only one set of allowed values 1 or 2 bytes String Set ('value','value2',...) String object that can have one or...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
something that can emulate a random number... well it's not really random, it involves getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters Using a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
chat completion Zoho Community > Zoho Cliq > Configure ChatGPT in Zoho Cliq (Poorvik Palanikumar) Zoho Cliq - Message Object
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
Was happening when I was trying to update the Zoho Creator record, specifically the file upload field, with the file object directly, eg. .=. 2945: UPLOAD_RULE_NOT_CONFIGURED Also got this error if I failed to add the setParamName such as:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
delivery Wikipedia - List of HTTP status codes Zoho CRM Developer Docs - Serverless Functions - Request and Response Object Joel Lipman - ZohoCRM & Xero Real-Time Invoices: Receive Webhook
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
(i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
i++) { // initialize new line item var o_NewLineItem = {}; // store this line item as an object o_ThisLineItem = o_QuoteDetails._Product_Details[i]; console.log(o_ThisLineItem); // assigning to a lookup field (Product) var o_ProductDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
$_GET['id']); if ($result = mysqli_query($db_connect, $query, MYSQLI_USE_RESULT)) { while($obj = $result->fetch_object()){ $content_count = $obj->ArticleCount; } } } echo $content_count; mysqli_free_result( $db_connect ); Clear as mud? Feel free to use...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
row disposition on "output column "DC_This_Date" (3833)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
error row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
of Row: foreach (PropertyInfo p in Row.GetType().GetProperties()) { try { // Check type for all string properties if (object.ReferenceEquals(p.PropertyType, typeof(string))) { // declare two arrays string[] exceptionArray_this; string[]...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
with no name. Show hour in top column only on the hour =IIF(MINUTE(Fields!Time.Value)=30, "", Fields!Time.Value) Make the object in the cell a block (which I made big and then didn't allow cell to increase/decrease height). This way when it's printed...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
work or didn't apply for me. I had to insert a rectangle that separates the textboxes (so fills up the empty space with an object)... The visibility expressions for both hiding and displaying either the textbox or the tablix has to be applied to both...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the ReportServer....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Connections ncpa.cpl Network Setup Wizard netsetup.cpl Notepad notepad Nview Desktop Manager (if installed) nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (if installed)...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB