Assuming matching is required, the following 23 results were found.
-
table in which the column occurs ** ** (returned as "database.schema.tablename") ** ** - myCount: the number of records matching the value in this table. ** ** ** ************************************************************************************ **...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
spin for 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
migrate your users, passwords and all. -- For USERS, we're going to do the following: -- 1) Migrate all users except any matching the new admin in J30 -- 2) Migrate user who's ID in J15 matches the new admin ID in J30 -- 3) Recover odduser's new ID in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
'Not Available', 'dbo'; ** ** ** ** Return Values : Table of two columns: ** ** - Value: Your search term and matching variations ** ** - Source: The table_name.column_name it found this value (Maximum) ** ** ** ** Additional: ** ** - For performance,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
a{3,5} This expression matches all of the following sequences: aaa aaaa aaaaa The expression does not match: aa aaaaaa Matching Character List You use the matching character list to search for an occurrence of any character in a list. For example, to...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Attributes set. /XA:[RASHCNETO] :: eXclude files with any of the given Attributes set. /XF file [file]... :: eXclude Files matching given names/paths/wildcards. /XD dirs [dirs]... :: eXclude Directories matching given names/paths. /XC :: eXclude Changed...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
LIKE @GroupName AND _SMDBA_.Incident.[Assigned To Full Name] '' Note that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
eq.EquipId=re.EquipId WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems because when there are no matching rows (so zero results), BIDS doesn't seem to know what to do with this. We could add a row with a SELECT UNION statement...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 copied...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to use your own head to match the datatypes for including a dummy row. Also note that because I don't have any options matching the ID above ("000000-0000-..."), this worked perfectly for me as my report didn't compare the 2 remaining dummy reports it...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
0 0 no-repeat; } If using an image, create a folder and add the image matching the path in the previous step: \templates\\images\background\ambientturquoise\ambientturquoise.jpg Test by logging into the Joomla Admin Panel > Extensions > Template Manager...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
-- Returns attribute "financialyear" of CURRENT_EMPLOYEE (eg. "2014") In a WHERE clause To select records matching a value for the XML field: SELECT * FROM [dbo].[XML_EVENTS] WHERE CAST(Event_XML AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
{ v_MatchedAccountID = ifnull(r_Coql.get("data").get(0).get("id"),0); } Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and data. And yes, the part that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= zoho.people.getRecords("P_ApplyLeave",0,200,l_SearchCriterias); Then we need the code to loop through all these matching records (and approved) and determine if it clashes with the requested dates: for each r_TimeOff in l_AllTimeOffs {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_Count = v_Count + 1; if(!isnull(r_Contact.get("Email"))) { v_Email = r_Contact.get("Email"); // // find all lead records matching this email l_Leads = zoho.crm.searchRecords("Leads","Email:equals:" + v_Email); for each r_Lead in l_Leads { // check...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
eval v_BooksOrgID = 12345678901; r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); // // check if owner and get matching salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID = r_SoDetails.get("Owner").get("id"); v_Filter =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // if not found, let's see if state is specified else if(!isnull(r_LeadDetails.get("State"))) { // find a module record matching the State l_SearchResults = zoho.crm.searchRecords("States","Name:equals:" + r_LeadDetails.get("State")); for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
say compare by email and the foreign key (3rd-party unique ID for that contact). Error(s) Encountered Could not find a matching parent record for this lookup field. - Parent Id: Ensure that CRM Record ID exists and that you are uploading the associated...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= v_GreetingName; } }); } catch(e) { document.getElementById('debug').innerHTML = "Sorry! We don't have any matching records."; } }); /* SAMPLE TO GET ONE RECORD - Working as of March 2024 ZOHO.CREATOR.init() .then(function(data) { var config = {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF