Assuming order is required, the following 133 results were found.
-
// // search payments m_SearchCriteria = Map(); m_SearchCriteria.put("customer_id",v_CustomerID); m_SearchCriteria.put("sort_order","A"); m_SearchCriteria.put("sort_by","payment_number"); // // fetch all payments against this customer in order of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= 0; v_CountProcessed = 0; v_FromIndex = (v_Page - 1) * v_PerPage; v_ToIndex = v_FromIndex + v_PerPage - 1; // // note that ordering here seemed to do nothing... it's in an order, not sure what order. Let's loop through every page anyway. l_Candidates =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified Time of Record If Modified Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
also try to delete the duplicate but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders, invoices, purchase orders), then it will delete the older one (referred to as keep ID). Another point is that this is using...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r3 ON r2."ID" = r3."Respondent ID" LEFT JOIN "Pages (Zoho Survey)" p ON r."Page ID" = p."ID" WHERE p."Title" 'GENERAL' ORDER BY "Response Date" DESC, "Attempt ID", "Page Number", "Question Number" You can take out the order by clause. I just have it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
instructions for applying the template and integrating it into Joomla that straightforward. It doesn't seem to matter what order you do the below in because I went through rocketheme's instructions once and it didn't work. I then carried out all the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The component I'm making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
admin user can log in). Create a .htaccess file in your /administrator folder with the following content: # ALLOW USER BY IP order deny,allow deny from all allow from 123.123.123.123 # change 123.123.123.123 to your static IP address # PREVENT VIEWING...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
my_joomla_db to the name of your joomla database. Note that your database user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url,...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
= @siteId AND tt.[Status] 3 -- Remove cancelled bookings AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' ORDER BY Date ASC, Room ASC, tt.[StartTime] ASC, tt.[FinishTime] ASC I even separated off the @GivenDate and @GivenCampus and re-assigned...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries started. IIF your result row count, if it's zero, just display...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: Dataset to populate the dropdown SELECT d1.Name, d1.ItemID FROM ( SELECT Name, ItemID FROM Catalog WHERE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') AND TABLE_SCHEMA='dbo' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
+ substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items , ROW_NUMBER() OVER (PARTITION BY EmployeeNo, DateOfSickness ORDER BY EmployeeNo, DateOfSickness) AS Rownum FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row with the number of times that particular data appeared...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
(Standard), Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My file upload field is called "Order Confirmation". v_OrderType =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
we lose contact with each other, the project manager has the option of going to another developer with the source files in order to continue the work. JoelLipman.Com will produce a signed-off production site as per the initial specification: Front-end...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
rewritten this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: en-GB
-
Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let us assume we have the following in a form/report called "Stock_Upload": RowID Name SKU Account Email 0001 Test...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
quote into one single quote. Why? I've written this article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other ways but this is one that works for me. How? So here's an overview and then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *