Assuming method is required, the following 101 results were found.
-
Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can drag the columns by clicking and holding on the headers when...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
is at the top of the list print out each row with the number of times that particular 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...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
456789 567890 597890 I want the third column to say whether this is new or not. How? I found this in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value in B2 exists in range of A2:A100. -- Returns the index of column A in...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') Method #1 - chain: $query ->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR') ->where($db->quoteName('condition2')...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I like to use different passwords for every site but this came up as a client had lost their super user password. How? This method is reliant on having access to the database of your Joomla website. Method #1: Quickest way I know This is based on if you...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
is used in a search form where "SearchButton" is the name of the variable (picture) to change. Note that I am using the method of hiding the input button and putting an image over it. The code above is only really a solution to if you have one image...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
search // search weblinks as well Form attributes I have set these to the following: action = /index.php?option=com_search method = post role = search Issues Further searches do not include the same filters. This will be because the setting to display...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
ZohoCRM.users.ALL or to be safe ZohoCRM.modules.ALL ZohoCRM.settings.READ ZohoCRM.users.READ Problem: Code 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator record into Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
lists the "status" as connected as well as a snippet of Deluge for the usage Source(s): Zoho CRM Developer - getFields Method - Comparison
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= "Europe/London"; v_ZohoTime = v_ZohoEpoch.toLong().toTime("yyyy-MM-dd HH:mm:ss", v_IanaTZname); // The best method is per client: // Login to Xero > Accounting > Accounting Settings > Financial Settings > Time Zone // convert to IANA TimeZone and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
of Zoho Books to Zoho CRM and vice-versa. Annoyingly the attachment does not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also attached to the Sales Order in Books... but it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
The ZC_SUBFORM_250 error is because I am trying to assign the collection or list to the subform when I need to use "INSERT" method twice and not the equals sign: once to add the row to the collection, and the second time to add the collection to the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params I'm calling the Method Name "OnValidate" and I add the following parameters: p_RequestID specified as "ID (Leave)"... this is the ID of the Leave...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Webservice_rest->call_method('create_entry') #3 /home/thirdpartyapiorg/public_html/thirdpartyapi_controlpanel/user/addons/thirdpartyapi_webservice/Core/Hook/SessionsStart.php(106): Webservice_rest->__construct() #4...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
]; From the documentation Additional Note that any bidirectional relation field that exists will be prepopulated using the method above. Clear subform of all its rows: input..clear(); Changing the picklist/dropdown options in a subform row (applies...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick article to document a method of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
that the system will understand the date correctly? How? It may be that when obtaining a date string and applying the method .toString("dd/MM/yyyy") is dependent on the settings. But making a date into a SQL format or from largest denominator to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
of the Shipping Address... But let's say I don't know how to create a shipping address and retrieve its ID then here's the method I use: Create the sales order in ZohoBooks (either in Zoho Deluge or however you're doing it), then Retrieve the ID of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
(see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a public link. My use-case scenario here is that while I could upload the link from Creator to eBay's Picture...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method .workdaysList(): date1='2022-07-21'; date2='2022-07-29'; info date1.workdayslist(date2); // yields: Thu Jul 21 00:00:00 PDT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *