Assuming exist is required, the following 41 results were found.
-
of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name: jos_content): id title introtext...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
looked just like remository and lacked the features I needed. There were also standard features I wanted that didn't exist in the other systems. I wanted minimal code and leave the comments/videos/pdf to be handled by existing Joomla! CMS features. I...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Variables" Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another Joe TABLE:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
in the dropdown menu Select "Data Sources" in the left menu Specify a "shared data source" and browse to it to ensure it exists. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the key. We'll call it Foo. Go to HKEY_USERS\Foo\Software\Microsoft\Windows\CurrentVersion\Policies If it does not already exist, create a key called Explorer Create a new 32-bit DWORD value inside the Explorer key/folder and name it NoDrives (or...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
type @[User::SourceExtractFile] OK to save it Add the ForEach Loop Container to your "Control Flow" (NB: This did not exist in my data flow ssis toolbox - if you do not see it when you are under the "Control Flow" design tab, then select Tools > Choose...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
are changed in the back-end of the site (Joomla admin panel). The functionality and component are simply an extension to the existing Joomla Search. There are no changes to the existing component. Download You can download this module I made from my...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
the last step of this migration. Rename admin ID in the UPGRADE database We want to make sure that the new user ID doesn't exist in our upgraded system because we may have a user with that ID in the old system who might inherit privileges they shouldn't...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
:= a_MyArray[2, 3] - a_MyArray[2, 1] ; Open Notepad on right-most (3rd) Screen RunWait, Notepad.exe v_LastID := WinExist("A") WinMove, ahk_id %v_LastID%,, %v_XCoord%, %v_YCoord%, %v_ThisWidth%, %v_ThisHeight% And switching desktop? Well considering you...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
a zoho.people.getRecordByID("P_ApplyLeave",v_RequestId) in the function because on application, the record doesn't properly exist in the system yet and the delay causes errors further down the line. Just add these parameters as per my above instructions...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this is my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to Creator but have it as a blank form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we actually want the user to be able to click and download/open the attachments on the CRM record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ v_CandidateZohoID + r_Data.get("id") + ")"; l_CheckExists = invokeurl [ url :v_SearchEndpoint type :GET connection:"my_connection" ]; v_CountExists = 0; if(!isnull(l_CheckExists.get("data"))) { for each r_Check in l_CheckExists.get("data") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:v_Subject message :v_Message Attachments :file:v_CSVFile ] } Error(s): {"errors":[{"message":"Field 'endCursor' doesn't exist on type...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Purpose: Queries eBay for information about an order and then creates item/contact/sales order/package slip/invoice (if not exist) Date Created: 2022-05-05 (Joel Lipman) - Initial release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - Only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM and at least 1 line item is mandatory l_CrmProductLineItems =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_UserSignature.put("signature",v_ThisSig); l_UserUpdates.add(m_UserSignature); //} } // // if updates exist then update the users module with these new signatures if(l_UserUpdates.size() > 0) { m_Params = Map(); m_Params.put("users",l_UserUpdates);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
404: Page Not Foundhttps://joellipman.com/static-items/404.html
that was on the old site is still to be found on our new website at www.joellipman.com. The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Joel Lipman .Com to choose a new direction.
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML Allows basic HTML ARRAY Forces value to be an array PATH Forces value...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF