Skip to main content
J
johnsqftwr
Known Participant
March 10, 2010
Question

Decimal Point Problem

  • March 10, 2010
  • 1 reply
  • 322 views

Hi All,

Dreamweaver CS4

Microsoft Access

ASP/Vb

I have a number field in a database formatted as Double, fixed and 1 decimal place.

Adding a record via an ASP page accepts the input correctly ie 6.2

Updating the record via another ASP page returns 62 when 6.2 is entered

The paramater for the field is:

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 5, 1, -1, MM_IIF(Request.Form("HomeOvers"), Request.Form("HomeOvers"), null)) ' adDouble

Many thanks

This topic has been closed for replies.

1 reply

J
johnsqftwrAuthor
Known Participant
March 11, 2010

Hi All,

Problem now resolved. Converted the field in the database from number to text and both the add record and update record behaviours work.

Then able to convert back to number for calculations etc.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices