Search - Joel Lipman .Com

21. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2: / Joomla /; ... (If you want my cached download - v1.1.8: click here) Extract the ZIP file to a folder (should be about 4 php files) Modify the file ayah_config.php to match the publisher and scoring key given to ...; Created on 27 April 2014
22. T-SQL: Parse an XML value: / Transact-SQL /; What? 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 ...; Created on 27 March 2014
23. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5: / Joomla /; ... STEP #2: Download AYAH files Download the latest files from https://portal.areyouahuman.com/installation/php (If you want my cached download - v1.1.8: click here) Extract the ZIP file to ...; Created on 24 March 2014
24. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... but just the count is extracted: -- DataSet2: SELECT COUNT(*) AS myCount FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames ...; Created on 07 March 2014
25. ReCaptcha disappears from Joomla 2.5 Registration: / Joomla /; What? This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin ...; Created on 24 November 2013
26. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE ...; Created on 14 May 2013
27. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID ...; Created on 14 May 2013
28. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special ...; Created on 23 April 2013
29. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...; Created on 04 April 2013
30. AwStats Data Parser (ADP): / Product Documentation /; ... finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data ...; Created on 03 April 2013
31. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... is the string of code you want to parse (all content). Function ExtractText extracts text given a unique string to mark the start of the extract (1a), a second string (1b) to refine the starting position ...; Created on 30 March 2013
32. SSIS Convert a string into a date: / SQL Server Integration Services /; ... The "component "Extract dates from string dates" (3614)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "DC_This_Date" (3833)" specifies failure on error. An ...; Created on 14 March 2013
33. Setup a copy of your Joomla website: / Joomla /; ... of web-based file managers cannot see hidden files! » Compress your LIVE files into a ZIP and extract to TEST to copy over any hidden files. You only have to do this on the first refresh. For further ...; Created on 19 December 2012
34. Search a database for a value and count matching rows: / Databases /; ... after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create a stored procedure and saving it on a database): IF OBJECT_ID('usp_CountRecordsPerTablePerColumn', ...; Created on 05 November 2012
35. Slideshow div layer through a window: / MooTools Framework /; ... float:left; } #slide_02{ position:relative; float:left; } The JS/Mootools Part Apologies for the mess as the solution I'm working on is far more complex and I need to keep extracting ...; Created on 11 September 2012
36. Connect to Joomla database in standalone script: / Joomla /; ... The example below demonstrates how to get these details and extract data from the database. How? Based on a script I found on StackOverflow. Not sure what version they were using so I modified ...; Created on 17 August 2012
37. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... 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 ...; Created on 03 August 2012
38. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012
39. SSRS Zero Padding: / SQL Server Reporting Services /; ... & Fields!ERROR_CODE.Value.ToString, 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 ...; Created on 10 November 2011
40. T-SQL Record Separator: / Transact-SQL /; ... perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM [pretendDatabase].[pretendSchema].[pretendTable] t0 WHERE [pretendField]='elephantastic' -- ...; Created on 11 October 2011