Re: SQL - Output into file
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60301
interpreted = N
texte = Duh...setting the path correctly was all it took. Thanks.LarryOn Dec 6, 2004, at 9:04 AM, Brian Fries wrote:> '/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?>> - brian>> On 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/>>Larry Hewitt360.807.1100 OFFICEHCO, LLC 360.807.1103 FAX109 No. Tower360.880.4855 CELLP.O. Box 1017larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.hewittco.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:
Duh...setting the path correctly was all it took. Thanks.LarryOn Dec 6, 2004, at 9:04 AM, Brian Fries wrote:> '/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?>> - brian>> On 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/>>Larry Hewitt360.807.1100 OFFICEHCO, LLC 360.807.1103 FAX109 No. Tower360.880.4855 CELLP.O. Box 1017larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.hewittco.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/
Larry Hewitt
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:
Sandbox Question (2003)
Multiple Users.db Possible? (1997)
[WebDNA] showif with empty variable (2015)
You can't buy something twice... (1997)
special commerce fields (1997)
updating with ProductEditor (1998)
question: back button prevention (1997)
File not found error message (1998)
Standalone Testing (1998)
cc auth with [purchase] (1998)
no global [username] or [password] displayed ... (1997)
Quit revisited (1997)
Easter (1998)
Exclude by date - multiple (1997)
PC Hub and Web Merchant (1998)
lookup problem (2000)
Multiple Newcarts (1996)
[math] are you there? (1999)
sendmail in html format? (2002)
Nested tags count question (1997)