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

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

2011-06-08T05:23:00Z

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

2011-06-07T20:59:25Z

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

/Joe

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

2011-06-07T17:00:01Z

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

2011-06-07T14:05:53Z

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

2011-06-07T10:09:46Z

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