Assuming return is required, the following 180 results were found.
-
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
-
(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
-
Int,0, UShort,0, UIntP,nSz )) + 12 ), UInt,0 ) VarSetCapacity( Var,1024,0 ), VarSetCapacity( List,10240,0 ) IfEqual,nPtr,0, Return SubStr( DllCall( "ImageHlp\UnMapAndLoad", UInt,&$LI ), 0,0 ) Loop % NumGet( P+24 ) + 1 A_IsUnicode ? Var := DllCall(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
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
-
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
-
1. Open the file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the following string in the OnDisplay function: return ' '; 3. and replace with: // Replace YOUR_KEY with your public key return ' window.onload = function() {...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- 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
-
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: *
-
: 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: *
-
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: *
-
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: *
-
then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the second column (profile names) Gui, Font, s8, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; Subroutine: OpenProfile...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
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: *
-
and copy and paste this into a new browser window/tab Right-click on one of the file upload/attachments and copy the link Return to your code and customize the permalink so it looks the same but appends the file name See the following as an example of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and data. And yes, the part that took me about 8 hours and the key point above is to replace the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
try to update an integration field via deluge with another integration field or even the same integration field, it will return an error Unable to update the value to r_RecordDetails.Account. Line:(442) How? It is written in the documentation albeit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"Processed" is "Selected", check after each run of the function that the number has incremented. Once all records are done, return to the Module Layout and delete the "Processed" field. [Optional conditionally] Reactivate any workflows you deactivated...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF