Hi, This is not good for human eyes :( Why don't you print it in the page, copy and paste to an SQL console, Access query window or whatever you have there, execute and see what field name is actually wrong?
Michael -----Original Message----- From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 9:12 PM To: ActiveServerPages Subject: No value given for one or more required parameters. Hi Guys, Can I have another set of eyes look at this code? The error I am getting is as follows: Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. /Reports/pending2.asp, line 69 I think I understand the error but for the life of me I can't seem to see it on my code. sql ="SELECT Orders.Order_ID AS Orders_Order_ID, "_ & " Orders.ShipFirstName, "_ & " Orders.ShipMiddleInitial, "_ & " Orders.ShipLastName, "_ & " Orders.ShipCompany, "_ & " Orders.ShipAddress1, "_ & " Orders.ShipAddress2, "_ & " Orders.ShipCity, "_ & " Orders.ShipState, "_ & " Orders.ShipCounty, "_ & " Orders.ShipZip, "_ & " Orders.ShipPhone, "_ & " Orders.Message, "_ & " Orders.SameAsUserInfo, "_ & " Orders.FirstName, "_ & " Orders.MiddleInitial, "_ & " Orders.LastName, "_ & " Orders.Company, "_ & " Orders.Address1, "_ & " Orders.Address2, "_ & " Orders.City, "_ & " Orders.State, "_ & " Orders.County, "_ & " Orders.Zip, "_ & " Orders.Phone, "_ & " Payments.Order_ID AS Payments_Order_ID, "_ & " Payments.PaymentAmount, " _ & " Payments.PaymentDate, " _ & " Payments.CreditCardNumber, "_ & " Payments.PaymentMethod_ID, "_ & " Payments.CreditCardExpDate, "_ & " OrderDetails.Order_ID AS OrderDetails_Order_ID, "_ & " OrderDetails.Product_ID, "_ & " OrderDetails.Qty, "_ & " OrderDetails.Price, "_ & " OrderDetails.ProductTitle, "_ & " OrderDetails.PartNumber, "_ & " OrderDetails.ExtPrice "_ & " FROM (Orders INNER JOIN OrderDetails ON Orders.Order_ID = OrderDetails.Order_ID) "_ & " INNER JOIN Payments ON Orders.Order_ID = Payments.Order_ID " _ & " WHERE Payments.CreditCardExpDate <> 'processed' "_ & " AND Payments.PaymentDate >= # " & FromDate & "# AND Payments.Payment_ID <= #" & ToDate & "# ORDER By Orders.Order_ID" response.write sql set rs = conn.execute(sql) sql prints out: SELECT Orders.Order_ID AS Orders_Order_ID, Orders.ShipFirstName, Orders.ShipMiddleInitial, Orders.ShipLastName, Orders.ShipCompany, Orders.ShipAddress1, Orders.ShipAddress2, Orders.ShipCity, Orders.ShipState, Orders.ShipCounty, Orders.ShipZip, Orders.ShipPhone, Orders.Message, Orders.SameAsUserInfo, Orders.FirstName, Orders.MiddleInitial, Orders.LastName, Orders.Company, Orders.Address1, Orders.Address2, Orders.City, Orders.State, Orders.County, Orders.Zip, Orders.Phone, Payments.Order_ID AS Payments_Order_ID, Payments.PaymentAmount, Payments.PaymentDate, Payments.CreditCardNumber, Payments.PaymentMethod_ID, Payments.CreditCardExpDate, OrderDetails.Order_ID AS OrderDetails_Order_ID, OrderDetails.Product_ID, OrderDetails.Qty, OrderDetails.Price, OrderDetails.ProductTitle, OrderDetails.PartNumber, OrderDetails.ExtPrice FROM (Orders INNER JOIN OrderDetails ON Orders.Order_ID = OrderDetails.Order_ID) INNER JOIN Payments ON Orders.Order_ID = Payments.Order_ID WHERE Payments.CreditCardExpDate <> 'processed' AND Payments.PaymentDate >= # 8/1/2002# AND Payments.Payment_ID <= #8/9/2002# ORDER By Orders.Order_ID Thanks in advance! --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
