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:

using showpage and showcart commands (1996) Strange intermittent WebDNA problems (2008) webcat serving multiple copies of same db from ram (2000) Sorting error (1997) This list needs a digest: rant, rave... (1997) Simple way to create unique SKU (1997) tag request (1999) Nested tags count question (1997) [input] [/input] (1997) RE: Any limit to [include] (1997) Problems with [Applescript] (1997) PC Auth Hub+Merchant (1998) Country & Ship-to address & other fields ? (1997) F*** you (1998) Dumb Question about Docs (1997) [WebDNA] Bug in WebDNA or in my brain? (2013) Download URL & access on the fly ? (1997) Latin Characters (1998) Urgent help needed (1998) [file] (2005)