SELECT Into File
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 63838
interpreted = N
texte = I ran across a thread of this statement with the list about 18 months ago that seemed to say I figured this out, but I'm stumped.This is on our test server:This works fine:SELECT * INTO OUTFILE '/tmp/test.txt' FROM names;This doesn't:SELECT * INTO OUTFILE '/Applications/4dwebstar/webserver/defaultsite/ nasdtec/test.txt' FROM names;[Can't create/write to file '/Applications/4dwebstar/webserver/ defaultsite/nasdtec/test.txt' (Errcode: 13)]TIALarry------------------------------------------------------------------------ ------"Democracy is two wolves and a lamb voting on what to have for lunch.Liberty is a well-armed lamb contesting the vote."--Benjamin FranklinLarry Hewitt 360.807.1100 OFFICEHCO, LLC 360.807.1103 FAX109 No. Tower 360.880.4855 CELLP.O. Box 1017 larryh@hewittco.comCentralia, WA 98531 www.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:
I ran across a thread of this statement with the list about 18 months ago that seemed to say I figured this out, but I'm stumped.This is on our test server:This works fine:SELECT * INTO OUTFILE '/tmp/test.txt' FROM names;This doesn't:SELECT * INTO OUTFILE '/Applications/4dwebstar/webserver/defaultsite/ nasdtec/test.txt' FROM names;[Can't create/write to file '/Applications/4dwebstar/webserver/ defaultsite/nasdtec/test.txt' (Errcode: 13)]TIALarry------------------------------------------------------------------------ ------"Democracy is two wolves and a lamb voting on what to have for lunch.Liberty is a well-armed lamb contesting the vote."--Benjamin FranklinLarry Hewitt 360.807.1100 OFFICEHCO, LLC 360.807.1103 FAX109 No. Tower 360.880.4855 CELLP.O. Box 1017 larryh@hewittco.comCentralia, WA 98531 www.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:
WebDNA-Talk Digest mode broken (1997)
breaking & sorting (2000)
variable value locked when passed to include (2001)
File Upload (1997)
TCPconnect issue (2000)
Permissions (2000)
missing records (1998)
Return as Delimeter (2000)
deadlock (2000)
Passwords, Subscription, DBs, oh my! (2000)
all records returned. (1997)
HELP WITH DATES (1997)
WC2b15 File Corruption (1997)
Using Applescript to process WebCatalog functions (1998)
Multiple catalog databases and showcart (1997)
upload images and other data (2001)
PROBLEMS WITH WEBCAT LINUX (2000)
Speed Optimization - Mac (1997)
emailer on Windows Beta 18 (1997)
Showing unopened cart (1997)