Re: Catch MySQL Connection error

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60868
interpreted = N
texte = This is what we use - real simple... [text]connect=3D0[/text] [SQLConnect =20 dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D[pwd]&conn_= var=3Dconn=20 1] [text]connect=3D1[/text] [/SQLConnect] [showif [connect]=3D0][redirect error.tpl][/showif] Larry On Jan 27, 2005, at 2:58 AM, Nitai @ ComputerOil wrote: > Hi all > > Has anybody found a way to catch a MySQL Connection error? I don=92t = see =20 > anything in the docs. > > The goal is to see if a connection to the server could be established =20= > or not. So far if I have a wrong connection and I issue a [sqlconnect] = =20 > I receive this: > > ERROR: MySQL DATABASE CONNECTION FAILED! - Unknown MySQL Server Host =20= > '127.0.0.' (0) ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1". > - Subsequent SQL commands attempting to use that result ID will fail. > > TIA. > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > =A0 > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > =A0 > info@computeroil.com > http://computeroil.com > =A0 > > > > ------------------------------------------------------------- > 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 =20 > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Larry Hewitt360.807.1100 = OFFICE HCO, LLC 360.807.1103 = FAX 109 No. Tower360.880.4855 = CELL P.O. Box 1017= larryh@hewittco.com Centralia, WA 98531www.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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Catch MySQL Connection error ( "Nitai @ ComputerOil" 2005)
  2. Re: Catch MySQL Connection error ( Larry Hewitt 2005)
  3. Catch MySQL Connection error ( "Nitai @ ComputerOil" 2005)
This is what we use - real simple... [text]connect=3D0[/text] [SQLConnect =20 dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D[pwd]&conn_= var=3Dconn=20 1] [text]connect=3D1[/text] [/SQLConnect] [showif [connect]=3D0][redirect error.tpl][/showif] Larry On Jan 27, 2005, at 2:58 AM, Nitai @ ComputerOil wrote: > Hi all > > Has anybody found a way to catch a MySQL Connection error? I don=92t = see =20 > anything in the docs. > > The goal is to see if a connection to the server could be established =20= > or not. So far if I have a wrong connection and I issue a [SQLconnect] = =20 > I receive this: > > ERROR: MySQL DATABASE CONNECTION FAILED! - Unknown MySQL Server Host =20= > '127.0.0.' (0) ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1". > - Subsequent SQL commands attempting to use that result ID will fail. > > TIA. > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > =A0 > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > =A0 > info@computeroil.com > http://computeroil.com > =A0 > > > > ------------------------------------------------------------- > 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 =20 > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Larry Hewitt360.807.1100 = OFFICE HCO, LLC 360.807.1103 = FAX 109 No. Tower360.880.4855 = CELL P.O. Box 1017= larryh@hewittco.com Centralia, WA 98531www.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/ 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:

Multiple prices (1997) Sort Order on a page search (1997) problem serving foreign languages text (1997) Serial Number Question (1997) [Announce]: Web server security and password protection (1997) unable to launch acgi in WebCat (1997) Up and running ... at last !! (1997) Changing the value assigned to a formvariable (2000) taxrate - off by 1 cent (1997) [HIDEIF] inside [FOUNDITEM] (1997) Summing fields (1997) Slightly [OT] Trying to get clients SQL system going (2005) Upload (1998) [WebDNA] Build Name for 6.1 (2008) Professional WebDNA Hosting Solutions (2005) [WriteFile] problems (1997) Listwords and the & (2001) Intermitent problem using [referrer] (1997) Help! WebCat2 bug (1997) [WebDNA] Cron vs. trigger syntax (2014)