Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
i am trying to get records from Orders.ShipVia (Northwind database). i have a query in access that does exactly what i need, it returns the name of the shipper. in my aspx page, the exact same sql statement returns the shipper ID number instead of the name. any ideas on why its doing this? in the database you choose which shipper you want for an order from a dropdownbox, i assume it has something to do with this.
thanks in advance
Here is the entire sql statement:
SELECT Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, [Order Details].Quantity, [Order Details].UnitPrice, [Order Details].Discount, CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100 AS Revenue FROM Products INNER JOIN (Customers INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID=[Order Details].OrderID) ON Customers.CustomerID=Orders.CustomerID) ON Products.ProductID=[Order Details].ProductID WHERE (((Customers.CompanyName)=@strCustomers) AND ((Products.ProductName)=@strProducts))