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:
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)