|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
database result pageI 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?
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency
--
Show quote
Hide quote
~ 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" <karenbl***@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? > 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? Show quoteHide quote "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" <karenbl***@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? > > > > > 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. Show quoteHide quote "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" <karenbl***@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? > > > > > 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. -- Show quoteHide quote~ 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" <karenbl***@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" <karenbl***@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? >> > >> >> >> 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 Show quoteHide quote "karenblack" <karenbl***@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? >  
Other interesting topics
widescreen monitors
Import data from Excel or Access to a textbox in a webpage Assign value to database while using DBW Include Page difference in 2002 and 2003 Running an EXE file outside of MSIE? Slide Show on Web Page created with Front Page Drop-Down Box Options Line Spacing Unable to publish site changes?? URL address has % and numbers in it why and how do I fix this? How do I get FP 2003 to display a PHP page? |
|||||||||||||||||||||||
