How should I modify the code below to round off the number
in the field to zero decimal place?

<!--webbot bot="DatabaseResultColumn" startspan
s-
columnnames="CourseTitle,DateFrom,DateTo,TrainerName,Traini
ng Content,Training Material,Training Tools,Course
Delivery,System Response,Overall
Session,Organization,Respondents"
s-column="Training Tools" b-
tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Training
Tools&lt;font size=&quot;-
1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-
1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Training
Tools&lt;font size=&quot;-
1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal
(fp_rs,"Training Tools")%><!--webbot
bot="DatabaseResultColumn" i-
CheckSum="36397" endspan -->


Regards,
JamesA

Re: Rounding off numbers in asp result page. by MD

MD
Thu Oct 16 08:51:50 CDT 2003

Hi James,

Not possible in the webbot parameters.

Modify the code in the DRW instead using formatnumber(myNumber)
--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
----------------------------------------------------------------------------
--------------------
If you think I'm doing a good job, let MS know at mvpga@microsoft.com

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
----------------------------------------------------------------------------
--------------------
If you think I'm doing a good job, let MS know at mvpga@microsoft.com

"jamesa" <jamesa@sabic.com> wrote in message
news:0d5b01c393b3$11eb53d0$a101280a@phx.gbl...
> How should I modify the code below to round off the number
> in the field to zero decimal place?
>
> <!--webbot bot="DatabaseResultColumn" startspan
> s-
> columnnames="CourseTitle,DateFrom,DateTo,TrainerName,Traini
> ng Content,Training Material,Training Tools,Course
> Delivery,System Response,Overall
> Session,Organization,Respondents"
> s-column="Training Tools" b-
> tableformat="TRUE" b-hasHTML="FALSE"
> clientside
> local_preview="&lt;font size=&quot;-
> 1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Training
> Tools&lt;font size=&quot;-
> 1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
> preview="&lt;font size=&quot;-
> 1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Training
> Tools&lt;font size=&quot;-
> 1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal
> (fp_rs,"Training Tools")%><!--webbot
> bot="DatabaseResultColumn" i-
> CheckSum="36397" endspan -->
>
>
> Regards,
> JamesA