Assuming same is required, the following 183 results were found.
-
Not Yet Available Which isn't at all what we set out to achieve other than it 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...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Light Squares Mosaic Turquoise Color Ambient Turquoise Add a \templates\\css\background\ambientturquoise.css file. Note the same filename as in the option value of the previous step. body#page { background: #f4f5f5...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
acyear WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using % (avoids MySQL Error 1065: Works within PHP scripts) SELECT calendar.WeekNumber AS AcademicWeek, CONCAT(...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
= CAST(@DateVal AS varchar(10)) + ' ' + CAST(@TimeVal AS varchar(16)); ELSE SET @NewVal = ''; -- REDUCE THIS STRING TO THE SAME LENGTH AS SUBMITTED VALUE // not necessary for update -- SET @NewVal = SUBSTRING(LTRIM(RTRIM(CAST(@NewVal AS VARCHAR(30)))),...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of being able to just click on "Yes". How? The gist is that we're going...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
instance of the browser to your Joomla one. Check that your template isn’t the problem: If you have a test site that has the same error, change the site template to a default one and see if that works. Check your cookie policy: Open a browser which...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
line to the XML installation file: script.php Now create a script.php file in the root folder of your component (ie. same as the XML installation file) Add the install script instructions: // No direct access to this file defined('_JEXEC') or die; //...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
my Project Analysis Manager - dubbed PAM - can tell me how long it took to setup a website previously, and will plan the same again). My 15 years of web-development experience allow me to reduce the risk of nasty surprises and also allows me not have to...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
-- 2013-12-07 Saturday -- 2013-12-08 Sunday Brilliant! We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
(not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the problem authentication? Restricted access to a...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
is a quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
a number to be used internally and did not need rendering (only 1 row returned for a count). The dataset for this is the same as for DataSet1 but just the count is extracted: -- DataSet2: SELECT COUNT(*) AS myCount FROM PersonsTable WHERE (Reference =...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
(JoomlaTune.com) What? Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an article on...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The concept of creating the NoDrives registry entry is what you need to remember. In the example below, we are applying the same principle to a specific user account (the Guest account): Open the registry editor with administrative privileges Select...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
allows for a large space at the bottom of the page indicating the page number. The footer of the dataset (in black) is the same image used in the top center of the dataset (the black background). And here's the rendered/published view on the Reporting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
code with the joined tables as follows (note that in our case we needed the lookups on the source database which was not the same as our staging one which this package gets as its source): -- here we are pretending the lookup tables are prefixed with...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
import Adds multiple schemas with different target namespace to a document include Adds multiple schemas with the same target namespace to a document key Specifies an attribute or element value as a key (unique, non-nullable, and always present) within...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI Phantom and the Hubsan X4 H107C This model is the DJI Phantom FC40 so the first Phantom (v1.2?) with DJI's...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF