Assuming data is required, the following 229 results were found.
-
Invited Sent Me Web Invited Accepted Sent Myself Walk-In Accepted Sent Invited The catch is that our campaign names are in data rows not individual columns. How? There may be ways of doing this using the GUI and a "Pivot View" report but I always resort...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
include these in her estimate template... But I'm sending them anyway. Note(s) The following code accesses APIs on the EU datacenter. I have a connection called "zbooks" which has the necessary scope(s) to create and update an estimate as well as read...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
zoho.appname, "Quote", m_QuoteRecord, m_Blank, "my_creator_connection"); // // SUCCEEDS: with r_Create = {"code":3000,"data":{"ID":"1234567000012345678"},"message":"Data Added Successfully"} Source(s): Zoho Creator / API Status Codes Zoho Community /...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the vertical ellipsis icon in the top right v_ReportLinkName = "All_Weekly_Calendar_Caches"; v_FileUploadFieldName = "Cached_DataFile"; v_RecordID = c_Check.ID.toString(); // // using API upload file endpoint (either endpoints seem to be valid)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// get created time (no need to check if null?) v_LeadCreatedTime = r_LeadDetails.get("Created_Time"); // // convert to time datatype v_TimeOffset = (v_LeadCreatedTime.subString(0,10) + " " + v_LeadCreatedTime.subString(11,25)).toString("yyyy-MM-dd...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Mine 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: *
-
1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
their full name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
NOT NULL DEFAULT 'DefaultString' COMMENT 'A Comment' AFTER other_column; Alternatively Export the file as a SQL file (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
+1 END -- remove any leading and trailing spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous rules SET @Ret = UPPER(SUBSTRING(@Ret,1,1)) + SUBSTRING(@Ret,2,LEN(@Ret)); END ELSE BEGIN -- return the string...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00 00:00...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
So this is an article to serve as documentation for one of the data sources available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a refreshable...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
sometimes) Service Transition Security rights/roles in the system (reasons for different accesses) Get all known logins (database, ftp, sftp, ssl, site logins: test & admins) List all files, their purpose (consider a spreadsheet of all active/legacy...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
form is setup to do this:...... The form above will post to itself but more importantly is the enctype="multipart/form-data" without which your file upload processing won't work. The name of the file is important but you can call it what you want, in...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
key or unique element list Defines a simple type element as a list of values notation Describes the format of non-XML data within an XML document redefine Redefines simple and complex types, groups, and attribute groups from an external schema...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB