navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Rounding drw

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Rounding drw 		Page: [1]
 
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		Rounding drw - 3/23/2006 20:41:04   
I have read every post on rounding on this forum and it's just not working for me.

Here is the original snippet:

<%=FP_FieldVal(fp_rs,"AvgOfRating")%>

I tried changing it to:

<%=Round(FP_FieldVal(fp_rs,"fieldname"),2)%>

I get this message from frontpage:
"The contents of a FrontPage component have been modified. These contents will be overwritten when you save this page."

Then the code goes back to exactly the way it was, no changes happen. I am pulling my hair out. Anyone have any suggestions.
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/23/2006 20:55:31   
Yes, Spooky diet ;-)
Check my sig for further details

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/23/2006 21:02:05   
I looked your signature but not seeing any specific rounding info. I'll try again.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/23/2006 21:14:44   
http://www.outfront.net/spooky/adv_drw.htm

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/23/2006 22:05:55   
Thanks did find the information in the link. Put following into the code

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

Still get same message from FrontPage and still does not save information

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/23/2006 22:23:20   
How are you editing and saving the file? If the unneeded info is removed - that message should not occur

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/23/2006 22:38:10   
When I put the code in and I am working in the split screen in FrontPage as soon as go out of the code screen to do anything else that's when the message pops up

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/23/2006 22:52:29   
You may not be removing all of the code?
Dont use split screen and failing that, feel free to post the code here

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/23/2006 23:06:01   
I'm not sure what part you need to see so I'll break down it down

<%
fp_sQry="SELECT * FROM Services_Rating WHERE (ID = ::ID::)"
fp_sDefault="ID="
fp_sNoRecords="No records returned."
fp_sDataConn="PetServiceForm1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=15
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&Type_of_Service=202&Other_Service=202&Contact_Organization=202&Contact_WorkPhone=202&Contact_ZipCode=202&Cities_Serviced=202&AvgOfRating=5&CountOfRating1=3&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

Then this is the field included in the database

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

All I do is paste the new code directly over the old code which is

<%=FP_FieldVal(fp_rs,"AvgOfRating")%>

Does that hope. I am a true novice fumbling my way through.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/24/2006 0:42:06   
No, preferably the whole page code - the issue is the DRW is over writing your code?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/24/2006 18:05:04   
Here goes: 

<html><head>

<meta name="keywords" content="colorado, colorado breeders, breeds, dogs, dog breeders, pet services, groomers, kennel, dog daycare, pet spa">
<meta name="description" content="All About Colorado Breeders">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">

<!-- CHANGE THE NEXT THREE LINES -->

<title>ColoradoBreeders.com is all about quality companions</title>

<!-- CHANGE THE ABOVE THREE LINES -->



<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">


<link rel=StyleSheet href="coolstyle.css" type="text/css" media="screen">




<script language="JavaScript" src="javascripts.js"></script>
<script language="JavaScript" src="pop-closeup.js"></script>




