Snipplr

(JavaScript) Dynamic Table Generator - COBOLdinosaur

Thu, 04 Apr 2013 07:15:15 GMT

The use of dynamic data acquisition on modern web sites and in a lot of intranet applications, sometimes means we have to build structures dynamically as data comes in from a feed or AJAX operations. The problem is not with the data, but rather that it is unstructured, or not appropriately tagged. The solution is to dynamically build the necessary structures to make the data presentable in a web page

(SQL) Delete all tables from SQL - fixpq

Sun, 17 Feb 2013 23:58:38 GMT

It removes relations before deleting tables.

(Objective C) dealloc - dbck

Fri, 26 Aug 2011 20:48:27 GMT

(PHP) PHP getTotal - brownrl

Mon, 27 Jun 2011 20:04:11 GMT

Simple function to return the total records in a DB. This function probably has to be modified for every project you do to adjust for your db layer and server. I have it here simply because I use ado-db lite and my other functions almost all the time.

(SQL) ALTER TABLE - vedgiee

Tue, 16 Nov 2010 00:52:54 GMT

Alter Table

(VB.NET) Read user tables from access - dirkschoeters

Wed, 04 Aug 2010 16:11:54 GMT

This snippet reads all user tables from a Access Database

(Java) Changing Header Class (CSS) in JSF Datatables - Codedrop™ Weblog - adriamooney

Thu, 22 Jul 2010 06:53:52 GMT

Something I have always found annoying about JSF datatables is the limitation to only apply one header class style to the entire table. This is un-functional for datatables that would display monetary amount or other data that is typically right aligned whereas descriptive columns are left aligned. The table doesn’t look very nice if the heading don’t match the columns.

(Objective C) Dynamic Cell Height - peetj

Wed, 23 Jun 2010 14:15:20 GMT

How to work out the cell height of a piece of text in order to set the row height of a table dynamically.

(SQL) Find Tables in Database (SQL Query) - emregulcan

Tue, 20 Apr 2010 03:56:52 GMT

(MySQL) Drop all tables in a MySQL database - wnasich

Wed, 24 Feb 2010 19:05:36 GMT

(PHP) Colorear filas de una tabla par/impar con PHP - jrobinsonc

Mon, 15 Feb 2010 08:02:24 GMT

(JavaScript) Zebra tables with Prototype - shapeshifta

Wed, 20 Jan 2010 10:13:17 GMT

(SAS) Finding the number of observations in the Dataset - sarathannapareddy

Tue, 11 Aug 2009 16:22:13 GMT

There are a number of ways of finding out the number of observations in a SAS data set and, while they are documented in a number of different places, I have decided to collect them together in one place. At the very least, it means that I can find them again. Read more at: http://studysas.blogspot.com/2008/08/finding-number-of-observations-in-sas.html

(PHP) Output zebra stripe rows in PHP - dizzley

Thu, 06 Aug 2009 11:54:16 GMT

This is a simple way to stripe alternate rows of output or to do anything different as I process each alternate row. Typically, I set the element's class to "myEvenRow" or "myOddRow" then output the data just after the IF statement. I found this full example at nullislove.com. The page also has a Ruby example. Full props to them.

(SAS) Dictionary Tables and SASHELP Views (SAS metadata) - sarathannapareddy

Thu, 30 Jul 2009 13:06:03 GMT

Most of the SAS programmers think that the Metadata concepts (Dictionary tables and SASHELP views) are advanced SAS topics, in fact it is not. I tried here to explain the concept precise and clear…… Here, I will cover the following topics…… Introduction to SAS metadata How to see what’s in the tables How to use the tables, using several real-world examples Advantages What are Dictionary Tables4?

(SAS) Subscript or Superscript in the footers/titles of RTF output - sarathannapareddy

Thu, 23 Jul 2009 09:32:13 GMT

Wondering how to create a subscripts and superscipt in title or footnotes of the rtf output... here is a way to do it.... Execute the following program to get an Idea about how to keep SUBSCRIPTS and SUPERSCRIPTS in footnotes and titles of rtf output.. ************************************************************; data test; length secnam $15; input sortord secnam $ pvalue; cards; 1 demog 0.8812 2 ae 0.7112 3 disposition 0.8112 4 medicalhistory 0.9112 ; run; ods listing close; ods rtf file="Test output.rtf" style=rtfout; ods escapechar='\'; proc report data = test missing split="$" spacing=0 headline nowd; column sortord secnam pvalue; define sortord / order noprint; define secnam / order flow "Demographics$Variable\{super a}"; define pvalue / display flow "ANOVA$P-Value\{sub p}"; run; ods rtf close; ods trace off; ods listing; *************************************************************; Variable\{super a}"; *Adds a superscript a to Demographics variable; ANOVA$P-Value\{sub p}";*Adds a subscript p to ANOVA P-Value variable; Make sure to use the same kind of brackets { }I have used in the sample code to get the superscripts and subscripts to get printed in the rtf output. ESCAPECHAR need not be '\' as it is mentioned in the sample code... It could be '*' or '^' or '#' anything we can think of...

(SAS) Renaming All Variables in a SAS Data Set Using the SASHELP VIEWS - sarathannapareddy

Thu, 23 Jul 2009 09:29:51 GMT

*Create a temporary dataset... DSN; data dsn; a=1; b=2; c=3; d=4; e=5; f=6; run; %macro test(lib,dsn); */1)*/ data _null_; set sashelp.vtable(where=(libname="&LIB" and memname="&DSN")); call symput('nvars',nvar); run; */2)*/ data dsn; set sashelp.vcolumn(where=(libname="&LIB" and memname="&DSN")); call symput(cats("var",_n_),name); run; */3)*/ proc datasets library=&LIB; modify &DSN; rename %do i = 1 %to &nvars; &&var&i=Rename_&&var&i. %end; ; quit; run; %mend; %test(WORK,DSN); After submitting the above program... the output looks like this.... Output: Rename_a Rename_b Rename_c Rename_d Rename_e Rename_f 1 2 3 4 5 6

(PHP) Dynamic Navigation From Database Table Names - jiggyhat

Sat, 16 May 2009 15:27:32 GMT

This will create a Navigation from a MySQL database table names. It removes the table name "includes" by default so you can see how to remove any certain tables you wish to not use as a site section. Just plug in your MySQL database details and connection info into data.php and you should be great to go.

(PHP) Dump a database to HTML tables - brent-man

Mon, 13 Oct 2008 09:47:49 GMT

(PHP) Easy Excel export from PHP - stavelin

Wed, 08 Oct 2008 11:31:37 GMT

This is saved from Gerhard Slettens weblog www.gersh.no. I just want yo keep it on snipplr so it easily can be fetched through textmate.