/[simile]/sql/mt.html
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Log of /sql/mt.html

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (annotate)
Sticky Revision:

Revision 38 - (view) (annotate) - [select for diffs]
Modified Sat Oct 25 16:45:32 2008 UTC (15 years, 5 months ago) by dpavlin
File length: 1720 byte(s)
Diff to previous 37 , to selected 33
sort years by number to get cronological order

Revision 37 - (view) (annotate) - [select for diffs]
Modified Sat Oct 25 16:39:22 2008 UTC (15 years, 5 months ago) by dpavlin
File length: 1696 byte(s)
Diff to previous 34 , to selected 33
added interval from create to modify time which we fake to
be single day if it's longer than 30 days (for old data
which seem to have wrong last modify date)

Revision 34 - (view) (annotate) - [select for diffs]
Modified Sat Oct 25 12:47:24 2008 UTC (15 years, 5 months ago) by dpavlin
File length: 1671 byte(s)
Diff to previous 33
encode property valueType for Exhibit in column name

Original idea was to get it directly from DBI, but that
didn't turn out to work well, so we extend column name
in SQL query with valueType and name of type

Revision 33 - (view) (annotate) - [selected]
Added Sat Oct 25 12:02:49 2008 UTC (15 years, 5 months ago) by dpavlin
File length: 1643 byte(s)
convert SQL query using DBI to exhibit JSON

- example using Movable Type database

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

  ViewVC Help
Powered by ViewVC 1.1.26