error 80020009

 

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
%>