Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Re: Microsoft JET Database Engine (0x80040E14)


Message #1 by "Shawn Clabough" <shawnc@u...> on Sat, 1 Jun 2002 00:23:16
You're missing some spaces in your statement.  
           & "and itemsOrdered.orderID = " & intOrderID _
  & " and itemsOrdered.productName = " & strprodName _
  & " and itemsOrdered.productPrice = " & intprodPrice		

> Soort fout:
> Microsoft JET Database Engine (0x80040E14)
> Syntaxisfout (operator ontbreekt) in query-expressie products.productID 
= 
> itemsOrdered.productID and itemsOrdered.orderID = 20and 
> itemsOrdered.productName = and itemsOrdered.productPrice =.
> /mcartpal/reviewOrder.asp, line 105

>  sqlText = "select products.productID, productName, " _
>            & "productPrice, quantity from products, " _
>            & "itemsOrdered where " _
>            & "products.productID = itemsOrdered.productID "_
>            & "and itemsOrdered.orderID = " & intOrderID _
>   & "and itemsOrdered.productName = " & strprodName _
>   & "and itemsOrdered.productPrice = " & intprodPrice		
> %>
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 3 Jun 2002 12:14:35 +1000
This is a multi-part message in MIME format.

------=_NextPart_000_0117_01C20AF8.39C51660
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Vivian eersels" <vivian.eersels@w...>
Subject: [access_asp] Microsoft JET Database Engine (0x80040E14)


: Soort fout:
: Microsoft JET Database Engine (0x80040E14)
: Syntaxisfout (operator ontbreekt) in query-expressie 
products.productID =3D
: itemsOrdered.productID and itemsOrdered.orderID =3D 20and
------------------------------------------------------^

You need a space between "20" and "and"

Cheers
Ken



  Return to Index