r6175 - trunk/lib/org/freemedsoftware/module

[subve...@svn.freemedsoftware.org]

Author: jeff
Date: 2011-11-16 01:04:31 -0500 (Wed, 16 Nov 2011)
New Revision: 6175

Modified:
trunk/lib/org/freemedsoftware/module/NDCLexicon.class.php
Log:
Fix drug picker to only display drugs starting with search string.

Modified: trunk/lib/org/freemedsoftware/module/NDCLexicon.class.php
===================================================================
--- trunk/lib/org/freemedsoftware/module/NDCLexicon.class.php 2011-11-16 06:03:09 UTC (rev 6174)
+++ trunk/lib/org/freemedsoftware/module/NDCLexicon.class.php 2011-11-16 06:04:31 UTC (rev 6175)
@@ -53,7 +53,7 @@
// Array of hashes
//
function TradenamePicklist ( $criteria = NULL, $limit = 20 ) {
- $c[] = "LOWER(tradename) LIKE LOWER('%".$GLOBALS['sql']->escape( $criteria )."%')";
+ $c[] = "LOWER(tradename) LIKE LOWER('".$GLOBALS['sql']->escape( $criteria )."%')";
$query = "SELECT * FROM ndc_name_lookup ".
( is_array($c) ? " WHERE ".join(' OR ',$c) : "" ).
" ORDER BY tradename ".