Re: trouble updating records in database
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19066
interpreted = N
texte = >This is right, but not usable under some circumstances. Most databases are >for client/server and not for web. Take 4D for example: if you flag a field >as unique then an error message will pop up to warn the user. Fine for a >dedicated database client, but if you do not catch this situation in your >web-application, the popup would be shown on the webserver!Not really, it can be handled just like required form fields: you get an error page stating the problem, and the user just has to click the back button and reenter the data. No need to popup anything on the server.>Therefore I agree with Ken - it is more secure when the programmer decides >what is unique and what is not.How about making SKU unique, and if you don't want to make it unigue, don't call it SKU...Charles_______________________________________________________________ Institut Balear de Comunicacions, S.L. Gremio Tejedores 22, 1 07009 Palma de Mallorca, Spain _____________________________________________ Tel: +34 971.43.12.77 Fax: +34 971.43.08.18 E-mail: ckefauver@ibacom.es URL: http://www.ibacom.es/ _____________________________________________ Public PGP signature (Clave publica PGP): http://www.ibacom.es/PGP/kefauver.txt _______________________________________________________________
Associated Messages, from the most recent to the oldest:
>This is right, but not usable under some circumstances. Most databases are >for client/server and not for web. Take 4D for example: if you flag a field >as unique then an error message will pop up to warn the user. Fine for a >dedicated database client, but if you do not catch this situation in your >web-application, the popup would be shown on the webserver!Not really, it can be handled just like required form fields: you get an error page stating the problem, and the user just has to click the back button and reenter the data. No need to popup anything on the server.>Therefore I agree with Ken - it is more secure when the programmer decides >what is unique and what is not.How about making SKU unique, and if you don't want to make it unigue, don't call it SKU...Charles_______________________________________________________________ Institut Balear de Comunicacions, S.L. Gremio Tejedores 22, 1 07009 Palma de Mallorca, Spain _____________________________________________ Tel: +34 971.43.12.77 Fax: +34 971.43.08.18 E-mail: ckefauver@ibacom.es URL: http://www.ibacom.es/ _____________________________________________ Public PGP signature (Clave publica PGP): http://www.ibacom.es/PGP/kefauver.txt _______________________________________________________________
Charles Kefauver
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:
Thanks and Big News!!! (1997)
Running _every_ page through WebCat-error.html (1997)
RE: E-mailer error codes (1997)
Not really WebCat (1997)
Extra carriage returns (1999)
Server Freeze (1998)
WebDNA Solutions ... sorry! (1997)
Online magazine- monthly updates and such (1999)
Calendar Snippet Problems (1998)
Template Encrypt Speed (1998)
how to post without certain data appearing in the html source (2001)
Associative lookup style? (1997)
Mac & Internet Explorer (2000)
PIXO support (1997)
Country & Ship-to address & other fields ? (1997)
Web Catalog not encrypting/decrypting problem (1998)
[TaxableTotal] - not working with AOL and IE (1997)
WC Database Format (1997)
Help name our technology! (1997)
Summary search -- speed (1997)