Assuming form is required, the following 100 results were found.
-
Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
audit purposes]). The 3rd parameter is the Username of the person running the report. This second page is called "HouseKeepForm". We have a 3rd report which will actually execute the stored procedure called "HouseKeepExec". The Problem We get the above...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
t1.Room ASC, t1.Finish ASC) as 'RowNumber' FROM ( -- start your original SQL query and save results as table t1 SELECT -- perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
last part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring in a sort of reversed form. For argument's sake, I'm assigning this string to the variable "haystack". How? Perhaps we should determine the position of...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
BY MONTH(t2.Date); Notes: I use this in a PHP script so where year is specified (2010), I have a variable posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous guests count as guests until they login, which...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
that registers the misspelling of a popular website address, either to increase advertising revenue or as a form of parody/social criticism. initialism An initialism is a phrase or multi-word name that has been abbreviated to the first letter of each...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
domain to be redirected to the new domain. Why? I warned that a 301 site gets removed from the Google directory and true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
I tried and ended up with: If your XML is UTF-8 This is the basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); //...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
rest. To serve, spinkle each pancake with freshly squeezed lemon juice and caster sugar, fold in half, then in half again to form triangles, or else simply roll them up. Serve sprinkled with a little more sugar and lemon juice and extra sections of...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
Version Platform ChangeLog Options 1.5 (4) - Enhancement: Restored alignment parameter - Enhancement: Restored colors and new colors given - Enhancement: Compatible with Joomla v2.5.x - Fixed: Backwards compatible parameters updated - Date Uploaded:...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
that claims to be from «CompanyName» or another company and requests that you reply 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...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for selection. Why? This was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
and segmented Method 1. In a bowl mix together the oats, honey, self-raising flour, egg and dried cranberries. This should form a thick batter. 2. Melt the butter in a thick based non-stick frying pan. Spoon the mixture into small rounds. 3. Fry for 2-3...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the smallest bookable time by low-level tape monkeys and techies is 30 minutes...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB