Re: Forms to db's and back (was Re: Displaying text and

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 61263
interpreted = N
texte = Bill,Can you elaborate on your grooming technique a little bit? Not sure I understand what you mean about holding meta data or how you use it.Thanks,TerryAt 2:00 AM -0800 2/28/05, devaulw@onebox.com wrote:>>I have implemented a practice where I look at all user data, check >itwith a function, and return it to the user for checking if there >areerrors. It gets parked in a table in revised or accepted form >before Ireturn it to the user with errors or store it in the >database.>>Basically it goes:>1. Set up a table with meta data about the on page variables >(maxlength, accept if empty, characters?).>2. If no user input, use meta data to create the form.>3. If any user input, groom it with functions while storing errors >andrevised data (trim data for length, date format, illegal >characters) ina table.>4. If errors, return revised data from the table to the user >forcorrection, else accept the data and notify user.>>This means I am unlikely to populate a form field from a form >variableever because everything will come from the table after >having beengroomed.>>I've got something that has been slightly factored and clean that I >canroll up into a tool to show some code on this.-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Bill,Can you elaborate on your grooming technique a little bit? Not sure I understand what you mean about holding meta data or how you use it.Thanks,TerryAt 2:00 AM -0800 2/28/05, devaulw@onebox.com wrote:>>I have implemented a practice where I look at all user data, check >itwith a function, and return it to the user for checking if there >areerrors. It gets parked in a table in revised or accepted form >before Ireturn it to the user with errors or store it in the >database.>>Basically it goes:>1. Set up a table with meta data about the on page variables >(maxlength, accept if empty, characters?).>2. If no user input, use meta data to create the form.>3. If any user input, groom it with functions while storing errors >andrevised data (trim data for length, date format, illegal >characters) ina table.>4. If errors, return revised data from the table to the user >forcorrection, else accept the data and notify user.>>This means I am unlikely to populate a form field from a form >variableever because everything will come from the table after >having beengroomed.>>I've got something that has been slightly factored and clean that I >canroll up into a tool to show some code on this.-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/ Terry Wilson

DOWNLOAD WEBDNA NOW!

Re: Forms to db's and back (was Re: Displaying text and

2005

Top Articles:

Related Readings: