zarkosusnjar

require.config({
	urlArgs: 'bust=' +  (new Date()).getTime(),
	baseUrl : gmsURLDir + 'assets/js/common/paymentLetter',
	paths: {
		'jquery': gmsURLDir + 'assets/js/jquery-1.9.1',
		'jquery-ui': gmsURLDir + 'assets/js/jquery-plugins/jquery-ui/jquery-ui-1.10.2.custom',
		'tinymce': gmsURLDir + 'assets/js/jquery-plugins/tinymce/jquery.tinymce.min',
		'validate': gmsURLDir + 'assets/js/jquery-plugins/validate/jquery.validate.min',
		'validate-messages': gmsURLDir + 'assets/js/jquery-plugins/validate/localization/messages_' + gmslang,
		'underscore' : gmsURLDir + 'assets/js/underscore',

zarkosusnjar

create table t1 (num int, color varchar(10));

insert into t1 values (1,'red'), (1,'black'), (2,'red'), (2,'yellow'), (2,'green');

select num,
      substr( xmlserialize( xmlagg( xmltext( concat( ', ', color ) ) ) as varchar( 1024 ) ), 3 )
from t1
group by num;

--OR without space after comma

zarkosusnjar

# omogucite skidanje Sun JDK iz partner repozitorijuma
zarko@devbox2:~$ sudo nano /etc/apt/sources.list
# skinite komentar sa linije 
deb http://archive.canonical.com/ lucid partner

# sačuvajte fajl ( ctrl+x ) ( y )
zarko@devbox2:~$ sudo apt-get update
zarko@devbox2:~$ sudo apt-get install sun-java6-jdk
# proverite da li je JDK instaliran pravilno
zarko@devbox2:~$ java -version

zarkosusnjar

zarko@devbox$ java -cp clojure-1.2.0.jar clojure.main
Clojure 1.2.0
user=> (println "Hello world!")
Hello world!
nil
user=> (+ 23 56)
79
user=> (str "Foo" "Bar")
"FooBar"
user=>

zarkosusnjar

# instalira curl, git, ssl, mysql, imagemagick itd.
sudo apt-get update
sudo apt-get -y install curl git build-essential bison openssl libreadline6 libreadli ne6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-0 libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev imagemagick libcurl4-openssl-dev mysql-server libmysqlclient-dev libmysql-ruby mysql-admin

# instalira rvm
bash < <(curl -s https://rvm.beginrescueend.com/install/rvm); echo '[[ -s "$HOME/.rvm/scripts/rvm" ]] && source  "$HOME/.rvm/scripts/rvm"' >> ~/.bashrc;
source ~/.bashrc;

#skida i kompajlira ruby, gem command, rails i par osnovnih gem-ova
rvm install 1.9.2; rvm use 1.9.2 --default

zarkosusnjar

-data
/var/www
-showlocation
-showsplash
org.eclipse.platform
--launcher.defaultAction
openFile
-vm
/usr/lib/jvm/java-6-sun/jre/lib/amd64/server/libjvm.so
-vmargs

zarkosusnjar

-- Example found on http://goo.gl/nfiBq

SELECT 'drop table [' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']'

FROM 	INFORMATION_SCHEMA.TABLES

WHERE 	TABLE_NAME like 'cms%'

zarkosusnjar

<cfquery name="test" datasource="#this.dsn#" result="testing">
	<!--- DECLARE temp table --->
	DECLARE @resultSet TABLE( no INT )
	
	<!--- INSERT last current identity value into temp table --->
	INSERT INTO @resultSet (no) VALUES (IDENT_CURRENT('contacts'));
	
	INSERT INTO contacts (
				firstname
				,lastname

zarkosusnjar

<!--- SQL Server 2008 --->
<cfquery name="test" datasource="#this.dsn#" result="testResult">
	INSERT INTO contacts (
	   	    firstname
	       ,lastname
	  )
        VALUES
	(
		( <cfqueryparam cfsqltype="cf_sql_varchar" value="Marko">
		, <cfqueryparam cfsqltype="cf_sql_varchar" value="Simic">),

zarkosusnjar

<cfquery name="test" datasource="#this.dsn#" result="testResult">
	INSERT INTO contacts (
				firstname
				,lastname
	)
		SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="Marko">
				,<cfqueryparam cfsqltype="cf_sql_varchar" value="Simic">
	
		UNION ALL