• From: Indonesia
  • Registered: 04/07/2011
  • Posts: 29

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

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

apprayo's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

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

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

  • From: Indonesia
  • Registered: 04/07/2011
  • Posts: 29

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

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

apprayo's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

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

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

/Joe

  • From: Indonesia
  • Registered: 04/07/2011
  • Posts: 29

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

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

Albert

apprayo's Website