Database results

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I have an .asp page that saves records to an Access
database, one of the fields is for currency, the user
enters the number and when I look at the table in access
(data type = currency), it displays $47.20. When I do a
search via another .asp page, the results come back in
number format, not currency (ie. 47.2 instead of $47.20).
Suggestions?
 
This is what the DRW generates for me:
<%=FP_FieldVal(fp_rs,"TotalDue")%>
I have tried:
<%=FormatCurrency[FP_FieldVal(fp_rs,"TotalDue")]%> and
also tried:
<%=FormatCurrency(FP_FieldVal[fp_rs,"TotalDue"])%>
and when I try to save the page I get the pop-up "The
contents of a FrontPage component have been modified.
These contents will be overwritten when you save this
page." Frontpage discards the FormatCurrency part and
puts the original generated result back in. What am I
doing wrong?

-----Original Message-----

<%=FormatCurrency([your input])%>


Daniel said:
I have an .asp page that saves records to an Access
database, one of the fields is for currency, the user
enters the number and when I look at the table in access
(data type = currency), it displays $47.20. When I do a
search via another .asp page, the results come back in
number format, not currency (ie. 47.2 instead of $47.20).
Suggestions?
Click to expand...


.
Click to expand...
 
<%=FormatCurrency(FP_Field(fp_rs,"TotalDue"))%>

To prevent FP from modifying the code, remove the grey coloured code that
surrounds it (just inside that table cell)


Daniel said:
This is what the DRW generates for me:
<%=FP_FieldVal(fp_rs,"TotalDue")%>
I have tried:
<%=FormatCurrency[FP_FieldVal(fp_rs,"TotalDue")]%> and
also tried:
<%=FormatCurrency(FP_FieldVal[fp_rs,"TotalDue"])%>
and when I try to save the page I get the pop-up "The
contents of a FrontPage component have been modified.
These contents will be overwritten when you save this
page." Frontpage discards the FormatCurrency part and
puts the original generated result back in. What am I
doing wrong?

-----Original Message-----

<%=FormatCurrency([your input])%>


Daniel said:
I have an .asp page that saves records to an Access
database, one of the fields is for currency, the user
enters the number and when I look at the table in access
(data type = currency), it displays $47.20. When I do a
search via another .asp page, the results come back in
number format, not currency (ie. 47.2 instead of $47.20).
Suggestions?
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top