Hi all, IC5.2.0 Perl 5.8.2 MySQL 3.23 Apache 1.3.22 Redhat 7.2 4.8 Construct catalog updated 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. 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 luck. Can anyone see an obvious solution and offer some assistance? Thank you. Curt Hauge Office 763-689-4984 Cell 612-598-5530 www.IWantAConsultant.com www.MNWebDesign.com _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.