Assuming rows is required, the following 64 results were found.
-
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
-
found COLLECTION expression How? Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to what the documentation that says "This task can be used in the following events", effective as of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
in row 1 (odd row numbers) and a very light grey (=#eeeeee) in row 2 (even row numbers). The first row being of all rows in the dataset and not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
** Assumptions : None ** Inputs : @StringInput = the space separated string values ** Outputs : Single table ** Output Rows : One row per space separated string value ** Return Values : None...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
ORDER BY Score DESC LIMIT 0, ".$maximum_number_of_results_from_db; $terms_rx = search_rx_escape_terms($terms); $results_rows = array(); $result = mysql_query($filter_sql); if ($result) { while($row=mysql_fetch_assoc($result)) { $row["Score"] = 0;...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
report, click on "Get embed Code" (ensure this report is published) Get the Permalink and copy and paste this into a new browser window/tab Right-click on one of the file upload/attachments and copy the link Return to your code and customize the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with data that is expected to be in the rows (ZohoAnalytics may have issues loading a file with only headers) Click on "Create" then "New Table/Import Data" > Select...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
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 Books
- Language: *
-
-- USERGROUP MAPPING -- ********************************************************************* -- Note-to-self: Delete rows other than the admin ID -- DELETE FROM `v34_db`.`v34_user_usergroup_map` WHERE `user_id` @v25_admin_id; --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
My Most Frequent Fix: The data files I have to work with are rarely consistent. On some rows the date column will have a string of 8 characters long in the format DDMMYYYY and on other rows, this is blank with spaces instead, I still get the Error: The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
(type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the rows as... rows. My pic above shows my 4 reports results side by side. To do this, I had to insert a Matrix rather than a Tablix:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design the Matrix: Ok so we want weekday in the columns (to have mon-sun along the top), "Order" in rows (order is which...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
@stringtoFind, @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
at the centre) and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has too many rows to fit on one page, and this overlaps onto...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *