Monthly Archives: May 2012

usb: programmable usb

May 31, 2012
By

Hre are several websites to look at programming usb key fobs: With LCD:!! bu $29 LCD cost http://www.pjrc.com/store/dev_display_128x64.html http://www.pjrc.com/teensy/td_libs_GLCD.html http://www.pjrc.com/tech/8051/board5/lcd_128x64.html     Expand IO: http://www.hexwax.com/Products/expandIO-USB/   SG Lock (in french): ($10) http://www.sg-lock.com/fr/index.php   Rock Key: ($29) http://www.rockey.com.my/prod-dongle-rockey6.php   http://www.irongeek.com/i.php?page=security/programmable-hid-usb-keystroke-dongle   Teensy USB: http://www.pjrc.com/teensy/  

Read more »

Php: JavaScript and CSS compress

May 31, 2012
By

Name: JavaScript and CSS minifier Author: mlitn Description: This package can optimize JavaScript and CSS files. It provides a class that can reduce the size of JavaScript files by stripping comments and white space characters. Another class can reduce the size of CSS files by also stripping comments and white space characters, as well...

Read more »

php: MSAccess copy contents into another table

May 30, 2012
By

// erase table $drop_sql = “DROP TABLE tBSI_counter”; $pt_result = odbc_exec($conn, $drop_sql); // copy table into another $esrd_sql = “select * into tBSI_count from qBSI “;

Read more »

SQL: Infection Blood cultures

May 30, 2012
By

select * from LURS.VLU_MICRO_RESULT where order_fac_id=’HAY’ and MRN = ‘xxxxxxxx’ and (PERFORMED_TEST_CD = ’6000501′ or PERFORMED_TEST_CD = ’6000497′ or PERFORMED_TEST_CD = ’6000495′ or PERFORMED_TEST_CD = ’6000493′) AND COLLECTION_DATE BETWEEN ’2010-03-01′ and ’2010-10-31′ ;

Read more »

Teradata SQL: compare lab values, shorten mrn

May 30, 2012
By

SELECT substr(MRN,5) as ID, ORDER_FAC_ID as FACILITY, VERIFY_TECH_ID as TECH, PERFORMED_TEST_CD as TEST, TEST_RESULT as VAL, COLLECTION_DATE as COLLECTED FROM LURS.VLU_LAB_RESULT where COLLECTION_DATE BETWEEN ’2010-12-31′ AND ’2011-1-1′ AND PERFORMED_TEST_CD = ’1001700′ AND TEST_RESULT BETWEEN ‘ 90′ AND ‘ 133′ AND TEST_RESULT NOT LIKE ‘%TND%’

Read more »

Php: Dados MySQL pagination

May 27, 2012
By

Name: Dados Author: Ivan Soares Ferrer Description: This class can show pagination links to list MySQL query results. It takes a given SQL query and executes it to determine the total number of results it returns. The class can generate HTML links to go from the current page to any other page of the...

Read more »

Php: reg exp search in tags

May 25, 2012
By

Name: jooRegexpr Author: Viet Vu Description: This class can find tags with parameters in text. It uses regular expressions to find a tag with a given name. By default the format of the tag is {tag parameter=value …}. The search regular expression can be customized to find tags with a different format. The class...

Read more »

Php: rss feed

May 24, 2012
By

Name: Feeder Author: Pavel Description: This class can generate feeds in RSS and Atom formats. There is a main class that can manage the information about the feed channel like the title, description, author and base URL. Another class can manage the information about each feed entry like the title, author, content and generation...

Read more »

Php: download file count

May 23, 2012
By

Name: Download 2 Author: Marko Schulz Description: This class serve files for download and count downloads using files. It can serve a given files for download automatically determining the content type based on the file name extension. The class also track the number of times each file is downloaded using text files to store...

Read more »

Php: report to excel or PDF

May 22, 2012
By

Name: PHP Report Author: verni Description: This class can generate reports in Excel, HTML and PDF formats from arrays of data. It takes arrays of data that define the contents and format of cells of a spreadsheet and it generates an spreadsheet file using the PHPExcel package in several formats like Excel, HTML and...

Read more »