Re: Catch MySQL Connection error

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60876
interpreted = N
texte = True, real simple. Thank you. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Larry Hewitt > Sent: Donnerstag, 27. Januar 2005 17:14 > To: WebDNA Talk > Subject: Re: Catch MySQL Connection error > > This is what we use - real simple... > > [text]connect=3D0[/text] > [SQLConnect > dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D= [pwd]&conn_var=3Dconn > 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=20= don=E2=80=99t see > > anything in the docs. > > > > The goal is to see if a connection to the server could be est= ablished > > or not. So far if I have a wrong connection and I issue a [sq= lconnect] > > I receive this: > > > > ERROR: MySQL DATABASE CONNECTION FAILED! - Unknown MySQL Serv= er Host > > '127.0.0.' (0) ERROR: COULD NOT FIND SQLCONNECT VARIABLE "con= n1". > > - Subsequent SQL commands attempting to use that result ID wi= ll fail. > > > > TIA. > > > > Nitai > > > > -- > > Redakto - Content Management that simply works > > Content Management & eBusiness Systems > > > > ComputerOil=C2=AE AG > > Dammstrasse 7 > > 5400 Baden / Switzerland > > Telefon +41 (0)844 44 55 66 > > > > info@computeroil.com > > http://computeroil.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 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 > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > 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:

    
  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)
True, real simple. Thank you. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Larry Hewitt > Sent: Donnerstag, 27. Januar 2005 17:14 > To: WebDNA Talk > Subject: Re: Catch MySQL Connection error > > This is what we use - real simple... > > [text]connect=3D0[/text] > [SQLConnect > dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D= [pwd]&conn_var=3Dconn > 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=20= don=E2=80=99t see > > anything in the docs. > > > > The goal is to see if a connection to the server could be est= ablished > > or not. So far if I have a wrong connection and I issue a [sq= lconnect] > > I receive this: > > > > ERROR: MySQL DATABASE CONNECTION FAILED! - Unknown MySQL Serv= er Host > > '127.0.0.' (0) ERROR: COULD NOT FIND SQLCONNECT VARIABLE "con= n1". > > - Subsequent SQL commands attempting to use that result ID wi= ll fail. > > > > TIA. > > > > Nitai > > > > -- > > Redakto - Content Management that simply works > > Content Management & eBusiness Systems > > > > ComputerOil=C2=AE AG > > Dammstrasse 7 > > 5400 Baden / Switzerland > > Telefon +41 (0)844 44 55 66 > > > > info@computeroil.com > > http://computeroil.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 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 > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > 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/ "Nitai @ ComputerOil"

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:

Country & Ship-to address & other fields ? (1997) What is WebDNA (1997) truncating email part II (1997) [Summary] re: Emailer setup (1997) Can webcat 3.0/4.0 handle 1,000,000 hits a day? (2000) Frames and WebCat (1997) WebCat2b15MacPlugin - showing [math] (1997) Yet another db manager (2004) FORMS: Returning a specific page (1997) more info on [setlineitems] (1997) [WebDNA] sendmail attached file (2011) RE: Still Learning (1997) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) Mac Programs (1998) Unexpected comparison behavior change in 4.5.1 (2003) oops private message leaked into talk list (1997) Generating Report Totals (1997) restarting service remotely on NT (1997) RE: Deafness (1998) pc (1997)