Assuming following is required, the following 283 results were found.
-
If you're not using the CRM integration and this is a public Survey with an email field on it, then you may need the following query instead: SELECT concat('REF-', left_pad(to_integer(substring(r2."ID", 8)), 6, '0')) AS "Attempt ID", s."Title" AS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html
are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument supplied for foreach() in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
[Mandatory Stage] We want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to articles where the search term is found in the title....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find the following 3 lines of code : const RECAPTCHA_API_SERVER = "http://api.recaptcha.net"; const RECAPTCHA_API_SECURE_SERVER =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
name that is difficult to guess but easy to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code to the .htaccess file in the root of your joomla website: # Admin Redirect...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I gave the transcript.txt file (all lowercase no punctuation) to ChatGPT as an attachment (~100 pages) and gave it the following prompt: rephrase the following so that it makes sense to a trainee: "" // wait for completion and if paragraph is ok Could...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
recent browsers. If you need more, you need to edit your PHP.ini file. 4. Test your PHP file can process the data Add the following code to the receiving PHP file: echo "Upload: " . $_FILES["uploaded_file"]["name"] . " "; echo "Type: "....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
to run the monitors (this is as per our development environment) The DOT Monitor should have a shortcut similar to the following:D:\Applications\siapp\vision\dev\uniface\bin\uniface.exe /asn=d:\applications\siapp\vision\dev\adm\svrside_batch.asn stutalk...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
parameter, for example: /imagine a beautiful face --portrait Effects So I can now build a prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following loops through directory for any file beginning with Reference FOR %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields:...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the following code is an excerpt from my program which checks an online server (for IT Events during this month) and if it can't download...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Welcome to our website. If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use, which together with our privacy policy govern Joel Lipman .Com's relationship with you in...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
use, sell, offer for sale, import and otherwise run, modify and propagate the contents of its contributor version. In the following three paragraphs, a “patent license” is any express agreement or commitment, however denominated, not to enforce a patent...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compatibility and actively developed. Unfortunately...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
} Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar = zoho.currentdate.toString("d").right(1).toLong(); v_EnglishOrdinal = if(v_ThisDayDateLastChar == 1...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the starting hour is found and stop adding when the closing hour is found. The picklist field is called "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution that will distance following roads and the such but.. the following is free albeit as-the-crow flies. This makes use of an undocumented function in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *