Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old 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
Default 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







  #2 (permalink)  
Old May 13th, 2005, 05:53 PM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

;;;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.
Use percentages on your tables

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


Wind is your friend
Matt
  #3 (permalink)  
Old 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
Default

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

_________________________
- Vijay G
Strive for Perfection
  #4 (permalink)  
Old 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
Default

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


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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.