Wrox Programmer Forums Divided by Zero and Print Landscape
 Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
 Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
 Welcome to the p2p.wrox.com Forums. You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersâ€™ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
May 13th, 2005, 08:25 AM
 Friend of Wrox Join Date: Jun 2003 Location: abu dbabi, , United Arab Emirates. Posts: 518 Thanks: 0 Thanked 0 Times in 0 Posts
Divided by Zero and Print Landscape

I use following coding to calculate the percentage.

IF NOT RS.EOF THEN
do while rs.eof=false

totalBH1 = (totalBH1 + cint(rs("BH")))
Response.Write("<td align=center>" & rs("BH") & "</td>")

total1 = (total1 + cint(rs("total")))
Response.Write("<td align=center>" & rs("total") & "</td>")

rs.movenext
loop

per = (total1/totalBH1)*100 // line 187

end if

"<td align=center>" & per & "%" &"</td>" & _

some time values in totalBH1 is zero it give following error

Error Type:
Microsoft VBScript runtime (0x800A000B)
Division by zero
/tabulation/bmhours/FOWMHR2.asp, line 187

Zero can not be divided to any values. it is infinate value.
how can control this ?
if totalBH1 is ZERO it should display 0% how ?

in the PER field.

2. Secondly problem.

How can print the ASP page invoice in LANDSCAPE and
PORTRAIT ? and should be pring in center alignment.

3. how can set the printer setting in asp page ?

regards.

Mateen

May 13th, 2005, 05:53 PM
Friend of Wrox
 Points: 6,664, Level: 34
 Activity: 0%

Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts

;;;Zero can not be divided to any values. it is infinate value.
how can control this
if totalBH1 > 0 then
per = (total1/totalBH1)*100
else
per = 0
end if

;;;How can print the ASP page invoice in LANDSCAPE and PORTRAIT ? and should be pring in center alignment.

;;;how can set the printer setting in asp page ?
If percentages are used properly, this is not an issue.

Matt
May 13th, 2005, 06:53 PM
 Friend of Wrox Join Date: Jun 2003 Location: Bangalore, KA, India. Posts: 2,480 Thanks: 0 Thanked 1 Time in 1 Post

Yes, Mat is right. Try that, you should be through.

_________________________
- Vijay G
Strive for Perfection
May 14th, 2005, 05:01 AM
 Friend of Wrox Join Date: Jun 2003 Location: abu dbabi, , United Arab Emirates. Posts: 518 Thanks: 0 Thanked 0 Times in 0 Posts

Thanks a lot.

I have also more then one pages invoice.
if I have two page invoice
How I can print first page heading to next page ?
ie.

<table width="85%"...>
<tr bgcolor="">

<th width="120" height="9" bgcolor="#f8f8ff"><span style="font-weight: 400">
<em style="font-style: normal"><strong>
Name</strong></em></span></th>
<th width="80" height="9" bgcolor="#f8f8ff"><span style="font-weight: 400">
<em style="font-style: normal"><strong>
Budgeted MH</strong></em></span></th>
<th width="80" height="9" bgcolor="#f8f8ff"><span style="font-weight: 400">
<em style="font-style: normal"><strong>
....
</tr>
....
asp coding....

...
loop close

</table>

Also print Name and Budgeted MH heading to next page ?

what change in the above loop coding ?

regards.

Mateen

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is OffTrackbacks are Off Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post javascript print in landscape vsr Javascript How-To 0 November 14th, 2007 05:23 PM Print Query in Landscape using VBA RPetto85 Access VBA 2 June 19th, 2007 04:25 AM This forum should be further divided into chapter- aaronlzhao BOOK: ASP.NET Website Programming Problem-Design-Solution 0 February 1st, 2006 03:33 PM How can I print MsChart.object in landscape? all21 Beginning VB 6 0 December 10th, 2003 04:48 AM Command Button to Print in Landscape Orientation brlevy Access 3 June 9th, 2003 11:59 AM

All times are GMT -4. The time now is 09:08 AM.