Microsoft JET Database Engine (0x80004005) error 
Author Message
 Microsoft JET Database Engine (0x80004005) error

Microsoft JET Database Engine (0x80004005)
Het opgegeven veld product kan naar meer dan een tabel verwijzen in de
component FROM van uw SQL-instructie.
/mcartpal/reviewOrder.asp, line 105

Mijn code:

         <%
    set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open ConString

    if cstr(Session("orderID")) = "" then
        Response.Write "<div align='center'>"
        Response.Write "<p><font face='Verdana' size='4'><b>"
        Response.Write "U heeft nog niets besteld." & "<br>"
        Response.Write "Indien u eerder produkten in uw wagentje zette, "
        Response.Write "heeft uw sessie een time-out.<br><br>"
        Response.Write "<a href='default.asp'>Verder winkelen</a>"
        Response.Write "<b></font></p>"
        Response.Write "</div>"
    else
        intOrderID = cstr(Session("orderID"))

        sqlText = "select products.productID, product, " _
            & "productPrice, quantity from products, " _
            & "itemsOrdered where " _
            & "products.productID = itemsOrdered.productID "_

   & "and itemsOrdered.orderID = " & intOrderID

%>
            <p><font face="Verdana" size="4"><strong>Bekijk
winkelwagentje</strong></font></p>
            <p><font face="Verdana" size="2">Kijk aub uw bestelling na voor
eventuele
              fouten . Om een produkt te verwijderen, zet het aantal op 0 en
klik
              op de Update Bestelling knop.</font></p>
            <form action="checkout1.asp" method="post" id="form1"
name="form1">
              <table border="1" cellpadding="3" cellspacing="3"
width="100%">
                <tr bgcolor="#6699cc">
                  <td width="15%" align="left" valign="center" nowrap><font
color="#ffffff" face="Verdana" size="2" style="BACKGROUND-COLOR:
#6699cc"><strong>Aantal<strong></font></strong></strong></td>
                  <td width="44%" align="left" valign="center" nowrap><font
color="#ffffff" face="Verdana" size="2" style="BACKGROUND-COLOR:
#6699cc"><strong>Produkt<strong></font></strong></strong></td>
                  <td align="left" valign="center"><font color="#ffffff"
face="Verdana" size="2" style="BACKGROUND-COLOR:
#6699cc"><strong>Prijs<strong></font></strong></strong></strong></td>
                </tr>
                <%
set rsReview = Conn.Execute(sqlText) <------------------dit is de bewuste
lijn
while not rsReview.EOF
      intProdID = rsReview("productID")
      strName = rsReview("product")
      intPrice = rsReview("productPrice")
   intQuant = rsReview("quantity")
      intTotal = intTotal + (intQuant * intProdPrice)
%>
                <tr>
                  <td width="15%" valign="center" align="left"><font
face="Verdana" size="2">
                    <input name="quant<%= intProdID %>" size="6" value="
<%=intQuant%>" onSubmit="HandleKeyUp(this)">
                    </font></td>
                  <td width="44%" align="left"><font face="Verdana"
size="2">&nbsp;<%= strProdName %> </font></td>
                  <td align="right"><font face="Verdana" size="2"> &euro;<%=
(intProdPrice) %> </font><font face="Verdana" size="2"> &euro;</font></td>
                </tr>
                <%
rsReview.MoveNext
wend

rsReview.Close
set rsReview = Nothing
%>
                <tr>
                  <td valign="center" align="left"><font face="Verdana"
size="2"><strong>Totaal:<strong></font></strong></strong></td>
                  <td colspan="2" align="right" valign="center"><font
face="Verdana" size="2"><strong>
                    &euro;<%= (intTotal) %>
<strong></font></strong></strong></td>
                </tr>
              </table>
              <p>
                <input type="submit" name="control" value="Update
Bestelling">
                <input type="submit" name="control" value="Ga naar
bestelformulier">
              </p>
            </form>
            <form action="default.asp" method="post" id="formx"
name="formx">
              <input type="submit" name="buttonX" value="Verder winkelen">
            </form>
<%
 end if

    Conn.Close
    set Conn = Nothing
%>
</td>
  </tr>
  </table>

 </td>
  </tr>
  </table>
      <hr color="#cccccc" size="1" noshade>

<!--#include file="footer.asp"-->
</body>
</html>



Sat, 13 Nov 2004 00:45:10 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Microsoft JET Database Engine error '80040e09'

2. Error: 3197 Description: The Microsoft jet database engine ...

3. The Microsoft Jet database engine cannot......

4. Microsoft Jet Database Engine Cannot Open The File.......(access)mdb

5. 3197 Microsoft Jet database engine

6. The Microsoft Jet Database Engine cannot find the input table or query

7. Microsoft Jet Database Engine

8. Microsoft's Jet Database Engine Book

9. The Microsoft Jet database engine cannot open the file

10. Microsoft Jet Database Engine Cannot Open The File.......(access)mdb

11. The Microsoft Jet database engine cannot open the file

12. Microsoft Jet Database Engine cannot open the file

 

 
Powered by phpBB® Forum Software