Re: practicing safe queries..
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31509
interpreted = N
texte = So what you are saying is improper syntax should be discarded and the rest of the script should parse normally? Why? Nothing else in WebDNA acts that way! Why make a special exception?Restoring from a backup runs a 50/50 chance that you are going to lose data depending on how often the DB collects data. No good..Jereme> >Now because I managed to type SKU instead of eqSKUdatarq, that part> >of the query is ignored and everything that is TYPE=ARCHIVE gets it's> >STATUS set to CARROT.. Shouldn't the query fail instead so you don't> >hose your entire DB?>>No way!>>Just because you failed to use the proper webdna syntax and screwed>up your database is no reason for webcat to have its default behavior>changed. WebCat is properly using every valid parameter you gave it,>exactly like it should -- and just like it always has. It should be>a simple task for you to fix your webdna code, them manually replace>your ruined db file with your backup copy.--Jereme Claussen jeremec@darkhorse.comWeb Developer Dark Horse Comics503.652.8815.330 http://www.dhorse.com/I mustn't fear.. Fear is the mime killer..#############################################################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:
So what you are saying is improper syntax should be discarded and the rest of the script should parse normally? Why? Nothing else in WebDNA acts that way! Why make a special exception?Restoring from a backup runs a 50/50 chance that you are going to lose data depending on how often the DB collects data. No good..Jereme> >Now because I managed to type SKU instead of eqSKUdatarq, that part> >of the query is ignored and everything that is TYPE=ARCHIVE gets it's> >STATUS set to CARROT.. Shouldn't the query fail instead so you don't> >hose your entire DB?>>No way!>>Just because you failed to use the proper webdna syntax and screwed>up your database is no reason for webcat to have its default behavior>changed. WebCat is properly using every valid parameter you gave it,>exactly like it should -- and just like it always has. It should be>a simple task for you to fix your webdna code, them manually replace>your ruined db file with your backup copy.--Jereme Claussen jeremec@darkhorse.comWeb Developer Dark Horse Comics503.652.8815.330 http://www.dhorse.com/I mustn't fear.. Fear is the mime killer..#############################################################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
Jereme Claussen
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:
Sendmail truncation in Eudora Clients (1998)
Emailer again (1997)
Adding multiple items to cart with one click? (2000)
2.1b3 --> way slow (1997)
Alternating BGColors in Table Rows (1998)
F3 crashing server (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Using Plug-In while running 1.6.1 (1997)
I'm new be kind (1997)
Using files in an Email broadcast (1999)
Formating found categories (1997)
Help formatting search results w/ table (1997)
[OrderFile] error (help) (1999)
PCS Customer submissions ? (1997)
2nd WebCatalog2 Feature Request (1996)
Quick Question About Sorting (1997)
RE: Adding headers to email (1997)
Catalog Design (1999)
WebCat2 - storing unformatted date data? (1997)
SMSI, your store.smithmicro.com FTP server is down .. (2004)