Assuming that is required, the following 493 results were found.
-
Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
FROM my_table) T1; -- Performance Improvement SELECT COUNT(1) FROM (SELECT DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Joomla instructions do not include the search engine. I need the Joomla built-in search engine to also ignore permissions so that the article can still be indexed in global search engines such as Google. How? It's been difficult to search for the right...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the top nav bar is cut off if he's using a normal tv and not a pc monitor. I'd like to have 1 screen adjustment tool that correctly adjusts both the lmce desktop and the main ubuntu desktop, so even when using the Ubuntu desktop on a TV, the top nav...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories >...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
-cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
By adding the following line to your LocalSettings.php file, you will be able to log everything that WikiMedia does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
basically highlighted articles found in one but not the other - we had over 2000 articles... I guess I'm a bit geekly like that) This doesn't show modified date and content size differences but I can run this SQL query to show me these.
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
sql server setup, re-ran the repair to no avail. A clue came from the MS site for an older version of the pipeline in that you access the SQL Server Configuration Manager. This may not be the fix for you but it was for me: Open Start > All Programs >...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all reports. File > Save selected item as... For SSRS...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution is far more complicated then this, but it isn't. This is one of those rare situations when the Microsoft error...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
use the link. Why? As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg. http://www.gravatar.com/my-picture), Go to your SharePoint site Click on the “People and Groups” link at the...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any file in the Solution...
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools -> Folder Options Click...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
1 Me 2 Myself 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)]...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *