Re: trouble updating records in database
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19062
interpreted = N
texte = >>Ken Grome:>>The WebDNA programmer, not the software, should perform a check for the>>existence of the duplicate SKU...>At 10:05 Uhr 24.07.1998, Charles Kefauver wrote:>Sure, but it is more work, and the programmer must remember to do so in>each new proyect. In all other Database systems, when you flag a field as>being unique, the underlying database makes sure it is unique. Every>database I have even seen that uses unique fields (and I have seen many)>does this automatically.This is right, but not usable under some circumstances. Most databases arefor client/server and not for web. Take 4D for example: if you flag a fieldas unique then an error message will pop up to warn the user. Fine for adedicated database client, but if you do not catch this situation in yourweb-application, the popup would be shown on the webserver!Therefore I agree with Ken - it is more secure when the programmer decideswhat is unique and what is not.Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++43-1-8777454 fax ++43-1-8777454-21
Associated Messages, from the most recent to the oldest:
>>Ken Grome:>>The WebDNA programmer, not the software, should perform a check for the>>existence of the duplicate SKU...>At 10:05 Uhr 24.07.1998, Charles Kefauver wrote:>Sure, but it is more work, and the programmer must remember to do so in>each new proyect. In all other Database systems, when you flag a field as>being unique, the underlying database makes sure it is unique. Every>database I have even seen that uses unique fields (and I have seen many)>does this automatically.This is right, but not usable under some circumstances. Most databases arefor client/server and not for web. Take 4D for example: if you flag a fieldas unique then an error message will pop up to warn the user. Fine for adedicated database client, but if you do not catch this situation in yourweb-application, the popup would be shown on the webserver!Therefore I agree with Ken - it is more secure when the programmer decideswhat is unique and what is not.Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
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:
Full text search (1999)
Emailer (WebCat2) (1997)
Some Advise needed (1997)
[searchString] (1997)
Getting total number of items ordered (1997)
New WebDNA server (2007)
[WebDNA] Forum Module Made In WebDNA (2020)
Test (2003)
[Sum] function? (1997)
Online magazine- monthly updates and such (1999)
Pay by Mail (CC, Check, Money Order) (2001)
Developers in Washington State (2004)
E-Mailer (WebCatb15acgiMac) (1997)
Possible Bug in 2.0b15.acgi (1997)
PCS Frames (1997)
More on the email templates (1997)
Whats going on with my SERIAL NUMBER??? (1998)
Country & Ship-to address & other fields ? (1997)
Re:PCS Customer submissions ? (1997)
show all problem (1997)