H
hrider1
Can anybody tell me why the SQL query work number 1 works until I change it
in number 2 and move it to an ASP Page in FrontPage 2003? If I copy number 1
to a FrontPage 2003 ASP Page it works.
Number 1
SELECT Shipments.Shipper_Reference, Shipments.Consignee_Company,
Shipments.Consignee_Contact, Shipments.Consignee_Address1,
Shipments.Consignee_City, Shipments.Consignee_State,
Shipments.Consignee_PostalCode, Shipments.Consignee_Phone, Shipments.Country,
Shipments.Fuel_Surcharge, Shipments.Total,
Shipments.UserName, Shipments.ShipDate, Shipments.ServicePlaintext,
Packages.Tracking_Number,
Shipments.Business_Unit, Shipments.Shipping_Group
FROM Shipments INNER JOIN
Packages ON Shipments.ShipmentGUID =
Packages.ShipmentGUID
WHERE (Shipments.Business_Unit <> '') AND (Shipments.Shipping_Group <>
'') AND (Shipments.ShipDate BETWEEN CONVERT(DATETIME,
'2006-03-01 00:00:00', 102) AND CONVERT(DATETIME,
'2006-03-21 00:00:00', 102))
ORDER BY Shipments.Shipper_Reference, Shipments.ShipDate,
Shipments.ServicePlaintext
Number 2
SELECT Shipments.Shipper_Reference, Shipments.Consignee_Company,
Shipments.Consignee_Contact, Shipments.Consignee_Address1,
Shipments.Consignee_City, Shipments.Consignee_State,
Shipments.Consignee_PostalCode, Shipments.Consignee_Phone, Shipments.Country,
Shipments.Fuel_Surcharge, Shipments.Total,
Shipments.UserName, Shipments.ShipDate, Shipments.ServicePlaintext,
Packages.Tracking_Number,
Shipments.Business_Unit, Shipments.Shipping_Group
FROM Shipments INNER JOIN
Packages ON Shipments.ShipmentGUID =
Packages.ShipmentGUID
WHERE (Shipments.Business_Unit <> '') AND (Shipments.Shipping_Group <>
'') AND (Shipments.ShipDate BETWEEN CONVERT(DATETIME,
'::TxtStart::', 102) AND CONVERT(DATETIME,
'::TxtEnd::', 102))
ORDER BY Shipments.Shipper_Reference, Shipments.ShipDate,
Shipments.ServicePlaintext
Any Help!
Jim
in number 2 and move it to an ASP Page in FrontPage 2003? If I copy number 1
to a FrontPage 2003 ASP Page it works.
Number 1
SELECT Shipments.Shipper_Reference, Shipments.Consignee_Company,
Shipments.Consignee_Contact, Shipments.Consignee_Address1,
Shipments.Consignee_City, Shipments.Consignee_State,
Shipments.Consignee_PostalCode, Shipments.Consignee_Phone, Shipments.Country,
Shipments.Fuel_Surcharge, Shipments.Total,
Shipments.UserName, Shipments.ShipDate, Shipments.ServicePlaintext,
Packages.Tracking_Number,
Shipments.Business_Unit, Shipments.Shipping_Group
FROM Shipments INNER JOIN
Packages ON Shipments.ShipmentGUID =
Packages.ShipmentGUID
WHERE (Shipments.Business_Unit <> '') AND (Shipments.Shipping_Group <>
'') AND (Shipments.ShipDate BETWEEN CONVERT(DATETIME,
'2006-03-01 00:00:00', 102) AND CONVERT(DATETIME,
'2006-03-21 00:00:00', 102))
ORDER BY Shipments.Shipper_Reference, Shipments.ShipDate,
Shipments.ServicePlaintext
Number 2
SELECT Shipments.Shipper_Reference, Shipments.Consignee_Company,
Shipments.Consignee_Contact, Shipments.Consignee_Address1,
Shipments.Consignee_City, Shipments.Consignee_State,
Shipments.Consignee_PostalCode, Shipments.Consignee_Phone, Shipments.Country,
Shipments.Fuel_Surcharge, Shipments.Total,
Shipments.UserName, Shipments.ShipDate, Shipments.ServicePlaintext,
Packages.Tracking_Number,
Shipments.Business_Unit, Shipments.Shipping_Group
FROM Shipments INNER JOIN
Packages ON Shipments.ShipmentGUID =
Packages.ShipmentGUID
WHERE (Shipments.Business_Unit <> '') AND (Shipments.Shipping_Group <>
'') AND (Shipments.ShipDate BETWEEN CONVERT(DATETIME,
'::TxtStart::', 102) AND CONVERT(DATETIME,
'::TxtEnd::', 102))
ORDER BY Shipments.Shipper_Reference, Shipments.ShipDate,
Shipments.ServicePlaintext
Any Help!
Jim