Classic ASP Discussion - error 80020009

Print Page | Close Window

error 80020009

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=15650
Printed Date: 30 March 2026 at 7:50am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: error 80020009

Posted By: ub3rl337ch3ch
Subject: error 80020009
Date Posted: 29 June 2005 at 2:37am

error '80020009'

/cranston/homepage.asp, line 1167

The above error message spits at me when i put the following code in. Ive seen something on mskb about text/blob fields being in the wrong order. PrtLogo is bit, Fee and GST are money. I'm using MSSQL (i believe v8.0). I've tried putting PrtLogo before and after Fee, still no joy.

<%
if pascheck = 12 then
sql = "SELECT Fee, GST, PrtLogo FROM CBroker WHERE BrokerOpName='" & Vbrok & "'"
vrec2.open sql, adoCon
if vrec2("PrtLogo") = -1 then
%>
  <p></p>
  <table border="0" width="100%" id="table23">
   <tr>
    <td><font face="Arial" size="2">Broker Fee</font></td>
    <td>
    <input name="BrokFee" size="15" value="<%Response.Write vrec2("Fee")%>" style="float: right; text-align:right"></td>
   </tr>
   <tr>
    <td><font face="Arial" size="2">Broker Fee GST</font></td>
    <td>
    <input name="BrokFeeGST" size="15" value="<%Response.Write vrec2("GST")%>" style="float: right; text-align:right"></td>
   </tr>
  </table>
<%
end if
vrec2.close
end if
%>

Replies:

Posted By: dpyers
Date Posted: 29 June 2005 at 4:46am

aspfaq goes into this error in some detail
http://www.aspfaq.com/search.asp?q=80020009&type=ALL&category=0&numDays=0&order=1 - http://www.aspfaq.com/search.asp?q=80020009&type=ALL&category=0&numDays=0&order=1

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

Lead me not into temptation... I know the short cut, follow me.