Assuming what is required, the following 495 results were found.
-
Language Codeshttps://www.joellipman.com/articles/cms/joomla/language-codes.html
started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English speakers...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
What? This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3 steps...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
and although these changes would have an effect on the module (such as take away accents and convert to ASCII), they weren't what we were looking for. The quick solution was to make the script run a MySQL command at the start: SET NAMES 'utf8' Now I...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University Knowledge...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
The option was added in Connector/NET version 5.0.3 and Connector/NET version 1.0.9. Specifying port Use this one to specify what port to use for the connection. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Port=3306; The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Format(Fields!Date.Value,"d")=3,"rd", Format(Fields!Date.Value,"d")=23,"rd") Can anyone say what I did wrong with this? It returns "#Error".
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
&rc:FindString=foo Note: I have no idea what this is for. Render a snapshot http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rs:Snapshot=2004-03-30T15:45:02 Use a specific stylesheet (handy for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
"So this is all I could fix in the time I have, all your issues have been dealt with and I also did this..." "So this is what I've quickly put together for demo purposes."
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
What? This is an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html
for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
CMS features. I also needed a component which isolated the download functions external to Joomla! for performance purposes. What makes this one different to others, is that it it treats each file like a project. Combining all file versions,...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
What? This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit of the drilldown). What's the problem? Enter this as a query in Excel without the parameters and it will work. Set MySQL parameters (using @ - same...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What do I want? Page ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
they all seem to have this problem. I'm really keen not to ask all my users to have to change their passwords but that is what the commercial applications are doing. The script to transfer users This is a free solution to at least get your user accounts...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
#2 overwrites data in the last row of the day (the one marked with a separator) which happens to be data my customer wants. What if that last row of that day was actually blank and didn't have any of the data we want in the end? The aim here then is to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF