[ic] Quickbooks IIF generation
joachim at schubis-dd.de
Fri Dec 9 04:05:00 EST 2005
On Thu, Dec 08, 2005 at 09:32:48PM -0600, Curt Hauge wrote:
> Hi all,
> IC5.2.0 Perl 5.8.2 MySQL 3.23 Apache 1.3.22 Redhat 7.2 4.8 Construct catalog
> I am trying to get Quickbooks working with Interchange. It is installed and
> working for the most part, however, I am having trouble with one selection
> on the generate_new_iif.html page. If you select "Generate any new IIF
> files", this query does not include a record UNLESS the comment field
> already has data in it:
> [tmp sql]
> SELECT *
> FROM transactions
> WHERE 1=1
> AND deleted <> 1
> [snip stuff]
> [if cgi query_type eq 'any_new']
> AND comments NOT LIKE '%(syncronized)'
> LIMIT [scratch any_new_limit]
> If comments field is empty, the transaction is not included in the list, but
> it SHOULD be.
> If comments fields has data in it (but without (syncronized) on the end), it
> is included, like it should be.
> If comments field has (syncronized) at the end of the file, it is not
> included, and it shouldn't be.
> The comments field obviously could be empty, so this is not good.
> I have searched the mail archives and I am currently using the above code
> which I extracted from the 5.3.2 release. I have tried changing the field
> type to varchar(255) instead of TEXT, but comments is currently a TEXT
> field. I've also tried changing the expression around a bit without any
have you tried (if the default value for comments is NULL):
[if cgi query_type eq 'any_new']
AND ( comments NOT LIKE '%(syncronized)' OR comments is NULL )
LIMIT [scratch any_new_limit]
> Can anyone see an obvious solution and offer some assistance?
> Thank you.
> Curt Hauge
> Office 763-689-4984
> Cell 612-598-5530
> interchange-users mailing list
> interchange-users at icdevgroup.org
More information about the interchange-users