SF.net SVN: ledger-smb: [2154] trunk/sql/modules/Company.sql

[..hidden..]

Revision: 2154
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2154&view=rev
Author:   einhverfr
Date:     2008-05-21 11:12:52 -0700 (Wed, 21 May 2008)

Log Message:
-----------
Correcting more vendor search errors.

Modified Paths:
--------------
    trunk/sql/modules/Company.sql

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2008-05-21 18:07:00 UTC (rev 2153)
+++ trunk/sql/modules/Company.sql	2008-05-21 18:12:52 UTC (rev 2154)
@@ -41,7 +41,7 @@
 			AND (ec.meta_number = in_meta_number 
 				OR in_meta_number IS NULL)
 			AND (c.legal_name like '%' || in_legal_name || '%'
-				OR legal_name IS NULL)
+				OR in_legal_name IS NULL)
 			AND ((in_address IS NULL AND in_city IS NULL 
 					AND in_state IS NULL 
 					AND in_country IS NULL)
@@ -79,7 +79,7 @@
 					AND in_business_id IS NULL))
 			AND (ec.startdate <= coalesce(in_date_to, 
 						ec.startdate)
-				OR (ec.startdate IS NULL)
+				OR (ec.startdate IS NULL))
 			AND (ec.enddate >= coalesce(in_date_from, ec.enddate)
 				OR (ec.enddate IS NULL))
 	LOOP


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.