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