saquery.com
a web developer' s kung fu…

To get a distinct dataset in MySql and embed it into Javascript in JSON format with PHP we need 3 Steps. SQL Source Code 1st. A SQL query to get a unique domain-name list.

Categories: Snippets | Add a Comment

The following sample shows how to limit a GROUP_CONCAT string in MySql to a specific length. This methode is near to the better List Aggregate Function in Sybase SqlAnywhere. 

Just improved my scripts to compress Cascading Stylesheet and Javascript code with yuicompressor. I wrote 3 small MS Dos batches to compress all files in a specified folder. By executing _make.bat the script will compress all *.js and *.css files from a folder named "/src_debug/" to "src". Last but not least the script will store [...]
Categories: more skills | Add a Comment
TIFFANY B. BROWN published on alistapart.com a realy good post about how to debug Javascript on mobile devices. The following links are a must-read for both aspiring web developer and also for advanced programmers. Modern Debugging Tips and Tricks - Advanced Debugging With JavaScript by H. R.M. STEEN , C. MILLS
Categories: Snippets | Add a Comment
Because I've nothing found to get the folder of the current active wordpress theme on web server' s filesystem I wrote my own from scratch called get_wp_theme_folder(); PHP Source code: function get_wp_theme_folder(){ $tmp = get_bloginfo("template_url"); $tmp = explode("wp-content/themes/",$tmp); $result = $tmp[1]; // Windows returns slashes in path strings. return str_replace("\\", "/", get_theme_root()."/".$result) ; }
After using Node.js for simple network service written in JavaScript I must say. Node.js realy rocks! The advantages to write server-side code in Javascript are obvious. As you can see in the following video, there are a lot of advantages over other server systems. The major differences are that Node.js is a server-side JavaScript environment. Node.js uses an asynchronous event-driven model. This allows to get an excellent performance based on the architectures of many Internet applications. Source: http://nodejs.org/ - https://github.com/joyent/node/wiki
This is a nice way to get the Domainname form a Url String in Python. import urlparse return urlparse.urlparse(self.request.url)
See how smart we can handle Web Requests in SQL Anywhere with a few lines of SQL Code. [inline] Specify HTTP Web service protocol and Port in SQL Anywhere The Database Start Parameter -xs specifies server-side Web service communication protocols. With the internal Webserver we can handle web requests within a SQL Anywhere Server. Simply [...]
Categories: more skills, Sql | Add a Comment
SAQ_DESCRIBE_FOREIGNKEYIn the development environment of a Sybase SQL Anywhere Database, it is simple to analyze and describe the rules of foreign keys. All necessary informations are stored in the system tables of the database. The information can be combined into a useful view.
jDrums A few months ago, I studied the possibilities to play audio files such as wave or mp3 in a Web browser. I quickly came to the conclusion that it is a difficult project. As a test scenario I had imagined a very simple drum machine.