Assuming results is required, the following 68 results were found.
-
Change contents of "original_file.txt" The first line of my code The second line of my code The third line of my code To "results_file.txt" 1: The first line of my code 2: The second line of my code 3: The third line of my code How? Open a MS-DOS...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
$out = array(); foreach($terms as $term){ $out[] = '\b'.preg_quote($term, '/').'\b'; } return $out; } # function to sort results by rank. # NOTE: does not seem to be working properly function search_sort_results($a, $b){ $ax = $a["Score"]; $bx =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
$query->order('u.real_name ASC'); // Reset the query using our new query object $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...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
'nchar', 'varchar', 'nvarchar', 'text', 'ntext') ** ** AND TABLE_SCHEMA='dbo' ** ** ** ** - For performance, return results based on string length which is 1 greater or lesser than the original ** ** string value: ** ** Automatic: ** ** @minStringLength...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
COUNT(*) AS CountOrder FROM table1 GROUP BY column1 ORDER BY CountOrder DESC LIMIT 0,10 PHP script to loop through the results of the above query Display the value of column1 and CountOrder The old code would have been: echo '# | Search Term | Count'....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
BY t1.Date ASC, t1.Start ASC, t1.Room ASC, t1.Finish ASC) as 'RowNumber' FROM ( -- start your original SQL query and save results as table t1 SELECT -- perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other sites have this solution as well so who...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
varchar2 ) IS BEGIN OPEN c_test FOR SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME; END; View the results? Oracle PL/SQL is a bit of a bugger as you need to do a few other things to see the results of this stored procedure. The...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
about 10 minutes without the possibility to cancel (link not working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
as long as you specify a link to its source. You can use this script as long as you don't hold me responsible for the results. If you don't understand what this script is doing, you shouldn't be running it. Please ask someone who does. -- IMPORTANT...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
where changes were made and how this affected the reports' performance. What? What I'm trying to do is display a set of results (comparing various reports) in a table and then to color the backgrounds based on whether they are the fastest or slowest in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
@search_string; EXECUTE search_string; SET COUNTER = @CNT_VALUE; #SELECT COUNTER; IF COUNTER>0 THEN # Inserting required results from search to table INSERT INTO temp_details VALUES(db,tbl,clmn); END IF; IF done=1 THEN LEAVE table_loop; END IF; END...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
2.5.x +, 3.4.x What? So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
data was missing. Perhaps by forcing the sort criteria to be by order of cursor alphabetically; but we were happy with the results the above code did anyway so I haven't tried this. Source(s): Shopify Dev - Paginating results with GraphQL
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:POST parameters:x_Params headers:m_Headers ]; //info "Response from eBay:"; //info x_ResponseBody; // // get pagination results from the first iteration/page if(v_Page == 1) { // // get page results x_PaginationResult =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *