Assuming return is required, the following 182 results were found.
-
Why? The previous article meant that the Google map was your main activity and any other activity would be a sub-activity; returning to the map activity would restart the app as a menu item, it would need to launch a new intent... I wanted to change my...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: SSIS...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
it populates only the first dataset with results; the remaining datasets that need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents"...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
unstable...) Browser Sandbox (Need IE and install their plugin - does not reflect my customer's PC image) IETester v0.4.3 (Returned different results from my IE7 tests) ie6olas_nt (from http://browsers.evolt.org - works but installing IE8 breaks it)...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
you want to search. ** ** ** ** Example: ** ** EXEC [usp_GenerateSearchbySoundexQuery] 'Not Available', 'dbo'; ** ** ** ** Return Values : Table of two columns: ** ** - Value: Your search term and matching variations ** ** - Source: The...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
** Author: Joel Lipman ** ** Created On: 29 October 2012 ** ** Revision: v1.0 ** ** Description: Stored Procedure to return counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Or -- Using .value() SELECT CAST(Event_XML AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
with exceptions to the rule, words that you want in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN -- declare some variables DECLARE @Reset BIT; DECLARE @Ret VARCHAR(8000); DECLARE @i INT; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
(using @ - same as T-SQL) and Microsoft Excel 2007 gets confused. Putting it all together Create a SQL query that will return: staffname, activity date, duration, week/year, person days, resource names, and the activity (+ any others you may want to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
: true, version : 'v2.5' }); }; (function(d, s, id){ var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) {return;} js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_US/sdk.js"; fjs.parentNode.insertBefore(js,...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
function get_data($url) { $ch = curl_init(); $timeout = 5; curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); $data = curl_exec($ch); curl_close($ch); return $data; }...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Format Editor dialog box appears. From the Common tab, specify an alignment in the Horizontal Alignment box. Click OK to return to the report. All the objects in the same column now have the same alignment. Export the report to Excel and there will be...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How? #NoEnv SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance Force ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Loop, %OutputVar% { FirstChar:=Substr(Result, 1, 1) IfEqual, FirstChar, `, { Result:=Substr(Result, 2) } else { break } } Return Result } Use as per usual: ValueWithCommas:=FormatAddCommas(NumberWithoutCommas) One taken from the AutoHotkey forums:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and will update this...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be expressed as: IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB