Validation errors (CSS Form Builder)
I'm trying to validate a form to prevent SQL injections, so I'm using validation.
I built this form using Dreamweaver's Record Insertion Form Wizard, and then applied FB's client and server validation (Insert bar: WebAssist/Client Validation - and Server Validation) after that.
I need to allow spaces in a number of alphanumeric fields, together with some limited punctuation "',.()" (double quotes show the limits of what I want to allow).
However, it's not allowing users to enter spaces in the First and Last Name fields. Furthermore, entering punctuation in the "Church/Choir/School" field seems to reset the form without allowing the user to go to the next page (and no data is inserted into the database).
I'd be grateful for some help. This has taken up a lot of time so far.
It would be really helpful to have documentation explaining precisely what each bit of code does (both the PHP code at the beginning of the document and the <form onSubmit ...>) as what I see there doesn't seem to match up with what I entered in the WA dialogue boxes. (For example, even if I create validation to disallow upper-case and lower-case letters, the code doesn't seem to be any different to if they are allowed. Perhaps I'm looking in the wrong place, but it's impossible to tell.)
The page is Valid HTML (XHTML Transitional)
Dreamweaver CS4 / WinXP SP3
Many WebAssist extensions, including:
CSS FormBuilder 1.0.0
Validation Toolkit 2.3.5 (now removed from Extension manager)