Search found 6 matches

by yerkes
Thu Mar 03, 2011 3:26 pm
Forum: Winter 2011
Topic: check-in anomalies
Replies: 0
Views: 7845

check-in anomalies

Here's a rough Processing sketch that shows some of the most interesting check-in anomalies.

-- karl
by yerkes
Tue Feb 22, 2011 2:36 pm
Forum: Winter 2011
Topic: SQL queries on the vislab2 db
Replies: 3
Views: 3675

Re: SQL queries on the vislab2 db

here's a query makes a sorted list of each deweyclass, counts the total number of checkout transactions for each deweyclass and makes a list of all the barcodes of the items that belong to each deweyclass. select deweyclass as deweyClass, count(*) as numberOfCheckouts, group_concat(distinct i.barcod...
by yerkes
Tue Feb 15, 2011 1:02 pm
Forum: Winter 2011
Topic: SQL queries on the vislab2 db
Replies: 3
Views: 3675

Re: SQL queries on the vislab2 db

select deweyclass,count(*) c from transactions t,items i where t.barcode = i.barcode and deweyclass like '70%' group by deweyclass order by c desc;

count the number of times each deweyclass that starts with '70' has been checked out.
by yerkes
Tue Feb 15, 2011 12:36 pm
Forum: Winter 2011
Topic: SQL queries on the vislab2 db
Replies: 3
Views: 3675

Re: SQL queries on the vislab2 db

select itemtype,count(*) c from items i group by itemtype order by c desc;

count the number of items for each itemtype and sort in descending order.
by yerkes
Tue Feb 15, 2011 11:54 am
Forum: Winter 2011
Topic: SQL queries on the vislab2 db
Replies: 3
Views: 3675

SQL queries on the vislab2 db

select t.barcode,count(*) from items i,transactions t where t.barcode = i.barcode group by t.barcode limit 100; this gets all the barcodes with a count of the number of times they've been checked out. select deweyclass,itemtype,ckoutDateTime,ckinDateTime from items i, transactions t where i.barcode ...
by yerkes
Tue Jan 18, 2011 10:24 am
Forum: Winter 2011
Topic: PROJET 1 FREQUENCY MAPPING: SUBMIT HERE
Replies: 11
Views: 9381

Re: PROJET 1 FREQUENCY MAPPING: SUBMIT HERE

doodle.png
Codepage-437.png
also, i'd like to use Code Page 437 graphics, maybe.
Codepage-437.png (2.45 KiB) Viewed 6460 times