What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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? - 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL - Output into file ( "Jason Aus" 2004)
  2. Re: SQL - Output into file ( "Jason Aus" 2004)
  3. Re: SQL - Output into file ( Larry Hewitt 2004)
  4. Re: SQL - Output into file ( Brian Fries 2004)
  5. SQL - Output into file ( Larry Hewitt 2004)
'/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/ 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:

Payment Processors (2006) How is it done? (1998) Strange search... (2001) Duplicate Carts (2000) [shownext] link disappears after first use. Why? (2000) Limiting user access to .tmpl files (1997) 2.0 Info (1997) Searchable Talklist Archive (1998) unable to run webcatalog locally (1998) possible, WebCat2.0 and checkboxes-restated (1997) Up and running ... at last !! (1997) remotely add + sign (1997) [OT] Cold Fusion snippet please... (2002) [WebDNA] Problem with administration (2009) Summing fields (1997) Postprocessing CCs (2000) redirect from the errorsMessages.db entry (1997) WebCatalog for guestbook ? (1997) WebCatalog can't find database (1997) Erotic Sites (1997)