• HCMC Blogs
  • Moses
  • Maint
  • Mariage
  • Admin
  • Academic
  • Depts
  • ScanCan
  • HumsSites
  • Projects
  • Pro-D
  • ColDesp
  • CanMys
  • LondonMap
  • AdaptiveDB
  • MoM
  • Cascade
  • Landscapes
  • Linguistics
  • CGWP
  • Endings
  • LEMDO
  • DVPP
  • Wendat
  • Announcements

Contact Us on 0800 123 4567 or info@example.com

German Medical Exams

  • Front Page
  • Contact
  • Log in
  • « minor updates to renmedic
  • created show/hide detail presentation »

reconcile previous and proposed treatment lists

Posted by sarneil on 18 Dec 2008 in Activity log
The lists for the previous treatment field and the recommended treatment fields are very similar, so I rejigged the numeric values for some of the values in each of those fields, so that I ended up with no conflicts. This will ultimately allow me to use one "treatments" table should I want to, rather than two separate tables. Had to modify the GUI in the add.htm and doGetRecord.php files, the actual fields in the mysql db file and then I had to do a number of UPDATES the database to correct any records which had old values for any of the affected fields so that they now had the correct new values. Typical query (from memory): UPDATE exams SET previous_treatment_1 = 21 WHERE previous_treatment_1 = 18
This entry was posted by Stewart and filed under Activity log.

German Medical Exams

This project will create an xml-based database of medical exam reports from the 16th through 19th centuries in Germany. The database will allow researchers to query medical practices in that time and to infer changes in the administration of medical care and other social changes.
  • Home
  • Recently
  • Archives
  • Categories
  • Latest comments

Search

Categories

  • All
  • Activity log
  • Announcements
  • Tasks

XML Feeds

  • RSS 2.0: Posts
  • Atom: Posts
What is RSS?

Recent Posts

  • allow for AND or OR operator within multiselect fields
  • query fails when more than one item selected in multiselect fields
  • add filter for Has Nurse or Support Care
  • add another search, one still to go
  • update order-by control
  • Add search of treatments textarea
  • Add search of conditions textarea, new report presentation to follow
  • change which fields appear in report
  • fix couple of bugs in sql
  • fix errors in dropdown lists

Sidebar 2

This is the "Sidebar 2" container. You can place any widget you like in here. In the evo toolbar at the top of this page, select "Customize", then "Blog Widgets".

This collection ©2026 by admin • Help • Responsive CMS