Gossamer Forum
Home : Products : Others : MySQLMan :

Save Results not working

Quote Reply
Save Results not working
Hi,

I love this script! I have been having one problem though.

I cannot use the Save Results feature for a successful query. I have to page through sometimes 50 pages of results copying each.

When I click either Print to Screen or Export to File (I leave the default characters), I get the following error:

Error
MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO OUTFILE '/usr/tmp/GTMM114235266814895577' FIELDS ' at line 2.
Query: SELECT INTO OUTFILE '/usr/tmp/GTMM114235266814895577' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM invoices

I can't figure out why. Could it be something related to how the MySQL server is set up? The current version is mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686)

Thanks!
Darren

Last edited by:

dc312: Mar 14, 2006, 8:16 AM