Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
Password Reminder
Register
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 .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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







Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.