#162 Badly formed SQL for MySQL

[Steve Wilson]

Attempting to run a simple report, I get a SQL error
back. This is the generated SQL:

select course."SO_SEC_NO"
from course

The quotes are the problem. They need to be gone for
MySQL to process this query.

[Jim Menard]

Logged In: YES
user_id=106342

This is a known bug. You can use the -q command line option
to turn off the use of quotes.

[edwinting]

Logged In: YES
user_id=1568792

Does the -q command line option work for datavision.bat on
windows?
I continue to have the problems with the quotes.
Thanks!

[mjf-qla]

Logged In: YES
user_id=1601202

I'm having the same problem with Windows; -q doesn't help.
I check the cmd window and the '-q' option is really there.
Any further thoughts? Thanks.

(BTW, you can:
SET sql_mode='ANSI_QUOTES'
and that lets the quotation marks be treated as back-tics,
which should let the SQL statements run. I'd do that for my
Datavision session if I knew how; I can't set that sql_mode
on globally.)

[Frank W. Zammetti]

Logged In: YES
user_id=1177513
Originator: NO

I lowered the priority, since there seems to be a resolution... although, I'm concerned that -q didn't seem to work for some... would like to get further info on this... I'll also try and find time to run some tests against MySQL myself.

[Frank W. Zammetti]

Logged In: YES
user_id=1177513
Originator: NO

-q works for me, so I'm going to close this with the appropriate resolution... can be reopened if it persists for people, but the suggested solution does appear to work.