Salaheddin AbuEin sabuein

For our reporting services, we need to convert a lot SQL tables to HTML. This is the SP that can convert any table to HTML based on a SP created by Ian Atkin ([email protected]) The original post can be found here

The modified version supports converting tables having NULL cells & better styling

create PROCEDURE [dbo].[SqlTableToHtml] (
@TABLENAME  NVARCHAR(500),
@OUTPUT   NVARCHAR(MAX) OUTPUT,
@TBL_STYLE NVARCHAR(1024) = '',
@TD_STYLE NVARCHAR(1024) = '',

File Magic Numbers

Magic numbers are the first bits of a file which uniquely identify the type of file. This makes programming easier because complicated file structures need not be searched in order to identify the file type.

For example, a jpeg file starts with ffd8 ffe0 0010 4a46 4946 0001 0101 0047 ......JFIF.....G ffd8 shows that it's a JPEG file, and ffe0 identify a JFIF type structure. There is an ascii encoding of "JFIF" which comes after a length code, but that is not necessary in order to identify the file. The first 4 bytes do that uniquely.

This gives an ongoing list of file-type magic numbers.

Image Files

About

This file was generated automatically based on this two sources:

/etc/nginx/mime.types
http://www.garykessler.net/library/file_sigs.html

File format

This is a JSON object by following structure:

[string ext] : {
 signs: [sign]

Lecture ✍️

JS Events

So far we have mostly been using HTML buttons to trigger JS functions, but this is only one event we can use to trigger logic from our JS files. In previous tasks we set up what is called an event listener to detect when the button was clicked. We passed a callback as a function that gets called when event is triggered. Being able to pass functions as parameters - the same way as we can with variables - is one of the major strengths of the JS language.

Event-based programming can be a little tricky to wrap your head around, especially as a beginner. Up until now you have probably been mainly programming in a sequential or imperative way - each line is executed one after another. When we introduce event listeners and callbacks we are determining the functionality we want to happen but we are not actually in control of when this functionality happens - functions aren't called until the button is actually clicked by the user.

Let's create a Coder Academy webapp that allows users t

A regularly updated collection of SVG resources

	<label for="addressCountry">Country</label>
	<select name="addressCountry">
	<option></option>
	<optgroup label="North America">
	<option value="US">United States</option>
	<option value="UM">United States Minor Outlying Islands</option>
	<option value="CA">Canada</option>
	<option value="MX">Mexico</option>
	<option value="AI">Anguilla</option>
	<option value="AG">Antigua and Barbuda</option>

	$("#tblId tr").each(function(i, obj) {
	if($(obj).attr('id') =='idBreakHere' ){
	return false; //this is equivalent of 'break' for jQuery loop
	}
	}


	$("#tblId tr").each(function(i, obj) {
	if($(obj).attr('id') =='idToFind' ){
	return; //this is equivalent of 'continue' for jQuery loop

	Default File Manager in Ubuntu is nautilus

	To open the current directory in File Manager:
	nautilus .

	To open current user documents folder:
	nautilus ~/Documents


	Alternative File Manager : thunar

	<?php
	/**
	* Plugin Name: WordPress Export to JSON
	* Plugin URI: https://jsnelders.com/
	* Description: Export all WordPress posts, pages, comments, tags, commments and users to a JSON file.
	* Author: Jason Snelders
	* Author URI: http://jsnelders.com
	* Version: 2020-01-30.1
	**/

	############ If you are using DOCKER all-in-one image, create Dockerfile like: ################
	############ FROM openproject/openproject:16 ################
	############ COPY ./enterprise_token.rb app/models/enterprise_token.rb ################

	############ If you are runing a manual installation: ################
	############ REPLACE app/models/enterprise_token.rb in the source code with this file! ################
	############ also be sure to RESTART OpenProject after replacing the file. ################

	############ If using some other set up (eg docker-compose), read the comments on ################
	############ https://gist.github.com/markasoftware/f5b2e55a2c2e3abb1f9eefcdf0bfff45 ################