Assuming results is required, the following 70 results were found.
-
find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey. Apparently this will be done in Zoho Analytics. The Brief: We would like the survey data to be generated as a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Suspect Survey - Webhook Trigger: Webhook when a suvey is submitted in Zoho Survey Purpose: Push the calculated score and results from Analytics into the corresponding Zoho CRM record. Inputs: String crmAPIRequest Outputs: - Date Created: 2025-09-19...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if you need counts or to use the data later on. Further Post-Joomla 2.5 aides Validating a login...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
without the quotes and tick the “Constant” radio box and click on the “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
for moving to the previous field. IME_ACTION_SEARCH // the action key performs a "search" operation, taking the user to the results of searching for the text they have typed (in whatever context is appropriate). IME_ACTION_SEND // the action key...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
ECHO Done. Deployment Method #?: As a setup.exe Package the visual studio project by adding a "setup wizard" project. This results in a setup.exe and msi file which can be installed on Windows Servers run by accounts which do not have access or which do...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Lipman M 726 5826 000 39 0000000002 0987654 MAJ Big Bird M 771 771 771 15 The one lookup task: Changing the lookup to "use results of an SQL query": Which would code with the joined tables as follows (note that in our case we needed the lookups on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
still works but when I type a Username ("@StudentADAccount"), 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Sandbox (Need IE and install their plugin - does not reflect my customer's PC image) IETester v0.4.3 (Returned different results from my IE7 tests) ie6olas_nt (from http://browsers.evolt.org - works but installing IE8 breaks it) ie6setup.exe (from...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
WHERE COLUMN_NAME = @p_Column ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME; -- Create temporary table to hold results CREATE TABLE #CountRecordsPerTablePerCol (myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
-- Drop dummy column from table declaration ALTER TABLE #myScrambledTable DROP COLUMN dummyIndex; -- Show me the results SELECT * FROM #myScrambledTable; END GO -- Usage: -- EXECUTE dbo.usp_MakeTableTemp 'mySchema.myTable'; Post-Notes Added a dummy...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM @myXml.nodes('/root/s') T(c); -- Create temporary table to hold results CREATE TABLE #ListDistinctValuesAndCounts (myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
AND ref.[RefSystem] = 'myPayrollSystem' Yes well obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone]...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
it thinks "riviere" is different to "rivière". We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
can it be circumvented?) Website Revamp? Signed Off Specification (describing clearly the agreed work to do and expected results) Realistic Cost & Time (obviously agreed with client) Additional Documentation (timesheets, agreements, technical...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
character list are returned as a match. For example, to exclude the characters 'a', 'b', and 'c' from your search results, use the following regular expression: [^abc] This expression matches characters 'd' and 'g' in the following strings: abcdef ghi...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm redirecting from myolddomain.com to mynewdomain.com: RewriteEngine On RewriteRule ^(.*)$...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *