database result page

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
Fri Nov 02 08:25:08 PDT 2007

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" <karenblack@discussions.microsoft.com> wrote in message
news:C09DF0F0-2498-4BFC-AB31-354B0C4F8F58@microsoft.com...
>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?
>

karenblack
Fri Nov 02 08:44:00 PDT 2007

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?


"Kathleen Anderson" wrote:

> 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" <karenblack@discussions.microsoft.com> wrote in message
> news:C09DF0F0-2498-4BFC-AB31-354B0C4F8F58@microsoft.com...
> >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?
> >
>
>
>

karenblack
Fri Nov 02 09:22:02 PDT 2007


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" wrote:

> 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" <karenblack@discussions.microsoft.com> wrote in message
> news:C09DF0F0-2498-4BFC-AB31-354B0C4F8F58@microsoft.com...
> >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
Fri Nov 02 14:10:26 PDT 2007

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


"karenblack" <karenblack@discussions.microsoft.com> wrote in message
news:E21328F6-2CE6-4E30-9875-68C118B7D72A@microsoft.com...
>
> 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" wrote:
>
>> 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" <karenblack@discussions.microsoft.com> wrote in message
>> news:C09DF0F0-2498-4BFC-AB31-354B0C4F8F58@microsoft.com...
>> >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?
>> >
>>
>>
>>

Armando
Fri Nov 16 08:21:18 PST 2007

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


"karenblack" <karenblack@discussions.microsoft.com> escribió en el mensaje
news:C09DF0F0-2498-4BFC-AB31-354B0C4F8F58@microsoft.com...
>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?
>