close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Getting ProductPrice To Accept Decimals In DataAssist

Thread began 1/21/2014 11:42 am by MsEvette | Last modified 1/21/2014 6:19 pm by Jason Byrnes | 556 views | 7 replies |

MsEvette

Getting ProductPrice To Accept Decimals In DataAssist

The issue I'm having is most likely user error, so please have mercy on me as I explain.

I have been searching for the answer to this, but have not found anything that helps me. I would think I should be able to specify decimals when I'm setting up the pages in DataAssist, and I've tried by specifying the min/max characters as well as the min/max number under Validations in the Form Validation and Field Settings while using Currency as the type, but when I try to submit the price in the _insert.php page while in the browser, it tells me I need to "Please enter a value."

However, if I simply put a whole number in, it is accepted and shows 2 decimal places (ex. 59.00) in the results. I need it to show $59.99.

Please steer me in the right direction to solve this.

Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

In the database, make sure the price column is set to use the float data type.

In the Data Assist wizard, set the validation for the price column to use currency, and select the US format:
1,000,000.00

dont set the min or max character/number settings to anything, leave them as is.

if you continue to have a problem, send a copy of the page and a link where i can see the problem happen.

Sign in to reply to this post

MsEvette

In DataAssist, the validation for the price is set to currency; 1,000,000.00

the min/max character/number fields are blank.

I have attached a screen shot of my result.

Not sure how to give you a link since my testing server is local.

Sign in to reply to this post

Jason ByrnesWebAssist

send a copy of the page please.

Sign in to reply to this post

MsEvette

Sorry, see attached.

Sign in to reply to this post

Jason ByrnesWebAssist

the code looks correct, are you sure there is not a leading or trailing space in the entered value?

Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

Sign in to reply to this post

MsEvette

There is no leading or trailing space; I just checked.

Sign in to reply to this post

Jason ByrnesWebAssist

we corrected this by updating the server validation to add a min of 0.01 and max 100000 for the fields that allowed decimals.

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...