FrontAccounting forum — Report generator: cannot use quote mark (" or ') in query

Re: Report generator: cannot use quote mark (" or ') in query

null@example.com (apprayo) — Wed, 08 Jun 2011 05:23:00 +0000

Finally I can create a report without any quote marks
Btw, I was creating a pdf report for stock movements, because I don't see a pdf report available for it.

Albert

Re: Report generator: cannot use quote mark (" or ') in query

null@example.com (joe) — Tue, 07 Jun 2011 20:59:25 +0000

Ah, sorry, look into some of the source files at the very top.

/Joe

Re: Report generator: cannot use quote mark (" or ') in query

null@example.com (apprayo) — Tue, 07 Jun 2011 17:00:01 +0000

Oh, I just read in the readme.txt file that the author is Joe Hunt. And I thought that was you.
Hmmm... So, to whom can I send my questions?

Albert

Re: Report generator: cannot use quote mark (" or ') in query

null@example.com (joe) — Tue, 07 Jun 2011 14:05:53 +0000

This report generator was not written by us, but by another guy (look into the readme file). It was only adapted by us to fit into FA.

So I guess you are right. No quote mark in queries.

/Joe

Report generator: cannot use quote mark (" or ') in query

null@example.com (apprayo) — Tue, 07 Jun 2011 10:09:46 +0000

Hi all,

I'm trying to create a report using report generator module. In SQL query, I need to filter and modify some fields' values, using 'where field_name = "blablabla"' and 'date_format(date_field, "blablabla")'. But the SQL was said having SQL error, and I got error code : 1064.

The problem was gone if I remove every filter and modifying function which use quote mark (" or ').

Does this mean we should not use quote mark in the query?

Albert