Assuming default is required, the following 123 results were found.
-
should work: Apparently not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" either. I'm...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the pen. BTW I don't use the "remove device safely" rubbish as my old pen never did and it was fine for over a year. The default setup in windows XP is that it doesn't need it. Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof!... I'm...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Under the visual effects tab you should see that the option “ Let windows choose what’s best for my computer “ is by default checked. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
System File Checker Utility (Scan On Every Boot) sfc /scanboot System File Checker Utility (Return Scan Setting To Default) sfc /revert System File Checker Utility (Purge File Cache) sfc /purgecache System File Checker Utility (Sets Cache Size to size...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = DATALENGTH(@OrigVal); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal = ''; --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
[dbo].[myUserTable]; GO Types for sys.objects (less used by me) AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY constraint FN = SQL scalar function FS = Assembly (CLR) scalar-function FT =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default values SET @TableName = SUBSTRING(@SchemaTableName, CHARINDEX('.', @SchemaTableName)+1, LEN(@SchemaTableName)); SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = LEN(CAST(@OrigVal AS VARCHAR(max))); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I have uninstalled and reinstalled once just to make sure everything was OK. Basically after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted my...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port should be 3306 by default User is the mysql username Database is your selection and should auto-populate if the connection is successful TEST > OK...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
MediaWiki LocalSettings.php file, we can fix this. For demo purposes, I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the LocalSettings.php file in the web root folder...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
in shell is 'chown -R apache:apache '. 3. Check that your PHP ini specifies a reasonable maximum file size limit. By default this is 2Mb. In my example, I added the hidden input type MAX_FILE_SIZE which is ignored by more recent browsers. If you need...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Chinese, Hebrew, Russian, and Slovak. Fingers crossed this should work for all characters that Joomla! can handle by default anyway. Cause: Q. Why does this work for Joomla! articles and not for this module? A. Think this is because that module is...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
a PHP one and has to do with versions of PHP and MySQL. As quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
disk, flash drive, etc) Make sure that the \components\com_kunena\template folder is on your local disk Make a copy of the default folder inside Rename this to the name of your new template (avoid any spaces) Download the new template for the Kunena...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html
… omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and directory permissions 5. Remove unneeded files 6....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to the Joomla 1.5.x website Browse the table "jos_components" (or "#__components" where "#_" is the site table prefix. default is "jos"). Open the row where name="User Manager" Set the value under params for AllowUserRegistration allowUserRegistration=0...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
necessary because not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search engine to also ignore permissions...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *