Assuming single is required, the following 55 results were found.
-
to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
-- query() returns typed XML SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- value() returns single value, specify data type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
form and if 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...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
I'm listing what needs to be escaped in SQL for future use: Character Description \0 An ASCII NUL (0x00) character. \' A single quote (“'”) character. \" A double quote (“"”) character. \b A backspace character. \n A newline (linefeed) character. \r A...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later....
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
}); // use built-in JSON stringify function newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); // removes...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
to an underscore $v_Output = preg_replace("/[^a-z0-9\_]/", "_",$v_Output); // replace any consecutive underscores to a single one (eg. "my_____test" yields "my_test") $v_Output = preg_replace("#((\_){2})\\2+#", "$2", trim($v_Output, "_")); // returns a...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
demo, the link value uses all three primary keys of the CAP entity. They can be separated by double hashes/pound signs or a single tilda with the keys enclosed by double chevrons. Add the DataChange-out-tray Rule Element (DRE) records by clicking on the...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output 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...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
be manageable to add every new user's IP address to their service. The request has to come from a permitted server with a single IP address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
with the first parameter being the text to search for (can be a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Day_Name = Day_Map.get(My_Date.toString("E")); Method #3: Using a list, the inevitable single line: Day_Name = ",Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday".toList(",").get(My_Date.toDate().getDayOfWeek());
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *