Welcome to Dream.In.Code
Getting Help is Easy!

Join 109,585 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,528 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



ASP Error 80020009

 
Reply to this topicStart new topic

ASP Error 80020009, Error processing the page

dallasmcintosh
post 29 Apr, 2008 - 02:23 PM
Post #1


New D.I.C Head

*
Joined: 29 Apr, 2008
Posts: 3


My Contributions


Hi,

I am recently getting an error on my page when processing an order.

The error reads:

error '80020009'

folder/file.asp, line 100

The code is listed below, with line 100 being 6 rows down Response.Write "<tr><td colspan=3><hr></td></tr>". Can anyone help why it wouldn't let me process the asp. I have included the information which I believe is the culprit.

Thanks


CODE


'Output The Order    
Response.Write "<table border='0' cellspacing='0' cellpadding='0' align='center' width='514px' class='columns'>"
Response.Write "<div align=center>"
Response.Write "<tr class=column><td colspan=3><h4>Your Receipt</h4><br></td></tr>"
Response.Write "<tr class=column><td colspan=3><span class=subhead><cfoutput><em>" & ErrorMsg & "</em></cfoutput></span></td></tr>"
Response.Write "<tr><td colspan=3><hr></td></tr>"
Response.Write "<tr><td colspan=3><strong>Order No: </strong>" & objRS("orderid") & "</td></tr>"
Response.Write "<tr><td colspan=3><strong>Order Paid: </strong>" & objRS("orderpaiddate") & "</td></tr>"
Response.Write "<tr><td colspan=3><strong>Order Confirmation: </strong>" & objRS("ordertx") & "</td></tr>"
Response.Write "<tr><td colspan=3><strong>Price: </strong>" & objRS("orderprice") & "</td></tr>"
Response.Write "<tr><td colspan=3><strong>Freight: </strong>" & objRS("orderfreight") & "</td></tr>"
Response.Write "<tr><td colspan=3><hr></td></tr>"    
Response.Write "<tr><td>Item</td><td align=center>Qty</td><td align='right'>Price</td></tr>"
Response.Write "<tr><td colspan=3><hr></td></tr>"

'Response.Write "Order ID=" & objRS("orderid")
'Response.Write ", CustomerID=" & objRS("custid")
'Response.Write ", Placed=" & objRS("orderplaceddate")
'Response.Write ", Paid=" & objRS("orderpaiddate")
'Response.Write ", Price=" & objRS("orderprice")
'Response.Write ", Freight=" & objRS("orderfreight")
'Response.Write ", TXRecord=" & objRS("ordertx")

Do Until objRS.EOF = True
Response.Write "<tr>"
Response.Write "<td>" & objRS("itemname") & " " & objRS("itemcode") & "</td>"
Response.Write "<td height=18 align=center>" & objRS("quantity") & "</td>"
Response.Write "<td align=right>" & objRS("itemprice") & "</td>"
Response.Write "</tr>"
'Move to the next record (important!!)
objRS.MoveNext
Loop
Response.Write "<tr><td colspan=3><hr></td></tr>"
Response.Write "</table>"
'Close the Recordset object
objRS.Close

'Delete the Recordset Object
Set objRS = Nothing

'Close the Connection object
objConn.Close

'Delete the Connection Object
Set objConn = Nothing
Set eWay = Nothing

Else
Response.Write "<p align=center>Error! There is a problem with the information submitted</p>"
Response.Write "<div align=center><input type=button value='Please Try Again' onClick='history.go(-1)'></div>"
End if

Else
Response.Write "<Font color=red><B>ERROR:</B></FONT>" & eWay.ErrorMessage & "<BR>"
End if

User is offlineProfile CardPM

Go to the top of the page


PsychoCoder
post 30 Apr, 2008 - 05:47 PM
Post #2


DIC.Rules == true;

Group Icon
Joined: 26 Jul, 2007
Posts: 7,249



Thanked 52 times

Dream Kudos: 7775

Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, GDI, Boo.Net

My Contributions


That isn't actually where the error is occurring. Show the code you're using to connect to your database and query it to get your data back please.
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 9/8/08 12:44AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month