Category: MYSQL DATABASE

exogen 4000 battery replacement

By , August 14, 2016 9:39 PM

How to replace an Exogen 4000+ battery

 

I’ve recently been told of an EXPRESS model that uses the same innards but with firmware that stops dead at 150 treatments.

.

Replacement Biomedical

Panasonic 1632 BR  – 3v 120Mah 2pin

 

Battery for Exogen Inc 4000+ Bone Healing System. This Lithium battery has a nominal voltage of 18.0V and a rated capacity of 2.1Ah.

Replaces OEM Part 81025147Exogen Inc 4000+ Bone Healing System Battery 81025147

Bio-Medical Battery Specifications:

Chemistry: Lithium
Voltage: 18.0V
Nominal Capacity: 2.1Ah
Device Manufacturer: Exogen Inc
Application: 4000+ Bone Healing System
OEM Part: 81025147
Notes:

Distance to Point, Great Cricle Distance, Cosine Theorem, Haversine formula

By , March 21, 2012 11:07 PM

Great Circle Distance Calculation

http://code.google.com/apis/maps/articles/phpsqlsearch.html

Finding locations nearby with MySQL

To find locations in our markers table that are within a certain radius distance of a given latitude/longitude, you can use a SELECT statement based on the Haversine formula. The Haversine formula is used generally for computing great-circle distances between two pairs of coordinates on a sphere. An in-depth mathemetical explanation is given by Wikipedia and a good discussion of the formula as it relates to programming is on Movable Type’s site.

Here’s the SQL statement that will find the closest 20 locations that are within a radius of 25 miles to the 37, -122 coordinate. It calculates the distance based on the latitude/longitude of that row and the target latitude/longitude, and then asks for only rows where the distance value is less than 25, orders the whole query by distance, and limits it to 20 results. To search by kilometers instead of miles, replace 3959 with 6371.

SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) – radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < 25 ORDER BY distance LIMIT 0 , 20;

 

SELECT ((ACOS(SIN($lat * PI() / 180) * SIN(`lat` * PI() / 180) + COS($lat * PI() / 180) * COS(`lat` * PI() / 180) * COS(($lon – `lon`) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance FROM `members` HAVING distance<=’10′ ORDER BY distance ASC

 

Necessary reading for Great Circle Distance Calculations

http://code.google.com/apis/maps/articles/phpsqlsearch.html

http://www.movable-type.co.uk/scripts/latlong.html

http://zcentric.com/2010/03/11/calculate-distance-in-mysql-with-latitude-and-longitude/

http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL

MySQL Group Count

By , February 25, 2012 9:58 AM

SELECT
clog.AppointmentDate,
Count(clog.CallID)
FROM
clog
WHERE
clog.Patientseen = ‘1’ AND
clog.AppointmentDate >= ‘2007-12-01’ AND
clog.AppointmentDate <= ‘2007-12-23’ GROUP BY
clog.AppointmentDate

DELETE QUERY WITH 2 TABLES

By , February 8, 2012 10:57 PM

MYSQL DELETE QUERY OVER MULTIPLE TABLES

 

DELETE calllog
FROM calllog
JOIN locum ON calllog.LocumID = locum.LocumID
WHERE locum.LastName = “ANAME”

Char and VARCHAR

By , September 5, 2011 8:34 PM

Where the data varies significantly in length from one record to the next with the longest being significantly longer than the average then you need to use a VARCHAR. There is no point in using a CHAR(40) if the average length is only 15 since that will resuult in a lot of wasted space in most records. Using a VARCHAR(40) instead means that you can still fit the leng 40 chharacter values while the average space used will be 15 plus the record length marker overhead.

summary use varchar for variable length fields and use char if you are expecting it to always be the same eg CHAR (ASSS, DASS, FASS, TASS) this is good for a char ie fixed length fields

Thomas Challenger Thomas Challenger