Assuming rows is required, the following 62 results were found.
-
type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse response l_DataRows = ifnull(r_PurchaseOrders.get("data"),List()); // // build up related list header row l_HeaderColumns = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
$mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $a1=$mysqli->affected_rows(); $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'"); $a2=$mysqli->affected_rows();...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
such as JomSocial, K2 and phpBB3. The template's core feature is Sortable Elements, which allows for the movement of modular rows, individual positions and stacks of modules Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sit amet nibh....
- Type: Article
- Author: Webmaster
- Category: Joomla
- Language: *
-
for the mess coding but it's a mix between HTML and autohotkey syntax (note we're making a table with 9 columns and 6 rows - there's a spacing column on either side): htmlText:="" htmlText:=htmlText " " htmlText:=htmlText "" htmlText:=htmlText " "...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
1: Fields in the same column are not aligned with guidelines or snap-togrid To prevent fields from appearing in different rows, horizontally align fields with guidelines: In Design view, click the vertical ruler to create a vertical guideline. Click one...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html
only the first error is recorded ByteCountbigintNOT NULLSize of rendered reports in bytes. RowCountbigintNOT NULLNumber of rows returned from queries. Conversions Needed: I want to convert a start and end date to a single time value (hours minutes...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
// I don't have a report that takes over an hour to process but in theory this should accommodate it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has two rows, both with the typo: ** ** Row1: EthnicCode DnYa ** ** Row2: RegionCode DnYa ** ** -> Only Row1 will display in column source...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum Source(s): MSDN Microsoft Library (DATEPART (Transact-SQL)) MSDN Microsoft Library (DATENAME (Transact-SQL)) MySQL...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Needle2 - Needle1 NeedleMarker := Needle2 ReturnedHTMLTable := SubStr( Haystack, Needle1, NeedleLen ) ; split the table into rows StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,,|,A ReturnedHTMLTableRows=%ReturnedHTMLTableRows%...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
requirement example. Note that we have two events on the Thursday. A few things we have to deal with still: We have lost the rows with days that have no events. We need to group by days so that each day only outputs one row (see Thursday). We want the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
report and instead the whole report acted as a header on top of the scrolling content and would only ever display, the top rows of the dataset. Why? A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
NULLs so, our sequence identifier and student reference are never blank so it is safe to to use "Lookup Match Output" as rows with neither sequence nor student reference will not come through the system. Lookups that failed will return as NULL....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
To: MS Windows 10 Pro v10.0.18362 Build 18362 (64-bit) Google Chrome Browser v79.0.3945.88 (Official Build) (64-bit) AutoHotkey v1.1.30.01 What? This is an article to create a standalone application which lists all the Google Chrome Profiles on your...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
{ // set an if condition if(r_Record.Type == "Subform1") { // store the first subform into a collection c_SubformRows = r_Record.mySubform1; } // set an else if condition else if(r_Record.Type == "Subform2") { // store the second subform into a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
values based on the filters I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing the sale person name. Something like the following: With these kind of columns available to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a subform which gets autopopulated with a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time of print, this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 to a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM and at least 1 line item is mandatory l_CrmProductLineItems =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: we'll generate the CSV rows and then a file; then we'll use invokeURL to upload the file. Generating the CSV Here's the simplified code to generate the CSV...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *