Assuming which is required, the following 337 results were found.
-
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, then...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used in SSRS so I'm...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 range of Aero features. Select the custom option and then select all the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
** ** ** ** Parameters : ** ** - Value: the value you want to match on (eg. Customer_ID) ** ** - Column: the column name which will contain this value. ** ** ** ** Return Values : Table of three columns: ** ** - myValue: value specified in parameter 1...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
1 for another employee. 002 00204 003 00305 Almost There! So we're using the ROW_NUMBER() functionality with an ORDER BY which seems to work somewhat. But using the code above still produces an error which can only be seen when using more records and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single value, which is all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student ID...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function which could determine the datatype automatically but as you may know, Oracle has a funny way of working with dates which made this...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
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 Base. The skin itself is the index page loaded for any page in the Wiki...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't care about testing, about changing a production...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1 This method replicates the table in a listview format: ; tell the script which content to parse Haystack...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
Why? I've noticed a lot of solutions now use JQuery or Mootools but most of these will not work in Internet Explorer 7 which is unfortunately still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
to do this:...... The form above will post to itself but more importantly is the enctype="multipart/form-data" without which your file upload processing won't work. The name of the file is important but you can call it what you want, in my case I've...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
"$2", trim($v_Output, "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias: DROP TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
blank values using single tags so we had to find a place to introduce it. On strings this has little worth, but on dates which could be NULL, this was necessary (unless we interpreted dates as strings which we don't want to do): -- SITS Output: Option 1...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a boolean. Returns false if a cell...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
or follow a link to provide personal information. These are fake and are known as ‘spoof’ or ‘phishing’ emails. Any emails which combine urgency with a need for personal details should be treated with caution, no matter whom they appear to be from....
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
Attack (=try every combination starting with words that exist). (source: Lockdown: Choosing a good password) And some more which have become more popular in recent years: There are loads of nightmare stories by security companies but one of my...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *