Re: SELECT Into File
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 63840
interpreted = N
texte = BTW - MacOSX 3.?; Webstar; WebDNA 6I think I have a problem with this. The permissions are for Webstar to R/W; and WebDNA therefore can do so. The user for MySQL is also Webstar; would there be a different set of permissions in this case?This area always gets me fouled up.LarryOn Jan 16, 2006, at 6:38 PM, Marko Bernyk wrote:> Couls be permissions problem.>> Do you have permissions to write into the directory /Applications/ > 4dwebstar/webserver/> defaultsite/nasdtec/ ???>> Sounds like you do for folder /tmp/>> -- > Regards,> Marko>>> On Tuesday, 17 January 2006 11:09 AM, Larry Hewitt >
wrote:> 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)]>> TIA>> Larry>>>> ---------------------------------------------------------------------- > --> ------> "Democracy is two wolves and a lamb voting on what to have for lunch.> Liberty is a well-armed lamb contesting the vote."> --Benjamin Franklin>> Larry Hewitt 360.807.1100 OFFICE> HCO, LLC 360.807.1103 FAX> 109 No. Tower 360.880.4855 CELL> P.O. Box 1017 larryh@hewittco.com> Centralia, WA 98531 www.votewashington.org> www.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------------------ ------"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:
BTW - MacOSX 3.?; Webstar; WebDNA 6I think I have a problem with this. The permissions are for Webstar to R/W; and WebDNA therefore can do so. The user for MySQL is also Webstar; would there be a different set of permissions in this case?This area always gets me fouled up.LarryOn Jan 16, 2006, at 6:38 PM, Marko Bernyk wrote:> Couls be permissions problem.>> Do you have permissions to write into the directory /Applications/ > 4dwebstar/webserver/> defaultsite/nasdtec/ ???>> Sounds like you do for folder /tmp/>> -- > Regards,> Marko>>> On Tuesday, 17 January 2006 11:09 AM, Larry Hewitt > wrote:> 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)]>> TIA>> Larry>>>> ---------------------------------------------------------------------- > --> ------> "Democracy is two wolves and a lamb voting on what to have for lunch.> Liberty is a well-armed lamb contesting the vote."> --Benjamin Franklin>> Larry Hewitt 360.807.1100 OFFICE> HCO, LLC 360.807.1103 FAX> 109 No. Tower 360.880.4855 CELL> P.O. Box 1017 larryh@hewittco.com> Centralia, WA 98531 www.votewashington.org> www.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------------------ ------"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:
webcat NT (1998)
Notepad problems (1998)
Digest Version (2000)
Grep and <> (2005)
Multiple Pulldowns (1997)
Bug? (1997)
Error: Too many nested [xxx] contexts (1997)
Remove Command not working (2000)
dynamic list of form variables (2003)
Quickie question on the email templates (1997)
Extended [ConvertChars] (1997)
calculating tax rates, mail order solutions and version 2 (1997)
custom freight charges (2001)
USPS - SiteBuilder (2005)
Fwd: Problems with Webcatalog Plug-in (1997)
multi-paragraph fields (1997)
forming a SKU (1999)
RequiredFields template (1997)
[WebDNA] 8.0.2 Install on Yosemite Fails (2015)
Number searching/formats (1998)