not accepting numeric data
Despite trying everything I cannot get the data assist generated to allow values to be entered into any of the data entry.
C Pm
Despite trying everything I cannot get the data assist generated to allow values to be entered into any of the data entry.
C Pm
Your <input type="text" form elements have min="15" properties. Text elements with min settings consider that value as a minimum character length. If you change them to <input type="number" it will treat that as a minimum number value. I believe that is the issue you are running into.
changed as suggested that appears to work issue I have now is I get mysql error
There is an error in your SQL syntax.
on insert /update when ever a duplicate entry is encountered, how does dataassist/mysqli handle duplicates and what code do I need to insert so as the program continues
primary index is on dbmDisplaySiteID and dbmDisplayScreenID
How would you like to handle duplicated keys? I'll help you get it working how you want it to. Currently it shows an error when any database insert/update fails for any reason.
Combined Key? Do you want it to insert the rest of them and just skip the repeats or not do any updates at all in that case?
The best option is probably to create a recordset and filter it with the submitted keys. Then use server validation to validate the number of rows returned. If a the total number of rows is not zero, then the keys exist, so you could use number validation to make sure the number of rows returned is zero.
You can add a recordset and add a where clause to filter it with the submitted form values. That is the first step. Are you able to do that? I don't have a tutorial, so you would have to give it a try and see if you can do it and ask specific questions when you run into them.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.