Assuming note is required, the following 288 results were found.
-
favorite text-editor Rename any instance of "my_old_database.jos_" to the name of your old Joomla 1.5 database or a copy of (note the "jos_" prefix to all J15 tables, if you have changed this then reflect this in the SQL file). Rename any instance of...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to place on the calendar SELECT EventDate = CONVERT(VARCHAR(2),DATEADD(MONTH, -1,GETDATE()),101) + '/30/2009 02:00:00 PM', Note = 'Event 1' UNION SELECT EventDate = CONVERT(VARCHAR(2),GETDATE(),101) + '/23/2009 12:00:00 PM', Note = 'Event 2' UNION...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
and overriding certain CSS elements that the vanilla or out-of-the-box Zoho Creator ones provide. First, let's add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
t0 WHERE [pretendField]='elephantastic' -- end your original SQL query here (note no "order by" allowed -- refer to 6th line of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
(eg. "Director of It ") ValueToConvert = ValueToConvert + " "; // tranformation exceptions: words to be lowercased // note the prefixed spaces so as not to lowercase words at the beginning of a line. exceptionArray_this = new string[] { " And ", " At ",...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
0)) AS "Credit Margin excl Tax", SUM(if_null(ab2."ItemMarginInclTax", 0)) AS "Credit Margin incl Tax" FROM "My Credit Note Items" ab2 WHERE ab2."Status" IN ( 'Open' , 'Closed' ) GROUP BY ab2."SalesPersonID", ab2."MonthYear" ) t2 ON absp."Sales Person...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note: It is not advisable to run this on a production website! --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Form in Joomla 2.5 Name: E-Mail: Sample CheckBox: Sample SelectList: yes no Ajax Response Ready, Willing and Able Big Note: UPDATE 2012 It is important to refer to the correct mootools scripts in order for this to work. Unfortunately, clients who sign...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
specify the client's own Job Opening Ref m_Create.put("Vacancy Ref",r_Data.get("Job_Opening_ID")); // // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"my_connection"); //info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
type field into a color picker. Pre-amble: Create a Zoho Creator form Create a form, I'm calling mine "Color Picker" Add a note field, I've given it the field link name "Note_ColorPicker_Css" Add a radio field type, I've called it "Color Picker" Add a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
control webpages using JavaScript, along with the AHK COM "translations" (AutoHotkey_L in Black, AHK Basic in Green) - also, note Sean's post below. (Using COM requires Internet Explorer, but JavaScript can be used with most Web Browsers) The guidelines...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Users Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Check that ZohoDesk is sync'ing with your ZohoAnalytics: Login to ZohoAnalytics as an Admin with access to ZohoDesk Make a note of the workspace name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
AS PersonDays, CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource, s.StaffActivity AS Activity, s.AdditionalNotes AS Notes, CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *