• 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
  • « solved bug in compound searches including treatment
  • Add treatments to search-by and order-by fields »

investigate bug report with search for Treatment

Posted by sarneil on 30 Jan 2009 in Activity log

ML reported that he was getting an SQL error message when he tried to search by treatment

Query failed: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'( t1.treatment_text LIKE '%cure%' OR t2.treatment_text LIKE '%cure%')
GROUP BY ' at line 1

I could not reproduce the behaviour, so asked him to confirm the problem and report on browser and OS, so I could try to reproduce it.

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 • Bootstrap CMS