Re: SQL - Output into file
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60300
interpreted = N
texte = '/result.txt', as far as MySQL is concerned, is the root of the System (not the web site, which MySQL has no knowledge of). Does MySQL have privileges to write there?- brianOn Dec 6, 2004, at 8:23 AM, Larry Hewitt wrote:> SELECT votes,percent INTO OUTFILE '/result.txt' FIELDS TERMINATED BY > ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM > candidates_co;>> This code is right out of the MySql manual. I get a 'can't > create/write' error. The docs say the FilePriv must be set to Y, > which according to the MySQL tables is.>> Any ideas?>>>> Larry Hewitt360.807.1100 OFFICE> HCO, LLC 360.807.1103 FAX> 109 No. Tower360.880.4855 CELL> P.O. Box 1017larryh@hewittco.com> Centralia, WA 98531www.votewashington.org> www.hewittco.com>-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com ---------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
'/result.txt', as far as MySQL is concerned, is the root of the System (not the web site, which MySQL has no knowledge of). Does MySQL have privileges to write there?- brianOn Dec 6, 2004, at 8:23 AM, Larry Hewitt wrote:> SELECT votes,percent INTO OUTFILE '/result.txt' FIELDS TERMINATED BY > ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM > candidates_co;>> This code is right out of the MySql manual. I get a 'can't > create/write' error. The docs say the FilePriv must be set to Y, > which according to the MySQL tables is.>> Any ideas?>>>> Larry Hewitt360.807.1100 OFFICE> HCO, LLC 360.807.1103 FAX> 109 No. Tower360.880.4855 CELL> P.O. Box 1017larryh@hewittco.com> Centralia, WA 98531www.votewashington.org> www.hewittco.com>-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com ---------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Brian Fries
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
problems with 2 tags shakur (1997)
WebCat2b12 - nesting [tags] (1997)
WebCatalog stalls (1998)
What am I missing (1997)
Problems with upload / WebCat (1998)
[WebDNA] ONLY the FIRST continuous run of numeric chars? (2008)
OT: RAID Options (2004)
OT: Forcing a header when printing web pages (2002)
Multiple fields on 1 input (1997)
No Data (1997)
problems with WebCat-Plugin (1997)
Three new problems, maybe a fourth (1997)
quotes and truncating? (1997)
Credit Card Number checking (1997)
Calendar (1997)
Upgrade Installation (1998)
No luck with taxes (1997)
HomePage Caution (1997)
locking variables? (2000)
[WebDNA] Apple nixes Mac OS Server ("websites") and other services (2018)