>I'm writing an .asp application using VFP tables. One table has a field "Price" which is defined as N(10,2). When the records are selected and displayed via
>
>response.write(oDatarecord("Price"))
>
>the result does not include the zero value decimals. Thus 1.00 becomes 1 and 1.20 becomes 1.2. So my question is:
>
>Is there a function similar to VFP's transform or padr that would force the zero decimals to display? I apologize if this is too far off topic for this list but I don't know where else to turn.
>
>Thanks
If I recall correctly, you may want to use FORMAT function to display record in the correct format.
A while ago I used tek-tips.com forum for ASP questions.
If it's not broken, fix it until it is.
My Blog