Search - Joel Lipman .Com

41. Search a database for a value and count matching rows: / Databases /; ... -- Declare some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid ...; Created on 05 November 2012
42. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... -- Create temporary table to hold results CREATE TABLE #ListDistinctValuesAndCounts (myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through ...; Created on 26 October 2012
43. Slideshow div layer through a window: / MooTools Framework /; ... the basic mechanisms of this to demo here. Under Construction! window.addEvent('domready', function() { var v_width = $('v_placeholder').getCoordinates().width; var v_win_x = $('window_slide').getCoordinates().left; var ...; Created on 11 September 2012
44. Getting the mysql where in delimited string to work: / MySQL /; ... the loop DECLARE str_len INT; -- string length,self explanatory DECLARE out_str text DEFAULT ''; -- return string holder DECLARE temp_str text DEFAULT ''; -- temporary string holder DECLARE ...; Created on 02 January 2012
45. SSRS External Images don't displa: / SQL Server Reporting Services /; ... hosted on an external URL Check if image exists to display alternative placeholding image. Solution #1: Image does not appear within SSRS Configure the Unattended Execution Account: According ...; Created on 19 September 2011
46. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... It will act as a confirmation page (already holds the parameter passed to it from the previous page and that it will pass to the next page which executes the stored procedure) So this is the 3rd page ...; Created on 02 September 2011
47. Joes Bug Tracker (JBT): / Product Documentation /; ... (red, green, orange) --- Progress Status Types (received, acknowledged, on-hold, in progress, awaiting customer [uat], closed) --- Version Status Types (milestone, alpha, beta, test, dev, qa, RC, stable) --- ...; Created on 07 July 2011
48. Joes Quicklist Weblinks (JQW): / Product Documentation /; ... Thumbnail Yet? If the thumbnail hasn't been generated and you have opted to display thumbnails, then a placeholder indicating a missing image will display. You can create a "no_thumbnail_yet" image (i ...; Created on 03 July 2011
49. Creating a Profile Plugin for Joomla 1.6: / Joomla /; So there is other documentation out there. I'm basing most of this article on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that ...; Created on 27 April 2011
50. MySQL: Find records in one table that are not in another.: / MySQL /; ... like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers ...; Created on 25 February 2011
51. Header (Centered): Created on 17 April 2017
52. Header (Adspace): Created on 17 April 2017
53. Person: Created on 08 October 2015
54. Tabs: Created on 17 April 2015
55. Form Builder: Created on 30 November -0001