Multiple-step OLE DB operation generated errors
HejJeg er lige pludselig begyndt at få fejl på en af mine sider, når jeg vil læse data fra en mysql tabel:
Provider error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/Fakturaer.asp, line 40
Og her er koden:
<!-- #Include file="sikkerhed.asp" -->
<!-- #Include file="dbconn.asp" -->
<div align="center">
<form method="POST" action="?SubMenu=Faktura&Side=faktura_sog">
Faktura nr.: <input type="text" name="BillID" size="20">
Projekt nr.: <input type="text" name="ProjectID" size="20">
<input type="submit" value="Søg" name="B1">
</form>
<br>
<table border="0" width="710" id="table2">
<tr>
<td class="list_header" width="93">Faktura nr.:</td>
<td class="list_header" width="125">Oprettet den:</td>
<td class="list_header" width="128">Betales den:</td>
<td class="list_header" width="79">Oprettet af:</td>
<td class="list_header" width="163">Antal kr.
(eks.. moms):</td>
<td class="list_header" width="96">Status:</td>
</tr>
<%
BillID = Request.querystring("FakturaID")
ProjectID = Request.querystring("ProjectID")
if BillID > "" then
Set Rs = Conn.Execute("SELECT * FROM man_bills WHERE id = '"& BillID & "' ORDER by paydate desc")
else
if ProjectID > "" then
Set Rs = Conn.Execute("SELECT * FROM man_bills WHERE projectid = '"& ProjectID &"' ORDER by paydate desc")
else
Set Rs = Conn.Execute("SELECT * FROM man_bills ORDER by paydate desc")
end if
end if
response.write sql
Do While Not rs.EOF
BillID = rs("id")
strDate = rs("date")
PayDate = rs("paydate")
strEmploye = rs("employe")
IntSize = rs("size")
Finish = rs("finish")
CostumerID = rs("costumerid")
%>
<%if finish = 1 then%>
<tr onmouseover="this.style.background='#FFC06F'" onmouseout="this.style.background=''" onclick="window.open('fakturaer/<%=BillID%>.pdf','Faktura','location=no,menubar=no,statusbar=no,directories=no,width=770,height=700'); return false;">
<%else%>
<tr onmouseover="this.style.background='#FFC06F'" onmouseout="this.style.background=''" onclick="window.open('ny_faktura_blank.asp?KundeID=<%=CostumerID%>&BillID=<%=BillID%>&Created=True','Faktura','location=no,menubar=no,statusbar=no,directories=no,width=770,height=700'); return false;">
<%end if%>
<td class="list_content" width="93"><%=BillID%></td>
<td class="list_content" width="125"><%=strDate%></td>
<td class="list_content" width="128"><%=PayDate%></td>
<td class="list_content" width="79"><%=strEmploye%></td>
<td class="list_content" width="163"><%=IntSize%></td>
<td class="list_content" width="96"><%if Finish = "1" then response.write "Afsluttet" Else Response.write "Igangværende" end if%></td>
</tr>
<%
RS.MoveNext
Loop
Rs.Close
Set Rs = Nothing
%>
</table></div>
Linie 40 ser således ud: IntSize = rs("size")
Nogen der kan se en fejl?
