database result page

[karenblack]

I have a website that shows the books I have available for sale online. My
problem is that it will not show the price in the correct format. How can I
fix that?

 

[Kathleen Anderson]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[karenblack]

I tried that and I am not very good at SQL statements and it keeps rejecting
it. Do I have to change the wording or add a parameter?

 

[karenblack]

I was nor clear, I already have an SQL statement for it to show the columns
I want, and it will not let me add this statement to it.

 

[Kathleen Anderson]

Find the SQL in the gray-colored code and make your change there. Save the
changes while still in HTML/Code view. You will notice that once you've
saved your changes they are also made to the maroon colored code - that is
by design. The maroon colored code should never be touched; it's generated
by the gray code at save time.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Armando Méndez]

Select the database field from your database section ( i.e. <<price>> ),
open the code panel, delete the entire gray line ( i.e. <!--webbot
bot="Databas... ) , type the following code

<%=FormatNumber(FP_FieldVal(fp_rs,"price"),2)%>

http://amendez.interlinea.com.mx/archivos/FormatearCadenasASP.pdf

Good luck