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 worksContent Management & eBusiness Systems ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://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:
True, real simple. Thank you.Nitai--Redakto - Content Management that simply worksContent Management & eBusiness Systems ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://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)