Posts

Showing posts from 2014

Initializing xslt variable with static content

I had to use a variable in an xslt template. The value for that variable would be returned by a stored procedure at a SQL Server DB. So, I decided to populate the variable with static content:

    <xsl:variable name="hideColumns" select ="'ISBN,author_id,vendor_id'" />

Populated with the static content, the variable proved to be a good replacement for the real-life data. So, as soon as the stored procedure was deployed, my xslt template was readily updated with the appropriate select statement in the hideColumns variable declaration.

T-SQL: COALESCE returns int for integer operations

DECLARE @can_import BIT

PRINT CAST (SQL_VARIANT_PROPERTY(COALESCE(@can_import, 0), 'BaseType') AS VARCHAR(20))

Result:
int

jQuery | remove inline style

Image
Summary: The jQuery.UI dialog widget can be called on a dynamically created <div />. In this case, the element will have its height set to 30px. A possible solution could be setting height to the empty string using the css() method. Normally the jQuery.UI dialog is called on an existing element. But it can also be bound to a dynamically created element:
var confirmText = Would you like to edit this task as the administrator user?'; // dynamically create <div /> to call the dialog on $('<div />').appendTo(document.forms[0]) .attr('id', 'div1') .attr('title', 'Dialog Title') .text(confirmText); // initialize the dialog $('#div1').dialog(); The resulting dialog assigns div1 to the message pane. But it also adds inline styling that squeezes div1 to the height of 30px, like this:
To fix this issue just remove the height style from div1:
$('#div1').dialog().css('height', ''); This seems to be …