Re: MySQL and Decimals
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57853
interpreted = N
texte = Hi,I started experimenting with MySQL as well. I started a MySQl Admin that Ihope will be similar to if not better than phpmyadmin.I haven't had much time to work on it lately, but you can check it out here.http://69.44.60.22/MySqlDNA/default.tplUsername: webdnaPassword: mysql Salvatore B. D'AnnaDotNetNuke HostingV:(619)306-7606F: (619)374-2268http://DotNetNukeHosting.com -----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfLarry HewittSent: Friday, May 14, 2004 12:28 PMTo: WebDNA TalkSubject: Re: MySQL and DecimalsJohn -Thanks for the info.I am just now experimenting with MySQL, and appreciate the tips.LarryOn May 14, 2004, at 12:03 PM, John Peacock wrote:> Larry Hewitt wrote:>>> [SQLExecute conn_ref=conn1&result_var=1]>> SELECT * FROM QUICKFACTS ORDER by ID;>> [/SQLExecute]>> FWIW, this is sloppy code; you should always specify the fieldnames in > your SQL query, even if you intend to use all of them. The reason for > that is performance; if you use "SELECT *" then the query optimizer > has to lookup the fields in the system table, then check for any > applicable indexes, and only then perform the actual query.>> Since WebDNA does not support cursors, every single page will require > all of the above steps. If you can cut out the system table query, > you can save precious CPU cycles for more important use.>> John>> -- > John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4501 Forbes Boulevard> Suite H> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5748>> -------------------------------------------------------------> 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 Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX1133 Kresky NE #106360.508.6231 CELLCentralia, WA 98531larryh@hewittco.comwww.hewittco.comwww.votewashington.org-------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.smithmicro.com/__________ NOD32 1.759 (20040513) Information __________This message was checked by NOD32 Antivirus System.http://www.nod32.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:
Hi,I started experimenting with MySQL as well. I started a MySQl Admin that Ihope will be similar to if not better than phpmyadmin.I haven't had much time to work on it lately, but you can check it out here.http://69.44.60.22/MySqlDNA/default.tplUsername: webdnaPassword: mysql Salvatore B. D'AnnaDotNetNuke HostingV:(619)306-7606F: (619)374-2268http://DotNetNukeHosting.com -----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfLarry HewittSent: Friday, May 14, 2004 12:28 PMTo: WebDNA TalkSubject: Re: MySQL and DecimalsJohn -Thanks for the info.I am just now experimenting with MySQL, and appreciate the tips.LarryOn May 14, 2004, at 12:03 PM, John Peacock wrote:> Larry Hewitt wrote:>>> [SQLExecute conn_ref=conn1&result_var=1]>> SELECT * FROM QUICKFACTS ORDER by ID;>> [/SQLExecute]>> FWIW, this is sloppy code; you should always specify the fieldnames in > your SQL query, even if you intend to use all of them. The reason for > that is performance; if you use "SELECT *" then the query optimizer > has to lookup the fields in the system table, then check for any > applicable indexes, and only then perform the actual query.>> Since WebDNA does not support cursors, every single page will require > all of the above steps. If you can cut out the system table query, > you can save precious CPU cycles for more important use.>> John>> -- > John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4501 Forbes Boulevard> Suite H> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5748>> -------------------------------------------------------------> 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 Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX1133 Kresky NE #106360.508.6231 CELLCentralia, WA 98531larryh@hewittco.comwww.hewittco.comwww.votewashington.org-------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.smithmicro.com/__________ NOD32 1.759 (20040513) Information __________This message was checked by NOD32 Antivirus System.http://www.nod32.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/
"Sal"
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] Topic... (2004)
Tax Troubles (2003)
multi-paragraph fields (1997)
Help formatting search results w/ table (1997)
Cookie set browser session. (1998)
WebCat2 several catalogs? (1997)
Emailer help....! (1997)
WCS Newbie question (1997)
Convert "&" to "&" using [grep] (2006)
autosensing lanague selection (1997)
FTP Address (2003)
Design Help Needed (1998)
Simple Database close connection (2001)
no global [username] or [password] displayed ... (1997)
NewCart+Search with one click ? (1997)
Bulk Email >>>>Any ideas? (2001)
WebMerchant 1.6 and SHTML (1997)
Random sort is not random at all..... (2000)
[GROUPS] followup (1997)
Cart doesn't interpret tag! (1997)