Re: [WebDNA] try/except
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 111856
interpreted = N
texte = Very interesting. I=92ll have to go dig up and play with that database.=20=So here=92s an odd thing, setting a text variable inside an append still =works, even if the append fails.handy to find if an append fails to suspend any chained database =operations.example (again given a database =91test.db' that can not be written to:[text]testid=3Dblar[/text][testid]
[append =db=3D^data/test.db&AUTONUMBER=3DID][text]testid=3D[thisautonumber][/text]f=ield1=3Dyes&field2=3Dno[/append]
[showif [testid]=3D]an error occured
[/showif]shows the error message.> On Jan 12, 2015, at 1:22 PM, Kenneth Grome
=wrote:>=20> Just edit the correct record in errorMessages.db and it will send> you email in this situation.>=20> Then put the append context inside an html comment to hide it from> the visitor in case an error is generated.>=20> Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Management>=20>=20> On 01/12/2015 01:00 PM, Brian Burton wrote:>> Just discovered a lovely little problem involving appending records =to a database, the database having the wrong owner or permissions or =whatever (Thanks Obama Unix> and website users being =oblivious to the ugly error message webdna kicked out that displayed at =the top of the page.=20>>=20>> steps to reproduce:>> create a database that webdna can=92t write to because of incorrect =permissions (test.db)>>=20>> [append db=3D^data/test.db]field1=3Dyes&field2=3Dno[/append]>> will yield:>> Error: Permision deny. Unable to append to 'test.db' .Ignoring =[Append] context.>>=20>> if turns out this works:>> [showif [append db=3Dtest.db]field1=3Dyes&field2=3Dno[/append]~Error]a =problem was encountered[/showif]>>=20>> but it=92s U.G.L.Y.=20>>=20>> what would be nice:>>=20>> [try]>> [append db=3D^data/test.db]field1=3Dyes&field2=3Dno[/append]>> [except]>> [sendmail to=3Dme&from=3Dwebserver] Problems. Problems =EVERYWHERE! [/sendmail]>> [/except]>> [/try]>>=20>>=20>> I realize this won=92t get used often, but there are occasionally =some database operations where failure is not an option, and an admin =needs to get alerted directly is something goes wrong.=20>>=20>> -BBB>=20
Associated Messages, from the most recent to the oldest:
Very interesting. I=92ll have to go dig up and play with that database.=20=So here=92s an odd thing, setting a text variable inside an append still =works, even if the append fails.handy to find if an append fails to suspend any chained database =operations.example (again given a database =91test.db' that can not be written to:[text]testid=3Dblar[/text][testid]
[append =db=3D^data/test.db&AUTONUMBER=3DID][text]testid=3D[thisautonumber][/text]f=ield1=3Dyes&field2=3Dno[/append]
[showif [testid]=3D]an error occured
[/showif]shows the error message.> On Jan 12, 2015, at 1:22 PM, Kenneth Grome =wrote:>=20> Just edit the correct record in errorMessages.db and it will send> you email in this situation.>=20> Then put the append context inside an html comment to hide it from> the visitor in case an error is generated.>=20> Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Management>=20>=20> On 01/12/2015 01:00 PM, Brian Burton wrote:>> Just discovered a lovely little problem involving appending records =to a database, the database having the wrong owner or permissions or =whatever (Thanks Obama Unix> and website users being =oblivious to the ugly error message webdna kicked out that displayed at =the top of the page.=20>>=20>> steps to reproduce:>> create a database that webdna can=92t write to because of incorrect =permissions (test.db)>>=20>> [append db=3D^data/test.db]field1=3Dyes&field2=3Dno[/append]>> will yield:>> Error: Permision deny. Unable to append to 'test.db' .Ignoring =[append] context.>>=20>> if turns out this works:>> [showif [append db=3Dtest.db]field1=3Dyes&field2=3Dno[/append]~Error]a =problem was encountered[/showif]>>=20>> but it=92s U.G.L.Y.=20>>=20>> what would be nice:>>=20>> [try]>> [append db=3D^data/test.db]field1=3Dyes&field2=3Dno[/append]>> [except]>> [sendmail to=3Dme&from=3Dwebserver] Problems. Problems =EVERYWHERE! [/sendmail]>> [/except]>> [/try]>>=20>>=20>> I realize this won=92t get used often, but there are occasionally =some database operations where failure is not an option, and an admin =needs to get alerted directly is something goes wrong.=20>>=20>> -BBB>=20
Brian Burton
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:
Separate SSL Server (1997)
emailer (1997)
Grep search not working (2002)
Public Beta for WebCatalog 4.0 is Available (2000)
[WebDNA] Fails to recognize comma-separated db (2010)
WebMerchant bomb (1998)
Email Set-Up? (1997)
Newbie problem blah blah blah (1997)
free zip codes database (1999)
syntax question, not in online refernce (1997)
E-mailer error codes (1997)
WebCatalog for guestbook ? (1997)
Nested tags count question (1997)
RE: type 2 errors with ssl server (1997)
Renaming TextA (1998)
This [search] worked before update to 4.5.1 (2003)
Mac: [ListFiles] bug alert (1997)
Emailer (1997)
RE: protect tag on NT (1997)
(1997)