Assuming well is required, the following 154 results were found.
-
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 PHP but since becoming...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
dependent on parameters submitted, we had to apply a similar IIF statement block to the Font color and the Action target as well within SSRS.
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other sites have this solution as well so who copied off who is not my concern as this is not the solution to our problem. This is the solution that I initially...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
whether they are the fastest or slowest in the set. Something like: The DataSet This should work on your reporting server as well. I'm using the database "ReportServer". select * from ( SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID]...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
source of your webpage that this form will be on). Does not use JQuery - Although most of the sites I work for use JQuery as well as MooTools, I needed this for a component that I was building and only wanted to use the files that Joomla versions 1.6 to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
The "clear" button is essential as some article_modal fields may not be required and are difficult to clear once set. How? Well don't quote me on this but I haven't needed to modify this script for any different component. Simply include this file in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html
distribution (with or without modification), making available to the public, and in some countries other activities as well. To “convey” a work means any kind of propagation that enables other parties to make or receive copies. Mere interaction with a...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Who doesn't want to change their desktop background wallpaper? Using Windows 7, who doesn't want it to be a slideshow as well? Create a folder in your “My Pictures” folder in your home drive (check that this is the one on the homedrive and preferably...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server instances but it wasn't practical to link this to mySQL databases. How? So this is how I did it, I found the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
expressions is shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not: Surround string...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant its own article but for those of us who merely use SQL Server...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
The scripts in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download» Run the SQL script against a test database, Modify the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
a Microsoft product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
click on "This computer" and tick the "Encrypt iPhone backup" (note the password as you'll need it for future restores as well as to untick the box). Click on the "Back Up Now" button. When that's done, Right-click on the new phone and select "Restore...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
log). /UNILOG+:file :: output status to LOG file as UNICODE (append to existing log). /TEE :: output to console window, as well as the log file. /NJH :: No Job Header. /NJS :: No Job Summary. /UNICODE :: output status as UNICODE. :: :: Job Options : ::...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
" and " ThisManyWorkingMinutesRemainder " second" ( ThisManyWorkingMinutesRemainder==1?"":"s") ; MESSAGES Message0:="All's well at " A_Hour ":" A_Min " on " A_DDDD ", " A_DD " " A_MMMM " " A_YYYY "`n`nAnd it's time for that gentle reminder..."...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep our XSLT with some slight modifications. First let's look at the XML output from...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF