Assuming value is required, the following 190 results were found.
-
This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
a list of stdClass objects (see later for more options on retrieving data). $rows = $db->loadObjectList(); // Retrieve each value in the ObjectList foreach( $rows as $row ) { $this_user_id = $row->user_id; $this_user_name = $row->username;...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value, DateFormat.GeneralDate)...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
You may use these links for a more in-depth description of each item. HTML DOM, JavaScript, COM, Methods, document, value, element, form, name, ID, Input, Tag, selectedIndex, checked, innerText, innerHTML Methods - The following Methods will be used...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How?...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you need permission to create this function. Don't forget to GRANT permission to execute this function...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
typeof(string))) { // declare two arrays string[] exceptionArray_this; string[] exceptionArray_that; // get the value we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words //...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time value =( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) - CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ) // yields //...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO The Function -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataScramble', 'FN') IS NOT NULL DROP...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
article to help anyone encountering this gotcha: I have an integration field, if someone changes it, I want to save the value to the record immediately. Why? If you try to update an integration field via deluge with another integration field or even the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
extension Extends an existing simpleType or complexType element field Specifies an XPath expression that specifies the value used to define an identity constraint group Defines a group of elements to be used in complex type definitions import Adds...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ( StringValue VARCHAR(10) ) AS /********************************************************************************* ** Description : This...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing with leading zeros (for sorting purposes - eg. so 10 is not before...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Named pipes Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword; It is the port value of -1 that tells the driver to use named pipes network protocol. This is available on Windows only. The value is ignored if Unix socket is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName)...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB