close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dropping Data???

Thread began 6/28/2011 11:18 am by Justin@AdventDesign | Last modified 7/21/2011 11:02 am by Ray Borduin | 1089 views | 6 replies |

Justin@AdventDesign

Dropping Data???

I'm completely confused over this one.

I've been using web assist data assist for many years on many, many projects and I've NEVER run into anything like this.

Developed a product database for a client. Fully tested the online data assist forms and everything worked fine. Had the client upload their data. After many hours of uploading, the client discovered much of the data they input was not retained. The individual records were there, but the information within was not.

I have fully tested and retested on my system (Mac using FireFox 5 browser) and cannot duplicate their issue. Everything seems to work perfectly fine for me. They are on an older PC using IE (can't seem to tell me the version). Could that be an issue? I know there are display issues with older browsers but I've never run into form issues in which everything appears to function properly but data is just lost.

Suggestions for troubleshooting??? Please Help!

Sign in to reply to this post

Jason ByrnesWebAssist

double check that the form elements in the page are all configured correctly with a value attribute, even if the value is blank:

<input type="text" name="first_name" value="" >

I have seen some older versions of IE have issues passing form data with fields that did not include the value attribute.


make sure your client is actually clicking the forms submit button with the mouse rather than hitting the enter key to submit the form.

have them try the form with Fire fox instead of IE to see if the problem persists.

Sign in to reply to this post

Justin@AdventDesign

Thanks Jason. I'll give that a shot.

Sign in to reply to this post

Justin@AdventDesign

One other quick question that may have something to do with this, should the MySQL field default be set to "Null" as a general rule?

Sign in to reply to this post

Jason ByrnesWebAssist

there is not a general rule for this, there are really many different factors to take into account.

I guess the closest to a _general_ rule for a default value of null would be this:

Use NULL For the default value on a column that Does NOT allow blank, but you do not require in your form.

Sign in to reply to this post

Justin@AdventDesign

Problem Solved

Well, after a long delay due to the client being out of town and then too busy to deal with it, I've finally found the problem, after a trip to the clients to watch over their shoulder what they were doing. Apparently, in the fields meant for pricing (i.e. "3.25") they were trying to also insert text (i.e. "$3.25/ft"). The MySQL field was set to accept a decimal number, and would reject their entry, leaving the field with 0.00!

So after hours of pulling my hair out, it came down to a usability issue, not a technical problem!

Sign in to reply to this post

Ray BorduinWebAssist

You could add spry validation or server validation to give an error message in that case to make sure that the user is able to identify the problem more easily. Thank you for the update.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...