<style fprolloverstyle>A:hover {color: #0000FF; font-style: italic}
</style>




</head>

<BODY BGCOLOR="#6F8C8F" TEXT="#FFFFFF" LINK="#99CCCC" VLINK="#99CCCC" ALINK="#FFFFFF" leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" marginheight="0" marginwidth="0">



<!-- OUTER TABLE-->
<TABLE cellpadding="0" cellspacing="0" border="0" width="100%" height="100%"><tr><td VALIGN="TOP">



<!-- top TABLE-->
<TABLE cellpadding="0" cellspacing="0" border="0" width="100%"><tr><td ALIGN="left" VALIGN="top">



<script language="JavaScript" src="header.js"></script>








<CENTER>
<!-- MAIN TABLE-->
<!-- MAIN TABLE-->
</CENTER>







<p>



<!-- Start of StatCounter Code -->
<script type="text/javascript" language="javascript">
var sc_project=819019; 
var sc_partition=4; 
var sc_security="3f2e3032"; 
var sc_invisible=1; 
</script>

<script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/counter.js"></script><noscript><a href="http://www.statcounter.com/" target="_blank"><img  src="http://c5.statcounter.com/counter.php?sc_project=819019&java=0&security=3f2e3032&invisible=1" alt="free hit counter script" border="0"></a> </noscript>
<!-- End of StatCounter Code -->
</p>
<blockquote>
	<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-columntypes="3,202,202,202,202,202,202,5,3" s-dataconnection="PetServiceForm1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Services_Rating" s-displaycolumns="ID,Other_Service,Type_of_Service,Contact_Organization,Contact_ZipCode,Cities_Serviced,CountOfRating1,AvgOfRating" s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM Services_Rating WHERE (ID =  ::ID::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="ID=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="15" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" b-UseDotNET="FALSE" CurrentExt sa-InputTypes="3" b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes="3" b-WasTableFormat="FALSE" b-ReplaceDatabaseRegion="FALSE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Services_Rating WHERE (ID =  ::ID::)"
fp_sDefault="ID="
fp_sNoRecords="No records returned."
fp_sDataConn="PetServiceForm1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=15
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&Type_of_Service=202&Other_Service=202&Contact_Organization=202&Contact_WorkPhone=202&Contact_ZipCode=202&Cities_Serviced=202&AvgOfRating=5&CountOfRating1=3&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="52356" --><div style="border-style: outset; border-color: #6F8C8F; padding: 5px; background-color: #FFFFFF">
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font color="#587072" size="2">
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="Type_of_Service" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Type_of_Service<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Type_of_Service")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="40187" -->,
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="Other_Service" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Other_Service<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Other_Service")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="38314" --></font></p>
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font size="2" color="#000000"><b>
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="Contact_Organization" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Contact_Organization<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Contact_Organization")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="58571" --></b></font></p>
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font size="2" color="#000000"><b>Phone: </b>
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="Contact_WorkPhone" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Contact_WorkPhone<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Contact_WorkPhone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="45786" --></font></p>
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font color="#000000" size="2"><b>Zip Code:</b>
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="Contact_ZipCode" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Contact_ZipCode<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Contact_ZipCode")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="38871" --></font></p>
		<p style="margin-top: 0; margin-bottom: 0; text-align:left; margin-right:20px">
		<font color="#000000" size="2"><b>Serving:</b>
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="Cities_Serviced" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Cities_Serviced<font size="-1">>></font>" startspan s-ColumnTypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,205,135" --><%=FP_FieldVal(fp_rs,"Cities_Serviced")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="39393" --></font></p>
		<p style="margin-top: 0; margin-bottom: 0; text-align:left; margin-right:20px">
		<font size="2" color="#000000"><b># of Ratings </b>
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="CountOfRating1" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>CountOfRating1<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"CountOfRating1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="41671" --><b>    
		Avg. Rating</b>:
		<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Type_of_Service,Other_Service,Contact_Organization,Contact_WorkPhone,Contact_ZipCode,Cities_Serviced,AvgOfRating,CountOfRating1" s-column="AvgOfRating" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>AvgOfRating<font size="-1">>></font>" startspan s-ColumnTypes="3,202,202,202,202,202,5,3" --><%=FP_FieldVal(fp_rs,"AvgOfRating")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31417" --> 
	out of 5    </font><font color="#0000FF" size="2">
		<a href="showcase.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">
		<font color="#0000FF">
		<a href="showcase.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">
		<font color="#0000FF">Read/Add Reviews</font></a></font></a></font></p></div><hr>
	<p style="text-align: left; margin-right: 20px; margin-top: 0; margin-bottom: 0"> </p>
	<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="15" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/15]</NOBR><BR></td></tr></table>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></blockquote>
</BODY>
</HTML>


< Message edited by Spooky -- 3/27/2006 0:06:21 >

(in reply to Spooky)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/26/2006 23:41:15   
Have you given up on me?

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 0:12:43   
Try this : 

<html><head>

<meta name="keywords" content="colorado, colorado breeders, breeds, dogs, dog breeders, pet services, groomers, kennel, dog daycare, pet spa">
<meta name="description" content="All About Colorado Breeders">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">

<!-- CHANGE THE NEXT THREE LINES -->

<title>ColoradoBreeders.com is all about quality companions</title>

<!-- CHANGE THE ABOVE THREE LINES -->



<%
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">


<link rel=StyleSheet href="coolstyle.css" type="text/css" media="screen">




<script language="JavaScript" src="javascripts.js"></script>
<script language="JavaScript" src="pop-closeup.js"></script>




<style fprolloverstyle>A:hover {color: #0000FF; font-style: italic}
</style>




</head>

<BODY BGCOLOR="#6F8C8F" TEXT="#FFFFFF" LINK="#99CCCC" VLINK="#99CCCC" ALINK="#FFFFFF" leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" marginheight="0" marginwidth="0">



<!-- OUTER TABLE-->
<TABLE cellpadding="0" cellspacing="0" border="0" width="100%" height="100%"><tr><td VALIGN="TOP">



<!-- top TABLE-->
<TABLE cellpadding="0" cellspacing="0" border="0" width="100%"><tr><td ALIGN="left" VALIGN="top">



<script language="JavaScript" src="header.js"></script>








<CENTER>
<!-- MAIN TABLE-->
<!-- MAIN TABLE-->
</CENTER>







<p>



<!-- Start of StatCounter Code -->
<script type="text/javascript" language="javascript">
var sc_project=819019; 
var sc_partition=4; 
var sc_security="3f2e3032"; 
var sc_invisible=1; 
</script>

<script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/counter.js"></script><noscript><a href="http://www.statcounter.com/" target="_blank"><img  src="http://c5.statcounter.com/counter.php?sc_project=819019&java=0&security=3f2e3032&invisible=1" alt="free hit counter script" border="0"></a> </noscript>
<!-- End of StatCounter Code -->
</p>
<blockquote>

<!--#include file="_fpclass/fpdblib.inc"-->

<%
fp_sQry="SELECT * FROM Services_Rating WHERE (ID =  ::ID::)"
fp_sDefault="ID="
fp_sNoRecords="No records returned."
fp_sDataConn="PetServiceForm1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=15
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&Type_of_Service=202&Other_Service=202&Contact_Organization=202&Contact_WorkPhone=202&Contact_ZipCode=202&Cities_Serviced=202&AvgOfRating=5&CountOfRating1=3&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<div style="border-style: outset; border-color: #6F8C8F; padding: 5px; background-color: #FFFFFF">
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font color="#587072" size="2">
		<%=FP_FieldVal(fp_rs,"Type_of_Service")%>,
		<%=FP_FieldVal(fp_rs,"Other_Service")%></font></p>
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font size="2" color="#000000"><b>
		<%=FP_FieldVal(fp_rs,"Contact_Organization")%></b></font></p>
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font size="2" color="#000000"><b>Phone: </b>
		<%=FP_FieldVal(fp_rs,"Contact_WorkPhone")%></font></p>
		<p style="margin-top: 0; margin-bottom: 0; margin-right:20px; text-align:left">
		<font color="#000000" size="2"><b>Zip Code:</b>
		<%=FP_FieldVal(fp_rs,"Contact_ZipCode")%></font></p>
		<p style="margin-top: 0; margin-bottom: 0; text-align:left; margin-right:20px">
		<font color="#000000" size="2"><b>Serving:</b>
		<%=FP_FieldVal(fp_rs,"Cities_Serviced")%></font></p>
		<p style="margin-top: 0; margin-bottom: 0; text-align:left; margin-right:20px">
		<font size="2" color="#000000"><b># of Ratings </b>
		<%=FP_FieldVal(fp_rs,"CountOfRating1")%><b>    
		Avg. Rating</b>:
		<%=FP_FieldVal(fp_rs,"AvgOfRating")%>
	out of 5    </font><font color="#0000FF" size="2">
		<a href="showcase.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">
		<font color="#0000FF">
		<a href="showcase.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">
		<font color="#0000FF">Read/Add Reviews</font></a></font></a></font></p></div><hr>
	<p style="text-align: left; margin-right: 20px; margin-top: 0; margin-bottom: 0"> </p>
	<!--#include file="_fpclass/fpdbrgn2.inc"-->

	</blockquote>
</BODY>
</HTML>


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/27/2006 12:18:57   
Unfortunately, it's still not working.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 12:40:42   
Which part?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/27/2006 12:49:24   
The rounding part.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 14:34:53   
I meant for you to add that part for yourself ;-)

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/27/2006 16:03:54   
I'm sorry, you're dealing with a complete novice here. What do you mean? How do I round? I copied the code you said to try and I don't know what to do after that.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 20:23:46   
Like you had above, find the code for AvgOfRating and change it to :

<%=round(FP_Field(fp_rs,"AvgOfRating"),2)%>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/27/2006 20:52:42   
I tried that. It's the first thing I did (refer to first part of thread). I tried it again and the same thing happened (first part of thread)

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 21:05:30   
It sounds as if you havent replaced your full script with the one I have above?
If its not allowing you to make changes, then the script is not dieted

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/27/2006 21:20:25   
Thank you for your time. Almost there. It rounds records with a value. Those without values get the following:

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: ""]'

/catalog.asp, line 134

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 21:39:21   
Use this code instead :

<% If isNumeric(FP_Field(fp_rs,"AvgOfRating")) then
response.write round(FP_Field(fp_rs,"AvgOfRating"),2)
else
response.write (FP_Field(fp_rs,"AvgOfRating")
end if
%>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/27/2006 21:49:07   
I know you are probably helping God knows how many people, this isn't urgent, urgent. If you need to put this on the backburner, understood. But, when I change the code I get this:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Open the www.coloradobreeders.com home page, and then look for links to the information you want.
Click the Refresh button, or try again later.

Click Search to look for information on the Internet.
You can also see a list of related sites.




HTTP 500 - Internal server error


(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 21:51:07    
<% If isNumeric(FP_Field(fp_rs,"AvgOfRating")) then
response.write round(FP_Field(fp_rs,"AvgOfRating"),2)
else
response.write FP_Field(fp_rs,"AvgOfRating")
end if
%>


Its late :-)
Also - check http://www.frontpagewebmaster.com/m-235653/tm.htm


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/27/2006 22:09:55   
I don't know what happened, I copied the code from your reply. It all works great. Have you ever thought of adding a donation button to the forum for those who are so appreciative of all you do. I would be so happy to support this forum, it has been so helpful.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Rounding drw - 3/27/2006 22:48:10   
There are so many deserving people, I would find it hard to split up. It would be one hell of a party every year though! :)
Stick around, learn, help - its what makes it all work.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to mosomojo)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/31/2006 21:00:08   
All is working well with the rounding, but I have a question regarding the same db results, so I thought it best to stick here with the code you gave me.

Since there is no database results region, how do I split the records into groups, say 10.

(in reply to Spooky)
mosomojo

 

Posts: 24
Joined: 3/12/2006
Status: offline

  		RE: Rounding drw - 3/31/2006 21:45:47   
Never mind, Got it :)

(in reply to mosomojo)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Rounding drw 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.