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] bulk e-mail (2011)
Adding Shipping Costs based on percent of subtotal (1997)
emailer problem on OS X - unsent emails (2003)
Re:Searching for ALL / empty form field *the FINAL answer* (1997)
Expiration of Carts (1997)
WebMerchant? (1998)
SetCookie / GetCookie Problem.... (2004)
A link and two command (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Sub Categories (2000)
Math with Time (1997)
Download Question (1997)
F3 crashing server (1997)
[INCLUDE] Limitations (1998)
'RequiredField' Question (1998)
I'm tired of all this! (2000)
[ShowIf] and empty fields (1997)
Summing fields (1997)
Alternative colors? (2000)
Using Applescript to process WebCatalog functions (1998)