Re[2]: [REQ] Improved SQL context
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30745
interpreted = N
texte = I think the actual error message is going to vary wildly based on the actualdatabase engine, but the concept is a good one. Since WebCat will be aware thatan SQL error has occurred, it would be good to have two contexts to deal withthat error condition. For modify the example out of the HTML documentation:[SQL dsn=Pubs&statement=SELECT * from Authors][OnSQLError] Tell the user what the [SQLerror] was and/or log it to a file and email that the the admin[/OnSQLError][OnSQL] Found [NumFound] items
[FoundItems] [au_lname], [au_fname], [title]
[/FoundItems][/OnSQL][/SQL] John Peacock____________________Reply Separator____________________Subject: Re: [REQ] Improved SQL context Author:
Date: 4/21/2000 10:16 AM>I posted this in the general list once. It would be very nice if we could>analyze the output of a SQL query just like ASP does.>>Something like:>>[OnSQLError][/OnSQLError] when we have an error message coming back>[OnSQL][/OnSQL] when we receive a proper responseCan you give me an example of what this would look like? We currently output whatever error the ODBC driver sends back to us; where can we get more information?Grant Hulbert, Director of Engineering **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentMain Line: (858) 675-1106 | http://www.smithmicro.com Fax: (858) 675-0372 **********************************#############################################################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 To switch to the INDEX mode, E-mail to Send administrative queries to
Associated Messages, from the most recent to the oldest:
|
- Re[2]: [REQ] Improved SQL context (jpeacock@univpress.com 2000)
|
I think the actual error message is going to vary wildly based on the actualdatabase engine, but the concept is a good one. Since WebCat will be aware thatan SQL error has occurred, it would be good to have two contexts to deal withthat error condition. For modify the example out of the HTML documentation:[SQL dsn=Pubs&statement=SELECT * from Authors][OnSQLError] Tell the user what the [SQLerror] was and/or log it to a file and email that the the admin[/OnSQLError][OnSQL] Found [NumFound] items
[founditems] [au_lname], [au_fname], [title]
[/FoundItems][/OnSQL][/SQL] John Peacock____________________Reply Separator____________________Subject: Re: [REQ] Improved SQL context Author: Date: 4/21/2000 10:16 AM>I posted this in the general list once. It would be very nice if we could>analyze the output of a SQL query just like ASP does.>>Something like:>>[OnSQLError][/OnSQLError] when we have an error message coming back>[OnSQL][/OnSQL] when we receive a proper responseCan you give me an example of what this would look like? We currently output whatever error the ODBC driver sends back to us; where can we get more information?Grant Hulbert, Director of Engineering **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentMain Line: (858) 675-1106 | http://www.smithmicro.com Fax: (858) 675-0372 **********************************#############################################################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 To switch to the INDEX mode, E-mail to Send administrative queries to
jpeacock@univpress.com
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:
Authorize.net has gone flooey (2006)
[WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012)
Re[2]: Putting a page between checkout and invoice (1999)
New public beta available (1997)
Price Not Appearing (2000)
4.5 Upgrade (2003)
[ShowNext] feature in 2.0 (1997)
Extended [ConvertChars] (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Protect (1997)
Webcatalog server support (1997)
Header info in content (1998)
NT Manual (1997)
Roundup function? (1997)
ErrorLog.txt (1999)
How to delete all files in a folder? (2001)
Navigator 4.01 (1997)
TCP Connect (1999)
[Case] on OS X (2000)
[WebDNA] Did someone answer this? (2013)