[1] 프로시저 총 목록...

Select ROUTINE_NAME from INFORMATION_SCHEMA.ROUTINES

[2] 프로시저 소스 보기

 sp_helptext  프로시저명

[3] 프로시저 정보 보기

sp_help 프로시저명

HTML5 File Uploads with jQuery

http://tutorialzine.com/2011/09/html5-file-upload-jquery-php/

Demo    Download

What are HTML5 File Uploads?

Uploading files using HTML5 is actually a combination of three technologies – the new File Reader API, the also new Drag & Drop API, and the good ol’ AJAX (with the addition of binary data transfer). Here is a description of a HTML5 file upload process:

1. The user drops one or more files from their file system to the browser window by dragging. Browsers that support the Drag & Drop API will fire an event, which alongside other useful information, contains a list of files that were dropped;
2. Using the File Reader API, we read the files in the list as binary data, and store them in memory;
3. We use the new sendAsBinary method of the XMLHttpRequest object, and send the file data to the server.

Sounds complicated? Yes, it could use some optimization. Fortunately, there are jQuery plugins that can do this for us. One of them is Filedrop, which is a wrapper around this functionality, and provides features for limiting maximum file size and specifying callback functions, which is really handy for integrating it into your web applications.

Currently file uploads work only in Firefox and Chrome, but upcoming major versions of the other browsers also include support for it. A simple fallback solution for older browsers would be to display a regular file input dialog, but we won’t be doing this today, as we will be focusing our attention on using HTML5.

So lets get started!

부모가 아이를 더 크게 성장시키려면
모든 걸 갖추어주는 배려는 독이 될 수 있다.
어느 정도 결핍을 허용하고,
그 속에서 스스로 판단하고 걸어갈 수 있게끔 해야 한다.
인류사의 모든 문명은 결핍에서 성장하고 풍요에서 쇠퇴해갔다.
개인도 마찬가지다.
- 한형조 (한국학 중앙연구원 교수)

그야말로 헝그리 정신이 필요한 시대입니다.
그러나 실제로 헝그리 하지 않은 상황에서
헝그리 정신을 갖는다는 것은 매우 어려운 일입니다.
역으로 생각하면, 그렇기 때문에 오히려
사랑하는 자녀, 사랑하는 후배, 부하직원들에게
어떻게 하면 결핍을 선물할까? 헝그리 정신을 어떻게 심어줄까?
더욱 더 고민해야 하는 때라 할 수 있습니다.

Inserted Android reference links as the first attempt to improve API documentation. More will follow soon.

Also found out accidentally that updated Configuration class is not generated in the latest commit, so I added it as a separate commit.

You can merge this Pull Request by running

  git pull https://github.com/guersam/scaloid wip-improve-apidoc

Or view, comment on, or merge it at:

https://github.com/pocorall/scaloid/pull/69

Commit Summary

• Generate Configuration class as changed in afb19ef8
• Add link to Android reference for each generated class

File Changes

• Mproject/AndroidClassExtractor.scala (2)
• Mproject/StringTemplateSupport.scala (3)
• Mproject/st/base.scala.stg (39)
• Mscaloid-common/src/main/scala/org/scaloid/common/content.scala (16)
• Mscaloid-common/src/main/scala/org/scaloid/common/preferences.scala (26)
• Mscaloid-common/src/main/scala/org/scaloid/common/view.scala (44)
• Mscaloid-common/src/main/scala/org/scaloid/common/widget.scala (758)
• Ascaloid-common/src/main/scala/org/scaloid/util/Configuration.scala (54)
• Mscaloid-support-v4/src/main/scala/org/scaloid/support/v4/app.scala (40)

Patch Links:

• https://github.com/pocorall/scaloid/pull/69.patch
• https://github.com/pocorall/scaloid/pull/69.diff

친절이란 귀먹은 사람이 들을 수 있고 눈먼 사람이 볼 수 있는 언어. - 마크 트웨인 -

.

전화번호 입력 포멧

http://firstopinion.github.io/formatter.js/demos.html

Formatter.js: Conform user input to predefined patterns

formatter.js

   ___                    __  __              _   
  / _/__  ______ _  ___ _/ /_/ /____ ____    (_)__
 / _/ _ \/ __/  ' \/ _ `/ __/ __/ -_) __/   / (_-<
/_/ \___/_/ /_/_/_/\_,_/\__/\__/\__/_/ (_)_/ /___/
                                        |___/     

Format user input to match a specified pattern

Demos/Examples

view demo

Why?

Sometimes it is useful to format user input as they type. Existing libraries lacked proper functionality / flexibility. Formatter was built from the ground up with no dependencies. There is however a jquery wrapper version for quick use.

On Bower

bower install formatter

Usage

Vanilla Javascript

new Formatter(el, opts)

var formatted = new Formatter(document.getElementById('credit-input'), {
  'pattern': '{{999}}-{{999}}-{{999}}-{{9999}}',
  'persistent': true
});

Jquery

• uncompressed: jquery.formatter.js
• compressed: jquery.formatter.min.js

$(selector).formatter(opts)

$('#credit-input').formatter({
  'pattern': '{{999}}-{{999}}-{{999}}-{{9999}}',
  'persistent': true
});

Opts

• pattern (required): String representing the pattern of your formatted input. User input areas begin with {{ and end with }}. For example, a phone number may be represented: ({{999}}) {{999}}-{{999}}. You can specify numbers, letters, or numbers and letters.
  • 9: [0-9]
  • a: [A-Za-z]
  • *: [A-Za-z0-9]
• persistent: [False] Boolean representing if the formatted characters are always visible (persistent), or if they appear as you type.