Assuming number is required, the following 160 results were found.
-
noteworthy: The only anti-code injection facility in this example is the "mysqli_real_escape_string" function applied to a number. You will need to be more vigilent. Variables are all cleared and redefined. To pass a value to this script you have to use...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
search system for a technical database, and there is one specific article you visit a lot, it would be nicer just to type a number like "1234" and this returns that specific article. In the case of Joomla, we'll use the article ID. Pre-Notes: This...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
a tab. Returns the tab to its orginal position. Ctrl+1 through Ctrl+8 Switches to the tab at the specified position number on the tab strip. Ctrl+9 Switches to the last tab. Ctrl+Tab or Ctrl+PgDown Switches to the next tab. Ctrl+Shift+Tab or Ctrl+PgUp...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work was for a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data fields) Invidividual the incident(s) are assigned to (Labels - series fields) Months the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the following: =IIF(RowNumber(Nothing) Mod 2, "#ffffff", "#eeeeee") or =IIF(RowNumber(Nothing) Mod 2, "WhiteSmoke", "Garamond") This is telling the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
[varchar] and @StudentReference [int] respectively). Most of the remaining datasets use the resulting @StudentReference number in their "where" clause. A student always has a "Student Reference" but not necessarily a student AD account (enquired/applied...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the prefixing zeros -- "00000" because we don't expect strings to exceed 5 characters. The Oracle...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
criteria (the parameters). The concern was that this would make the report just as slow but the count only returns a number to be used internally and did not need rendering (only 1 row returned for a count). The dataset for this is the same as for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
** ** - myTable: table in which the column occurs ** ** (returned as "database.schema.tablename") ** ** - myCount: the number of records matching the value in this table. ** ** **...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
EventDate = CONVERT(VARCHAR(2),DATEADD(MONTH, 1,GETDATE()),101) + '/01/2009 01:30:00 PM', Note = 'Event 6' ) SELECT -- Number the records based on the date, if multiple records have -- the same date then they will be numbered the same. Used in --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= 1 ); -- Generate Select Query to extract data from given table and populate temporary table SET @SqlToExecute='SELECT ROW_NUMBER() OVER(ORDER BY ' + @ColName + ') AS dummyIndex, ' + STUFF( ( -- Code to concatenate column names and data types into one...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
columns: ** ** - myValue: the distinct values ** ** - myColumn: the column this value was found in. ** ** - myCount: the number of times this value was found in this column. ** ** ** ** Link to other SQL Server collations:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
int My issue was silly T-SQL concatenation which requires plus signs and thinks it's super clever when it tries to add a number and a string together; then remembers it's a Microsoft by-product and realises it can't. Solved by checking the datatypes for...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
- @i SET @CaseValue = SUBSTRING(@CaseExceptions, @i, @CaseLen) -- Is this word a UK postal outward code (2 letters and number(s)) IF ((LEN(@CaseValue)
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
from within a stored procedure. Our aim is to run a small query first to return the ID of the student, and then to use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE]...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here......
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB