admin
Posts
-
Escape JSON Special Characters using PHP
Escape JSON Special Characters using PHP php > 5.2 $str_valid=json_encode($str); php versions older that 5.2... Read More » -
Make up table definition with [yr-mth] columns and column list
UDF Function -- ============================================= -- Author: Albert He -- Create date: 2018-05-18 -- Description: make... Read More » -
Uploading multiple files – jquery+php
Strategy: Initiate 3 file input box, put Add button on top of the form to... Read More » -
Handling long-press event
On desktop, to handle long-press event, we can utilize mousedown/mouseup event, with setTimeout to control... Read More » -
Passing parameters to event handler, setTimeout
Passing params to event handler using proxy. $("#id").on('mousedown', $.proxy( ()=>{ deleteFile( id );... Read More » -
SQL Server export data – 5 ways
Apart from using DTS and Export wizard, we can also use this query to export... Read More » -
usp_Email_AutomationScorecard
use BusinessSuite go if object_id('dbo.tbl_Email_Report') is not null drop table dbo.tbl_Email_Report if object_id('dbo.tbl_Email_Report_List') is not... Read More » -
Send report in the attachment from database
Project: automation report Base data: BluePrism automation data Architecture: create report as string with tab... Read More » -
JavaScript get hostname from URL
document.location.href = "http://aaa.bbb.ccc.com/first/second/abc.aspx?parm" window.location.host : sub.domain.com:8080 or sub.domain.com:80 window.location.hostname : sub.domain.com window.location.protocol : http: window.location.port : ... Read More » -
SQL Server Date and Time Conversions
Problem There are many instances when dates and times don’t show up at your doorstep... Read More »