practicing safe queries..
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31496
interpreted = N
texte = Is there a chance we can make DB queries fail if they are mistyped? For example:I just get in the office, and haven't had my coffee yet.. I fumble finger out:[REPLACE DB=messages.db&eqTYPEdatarq=ARCHIVE&SKU=89005130]STATUS=CARROT[/REPLAC E]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?Just a thought..Jereme -- Jereme Claussen jeremec@darkhorse.com Web Developer Dark Horse Comics 503.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:
Is there a chance we can make DB queries fail if they are mistyped? For example:I just get in the office, and haven't had my coffee yet.. I fumble finger out:[REPLACE DB=messages.db&eqTYPEdatarq=ARCHIVE&SKU=89005130]STATUS=CARROT[/REPLAC E]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?Just a thought..Jereme -- Jereme Claussen jeremec@darkhorse.com Web Developer Dark Horse Comics 503.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:
webcat- multiple selection in input field (1997)
Update quantity (2000)
Exclamation point (1997)
Parsing overhead for commenting out line endings (2003)
Using Plug-In while running 1.6.1 (1997)
Missing custom convert.db (1998)
PLEASE REMOVE MY EMAIL ADDRESS (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Online reference (1997)
Simple Store (2000)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
Why don't Typhoon & Firesite work together? (and webcat) (1998)
[WebDNA] writing pdfs on the fly (Avery labels #5160) (2010)
Generating Report Totals (1997)
listfiles-looking for slick solution (1997)
Need relative path explanation (1997)
customer info (2001)
Sendmail (1997)
results in a table (2000)
serial number generation (1997)