Assuming rows is required, the following 62 results were found.
-
$db->setQuery($query); // Load the results as a list of stdClass objects (see later for more options on retrieving data). $rows = $db->loadObjectList(); // Retrieve each value in the ObjectList foreach( $rows as $row ) { $this_user_id = $row->user_id;...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
So What? The problem is that if the student does not have a username but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html
note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d),...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
var json_Row = new Array(); var json_Arg = new Object(); // get some values beforehand which allows us to compare to the rows already present in the subform // first column to add in this row is start date (retrieved from field "Actual Start Date" on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
What? This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
/ VS2008), the IDE would crash and close without warnings or notifications. We found that if the query only returned 1000 rows, it completed and displayed in just under 1 minute. If limited to 500 rows, it would complete in just under 40 seconds. and if...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
// // loop through Monday subform for each r_Row in input.Mondays { if(r_Row.In_Effect) { // get Monday entries/rows v_EventType = r_Row.Event_Type; v_EventStart = r_Row.Start_Time; v_EventEnd = r_Row.End_Time; // // create Tuesdays subform entries...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 the purpose of having anything...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
it populates only the first dataset with results; the remaining datasets that need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to insert separator rows so ideally we would like: Day ---------------- Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
return contents of target file to JS variable var my_csv_file_contents = xhr.responseText; // split contents into array of rows // store each line of the CSV file into a JS array var my_csv_rows_array = my_csv_file_contents.split("\n"); // declare a...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB