엑셀2010 창 두개 띄우기

카테고리 없음 2011. 10. 19. 16:41
http://answers.microsoft.com/ko-kr/office/forum/office_2010-excel/%EC%97%91%EC%85%802010%EC%97%90%EC%84%9C/87d5d69b-d94d-e011-8dfc-68b599b31bf5


관련 파일은 여기로~~
http://snoopybox.co.kr/1511 
Posted by [czar]
,

MySQL의 쿼리 값을 계산하는 방법

카테고리 없음 2011. 9. 28. 11:48
사람투표
오바마 예
매케인 아니
오바마 예
오바마 아니
매케인 예
오바마 예
오바마 예
오바마 아니
매케인 아니

http://www.randomsnippets.com/2008/10/05/how-to-count-values-with-mysql-queries/

SELECT person, 
SUM(IF(vote = "yes", 1,0)) AS `yes_votes`, 
SUM(IF(vote = "no", 1,0)) AS `no_votes`, 
COUNT(vote) AS `total` 
FROM votes 
GROUP BY person 
ORDER BY yes_votes DESC 

다음은 쿼리의 결과 것입니다 :

사람YES_VOTESNO_VOTES합계
오바마 4 2 6
매케인 1 2 3
Posted by [czar]
,

svn 로그

카테고리 없음 2011. 9. 15. 11:31

간단히 최신 로그 5개만 보기
]# svn log --limit 5

상세한 최신 로그 5개만 보기
]# svn log --limit 5 --verbose



svn: '.' 은 작업 사본이 아닙니다

svn url을 지정
svn log --limit 5 svn://localhost/test_repo


Posted by [czar]
,

Installing Java (Sun JDK 1.6.0) on CentOS 5 . CentOS 5에서SUN JDK 설치

카테고리 없음 2011. 9. 5. 14:44
Installing Java (Sun JDK 1.6.0) on CentOS 5 . CentOS 5에서SUN JDK 설치

STEP I: SYS PREP
1. Open terminal

2. Set up working directories (in this example it's ~/rpmbuild)
$ mkdir -p ~/rpmbuild/{SOURCES,SRPMS,SPECS,RPMS,tmp,BUILD}

3. Create ~/.rpmmacros
$ echo "%_topdir /home/user_name/rpmbuild" >> .rpmmacros
$ echo "%_tmppath %{_topdir}/tmp" >> .rpmmacros

4. Log in as root and use YUM to install following packages
$ su root
Password:
# yum install -y rpm-build gcc gcc-c++ redhat-rpm-config
# yum -y install jpackage-utils
# su user_name
 $



STEP II: INSTALL JAVA

1. Download JDK 1.6 update 7 self-extracting RPM version (jdk-6u7-linux-i586.bin) from Sun to ~/rpmbuild/SOURCES/


2. Download and build java-1.6.0-sun-1.6.0.7-1jpp.nosrc.rpm package
$ cd ~/rpmbuild
 $ curl -L -O http://mirrors.dotsrc.org/jpackage/1.7/generic/SRPMS.non-free/java-1.6.0-sun-1.6.0.7-1jpp.nosrc.rpm
 $ rpmbuild --rebuild java-1.6.0-sun-1.6.0.7-1jpp.nosrc.rpm
don't get freaked out by the errors or that it could take a little while, it's ok. Verify that RPMS directory in rpmbuild contains i586 directory with rpms.

3. su to root and migrate rpms to local yum repository
# yum localinstall ~user_name/rpmbuild/RPMS/i586/java-1.6.0-sun-1.6.0.7-1jpp.i586.rpm
NOTE: if you get "NOT SIGNED" issue (and most likely you will), resolve by the following work-around
- install X11 library to resolve libXP.so.6 dependency
# yum install libXp-devel.i386
- then plain old rpm
# rpm -Uvh ~user_name/rpmbuild/RPMS/i586/java-1.6.0-sun-1.6.0.7-1jpp.i586.rpm

4. Login as root to configure alternatives system to use new JDK
[root@blah]# alternatives --config java

5. Verify install
$ java -version
it should display java version "1.6.0_07 ....."
Posted by [czar]
,

Installing Java (Sun JDK 1.6.0) on CentOS 5 . CentOS 5에서SUN JDK 설치

카테고리 없음 2011. 9. 5. 14:43
Installing Java (Sun JDK 1.6.0) on CentOS 5 . CentOS 5에서SUN JDK 설치

STEP I: SYS PREP
1. Open terminal

2. Set up working directories (in this example it's ~/rpmbuild)
$ mkdir -p ~/rpmbuild/{SOURCES,SRPMS,SPECS,RPMS,tmp,BUILD}

3. Create ~/.rpmmacros
$ echo "%_topdir /home/user_name/rpmbuild" >> .rpmmacros
$ echo "%_tmppath %{_topdir}/tmp" >> .rpmmacros

4. Log in as root and use YUM to install following packages
$ su root
Password:
# yum install -y rpm-build gcc gcc-c++ redhat-rpm-config
# yum -y install jpackage-utils
# su user_name
 $



STEP II: INSTALL JAVA

1. Download JDK 1.6 update 7 self-extracting RPM version (jdk-6u7-linux-i586.bin) from Sun to ~/rpmbuild/SOURCES/


2. Download and build java-1.6.0-sun-1.6.0.7-1jpp.nosrc.rpm package
$ cd ~/rpmbuild
 $ curl -L -O http://mirrors.dotsrc.org/jpackage/1.7/generic/SRPMS.non-free/java-1.6.0-sun-1.6.0.7-1jpp.nosrc.rpm
 $ rpmbuild --rebuild java-1.6.0-sun-1.6.0.7-1jpp.nosrc.rpm
don't get freaked out by the errors or that it could take a little while, it's ok. Verify that RPMS directory in rpmbuild contains i586 directory with rpms.

3. su to root and migrate rpms to local yum repository
# yum localinstall ~user_name/rpmbuild/RPMS/i586/java-1.6.0-sun-1.6.0.7-1jpp.i586.rpm
NOTE: if you get "NOT SIGNED" issue (and most likely you will), resolve by the following work-around
- install X11 library to resolve libXP.so.6 dependency
# yum install libXp-devel.i386
- then plain old rpm
# rpm -Uvh ~user_name/rpmbuild/RPMS/i586/java-1.6.0-sun-1.6.0.7-1jpp.i586.rpm

4. Login as root to configure alternatives system to use new JDK
[root@blah]# alternatives --config java

5. Verify install
$ java -version
it should display java version "1.6.0_07 ....."
Posted by [czar]
,

나이키 신발

카테고리 없음 2011. 9. 5. 00:18

Posted by [czar]
,

sitemesh layout 에 body class 및 id 적용 getProperty

카테고리 없음 2011. 8. 17. 16:04
<decorator:getProperty property="body.id" writeEntireProperty="true" /> <decorator:getProperty property="body.class" writeEntireProperty="true" />


<body <decorator:getProperty property="body.id" writeEntireProperty="true" /> <decorator:getProperty property="body.class" writeEntireProperty="true" />> 


sitemesh + velocity 인 경우

id="$!page.getProperty("body.id")" 
class="$!page.getProperty("body.class")"


<body id="$!page.getProperty("body.id")"> 
Posted by [czar]
,

centos git 설치

카테고리 없음 2011. 8. 5. 16:35
rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm
yum install git 


[root@localhost ~]# wget http://kernel.org/pub/software/scm/git/git-1.7.6.tar.bz2
[root@localhost ~]# tar xvfj git-1.7.6.tar.bz2

Posted by [czar]
,

node: symbol lookup error: node: undefined symbol: ares_library_init 에러

카테고리 없음 2011. 8. 5. 16:27
node: symbol lookup error: node: undefined symbol: ares_library_init


yum remove nodejs
git clone http://github.com/joyent/node.git
cd node
git checkout v0.4.10
./configure
make
make install
Posted by [czar]
,

centos yum nodejs 설치

카테고리 없음 2011. 8. 5. 16:24

[root@localhost yum.repos.d]# vi SannisDev.repo

[home_SannisDev]
name=SannisDev's Home Project (CentOS_CentOS-5)
type=rpm-md
baseurl=http://download.opensuse.org/repositories/home:/SannisDev/CentOS_CentOS-5/
gpgcheck=1
gpgkey=http://download.opensuse.org/repositories/home:/SannisDev/CentOS_CentOS-5/repodata/repomd.xml.key
enabled=1 


yum install nodejs 


which node


node -v 



http://rubis.tistory.com/312 
Posted by [czar]
,

티스토리툴바