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:
Generating unique SKU from [cart] - FIXED! (1997)
path hierarchy notation (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Nested search (1997)
[WebDNA] WebDNA 8.6 announced - New features (2018)
Re[3]: Problem with new formvariables (2000)
Just Testing (1997)
[WebDNA] WebDNA install on Redhat 4 64 bit? (2008)
[/application] error? (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Running 2 two WebCatalog.acgi's (1996)
help wanted, still (1999)
WCS Newbie question (1997)
RE: creating writefile data from a nested search (1997)
Fun with Dates - any progress? (1997)
mapping fields between databases (2001)
More on the email templates (1997)
Gettting IPAddress (2001)
embedding [showcart] ??? (1998)
SiteEdit NewFile.html ? (1997)