[interchange-cvs] interchange - heins modified extensions/quickbooks/pages/admin/quickbooks/generate_new_iif.html

[interchange-cvs at icdevgroup.org]

User:      heins
Date:      2005-09-08 16:34:26 GMT
Modified:  extensions/quickbooks/pages/admin/quickbooks
Modified:           generate_new_iif.html
Log:
* Make [query ...] base be transactions to avoid using Vend::SQL_Parser
  when products is not in same DSN as transactions.

* Use proper SQL <> operator instead of the != I propagated all over the
  catalog originally.

Revision  Changes    Path
2.3       +2 -2      interchange/extensions/quickbooks/pages/admin/quickbooks/generate_new_iif.html


rev 2.3, prev_rev 2.2
Index: generate_new_iif.html
===================================================================
RCS file: /var/cvs/interchange/extensions/quickbooks/pages/admin/quickbooks/generate_new_iif.html,v
retrieving revision 2.2
retrieving revision 2.3
diff -u -r2.2 -r2.3
--- generate_new_iif.html	3 Jul 2003 02:24:07 -0000	2.2
+++ generate_new_iif.html	8 Sep 2005 16:34:25 -0000	2.3
@@ -142,7 +142,7 @@
 		SELECT		*
 		FROM		transactions
 		WHERE		1=1
-		AND			deleted != 1
+		AND			deleted <> 1
 		[if cgi date_from]
 			AND order_ymd >= '[cgi date_from]'
 			AND order_ymd <= '[cgi date_to]'
@@ -164,7 +164,7 @@
 	[tmp mv_add_dot_html]0[/tmp] 
 	
 	
-	[query prefix=tx list=1 type=list sql='[scratch sql]']
+	[query base=transactions prefix=tx list=1 type=list sql='[scratch sql]']
 		[no-match] No Match.  Query was <pre>[scratch sql]</pre> [/no-match]
 		[list]