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 =20dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D[pwd]&conn_=var=3Dconn=201][text]connect=3D1[/text][/SQLConnect][showif [connect]=3D0][redirect error.tpl][/showif]LarryOn 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 =OFFICEHCO, LLC 360.807.1103 =FAX109 No. Tower360.880.4855 =CELLP.O. Box 1017=larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.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:
This is what we use - real simple...[text]connect=3D0[/text][SQLConnect =20dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D[pwd]&conn_=var=3Dconn=201][text]connect=3D1[/text][/SQLConnect][showif [connect]=3D0][redirect error.tpl][/showif]LarryOn 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 =OFFICEHCO, LLC 360.807.1103 =FAX109 No. Tower360.880.4855 =CELLP.O. Box 1017=larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.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)