Assuming needs is required, the following 67 results were found.
-
the following to the core joomla search module PHP template so that the first search is based on the above heuristics: This needs to be put alongside the other hidden variables in the module, core joomla file is at /modules/mod_search/tmpl/default.php...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
wants to upgrade my PHP v7.x to PHP v8.x. I also get complaints (from my server not from humans) that my Joomla version needs updating... I'm writing this in case I ever have to upgrade other people's Joomla CMS and if it helps anyone else out there....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that needs to constantly monitor your whereabouts in order to "remind you". The reminder here was to charge the phone but it was the...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
*.apps.googleusercontent.com $CLIENT_SECRET = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email', $GAPIS_AUTH . 'userinfo.profile'); // add...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
on your server (JSON downloadable from Google) $api['keys']['private']['file'] = '.json'; // Location to store access token (needs be writeable) $api['jwt']['token']['file'] = '/access_token.dat'; 2b. Specify the impersonator Now for testing purposes...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
WHERE p.page_namespace=0 AND t.old_text='' AND p.page_is_redirect=0 My custom query To list access levels (this needs to check categories with access levels table), I have a separate table containing the wiki categories associated with local wiki groups...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we didn't...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
within SSRS Configure the Unattended Execution Account: According to Microsoft and Stack Overflow, your reporting server needs to have the "unattended execution account" configured. Some sources are specific saying that the account will need to be able...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Using encryption This one activates SSL encryption for all data sent between the client and server. The server needs to have a certificate installed. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true; This option...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
[pretendField]='elephantastic' -- insert some empty rows to blank out later as separators (select from your existing table, needs to contain data to order by so that it's the last row of each day -- if grouping by day -- basically insert a row that when...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
84 3 7749 63 4 B110 92 -- so we have 1 director, 2 managers, and 3 tape-monkeys Now suppose we had a convoluted query which needs to join the two tables so that we get the "MapOut" value: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
2000-02-19 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for testing. the Items...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
all required values to escape have been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in SQL for future use: Character Description \0 An ASCII NUL (0x00) character. \' A single quote (“'”)...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into the morning and afternoon slots. All days and time...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my needs. This PHP function accepts as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
in API call to Xero... apparently it can accept up to 60 invoices in one call. How? Crazy simple solution, your JSON needs to have the key "Invoices" and the list of invoices to create: {"Invoices":[... list of invoices...]} If sending just the 1: {......
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
I would recommend you return it in SQL date format (yyyy-mm-dd) and then do "Sort Z to A". You may find that the field needs to be unlinked and relinked each time further dates get added which is why you should leave it in ascending order if you don't...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB