Re: SQL - Output into file

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 60302
interpreted = N
texte = Hello all, I have a customer whose cart system won't calculate shipping for orderswhere shipping weight > 150lbs. It just returns $0.00 for shipping. Ican't find any limits set in code. Does UPS online limit their onlinecalculations?Thanks,Jasonwww.digitaljam.comJason AusACS/Digital JamWebmaster/Database Administrator218-346-8137 (office)218-346-8235 (fax)jasonaus@arvig.comwww.digitaljam.com----- Original Message ----- From: "Larry Hewitt" To: "WebDNA Talk" Sent: Monday, December 06, 2004 11:12 AMSubject: Re: SQL - Output into file> Duh...>> setting the path correctly was all it took. Thanks.>> Larry>>> On 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 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> >>> > -- 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 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> 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: SQL - Output into file ( "Jason Aus" 2004)
Re: SQL - Output into file ( "Jason Aus" 2004)
Re: SQL - Output into file ( Larry Hewitt 2004)
Re: SQL - Output into file ( Brian Fries 2004)
SQL - Output into file ( Larry Hewitt 2004)

Hello all, I have a customer whose cart system won't calculate shipping for orderswhere shipping weight > 150lbs. It just returns $0.00 for shipping. Ican't find any limits set in code. Does UPS online limit their onlinecalculations?Thanks,Jasonwww.digitaljam.comJason AusACS/Digital JamWebmaster/Database Administrator218-346-8137 (office)218-346-8235 (fax)jasonaus@arvig.comwww.digitaljam.com----- Original Message ----- From: "Larry Hewitt" To: "WebDNA Talk" Sent: Monday, December 06, 2004 11:12 AMSubject: Re: SQL - Output into file> Duh...>> setting the path correctly was all it took. Thanks.>> Larry>>> On 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 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> >>> > -- 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 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> 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 Web Archive of this list is at: http://webdna.smithmicro.com/ "Jason Aus"

DOWNLOAD WEBDNA NOW!

Re: SQL - Output into file

2004

Top Articles:

Related Readings: