[ic] Quickbooks IIF generation

[Curt Hauge]

On Friday, December 09, 2005 Joachim Schubert said:

> > 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]
> > [/tmp]
> >
> > 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.
[snip stuff]
>
> 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]
>    [/if]

That was exactly what I needed, thank you so much! I had not tried the OR on
the same line.

Take care!

Curt